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