//获取点位信息 private string getPointList() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); if (strSortname == null || strSortname.Length < 0) { strSortname = TMisMonitorTaskPointVo.NUM_FIELD; } if (this.SUBTASK_ID.Value.Length == 0) { return(""); } if (this.MONITOR_ID.Value.Trim() == "FunctionNoise") { //如果是功能区噪声需要按一天24小时拆分样品 SplitFunctionNoiseByHour(this.SUBTASK_ID.Value.Trim()); } TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo(); objSampleInfo.SUBTASK_ID = this.SUBTASK_ID.Value; objSampleInfo.QC_TYPE = "0"; objSampleInfo.SORT_FIELD = "POINT_ID"; objSampleInfo.SORT_TYPE = "asc"; DataTable dtSample = new DataTable(); DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTable(objSampleInfo, intPageIndex, intPageSize); string strUnit = ""; if (this.MONITOR_ID.Value.Trim() == "000000004") { strUnit = "dB(A)"; } dtSample = new TMisMonitorSubtaskLogic().getItemBySubTaskID(this.SUBTASK_ID.Value.Trim()); for (int i = 0; i < dtSample.Rows.Count; i++) { dt.Columns.Add(dtSample.Rows[i]["ID"].ToString() + "@@" + dtSample.Rows[i]["ITEM_NAME"].ToString() + strUnit, typeof(string)); } for (int i = 0; i < dt.Rows.Count; i++) { dtSample = new TMisMonitorSubtaskLogic().getItemValueBySampleID(dt.Rows[i]["ID"].ToString()); for (int j = 0; j < dtSample.Rows.Count; j++) { dt.Rows[i][dtSample.Rows[j]["ID"].ToString() + "@@" + dtSample.Rows[j]["ITEM_NAME"].ToString() + strUnit] = dtSample.Rows[j]["ITEM_RESULT"].ToString(); } } int intTotalCount = new TMisMonitorSampleInfoLogic().GetSelectResultCount(objSampleInfo); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 发送到下一环节 /// </summary> /// <param name="strTaskId">任务ID</param> /// <returns></returns> public string SendToNext(string strTaskId) { bool IsSuccess = true; //把样品从交接发送到分配环节 DataTable dtSample = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet_QHD(strTaskId, "", "021,02"); for (int i = 0; i < dtSample.Rows.Count; i++) { TMisMonitorSampleInfoVo objSampleVo = new TMisMonitorSampleInfoVo(); objSampleVo.ID = dtSample.Rows[i]["ID"].ToString(); objSampleVo.NOSAMPLE = "2"; IsSuccess = new TMisMonitorSampleInfoLogic().Edit(objSampleVo); } //如果子任务的样品都采样完,刚更新子任务的状态 DataTable dt = new TMisMonitorResultLogic().getItemTypeInfo_QHD(strTaskId, "021", "01", "2", true); for (int i = 0; i < dt.Rows.Count; i++) { string strMonitorID = dt.Rows[i]["MONITOR_ID"].ToString(); TMisMonitorSubtaskVo objSsubtask = new TMisMonitorSubtaskVo(); objSsubtask.TASK_ID = strTaskId; objSsubtask.MONITOR_ID = strMonitorID; objSsubtask = new TMisMonitorSubtaskLogic().Details(objSsubtask); objSsubtask.SAMPLE_ACCESS_ID = LogInfo.UserInfo.ID; objSsubtask.TASK_STATUS = "03"; if (!new TMisMonitorSubtaskLogic().Edit(objSsubtask)) { IsSuccess = false; } } return(IsSuccess == true ? "1" : "0"); }
public void SplitFunctionNoiseByHour(string strSubTaskID) { TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskLogic().Details(strSubTaskID); if (objSubtaskVo.SAMPLING_METHOD != "1") //SAMPLE_METHOD='1'时表示该任务已进行了拆分 { objSubtaskVo.SAMPLING_METHOD = "1"; List <TMisMonitorSampleInfoVo> listSample = new List <TMisMonitorSampleInfoVo>(); TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.SUBTASK_ID = strSubTaskID; TMisMonitorSampleInfoVo objSampleSet = new TMisMonitorSampleInfoVo(); objSampleSet.ENV_HOUR = "0"; new TMisMonitorSampleInfoLogic().Edit(objSampleSet, objSample); listSample = new TMisMonitorSampleInfoLogic().SelectByObject(objSample, 0, 0); for (int i = 0; i < listSample.Count; i++) { objSample = listSample[i]; TMisMonitorResultVo objResultVo = new TMisMonitorResultVo(); objResultVo.SAMPLE_ID = objSample.ID; List <TMisMonitorResultVo> listResult = new List <TMisMonitorResultVo>(); listResult = new TMisMonitorResultLogic().SelectByObject(objResultVo, 0, 0); for (int j = 1; j < 24; j++) { objSampleSet = new TMisMonitorSampleInfoVo(); CopyObject(objSample, objSampleSet); objSampleSet.ID = GetSerialNumber("MonitorSampleId"); objSampleSet.ENV_HOUR = j.ToString(); for (int k = 0; k < listResult.Count; k++) { objResultVo = listResult[k]; TMisMonitorResultVo objResultAdd = new TMisMonitorResultVo(); CopyObject(objResultVo, objResultAdd); objResultAdd.ID = GetSerialNumber("MonitorResultId"); objResultAdd.SAMPLE_ID = objSampleSet.ID; TMisMonitorResultAppVo objResultAppVo = new TMisMonitorResultAppVo(); objResultAppVo.RESULT_ID = objResultVo.ID; objResultAppVo = new TMisMonitorResultAppLogic().Details(objResultAppVo); TMisMonitorResultAppVo objResultAppAdd = new TMisMonitorResultAppVo(); CopyObject(objResultAppVo, objResultAppAdd); objResultAppAdd.ID = GetSerialNumber("MonitorResultAppId"); objResultAppAdd.RESULT_ID = objResultAdd.ID; new TMisMonitorResultLogic().Create(objResultAdd); new TMisMonitorResultAppLogic().Create(objResultAppAdd); } new TMisMonitorSampleInfoLogic().Create(objSampleSet); } } new TMisMonitorSubtaskLogic().Edit(objSubtaskVo); } }
public static string saveSampleCode(string id, string strSampleCode, string strIsOk, string strAskingdate) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.ID = id; objSample.SAMPLE_CODE = strSampleCode; objSample.REMARK4 = strIsOk == "" ? "###" : strIsOk; objSample.REMARK5 = strAskingdate == "" ? "###" : UTCConvert(strAskingdate); bool isSuccess = new TMisMonitorSampleInfoLogic().Edit(objSample); return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 更新样品子样数据 /// </summary> /// <returns></returns> public string UpdateSample() { string result = ""; TMisMonitorSampleInfoVo objItems = new TMisMonitorSampleInfoVo(); objItems.ID = strSampleId; objItems.SUBSAMPLE_NUM = strSubSampleNum; if (new TMisMonitorSampleInfoLogic().Edit(objItems)) { result = "true"; } return(result); }
public static string saveSample(string id, string strSubtaskID, string strSampleCode, string strSampleName, string strOriginalNum, string strSampleDes) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample = new TMisMonitorSampleInfoLogic().Details(id); objSample.SAMPLE_CODE = strSampleCode; objSample.SAMPLE_NAME = strSampleName; objSample.REMARK2 = strOriginalNum == "" ? "###" : strOriginalNum; objSample.REMARK3 = strSampleDes == "" ? "###" : strSampleDes; bool isSuccess = new TMisMonitorSampleInfoLogic().Edit(objSample); return(isSuccess == true ? "1" : "0"); }
//获取点位信息 private string getPointList() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); if (strSortname == null || strSortname.Length < 0) { strSortname = TMisMonitorTaskPointVo.NUM_FIELD; } string strSubtaskID = this.SUBTASK_ID.Value; if (strSubtaskID.Length == 0) { return(""); } TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo(); objSampleInfo.SUBTASK_ID = strSubtaskID; //objSampleInfo.QC_TYPE = "0"; objSampleInfo.SORT_FIELD = "ISNULL(SAMPLE_COUNT,'9999'),POINT_ID,ID"; objSampleInfo.NOSAMPLE = "0"; DataTable dtSample = new DataTable(); DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, intPageIndex, intPageSize); dtSample = dt.Clone(); for (int i = 0; i < dt.Rows.Count; i++) { dtSample.ImportRow(dt.Rows[i]); //objSampleInfo.QC_TYPE = ""; //objSampleInfo.QC_SOURCE_ID = dt.Rows[i]["ID"].ToString(); //objSampleInfo.SORT_FIELD = "QC_TYPE"; //objSampleInfo.NOSAMPLE = "0"; //DataTable dtQcSample = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, 0, 0); //for (int j = 0; j < dtQcSample.Rows.Count; j++) //{ // DataRow dr = dt.NewRow(); // dr = dtQcSample.Rows[j]; // dtSample.ImportRow(dr); //} } int intTotalCount = dtSample.Rows.Count; string strJson = CreateToJson(dtSample, intTotalCount); return(strJson); }
public string SaveUserInfo() { var sampleIds = this.strSampleIds.Value; bool isSuccess = true; var logic = new TMisMonitorSampleInfoLogic(); var sampleIdList = sampleIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (var sampleId in sampleIdList) { TMisMonitorSampleInfoVo vo = logic.Details(sampleId); vo.REMARK5 = Request["DEFAULT_USER"]; logic.Edit(vo); } return(isSuccess == true ? "1" : "0"); }
//获取点位信息 private string getPointList() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); if (strSortname == null || strSortname.Length < 0) { strSortname = TMisMonitorTaskPointVo.NUM_FIELD; } string strSubtaskID = this.SUBTASK_ID.Value; if (strSubtaskID.Length == 0) { return(""); } TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo(); objSampleInfo.SUBTASK_ID = strSubtaskID; objSampleInfo.QC_TYPE = "0"; objSampleInfo.SORT_FIELD = "POINT_ID"; DataTable dtSample = new DataTable(); DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, intPageIndex, intPageSize); dtSample = dt.Clone(); for (int i = 0; i < dt.Rows.Count; i++) { dtSample.ImportRow(dt.Rows[i]); objSampleInfo.QC_TYPE = ""; objSampleInfo.QC_SOURCE_ID = dt.Rows[i]["ID"].ToString(); objSampleInfo.SORT_FIELD = "QC_TYPE"; DataTable dtQcSample = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, 0, 0); for (int j = 0; j < dtQcSample.Rows.Count; j++) { DataRow dr = dt.NewRow(); dr = dtQcSample.Rows[j]; //清远 生成样品编号(质控) TMisMonitorSampleInfoVo objSampleQc = new TMisMonitorSampleInfoLogic().Details(dr["ID"].ToString()); if (objSampleQc.SAMPLE_CODE.Length == 0) { objSampleQc.SAMPLE_CODE = GetSampleCode(dr["ID"].ToString()); objSampleQc.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); new TMisMonitorSampleInfoLogic().Edit(objSampleQc); dr["SAMPLE_CODE"] = objSampleQc.SAMPLE_CODE; } dtSample.ImportRow(dr); } //清远 采样时自动生成样品编号(原始样) TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString()); if (objSample.SAMPLE_CODE.Length == 0) { objSample.SAMPLE_CODE = GetSampleCode(dt.Rows[i]["ID"].ToString()); objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); new TMisMonitorSampleInfoLogic().Edit(objSample); dtSample.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE; } } int intTotalCount = dtSample.Rows.Count; string strJson = CreateToJson(dtSample, intTotalCount); return(strJson); }