/// <inheritdoc/> protected override async Task <PaginationResultModel <EventModel> > ProtectedHandleAsync(GetPaginatedQuery request, CancellationToken cancellationToken) { var principal = PrincipalProvider.GetPrincipal(); if (principal == null) { throw new ForbiddenException("Not authenticated"); } Expression <Func <EventEntity, bool> > expression = PredicateBuilder.True <EventEntity>(); if (!principal.IsInRole(RoleType.Administrator)) { expression = expression.And(e => e.UserId == principal.Identity.Name); } int total = await Context.EventRepository.CountAsync(expression, cancellationToken); var query = Context.EventRepository .GetQuery(expression) .OrderByDescending(e => e.CreatedDate) .Skip(request.Page * request.Limit) .Take(request.Limit); var entities = await Context.ToListAsync(query, cancellationToken); var models = entities.Select(e => EventModel.Create(e, Serializer)); return(PaginationResultModel <EventModel> .Create(models, request.Page, request.Limit, total)); }
public async Task <PaginationResultModel> GetByFilter(PaginationParamsModel paginationParams) { PaginationResultModel response = new PaginationResultModel(); string searchString = paginationParams.SearchString; IQueryable <SucceededOperation> operations = _userDbContext.SucceededOperations.Where(operation => operation.AccountId == paginationParams.AccountId); if (!string.IsNullOrEmpty(searchString)) { operations = operations.Where(operation => operation.AccountId.ToString().Contains(searchString) || operation.Id.ToString().Contains(searchString) || operation.Balance.ToString().Contains(searchString) || operation.OperationTime.ToString().Contains(searchString) || operation.TransactionAmount.ToString().Contains(searchString) ); } response.OperationsTotal = await operations.CountAsync(); SortField sortField = paginationParams.SortField; List <SucceededOperation> operationList = await operations .OrderBy(sortField.ToString(), paginationParams.SortDirection .ToString() == "Asc"?false : true) .Skip((paginationParams.PageIndex) * paginationParams.PageSize).Take(paginationParams.PageSize) .ToListAsync(); response.OperationsList = _mapper.Map <List <SucceededOperationModel> >(operationList); return(response); }
public JsonResult GetArticlesList(PaginationModel pageList) { PaginationResultModel <Article> alist = new PaginationResultModel <Article>(); alist = RichArticleService.GetArticleList(pageList); return(Json(alist)); }
public async Task <PaginationResultModel <CategoryModel> > GetWithPaginationAsync(int page = 1, int limit = 5) { var result = new PaginationResultModel <CategoryModel>(); string connectionString = _configuration.GetConnectionString("CoreLearningDB"); using (IDbConnection dapper = new SqlConnection(connectionString)) { string query = "SP_Categories_GetAll_WithPagination"; int skip = (page - 1) * limit; var parameters = new DynamicParameters(); parameters.Add("skip", skip); parameters.Add("take", limit); parameters.Add("total", dbType: DbType.Int32, direction: ParameterDirection.Output); var queryResult = await dapper.QueryAsync <CategoryModel>(query, parameters, commandType : CommandType.StoredProcedure); var total = parameters.Get <int>("total"); result.Data = queryResult.ToList(); result.Page = page; result.Limit = limit; result.Total = total; result.Pages = Convert.ToInt32(Math.Ceiling((decimal)total / limit)); return(result); } }
//后台根据页面类型获取富文本中的 简短介绍 public JsonResult GetRichArticleList(PaginationModel pageList) { PaginationResultModel <SimpleArticle> result = new PaginationResultModel <SimpleArticle>(); result = RichArticleService.GetRichList(pageList); return(Json(result)); }
public PaginationResultModel <SummaryReportDTO> GetDataCollectionCarInfoSummaryReportPagination(ReportConfigurationDTO reportConfiguration) { IQueryable <SummaryReportDTO> collectionCarInfoReport = GetCollectionCarInfoSummaryReport(reportConfiguration); PaginationResultModel <SummaryReportDTO> result = PaginationHelper .GetItemsWithPagination(collectionCarInfoReport, reportConfiguration.PageIndex, reportConfiguration.PageSize); return(result); }
public async Task <PaginationResultDTO> Get([FromQuery] PaginationParamsDTO paginationParamsDTO) { PaginationParamsModel paginationParams = _mapper.Map <PaginationParamsModel>(paginationParamsDTO); PaginationResultModel operationList = await _operationsHistoryService.GetByFilter(paginationParams); PaginationResultDTO paginationResultDTO = _mapper.Map <PaginationResultDTO>(operationList); return(paginationResultDTO); }
public PaginationResultModel <CollectionSheetSearchItemDTO> GetAllWithFillter(SearchCollectionSheetDTO input) { var query = QueryAndApplyFilterSearchCollectionSheet(input); PaginationResultModel <CollectionSheetSearchItemDTO> resultSearch = new PaginationResultModel <CollectionSheetSearchItemDTO>(); var resultPaging = PaginationHelper.GetItemsWithPagination(query, input.PageIndex, input.PageSize); return(TakeIndexForPaging(input, resultPaging)); }
public async Task <PaginationResultModel <ArtistModel> > GetPagedArtistsAsync(PaginationModel pagination, ArtistFilterModel filter = null, IEnumerable <ArtistOrderByModel> orderByList = null, string includes = "", bool tracking = true) { var p = _mapper.Map <Pagination>(pagination); var f = ArtistFilterExpressions(_mapper.Map <ArtistFilter>(filter)); var o = ArtistOrderByList(_mapper.Map <IEnumerable <ArtistOrderBy> >(orderByList)); var a = await _unitOfWork.Artists.GetPagedAsync(p, f, o, includes, tracking); var result = new PaginationResultModel <ArtistModel>(_mapper.Map <PaginationStateModel>(a.PageState), _mapper.Map <IEnumerable <ArtistModel> >(a.Result)); return(result); }
/// <inheritdoc/> protected override async Task <PaginationResultModel <AppLogModel> > ProtectedHandleAsync(GetPaginatedQuery request, CancellationToken cancellationToken) { int total = await appLogRepository.CountAsync(cancellationToken); var result = appLogRepository .GetQuery() .OrderByDescending(e => e.Timestamp) .Skip(request.Page * request.Limit) .Take(request.Limit) .Select(e => AppLogModel.Create(e)); return(PaginationResultModel <AppLogModel> .Create(result, request.Page, request.Limit, total)); }
public PaginationResultModel <InforCustomerSearchItemDTO> GetAllWithFillter(SearchInfoCustomerDTO input) { IQueryable <InfoCustomer> query = _inforCustomerRepository.FindAll(); query = FilterConditionSearchInfoCustomer(query, input); PaginationResultModel <InforCustomerSearchItemDTO> resultSearch = new PaginationResultModel <InforCustomerSearchItemDTO>(); var queryModelDTO = query.ProjectTo <InforCustomerSearchItemDTO>(); var resultPaging = PaginationHelper.GetItemsWithPagination(queryModelDTO, input.PageIndex, input.PageSize); return(resultPaging); }
//后台获取文章类型 public static PaginationResultModel <Article> GetArticleList(PaginationModel pageList) { PaginationResultModel <Article> result = new PaginationResultModel <Article>(); try{ using (CDBContext _cDBContext = new CDBContext()){ List <Article> messages = _cDBContext.Ar.Skip((pageList.Index - 1) * pageList.Size).Take(pageList.Size).ToList(); result.Total = _cDBContext.Ar.Count(); result.status = 1; result.Data = messages; result.message = "获取数据成功!"; } }catch (Exception ex) { result.status = 0; result.Data = null; result.message = ex.ToString(); result.Total = 0; } return(result); }
public static PaginationResultModel <ScrollPicture> GetPicList(PaginationModel pageList) { PaginationResultModel <ScrollPicture> result = new PaginationResultModel <ScrollPicture>(); try{ using (CDBContext _cDBContext = new CDBContext()){ List <ScrollPicture> sps = new List <ScrollPicture>(); sps = _cDBContext.Sc.Skip((pageList.Index - 1) * pageList.Size).Take(pageList.Size).ToList(); result.Total = _cDBContext.Sc.Count(); result.status = 1; result.Data = sps; result.message = "获取轮播图添加成功"; } }catch (Exception ex) { result.status = 0; result.Data = null; result.message = ex.ToString(); result.Total = 0; } return(result); }
// private static CDBContext _cDBContext; // public MailService(CDBContext CDBContext){ // _cDBContext=CDBContext; // } //展示邮件列表 public static PaginationResultModel <Message> GetMailList(PaginationModel pageList) { PaginationResultModel <Message> result = new PaginationResultModel <Message>(); try{ using (CDBContext cb = new CDBContext()){ List <Message> mss = new List <Message>(); mss = cb.Me.Skip((pageList.Index - 1) * pageList.Size).Take(pageList.Size).ToList(); result.Total = cb.Me.Count(); result.status = 1; result.Data = mss; result.message = "获取数据成功!"; } }catch (Exception ex) { result.status = 0; result.Data = null; result.message = ex.ToString(); result.Total = 0; } return(result); }
/// <inheritdoc/> public async Task <PaginationResultModel <ObjectModel> > Handle(GetObjectsQuery request, CancellationToken cancellationToken) { int total = await context.ObjectRepository.CountAsync(cancellationToken); var query = context.ObjectRepository .GetQuery() .Select(e => new { Object = e, Tasks = e.Tasks.OrderByDescending(e1 => e1.CreatedDate).Take(request.Limit), Results = e.Tasks.OrderByDescending(e1 => e1.CreatedDate).Select(e1 => e1.Result).Take(request.Limit) }) .OrderByDescending(e => e.Object.CreatedDate) .Skip((request.Page - 1) * request.Limit) .Take(request.Limit); var entities = await context.ToListAsync(query, cancellationToken); var models = entities.Select(e => ObjectModel.Create(e.Object, e.Tasks, e.Results, serializer)); return(PaginationResultModel <ObjectModel> .Create(models, request.Page, request.Limit, total)); }
public JsonResult ShowMessageList(PaginationModel pageList) { PaginationResultModel <Message> result = MailService.GetMailList(pageList); return(Json(result)); }
public JsonResult GetPics(PaginationModel pageList) { PaginationResultModel <ScrollPicture> sps = ScrollPicService.GetPicList(pageList); return(Json(sps)); }
private PaginationResultModel <CollectionSheetSearchItemDTO> TakeIndexForPaging(SearchCollectionSheetDTO input, PaginationResultModel <CollectionSheetSearchItemDTO> paging) { if (paging != null && paging.Items.Any()) { if (input.PageIndex >= paging.NumberOfPage) { input.PageIndex = 0; } int no = input.PageSize * (input.PageIndex); foreach (CollectionSheetSearchItemDTO item in paging.Items) { no++; item.No = no; } } return(paging); }