/// <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); }