/// <summary> /// 发送到下一环节 /// </summary> /// <param name="strTaskId">任务ID</param> /// <returns></returns> public string SendToNext(string strTaskId) { bool IsSuccess = true; DataTable dt = new TMisMonitorResultLogic().getItemTypeInfo(LogInfo.UserInfo.ID, "sample_delivery", strTaskId, "021", "01"); 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.SAMPLE_ACCESS_DATE = DateTime.Now.ToString(); objSsubtask.TASK_STATUS = "03"; if (!new TMisMonitorSubtaskLogic().Edit(objSsubtask)) { IsSuccess = false; } } if (IsSuccess) { //如果配置文件的IsToDelivery=0,则直接跳过分析任务分配环节,到监测分析环节 if (ConfigurationManager.AppSettings["IsToDelivery"].ToString() != "1") { new TMisMonitorResultLogic().sendToAnalysis(strTaskId, "03", "01", "20"); } } return(IsSuccess == true ? "1" : "0"); }
/// <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"); }
/// <summary> /// 获取样品信息 /// </summary> /// <returns></returns> private string getSampleGridInfo(string strTaskID, string strSubTaskID) { //huangjinjun add 2016.1.26 如果REMARK3等于true,将ph值、电导率、溶解氧设为分析项目 TMisMonitorTaskVo tm = new TMisMonitorTaskVo(); TMisMonitorSubtaskVo tmsub = new TMisMonitorSubtaskVo(); tmsub = new TMisMonitorSubtaskLogic().Details(strSubTaskID); tm.ID = tmsub.TASK_ID; DataTable dtRemark = new TMisMonitorTaskLogic().SelectByTable(tm); if (dtRemark.Rows[0]["REMARK3"].ToString() == "true") { bool bl = new TBaseItemInfoLogic().EditItemTypeFX(); } else { bool bl = new TBaseItemInfoLogic().EditItemTypeXC(); } 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); } if (sampleIdList.Count == 0) { DataTable dt = new TMisMonitorResultLogic().getSampleCodeInAlloction_MAS(strTaskID, strSubTaskID); string strJson = CreateToJson(dt, 0); return(strJson); } else { DataTable dt = new TMisMonitorResultLogic().getSampleCodeInAlloction_MAS(strTaskID, strSubTaskID); 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.Contains(dt.Rows[i]["ID"].ToString())) { continue; } newDT.Rows.Add(dt.Rows[i].ItemArray); } string strJson = CreateToJson(newDT, 0); return(strJson); } }
/// <summary> /// 获得委托书信息 /// </summary> /// <returns>Json</returns> protected string GetContractInfo() { if (this.PLAN_ID.Value.Length == 0) { return(""); } TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(this.PLAN_ID.Value); TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.PLAN_ID = this.PLAN_ID.Value; objTask = new TMisMonitorTaskLogic().Details(objTask); //如果是验收监测 if (objTask.CONTRACT_TYPE == "05") { //获取方案编制人信息 string strProjectId = objTask.PROJECT_ID; //将方案编制人信息写入监测子任务表中 TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVo.TASK_ID = objTask.ID; DataTable objTable = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo); foreach (DataRow row in objTable.Rows) { string strSubTaskId = row["ID"].ToString(); TMisMonitorSubtaskVo TMisMonitorSubtaskVoTemp = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVoTemp.ID = strSubTaskId; TMisMonitorSubtaskVoTemp.SAMPLING_MANAGER_ID = strProjectId; new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVoTemp); } } objTask.TESTED_COMPANY_ID = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID).COMPANY_NAME; objTask.CONTRACT_TYPE = new TSysDictLogic().GetDictNameByDictCodeAndType(objTask.CONTRACT_TYPE, "Contract_Type"); return(ToJson(objTask)); }
/// <summary> /// 获取监测子任务列表信息 /// </summary> /// <returns></returns> protected void selectsubTask() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; int intPageIdx = Convert.ToInt32(Request.Params["page"]); int intPagesize = Convert.ToInt32(Request.Params["pagesize"]); //构造查询对象 TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskLogic objSubTaskLogic = new TMisMonitorSubtaskLogic(); if (strSortname == null || strSortname.Length == 0) { strSortname = TMisMonitorSubtaskVo.ID_FIELD; } objSubTask.SORT_FIELD = strSortname; objSubTask.SORT_TYPE = strSortorder; objSubTask.TASK_ID = !string.IsNullOrEmpty(Request.QueryString["task_id"]) ? Request.QueryString["task_id"].ToString() : ""; string strJson = ""; //int intTotalCount = objSubTaskLogic.GetSelectResultCount(objSubTask);//总计的数据条数 DataTable dt = objSubTaskLogic.SelectByTable(objSubTask, 0, 0); DataTable dtRe = doWithSubtaskData(dt); strJson = CreateToJson(dtRe, dtRe.Rows.Count); Response.Write(strJson); Response.End(); }
/// <summary> /// 将任务发送至下一环节 /// </summary> /// <param name="strTaskId">任务ID</param> /// <returns></returns> public string SendToNext(string strOneGridId) { string strSubTaskID = Request["strSubTaskID"].ToString(); string strUserID = Request["strUserID"].ToString(); int SuccessCount = 0; DataTable dt = new TMisMonitorSubtaskLogic().SelectSampleSubTaskForQY(strSubTaskID, strOneGridId, "022", "sample_result_check"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo(); objSubtaskVo.ID = dt.Rows[i]["ID"].ToString(); objSubtaskVo.TASK_STATUS = "023"; objSubtaskVo.TASK_TYPE = "发送"; if (new TMisMonitorSubtaskLogic().Edit(objSubtaskVo)) { SuccessCount++; } TMisMonitorSubtaskAppVo objSubAppSet = new TMisMonitorSubtaskAppVo(); objSubAppSet.REMARK2 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); //复核时间 objSubAppSet.SAMPLING_QC_CHECK = strUserID; TMisMonitorSubtaskAppVo objSubAppWhere = new TMisMonitorSubtaskAppVo(); objSubAppWhere.SUBTASK_ID = dt.Rows[i]["ID"].ToString(); new TMisMonitorSubtaskAppLogic().Edit(objSubAppSet, objSubAppWhere); } } return(SuccessCount > 0 ? "1" : "0"); }
public static string GoToBack(string strTaskId) { TMisMonitorTaskVo TMisMonitorTaskVo = new TMisMonitorTaskVo(); TMisMonitorTaskVo.ID = strTaskId; TMisMonitorTaskVo.QC_STATUS = "NULL"; bool IsTaskEditSuccess = new TMisMonitorTaskLogic().Edit(TMisMonitorTaskVo); TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVo.TASK_ID = strTaskId; TMisMonitorSubtaskVo.TASK_STATUS = "04"; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo); bool IsSubTaskEditSuccess = true; foreach (DataRow row in dt.Rows) { string strSubTaskId = row["ID"].ToString(); TMisMonitorSubtaskVo TMisMonitorSubtaskVoTemp = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVoTemp.ID = strSubTaskId; TMisMonitorSubtaskVoTemp.TASK_STATUS = "01"; IsSubTaskEditSuccess = new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVoTemp); } return IsTaskEditSuccess && IsSubTaskEditSuccess == true ? "1" : "0"; }
/// <summary> /// 修改项目复制人 /// </summary> /// <param name="strPlanId"></param> private void ModifTaskSampleDutyUser(string strPlanId) { if (!String.IsNullOrEmpty(strPlanId)) { TMisMonitorTaskVo objTaskDetail = new TMisMonitorTaskLogic().Details(new TMisMonitorTaskVo { PLAN_ID = strPlanId }); TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); objSubTask.TASK_ID = objTaskDetail.ID; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask, 0, 0); TMisContractUserdutyVo objUserDuty = new TMisContractUserdutyVo(); objUserDuty.CONTRACT_PLAN_ID = strPlanId; DataTable dtDuty = new TMisContractUserdutyLogic().SelectByTable(objUserDuty, 0, 0); if (dt.Rows.Count > 0 && dtDuty.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { foreach (DataRow drr in dtDuty.Rows) { if (dr["MONITOR_ID"].ToString() == drr["MONITOR_TYPE_ID"].ToString()) { TMisMonitorSubtaskVo objUpSubTask = new TMisMonitorSubtaskVo(); objUpSubTask.ID = dr["ID"].ToString(); objUpSubTask.SAMPLING_MANAGER_ID = drr["SAMPLING_MANAGER_ID"].ToString(); new TMisMonitorSubtaskLogic().Edit(objUpSubTask); } } } } } }
/// <summary> /// 任务退回 /// </summary> /// <param name="strTaskId">任务Id</param> /// <returns></returns> private string GoToBack(string strTaskId, string strSubTaskId, string strSuggestion) { bool isSuccess = false; TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo(); objSubtaskVo.ID = strSubTaskId; objSubtaskVo.TASK_STATUS = "02"; objSubtaskVo.TASK_TYPE = "退回"; isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo); TMisReturnInfoVo objReturnInfoVo = new TMisReturnInfoVo(); objReturnInfoVo.TASK_ID = strTaskId; objReturnInfoVo.SUBTASK_ID = strSubTaskId; objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_005; objReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_002; TMisReturnInfoVo obj = new TMisReturnInfoLogic().Details(objReturnInfoVo); if (obj.ID.Length > 0) { objReturnInfoVo.ID = obj.ID; objReturnInfoVo.SUGGESTION = strSuggestion; isSuccess = new TMisReturnInfoLogic().Edit(objReturnInfoVo); } else { objReturnInfoVo.ID = GetSerialNumber("t_mis_return_id"); objReturnInfoVo.SUGGESTION = strSuggestion; isSuccess = new TMisReturnInfoLogic().Create(objReturnInfoVo); } return(isSuccess == true ? "1" : "0"); }
private void GetInfoForPrint(ref string strMonitorNames, ref string strPointNames, ref string strFREQ, ref string strItemS) { if (this.hidPlanId.Value.Length == 0) { return; } TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.PLAN_ID = this.hidPlanId.Value; objTask = new TMisMonitorTaskLogic().Details(objTask); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); objSubtask.TASK_ID = objTask.ID; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubtask, 0, 0); for (int i = 0; i < dt.Rows.Count; i++) { TBaseMonitorTypeInfoVo objMonitorTypeInfoVo = new TBaseMonitorTypeInfoLogic().Details(dt.Rows[i]["MONITOR_ID"].ToString()); strMonitorNames += objMonitorTypeInfoVo.MONITOR_TYPE_NAME + "\n"; GetPoint_UnderTask(objTask.CONTACT_ID, dt.Rows[i]["ID"].ToString(), ref strPointNames, ref strFREQ, ref strItemS); } }
public string SaveUserInfo() { bool isSuccess = true; string strSamplingMan = ""; TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); if (this.strTaskId.Value.Trim() == "") { objSubtask.ID = this.strSubTaskId.Value; objSubtask.SAMPLING_ID = Request["txtDefaultUserId"]; for (int i = 0; i < objSubtask.SAMPLING_ID.Split(',').Length; i++) { TSysUserVo objUser = new TSysUserLogic().Details(objSubtask.SAMPLING_ID.Split(',')[i]); strSamplingMan += (strSamplingMan.Length > 0) ? "," + objUser.REAL_NAME : objUser.REAL_NAME; } objSubtask.SAMPLING_MAN = strSamplingMan; isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask); } else { //在采样分配环节批量修改协同人 add by weilin objSubtask.SAMPLING_ID = Request["txtDefaultUserId"]; for (int i = 0; i < objSubtask.SAMPLING_ID.Split(',').Length; i++) { TSysUserVo objUser = new TSysUserLogic().Details(objSubtask.SAMPLING_ID.Split(',')[i]); strSamplingMan += (strSamplingMan.Length > 0) ? "," + objUser.REAL_NAME : objUser.REAL_NAME; } objSubtask.SAMPLING_MAN = strSamplingMan; TMisMonitorSubtaskVo objWhere = new TMisMonitorSubtaskVo(); objWhere.TASK_ID = this.strTaskId.Value.Trim(); objWhere.TASK_STATUS = "01"; isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask, objWhere); } return isSuccess == true ? "1" : "0"; }
/// <summary> /// 采样任务列表信息 /// </summary> /// <returns>Json</returns> protected string getSampleTask() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); //objSubtask.SORT_FIELD = "SAMPLE_ASK_DATE"; //DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0); //DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithAllTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0); //int intTotalCount = dt.Rows.Count; //string strJson = CreateToJson(dt, intTotalCount); objSubtask.SORT_FIELD = "CREATE_DATE"; objSubtask.SORT_TYPE = "desc"; DataTable dtTreeRoot = new TMisMonitorSubtaskLogic().SelectByTableWithAllTaskForFatherTree(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0); objSubtask.SORT_FIELD = "TASK_ID"; objSubtask.SORT_TYPE = "asc"; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithAllTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0); int RecordCount = dtTreeRoot.Rows.Count + dt.Rows.Count; string strJson = LigerGridTreeDataToJson(dtTreeRoot, dt, "TASK_ID", RecordCount); return(strJson); }
/// <summary> /// 发送到下一环节 /// </summary> /// <param name="strTaskId">任务ID</param> /// <returns></returns> public string SendToNext(string strSampleAskDate, string strSampleFinishDate) { bool IsSuccess = true; TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.PLAN_ID = this.PLAN_ID.Value; objTask = new TMisMonitorTaskLogic().Details(objTask); TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); objSubTask.TASK_ID = objTask.ID; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask); for (int i = 0; i < dt.Rows.Count; i++) { objSubTask.ID = dt.Rows[i]["ID"].ToString(); objSubTask.TASK_STATUS = "02"; objSubTask.SAMPLE_ASK_DATE = strSampleAskDate; objSubTask.SAMPLE_FINISH_DATE = strSampleFinishDate; if (!new TMisMonitorSubtaskLogic().Edit(objSubTask)) { IsSuccess = false; } TMisMonitorSubtaskAppVo objSubApp = new TMisMonitorSubtaskAppVo(); DataTable dtApp = new TMisMonitorSubtaskAppLogic().SelectByTable(new TMisMonitorSubtaskAppVo { SUBTASK_ID = dt.Rows[i]["ID"].ToString() }); if (dtApp.Rows.Count > 0) { objSubApp.ID = dtApp.Rows[0]["ID"].ToString(); objSubApp.SUBTASK_ID = dt.Rows[i]["ID"].ToString(); objSubApp.QC_APP_USER_ID = new PageBase().LogInfo.UserInfo.ID; objSubApp.QC_APP_DATE = DateTime.Now.ToString(); new TMisMonitorSubtaskAppLogic().Edit(objSubApp); } else { objSubApp.ID = GetSerialNumber("TMisMonitorSubtaskAppID"); objSubApp.SUBTASK_ID = dt.Rows[i]["ID"].ToString(); objSubApp.QC_APP_USER_ID = new PageBase().LogInfo.UserInfo.ID; objSubApp.QC_APP_DATE = DateTime.Now.ToString(); new TMisMonitorSubtaskAppLogic().Create(objSubApp); } } if (IsSuccess) { TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(this.PLAN_ID.Value); objPlan.HAS_DONE = "1"; new TMisContractPlanLogic().Edit(objPlan); } return(IsSuccess == true ? "1" : "0"); }
//发送到下一环节 private string SendToNext(string strTaskId) { TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVo.TASK_ID = strTaskId; TMisMonitorSubtaskVo.TASK_STATUS = "023"; DataTable objTable = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo); #region 审核人修改 foreach (DataRow row in objTable.Rows) { string strId = row["ID"].ToString(); //根据子任务ID获取监测子任务审核表ID i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo TMisMonitorSubtaskAppVoTemp = new i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo(); TMisMonitorSubtaskAppVoTemp.SUBTASK_ID = strId; string strSubTaskAppId = new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppLogic().Details(TMisMonitorSubtaskAppVoTemp).ID; i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo TMisMonitorSubtaskAppVo = new i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo(); TMisMonitorSubtaskAppVo.ID = strSubTaskAppId; TMisMonitorSubtaskAppVo.SAMPLING_QC_CHECK = LogInfo.UserInfo.ID; new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppLogic().Edit(TMisMonitorSubtaskAppVo); } #endregion //bool IsSuccess = new TMisMonitorResultLogic().TaskGoBackInSampleResultQcCheck(strTaskId, "023", "24"); bool IsSuccess = new TMisMonitorResultLogic().SetSampleResultStatus(strTaskId, "023", "50"); if (IsSuccess == true) { new TMisMonitorResultLogic().TaskGoBackInSampleResultQcCheck(strTaskId, "023", "03"); } #region 注释 //if (IsSuccess == true) //{ // if (new TMisMonitorResultLogic().allTaskIsFinish_ZZ(strTaskId, "24", "50")) // { // i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo TMisMonitorTaskVo = new i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo(); // TMisMonitorTaskVo.ID = strTaskId; // TMisMonitorTaskVo.TASK_STATUS = "09"; // new i3.BusinessLogic.Channels.Mis.Monitor.Task.TMisMonitorTaskLogic().Edit(TMisMonitorTaskVo); // i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo TMisMonitorTaskVoTemp = new i3.BusinessLogic.Channels.Mis.Monitor.Task.TMisMonitorTaskLogic().Details(strTaskId); // if (TMisMonitorTaskVoTemp.CONTRACT_TYPE == "05") // { // //根据任务ID获取项目负责人 // string strProjectId = TMisMonitorTaskVoTemp.PROJECT_ID; // TMisMonitorReportVo objMrUpdate = new TMisMonitorReportVo(); // objMrUpdate.IF_SEND = "1"; // objMrUpdate.REPORT_SCHEDULER = strProjectId; // TMisMonitorReportVo objMrWhere = new TMisMonitorReportVo(); // objMrWhere.TASK_ID = strTaskId; // new TMisMonitorReportLogic().Edit(objMrUpdate, objMrWhere); // } // } //} #endregion return(IsSuccess == true ? "1" : "0"); }
public static string updateDate(string strSubTaskID, string strAskDate, string strFinishDate) { TMisMonitorSubtaskVo SubTaskVo = new TMisMonitorSubtaskVo(); SubTaskVo.ID = strSubTaskID; SubTaskVo.SAMPLE_ASK_DATE = strAskDate; SubTaskVo.SAMPLE_FINISH_DATE = strFinishDate; new TMisMonitorSubtaskLogic().Edit(SubTaskVo); return("1"); }
public static string setReceiveSubTask(string strSubTaskId) { TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVo.ID = strSubTaskId; TMisMonitorSubtaskVo.REMARK2 = "1"; bool isSuccess = new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVo); return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 将任务发送至下一环节 /// </summary> /// <param name="strTaskId">任务ID</param> /// <returns></returns> public string SendToNext(string strSubtaskId) { TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo(); objSubtaskVo.ID = strSubtaskId; objSubtaskVo.TASK_STATUS = "023"; objSubtaskVo.TASK_TYPE = "发送"; bool isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo); return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 将任务回退到上一环节 /// </summary> /// <param name="strTaskId">任务ID</param> /// <returns></returns> public string GoToBackTask(string strSubTaskId) { TMisMonitorSubtaskVo objSubTaskVo = new TMisMonitorSubtaskVo(); objSubTaskVo.ID = strSubTaskId; objSubTaskVo.TASK_STATUS = "122";//退回状态 objSubTaskVo.TASK_TYPE = "退回"; bool isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubTaskVo); return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 采样任务分配信息 /// </summary> /// <returns></returns> private string getTwoGridInfo(string strTaskID) { if (this.PLAN_ID.Value.Length == 0) { return(""); } TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.ID = strTaskID; objTask.PLAN_ID = this.PLAN_ID.Value; objTask = new TMisMonitorTaskLogic().Details(objTask); string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); objSubtask.TASK_ID = objTask.ID; objSubtask.TASK_STATUS = "01"; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubtask, intPageIndex, intPageSize); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["SAMPLING_MANAGER_ID"].ToString().Length > 0) { dt.Rows[i]["SAMPLING_MANAGER_ID"] = new TSysUserLogic().Details(dt.Rows[i]["SAMPLING_MANAGER_ID"].ToString()).REAL_NAME; } else { dt.Rows[i]["SAMPLING_MANAGER_ID"] = "请选择"; } //退回意见 TMisReturnInfoVo objReturnInfoVo = new TMisReturnInfoVo(); objReturnInfoVo.TASK_ID = dt.Rows[i]["TASK_ID"].ToString(); objReturnInfoVo.SUBTASK_ID = dt.Rows[i]["ID"].ToString(); objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_002; objReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_001; objReturnInfoVo = new TMisReturnInfoLogic().Details(objReturnInfoVo); dt.Rows[i]["REMARK1"] = objReturnInfoVo.SUGGESTION; } dt.DefaultView.Sort = "MONITOR_ID ASC"; DataTable dtTemp = dt.DefaultView.ToTable(); int intTotalCount = new TMisMonitorSubtaskLogic().GetSelectResultCount(objSubtask); string strJson = CreateToJson(dtTemp, intTotalCount); return(strJson); }
public static string EnvFinish(string strSubTaskId) { TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVo.ID = strSubTaskId; TMisMonitorSubtaskVo.TASK_STATUS = "09"; if (new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVo)) { return("1"); } else { return("0"); } }
protected void btnImportCode_Click(object sender, EventArgs e) { string strPrintId = this.strPrintId.Value; string strCompanyName = GetCompany_UnderTask(strPrintId); TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); objSubTask.TASK_ID = strPrintId; DataTable dtSub = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask); string strSampleIDs = ""; for (int i = 0; i < dtSub.Rows.Count; i++) { GetPoint_UnderTask(dtSub.Rows[i]["ID"].ToString(), ref strSampleIDs); } //获取基本信息 DataTable dt = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheetInfoBySampleId(strSampleIDs, "021", "0"); FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/SamplingCodingSheet.xls"), FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); sheet.GetRow(2).GetCell(1).SetCellValue(DateTime.Now.ToString("yyyy年MM月dd日")); for (int i = 0; i < dt.Rows.Count; i++) { int j = i + 1; sheet.GetRow(i + 6).GetCell(0).SetCellValue(j.ToString()); sheet.GetRow(i + 6).GetCell(1).SetCellValue(strCompanyName + dt.Rows[i]["SAMPLE_NAME"].ToString()); //sheet.GetRow(i + 6).GetCell(3).SetCellValue("1"); sheet.GetRow(i + 6).GetCell(5).SetCellValue(dt.Rows[i]["SAMPLE_CODE"].ToString()); } using (MemoryStream stream = new MemoryStream()) { hssfworkbook.Write(stream); HttpContext curContext = HttpContext.Current; // 设置编码和附件格式 curContext.Response.ContentType = "application/vnd.ms-excel"; curContext.Response.ContentEncoding = Encoding.UTF8; curContext.Response.Charset = ""; curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("样品编码表.xls", Encoding.UTF8)); curContext.Response.BinaryWrite(stream.GetBuffer()); curContext.Response.End(); } }
protected string GetMonitorType(string strTaskID) { string strMonitorType = "";//合同类型字符串 TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); objSubTask.TASK_ID = strTaskID; List <TMisMonitorSubtaskVo> listSubTask = new TMisMonitorSubtaskLogic().SelectByObject(objSubTask, 0, 0); if (listSubTask.Count > 0) { foreach (TMisMonitorSubtaskVo obj in listSubTask) { strMonitorType += new TBaseMonitorTypeInfoLogic().Details(obj.MONITOR_ID).MONITOR_TYPE_NAME + ","; } } return(strMonitorType.Length > 0 ? strMonitorType.Remove(strMonitorType.LastIndexOf(",")) : ""); }
/// <summary> /// 获取监测点信息 /// </summary> /// <returns></returns> private string getOneGridInfo() { TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo(); TMisMonitorSubtaskVo.TASK_ID = Request["formId"].ToString(); DataTable objTable = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo); DataTable dt = objTable.Clone(); foreach (DataRow row in objTable.Rows) { if (row["REMARK1"].ToString() == "") { dt.ImportRow(row); } } string strJson = CreateToJson(dt, dt.Rows.Count); return(strJson); }
/// <summary> /// 采样任务列表信息 /// </summary> /// <returns>Json</returns> protected string getSampleTask() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); objSubtask.SORT_FIELD = "SAMPLE_ASK_DATE"; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0); int intTotalCount = dt.Rows.Count; string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 构造监测结论 /// </summary> /// <param name="strTaskID">监测任务ID</param> protected string AutoSaveConclusion(string strTaskID) { string strConclusion = "";// 监测结论 TMisMonitorSubtaskVo objMonitorSubTask = new TMisMonitorSubtaskVo(); objMonitorSubTask.TASK_ID = strTaskID; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objMonitorSubTask); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { //如果子任务中不存在监测结论则自动生成新的监测结论 string strCon = dr["PROJECT_CONCLUSION"].ToString().Length > 0 ? dr["PROJECT_CONCLUSION"].ToString() : GetConclusion(strTaskID, dr["ID"].ToString()); strConclusion += strCon.Length > 0 ? strCon + ";" : ""; } strConclusion += "对执行标准如有异议,以环保管理部门核定为准。"; } return(strConclusion); }
/// <summary> /// 发送到下一环节 /// </summary> /// <param name="strTaskId">任务ID</param> /// <returns></returns> public string SendToNext(string strTaskId) { bool IsSuccess = true; DataTable dt = new TMisMonitorResultLogic().getItemTypeInfo(LogInfo.UserInfo.ID, "sample_qc_end", strTaskId, "024", "01"); 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.TASK_STATUS = "021"; if (!new TMisMonitorSubtaskLogic().Edit(objSsubtask)) { IsSuccess = false; } } return(IsSuccess == true ? "1" : "0"); }
/// <summary> /// 任务退回 /// </summary> /// <param name="strTaskId">任务Id</param> /// <returns></returns> private string GoToBack(string strTaskId, string strSubTaskID, string strSuggestion) { //TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo(); //objSubtaskVo.ID = strSubTaskId; //objSubtaskVo.TASK_STATUS = "022"; //objSubtaskVo.TASK_TYPE = "退回"; //bool IsSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo); //bool IsSuccess = new TMisMonitorSubtaskLogic().SampleResultQcCheckBackTo(strTaskId, "023", "022", "退回"); bool IsSuccess = true; TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo(); objSubtaskVo.ID = strSubTaskID; objSubtaskVo.TASK_STATUS = "022"; objSubtaskVo.TASK_TYPE = "退回"; IsSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo); TMisReturnInfoVo objReturnInfoVo = new TMisReturnInfoVo(); objReturnInfoVo.TASK_ID = strTaskId; objReturnInfoVo.SUBTASK_ID = strSubTaskID; objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_004; objReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_003; TMisReturnInfoVo obj = new TMisReturnInfoLogic().Details(objReturnInfoVo); if (obj.ID.Length > 0) { objReturnInfoVo.ID = obj.ID; objReturnInfoVo.SUGGESTION = strSuggestion; IsSuccess = new TMisReturnInfoLogic().Edit(objReturnInfoVo); } else { objReturnInfoVo.ID = GetSerialNumber("t_mis_return_id"); objReturnInfoVo.SUGGESTION = strSuggestion; IsSuccess = new TMisReturnInfoLogic().Create(objReturnInfoVo); } return(IsSuccess == true ? "1" : "0"); }
public static string btnBackClick(string strPlanID) { bool IsSuccess = true; TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.PLAN_ID = strPlanID; objTask = new TMisMonitorTaskLogic().Details(objTask); TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); objSubTask.TASK_ID = objTask.ID; //判断是否经过质控,如果经过质控,则将数据发送到质控环节 if (true) { TMisMonitorTaskVo objTaskEdit = new TMisMonitorTaskVo(); objTaskEdit.ID = objTask.ID; objTaskEdit.QC_STATUS = "1"; new TMisMonitorTaskLogic().Edit(objTaskEdit); } return(IsSuccess == true ? "1" : "0"); }
private void GetInfoForPrint(ref string strPointNames, ref int intPointCount, ref string strItemS) { if (this.PLAN_ID.Value.Length == 0) { return; } TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.PLAN_ID = this.PLAN_ID.Value; objTask = new TMisMonitorTaskLogic().Details(objTask); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); objSubtask.TASK_ID = objTask.ID; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubtask, 0, 0); for (int i = 0; i < dt.Rows.Count; i++) { GetPoint_UnderTask(dt.Rows[i]["ID"].ToString(), ref strPointNames, ref intPointCount, ref strItemS); } }
public string SaveUserInfo() { bool isSuccess = true; TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo(); if (this.strTaskId.Value.Trim() == "") { objSubtask.ID = this.strSubTaskId.Value; objSubtask.SAMPLING_MANAGER_ID = Request["DEFAULT_USER"]; isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask); } else { //在采样分配环节批量修改采样人 add by weilin objSubtask.SAMPLING_MANAGER_ID = Request["DEFAULT_USER"]; TMisMonitorSubtaskVo objWhere = new TMisMonitorSubtaskVo(); objWhere.TASK_ID = this.strTaskId.Value.Trim(); objWhere.TASK_STATUS = "01"; isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask, objWhere); } return(isSuccess == true ? "1" : "0"); }