string getpagesize = context.Request.Form["pagesize"];//每页显示的记录数
int pagesize = int.Parse(getpagesize);
string getnum = context.Request.Form["pagenum"];//指定页数,0表示第一页
int getpagenum = int.Parse(getnum);
int pagenum = pagesize * getpagenum;
string sqlText1 = "select count(*)from [tablename] where id is not null";//查看数据表的总记录数
DataTable reader1 = sqlconnect.ExecuteDataTable(sqlText1);
string totalnum = reader1.Rows[0]["Column1"].ToString();
SqlParameter[] paras2 = new SqlParameter[]{
new SqlParameter("@pagesize",pagesize),
new SqlParameter("@pagenum",pagenum),
};
//分页查询
string sqlText2 = "select top " + @pagesize + " * from [tablename] where id not in (select top " + @pagenum + " id from [tablename] order by id desc)order by id desc";
DataTable reader2 = sqlconnect.ExecuteDataTable(sqlText2, paras2);
string check2 = DataTableToJson(reader2);
if (string.IsNullOrWhiteSpace(check2))//判断string是否为空
{
Boolean status = false;
//创建对象
AbnCheckAllActivityModel model = new AbnCheckAllActivityModel
{
Status = status,
Message = "查询结果为空!",
totalnum = totalnum,
};
//对象序列化Json
string strJson = JsonConvert.SerializeObject(model);
context.Response.ContentType = "text/plain";
context.Response.Write(strJson);
}
else
{
Boolean status = true;
//对象
CheckAllActivityModel model = new CheckAllActivityModel
{
Status = status,
Message = "查询成功!",
totalnum = totalnum,
data = check2,
};
//对象序列化Json
string strJson = JsonConvert.SerializeObject(model);
context.Response.ContentType = "text/plain";
context.Response.Write(strJson);
}