// GET: Console/ExportReports
public ActionResult ExportReports()
{
IViewerFactory <ReportView> factory = new ReportViewFactory();
var list = factory.Query(new Criteria(new
{
MenuDate = DateTime.Today,
MenuType = (int)MenuDto.GetMenuLunchOrSupper(0, false)
}));
if (list != null && list.Count > 0)
{
var mapper = ReportDto.ConfigMapper().CreateMapper();
var reports = mapper.Map <IEnumerable <ReportDto> >(list.AsEnumerable()).ToList();
var book = ExcelManager.BuildReportWorkbook(reports);
byte[] file;
using (var ms = new MemoryStream())
{
book.Write(ms);
file = ms.GetBuffer();
}
return(File(file, "application/vnd.ms-excel", $@"今日订餐统计表-{DateTime.Today:yyyyMMdd}.xls"));
}
return(RedirectToAction("Index", "Home"));
}
