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