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