感觉挺好用的,下面是主要代码,以我现在开发的项目为例:
#region 分页
/// <summary>
/// 传入当前页码,每页的显示的条数,记录的总数(输出参数),三个参数,返回供应商实体
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagesize"></param>
/// <param name="a"></param>
/// <returns></returns>
public IQueryable<Entity.供应商信息表> Pag(int pageindex, int pagesize,out int a)
{
a = context.TB_CUS_SUPPLIER_INFO.Count();
if (a <= 0 ||pagesize<=0||pageindex<=0) {
return null;
}
var customs = (from custom in context.TB_CUS_SUPPLIER_INFO
orderby custom.SUPP_ID
select custom
).Skip((pageindex - 1) * pagesize).Take(pagesize);
return customs;
}
#endregion