/// <summary> /// 导出付款条款 /// </summary> /// <param name="dto"></param> /// <returns></returns> public ActionResult ExportPayment(PaymentSearchDTO dto) { string result = null; List <PaymentResultDTO> pp = null; pp = BaseInfoProvider.GetPaymentList(dto); string strTemplateFile = Server.MapPath(@"~/TempLate/PaymentTemplate.xlsx"); string strGenarateDir = Server.MapPath(@"~/TempFile"); string strGenarateFile = Guid.NewGuid().ToString("N") + ".xlsx"; string strExportFile = strGenarateDir + "\\" + strGenarateFile; List <object> ratelist = new List <object>(); pp.ForEach(g => { Models.Model.Excel.ExcelPayment er = new Models.Model.Excel.ExcelPayment(); er.状态 = g.PayStatusStr; er.付款条款 = g.PayName; er.OracleName = g.OracleName; er.开始日期 = g.PayStartTime.HasValue ? g.PayStartTime.Value.ToString("yyyy-MM-dd") : null; er.结束日期 = g.PayEndTime.HasValue ? g.PayEndTime.Value.ToString("yyyy-MM-dd") : null; ratelist.Add(er); }); if (Common.ExcelHelper.Export(strTemplateFile, strGenarateDir, strGenarateFile, ratelist, "Sheet1")) { result = strGenarateFile; } return(Json(result)); }
/// <summary> /// 查询付款条款信息 /// </summary> /// <param name="dto"></param> /// <returns></returns> public ActionResult GetPaymentList(PaymentSearchDTO dto) { List <PaymentResultDTO> result = null; result = BaseInfoProvider.GetPaymentList(dto); return(Json(result, JsonRequestBehavior.AllowGet)); }