/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TBaseMethodAnalysisVo TBaseMethodAnalysisVo = new TBaseMethodAnalysisVo(); TBaseMethodAnalysisVo.ID = Request["id"].ToString(); TBaseMethodAnalysisVo TBaseMethodAnalysisVoTemp = new TBaseMethodAnalysisLogic().Details(TBaseMethodAnalysisVo); return(ToJson(TBaseMethodAnalysisVoTemp)); }
/// <summary> /// 修改数据 /// </summary> /// <returns></returns> public string frmUpdate() { TBaseMethodAnalysisVo TBaseMethodAnalysisVo = autoBindRequest(Request, new TBaseMethodAnalysisVo()); TBaseMethodAnalysisVo.ID = Request["id"].ToString(); bool isSuccess = new TBaseMethodAnalysisLogic().Edit(TBaseMethodAnalysisVo); if (isSuccess) { new PageBase().WriteLog("修改分析方法", "", new PageBase().LogInfo.UserInfo.USER_NAME + "修改分析方法" + TBaseMethodAnalysisVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
public static string deleteAnalysisInfo(string strValue) { TBaseMethodAnalysisVo TBaseMethodAnalysisVo = new TBaseMethodAnalysisVo(); TBaseMethodAnalysisVo.ID = strValue; TBaseMethodAnalysisVo.IS_DEL = "1"; bool isSuccess = new TBaseMethodAnalysisLogic().Edit(TBaseMethodAnalysisVo); if (isSuccess) { new PageBase().WriteLog("删除分析方法", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除分析方法" + TBaseMethodAnalysisVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 增加数据 /// </summary> /// <returns></returns> public string frmAdd() { TBaseMethodAnalysisVo TBaseMethodAnalysisVo = autoBindRequest(Request, new TBaseMethodAnalysisVo()); TBaseMethodAnalysisVo.ID = GetSerialNumber("Analysis_Id"); TBaseMethodAnalysisVo.METHOD_ID = Request["formObjId"].ToString(); TBaseMethodAnalysisVo.IS_DEL = "0"; bool isSuccess = new TBaseMethodAnalysisLogic().Create(TBaseMethodAnalysisVo); if (isSuccess) { new PageBase().WriteLog("新增分析方法", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增分析方法" + TBaseMethodAnalysisVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
//获取分析方法,仅为下拉框 弹出grid使用 private void GetMthods() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; int intPageIdx = Convert.ToInt32(Request.Params["page"]); int intPagesize = Convert.ToInt32(Request.Params["pagesize"]); string strSrhMONITOR_ID = (Request.Params["SrhMONITOR_ID"] != null) ? Request.Params["SrhMONITOR_ID"] : ""; string strSrhMethod_Code = (Request.Params["strSrhMethod_Code"] != null) ? Request.Params["strSrhMethod_Code"] : ""; string strSrhMethodSel_ItemID = Request.Params["MethodSel_ItemID"].ToString(); TBaseMethodAnalysisLogic logicMethod = new TBaseMethodAnalysisLogic(); int intTotalCount = logicMethod.GetSelectResultCount_ForSelectMethod_inItem(strSrhMethod_Code, strSrhMethodSel_ItemID);;//总计的数据条数 DataTable dt = logicMethod.SelectByTable_ForSelectMethod_inItem(strSrhMethod_Code, strSrhMethodSel_ItemID, intPageIdx, intPagesize); string strJson = CreateToJson(dt, intTotalCount); Response.Write(strJson); }
/// <summary> /// 获取分析方法信息 /// </summary> /// <param name="appId">仪器ID</param> /// <returns></returns> public string getAnalysisInfo(string appId) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TBaseMethodAnalysisVo TBaseMethodAnalysisVo = new TBaseMethodAnalysisVo(); TBaseMethodAnalysisVo.METHOD_ID = appId; TBaseMethodAnalysisVo.IS_DEL = "0"; TBaseMethodAnalysisVo.SORT_FIELD = strSortname; TBaseMethodAnalysisVo.SORT_TYPE = strSortorder; DataTable dt = new TBaseMethodAnalysisLogic().SelectByTable(TBaseMethodAnalysisVo, intPageIndex, intPageSize); int intTotalCount = new TBaseMethodAnalysisLogic().GetSelectResultCount(TBaseMethodAnalysisVo); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 获取指定监测项目的默认分析方法、依据 /// </summary> /// <param name="strItemID">监测项目ID</param> /// <param name="strAnalysisID">分析方法ID</param> /// <param name="strStandardID">方法依据ID</param> /// <param name="strCheckOut">最底检出限</param> protected void getMethod(string strItemID, ref string strAnalysisID, ref string strStandardID, ref string strCheckOut) { TBaseItemAnalysisVo objAnalysis = new TBaseItemAnalysisVo(); objAnalysis.ITEM_ID = strItemID; objAnalysis.IS_DEL = "0"; DataTable dtItemAnalysis = new TBaseItemAnalysisLogic().SelectByTable(objAnalysis); if (dtItemAnalysis.Rows.Count > 0) { for (int i = 0; i < dtItemAnalysis.Rows.Count; i++) { if (dtItemAnalysis.Rows[i]["IS_DEFAULT"].ToString() == "是")//默认负责人,否则取第一条方法 { strAnalysisID = dtItemAnalysis.Rows[i]["ID"].ToString(); strCheckOut = dtItemAnalysis.Rows[i]["LOWER_CHECKOUT"].ToString(); TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(dtItemAnalysis.Rows[i]["ANALYSIS_METHOD_ID"].ToString()); if (objMethod != null) { strStandardID = objMethod.METHOD_ID; } break;//默认方法 唯一 } else { strAnalysisID = dtItemAnalysis.Rows[0]["ID"].ToString(); strCheckOut = dtItemAnalysis.Rows[0]["LOWER_CHECKOUT"].ToString(); TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(dtItemAnalysis.Rows[0]["ANALYSIS_METHOD_ID"].ToString()); if (objMethod != null) { strStandardID = objMethod.METHOD_ID; } } } } }
private static bool createQcInfo(string strSubTaskId, string strQcType, string strItemId) { bool isSuccess = true; if (strItemId == "") { return(isSuccess); } TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); string strQcSampleId = GetSerialNumber("MonitorSampleId"); objSample.ID = strQcSampleId; objSample.SUBTASK_ID = strSubTaskId; objSample.QC_TYPE = strQcType; //objSample.SAMPLE_CODE = GetSampleCode_QHD(strQcSampleId); //新增点位时候,自动生成该点位的样品编码 TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); objSample.NOSAMPLE = "1"; if (strQcType == "10") { objSample.SAMPLE_NAME = "空白加标样"; } objSample.SAMPLE_COUNT = ""; //在样品表中添加样品数据 if (!new TMisMonitorSampleInfoLogic().Create(objSample)) { isSuccess = false; } //遍历监测项目信息,将监测项目信息添加到结果表、结果分析执行表、空白加标表中 for (int i = 0; i < strItemId.Split(',').Length; i++) { //将数据写入结果表中 TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = strQcSampleId; objResult.QC_TYPE = strQcType; objResult.ITEM_ID = strItemId.Split(',')[i]; //填充默认分析方法和方法依据 TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = objResult.ITEM_ID; objItemAnalysis.IS_DEFAULT = "是"; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); if (objItemAnalysis.ID.Length == 0) { objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = objResult.ITEM_ID; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); } if (objItemAnalysis.ID.Length > 0) { TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID); objResult.ANALYSIS_METHOD_ID = objMethod.ID; objResult.STANDARD_ID = objMethod.METHOD_ID; } objResult.ANALYSIS_METHOD_ID = ""; objResult.STANDARD_ID = ""; objResult.TASK_TYPE = "发送"; objResult.RESULT_STATUS = "01"; if (!new TMisMonitorResultLogic().Create(objResult)) { isSuccess = false; } //将数据写入结果分析执行表中 InsertResultAPP(objResult.ID); //将结果写入分析样结果表中 TMisMonitorQcAddQhdVo objQcAdd = new TMisMonitorQcAddQhdVo(); objQcAdd.ID = GetSerialNumber("QcAddId_QHD"); objQcAdd.RESULT_ID_ADD = objResult.ID; objQcAdd.QC_TYPE = strQcType; if (!new TMisMonitorQcAddQhdLogic().Create(objQcAdd)) { isSuccess = false; } } return(isSuccess); }
public static string CopyPointItem(string strCopyID, string strPastID, string strSubtaskID) { bool isSuccess = true; string strCopyPointID = new TMisMonitorSampleInfoLogic().Details(strCopyID).POINT_ID; string strPastPointID = new TMisMonitorSampleInfoLogic().Details(strPastID).POINT_ID; TMisMonitorTaskItemVo objPointItemCopy = new TMisMonitorTaskItemVo(); objPointItemCopy.IS_DEL = "0"; objPointItemCopy.TASK_POINT_ID = strCopyPointID; DataTable dtCopy = new TMisMonitorTaskItemLogic().SelectByTable(objPointItemCopy); TMisMonitorTaskItemVo objPointItemPast = new TMisMonitorTaskItemVo(); objPointItemPast.IS_DEL = "0"; objPointItemPast.TASK_POINT_ID = strPastPointID; DataTable dtPast = new TMisMonitorTaskItemLogic().SelectByTable(objPointItemPast); string strIsExistItem = ""; for (int i = 0; i < dtPast.Rows.Count; i++) { strIsExistItem += "," + dtPast.Rows[i]["ITEM_ID"].ToString(); } strIsExistItem += strIsExistItem.Length > 0 ? "," : ""; //获取粘贴样品ID,填充结果表数据 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strPastID); for (int i = 0; i < dtCopy.Rows.Count; i++) { DataRow dr = dtCopy.Rows[i]; string strCopyItemID = dr["ITEM_ID"].ToString(); if (!strIsExistItem.Contains(strCopyItemID)) { TMisMonitorTaskItemVo objPointItem = new TMisMonitorTaskItemVo(); objPointItem.ID = GetSerialNumber("t_base_company_point_item_id"); objPointItem.IS_DEL = "0"; objPointItem.TASK_POINT_ID = strPastPointID; objPointItem.ITEM_ID = strCopyItemID; isSuccess = new TMisMonitorTaskItemLogic().Create(objPointItem); TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = objSample.ID; objResult.ITEM_ID = strCopyItemID; objResult.QC_TYPE = objSample.QC_TYPE; objResult.RESULT_STATUS = "01"; //填充默认分析方法和方法依据 TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = strCopyItemID; objItemAnalysis.IS_DEFAULT = "是"; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); if (objItemAnalysis.ID.Length > 0) { TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID); objResult.ANALYSIS_METHOD_ID = objMethod.ID; objMethod.METHOD_ID = objMethod.METHOD_ID; } isSuccess = new TMisMonitorResultLogic().Create(objResult); string strAnalysisManagerID = ""; string strAnalysisManID = ""; TMisMonitorResultVo objResultTemp = new TMisMonitorResultVo(); objResultTemp.ID = objResult.ID; DataTable dtManager = new TMisMonitorResultLogic().SelectManagerByTable(objResultTemp); if (dtManager.Rows.Count > 0) { strAnalysisManagerID = dtManager.Rows[0]["ANALYSIS_MANAGER"].ToString(); strAnalysisManID = dtManager.Rows[0]["ANALYSIS_ID"].ToString(); } TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo(); objResultApp.ID = GetSerialNumber("MonitorResultAppId"); objResultApp.RESULT_ID = objResult.ID; objResultApp.HEAD_USERID = strAnalysisManagerID; objResultApp.ASSISTANT_USERID = strAnalysisManID; isSuccess = new TMisMonitorResultAppLogic().Create(objResultApp); } } if (isSuccess) { return("1"); } else { return("0"); } }
public static string SaveDataItem(string strSubtaskID, string strSample, string strSelItem_IDs) { bool isSuccess = true; string[] arrSelItemId = strSelItem_IDs.Split(','); TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strSample); TMisMonitorTaskItemVo objPointItemSet = new TMisMonitorTaskItemVo(); objPointItemSet.IS_DEL = "1"; TMisMonitorTaskItemVo objPointItemWhere = new TMisMonitorTaskItemVo(); objPointItemWhere.IS_DEL = "0"; objPointItemWhere.TASK_POINT_ID = objSample.POINT_ID; new TMisMonitorTaskItemLogic().Edit(objPointItemSet, objPointItemWhere); TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult = new TMisMonitorResultVo(); if (strSample.Length > 0) { objResult.SAMPLE_ID = strSample; new TMisMonitorResultLogic().Delete(objResult); } if (strSelItem_IDs.Length > 0) { for (int i = 0; i < arrSelItemId.Length; i++) { TMisMonitorTaskItemVo objPointItem = new TMisMonitorTaskItemVo(); objPointItem.ID = GetSerialNumber("t_mis_monitor_task_item_id"); objPointItem.IS_DEL = "0"; objPointItem.TASK_POINT_ID = objSample.POINT_ID; objPointItem.ITEM_ID = arrSelItemId[i]; isSuccess = new TMisMonitorTaskItemLogic().Create(objPointItem); objResult = new TMisMonitorResultVo(); objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = objSample.ID; objResult.ITEM_ID = arrSelItemId[i]; objResult.QC_TYPE = objSample.QC_TYPE; objResult.RESULT_STATUS = "01"; //填充默认分析方法和方法依据 TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = arrSelItemId[i]; objItemAnalysis.IS_DEFAULT = "是"; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); if (objItemAnalysis.ID.Length > 0) { TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID); objResult.ANALYSIS_METHOD_ID = objMethod.ID; objMethod.METHOD_ID = objMethod.METHOD_ID; } isSuccess = new TMisMonitorResultLogic().Create(objResult); string strAnalysisManagerID = ""; string strAnalysisManID = ""; TMisMonitorResultVo objResultTemp = new TMisMonitorResultVo(); objResultTemp.ID = objResult.ID; DataTable dtManager = new TMisMonitorResultLogic().SelectManagerByTable(objResultTemp); if (dtManager.Rows.Count > 0) { strAnalysisManagerID = dtManager.Rows[0]["ANALYSIS_MANAGER"].ToString(); strAnalysisManID = dtManager.Rows[0]["ANALYSIS_ID"].ToString(); } TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo(); objResultApp.ID = GetSerialNumber("MonitorResultAppId"); objResultApp.RESULT_ID = objResult.ID; objResultApp.HEAD_USERID = strAnalysisManagerID; objResultApp.ASSISTANT_USERID = strAnalysisManID; isSuccess = new TMisMonitorResultAppLogic().Create(objResultApp); } } if (isSuccess) { return("1"); } else { return("0"); } }
private static bool createQcInfo(string strSubTaskId, string strQcType, string strItemId, string strSumQcStandValue, string strSumQcUncetainty) { bool isSuccess = true; if (strItemId == "") { return(isSuccess); } //TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); //string strQcSampleId = GetSerialNumber("MonitorSampleId"); //objSample.ID = strItemId; //objSample.SUBTASK_ID = strSubTaskId; //objSample.QC_TYPE = strQcType; //string strSourceResultId = ""; TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strSubTaskId); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.QC_TYPE = strQcType; objSample.QC_SOURCE_ID = strSubTaskId; //objSample.SAMPLE_NAME += "现场加密"; //新增点位时候,自动生成该点位的样品编码 TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); //objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); objSample.NOSAMPLE = "0"; if (strQcType == "11") { objSample.SAMPLE_NAME += "现场加密"; } //在样品表中添加样品数据 if (!new TMisMonitorSampleInfoLogic().Create(objSample)) { isSuccess = false; } //遍历监测项目信息,将监测项目信息添加到结果表、结果分析执行表、标准盲样表中 for (int i = 0; i < strItemId.Split(',').Length; i++) { //将数据写入结果表中 TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = objSample.ID; objResult.QC_TYPE = strQcType; objResult.ITEM_ID = strItemId.Split(',')[i]; //填充默认分析方法和方法依据 TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = objResult.ITEM_ID; objItemAnalysis.IS_DEFAULT = "是"; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); if (objItemAnalysis.ID.Length == 0) { objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = objResult.ITEM_ID; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); } if (objItemAnalysis.ID.Length > 0) { TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID); objResult.ANALYSIS_METHOD_ID = objMethod.ID; objResult.STANDARD_ID = objMethod.METHOD_ID; } //objResult.ANALYSIS_METHOD_ID = ""; //objResult.STANDARD_ID = ""; objResult.TASK_TYPE = "发送"; objResult.RESULT_STATUS = "01"; if (!new TMisMonitorResultLogic().Create(objResult)) { isSuccess = false; } //将数据写入结果分析执行表中 InsertResultAPP(objResult.ID); //将结果写入盲样结果表中 TMisMonitorQcBlindZzVo TMisMonitorQcBlindZzVo = new TMisMonitorQcBlindZzVo(); TMisMonitorQcBlindZzVo.ID = GetSerialNumber("QcBlindId_ZZ"); TMisMonitorQcBlindZzVo.RESULT_ID = objResult.ID; TMisMonitorQcBlindZzVo.QC_TYPE = strQcType; TMisMonitorQcBlindZzVo.STANDARD_VALUE = strSumQcStandValue.Split(',')[i]; TMisMonitorQcBlindZzVo.UNCETAINTY = strSumQcUncetainty.Split(',')[i]; if (!new TMisMonitorQcBlindZzLogic().Create(TMisMonitorQcBlindZzVo)) { isSuccess = false; } } return(isSuccess); }