/// <summary> /// 生成原始记录 /// </summary> /// <param name="PlanID">实验计划ID</param> /// <returns>返回生成结果</returns> public JsonResult CreateOriginalRecord(int PlanID) { E_tb_ExpePlan eExpePlan = _dExpePlan.GetModel(PlanID); E_tb_Project eProject = _dProject.GetModel(Convert.ToInt32(eExpePlan.ProjectID)); //定义原始记录实体 E_tb_OriginalRecord eOriginalRecord = new E_tb_OriginalRecord(); eOriginalRecord.ProjectID = eExpePlan.ProjectID; eOriginalRecord.TaskNo = eExpePlan.TaskNo; eOriginalRecord.DetectTime = eExpePlan.InspectTime; eOriginalRecord.DetectPersonnelID = CurrentUserInfo.PersonnelID; //提前给定最终文件保存名称 eOriginalRecord.FilePath = "OriginalRecordFile/LIMS" + DateTime.Now.ToString("yyyyMMddhhmmss") + "." + eProject.FilePath.Split('.')[1]; eOriginalRecord.Contents = ""; eOriginalRecord.AreaID = CurrentUserInfo.AreaID; eOriginalRecord.EditPersonnelID = CurrentUserInfo.PersonnelID; eOriginalRecord.SampleID = eExpePlan.SampleID; //默认给第一个标准, 后续可修改 eOriginalRecord.InsStand = eProject.InsStand.Split('、')[0].ToString(); bool result = _dOriginalRecord.Add(eOriginalRecord) > 0; return(Json(new { result = result, msg = "生成成功!" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_OriginalRecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_OriginalRecord set "); strSql.Append("ProjectID=@ProjectID,"); strSql.Append("TaskNo=@TaskNo,"); strSql.Append("DetectTime=@DetectTime,"); strSql.Append("DetectPersonnelID=@DetectPersonnelID,"); strSql.Append("FilePath=@FilePath,"); strSql.Append("Contents=@Contents,"); strSql.Append("AreaID=@AreaID,"); strSql.Append("EditPersonnelID=@EditPersonnelID,"); strSql.Append("SampleID=@SampleID,"); strSql.Append("InsStand=@InsStand"); strSql.Append(" where RecordID=@RecordID"); SqlParameter[] parameters = { new SqlParameter("@ProjectID", SqlDbType.Int, 4), new SqlParameter("@TaskNo", SqlDbType.NVarChar, 50), new SqlParameter("@DetectTime", SqlDbType.DateTime), new SqlParameter("@DetectPersonnelID", SqlDbType.Int, 4), new SqlParameter("@FilePath", SqlDbType.NVarChar, 150), new SqlParameter("@Contents", SqlDbType.NVarChar, 200), new SqlParameter("@AreaID", SqlDbType.Int, 4), new SqlParameter("@EditPersonnelID", SqlDbType.Int, 4), new SqlParameter("@SampleID", SqlDbType.Int, 4), new SqlParameter("@RecordID", SqlDbType.Int, 4), new SqlParameter("@InsStand", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.ProjectID; parameters[1].Value = model.TaskNo; parameters[2].Value = model.DetectTime; parameters[3].Value = model.DetectPersonnelID; parameters[4].Value = model.FilePath; parameters[5].Value = model.Contents; parameters[6].Value = model.AreaID; parameters[7].Value = model.EditPersonnelID; parameters[8].Value = model.SampleID; parameters[9].Value = model.RecordID; parameters[10].Value = model.InsStand; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
T_tb_TestReportData tTestReportData = new T_tb_TestReportData(); //检验报告数据 /// <summary> /// 原始记录文档在线编辑 /// </summary> /// <param name="InfoID">原始记录ID</param> /// <returns></returns> public ActionResult OriginalRecordDocEdit(int InfoID) { E_tb_OriginalRecord eOriginalRecord = _dOriginalRecord.GetModel(new E_tb_OriginalRecord() { RecordID = Convert.ToInt32(InfoID) }); E_tb_Project eProject = _dProject.GetModel(Convert.ToInt32(eOriginalRecord.ProjectID)); //判断是否已存在原始记录文件,若不存在默认读取检测项目对应的模板 string filepath = eProject.FilePath; if (System.IO.File.Exists(Server.MapPath("~/upfile/" + eOriginalRecord.FilePath))) { filepath = eOriginalRecord.FilePath; } //初始化PageOffice控件 PageOfficeCtrl pc = this.GetOfficeCtrl( "/OriginalRecordDoc/SaveDoc?filename=" + eOriginalRecord.FilePath, "/OriginalRecordDoc/SaveData?FilePath=" + eOriginalRecord.FilePath + "&ProjectID=" + eOriginalRecord.ProjectID + "&RecordID=" + InfoID, filepath); //定义提交数据范围 PageOffice.ExcelWriter.Workbook wb = new PageOffice.ExcelWriter.Workbook(); PageOffice.ExcelWriter.Sheet sheetOrder = wb.OpenSheet("Sheet1"); PageOffice.ExcelWriter.Table table = sheetOrder.OpenTable(eProject.SampleDataRange.Replace(":", ":").ToUpper()); pc.SetWriter(wb); //判断模板类型,是否为非农残检测项目 if (eOriginalRecord.IsPesCheck != 1) { PageOffice.ExcelWriter.Workbook workBook = this.GetNoPesCheckWorkbook(Convert.ToInt32(eOriginalRecord.SampleID), eProject.SampleDataRange); pc.SetWriter(workBook);// 注意不要忘记此代码,如果缺少此句代码,不会赋值成功。 } //实例化控件输出内容 Page page = new Page(); page.Controls.Add(pc); StringBuilder controlOutput = new StringBuilder(); using (StringWriter sw = new StringWriter(controlOutput)) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { Server.Execute(page, htw, false); } } ViewBag.EditorHtml = controlOutput.ToString(); return(View("/views/OriginalRecord/FileView.cshtml")); }
//*********************************原有代码**************************************************** /// <summary> /// 阅览文件 /// 作者:章建国 /// </summary> /// <param name="id">主键ID</param> /// <returns></returns> public JsonResult GetFileURLForView(int wid) { E_tb_OriginalRecord eOriginalRecord = _dOriginalRecord.GetModel(new E_tb_OriginalRecord() { RecordID = wid }); E_tb_Project eProject = tProject.GetModel(Convert.ToInt32(eOriginalRecord.ProjectID)); string SaveFilePage = "/OriginalRecord/SaveDoc?filename=" + eOriginalRecord.FilePath; string SaveDataPage = "/OriginalRecord/SaveData?FilePath=" + eOriginalRecord.FilePath + "|ProjectID=" + eOriginalRecord.ProjectID.ToString(); string DataRange = eProject.SampleDataRange.Replace(":", ":").ToUpper(); string UrlParams = string.Format("filename={0}&SaveFilePage={1}&SaveDataPage={2}&DataRange={3}", eOriginalRecord.FilePath, SaveFilePage, SaveDataPage, DataRange); return(Json(UrlParams, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 保存实验室信息 /// </summary> /// <param name="eOriginalRecord">要处理的对象</param> /// <returns>返回是否处理成功</returns> public JsonResult Save(E_tb_OriginalRecord eOriginalRecord) { eOriginalRecord.AreaID = CurrentUserInfo.AreaID; eOriginalRecord.EditPersonnelID = CurrentUserInfo.PersonnelID; bool result = tOriginalRecord.Update(eOriginalRecord); //关联样品数据(废弃,因无录入行为) //tRecordSample.UpdateRecordIDByFilePath(eOriginalRecord.RecordID, eOriginalRecord.FilePath); ////生成检验报告(该功能有前台触发) //E_tb_ExpePlan eExpePlan = tExpePlan.GetModelList("TaskNo='" + eOriginalRecord.TaskNo + "' and SampleID=" + eOriginalRecord.SampleID.Value).FirstOrDefault(); //Updatethings(eOriginalRecord, eExpePlan); return(Json(new { result = result, msg = "修改成功!" })); }
/// <summary> /// 获得数据列表 /// </summary> public List <E_tb_OriginalRecord> DataTableToList(DataTable dt) { List <E_tb_OriginalRecord> modelList = new List <E_tb_OriginalRecord>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { E_tb_OriginalRecord model; for (int n = 0; n < rowsCount; n++) { model = new E_tb_OriginalRecord(); if (dt.Rows[n]["RecordID"].ToString() != "") { model.RecordID = int.Parse(dt.Rows[n]["RecordID"].ToString()); } if (dt.Rows[n]["ProjectID"].ToString() != "") { model.ProjectID = int.Parse(dt.Rows[n]["ProjectID"].ToString()); } model.TaskNo = dt.Rows[n]["TaskNo"].ToString(); if (dt.Rows[n]["DetectTime"].ToString() != "") { model.DetectTime = DateTime.Parse(dt.Rows[n]["DetectTime"].ToString()); } if (dt.Rows[n]["DetectPersonnelID"].ToString() != "") { model.DetectPersonnelID = int.Parse(dt.Rows[n]["DetectPersonnelID"].ToString()); } model.FilePath = dt.Rows[n]["FilePath"].ToString(); model.Contents = dt.Rows[n]["Contents"].ToString(); if (dt.Rows[n]["AreaID"].ToString() != "") { model.AreaID = int.Parse(dt.Rows[n]["AreaID"].ToString()); } if (dt.Rows[n]["EditPersonnelID"].ToString() != "") { model.EditPersonnelID = int.Parse(dt.Rows[n]["EditPersonnelID"].ToString()); } if (dt.Rows[n]["SampleID"].ToString() != "") { model.SampleID = int.Parse(dt.Rows[n]["SampleID"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_OriginalRecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_OriginalRecord("); strSql.Append("ProjectID,TaskNo,DetectTime,DetectPersonnelID,FilePath,Contents,AreaID,EditPersonnelID,SampleID,InsStand)"); strSql.Append(" values ("); strSql.Append("@ProjectID,@TaskNo,@DetectTime,@DetectPersonnelID,@FilePath,@Contents,@AreaID,@EditPersonnelID,@SampleID,@InsStand)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ProjectID", SqlDbType.Int, 4), new SqlParameter("@TaskNo", SqlDbType.NVarChar, 50), new SqlParameter("@DetectTime", SqlDbType.DateTime), new SqlParameter("@DetectPersonnelID", SqlDbType.Int, 4), new SqlParameter("@FilePath", SqlDbType.NVarChar, 150), new SqlParameter("@Contents", SqlDbType.NVarChar, 200), new SqlParameter("@AreaID", SqlDbType.Int, 4), new SqlParameter("@EditPersonnelID", SqlDbType.Int, 4), new SqlParameter("@SampleID", SqlDbType.Int, 4), new SqlParameter("@InsStand", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.ProjectID; parameters[1].Value = model.TaskNo; parameters[2].Value = model.DetectTime; parameters[3].Value = model.DetectPersonnelID; parameters[4].Value = model.FilePath; parameters[5].Value = model.Contents; parameters[6].Value = model.AreaID; parameters[7].Value = model.EditPersonnelID; parameters[8].Value = model.SampleID; parameters[9].Value = model.InsStand; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { model.RecordID = Convert.ToInt32(obj); return(Convert.ToInt32(obj)); } }
/// <summary> /// 显示详情页 /// </summary> /// <param name="EditType">编辑类型</param> /// <returns>返回编辑结果</returns> public ActionResult OriginalRecordEdit(int InfoID) { E_tb_OriginalRecord eOriginalRecord = _dOriginalRecord.GetModel(new E_tb_OriginalRecord() { RecordID = Convert.ToInt32(InfoID) }); List <string> InsStandList = new List <string>(); E_tb_Project eProject = _dProject.GetModel(Convert.ToInt32(eOriginalRecord.ProjectID)); if (!string.IsNullOrEmpty(eProject.InsStand)) { foreach (var item in eProject.InsStand.Split('、')) { InsStandList.Add(item); } } ViewBag.DetectPersonnelID = CurrentUserInfo.PersonnelID; ViewBag.DetectPersonnelName = CurrentUserInfo.PersonnelName; ViewData["InsStandList"] = InsStandList; return(View(eOriginalRecord)); }
/// <summary> /// 得到一个对象实体 /// </summary> public E_tb_OriginalRecord GetModel(E_tb_OriginalRecord model) { StringBuilder strSql = new StringBuilder(); strSql.Append($@"select A.*, B.PersonnelName as detectpersonnelname, --检查人名称 C.SampleDataRange, --检查项目对应数据提取范围 C.IsPesCheck, --是否农药残留 C.projectname, --项目名称 D.name as samplename --样品名称 from tb_OriginalRecord as A left join dbo.tb_InPersonnel as B on A.DetectPersonnelID=B.PersonnelID left join dbo.tb_Project as C on A.ProjectID=C.ProjectID left join dbo.tb_Sample as D on A.SampleID=D.id where RecordID={model.RecordID}"); using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString())) { model = conn.Query <E_tb_OriginalRecord>(strSql.ToString(), model)?.FirstOrDefault(); } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(E_tb_OriginalRecord model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(E_tb_OriginalRecord model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public E_tb_OriginalRecord GetModel(int RecordID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from tb_OriginalRecord"); strSql.Append(" where RecordID=@RecordID"); SqlParameter[] parameters = { new SqlParameter("@RecordID", SqlDbType.Int, 4) }; parameters[0].Value = RecordID; E_tb_OriginalRecord model = new E_tb_OriginalRecord(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RecordID"].ToString() != "") { model.RecordID = int.Parse(ds.Tables[0].Rows[0]["RecordID"].ToString()); } if (ds.Tables[0].Rows[0]["ProjectID"].ToString() != "") { model.ProjectID = int.Parse(ds.Tables[0].Rows[0]["ProjectID"].ToString()); } if (ds.Tables[0].Rows[0]["TaskNo"] != null) { model.TaskNo = ds.Tables[0].Rows[0]["TaskNo"].ToString(); } if (ds.Tables[0].Rows[0]["DetectTime"].ToString() != "") { model.DetectTime = DateTime.Parse(ds.Tables[0].Rows[0]["DetectTime"].ToString()); } if (ds.Tables[0].Rows[0]["DetectPersonnelID"].ToString() != "") { model.DetectPersonnelID = int.Parse(ds.Tables[0].Rows[0]["DetectPersonnelID"].ToString()); } if (ds.Tables[0].Rows[0]["FilePath"] != null) { model.FilePath = ds.Tables[0].Rows[0]["FilePath"].ToString(); } if (ds.Tables[0].Rows[0]["Contents"] != null) { model.Contents = ds.Tables[0].Rows[0]["Contents"].ToString(); } if (ds.Tables[0].Rows[0]["AreaID"].ToString() != "") { model.AreaID = int.Parse(ds.Tables[0].Rows[0]["AreaID"].ToString()); } if (ds.Tables[0].Rows[0]["EditPersonnelID"].ToString() != "") { model.EditPersonnelID = int.Parse(ds.Tables[0].Rows[0]["EditPersonnelID"].ToString()); } if (ds.Tables[0].Rows[0]["SampleID"].ToString() != "") { model.SampleID = int.Parse(ds.Tables[0].Rows[0]["SampleID"].ToString()); } if (ds.Tables[0].Rows[0]["InsStand"] != null) { model.InsStand = ds.Tables[0].Rows[0]["InsStand"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新检验报告 /// </summary> /// <param name="eOriginalRecord"></param> /// <param name="eExpePlan"></param> public JsonResult UpdateTestReport(int RecordID) { E_tb_OriginalRecord eOriginalRecord = _dOriginalRecord.GetModel(new E_tb_OriginalRecord() { RecordID = RecordID }); E_tb_ExpePlan eExpePlan = _dExpePlan.GetExpePlanInfo(new E_tb_ExpePlan() { TaskNo = eOriginalRecord.TaskNo }); tb_Sample eSample = tSample.GetModel(eOriginalRecord.SampleID.Value); string productNum = eSample.protNum;//产品批次 E_tb_TestReport eTestReport = null; var tempmodel = tTestReport.GetModelList(" A.SampleNum = '" + eSample.sampleNum + "'"); if (tempmodel != null && tempmodel.Count > 0) { eTestReport = tempmodel.First(); eTestReport.SampleNum = eSample.sampleNum; //样品编号 eTestReport.SampleName = eSample.name; //样品名称 } if (eTestReport == null) { eTestReport = new E_tb_TestReport(); eTestReport.productNum = productNum; //批次号 eTestReport.SampleNum = eSample.sampleNum; //样品编号 eTestReport.SampleName = eSample.name; //样品名称 eTestReport.ProductionTime = eSample.productDate; //生产日期 eTestReport.Specifications = eSample.modelType; //规格型号 eTestReport.ShelfLife = eSample.expirationDate; //保质期 string Department = "/"; if (eSample.isDetection) { Department = eSample.detectionCompany; } else { var client = new BLL.ClientManage.T_tb_ClientManage().GetModel(Convert.ToInt32(eSample.InspectCompany)); Department = (client != null ? client.ClientName : ""); } eTestReport.Department = Department; //送/抽检单位 eTestReport.SendTestAddress = eSample.InspectAddress; //送检单位地址 eTestReport.SamplingPlace = eSample.detectionAdress; //抽样地点 eTestReport.SamplingCompany = eSample.detectionCompany; //抽样单位 eTestReport.SamplingPersonnel = eSample.detectionUser; //抽样者 eTestReport.Packing = eSample.packaging; //包装形式 eTestReport.SamplingTime = eSample.detectionDate; //抽样日期 eTestReport.TestBasis = new BLL.Laboratory.T_tb_Project().GetModel(eOriginalRecord.ProjectID.Value).ExpeMethod; eTestReport.TestTime = eOriginalRecord.DetectTime; //检验日期 DataTable dt = tOriginalRecord.GetRecordIDListBySampleID(int.Parse(eExpePlan.SampleID.ToString())); string RecordIDS = ""; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { RecordIDS += dt.Rows[i]["RecordID"].ToString() + ","; } RecordIDS = RecordIDS.TrimEnd(','); } eTestReport.RecordIDS = RecordIDS;//原始记录IDS DataTable dtExpePlan = tExpePlan.GetList("SampleID=" + eExpePlan.SampleID.ToString()).Tables[0]; string TaskNoS = ""; if (dtExpePlan != null && dtExpePlan.Rows.Count > 0) { for (int i = 0; i < dtExpePlan.Rows.Count; i++) { TaskNoS += dtExpePlan.Rows[i]["PlanID"].ToString() + ","; } TaskNoS = TaskNoS.TrimEnd(','); } eTestReport.TaskNoS = TaskNoS;//任务单号 对应的检验计划IDS eTestReport.EditPersonnelID = CurrentUserInfo.PersonnelID; eTestReport.AreaID = CurrentUserInfo.AreaID; eTestReport.AddTime = Convert.ToDateTime(DateTime.Now.ToShortDateString()); eTestReport.UpdateTime = DateTime.Now; eTestReport.ReportID = tTestReport.Add(eTestReport); } else { DataTable dt = tOriginalRecord.GetRecordIDListBySampleID(int.Parse(eExpePlan.SampleID.ToString())); string RecordIDS = ""; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { RecordIDS += dt.Rows[i]["RecordID"].ToString() + ","; } RecordIDS = RecordIDS.TrimEnd(','); } eTestReport.RecordIDS = RecordIDS;//原始记录IDS DataTable dtExpePlan = tExpePlan.GetList("SampleID=" + eExpePlan.SampleID.ToString()).Tables[0]; string TaskNoS = ""; if (dtExpePlan != null && dtExpePlan.Rows.Count > 0) { for (int i = 0; i < dtExpePlan.Rows.Count; i++) { TaskNoS += dtExpePlan.Rows[i]["PlanID"].ToString() + ","; } TaskNoS = TaskNoS.TrimEnd(','); } eTestReport.TaskNoS = TaskNoS;//任务单号 对应的检验计划IDS eTestReport.AreaID = CurrentUserInfo.AreaID; eTestReport.EditPersonnelID = CurrentUserInfo.PersonnelID; eTestReport.UpdateTime = DateTime.Now; eTestReport.TestBasis = new BLL.Laboratory.T_tb_Project().GetModel(eOriginalRecord.ProjectID.Value).ExpeMethod; tTestReport.Update(eTestReport); } //更新检验报告数据 List <E_tb_TestReportData> eTestReportDataList = tTestReportData.GetModelList("RecordFilePath='" + eOriginalRecord.FilePath + "'"); if (eTestReportDataList != null) { E_tb_Project eProject = tProject.GetModel(Convert.ToInt32(eOriginalRecord.ProjectID)); if (eProject.IsPesCheck != null && int.Parse(eProject.IsPesCheck.ToString()) == 1)//判断是否为农药残留检查项目 { foreach (E_tb_TestReportData eTestReportData in eTestReportDataList) { eTestReportData.RecordID = eOriginalRecord.RecordID; //原始记录ID eTestReportData.ReportID = eTestReport.ReportID; //检验报告ID eTestReportData.TestStandard = eProject.ExpeMethod; //检验标准 if (!String.IsNullOrEmpty(eOriginalRecord.InsStand)) { String[] strs = eOriginalRecord.InsStand.Split(':'); if (strs == null || strs.Length <= 2) { strs = eOriginalRecord.InsStand.Split(':'); } if (strs != null && strs.Length >= 2) { String str = strs[1]; int result = 0; if (!String.IsNullOrEmpty(str)) { // 正则表达式剔除非数字字符(不包含小数点.) str = Regex.Replace(str, @"[^\d.\d]", ""); // 如果是数字,则转换为decimal类型 if (Regex.IsMatch(str, @"^[+-]?\d*[.]?\d*$")) { result = int.Parse(str); } if (!String.IsNullOrEmpty(eTestReportData.TestResult)) { Decimal _testResult = Convert.ToDecimal(eTestReportData.TestResult); if (_testResult <= result) { eTestReportData.QualifiedLevel = "合格"; } else { eTestReportData.QualifiedLevel = "不合格"; } } } } } tTestReportData.Update(eTestReportData); } } else { foreach (E_tb_TestReportData eTestReportData in eTestReportDataList) { eTestReportData.RecordID = eOriginalRecord.RecordID; //原始记录ID eTestReportData.ReportID = eTestReport.ReportID; //检验报告ID eTestReportData.TestName = eProject.ProjectName; //检验名称/检验项目名称 eTestReportData.TestStandard = eProject.ExpeMethod; //检验标准 if (!String.IsNullOrEmpty(eOriginalRecord.InsStand)) { String[] strs = eOriginalRecord.InsStand.Split(':'); if (strs == null || strs.Length <= 2) { strs = eOriginalRecord.InsStand.Split(':'); } if (strs != null && strs.Length >= 2) { String str = strs[1]; int result = 0; if (!String.IsNullOrEmpty(str)) { // 正则表达式剔除非数字字符(不包含小数点.) str = Regex.Replace(str, @"[^\d.\d]", ""); // 如果是数字,则转换为decimal类型 if (Regex.IsMatch(str, @"^[+-]?\d*[.]?\d*$") && !string.IsNullOrEmpty(str)) { result = int.Parse(str); } if (!String.IsNullOrEmpty(eTestReportData.TestResult) && !string.IsNullOrEmpty(str)) { Decimal _testResult = Convert.ToDecimal(eTestReportData.TestResult); if (_testResult <= result) { eTestReportData.QualifiedLevel = "合格"; } else { eTestReportData.QualifiedLevel = "不合格"; } } } } } tTestReportData.Update(eTestReportData); } } } return(Json(new { result = true, msg = "更新成功!" }, JsonRequestBehavior.AllowGet)); }