/// <summary> /// 得到反馈信息 /// </summary> /// <returns></returns> public ActionResult GetFeedbackList(FeedbackSearchDTO dto) { ResultData <List <FeedbackModel> > result = new ResultData <List <FeedbackModel> >(); result = SystemProvider.GetFeedbackList(dto); return(Json(new { total = result.Count, rows = result.Object }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 导出反馈 /// </summary> /// <param name="dto"></param> /// <returns></returns> public ActionResult ExportFeedback(FeedbackSearchDTO dto) { dto.page = 1; dto.rows = 10000000; List <FeedbackModel> resultFeedback = null; string result = null; resultFeedback = SystemProvider.GetFeedbackList(dto).Object; string strTemplateFile = Server.MapPath(@"~/TempLate/FeedbackTemplate.xlsx"); string strGenarateDir = Server.MapPath(@"~/TempFile"); string strGenarateFile = Guid.NewGuid().ToString("N") + ".xlsx"; string strExportFile = strGenarateDir + "\\" + strGenarateFile; List <object> ratelist = new List <object>(); resultFeedback.ForEach(g => { Models.Model.Excel.ExcelFeedback er = new Models.Model.Excel.ExcelFeedback(); er.状态 = g.FeedbackStausStr; if (g.AttachFile != null) { er.附件 = g.AttachFile.AttachFileSrcName + g.AttachFileExtentionName; } er.反馈日期 = g.FeedbackDate.ToString(); er.反馈人 = g.FullName; er.反馈系统 = g.FeedbackSystem; er.反馈模块 = g.FeedbackModel; er.反馈内容 = g.FeedbackContent; er.经销商 = g.UserDistributorstr; er.部门 = g.DepartName; er.反馈人手机 = g.PhoneNumber; er.反馈人邮箱 = g.Email; ratelist.Add(er); }); if (Common.ExcelHelper.Export(strTemplateFile, strGenarateDir, strGenarateFile, ratelist, "Sheet1")) { result = strGenarateFile; } return(Json(result)); }