/// <summary> /// 饼图绑定 /// </summary> public void FillChart() { TMisMonitorTaskVo objItems = new TMisMonitorTaskVo(); objItems.REMARK3 = strYear; objItems.REMARK4 = strMonth; objItems.REMARK5 = strQuarter; objItems.CONTRACT_CODE = strContractCode; TMisMonitorTaskCompanyVo objComItems = new TMisMonitorTaskCompanyVo(); objComItems.AREA = strArea; objComItems.COMPANY_NAME = strTestCompany; dt = new TMisMonitorTaskLogic().GetTaskChartCountWithStatus(objItems, objComItems, strDept); if (dt.Rows.Count == 0) { DataRow dr = dt.NewRow(); dr["FINISHSUM"] = "0"; dr["FINISHTYPE"] = "无数据集"; dt.Rows.Add(dr); dt.AcceptChanges(); } ReportDataSource rds = new ReportDataSource("DataSet2", dt); this.reportViewer1.LocalReport.DataSources.Add(rds); this.reportViewer1.LocalReport.Refresh(); this.reportViewer2.LocalReport.DataSources.Add(rds); this.reportViewer2.LocalReport.Refresh(); }
private string InsertContractCompanyInfo(string strReqTaskId, string strReqCompanyId) { string result = ""; DataTable dt = new DataTable(); TMisMonitorTaskCompanyVo objTmc = new TMisMonitorTaskCompanyVo(); //Update By SSZ 将基础资料企业信息复制到委托书企业信息 //基础企业资料信息 TBaseCompanyInfoVo objCompanyInfo = new TBaseCompanyInfoLogic().Details(strReqCompanyId); //将相同字段的数据进行复制 CopyObject(objCompanyInfo, objTmc); objTmc.TASK_ID = strReqTaskId; objTmc.COMPANY_ID = strReqCompanyId; objTmc.IS_DEL = "0"; objTmc.ID = i3.View.PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId"); if (new TMisMonitorTaskCompanyLogic().Create(objTmc)) { result = objTmc.ID.ToString(); string strMessage = LogInfo.UserInfo.USER_NAME + "添加任务企业" + objTmc.ID + "成功"; //WriteLog(i3.ValueObject.ObjectBase.LogType.AddContractCompanyInfo, "", strMessage); } return(result); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tMisMonitorTaskCompany">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, int iIndex, int iCount) { string strSQL = " select * from T_MIS_MONITOR_TASK_COMPANY {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorTaskCompany)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorTaskCompany_UpdateSet">UpdateSet用户对象</param> /// <param name="tMisMonitorTaskCompany_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany_UpdateSet, TMisMonitorTaskCompanyVo tMisMonitorTaskCompany_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorTaskCompany_UpdateSet, TMisMonitorTaskCompanyVo.T_MIS_MONITOR_TASK_COMPANY_TABLE); strSQL += this.BuildWhereStatement(tMisMonitorTaskCompany_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获得委托书信息 /// </summary> /// <returns>Json</returns> protected string GetContractInfo() { TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(this.SUBTASK_ID.Value); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); TMisMonitorTaskCompanyVo objConCompany = new TMisMonitorTaskCompanyVo(); objConCompany.TASK_ID = objTask.ID; objConCompany = new TMisMonitorTaskCompanyLogic().Details(objConCompany); objSubtask.MONITOR_ID = getMonitorTypeName(objSubtask.MONITOR_ID); objSubtask.SAMPLING_MANAGER_ID = new TSysUserLogic().Details(LogInfo.UserInfo.ID).REAL_NAME; objSubtask.REMARK1 = objTask.CONTRACT_CODE; objSubtask.REMARK2 = getDictName(objTask.CONTRACT_TYPE, "Contract_Type"); objSubtask.REMARK3 = objConCompany.COMPANY_NAME; objSubtask.REMARK4 = objConCompany.CONTACT_NAME; objSubtask.REMARK5 = objConCompany.LINK_PHONE; if (!String.IsNullOrEmpty(objSubtask.SAMPLE_ASK_DATE)) { objSubtask.SAMPLE_ASK_DATE = DateTime.Parse(objSubtask.SAMPLE_ASK_DATE).ToString("yyyy-MM-dd"); } if (!String.IsNullOrEmpty(objSubtask.SAMPLE_FINISH_DATE)) { objSubtask.SAMPLE_FINISH_DATE = DateTime.Parse(objSubtask.SAMPLE_FINISH_DATE).ToString("yyyy-MM-dd"); } return(ToJson(objSubtask)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorTaskCompany">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorTaskCompany, TMisMonitorTaskCompanyVo.T_MIS_MONITOR_TASK_COMPANY_TABLE); strSQL += string.Format(" where ID='{0}' ", tMisMonitorTaskCompany.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { string strSQL = "delete from T_MIS_MONITOR_TASK_COMPANY "; strSQL += this.BuildWhereStatement(tMisMonitorTaskCompany); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
protected void btnImport_Click(object sender, EventArgs e) { FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/QcSheet.xls"), FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); ISheet sheet = hssfworkbook.GetSheet("Sheet1"); string strTaskType = ""; //DataTable dt = GetPendingPlanDataTable(); //if (dt.Rows.Count > 0) //{ // sheet.GetRow(2).GetCell(5).SetCellValue(dt.Rows[0]["TICKET_NUM"].ToString()); // sheet.GetRow(4).GetCell(1).SetCellValue(dt.Rows[0]["COMPANY_NAME"].ToString()); // strTaskType = getDictName(dt.Rows[0]["CONTRACT_TYPE"].ToString(), "Contract_Type"); // sheet.GetRow(4).GetCell(5).SetCellValue(strTaskType); // sheet.GetRow(5).GetCell(1).SetCellValue(dt.Rows[0]["PROJECT_NAME"].ToString()); // sheet.GetRow(6).GetCell(1).SetCellValue(strTaskType + "表"); // sheet.GetRow(6).GetCell(5).SetCellValue(dt.Rows[0]["COMPANY_NAME"].ToString()); // sheet.GetRow(8).GetCell(0).SetCellValue(dt.Rows[0]["QC_STEP"].ToString()); //} TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); TMisMonitorTaskCompanyVo objCompany = new TMisMonitorTaskCompanyVo(); int isOk = 0; getPrintQcInfo_pan(ref objTask, ref objCompany, ref isOk); if (isOk == 1) { sheet.GetRow(2).GetCell(5).SetCellValue(objTask.TICKET_NUM); sheet.GetRow(4).GetCell(1).SetCellValue(objCompany.COMPANY_NAME); strTaskType = getDictName(objTask.CONTRACT_TYPE, "Contract_Type"); sheet.GetRow(4).GetCell(5).SetCellValue(strTaskType); sheet.GetRow(5).GetCell(1).SetCellValue(objTask.PROJECT_NAME); if (objTask.CONTRACT_TYPE == "02" || objTask.CONTRACT_TYPE == "03") { sheet.GetRow(6).GetCell(1).SetCellValue("监测表"); } else { sheet.GetRow(6).GetCell(1).SetCellValue("监测报告"); } sheet.GetRow(6).GetCell(5).SetCellValue(objCompany.COMPANY_NAME); sheet.GetRow(8).GetCell(0).SetCellValue(objTask.REMARK1); } 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("监测质控通知单-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", Encoding.UTF8)); curContext.Response.BinaryWrite(stream.GetBuffer()); curContext.Response.End(); } }
protected void SetReport(string strContractID) { //获取委托书信息 TMisContractVo objContract = new TMisContractLogic().Details(strContractID); #region 构造监测任务对象 TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); CopyObject(objContract, objTask); objTask.ID = GetSerialNumber("t_mis_monitor_taskId"); objTask.CONTRACT_ID = objContract.ID; objTask.PLAN_ID = ""; objTask.CONSIGN_DATE = objContract.ASKING_DATE; objTask.CREATOR_ID = LogInfo.UserInfo.ID; objTask.CREATE_DATE = DateTime.Now.ToString(); objTask.TASK_STATUS = "09"; objTask.COMFIRM_STATUS = "0"; #endregion #region 构造监测任务委托企业信息 //委托企业信息 TMisContractCompanyVo objContractClient = new TMisContractCompanyLogic().Details(objContract.CLIENT_COMPANY_ID); //受检企业信息 TMisContractCompanyVo objContractTested = new TMisContractCompanyLogic().Details(objContract.TESTED_COMPANY_ID); //构造监测任务委托企业信息 TMisMonitorTaskCompanyVo objTaskClient = new TMisMonitorTaskCompanyVo(); CopyObject(objContractClient, objTaskClient);//复制对象 objTaskClient.ID = GetSerialNumber("t_mis_monitor_taskcompanyId"); objTaskClient.TASK_ID = objTask.ID; objTaskClient.COMPANY_ID = objContract.CLIENT_COMPANY_ID; //构造监测任务受检企业信息 TMisMonitorTaskCompanyVo objTaskTested = new TMisMonitorTaskCompanyVo(); CopyObject(objContractTested, objTaskTested);//复制对象 objTaskTested.ID = GetSerialNumber("t_mis_monitor_taskcompanyId"); objTaskTested.TASK_ID = objTask.ID; objTaskTested.COMPANY_ID = objContract.TESTED_COMPANY_ID; //重新赋值监测任务企业ID objTask.CLIENT_COMPANY_ID = objTaskClient.ID; objTask.TESTED_COMPANY_ID = objTaskTested.ID; #endregion #region 构造监测报告 TMisMonitorReportVo objReportVo = new TMisMonitorReportVo(); objReportVo.ID = GetSerialNumber("t_mis_monitor_report_id"); objReportVo.TASK_ID = objTask.ID; objReportVo.REPORT_CODE = objTask.CONTRACT_CODE; objReportVo.REPORT_EX_ATTACHE_ID = GetAttID(objTask.CONTRACT_ID, "AcceptanceContract"); objReportVo.IF_GET = "0"; if (new TMisMonitorTaskLogic().SaveTrans(objTask, objTaskClient, objTaskTested, objReportVo)) { WriteLog("生成验收委托监测任务", "", LogInfo.UserInfo.USER_NAME + "生成验收委托监测任务" + objTask.ID + "成功"); } #endregion }
private void getPrintQcInfo_pan(ref TMisMonitorTaskVo objTask, ref TMisMonitorTaskCompanyVo objCompany, ref int isOk) { if (!String.IsNullOrEmpty(strPlanId)) { TMisMonitorTaskVo objTaskWhere = new TMisMonitorTaskVo(); objTaskWhere.PLAN_ID = strPlanId; objTask = new TMisMonitorTaskLogic().Details(objTaskWhere); objCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID); isOk = 1; } }
private void getPrintQcInfo_pan(ref TMisMonitorTaskVo objTask, ref TMisMonitorTaskCompanyVo objCompany, ref int isOk) { string strTaskId = hidTaskId.Value; if (!String.IsNullOrEmpty(strTaskId) && strTaskId.Length > 0) { objTask = new TMisMonitorTaskLogic().Details(strTaskId); objCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID); isOk = 1; } }
/// <summary> /// 获得委托书信息 /// </summary> /// <returns>Json</returns> protected string GetContractInfo() { TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(this.SUBTASK_ID.Value); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); TMisMonitorTaskCompanyVo objConCompany = new TMisMonitorTaskCompanyVo(); //objConCompany.TASK_ID = objTask.ID; objConCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID); objSubtask.MONITOR_ID = getMonitorTypeName(objSubtask.MONITOR_ID); objSubtask.SAMPLING_MANAGER_ID = new TSysUserLogic().Details(objSubtask.SAMPLING_MANAGER_ID).REAL_NAME; objSubtask.REMARK1 = objTask.CONTRACT_CODE; objSubtask.REMARK2 = getDictName(objTask.CONTRACT_TYPE, "Contract_Type"); objSubtask.REMARK3 = objConCompany.COMPANY_NAME; objSubtask.REMARK4 = objConCompany.CONTACT_NAME; objSubtask.REMARK5 = objConCompany.PHONE; objSubtask.SAMPLE_APPROVE_INFO = objTask.TEST_PURPOSE; if (!String.IsNullOrEmpty(objSubtask.SAMPLE_ASK_DATE)) { objSubtask.SAMPLE_ASK_DATE = DateTime.Parse(objSubtask.SAMPLE_ASK_DATE).ToString("yyyy-MM-dd"); } if (!String.IsNullOrEmpty(objSubtask.SAMPLE_FINISH_DATE)) { objSubtask.SAMPLE_FINISH_DATE = DateTime.Parse(objSubtask.SAMPLE_FINISH_DATE).ToString("yyyy-MM-dd"); } //获取退回意见信息 TMisReturnInfoVo ReturnInfoVo = new TMisReturnInfoVo(); ReturnInfoVo.TASK_ID = objSubtask.TASK_ID; ReturnInfoVo.SUBTASK_ID = objSubtask.ID; if (Request.QueryString["strLink"].ToString() == "Sample") { ReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_003; ReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_002; } if (Request.QueryString["strLink"].ToString() == "Check") { ReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_004; ReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_003; } if (Request.QueryString["strLink"].ToString() == "QcCheck") { ReturnInfoVo.CURRENT_STATUS = "111"; ReturnInfoVo.BACKTO_STATUS = "222"; } ReturnInfoVo = new TMisReturnInfoLogic().Details(ReturnInfoVo); if (ReturnInfoVo.ID.Length > 0) { objSubtask.SAMPLING_METHOD = "退回意见:" + ReturnInfoVo.SUGGESTION; } return(ToJson(objSubtask)); }
/// <summary> /// 获得受检单位信息 /// </summary> /// <returns>Json</returns> protected string GetTestedInfo() { TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(this.ID.Value); TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo(); if (!string.IsNullOrEmpty(objTask.TESTED_COMPANY_ID)) { objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(new TMisMonitorTaskCompanyVo() { ID = objTask.TESTED_COMPANY_ID, IS_DEL = "0" }); } return(ToJson(objTaskCompany)); }
/// <summary> /// 创建原因:根据子任务ID获取企业信息 /// 创建人:胡方扬 /// 创建时间:2013-07-09 /// </summary> /// <returns></returns> public string getCompanyInfor() { string result = ""; if (!String.IsNullOrEmpty(strSubTask_Id)) { TMisMonitorResultVo objResult = new TMisMonitorResultLogic().Details(strSubTask_Id); TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(objResult.SAMPLE_ID); TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubTask.TASK_ID); TMisMonitorTaskCompanyVo objCompany = new TMisMonitorTaskCompanyVo(); objCompany.ID = objTask.TESTED_COMPANY_ID; DataTable dt = new TMisMonitorTaskCompanyLogic().SelectByTable(objCompany); dt.Columns.Add("SAMPLE_CODE"); dt.Rows[0]["SAMPLE_CODE"] = objSample.SAMPLE_CODE; result = LigerGridDataToJson(dt, dt.Rows.Count); } return(result); }
/// <summary> /// 获取已完成的预约任务 /// </summary> public void GetFinishedPlan() { dt = new DataTable(); TMisMonitorTaskVo objItems = new TMisMonitorTaskVo(); objItems.TASK_STATUS = "11"; objItems.REMARK3 = strYear; objItems.REMARK4 = strMonth; objItems.REMARK5 = strQuarter; objItems.CONTRACT_CODE = strContractCode; TMisMonitorTaskCompanyVo objComItems = new TMisMonitorTaskCompanyVo(); objComItems.AREA = strArea; objComItems.COMPANY_NAME = strTestCompany; dt = new TMisMonitorTaskLogic().GetTaskFinishedChart(objItems, objComItems, strDept, true); ReportDataSource rds = new ReportDataSource("DataSet1", dt); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(rds); this.reportViewer1.LocalReport.Refresh(); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tMisMonitorTaskCompany">对象</param> /// <returns>是否成功</returns> public bool Create(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { string strSQL = SqlHelper.BuildInsertExpress(tMisMonitorTaskCompany, TMisMonitorTaskCompanyVo.T_MIS_MONITOR_TASK_COMPANY_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <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); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tMisMonitorTaskCompany"></param> /// <returns></returns> public string BuildWhereStatement(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tMisMonitorTaskCompany) { //ID if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisMonitorTaskCompany.ID.ToString())); } //任务ID if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.TASK_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TASK_ID = '{0}'", tMisMonitorTaskCompany.TASK_ID.ToString())); } //委托书企业ID if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND COMPANY_ID = '{0}'", tMisMonitorTaskCompany.COMPANY_ID.ToString())); } //企业法人代码 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND COMPANY_CODE = '{0}'", tMisMonitorTaskCompany.COMPANY_CODE.ToString())); } //企业名称 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND COMPANY_NAME = '{0}'", tMisMonitorTaskCompany.COMPANY_NAME.ToString())); } //拼音编码 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.PINYIN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND PINYIN = '{0}'", tMisMonitorTaskCompany.PINYIN.ToString())); } //主管部门 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.DIRECTOR_DEPT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DIRECTOR_DEPT = '{0}'", tMisMonitorTaskCompany.DIRECTOR_DEPT.ToString())); } //经济类型 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ECONOMY_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ECONOMY_TYPE = '{0}'", tMisMonitorTaskCompany.ECONOMY_TYPE.ToString())); } //所在区域 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.AREA.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND AREA = '{0}'", tMisMonitorTaskCompany.AREA.ToString())); } //企业规模 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.SIZE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SIZE = '{0}'", tMisMonitorTaskCompany.SIZE.ToString())); } //污染源类型 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.POLLUTE_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POLLUTE_TYPE = '{0}'", tMisMonitorTaskCompany.POLLUTE_TYPE.ToString())); } //行业类别 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.INDUSTRY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND INDUSTRY = '{0}'", tMisMonitorTaskCompany.INDUSTRY.ToString())); } //废气控制级别 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.GAS_LEAVEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND GAS_LEAVEL = '{0}'", tMisMonitorTaskCompany.GAS_LEAVEL.ToString())); } //废水控制级别 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WATER_LEAVEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WATER_LEAVEL = '{0}'", tMisMonitorTaskCompany.WATER_LEAVEL.ToString())); } //开业时间 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.PRACTICE_DATE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND PRACTICE_DATE = '{0}'", tMisMonitorTaskCompany.PRACTICE_DATE.ToString())); } //联系人 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CONTACT_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CONTACT_NAME = '{0}'", tMisMonitorTaskCompany.CONTACT_NAME.ToString())); } //联系部门 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LINK_DEPT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LINK_DEPT = '{0}'", tMisMonitorTaskCompany.LINK_DEPT.ToString())); } //电子邮件 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.EMAIL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND EMAIL = '{0}'", tMisMonitorTaskCompany.EMAIL.ToString())); } //联系电话 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LINK_PHONE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LINK_PHONE = '{0}'", tMisMonitorTaskCompany.LINK_PHONE.ToString())); } //委托代理人 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.FACTOR.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FACTOR = '{0}'", tMisMonitorTaskCompany.FACTOR.ToString())); } //办公电话 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.PHONE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND PHONE = '{0}'", tMisMonitorTaskCompany.PHONE.ToString())); } //移动电话 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MOBAIL_PHONE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MOBAIL_PHONE = '{0}'", tMisMonitorTaskCompany.MOBAIL_PHONE.ToString())); } //传真号码 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.FAX.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND FAX = '{0}'", tMisMonitorTaskCompany.FAX.ToString())); } //邮政编码 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.POST.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND POST = '{0}'", tMisMonitorTaskCompany.POST.ToString())); } //联系地址 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CONTACT_ADDRESS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CONTACT_ADDRESS = '{0}'", tMisMonitorTaskCompany.CONTACT_ADDRESS.ToString())); } //监测地址 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MONITOR_ADDRESS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MONITOR_ADDRESS = '{0}'", tMisMonitorTaskCompany.MONITOR_ADDRESS.ToString())); } //企业网址 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WEB_SITE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WEB_SITE = '{0}'", tMisMonitorTaskCompany.WEB_SITE.ToString())); } //经度 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LONGITUDE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LONGITUDE = '{0}'", tMisMonitorTaskCompany.LONGITUDE.ToString())); } //纬度 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LATITUDE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND LATITUDE = '{0}'", tMisMonitorTaskCompany.LATITUDE.ToString())); } //使用状态(0为启用、1为停用) if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tMisMonitorTaskCompany.IS_DEL.ToString())); } //备注1 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisMonitorTaskCompany.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisMonitorTaskCompany.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisMonitorTaskCompany.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tMisMonitorTaskCompany.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tMisMonitorTaskCompany.REMARK5.ToString())); } //企业级别 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_LEVEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND COMPANY_LEVEL = '{0}'", tMisMonitorTaskCompany.COMPANY_LEVEL.ToString())); } //法人代表 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_MAN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND COMPANY_MAN = '{0}'", tMisMonitorTaskCompany.COMPANY_MAN.ToString())); } //废水最终排放去向 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WATER_FOLLOW.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WATER_FOLLOW = '{0}'", tMisMonitorTaskCompany.WATER_FOLLOW.ToString())); } //现有工程环评批复时间及文号 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CHECK_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CHECK_TIME = '{0}'", tMisMonitorTaskCompany.CHECK_TIME.ToString())); } //现有工程竣工环境保护验收时间 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ACCEPTANCE_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ACCEPTANCE_TIME = '{0}'", tMisMonitorTaskCompany.ACCEPTANCE_TIME.ToString())); } //执行标准 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.STANDARD.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND STANDARD = '{0}'", tMisMonitorTaskCompany.STANDARD.ToString())); } //主要环保设施名称、数量 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MAIN_APPARATUS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MAIN_APPARATUS = '{0}'", tMisMonitorTaskCompany.MAIN_APPARATUS.ToString())); } //环保设施运行情况 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.APPARATUS_STATUS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND APPARATUS_STATUS = '{0}'", tMisMonitorTaskCompany.APPARATUS_STATUS.ToString())); } //主要产品名称 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MAIN_PROJECT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MAIN_PROJECT = '{0}'", tMisMonitorTaskCompany.MAIN_PROJECT.ToString())); } //主要生产原料 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MAIN_GOOD.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MAIN_GOOD = '{0}'", tMisMonitorTaskCompany.MAIN_GOOD.ToString())); } //设计生产能力 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.DESIGN_ANBILITY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DESIGN_ANBILITY = '{0}'", tMisMonitorTaskCompany.DESIGN_ANBILITY.ToString())); } //实际生产能力 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ANBILITY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ANBILITY = '{0}'", tMisMonitorTaskCompany.ANBILITY.ToString())); } //监测期间生产负荷(%) if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CONTRACT_PER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CONTRACT_PER = '{0}'", tMisMonitorTaskCompany.CONTRACT_PER.ToString())); } //全年平均生产负荷(%) if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.AVG_PER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND AVG_PER = '{0}'", tMisMonitorTaskCompany.AVG_PER.ToString())); } //废水排放量 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WATER_COUNT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WATER_COUNT = '{0}'", tMisMonitorTaskCompany.WATER_COUNT.ToString())); } //年运行时间 if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.YEAR_TIME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND YEAR_TIME = '{0}'", tMisMonitorTaskCompany.YEAR_TIME.ToString())); } } return(strWhereStatement.ToString()); }
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"); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tMisMonitorTaskCompany">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { string strSQL = "select Count(*) from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 功能描述:保存监测任务、监测报告(验收委托) /// 创建时间:2012-12-29 /// 创建人:邵世卓 /// </summary> /// <param name="tMisMonitorTask">监测任务</param> /// <param name="tMisMonitorTaskCompanyA">监测任务委托单位</param> /// <param name="tMisMonitorTaskCompanyB">监测任务受检单位</param> /// <param name="objReportVo">监测报告</param> /// <returns></returns> public bool SaveTrans(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyA, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyB, TMisMonitorReportVo objReportVo) { return(access.SaveTrans(tMisMonitorTask, tMisMonitorTaskCompanyA, tMisMonitorTaskCompanyB, objReportVo)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tMisMonitorTaskCompany">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TMisMonitorTaskCompanyVo> SelectByObject(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, int iIndex, int iCount) { string strSQL = String.Format("select * from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany)); return(SqlHelper.ExecuteObjectList(tMisMonitorTaskCompany, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisMonitorTaskCompany"></param> /// <returns></returns> public DataTable SelectByTable(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { string strSQL = "select * from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 根据完成状态 获取监测任务完成、未完成、总和 /// </summary> /// <param name="tMisMonitorTask"></param> /// <returns></returns> public DataTable GetTaskChartCountWithStatus(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, string Dept) { return(access.GetTaskChartCountWithStatus(tMisMonitorTask, tMisMonitorTaskCompany, Dept)); }
/// <summary> /// 获取监测任务办理情况统计列表 饼图 Create By 胡方扬 2013-01-02 /// </summary> /// <param name="tMisMonitorTask"></param> /// <returns></returns> public DataTable GetTaskFinishedChart(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, string Dept, bool isFinished) { return(access.GetTaskFinishedChart(tMisMonitorTask, tMisMonitorTaskCompany, Dept, isFinished)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisMonitorTaskCompany"></param> /// <returns></returns> public DataTable SelectByTable(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { return(access.SelectByTable(tMisMonitorTaskCompany)); }
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> /// 对象明细 /// </summary> /// <param name="tMisMonitorTaskCompany">对象条件</param> /// <returns>对象</returns> public TMisMonitorTaskCompanyVo Details(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany) { string strSQL = String.Format("select * from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany)); return(SqlHelper.ExecuteObject(new TMisMonitorTaskCompanyVo(), strSQL)); }
/// <summary> /// 功能描述:保存监测任务、样品所有信息(自送样预约) /// 创建时间:2012-12-20 /// 创建人:胡方扬 /// </summary> /// <param name="tMisMonitorTask">监测任务</param> /// <param name="tMisMonitorTaskCompanyA">监测任务委托单位</param> /// <param name="tMisMonitorTaskCompanyB">监测任务受检单位</param> /// <param name="arrSubtask">监测子任务集合</param> /// <param name="arrSample">样品集合</param> /// <param name="arrSampleResult">样品结果集合</param> /// <param name="arrSampleResultApp">分析任务执行集合</param> /// <returns>布尔值</returns> public bool SaveSampleTrans(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyA, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyB, TMisMonitorReportVo objReportVo, ArrayList arrSubtask, ArrayList arrSample, ArrayList arrSampleResult, ArrayList arrSampleResultApp) { return(access.SaveSampleTrans(tMisMonitorTask, tMisMonitorTaskCompanyA, tMisMonitorTaskCompanyB, objReportVo, arrSubtask, arrSample, arrSampleResult, arrSampleResultApp)); }
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"); } }