public JsonResult ExportExcel(ExcelModel eModel) { var curModel = new T_CGMX(); if (eModel.SCQYID != null) { T_SupQY qycp = new T_SupQY(); qycp.SupID = (int)eModel.SCQYID; curModel.T_SupQY1 = qycp; } if (eModel.CPID != null) { curModel.CPID = (int)eModel.CPID; } int pagesize = eModel.PageSize; int pagecount = 0; int currentPage = eModel.PageNum; var DataList = T_CGMXDomain.GetInstance().PageT_CGMX(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount); var str = ExportExcelPR(DataList); //调用输出Excel表的方法 ExportToExcel("application/vnd.ms-excel", "采购汇总.xls", str); return(Json("true")); }
public ActionResult Details(ExcelModel eModel) { var curModel = new T_CKCollect(); if (eModel.CKID != null) { curModel.CKID = (int)eModel.CKID; } if (!string.IsNullOrEmpty(eModel.CJRID)) { curModel.CollectPerson = eModel.CJRID; } int pagesize = eModel.PageSize; int pagecount = 0; int currentPage = eModel.PageNum; var DataList = T_CKCollectDomain.GetInstance().PageT_CKCollect(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount); ViewData["ParaStr"] = ExportExcelPR(DataList); return(View("~/Views/T_CKCollect/Details.cshtml", eModel)); }
public void ExportExcel(ExcelModel eModel) { var curModel = new T_CKCollect(); if (eModel.CKID != null) { curModel.CKID = (int)eModel.CKID; } if (!string.IsNullOrEmpty(eModel.CJRID)) { curModel.CollectPerson = eModel.CJRID; } int pagesize = eModel.PageSize; int pagecount = 0; int currentPage = eModel.PageNum; var DataList = T_CKCollectDomain.GetInstance().PageT_CKCollect(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount); var str = ExportExcelPR(DataList); //调用输出Excel表的方法 ExportToExcel("application/vnd.ms-excel", "仓库采集数据.xls", str); }
public ActionResult Details(ExcelModel eModel) { var curModel = new T_XSMX(); if (eModel.SCQYID != null) { T_SupQY qycp = new T_SupQY(); qycp.SupID = (int)eModel.SCQYID; curModel.T_YLCP.T_SupQY1 = qycp; } if (eModel.CPID != null) { curModel.CPID = (int)eModel.CPID; } int pagesize = eModel.PageSize; int pagecount = 0; int currentPage = eModel.PageNum; var DataList = T_XSMXDomain.GetInstance().PageT_XSMX(curModel, eModel.StartDate, eModel.EndDate, currentPage, pagesize, out pagecount, out resultCount); ViewData["ParaStr"] = ExportExcelPR(DataList); return(View("~/Views/T_XSHZ/Details.cshtml", eModel)); }