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