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));
}
