public int totalpage = 0;
public int pagecurrent = 1;
public int pagesize = 25;
public int rowscount = 0;
string userid, username;
public datatable dt = new datatable();
public string path, userwelcome;
public string opt,cid;
protected void page_load(object sender, eventargs e)
{
if (!ispostback)
{
if (request.params[page] == null || request.params[page].tostring().equals())
pagecurrent = 1;
else
pagecurrent=int.parse(request.params[page].tostring());
this.getpage(out totalpage, out rowscount, pagesize, pagecurrent);
}
}
//调用存储过程的函数
private void getpage(out int totalpage, out int rowscount, int pagesize, int currentpage)
{
sqlparameter[] parameters = {
new sqlparameter(@totalpage, sqldbtype.int,4),
new sqlparameter(@rowscount, sqldbtype.int,4),
new sqlparameter(@pagesize, sqldbtype.int,4),
new sqlparameter(@currentpage, sqldbtype.int,4),
new sqlparameter(@selectfields, sqldbtype.nvarchar,700),
new sqlparameter(@idfield,sqldbtype.nvarchar,50),
new sqlparameter(@orderfield, sqldbtype.nvarchar,200),
new sqlparameter(@ordertype, sqldbtype.nvarchar,2),
new sqlparameter(@tablename, sqldbtype.nvarchar,300),
new sqlparameter(@strwhere, sqldbtype.nvarchar,300),
};
parameters[0].direction = parameterdirection.output;
parameters[1].direction = parameterdirection.output;
parameters[2].value = pagesize;
parameters[3].value = currentpage;
parameters[4].value = a.rlid,a.companyname,a.website,a.isrl,a.ordernum,a.isrl,a.userid;
parameters[5].value = a.rlid;
parameters[6].value = a.isrl asc , a.ordernum ;
parameters[7].value = 1;
parameters[8].value = qiyerenling a;
parameters[9].value = 1=1;//
dataset ds = wm23abc.dbutility.dbhelpersql.runprocedure(getrecordbypage, parameters, dt);
dt = ds.tables[0];
totalpage = int.parse(parameters[0].value.tostring());
rowscount = int.parse(parameters[1].value.tostring());
}