分页

public Pages<Students> GetStudentPage(PageParams pagePar)
{
int size = pagePar.PageSize;
//存储过程名称
string sql = "[dbo].[p_paging]";
//参数
SqlParameter[] sqlPar = {
new SqlParameter("@tableName", pagePar.TableName),
new SqlParameter("@indexCol", pagePar.IndexCol),
new SqlParameter("@pageSize", pagePar.PageSize),
new SqlParameter("@pageIndex", pagePar.PageIndex),
new SqlParameter("@orderCol", pagePar.OrderCol),
new SqlParameter("@where", pagePar.Where),
new SqlParameter("@columns", pagePar.Columns)
};
//获取分页存储过程的数据集
DataSet ds = DbHelperSQL.ExecuteDataset(DbHelperSQL.ConnB2c,CommandType.StoredProcedure,sql,sqlPar);
//分页的数据
DataTable dt = ds.Tables[0];
//总条数
int count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
Pages<Students> pages = new Pages<Students>();
pages.list = JsonConvert.DeserializeObject<List<Students>>(JsonConvert.SerializeObject(dt));
pages.SumCount = count;
pages.SumPage = ((count % size) > 0 ? ((count / size) + 1) : (count / size));
return pages;
}