public ActionResult SaleGoodsReportList()
{
List <SaleGoodsReport> list = new List <SaleGoodsReport>();
pbs_basic_OrderService pbsBasicOrderService = new pbs_basic_OrderService();
ResultInfo <List <SaleGoodsReport> > result = pbsBasicOrderService.GetSaleGoodsReportList();
if (result.Result && result.Data != null)
{
list = result.Data;
}
ViewData["SaleGoodsReportList"] = list;
return(View());
}
public JsonResult ExportExcelAjax()
{
dynamic result = new ExpandoObject();
result.Code = "0001";
result.Msg = "error";
result.Url = string.Empty;
pbs_basic_OrderService pbsBasicOrderService = new pbs_basic_OrderService();
ResultInfo <List <SaleGoodsReport> > resultList = pbsBasicOrderService.GetSaleGoodsReportList();
if (resultList.Result && resultList.Data != null)
{
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx";
string savePath = Server.MapPath("~/Content/export/") + fileName;
ExportExcelHelper.ExportExcel(savePath, ParseHelper.ToDataTable(resultList.Data));
result.Code = "0000";
result.Msg = "ok";
result.Url = "/Content/export/" + fileName;
}
return(Json(JsonConvert.SerializeObject(result), JsonRequestBehavior.AllowGet));
}
