public IActionResult ResponseInfoExport(string ids) { var response = ResponseModelFactory.CreateResultInstance; using (_dbContext) { var column = new List<string>() { "通知村庄","通知人员","响应等级","通知情况","联系电话","状态" }; var column2 = new List<string>() { "Village","TongzhiRen","XiangyingDj","TongzhiQingk","Phone","State" }; if (!string.IsNullOrEmpty(ids)) { var parameters = ids.Trim().Split(","); for (int i = 0; i < parameters.Length; i++) { parameters[i] = parameters[i].ToUpper(); } var query = _dbContext.ResponseInfo.Where(x => x.IsDeleted != 1 && parameters.Contains(x.ResponseInfoUuid.ToString())).Select(x => new { Village = x.Village, TongzhiRen = x.TongzhiRen, XiangyingDj = x.XiangyingDj, TongzhiQingk = x.TongzhiQingk, Phone = x.Phone, State = x.State == 1 ? "已响应" : "未响应" }).ToList(); string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\"; string uploadtitle = "响应情况信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx"; DataToExcel.TablesToExcel(query, sFileName, column, column2); response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx"); ToLog.AddLog("导出", "成功:导出:响应情况信息数据", _dbContext); return Ok(response); } else { var query = _dbContext.ResponseInfo.Where(x => x.IsDeleted != 1).Select(x => new { Village = x.Village, TongzhiRen = x.TongzhiRen, XiangyingDj = x.XiangyingDj, TongzhiQingk = x.TongzhiQingk, Phone = x.Phone, State = x.State == 1 ? "已响应" : "未响应" }).ToList(); string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\"; string uploadtitle = "响应情况信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx"; DataToExcel.TablesToExcel(query, sFileName, column, column2); response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx"); ToLog.AddLog("导出", "成功:导出:响应情况信息数据", _dbContext); return Ok(response); } } }
public IActionResult ResponseInitExport(string ids) { var response = ResponseModelFactory.CreateResultInstance; using (_dbContext) { var column = new List <string>() { "通知村庄", "等级", "情况", "状态" }; var column2 = new List <string>() { "VillagesName", "Level", "Situation", "ReleaseState" }; if (!string.IsNullOrEmpty(ids)) { var parameters = ids.Trim().Split(","); for (int i = 0; i < parameters.Length; i++) { parameters[i] = parameters[i].ToUpper(); } var query = _dbContext.ResponseInit.Where(x => x.IsDelete != 1 && parameters.Contains(x.ResponseInitUuid.ToString())).Select(x => new { VillagesName = "", Villages = x.Villages, Level = x.Level, Situation = x.Situation, ReleaseState = x.ReleaseState == 1?"已发起":"未发起" }).ToList(); List <ResponseInitExportViewModel> resinit = new List <ResponseInitExportViewModel>(); for (int i = 0; i < query.Count; i++) { ResponseInitExportViewModel re = new ResponseInitExportViewModel(); re.Level = query[i].Level; re.Situation = query[i].Situation; re.ReleaseState = query[i].ReleaseState; if (query[i].Villages != null) { var village = query[i].Villages.Split(","); var villagesname = ""; foreach (var item in village) { var villagesingle = _dbContext.Village.FirstOrDefault(x => x.VillageUuid.ToString() == item); if (villagesingle != null) { villagesname += villagesingle.VillageName + ","; } } re.VillagesName = villagesname.Trim(','); } resinit.Add(re); } string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\"; string uploadtitle = "响应发起信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx"; DataToExcel.TablesToExcel(resinit, sFileName, column, column2); response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx"); ToLog.AddLog("导出", "成功:导出:响应发起记录信息数据", _dbContext); return(Ok(response)); } else { var query = _dbContext.ResponseInit.Where(x => x.IsDelete != 1).Select(x => new { VillagesName = "", Villages = x.Villages, Level = x.Level, Situation = x.Situation, ReleaseState = x.ReleaseState == 1 ? "已通知" : "未通知" }).ToList(); List <ResponseInitExportViewModel> resinit = new List <ResponseInitExportViewModel>(); for (int i = 0; i < query.Count; i++) { ResponseInitExportViewModel re = new ResponseInitExportViewModel(); re.Level = query[i].Level; re.Situation = query[i].Situation; re.ReleaseState = query[i].ReleaseState; if (query[i].Villages != null) { var village = query[i].Villages.Split(","); var villagesname = ""; foreach (var item in village) { var villagesingle = _dbContext.Village.FirstOrDefault(x => x.VillageUuid.ToString() == item); if (villagesingle != null) { villagesname += villagesingle.VillageName + ","; } } re.VillagesName = villagesname.Trim(','); } resinit.Add(re); } string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportEmergencyExcel\\"; string uploadtitle = "响应发起信息导出" + DateTime.Now.ToString("yyyyMMddHHmmss"); string sFileName = $"{sWebRootFolder + uploadtitle}.xlsx"; DataToExcel.TablesToExcel(resinit, sFileName, column, column2); response.SetData("\\UploadFiles\\ImportEmergencyExcel\\" + uploadtitle + ".xlsx"); ToLog.AddLog("导出", "成功:导出:响应发起记录信息数据", _dbContext); return(Ok(response)); } } }