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 CGDSPIndex(System.Int32 id, string tag) { T_CGDModels model = new T_CGDModels(); model.DataModel = new T_CGD(); T_CGMX cgmodel = new T_CGMX(); if (id != 0) { model.DataModel = T_CGDDomain.GetInstance().GetModelById(id); model.CGMXList = T_CGMXDomain.GetInstance().GetAllT_CGMX(cgmodel); if (model.CGMXList.Count > 0) { model.CGMXList = model.CGMXList.Where(p => p.CGID == id).ToList(); } } model.Tag = tag; return(View("~/Views/T_CGD/CGDSPIndex.cshtml", model)); }
public ActionResult Details(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); ViewData["ParaStr"] = ExportExcelPR(DataList); return(View("~/Views/T_CGHZ/Details.cshtml", eModel)); }
public T_CGDModels() { base.CGMXList = base.CGMXList ?? new List <T_CGMX>(); CGMXModel = new T_CGMX(); }