int num1 = int.Parse(pagesize);
int num2 = int.Parse(index);
//num1表示一页显示的个数
int count = num1*num2 - num1;
string sql = "select top "+pagesize+" * from AdminListInf where ID -1 " + str +
" and ID not in(select top "+count.ToString()+" ID from AdminListInf where ID -1 "+str+" order by ID desc) order by ID desc ";
return DbHelperSQL.Query(sql);
int num1 = int.Parse(pagesize);
int num2 = int.Parse(index);
//num1表示一页显示的个数
int count = num1*num2 - num1;
string sql = "select top "+pagesize+" * from AdminListInf where ID <> -1 " + str +
" and ID not in(select top "+count.ToString()+" ID from AdminListInf where ID <> -1 "+str+" order by ID desc) order by ID desc ";
return DbHelperSQL.Query(sql);
posted on
2007-09-26 13:57
小角色
阅读(
147)
评论()
收藏
举报