public List LoadPagerEntities(int pageSize, int pageIndex, out int total,
Func whereLambda, bool isAsc, Func orderByLambda)
{
try
{
using (MyDbContext db = new MyDbContext())
{
var tempData = db.Set().Where(whereLambda);
total = tempData.Count();
//排序获取当前页的数据
if (isAsc)
{
tempData = tempData.OrderBy(orderByLambda).
Skip(pageSize * (pageIndex - 1)).
Take(pageSize).AsQueryable();
}
else
{
tempData = tempData.OrderByDescending(orderByLambda).
Skip(pageSize * (pageIndex - 1)).
Take(pageSize).AsQueryable();
}
return tempData.ToList();
}
}
catch (Exception e)
{
total = 0;
return null;
}
}