コード例 #1
0
        public async Task <IActionResult> OnGetLoadCategoryAsync()
        {
            var queryInput = new QueryCatogoryInputDto();

            queryInput.FetchFromOther(Query.ToDto());

            var result = (await _categoryService.GetCategoryByPageAsync(queryInput)).ToBootStrapQueryResultModel();

            return(new JsonResult(result));
        }
コード例 #2
0
        public async Task <PagedResultDto <CategoryDto> > GetCategoryByPageAsync(QueryCatogoryInputDto pagedQuery)
        {
            var query      = _categoryRep.GetAll();
            var resultList = await query
                             .OrderBy(pagedQuery.Sorting ?? $"{nameof(Category.CreateTime)} DESC")
                             .Skip(pagedQuery.SkipCount)
                             .Take(pagedQuery.MaxResultCount)
                             .Select(c => new CategoryDto()
            {
                Id           = c.Id,
                Name         = c.Name,
                ArticleCount = c.Articles.Count,
                CreateTime   = c.CreateTime
            })
                             .ToListAsync();

            var total = await query.CountAsync();

            return(new PagedResultDto <CategoryDto>(total, resultList));
        }