public IQueryable<T> GetPageEntities<S>(int pageSize, int pageIndex, out int total,
Expression<Func<T, bool>> whereLambda,
Expression<Func<T, S>> orderByLambda,
bool isAsc)
{
total = Db.Set<T>().Where(whereLambda).Count();
if (isAsc)
{
var temp = Db.Set<T>().Where(whereLambda)
.OrderBy<T, S>(orderByLambda)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize).AsQueryable();
return temp;
}
else
{
var temp = Db.Set<T>().Where(whereLambda)
.OrderByDescending<T, S>(orderByLambda)
.Skip(pageSize * (pageIndex - 1))
.Take(pageSize).AsQueryable();
return temp;
}
}
ef_分页查询
最新推荐文章于 2023-09-02 17:14:36 发布