public List <TEntity> FindList(IQueryable <TEntity> query, DataBase.Pagination pag)
{
pag.Total = query.Count();
string OrderBys = DataBase.OrderByJoin(pag.SortName, pag.SortOrder, false);
query = DynamicQueryableExtensions.OrderBy(query, OrderBys);
query = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize);
return(query.ToList());
}
public List <TEntity> FindList(Expression <Func <TEntity, bool> > pWhere, DataBase.Pagination pag)
{
var query = dbSet.AsNoTracking().Where(pWhere);
pag.Total = query.Count();
string OrderBys = DataBase.OrderByJoin(pag.SortName, pag.SortOrder, false);
query = DynamicQueryableExtensions.OrderBy(query, OrderBys);
query = query.Skip((pag.PageNumber - 1) * pag.PageSize).Take(pag.PageSize);
return(query.ToList());
}
