/// <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()); } }