/// <summary>
/// 分页查询
/// </summary>
public static List <T> GetPageList <T, TKey>(Expression <Func <T, bool> > whereLambda, Expression <Func <T, int> > orderLambda1, Expression <Func <T, string> > orderLambda2, int pageSize, int pageIndex, out int recordCount, out int pageCount)
where T : class
{
using (AIYunNetContext context = new AIYunNetContext())
{
var result = context.Set <T>()
.Where(whereLambda)
.OrderBy(orderLambda1).OrderByDescending(orderLambda2)
.Skip((pageIndex - 1) * pageSize)
.Take(pageSize).AsQueryable();
recordCount = context.Set <T>().Where(whereLambda).Count();
pageCount = Convert.ToInt32(Math.Ceiling((double)recordCount / pageSize));
return(result.ToList());
}
}
