/// <summary> /// 获取监测项目信息 /// </summary> /// <returns></returns> private string getThreeGridInfo(string strTwoGridId, string strTaskID) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); var strCCflowWorkId = Request.QueryString["strCCflowWorkId"]; var identification = CCFlowFacade.GetFlowIdentification(LogInfo.UserInfo.USER_NAME, Convert.ToInt64(strCCflowWorkId)); var sampleIdList = identification.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries).ToList(); if (sampleIdList.Count > 0) { sampleIdList.RemoveAt(0); } DataTable dt = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet_MAS(strTaskID, strTwoGridId, "1,2"); var newDT = new DataTable(); foreach (DataColumn column in dt.Columns) { newDT.Columns.Add(column.ColumnName); } //样品编号生成 for (int i = 0; i < dt.Rows.Count; i++) { if (sampleIdList.Count > 0 && !sampleIdList.Contains(dt.Rows[i]["ID"].ToString())) { continue; } TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString()); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); if (objSample.SAMPLE_CODE.Length == 0) { //objSample.SAMPLE_CODE = GetSampleCode_QHD(dt.Rows[i]["ID"].ToString()); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); if (objTask.TASK_TYPE == "1") { objSample.SAMPLE_CODE = objSample.SAMPLE_NAME; } else { objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); } new TMisMonitorSampleInfoLogic().Edit(objSample); dt.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE; } //样品状态,外委除外(废水、地表水) if (objTask.CONTRACT_TYPE != "04") { DataTable dtAtt = new DataTable(); string strAttValue = string.Empty; string strAttID = "''"; if (objSubtask.MONITOR_ID == "000000001" || objSubtask.MONITOR_ID == "EnvDrinkingSource") { strAttID = "'000000017'"; } if (objSubtask.MONITOR_ID == "EnvRiver") { strAttID = "'000000211'"; } dtAtt = new i3.BusinessLogic.Channels.Base.DynamicAttribute.TBaseAttributeInfoLogic().GetAttValue(strAttID, dt.Rows[i]["POINT_ID"].ToString()); for (int j = 0; j < dtAtt.Rows.Count; j++) { strAttValue += dtAtt.Rows[j]["ATTRBUTE_TEXT"].ToString() + "、"; } dt.Rows[i]["SAMPLE_STATUS"] = strAttValue.TrimEnd('、'); } newDT.Rows.Add(dt.Rows[i].ItemArray); } int intTotalCount = newDT.Rows.Count; string strJson = CreateToJson(newDT, intTotalCount); return(strJson); }
/// <summary> /// 获取监测项目信息 /// </summary> /// <returns></returns> private string getThreeGridInfo(string strTwoGridId, string strTaskID) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); DataTable dt = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet(strTaskID, strTwoGridId, "021"); //样品编号生成 for (int i = 0; i < dt.Rows.Count; i++) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString()); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); if (objSample.SAMPLE_CODE.Length == 0) { //objSample.SAMPLE_CODE = GetSampleCode_QHD(dt.Rows[i]["ID"].ToString()); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); if (objTask.TASK_TYPE == "1") { objSample.SAMPLE_CODE = objSample.SAMPLE_NAME; } else { objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); } new TMisMonitorSampleInfoLogic().Edit(objSample); dt.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE; } //样品状态,外委除外(废水、地表水) if (objTask.CONTRACT_TYPE != "04") { DataTable dtAtt = new DataTable(); string strAttValue = string.Empty; string strAttID = "''"; if (objSubtask.MONITOR_ID == "000000001") { strAttID = "'000000017'"; } if (objSubtask.MONITOR_ID == "EnvRiver") { strAttID = "'000000211'"; } dtAtt = new i3.BusinessLogic.Channels.Base.DynamicAttribute.TBaseAttributeInfoLogic().GetAttValue(strAttID, dt.Rows[i]["POINT_ID"].ToString()); for (int j = 0; j < dtAtt.Rows.Count; j++) { strAttValue += dtAtt.Rows[j]["ATTRBUTE_TEXT"].ToString() + "、"; } dt.Rows[i]["SAMPLE_STATUS"] = strAttValue.TrimEnd('、'); } } int intTotalCount = dt.Rows.Count; string strJson = CreateToJson(dt, intTotalCount); return(strJson); }