예제 #1
0
        /// <summary>
        /// 导出文章来源
        /// </summary>
        public async Task <FileDto> GetArticleSourceInfosToExcel(GetArticleSourceInfosInput input)
        {
            async Task <List <ArticleSourceInfoExportDto> > getListFunc(bool isLoadSoftDeleteData)
            {
                var query   = CreateArticleSourceInfosQuery(input);
                var results = await query
                              .OrderBy(input.Sorting)
                              .ToListAsync();

                var exportListDtos = results.MapTo <List <ArticleSourceInfoExportDto> >();

                if (exportListDtos.Count == 0)
                {
                    throw new UserFriendlyException(L("NoDataToExport"));
                }

                return(exportListDtos);
            }

            List <ArticleSourceInfoExportDto> exportData = null;

            //是否仅加载回收站数据
            if (input.IsOnlyGetRecycleData)
            {
                using (UnitOfWorkManager.Current.DisableFilter(AbpDataFilters.SoftDelete))
                {
                    exportData = await getListFunc(true);
                }
            }

            exportData = await getListFunc(false);

            var fileDto   = new FileDto(L("ArticleSourceInfo") + L("ExportData") + ".xlsx", MimeTypeNames.ApplicationVndOpenxmlformatsOfficedocumentSpreadsheetmlSheet);
            var byteArray = await _excelExporter.ExportAsByteArray(exportData);

            _tempFileCacheManager.SetFile(fileDto.FileToken, byteArray);
            return(fileDto);
        }
예제 #2
0
        /// <summary>
        ///
        /// </summary>
        private IQueryable <ArticleSourceInfo> CreateArticleSourceInfosQuery(GetArticleSourceInfosInput input)
        {
            var query = _articleSourceInfoRepository.GetAll();

            //关键字搜索
            query = query
                    .WhereIf(
                !input.Filter.IsNullOrEmpty(),
                p => p.Name.Contains(input.Filter));


            //创建时间范围搜索
            query = query
                    .WhereIf(input.CreationDateStart.HasValue, t => t.CreationTime >= input.CreationDateStart.Value)
                    .WhereIf(input.CreationDateEnd.HasValue, t => t.CreationTime <= input.CreationDateEnd.Value);


            //修改时间范围搜索
            query = query
                    .WhereIf(input.ModificationTimeStart.HasValue, t => t.LastModificationTime >= input.ModificationTimeStart.Value)
                    .WhereIf(input.ModificationTimeEnd.HasValue, t => t.LastModificationTime <= input.ModificationTimeEnd.Value);

            return(query);
        }
예제 #3
0
        /// <summary>
        /// 获取文章来源列表
        /// </summary>
        public async Task <PagedResultDto <ArticleSourceInfoListDto> > GetArticleSourceInfos(GetArticleSourceInfosInput input)
        {
            async Task <PagedResultDto <ArticleSourceInfoListDto> > getListFunc(bool isLoadSoftDeleteData)
            {
                var query = CreateArticleSourceInfosQuery(input);

                //仅加载已删除的数据
                if (isLoadSoftDeleteData)
                {
                    query = query.Where(p => p.IsDeleted);
                }

                var resultCount = await query.CountAsync();

                var results = await query
                              .OrderBy(input.Sorting)
                              .PageBy(input)
                              .ToListAsync();

                return(new PagedResultDto <ArticleSourceInfoListDto>(resultCount, results.MapTo <List <ArticleSourceInfoListDto> >()));
            }

            //是否仅加载回收站数据
            if (input.IsOnlyGetRecycleData)
            {
                using (UnitOfWorkManager.Current.DisableFilter(AbpDataFilters.SoftDelete))
                {
                    return(await getListFunc(true));
                }
            }
            return(await getListFunc(false));
        }