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