public ActionResult AddTestChemicalReport(FormCollection collection)
{
var model = new TestChemicalReport();
var models = new SampleRegisterTable();
var parameters = this.IDKLManagerService.GetParameterList().Select(c => new { Name = c.ParameterName }).Distinct();
#region 过滤掉样品登记表中的噪声选项
int i = 0;
var paraMeters = parameters.ToList();
foreach (var item in parameters)
{
i++;
if (item.Name == "噪声" || item.Name == "噪音")
{
paraMeters.Remove(paraMeters[i - 1]);
i--;
}
}
#endregion
ViewData.Add("ParameterName", new SelectList(paraMeters, "Name", "Name"));
model.ProjectNumber = m_ProjectWholeInfoViewModel.projectBasicinfo.ProjectNumber;
model.WorkShop = collection["projectTestChemicalReport.WorkShop"];
model.Job = collection["projectTestChemicalReport.Job"];
model.Location = collection["projectTestChemicalReport.Location"];
model.CSTEL = collection["projectTestChemicalReport.CSTEL"];
model.CTWA = collection["projectTestChemicalReport.CTWA"];
model.CMAC = collection["projectTestChemicalReport.CMAC"];
model.Factor = collection["projectTestChemicalReport.SampleProject"];
model.SampleNumber = collection["projectTestChemicalReport.SampleNumber"];
model.SampleProject = collection["projectTestChemicalReport.SampleProject"];
m_ProjectWholeInfoViewModel.projectTestChemicalReportList.Add(model);
this.IDKLManagerService.InsertTestChemicalReport(model);
return(View("Edit", m_ProjectWholeInfoViewModel));
}
public ActionResult Create(FormCollection collection)
{
var model = new TestChemicalReport();
this.TryUpdateModel <TestChemicalReport>(model);
this.IDKLManagerService.InsertTestChemicalReport(model);
return(RefreshParent());
}
public ProjectWholeInfoViewModel()
{
projectTime = new ProjectInfo();
projectClosingDate = new ProjectInfo();
projectBasicImgFile = new ProjectFile();
device = new DeviceOrderInfo();
projectBasicinfo = new ProjectInfo();
projectConsultBasicinfo = new ConsultBasicInfo();
projectBasicFile = new ProjectFile();
projectTestBasicinfo = new TestBasicInfo();
projectTestChemicalReport = new TestChemicalReport();
projectTestChemicalReportList = new List <TestChemicalReport>();
projectValueBasicinfo = new ValueBasicInfo();
sampleTable = new SampleRegisterTable();
projectTestBasicinfoList = new List <TestBasicInfo>();
arguments = new ArgumentValue();
}
public ActionResult WORDTEST(FormCollection collection)
{
#region 基本信息
ProjectInfo projectmodels = new ProjectInfo();
projectmodels.CompaneName = m_ProjectWholeInfoViewModel.projectBasicinfo.CompaneName;
projectmodels.CompanyAddress = m_ProjectWholeInfoViewModel.projectBasicinfo.CompanyAddress;
projectmodels.ProjectName = m_ProjectWholeInfoViewModel.projectBasicinfo.ProjectName;
projectmodels.CompanyContact = m_ProjectWholeInfoViewModel.projectBasicinfo.CompanyContact;
projectmodels.ZipCode = m_ProjectWholeInfoViewModel.projectBasicinfo.ZipCode;
projectmodels.ContactTel = m_ProjectWholeInfoViewModel.projectBasicinfo.ContactTel;
projectmodels.ProjectNumber = m_ProjectWholeInfoViewModel.projectBasicinfo.ProjectNumber;
#endregion
#region 危害因素信息
List <string> str = new List <string>();
List <TestChemicalReport> chemicalmodels = new List <TestChemicalReport>();
List <SampleRegisterTable> models = this.IDKLManagerService.GetSampleRegisterListByProjectNumber(m_ProjectWholeInfoViewModel.projectBasicinfo.ProjectNumber);
#region 化学数据对接
foreach (var item in models)
{
TestChemicalReport model = new TestChemicalReport();
model.SampleNumber = item.SampleRegisterNumber;
model.ProjectNumber = item.ProjectNumber;
model.SampleProject = item.ParameterName;
model.Factor = item.ParameterName;
model.ID = item.ID;
model.CreateTime = item.SamplingDay;
model.WorkShop = item.WorkShop;
model.Job = item.Job;
model.Location = item.Location;
model.CSTEL = item.CSTEL;
model.CTWA = item.CTWA;
model.CMAC = item.CMAC;
chemicalmodels.Add(model);
}
#endregion
foreach (var item in chemicalmodels)
{
str.Add(item.SampleProject);
}
str = str.Distinct().ToList();
#region 化学限值部分
List <Parameter> ParmeterChemicalModels = this.IDKLManagerService.GetParameterListBySampleProject(str); //重载
List <OccupationaldiseaseHarm> OccupationaldiseaseHarms = this.IDKLManagerService.GetOccupationaldiseaseHarmList(ParmeterChemicalModels);
foreach (var item in OccupationaldiseaseHarms)
{
if (item == null)
{
return(Back("请核对参数跟职业病信息"));
}
}
#endregion
#region 化学危害描述
#endregion
#endregion
string strFileName = "";
// CreateContractTestingAndEvaluation cr = new CreateContractTestingAndEvaluation();
CreatePresentEvaluationDoc cr = new CreatePresentEvaluationDoc(projectmodels, ParmeterChemicalModels, OccupationaldiseaseHarms);
List <string> appList = new List <string>();
appList = cr.CreateReportWord();
#region 判断报告生成运行状态
if (appList[0] == "1")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("合同生成失败"));
}
if (appList[0] == "2")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("合同生成失败"));
}
if (appList[0] == "3")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("合同生成失败"));
}
#endregion
strFileName = appList[1];
//报告下载
if (!string.IsNullOrEmpty(strFileName))
{
string fileNewName = strFileName.Substring(strFileName.LastIndexOf("\\") + 1);
Response.Clear();
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileNewName, Encoding.UTF8));
Response.WriteFile(strFileName);
Response.End();
}
else
{
return(Back("下载报告失败"));
}
return(Back("成功"));
} //评价报告 三江模板
public ActionResult DownLoadTsetDocFile(FormCollection collection)
{
//try
//{
string strFileName = "";
//1.判断是否满足下载条件
//2.从各个数据库获取数据
//3.调用接口生成报告
List <string> strc = new List <string>(); //物理检测项目(查询，制表用)
List <string> str = new List <string>(); //化学采样项目 控制打印表格时打印的项目
ProjectInfo projectmodels = new ProjectInfo();
List <TestPhysicalReport> physicalmodels = new List <TestPhysicalReport>();
List <TestChemicalReport> chemicalmodels = new List <TestChemicalReport>();
if ((m_ProjectWholeInfoViewModel == null) || (m_ProjectWholeInfoViewModel.projectBasicinfo == null))
{
return(Back("123"));
}
List <SampleRegisterTable> models = this.IDKLManagerService.GetSampleRegisterListByProjectNumber(m_ProjectWholeInfoViewModel.projectBasicinfo.ProjectNumber);
#region 化学数据对接
foreach (var item in models)
{
TestChemicalReport model = new TestChemicalReport();
model.SampleNumber = item.SampleRegisterNumber;
model.ProjectNumber = item.ProjectNumber;
model.SampleProject = item.ParameterName;
model.Factor = item.ParameterName;
model.ID = item.ID;
model.CreateTime = item.SamplingDay;
model.WorkShop = item.WorkShop;
model.Job = item.Job;
model.Location = item.Location;
model.CSTEL = item.CSTEL;
model.CTWA = item.CTWA;
model.CMAC = item.CMAC;
chemicalmodels.Add(model);
}
#endregion
foreach (var item in chemicalmodels)
{
str.Add(item.SampleProject);
}
str = str.Distinct().ToList();
#region 采样项目打印
List <SampleProjectGist> ProjectGistmodels = this.IDKLManagerService.GetSampleProjectGistBySampleProject(str);
#endregion
#region 基本信息
projectmodels.CompaneName = m_ProjectWholeInfoViewModel.projectBasicinfo.CompaneName;
projectmodels.CompanyAddress = m_ProjectWholeInfoViewModel.projectBasicinfo.CompanyAddress;
projectmodels.ProjectName = m_ProjectWholeInfoViewModel.projectBasicinfo.ProjectName;
projectmodels.CompanyContact = m_ProjectWholeInfoViewModel.projectBasicinfo.CompanyContact;
projectmodels.ZipCode = m_ProjectWholeInfoViewModel.projectBasicinfo.ZipCode;
projectmodels.ContactTel = m_ProjectWholeInfoViewModel.projectBasicinfo.ContactTel;
projectmodels.ProjectNumber = m_ProjectWholeInfoViewModel.projectBasicinfo.ProjectNumber;
#endregion
#region 物理检测部分录入
foreach (var item in m_ProjectWholeInfoViewModel.projectTestBasicinfoList)
{
strc.Add(item.TestContent);
if (item.TestContent == "噪声" || item.TestContent == "噪音")
{
var modeltemp = new TestPhysicalReport();
modeltemp.ProjectNumber = item.ProjectNumber;
modeltemp.WordShop = item.WordShop;
modeltemp.TestContent = item.TestContent;
modeltemp.Job = item.Job;
modeltemp.Location = item.Location;
modeltemp.SampleNumber = item.SampleNumber;
modeltemp.ContactTime = item.TouchTime;
modeltemp.NoiseIntensity = item.NoiseStrength;
modeltemp.Lex8hLexw = item.Lex8hLexw;
modeltemp.LexCategory = item.LexCategory;
physicalmodels.Add(modeltemp);
}
}
strc = strc.Distinct().ToList(); //去重
#endregion
#region 检测部分打印（物理+化学）
List <Parameter> Parametermodels = this.IDKLManagerService.GetParameterListBySampleProject(str, strc);
#endregion
#region 化学限值部分
List <Parameter> ParmeterChemicalModels = this.IDKLManagerService.GetParameterListBySampleProject(str); //重载
#endregion
#region 报告生成+下载
CreatTestDoc cr = new CreatTestDoc(projectmodels);
if ((ProjectGistmodels != null) && (Parametermodels != null) && (ParmeterChemicalModels != null) && (projectmodels != null) && (physicalmodels != null) && (chemicalmodels != null))
{
List <string> appList = new List <string>();
appList = cr.CreateReportWord(str, strc, ProjectGistmodels, Parametermodels, ParmeterChemicalModels, projectmodels, physicalmodels, chemicalmodels);
#region 判断报告生成运行状态
if (appList[0] == "1")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("检测项目中缺少对应参数，请联系实验室人员添加相应参数"));
}
if (appList[0] == "2")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("采样项目中缺少对应参数，请联系实验室人员添加相应参数"));
}
if (appList[0] == "3")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("采样项目未检测到数据，请联系实验室人员添加相应数据"));
}
#endregion
strFileName = appList[1];
} //报告下载
if (!string.IsNullOrEmpty(strFileName))
{
string fileNewName = strFileName.Substring(strFileName.LastIndexOf("\\") + 1);
Response.Clear();
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileNewName, Encoding.UTF8));
Response.WriteFile(strFileName);
Response.End();
}
else
{
return(Back("下载报告失败"));
}
#endregion
//}
//catch (Exception e)
//{
// return Back("1"+e.Message);
//}
return(Back("成功"));
}
protected void MoveProjectData(string projectNumber)
{
var infomodel = new ProjectInfo();
infomodel = this.IDKLManagerService.GetProjectInfo(projectNumber);
if (infomodel != null)
{
ProjectInfoHistory history = ProjectInfoHistory.Clone(infomodel);
history.ProjectRealClosingDate = DateTime.Now;
this.IDKLManagerService.AddProjectInfoHistory(history);
}
this.IDKLManagerService.DeleteProjectInfo(projectNumber);
var valueInfo = new ValueBasicInfo();
valueInfo = this.IDKLManagerService.GetVlaueProjectBasicInfo(projectNumber);
if (valueInfo != null)
{
ValueBasicInfoHistory history = ValueBasicInfoHistory.Clone(valueInfo);
this.IDKLManagerService.AddVlaueProjectBasicInfoHistory(history);
}
this.IDKLManagerService.DeleteVlaueProjectBasicInfo(projectNumber);
var testChemical = new TestChemicalReport();
testChemical = this.IDKLManagerService.GetTestTestChemicalReport(projectNumber);
if (testChemical != null)
{
TestChemicalReportListHistory chemicalHistory = TestChemicalReportListHistory.Clone(testChemical);
this.IDKLManagerService.AddTestChemicalReportListHistory(chemicalHistory);
}
this.IDKLManagerService.DeleteTestChemicalReport(projectNumber);
var testInfo = new TestBasicInfo();
testInfo = this.IDKLManagerService.GetProjectTestBasicInfo(projectNumber);
if (testInfo != null)
{
TestBasicInfoHistory history = TestBasicInfoHistory.Clone(testInfo);
this.IDKLManagerService.AddProjectTestBasicInfoHistory(history);
}
this.IDKLManagerService.DeleteProjectTestBasicInfo(projectNumber);
var consultInfo = new ConsultBasicInfo();
consultInfo = this.IDKLManagerService.GetConsultBasicInfo(projectNumber);
if (consultInfo != null)
{
ConsultBasicInfoHistory history = ConsultBasicInfoHistory.Clone(consultInfo);
this.IDKLManagerService.AddConsultBasicInfoHistory(history);
}
this.IDKLManagerService.DeleteConsultBasicInfo(projectNumber);
var fileInfo = new ProjectFile();
fileInfo = this.IDKLManagerService.GetProjectFile(projectNumber);
if (fileInfo != null)
{
ProjectFileHistory history = ProjectFileHistory.Clone(fileInfo);
this.IDKLManagerService.AddProjectFileHistory(history);
}
this.IDKLManagerService.DeleteProjectFile(projectNumber);
var docList = this.IDKLManagerService.GetProjectDocFileList(projectNumber);
ProjectDocFileHistory docHistory = new ProjectDocFileHistory();
foreach (var doc in docList)
{
docHistory = ProjectDocFileHistory.Clone(doc);
this.IDKLManagerService.AddProjectDocFileHistory(docHistory);
}
this.IDKLManagerService.DeleteProjectDocFile(projectNumber);
}
/// <summary>
/// 添加新增
/// </summary>
/// <returns></returns>
public ActionResult Create()
{
var model = new TestChemicalReport();
return(View("Edit", model));
}
public ActionResult DownLoadTestDocFile1(int id) ///下载水质监测报告 传入的值id为项目id
{
//try
//{
string strFileName = "";
//1.判断是否满足下载条件
//2.从各个数据库获取数据
//3.调用接口生成报告
var projectmodels = this.IDKLManagerService.GetProjectInfo(id); ///项目信息
List <string> strc = new List <string>();
var chemicalmodels = this.IDKLManagerService.GetChemicalReport(projectmodels.ProjectNumber);
var models = this.IDKLManagerService.GetSampleRegisterListByProjectNumber(projectmodels.ProjectNumber);
#region 化学数据对接
foreach (var item in models)
{
TestChemicalReport model = new TestChemicalReport();
model.SampleNumber = item.SampleRegisterNumber;
model.ProjectNumber = item.ProjectNumber;
model.SampleProject = item.ParameterName;
model.Factor = item.ParameterName;
model.ID = item.ID;
model.CreateTime = item.SamplingDay;
model.WorkShop = item.WorkShop;
model.Job = item.Job;
model.Location = item.Location;
model.CSTEL = item.CSTEL;
model.CTWA = item.CTWA;
model.CMAC = item.CMAC;
chemicalmodels.Add(model);
}
#endregion
foreach (var item in chemicalmodels)
{
strc.Add(item.SampleProject);
}
//strc = strc.Distinct().ToList();
#region 报告生成+下载
CreatWaterTestDoc cr = new CreatWaterTestDoc(projectmodels);
if ((projectmodels != null) && (chemicalmodels != null))
{
List <string> appList = new List <string>();
appList = cr.CreateReportWord(strc, projectmodels, chemicalmodels);
#region 判断报告生成运行状态
if (appList[0] == "1")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("检测项目中缺少对应参数，请联系实验室人员添加相应参数"));
}
if (appList[0] == "2")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("采样项目中缺少对应参数，请联系实验室人员添加相应参数"));
}
if (appList[0] == "3")
{
FileInfo fr = new FileInfo(appList[1]);
fr.Delete();
return(Back("采样项目未检测到数据，请联系实验室人员添加相应数据"));
}
#endregion
strFileName = appList[1];
}
//报告下载
if (!string.IsNullOrEmpty(strFileName))
{
string fileNewName = strFileName.Substring(strFileName.LastIndexOf("\\") + 1);
Response.Clear();
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileNewName, Encoding.UTF8));
Response.WriteFile(strFileName);
Response.End();
}
else
{
return(Back("下载报告失败"));
}
#endregion
//}
//catch (Exception e)
//{
// return Back("1"+e.Message);
//}
return(Back("成功"));
}
