public ActionResult QueryPurchaseSaleInventorySummary(Pager page, PurchaseSaleInventorySearch condition) { var rows = _reportQuery.QueryPurchaseSaleInventorySummary(page, condition); if (page.toExcel) { var data = _excelService.WriteToExcelStream(rows.ToList(), ExcelVersion.Above2007, false, true).ToArray(); var fileName = string.Format("进销存_{0}.xlsx", DateTime.Now.ToString("yyyyMMdd")); return(File(data, "application/ms-excel", fileName)); } return(Json(new { success = true, data = rows, total = page.Total, sum = page.SumColumns })); }
public ActionResult LoadData(Pager page, SearchStoreInventory condition) { if (string.IsNullOrEmpty(condition.StoreId) || condition.StoreId == "0") { condition.StoreId = _context.CurrentAccount.CanViewStores; } var rows = _storeInventoryQuery.GetPageList(page, condition); if (page.toExcel) { var data = _excelService.WriteToExcelStream(rows.ToList(), ExcelVersion.Above2007, false, true).ToArray(); var fileName = string.Format("库存_{0}.xlsx", DateTime.Now.ToString("yyyyMMdd")); return(File(data, "application/ms-excel", fileName)); } return(Json(new { success = true, data = rows, total = page.Total, sum = page.SumColumns })); }