/// <summary> /// 获得包含现场项目的点位信息 /// </summary> /// <returns>Json</returns> protected string GetPointInfo() { 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 TMisMonitorTaskPointLogic().SelectSampleDeptPoint(this.SUBTASK_ID.Value, "1,2", sampleIdList: sampleIdList); int intTotalCount = dt.Rows.Count; for (int i = 0; i < dt.Rows.Count; i++) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.POINT_ID = dt.Rows[i]["ID"].ToString(); objSample.SUBTASK_ID = this.SUBTASK_ID.Value; objSample = new TMisMonitorSampleInfoLogic().Details(objSample); dt.Rows[i]["REMARK1"] = objSample.SAMPLE_CODE; dt.Rows[i]["REMARK2"] = objSample.SAMPLE_NAME; } string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 点位描述信息拷贝 /// </summary> /// <returns></returns> protected void AttributeValueCopy() { TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointVo(); objTaskPoint.SUBTASK_ID = this.SUBTASK_ID.Value; DataTable dt = new TMisMonitorTaskPointLogic().SelectByTable(objTaskPoint); for (int i = 0; i < dt.Rows.Count; i++) { TBaseAttrbuteValueVo objAttrbuteValue = new TBaseAttrbuteValueVo(); objAttrbuteValue.OBJECT_ID = dt.Rows[i]["POINT_ID"].ToString(); TBaseAttrbuteValue3Vo objAttrbuteValue3 = new TBaseAttrbuteValue3Vo(); objAttrbuteValue3.OBJECT_ID = dt.Rows[i]["ID"].ToString(); DataTable dtAtt3 = new TBaseAttrbuteValue3Logic().SelectByTable(objAttrbuteValue3); if (dtAtt3.Rows.Count > 0) return; DataTable dtAtt = new TBaseAttrbuteValueLogic().SelectByTable(objAttrbuteValue); for (int j = 0; j < dtAtt.Rows.Count; j++) { objAttrbuteValue3 = new TBaseAttrbuteValue3Vo(); objAttrbuteValue3.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttrbuteValue3.OBJECT_TYPE = dtAtt.Rows[j]["OBJECT_TYPE"].ToString(); objAttrbuteValue3.OBJECT_ID = dt.Rows[i]["ID"].ToString(); objAttrbuteValue3.ATTRBUTE_CODE = dtAtt.Rows[j]["ATTRBUTE_CODE"].ToString(); objAttrbuteValue3.ATTRBUTE_VALUE = dtAtt.Rows[j]["ATTRBUTE_VALUE"].ToString(); objAttrbuteValue3.IS_DEL = dtAtt.Rows[j]["IS_DEL"].ToString(); new TBaseAttrbuteValue3Logic().Create(objAttrbuteValue3); } } }
//点位 private void GetPoint_UnderTask(string strContractID, string strSubTaskID, ref string strPointNames, ref string strFREQ, ref string strItemS) { TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo(); objSampleInfo.SUBTASK_ID = strSubTaskID; DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, 0, 0); string strtmpPointNameS = ""; string strtmpItems = ""; for (int i = 0; i < dt.Rows.Count; i++) { TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointLogic().Details(dt.Rows[i]["POINT_ID"].ToString()); if (!strtmpPointNameS.Contains(objTaskPoint.POINT_NAME)) { strtmpPointNameS += (strtmpPointNameS.Length > 0 ? "、" : "") + objTaskPoint.POINT_NAME; GetItem_UnderSample(dt.Rows[i]["ID"].ToString(), objTaskPoint.POINT_NAME, ref strtmpItems); TMisContractPointVo objContractPointVo = new TMisContractPointVo(); objContractPointVo = new TMisContractPointLogic().Details(objTaskPoint.CONTRACT_POINT_ID); strFREQ += (strFREQ.Length > 0 ? "\n" : "") + objTaskPoint.POINT_NAME + ":连续" + (objContractPointVo.SAMPLE_DAY == "" ? "1" : objContractPointVo.SAMPLE_DAY) + "天,每天" + (objContractPointVo.SAMPLE_FREQ == "" ? "1" : objContractPointVo.SAMPLE_FREQ) + "次"; } } strItemS += (strItemS.Length > 0 ? "\n" : "") + strtmpItems; strPointNames += (strPointNames.Length > 0 ? "\r\n" : "") + strtmpPointNameS; }
public static string discontinued(string strValue) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strValue); string strSubTaskID = objSample.SUBTASK_ID; bool isSuccess = new TMisContractPlanPointLogic().DelPlanPointForSampleDistr(objSample.POINT_ID); if (isSuccess) { isSuccess = new TMisMonitorTaskPointLogic().Delete(objSample.POINT_ID); isSuccess = new TMisMonitorSampleInfoLogic().Delete(strValue); TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult.SAMPLE_ID = strValue; isSuccess = new TMisMonitorResultLogic().Delete(objResult); } TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointVo(); objTaskPoint.SUBTASK_ID = strSubTaskID; DataTable dt = new TMisMonitorTaskPointLogic().SelectByTable(objTaskPoint); if (dt.Rows.Count == 0) { new TMisMonitorSubtaskLogic().Delete(strSubTaskID); return("2"); } return(isSuccess == true ? "1" : "0"); }
public static string saveSample(string id, string strSubtaskID, string strSampleCode, string strSampleName) { TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointLogic().Details(id); TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.SUBTASK_ID = strSubtaskID; objSample.POINT_ID = id; objSample = new TMisMonitorSampleInfoLogic().Details(objSample); objSample.SAMPLE_CODE = strSampleCode; objSample.SAMPLE_NAME = strSampleName; bool isSuccess = new TMisMonitorSampleInfoLogic().Edit(objSample); return(isSuccess == true ? "1" : "0"); }
public static string deletePoint(string strValue) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strValue); TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = objSample.POINT_ID; objPoint.IS_DEL = "1"; bool isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint); isSuccess = new TMisMonitorSampleInfoLogic().Delete(objSample); return(isSuccess == true ? "1" : "0"); }
public static string SaveDataAttr(string strPointID, string strAttrID, string strAttribute) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = strPointID; objPoint.DYNAMIC_ATTRIBUTE_ID = strAttrID; isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint); TBaseAttrbuteValue3Logic logicAttrValue = new TBaseAttrbuteValue3Logic(); //清掉原有动态属性值 TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo(); objAttrValueDelWhere.OBJECT_ID = strPointID; objAttrValueDelWhere.IS_DEL = "0"; TBaseAttrbuteValue3Vo objAttrValueDelSet = new TBaseAttrbuteValue3Vo(); objAttrValueDelSet.IS_DEL = "1"; logicAttrValue.Edit(objAttrValueDelSet, objAttrValueDelWhere); //新增动态属性值 if (strAttribute.Length > 0) { string[] arrAttribute = strAttribute.Split('='); for (int i = 0; i < arrAttribute.Length; i++) { string[] arrAttrValue = arrAttribute[i].Split('|'); TBaseAttrbuteValue3Vo objAttrValueAdd = new TBaseAttrbuteValue3Vo(); objAttrValueAdd.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttrValueAdd.IS_DEL = "0"; objAttrValueAdd.OBJECT_TYPE = arrAttrValue[0]; objAttrValueAdd.OBJECT_ID = strPointID; objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1]; objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2]; isSuccess = logicAttrValue.Create(objAttrValueAdd); } } if (isSuccess) { return("1"); } else { return("0"); } }
//获取点位对应的动态属性值 private void GetAttrValue(string strID) { TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointLogic().Details(strID); TBaseAttrbuteValue3Vo objAttrValue = new TBaseAttrbuteValue3Vo(); objAttrValue.IS_DEL = "0"; objAttrValue.OBJECT_ID = strID; DataTable dt = new TBaseAttrbuteValue3Logic().SelectByTable(objAttrValue); string strJson = DataTableToJson(dt); Response.Write(strJson); Response.End(); }
/// <summary> /// 生成并保存监测结论 /// </summary> /// <param name="strTaskID">监测任务ID</param> /// <param name="strSubTaskID">监测子任务ID</param> /// <returns>监测子任务结论</returns> protected string GetConclusion(string strTaskID, string strSubTaskID) { string strConclusion = ""; //监测点位 TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointVo(); objTaskPoint.TASK_ID = strTaskID; objTaskPoint.SUBTASK_ID = strSubTaskID; objTaskPoint.IS_DEL = "0"; DataTable dtTaskItem = new TMisMonitorTaskPointLogic().SelectTaskItemByPoint(objTaskPoint); if (dtTaskItem.Rows.Count > 0) { string strErrItem = ""; //超标项目 string strErrItemID = ""; //超标项目ID for (int i = 0; i < dtTaskItem.Rows.Count; i++) { DataRow dr = dtTaskItem.Rows[i] as DataRow; //生成监测结论 if (dr["CONDITION_ID"].ToString().Length > 0) { //获得标准、依据名称 strConclusion = getStandardName(dr["CONDITION_ID"].ToString()); //记录超标项目信息 strErrItemID += !strErrItemID.Contains(dr["ITEM_ID"].ToString()) ? (IsOver(dr["ITEM_ID"].ToString(), dr["TASK_POINT_ID"].ToString()) ? dr["ITEM_ID"].ToString() : "") + "、" : ""; if (strErrItemID.Contains(dr["ITEM_ID"].ToString())) { string strItemName = new TBaseItemInfoLogic().Details(dr["ITEM_ID"].ToString()).ITEM_NAME; if (!strErrItem.Contains(strItemName)) { strErrItem += strItemName + "、"; } } //构造监测结论语句 if (strErrItem.Length > 0) { strConclusion += "本次监测该单位" + dr["POINT_NAME"].ToString() + "除" + strErrItem.Remove(strErrItem.LastIndexOf("、")) + "外,其它项目达标"; } else { strConclusion += "本次监测该单位" + dr["POINT_NAME"].ToString() + "达标排放"; } } } } return(strConclusion); }
/// <summary> /// 获得包含现场项目的点位信息 /// </summary> /// <returns>Json</returns> protected string GetPointInfo() { DataTable dt = new TMisMonitorTaskPointLogic().SelectSampleDeptPoint_QHD(this.SUBTASK_ID.Value); int intTotalCount = dt.Rows.Count; //for (int i = 0; i < dt.Rows.Count; i++) //{ // TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); // objSample.POINT_ID = dt.Rows[i]["ID"].ToString(); // objSample.SUBTASK_ID = this.SUBTASK_ID.Value; // objSample = new TMisMonitorSampleInfoLogic().Details(objSample); // dt.Rows[i]["REMARK1"] = objSample.SAMPLE_CODE; // dt.Rows[i]["REMARK2"] = objSample.SAMPLE_NAME; //} string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
//获取数据 private void GetData(string strID) { TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointLogic().Details(strID); TBaseEvaluationConInfoLogic logicCon = new TBaseEvaluationConInfoLogic(); TBaseEvaluationInfoLogic logicSt = new TBaseEvaluationInfoLogic(); if (objPoint.NATIONAL_ST_CONDITION_ID.Length > 0) { TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.NATIONAL_ST_CONDITION_ID); TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID); objPoint.NATIONAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME; objPoint.hidNATIONAL_ST_CON = objCon.ID; } if (objPoint.LOCAL_ST_CONDITION_ID.Length > 0) { TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.LOCAL_ST_CONDITION_ID); TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID); objPoint.LOCAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME; objPoint.hidLOCAL_ST_CON = objCon.ID; } if (objPoint.INDUSTRY_ST_CONDITION_ID.Length > 0) { TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.INDUSTRY_ST_CONDITION_ID); TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID); objPoint.INDUSTRY_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME; objPoint.hidINDUSTRY_ST_CON = objCon.ID; } string strJson = ToJson(objPoint); Response.Write(strJson); Response.End(); }
public static string deletePoint(string strValue) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strValue); TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = objSample.POINT_ID; objPoint.IS_DEL = "1"; bool isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint); TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo(); objAttrValueDelWhere.OBJECT_ID = strValue; objAttrValueDelWhere.IS_DEL = "0"; TBaseAttrbuteValue3Vo objAttrValueDelSet = new TBaseAttrbuteValue3Vo(); objAttrValueDelSet.IS_DEL = "1"; new TBaseAttrbuteValue3Logic().Edit(objAttrValueDelSet, objAttrValueDelWhere); new TMisMonitorSampleInfoLogic().Delete(objSample); return(isSuccess == true ? "1" : "0"); }
//点位 private void GetPoint_UnderTask(string strSubTaskID, ref string strPointNames, ref int intPointCount, ref string strItemS) { TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo(); objSampleInfo.SUBTASK_ID = strSubTaskID; DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, 0, 0); string strtmpPointNameS = ""; string strtmpItems = ""; for (int i = 0; i < dt.Rows.Count; i++) { TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointLogic().Details(dt.Rows[i]["POINT_ID"].ToString()); if (!strtmpPointNameS.Contains(objTaskPoint.POINT_NAME)) { strtmpPointNameS += (strtmpPointNameS.Length > 0 ? "\r\n" : "") + objTaskPoint.POINT_NAME; } GetItem_UnderSample(dt.Rows[i]["ID"].ToString(), ref strtmpItems); } strItemS += (strItemS.Length > 0 ? "、" : "") + strtmpItems; strPointNames += (strPointNames.Length > 0 ? "\r\n" : "") + strtmpPointNameS; intPointCount += dt.Rows.Count; }
public static string getMonitorPointName(string strTaskPointId) { TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointLogic().Details(strTaskPointId); return(objTaskPoint.POINT_NAME); }
public static string SaveItemSplit(string strSampleID, string strPointName, string strResultItems, string strItems, string strMonitorID, string strSubTaskID) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId"); objPoint.IS_DEL = "0"; objPoint.SUBTASK_ID = strSubTaskID; objPoint.POINT_NAME = strPointName; objPoint.MONITOR_ID = strMonitorID; objPoint.FREQ = "1"; objPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorSampleInfoVo objSampleVo = new TMisMonitorSampleInfoLogic().Details(strSampleID); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); objPoint.TASK_ID = objTask.ID; //监测任务出现新增排口时,基础资料企业表也要新增 TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo(); objnewPoint.ID = GetSerialNumber("t_base_company_point_id"); objnewPoint.IS_DEL = "0"; objnewPoint.POINT_NAME = strPointName; objnewPoint.MONITOR_ID = strMonitorID; objnewPoint.FREQ = "1"; objnewPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo(); objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID); TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID); objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID; isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint); objPoint.POINT_ID = objnewPoint.ID; isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint); //增加点位样品信息 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.SUBTASK_ID = strSubTaskID; objSample.QC_TYPE = "0"; objSample.NOSAMPLE = "0"; objSample.POINT_ID = objPoint.ID; objSample.SAMPLE_NAME = objPoint.POINT_NAME; //新增点位时候,自动生成该点位的样品编码 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); isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample); isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_RESULT", "SAMPLE_ID='" + objSample.ID + "'", "ID in(" + strResultItems.TrimEnd(',') + ")"); isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_TASK_ITEM", "TASK_POINT_ID='" + objPoint.ID + "'", "TASK_POINT_ID='" + objSampleVo.POINT_ID + "' AND ITEM_ID in(" + strItems.TrimEnd(',') + ")"); return(isSuccess ? "true" : "false"); }
public static string SaveData(string strPointID, string strSubtaskID, string strPOINT_NAME, string strMONITOR_ID, string strPOINT_TYPE, string strDYNAMIC_ATTRIBUTE_ID, string strFREQ, string strCREATE_DATE, string strADDRESS, string strLONGITUDE, string strLATITUDE, string strNUM, string strAttribute, string strNATIONAL_ST_CONDITION_ID, string strLOCAL_ST_CONDITION_ID, string strINDUSTRY_ST_CONDITION_ID) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = strPointID.Length > 0 ? strPointID : GetSerialNumber("t_mis_monitor_taskpointId"); objPoint.IS_DEL = "0"; objPoint.SUBTASK_ID = strSubtaskID; objPoint.POINT_NAME = strPOINT_NAME; objPoint.MONITOR_ID = strMONITOR_ID; objPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID; objPoint.FREQ = strFREQ; objPoint.CREATE_DATE = strCREATE_DATE; objPoint.ADDRESS = strADDRESS; objPoint.LONGITUDE = strLONGITUDE; objPoint.LATITUDE = strLATITUDE; objPoint.NUM = strNUM; objPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID; objPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID; objPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID; TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubtaskID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); objPoint.TASK_ID = objTask.ID; //监测任务出现新增排口时,基础资料企业表也要新增 TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo(); if (strPointID.Length == 0) { objnewPoint.ID = GetSerialNumber("t_base_company_point_id"); objnewPoint.IS_DEL = "0"; objnewPoint.POINT_NAME = strPOINT_NAME; objnewPoint.MONITOR_ID = strMONITOR_ID; objnewPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID; objnewPoint.FREQ = strFREQ; objnewPoint.CREATE_DATE = strCREATE_DATE; objnewPoint.ADDRESS = strADDRESS; objnewPoint.LONGITUDE = strLONGITUDE; objnewPoint.LATITUDE = strLATITUDE; objnewPoint.NUM = strNUM; objnewPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID; objnewPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID; objnewPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID; TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo(); objTaskCompany.TASK_ID = objTask.ID;; objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTaskCompany); TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID); objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID; new TBaseCompanyPointLogic().Create(objnewPoint); objPoint.POINT_ID = objnewPoint.ID; } if (strPointID.Length > 0) { isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint); } else { isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint); //增加点位样品信息 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.SUBTASK_ID = strSubtaskID; objSample.QC_TYPE = "0"; objSample.NOSAMPLE = "0"; objSample.POINT_ID = objPoint.ID; objSample.SAMPLE_NAME = objPoint.POINT_NAME; string[] strSampleCode = new string[2] { "S" + DateTime.Now.Year + DateTime.Now.Month, i3.View.PageBase.GetSerialNumber("monitor_samplecode") }; objSample.SAMPLE_CODE = CreateSerialNumber(strSampleCode); new TMisMonitorSampleInfoLogic().Create(objSample); } TBaseAttrbuteValue3Logic logicAttrValue = new TBaseAttrbuteValue3Logic(); //清掉原有动态属性值 TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo(); objAttrValueDelWhere.OBJECT_ID = objPoint.ID; objAttrValueDelWhere.IS_DEL = "0"; TBaseAttrbuteValue3Vo objAttrValueDelSet = new TBaseAttrbuteValue3Vo(); objAttrValueDelSet.IS_DEL = "1"; logicAttrValue.Edit(objAttrValueDelSet, objAttrValueDelWhere); //新增动态属性值 if (strAttribute.Length > 0) { string[] arrAttribute = strAttribute.Split('-'); for (int i = 0; i < arrAttribute.Length; i++) { string[] arrAttrValue = arrAttribute[i].Split('|'); TBaseAttrbuteValue3Vo objAttrValueAdd = new TBaseAttrbuteValue3Vo(); objAttrValueAdd.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttrValueAdd.IS_DEL = "0"; objAttrValueAdd.OBJECT_TYPE = arrAttrValue[0]; objAttrValueAdd.OBJECT_ID = objPoint.ID; objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1]; objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2]; isSuccess = logicAttrValue.Create(objAttrValueAdd); } } if (isSuccess) { return("1"); } else { return("0"); } }
/// <summary> /// 根据监测天数拆分任务(验收监测) Create By:weilin 2014-12-04 /// </summary> /// <param name="strTaskID"></param> /// <returns></returns> private static bool SplitAcceptTask(string strTaskID, TBaseSerialruleVo objSerial) { bool bResult = true; TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskLogic().Details(strTaskID); TMisMonitorReportVo objReportVo = new TMisMonitorReportVo(); if (objTaskVo.CONTRACT_TYPE == "05") //验收监测 { TMisContractVo objContractVo = new TMisContractLogic().Details(objTaskVo.CONTRACT_ID); TMisContractPointVo objContractPointVo = new TMisContractPointVo(); objContractPointVo.CONTRACT_ID = objTaskVo.CONTRACT_ID; objContractPointVo.IS_DEL = "0"; objContractPointVo = new TMisContractPointLogic().Details(objContractPointVo); if (objContractPointVo.SAMPLE_DAY != "" && IsNumeric(objContractPointVo.SAMPLE_DAY) && objContractVo.REMARK5 == "") { int iSampleDay = int.Parse(objContractPointVo.SAMPLE_DAY); TMisMonitorTaskCompanyVo objClient = new TMisMonitorTaskCompanyLogic().Details(objTaskVo.CLIENT_COMPANY_ID); TMisMonitorTaskCompanyVo objTested = new TMisMonitorTaskCompanyLogic().Details(objTaskVo.TESTED_COMPANY_ID); for (int i = 1; i < iSampleDay; i++) { TMisMonitorTaskVo objTaskAddVo = new TMisMonitorTaskVo(); objTaskAddVo.ID = GetSerialNumber("t_mis_monitor_taskId"); objTaskAddVo.CONTRACT_ID = objTaskVo.CONTRACT_ID; objTaskAddVo.PLAN_ID = objTaskVo.PLAN_ID; objTaskAddVo.CONTRACT_CODE = objTaskVo.CONTRACT_CODE; objTaskAddVo.TICKET_NUM = objTaskVo.TICKET_NUM + "-" + (i + 1).ToString(); objTaskAddVo.PROJECT_NAME = objTaskVo.PROJECT_NAME; objTaskAddVo.CONTRACT_YEAR = objTaskVo.CONTRACT_YEAR; objTaskAddVo.CONTRACT_TYPE = objTaskVo.CONTRACT_TYPE; objTaskAddVo.TEST_TYPE = objTaskVo.TEST_TYPE; objTaskAddVo.TEST_PURPOSE = objTaskVo.TEST_PURPOSE; objTaskAddVo.ASKING_DATE = objTaskVo.ASKING_DATE; objTaskAddVo.SAMPLE_SOURCE = objTaskVo.SAMPLE_SOURCE; objTaskAddVo.CREATOR_ID = objTaskVo.CREATOR_ID; objTaskAddVo.CREATE_DATE = objTaskVo.CREATE_DATE; objTaskAddVo.TASK_STATUS = objTaskVo.TASK_STATUS; objTaskAddVo.REMARK1 = objTaskVo.REMARK1; objTaskAddVo.REMARK2 = objTaskVo.REMARK2; objTaskAddVo.REMARK3 = objTaskVo.REMARK3; objTaskAddVo.QC_STATUS = objTaskVo.QC_STATUS; objTaskAddVo.COMFIRM_STATUS = objTaskVo.COMFIRM_STATUS; objTaskAddVo.ALLQC_STATUS = objTaskVo.ALLQC_STATUS; objTaskAddVo.REPORT_HANDLE = objTaskVo.REPORT_HANDLE; //构造监测任务委托企业信息 TMisMonitorTaskCompanyVo objClientAdd = new TMisMonitorTaskCompanyVo(); PageBase.CopyObject(objClient, objClientAdd);//复制对象 objClientAdd.ID = PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId"); objClientAdd.TASK_ID = objTaskAddVo.ID; //构造监测任务受检企业信息 TMisMonitorTaskCompanyVo objTestedAdd = new TMisMonitorTaskCompanyVo(); PageBase.CopyObject(objTested, objTestedAdd);//复制对象 objTestedAdd.ID = PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId"); objTestedAdd.TASK_ID = objTaskAddVo.ID; objTaskAddVo.CLIENT_COMPANY_ID = objClientAdd.ID; objTaskAddVo.TESTED_COMPANY_ID = objTestedAdd.ID; TMisMonitorReportVo objReportAdd = new TMisMonitorReportVo(); objReportVo.ID = GetSerialNumber("t_mis_monitor_report_id"); objReportVo.REPORT_CODE = objReportVo.REPORT_CODE + "-" + (i + 1).ToString(); objReportVo.TASK_ID = objTaskAddVo.ID; objReportVo.IF_GET = "0"; //监测子任务信息 根据委托书监测类别进行构造 ArrayList arrSubTask = new ArrayList(); //监测子任务集合 ArrayList arrSubTaskApp = new ArrayList(); ArrayList arrTaskPoint = new ArrayList(); //监测点位集合 ArrayList arrPointItem = new ArrayList(); //监测点位明细集合 ArrayList arrSample = new ArrayList(); //样品集合 ArrayList arrSampleResult = new ArrayList(); //样品结果集合 ArrayList arrSampleResultApp = new ArrayList(); //样品分析执行表 List <TMisMonitorSubtaskVo> listSubTask = new TMisMonitorSubtaskLogic().SelectByObject(new TMisMonitorSubtaskVo() { TASK_ID = objTaskVo.ID }, 0, 0); for (int j = 0; j < listSubTask.Count; j++) { TMisMonitorSubtaskVo objSubTaskAdd = new TMisMonitorSubtaskVo(); CopyObject(listSubTask[j], objSubTaskAdd); objSubTaskAdd.ID = GetSerialNumber("t_mis_monitor_subtaskId"); objSubTaskAdd.TASK_ID = objTaskAddVo.ID; arrSubTask.Add(objSubTaskAdd); TMisMonitorSubtaskAppVo objSubTaskApp = new TMisMonitorSubtaskAppVo(); objSubTaskApp.SUBTASK_ID = listSubTask[j].ID; objSubTaskApp = new TMisMonitorSubtaskAppLogic().Details(objSubTaskApp); TMisMonitorSubtaskAppVo objSubTaskAppAdd = new TMisMonitorSubtaskAppVo(); CopyObject(objSubTaskApp, objSubTaskAppAdd); objSubTaskAppAdd.ID = GetSerialNumber("TMisMonitorSubtaskAppID"); objSubTaskAppAdd.SUBTASK_ID = objSubTaskAdd.ID; arrSubTaskApp.Add(objSubTaskAppAdd); List <TMisMonitorTaskPointVo> listTaskPoint = new TMisMonitorTaskPointLogic().SelectByObject(new TMisMonitorTaskPointVo() { TASK_ID = objTaskVo.ID, SUBTASK_ID = listSubTask[j].ID, IS_DEL = "0" }, 0, 0); for (int k = 0; k < listTaskPoint.Count; k++) { TMisMonitorTaskPointVo objTaskPointAdd = new TMisMonitorTaskPointVo(); CopyObject(listTaskPoint[k], objTaskPointAdd); objTaskPointAdd.ID = GetSerialNumber("t_mis_monitor_taskpointId"); objTaskPointAdd.TASK_ID = objTaskAddVo.ID; arrTaskPoint.Add(objTaskPointAdd); TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoVo(); objSampleInfoVo.SUBTASK_ID = listSubTask[j].ID; objSampleInfoVo.POINT_ID = listTaskPoint[k].ID; objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objSampleInfoVo); TMisMonitorSampleInfoVo objSampleInfoAdd = new TMisMonitorSampleInfoVo(); CopyObject(objSampleInfoVo, objSampleInfoAdd); objSampleInfoAdd.ID = GetSerialNumber("MonitorSampleId"); objSampleInfoAdd.SUBTASK_ID = objSubTaskAdd.ID; objSampleInfoAdd.POINT_ID = objTaskPointAdd.ID; objSampleInfoAdd.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTaskAddVo, objSubTaskAdd); arrSample.Add(objSampleInfoAdd); List <TMisMonitorTaskItemVo> listTaskItem = new TMisMonitorTaskItemLogic().SelectByObject(new TMisMonitorTaskItemVo() { TASK_POINT_ID = listTaskPoint[k].ID, IS_DEL = "0" }, 0, 0); for (int l = 0; l < listTaskItem.Count; l++) { TMisMonitorTaskItemVo objTaskItemAdd = new TMisMonitorTaskItemVo(); CopyObject(listTaskItem[l], objTaskItemAdd); objTaskItemAdd.ID = GetSerialNumber("t_mis_monitor_task_item_id"); objTaskItemAdd.TASK_POINT_ID = objTaskPointAdd.ID; arrPointItem.Add(objTaskItemAdd); } List <TMisMonitorResultVo> listResult = new TMisMonitorResultLogic().SelectByObject(new TMisMonitorResultVo() { SAMPLE_ID = objSampleInfoVo.ID }, 0, 0); for (int l = 0; l < listResult.Count; l++) { TMisMonitorResultVo objResultAdd = new TMisMonitorResultVo(); CopyObject(listResult[l], objResultAdd); objResultAdd.ID = GetSerialNumber("MonitorResultId"); objResultAdd.SAMPLE_ID = objSampleInfoAdd.ID; arrSampleResult.Add(objResultAdd); TMisMonitorResultAppVo objResultAppVo = new TMisMonitorResultAppVo(); objResultAppVo.RESULT_ID = listResult[l].ID; objResultAppVo = new TMisMonitorResultAppLogic().Details(objResultAppVo); TMisMonitorResultAppVo objResultAppAdd = new TMisMonitorResultAppVo(); CopyObject(objResultAppVo, objResultAppAdd); objResultAppAdd.ID = GetSerialNumber("MonitorResultAppId"); objResultAppAdd.RESULT_ID = objResultAdd.ID; arrSampleResultApp.Add(objResultAppAdd); } } } if (new TMisMonitorTaskLogic().SaveTrans(objTaskAddVo, objClientAdd, objTestedAdd, objReportVo, arrTaskPoint, arrSubTask, arrSubTaskApp, arrPointItem, arrSample, arrSampleResult, arrSampleResultApp)) { bResult = true; } } //更新任务单号 objTaskVo.TICKET_NUM = objTaskVo.TICKET_NUM + "-1"; new TMisMonitorTaskLogic().Edit(objTaskVo); //更新报告单号 objReportVo.REPORT_CODE = objReportVo.REPORT_CODE + "-1"; new TMisMonitorReportLogic().Edit(objReportVo); //更新验收委托书任务已经拆分任务的标志 objContractVo.REMARK5 = "1"; new TMisContractLogic().Edit(objContractVo); } } return(bResult); }
public static string SaveDataPoint(string strSubTaskID, string strPointName, string strMonitorID) { bool isSuccess = true; TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo(); objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId"); objPoint.IS_DEL = "0"; objPoint.SUBTASK_ID = strSubTaskID; objPoint.POINT_NAME = strPointName; objPoint.MONITOR_ID = strMonitorID; objPoint.FREQ = "1"; objPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); objPoint.TASK_ID = objTask.ID; //监测任务出现新增排口时,基础资料企业表也要新增 TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo(); objnewPoint.ID = GetSerialNumber("t_base_company_point_id"); objnewPoint.IS_DEL = "0"; objnewPoint.POINT_NAME = strPointName; objnewPoint.MONITOR_ID = strMonitorID; objnewPoint.FREQ = "1"; objnewPoint.CREATE_DATE = DateTime.Now.ToString(); TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo(); //objTaskCompany.TASK_ID = objTask.ID; ; objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID); TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID); objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID; isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint); objPoint.POINT_ID = objnewPoint.ID; isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint); //增加点位样品信息 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.SUBTASK_ID = strSubTaskID; objSample.QC_TYPE = "0"; objSample.NOSAMPLE = "0"; objSample.POINT_ID = objPoint.ID; objSample.SAMPLE_NAME = objPoint.POINT_NAME; isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample); //为新增的测点添加监测项目 DataTable dt = new TMisMonitorSubtaskLogic().getItemBySubTaskID(strSubTaskID); string strItemIDs = ""; for (int i = 0; i < dt.Rows.Count; i++) { strItemIDs += dt.Rows[i]["ID"].ToString() + ","; } isSuccess = SaveDataItem(strSubTaskID, objSample.ID, strItemIDs.TrimEnd(','), true); if (isSuccess) { return("1"); } else { return("0"); } }