Exemple #1
0
        /// <summary>
        /// 导出数据
        /// </summary>
        /// <returns></returns>
        public async Task <string> Export()
        {
            using (var scope = _dbContextScopeFactory.CreateReadOnly())
            {
                var db   = scope.DbContexts.Get <JuCheapContext>();
                var list = await db.Menus.OrderBy(x => x.Order)
                           .Select(item => new MenuDto
                {
                    Id   = item.Id,
                    Name = item.Name,
                    Url  = item.Url
                }).ToListAsync();

                return(SpireHelper.SaveToExcel("菜单数据报表", list));
            }
        }
        /// <summary>
        /// 打印
        /// </summary>
        /// <param name="condition">查询参数</param>
        public async void Index_Print(MenuFilters condition)
        {
            var menus = await _menuService.QueryExportDatas(condition);

            SpireHelper.ExportToPdf("菜单", menus, true);
        }
        /// <summary>
        /// 导出到Excel
        /// </summary>
        /// <param name="condition">查询参数</param>
        public async void Index_Exports(MenuFilters condition)
        {
            var menus = await _menuService.QueryExportDatas(condition);

            SpireHelper.ExportToExcel("菜单", menus);
        }