public static string EditData(string strID, string strSERIAL_NAME, string strSERIAL_TYPE, string strSERIAL_RULE, string strSEARIAL_NUMBER_BIT, string strMONITOR_TYPE_ID, string strSAMPLE_SOURCE, string strStartNum, string strMaxNum, string strStatus, string strIsUnion, string strUnionSerialId, string strUnionDefault) { bool isSuccess = true; TBaseSerialruleVo objMonitorType = new TBaseSerialruleVo(); objMonitorType.ID = strID; objMonitorType.SERIAL_NAME = strSERIAL_NAME; objMonitorType.SERIAL_RULE = strSERIAL_RULE; objMonitorType.SERIAL_TYPE = strSERIAL_TYPE; objMonitorType.SERIAL_NUMBER_BIT = strSEARIAL_NUMBER_BIT; objMonitorType.SERIAL_TYPE_ID = strMONITOR_TYPE_ID; objMonitorType.SAMPLE_SOURCE = strSAMPLE_SOURCE; objMonitorType.SERIAL_START_NUM = strStartNum; objMonitorType.SERIAL_MAX_NUM = strMaxNum; objMonitorType.STATUS = strStatus; objMonitorType.SERIAL_YEAR = DateTime.Now.Year.ToString(); objMonitorType.IS_UNION = strIsUnion; objMonitorType.UNION_SEARIAL_ID = strUnionSerialId; objMonitorType.UNION_DEFAULT = strUnionDefault; isSuccess = new TBaseSerialruleLogic().Edit(objMonitorType); if (isSuccess) { return("1"); } else { return("0"); } }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseSerialrule_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseSerialrule_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseSerialruleVo tBaseSerialrule_UpdateSet, TBaseSerialruleVo tBaseSerialrule_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseSerialrule_UpdateSet, TBaseSerialruleVo.T_BASE_SERIALRULE_TABLE); strSQL += this.BuildWhereStatement(tBaseSerialrule_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
//获取监测类别数据 private void GetData() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; int intPageIdx = Convert.ToInt32(Request.Params["page"]); int intPagesize = Convert.ToInt32(Request.Params["pagesize"]); TBaseSerialruleVo objMonitorType = new TBaseSerialruleVo(); objMonitorType.SORT_FIELD = strSortname; objMonitorType.SORT_TYPE = strSortorder; TBaseSerialruleLogic logicMonitorType = new TBaseSerialruleLogic(); int intTotalCount = logicMonitorType.GetSelectResultCount(objMonitorType); //总计的数据条数 DataTable dt = logicMonitorType.SelectByTable(objMonitorType, intPageIdx, intPagesize); DataView dtView = dt.DefaultView; dtView.Sort = " ID ASC"; dt = dtView.ToTable(); string strJson = CreateToJson(dt, intTotalCount); Response.Write(strJson); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseSerialrule">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseSerialruleVo tBaseSerialrule) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseSerialrule, TBaseSerialruleVo.T_BASE_SERIALRULE_TABLE); strSQL += string.Format(" where ID='{0}' ", tBaseSerialrule.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public static string deleteData(string strDelIDs) { if (strDelIDs.Length == 0) { return("0"); } string[] arrDelIDs = strDelIDs.Split(','); bool isSuccess = true; for (int i = 0; i < arrDelIDs.Length; i++) { TBaseSerialruleVo objMonitorType = new TBaseSerialruleVo(); objMonitorType.ID = arrDelIDs[i]; isSuccess = new TBaseSerialruleLogic().Delete(objMonitorType); } if (isSuccess) { return("1"); } else { return("0"); } }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseSerialrule">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseSerialruleVo tBaseSerialrule, int iIndex, int iCount) { string strSQL = " select * from T_BASE_SERIALRULE {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseSerialrule)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseSerialruleVo tBaseSerialrule) { string strSQL = "delete from T_BASE_SERIALRULE "; strSQL += this.BuildWhereStatement(tBaseSerialrule); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
public static string getReportCode() { //return GetSerialNumber("t_report_code"); TBaseSerialruleVo SerialruleVo = new TBaseSerialruleVo(); SerialruleVo.SERIAL_TYPE = "3"; return(CreateBaseDefineCode(SerialruleVo)); }
/// <summary> /// 获取辅助编号数据 /// </summary> /// <returns></returns> public string GetUnionCode() { string result = ""; TBaseSerialruleVo objItems = new TBaseSerialruleVo(); objItems.SERIAL_TYPE = "5"; DataTable dt = new TBaseSerialruleLogic().SelectByTable(objItems); result = LigerGridDataToJson(dt, dt.Rows.Count); return(result); }
/// <summary> /// 功能描述:样品生成规则 Create By Castle(胡方扬) 2014-04-19 /// </summary> /// <param name="strSampleID"></param> /// <returns></returns> protected static string GetSampleCode(string strSampleID) { string strSampleCode = ""; TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strSampleID); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; strSampleCode = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); return(strSampleCode); }
/// <summary> /// 验证是否跨年度,如果跨年,则把符合条件的(启用了跨年重新编号的) 胡方扬 2013-04-24 /// </summary> /// <param name="tBaseSerialrule"></param> /// <param name="strNowYear"></param> /// <returns></returns> public bool UpdateInitStartNumForNewYear(TBaseSerialruleVo tBaseSerialrule, string strNowYear) { if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_YEAR) && !String.IsNullOrEmpty(tBaseSerialrule.ID) && !String.IsNullOrEmpty(strNowYear)) { if (tBaseSerialrule.SERIAL_YEAR != strNowYear) { string strSQL = String.Format(" UPDATE T_BASE_SERIALRULE SET SERIAL_START_NUM='1', SERIAL_YEAR='{0}' WHERE ID='{1}' AND STATUS='1'", strNowYear, tBaseSerialrule.ID); if (SqlHelper.ExecuteNonQuery(strSQL) > 0) { return(true); } } } return(false); }
/// <summary> /// 获取监测项目信息 /// </summary> /// <returns></returns> private string getThreeGridInfo(string strTwoGridId, string strTaskID) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); DataTable dt = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet(strTaskID, strTwoGridId, "021"); //样品编号生成 for (int i = 0; i < dt.Rows.Count; i++) { TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString()); if (objSample.SAMPLE_CODE.Length == 0) { //objSample.SAMPLE_CODE = GetSampleCode_QHD(dt.Rows[i]["ID"].ToString()); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); 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); new TMisMonitorSampleInfoLogic().Edit(objSample); dt.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE; } } int intTotalCount = dt.Rows.Count; string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 验证是否跨年度、日度,如果跨年、日,则把符合条件的(启用了跨年、跨日重新编号的) 胡方扬 2013-04-24 /// </summary> /// <param name="tBaseSerialrule"></param> /// <param name="strNowYear"></param> /// <param name="strNowDay"></param> /// <returns></returns> public bool UpdateInitStartNumForNewYear(TBaseSerialruleVo tBaseSerialrule, string strNowYear, string strNowDay) { string strSQL = ""; ArrayList objVo = new ArrayList(); if (!String.IsNullOrEmpty(tBaseSerialrule.ID) && !String.IsNullOrEmpty(strNowYear) && String.IsNullOrEmpty(strNowDay)) { if (tBaseSerialrule.SERIAL_YEAR != strNowYear) { strSQL = String.Format(" UPDATE T_BASE_SERIALRULE SET SERIAL_START_NUM='1', SERIAL_YEAR='{0}' WHERE ID='{1}'", strNowYear, tBaseSerialrule.ID); objVo.Add(strSQL); } } if (!String.IsNullOrEmpty(tBaseSerialrule.ID) && String.IsNullOrEmpty(strNowYear) && !String.IsNullOrEmpty(strNowDay)) { if (tBaseSerialrule.SERIAL_DAY != strNowDay) { strSQL = String.Format(" UPDATE T_BASE_SERIALRULE SET SERIAL_START_NUM='1', SERIAL_DAY='{0}' WHERE ID='{1}'", strNowDay, tBaseSerialrule.ID); objVo.Add(strSQL); } } return(SqlHelper.ExecuteSQLByTransaction(objVo)); }
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="tBaseSerialrule">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseSerialruleVo tBaseSerialrule) { string strSQL = SqlHelper.BuildInsertExpress(tBaseSerialrule, TBaseSerialruleVo.T_BASE_SERIALRULE_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tBaseSerialrule"></param> /// <returns></returns> public string BuildWhereStatement(TBaseSerialruleVo tBaseSerialrule) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tBaseSerialrule) { // if (!String.IsNullOrEmpty(tBaseSerialrule.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseSerialrule.ID.ToString())); } // if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_NAME = '{0}'", tBaseSerialrule.SERIAL_NAME.ToString())); } //编码规则 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_RULE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_RULE = '{0}'", tBaseSerialrule.SERIAL_RULE.ToString())); } //类型 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_TYPE = '{0}'", tBaseSerialrule.SERIAL_TYPE.ToString())); } //编码位数 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_NUMBER_BIT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_NUMBER_BIT = '{0}'", tBaseSerialrule.SERIAL_NUMBER_BIT.ToString())); } //使用该编码的监测类别 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_TYPE_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_TYPE_ID = '{0}'", tBaseSerialrule.SERIAL_TYPE_ID.ToString())); } //样品来源,1为抽样,2为自送样 if (!String.IsNullOrEmpty(tBaseSerialrule.SAMPLE_SOURCE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SAMPLE_SOURCE = '{0}'", tBaseSerialrule.SAMPLE_SOURCE.ToString())); } // 初始编号 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_START_NUM.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_START_NUM = '{0}'", tBaseSerialrule.SERIAL_START_NUM.ToString())); } //最大编号 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_MAX_NUM.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_MAX_NUM = '{0}'", tBaseSerialrule.SERIAL_MAX_NUM.ToString())); } //是否启用年度重新编号 if (!String.IsNullOrEmpty(tBaseSerialrule.STATUS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND STATUS = '{0}'", tBaseSerialrule.STATUS.ToString())); } //当前创建年度 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_YEAR.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_YEAR = '{0}'", tBaseSerialrule.SERIAL_YEAR.ToString())); } //是否联合编号 if (!String.IsNullOrEmpty(tBaseSerialrule.IS_UNION.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_UNION = '{0}'", tBaseSerialrule.IS_UNION.ToString())); } //样品联合编号的组合编号ID if (!String.IsNullOrEmpty(tBaseSerialrule.UNION_SEARIAL_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND UNION_SEARIAL_ID = '{0}'", tBaseSerialrule.UNION_SEARIAL_ID.ToString())); } //辅助规则缺省值 if (!String.IsNullOrEmpty(tBaseSerialrule.UNION_DEFAULT.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND UNION_DEFAULT = '{0}'", tBaseSerialrule.UNION_DEFAULT.ToString())); } //跨天是否从新编号 if (!String.IsNullOrEmpty(tBaseSerialrule.DAY_STATUS.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DAY_STATUS = '{0}'", tBaseSerialrule.DAY_STATUS.ToString())); } //编号当天日期 if (!String.IsNullOrEmpty(tBaseSerialrule.SERIAL_DAY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SERIAL_DAY = '{0}'", tBaseSerialrule.SERIAL_DAY.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 如果编号被使用则,立刻更新初始化编号 胡方扬 2013-04-24 /// </summary> /// <param name="tBaseSerialrule"></param> /// <returns></returns> public bool UpdateSerialNum(TBaseSerialruleVo tBaseSerialrule) { string strSQL = String.Format(" UPDATE T_BASE_SERIALRULE SET SERIAL_START_NUM=SERIAL_START_NUM+1 WHERE ID='{0}'", tBaseSerialrule.ID); return(SqlHelper.ExecuteNonQuery(strSQL) > 0?true:false); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseSerialrule">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseSerialruleVo> SelectByObject(TBaseSerialruleVo tBaseSerialrule, int iIndex, int iCount) { string strSQL = String.Format("select * from T_BASE_SERIALRULE " + this.BuildWhereStatement(tBaseSerialrule)); return(SqlHelper.ExecuteObjectList(tBaseSerialrule, BuildPagerExpress(strSQL, iIndex, iCount))); }
public static bool QcSave(string strSampleID, string strQcType, string strItemId, string iSampleCode) { deleteSampleInfo(strSampleID, strQcType); bool isSuccess = true; if (strItemId == "") { return(isSuccess); } string strSourceResultId = ""; //添加现场空白样 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strSampleID); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.QC_TYPE = strQcType; objSample.QC_SOURCE_ID = strSampleID; //objSample.SAMPLE_CODE = GetSampleCode_QHD(strSampleID); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; if (iSampleCode == "Y") { objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); } objSample.SAMPLE_NAME += "现场空白"; objSample.SAMPLE_COUNT = ""; if (!new TMisMonitorSampleInfoLogic().Create(objSample)) { isSuccess = false; } for (int i = 0; i < strItemId.Split(',').Length; i++) { //根据监测项目查询原始样结果表信息 TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult.SAMPLE_ID = strSampleID; objResult.QC_TYPE = "0"; objResult.ITEM_ID = strItemId.Split(',')[i]; objResult = new TMisMonitorResultLogic().Details(objResult); //根据监测项目将空白样信息添加到结果表中 strSourceResultId = objResult.ID; objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = objSample.ID; objResult.QC_TYPE = strQcType; objResult.QC_SOURCE_ID = strSourceResultId; objResult.SOURCE_ID = strSourceResultId; objResult.QC = "###"; if (!new TMisMonitorResultLogic().Create(objResult)) { isSuccess = false; } InsertResultAPP(objResult.ID); //将空白信息添加到现场空白结果表中 TMisMonitorQcEmptyOutVo objQcEmpty = new TMisMonitorQcEmptyOutVo(); objQcEmpty.ID = GetSerialNumber("QC_EMPTY_OUT"); objQcEmpty.RESULT_ID_SRC = strSourceResultId; objQcEmpty.RESULT_ID_EMPTY = objResult.ID; if (!new TMisMonitorQcEmptyOutLogic().Create(objQcEmpty)) { isSuccess = false; } } return(isSuccess); }
private static bool createQcInfo(string strSampleID, string strQcType, string strItemId, string iSampleCode) { bool isSuccess = true; if (strItemId == "") { return(isSuccess); } TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strSampleID); string strQcSampleId = GetSerialNumber("MonitorSampleId"); objSample.ID = strQcSampleId; objSample.QC_TYPE = strQcType; objSample.QC_SOURCE_ID = strSampleID; //objSample.SAMPLE_CODE = GetSampleCode_QHD(strSampleID); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; if (iSampleCode == "Y") { objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); } if (strQcType == "3") { objSample.SAMPLE_NAME += "现场平行"; } if (strQcType == "4") { objSample.SAMPLE_NAME += "密码平行"; } objSample.SAMPLE_COUNT = ""; //在样品表中添加样品数据 if (!new TMisMonitorSampleInfoLogic().Create(objSample)) { isSuccess = false; } //遍历监测项目信息,将监测项目信息添加到结果表、结果分析执行表、平行样结果表中 for (int i = 0; i < strItemId.Split(',').Length; i++) { //根据需要做质控的监测项目获取原始样的结果表ID TMisMonitorResultVo objSourceResult = new TMisMonitorResultVo(); objSourceResult.SAMPLE_ID = strSampleID; objSourceResult.QC_TYPE = "0"; objSourceResult.ITEM_ID = strItemId.Split(',')[i]; TMisMonitorResultVo objResult = new TMisMonitorResultLogic().Details(objSourceResult); string strSourceId = objResult.ID; //将数据写入结果表中 objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = strQcSampleId; objResult.QC_TYPE = strQcType; objResult.SOURCE_ID = strSourceId; objResult.QC_SOURCE_ID = strSourceId; if (!new TMisMonitorResultLogic().Create(objResult)) { isSuccess = false; } //将数据写入结果分析执行表中 InsertResultAPP(objResult.ID); //将结果写入分析样结果表中 TMisMonitorQcTwinVo objQcTwin = new TMisMonitorQcTwinVo(); objQcTwin.ID = GetSerialNumber("QcTwinId"); objQcTwin.RESULT_ID_SRC = strSourceId; objQcTwin.RESULT_ID_TWIN1 = objResult.ID; objQcTwin.QC_TYPE = strQcType; if (!new TMisMonitorQcTwinLogic().Create(objQcTwin)) { isSuccess = false; } } return(isSuccess); }
public static string btnSendClick(string strWorkTask_Id, string strPlanID, string strSampleAskDate, string strSampleFinishDate, string strTicketNum, string strQCStatus) { bool IsSuccess = true; TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); objTask.ID = strWorkTask_Id; objTask.PLAN_ID = strPlanID; objTask = new TMisMonitorTaskLogic().Details(objTask); TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); objSubTask.TASK_ID = objTask.ID; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask); //判断是否经过质控,如果经过质控,则将数据发送到质控环节 if (!String.IsNullOrEmpty(strQCStatus) && strQCStatus == "1") { TMisMonitorTaskVo objTaskEdit = new TMisMonitorTaskVo(); objTaskEdit.ID = objTask.ID; objTaskEdit.QC_STATUS = "2"; objTaskEdit.TICKET_NUM = strTicketNum; objTaskEdit.ASKING_DATE = strSampleFinishDate;//黄进军添加20140901 //如果是环境质量类 将 SEND_STATUS 设置为1 if (objTask.TASK_TYPE == "1") { objTaskEdit.SEND_STATUS = "1"; } else { //分配任务报告编制人 if (objTask.REPORT_HANDLE == "") { objTaskEdit.REPORT_HANDLE = getNextReportUserID("Report_UserID"); } } if (new TMisMonitorTaskLogic().Edit(objTaskEdit)) { for (int i = 0; i < dt.Rows.Count; i++) { objSubTask.ID = dt.Rows[i]["ID"].ToString(); //objSubTask.SAMPLE_ASK_DATE = strSampleAskDate; objSubTask.SAMPLE_FINISH_DATE = strSampleFinishDate; if (!new TMisMonitorSubtaskLogic().Edit(objSubTask)) { IsSuccess = false; } } } } //如果不需要质控,则直接发送到采样环节 else { for (int i = 0; i < dt.Rows.Count; i++) { objSubTask.ID = dt.Rows[i]["ID"].ToString(); objSubTask.TASK_STATUS = "02"; objSubTask.TASK_TYPE = "发送"; //objSubTask.SAMPLE_ASK_DATE = strSampleAskDate; objSubTask.SAMPLE_FINISH_DATE = strSampleFinishDate; if (!new TMisMonitorSubtaskLogic().Edit(objSubTask)) { IsSuccess = false; } } if (IsSuccess) { TMisMonitorTaskVo objTaskEdit = new TMisMonitorTaskVo(); objTaskEdit.ID = objTask.ID; objTaskEdit.TICKET_NUM = strTicketNum; objTaskEdit.ASKING_DATE = strSampleFinishDate; //黄进军添加20140901 objTaskEdit.QC_STATUS = "8"; //表示已经完成质控设置 //如果是环境质量类 将 SEND_STATUS 设置为1 if (objTask.TASK_TYPE == "1") { objTaskEdit.SEND_STATUS = "1"; } else { //分配任务报告编制人 if (objTask.REPORT_HANDLE == "") { objTaskEdit.REPORT_HANDLE = getNextReportUserID("Report_UserID"); } } new TMisMonitorTaskLogic().Edit(objTaskEdit); TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(strPlanID); objPlan.HAS_DONE = "1"; new TMisContractPlanLogic().Edit(objPlan); } } TMisMonitorSubtaskAppVo objSubApp = new TMisMonitorSubtaskAppVo(); TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; List <TMisMonitorSampleInfoVo> list = new List <TMisMonitorSampleInfoVo>(); for (int i = 0; i < dt.Rows.Count; i++) { 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.SAMPLE_ASSIGN_ID = new PageBase().LogInfo.UserInfo.ID; objSubApp.SAMPLE_ASSIGN_DATE = DateTime.Now.ToString(); new TMisMonitorSubtaskAppLogic().Edit(objSubApp); } else { objSubApp.ID = GetSerialNumber("TMisMonitorSubtaskAppID"); objSubApp.SUBTASK_ID = dt.Rows[i]["ID"].ToString(); objSubApp.SAMPLE_ASSIGN_ID = new PageBase().LogInfo.UserInfo.ID; objSubApp.SAMPLE_ASSIGN_DATE = DateTime.Now.ToString(); new TMisMonitorSubtaskAppLogic().Create(objSubApp); } //噪声除外的所有样品设置样品编号 Create By weilin 2014-03-19 if (dt.Rows[i]["MONITOR_ID"].ToString() != "000000004" && dt.Rows[i]["MONITOR_ID"].ToString() != "FunctionNoise" && dt.Rows[i]["MONITOR_ID"].ToString() != "AreaNoise" && dt.Rows[i]["MONITOR_ID"].ToString() != "EnvRoadNoise") { objSubTask = new TMisMonitorSubtaskLogic().Details(dt.Rows[i]["ID"].ToString()); objSample = new TMisMonitorSampleInfoVo(); objSample.SUBTASK_ID = dt.Rows[i]["ID"].ToString(); list = new TMisMonitorSampleInfoLogic().SelectByObject(objSample, 0, 0); for (int j = 0; j < list.Count; j++) { if (list[j].SAMPLE_CODE.Length == 0) { objSample.ID = list[j].ID; if (objTask.TASK_TYPE == "1") { objSample.SAMPLE_CODE = list[j].SAMPLE_NAME; } else { objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubTask); } new TMisMonitorSampleInfoLogic().Edit(objSample); } } } } SplitAcceptTask(strWorkTask_Id, objSerial); return(IsSuccess == true ? "1" : "0"); //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; //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 objSubtaskApp = new TMisMonitorSubtaskAppVo(); // //objSubtaskApp.ID = GetSerialNumber("TMisMonitorSubtaskAppID"); // //objSubtaskApp.SUBTASK_ID = objSubTask.ID; // //objSubtaskApp.SAMPLE_ASSIGN_ID = LogInfo.UserInfo.ID; // //objSubtaskApp.SAMPLE_ASSIGN_DATE = DateTime.Now.ToString(); // //new TMisMonitorSubtaskAppLogic().Create(objSubtaskApp); //} //if (IsSuccess) //{ // TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(strPlanID); // objPlan.HAS_DONE = "1"; // new TMisContractPlanLogic().Edit(objPlan); //} //return IsSuccess == true ? "1" : "0"; }
/// <summary> /// 获取监测项目信息 /// </summary> /// <returns></returns> private string getThreeGridInfo(string strTwoGridId, string strTaskID) { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); var strCCflowWorkId = Request.QueryString["strCCflowWorkId"]; var identification = CCFlowFacade.GetFlowIdentification(LogInfo.UserInfo.USER_NAME, Convert.ToInt64(strCCflowWorkId)); var sampleIdList = identification.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries).ToList(); if (sampleIdList.Count > 0) { sampleIdList.RemoveAt(0); } DataTable dt = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet_MAS(strTaskID, strTwoGridId, "1,2"); var newDT = new DataTable(); foreach (DataColumn column in dt.Columns) { newDT.Columns.Add(column.ColumnName); } //样品编号生成 for (int i = 0; i < dt.Rows.Count; i++) { if (sampleIdList.Count > 0 && !sampleIdList.Contains(dt.Rows[i]["ID"].ToString())) { continue; } TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString()); TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); if (objSample.SAMPLE_CODE.Length == 0) { //objSample.SAMPLE_CODE = GetSampleCode_QHD(dt.Rows[i]["ID"].ToString()); TBaseSerialruleVo objSerial = new TBaseSerialruleVo(); objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE; objSerial.SERIAL_TYPE = "2"; objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd"); if (objTask.TASK_TYPE == "1") { objSample.SAMPLE_CODE = objSample.SAMPLE_NAME; } else { objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask); } new TMisMonitorSampleInfoLogic().Edit(objSample); dt.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE; } //样品状态,外委除外(废水、地表水) if (objTask.CONTRACT_TYPE != "04") { DataTable dtAtt = new DataTable(); string strAttValue = string.Empty; string strAttID = "''"; if (objSubtask.MONITOR_ID == "000000001" || objSubtask.MONITOR_ID == "EnvDrinkingSource") { strAttID = "'000000017'"; } if (objSubtask.MONITOR_ID == "EnvRiver") { strAttID = "'000000211'"; } dtAtt = new i3.BusinessLogic.Channels.Base.DynamicAttribute.TBaseAttributeInfoLogic().GetAttValue(strAttID, dt.Rows[i]["POINT_ID"].ToString()); for (int j = 0; j < dtAtt.Rows.Count; j++) { strAttValue += dtAtt.Rows[j]["ATTRBUTE_TEXT"].ToString() + "、"; } dt.Rows[i]["SAMPLE_STATUS"] = strAttValue.TrimEnd('、'); } newDT.Rows.Add(dt.Rows[i].ItemArray); } int intTotalCount = newDT.Rows.Count; string strJson = CreateToJson(newDT, intTotalCount); return(strJson); }
public static string SaveData(string strPointID, string strSubtaskID, string strPOINT_NAME, string strMONITOR_ID, string strPOINT_TYPE, string strDYNAMIC_ATTRIBUTE_ID, string strSAMPLEFREQ, 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 = "1"; objPoint.SAMPLE_FREQ = strSAMPLEFREQ; 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 = "1"; objnewPoint.SAMPLE_FREQ = strSAMPLEFREQ; 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; //新增点位时候,自动生成该点位的样品编码 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); 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"); } }
public static bool QcSave(string strSampleID, string strQcType, string strItemId, string strQcAddValue, string strRemark1, string strRemark2, string strRemark3) { deleteSampleInfo(strSampleID, strQcType); bool isSuccess = true; if (strItemId == "") { return(isSuccess); } string strSourceResultId = ""; TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strSampleID); objSample.ID = GetSerialNumber("MonitorSampleId"); objSample.QC_TYPE = strQcType; objSample.QC_SOURCE_ID = strSampleID; objSample.SAMPLE_NAME += "现场加标"; objSample.SAMPLE_COUNT = ""; //objSample.SAMPLE_CODE = GetSampleCode_QHD(strSampleID); //新增点位时候,自动生成该点位的样品编码 TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); 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); if (!new TMisMonitorSampleInfoLogic().Create(objSample)) { isSuccess = false; } for (int i = 0; i < strItemId.Split(',').Length; i++) { TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult.SAMPLE_ID = strSampleID; objResult.QC_TYPE = "0"; objResult.ITEM_ID = strItemId.Split(',')[i]; objResult = new TMisMonitorResultLogic().Details(objResult); strSourceResultId = objResult.ID; objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = objSample.ID; objResult.QC_TYPE = strQcType; objResult.QC_SOURCE_ID = strSourceResultId; objResult.SOURCE_ID = strSourceResultId; objResult.QC = "###"; if (!new TMisMonitorResultLogic().Create(objResult)) { isSuccess = false; } InsertResultAPP(objResult.ID); TMisMonitorQcAddVo objQcAdd = new TMisMonitorQcAddVo(); objQcAdd.ID = GetSerialNumber("QcAddId"); objQcAdd.RESULT_ID_SRC = strSourceResultId; objQcAdd.RESULT_ID_ADD = objResult.ID; objQcAdd.QC_TYPE = strQcType; objQcAdd.QC_ADD = strQcAddValue.Split(',')[i]; objQcAdd.REMARK1 = strRemark1.Split(',')[i]; objQcAdd.REMARK2 = strRemark2.Split(',')[i]; objQcAdd.REMARK3 = strRemark3.Split(',')[i]; if (!new TMisMonitorQcAddLogic().Create(objQcAdd)) { isSuccess = false; } } return(isSuccess); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseSerialrule"></param> /// <returns></returns> public DataTable SelectByTable(TBaseSerialruleVo tBaseSerialrule) { return(access.SelectByTable(tBaseSerialrule)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseSerialrule">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseSerialruleVo tBaseSerialrule) { string strSQL = "select Count(*) from T_BASE_SERIALRULE " + this.BuildWhereStatement(tBaseSerialrule); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
private static bool createQcInfo(string strSubTaskId, string strQcType, string strItemId) { bool isSuccess = true; if (strItemId == "") { return(isSuccess); } TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo(); string strQcSampleId = GetSerialNumber("MonitorSampleId"); objSample.ID = strQcSampleId; objSample.SUBTASK_ID = strSubTaskId; objSample.QC_TYPE = strQcType; //objSample.SAMPLE_CODE = GetSampleCode_QHD(strQcSampleId); //新增点位时候,自动生成该点位的样品编码 TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID); TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID); 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); objSample.NOSAMPLE = "1"; if (strQcType == "10") { objSample.SAMPLE_NAME = "空白加标样"; } objSample.SAMPLE_COUNT = ""; //在样品表中添加样品数据 if (!new TMisMonitorSampleInfoLogic().Create(objSample)) { isSuccess = false; } //遍历监测项目信息,将监测项目信息添加到结果表、结果分析执行表、空白加标表中 for (int i = 0; i < strItemId.Split(',').Length; i++) { //将数据写入结果表中 TMisMonitorResultVo objResult = new TMisMonitorResultVo(); objResult.ID = GetSerialNumber("MonitorResultId"); objResult.SAMPLE_ID = strQcSampleId; objResult.QC_TYPE = strQcType; objResult.ITEM_ID = strItemId.Split(',')[i]; //填充默认分析方法和方法依据 TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = objResult.ITEM_ID; objItemAnalysis.IS_DEFAULT = "是"; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); if (objItemAnalysis.ID.Length == 0) { objItemAnalysis = new TBaseItemAnalysisVo(); objItemAnalysis.ITEM_ID = objResult.ITEM_ID; objItemAnalysis.IS_DEL = "0"; objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis); } if (objItemAnalysis.ID.Length > 0) { TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID); objResult.ANALYSIS_METHOD_ID = objMethod.ID; objResult.STANDARD_ID = objMethod.METHOD_ID; } objResult.ANALYSIS_METHOD_ID = ""; objResult.STANDARD_ID = ""; objResult.TASK_TYPE = "发送"; objResult.RESULT_STATUS = "01"; if (!new TMisMonitorResultLogic().Create(objResult)) { isSuccess = false; } //将数据写入结果分析执行表中 InsertResultAPP(objResult.ID); //将结果写入分析样结果表中 TMisMonitorQcAddQhdVo objQcAdd = new TMisMonitorQcAddQhdVo(); objQcAdd.ID = GetSerialNumber("QcAddId_QHD"); objQcAdd.RESULT_ID_ADD = objResult.ID; objQcAdd.QC_TYPE = strQcType; if (!new TMisMonitorQcAddQhdLogic().Create(objQcAdd)) { isSuccess = false; } } return(isSuccess); }
/// <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> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseSerialrule"></param> /// <returns></returns> public DataTable SelectByTable(TBaseSerialruleVo tBaseSerialrule) { string strSQL = "select * from T_BASE_SERIALRULE " + this.BuildWhereStatement(tBaseSerialrule); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseSerialrule">对象条件</param> /// <returns>对象</returns> public TBaseSerialruleVo Details(TBaseSerialruleVo tBaseSerialrule) { string strSQL = String.Format("select * from T_BASE_SERIALRULE " + this.BuildWhereStatement(tBaseSerialrule)); return(SqlHelper.ExecuteObject(new TBaseSerialruleVo(), strSQL)); }