public async Task <IActionResult> GetFormOptions(Guid id) { var options = await _formDesignOptionsRepository.FindAsIQueryable(x => x.FormId == id) .Select(s => new { s.Title, s.FormOptions }) .FirstOrDefaultAsync(); return(Json(new { data = options })); }
public override WebResponseContent Export(PageDataOptions pageData) { string path = null; string fileName = null; WebResponseContent webResponse = new WebResponseContent(); ExportOnExecuting = (List <FormCollectionObject> list, List <string> columns) => { var formId = list[0].FormId; var data = _designOptionsRepository.FindAsIQueryable(x => x.FormId == formId) .Select(s => new { s.Title, s.FormConfig }).FirstOrDefault(); try { List <FormOptions> formObj = data.FormConfig.DeserializeObject <List <FormOptions> >(); List <Dictionary <string, object> > listDic = new List <Dictionary <string, object> >(); foreach (var item in list) { Dictionary <string, object> dic = new Dictionary <string, object>(); var formData = item.FormData.DeserializeObject <Dictionary <string, string> >(); dic.Add("标题", data.Title); dic.Add("提交人", item.Creator); dic.Add("提交时间", item.CreateDate.ToString("yyyy-MM-dd HH:mm:sss")); foreach (var obj in formObj) { dic.Add(obj.Title, formData.Where(x => x.Key == obj.Field).Select(s => s.Value).FirstOrDefault()); } listDic.Add(dic); } fileName = data.Title + ".xlsx"; path = EPPlusHelper.ExportGeneralExcel(listDic, fileName); } catch (Exception ex) { Logger.Error($"解析表单出错:{data.Title},表单配置:{data.FormConfig},{ex.Message}"); return(webResponse.Error("获取表单出错")); } webResponse.Code = "-1"; return(webResponse.OK(null, path.EncryptDES(AppSetting.Secret.ExportFile))); }; return(base.Export(pageData)); }