protected void SetDefaultPageSize(IPagingFilterDto pagingFilterDto) { if (pagingFilterDto.PageSize <= 0) { pagingFilterDto.PageSize = (int)systemConfigService.GetValueNumber(ConstantConfig.SystemConfigName.PageDefaultNumber); } }
private static void InitPagedModel <TModel>(this IQueryable <TModel> query, IPagingFilterDto pagingFilterDto, PagingResultDto <TModel> pagingModel) { pagingModel.RowCount = query.Count(); pagingModel.PageSize = pagingFilterDto.PageSize; pagingModel.CurrentPage = pagingFilterDto.PageNumber; var pageCount = (double)pagingModel.RowCount / pagingModel.PageSize; pagingModel.PageCount = (int)Math.Ceiling(pageCount); IQueryable <TModel> queryResultPage = query .Skip((pagingFilterDto.PageNumber - 1) * pagingFilterDto.PageSize) .Take(pagingFilterDto.PageSize); pagingModel.Items = queryResultPage.ToList(); }
public static PagingResultDto <TModel> PagedQuery <TModel>(this IQueryable <TModel> query, IPagingFilterDto pagingFilterDto) { if (pagingFilterDto.PageNumber <= 0) { pagingFilterDto.PageNumber = 1; } var result = new PagingResultDto <TModel>(); InitPagedModel(query, pagingFilterDto, result); return(result); }
public static PagingResultDto <TModel> PagedQuery <TModel>(this IQueryable <TModel> query, IPagingFilterDto pagingFilterDto) { if (pagingFilterDto.PageNumber <= 0) { pagingFilterDto.PageNumber = 1; } var result = new PagingResultDto <TModel>(); result.RowCount = query.Count(); result.PageSize = pagingFilterDto.PageSize; result.CurrentPage = pagingFilterDto.PageNumber; var pageCount = (double)result.RowCount / result.PageSize; result.PageCount = (int)Math.Ceiling(pageCount); IQueryable <TModel> queryResultPage = query .Skip((pagingFilterDto.PageNumber - 1) * pagingFilterDto.PageSize) .Take(pagingFilterDto.PageSize); result.Items = queryResultPage.ToList(); return(result); }