/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisMonitorReport">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisMonitorReportVo tMisMonitorReport, int iIndex, int iCount)
{
string strSQL = " select * from T_MIS_MONITOR_REPORT {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorReport));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorReport_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisMonitorReport_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorReportVo tMisMonitorReport_UpdateSet, TMisMonitorReportVo tMisMonitorReport_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorReport_UpdateSet, TMisMonitorReportVo.T_MIS_MONITOR_REPORT_TABLE);
strSQL += this.BuildWhereStatement(tMisMonitorReport_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取任务信息Json
/// </summary>
/// <returns></returns>
protected string getTaskInfo()
{
//任务ID
string strTaskID = Request.Params.AllKeys.Contains("task_id") ? Request.QueryString["task_id"].ToString() : this.TASK_ID.Value;
TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskVo();
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
if (!string.IsNullOrEmpty(strTaskID))
{
objTaskVo = new TMisMonitorTaskLogic().GetContractTaskInfo(strTaskID);
objReport = new TMisMonitorReportLogic().Details(new TMisMonitorReportVo()
{
TASK_ID = strTaskID
});
}
if (objTaskVo != null)
{
try
{
objTaskVo.CONSIGN_DATE = DateTime.Parse(objTaskVo.CONSIGN_DATE.ToString()).ToString("yyyy-MM-dd");
}
catch { }
}
//定制数据
objTaskVo.REMARK1 = objReport.REPORT_CODE;//报告编号
return(ToJson(objTaskVo));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorReport">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorReportVo tMisMonitorReport)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorReport, TMisMonitorReportVo.T_MIS_MONITOR_REPORT_TABLE);
strSQL += string.Format(" where ID='{0}' ", tMisMonitorReport.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获得委托书基本信息
/// </summary>
/// <returns>Json</returns>
protected string GetContractInfo()
{
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
if (!string.IsNullOrEmpty(this.ID.Value))
{
objTask = new TMisMonitorTaskLogic().GetContractTaskInfo(this.ID.Value);
objReport = new TMisMonitorReportLogic().Details(new TMisMonitorReportVo()
{
TASK_ID = this.ID.Value
});
}
if (objTask != null)
{
try
{
objTask.CONSIGN_DATE = DateTime.Parse(objTask.CONSIGN_DATE.ToString()).ToString("yyyy-MM-dd");
}
catch { }
}
//定制数据
objTask.REMARK1 = objReport.REPORT_CODE; //报告编号
//objTask.REMARK2 = objTask.REMARK5.Length > 0 ? objTask.REMARK5 : AutoSaveConclusion(this.ID.Value);//总监测任务的监测结论
objTask.REMARK2 = objTask.REMARK5; //总监测任务的监测结论
objTask.REMARK3 = GetMonitorType(this.ID.Value); //报告类别 废水，废气...
objTask.REMARK4 = GetRemark(this.ID.Value); //委托书备注信息 四个同意
return(ToJson(objTask));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisMonitorReportVo tMisMonitorReport)
{
string strSQL = "delete from T_MIS_MONITOR_REPORT ";
strSQL += this.BuildWhereStatement(tMisMonitorReport);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
protected void SetReport(string strContractID)
{
//获取委托书信息
TMisContractVo objContract = new TMisContractLogic().Details(strContractID);
#region 构造监测任务对象
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
CopyObject(objContract, objTask);
objTask.ID = GetSerialNumber("t_mis_monitor_taskId");
objTask.CONTRACT_ID = objContract.ID;
objTask.PLAN_ID = "";
objTask.CONSIGN_DATE = objContract.ASKING_DATE;
objTask.CREATOR_ID = LogInfo.UserInfo.ID;
objTask.CREATE_DATE = DateTime.Now.ToString();
objTask.TASK_STATUS = "09";
objTask.COMFIRM_STATUS = "0";
#endregion
#region 构造监测任务委托企业信息
//委托企业信息
TMisContractCompanyVo objContractClient = new TMisContractCompanyLogic().Details(objContract.CLIENT_COMPANY_ID);
//受检企业信息
TMisContractCompanyVo objContractTested = new TMisContractCompanyLogic().Details(objContract.TESTED_COMPANY_ID);
//构造监测任务委托企业信息
TMisMonitorTaskCompanyVo objTaskClient = new TMisMonitorTaskCompanyVo();
CopyObject(objContractClient, objTaskClient);//复制对象
objTaskClient.ID = GetSerialNumber("t_mis_monitor_taskcompanyId");
objTaskClient.TASK_ID = objTask.ID;
objTaskClient.COMPANY_ID = objContract.CLIENT_COMPANY_ID;
//构造监测任务受检企业信息
TMisMonitorTaskCompanyVo objTaskTested = new TMisMonitorTaskCompanyVo();
CopyObject(objContractTested, objTaskTested);//复制对象
objTaskTested.ID = GetSerialNumber("t_mis_monitor_taskcompanyId");
objTaskTested.TASK_ID = objTask.ID;
objTaskTested.COMPANY_ID = objContract.TESTED_COMPANY_ID;
//重新赋值监测任务企业ID
objTask.CLIENT_COMPANY_ID = objTaskClient.ID;
objTask.TESTED_COMPANY_ID = objTaskTested.ID;
#endregion
#region 构造监测报告
TMisMonitorReportVo objReportVo = new TMisMonitorReportVo();
objReportVo.ID = GetSerialNumber("t_mis_monitor_report_id");
objReportVo.TASK_ID = objTask.ID;
objReportVo.REPORT_CODE = objTask.CONTRACT_CODE;
objReportVo.REPORT_EX_ATTACHE_ID = GetAttID(objTask.CONTRACT_ID, "AcceptanceContract");
objReportVo.IF_GET = "0";
if (new TMisMonitorTaskLogic().SaveTrans(objTask, objTaskClient, objTaskTested, objReportVo))
{
WriteLog("生成验收委托监测任务", "", LogInfo.UserInfo.USER_NAME + "生成验收委托监测任务" + objTask.ID + "成功");
}
#endregion
}
/// <summary>
/// 报告编制任务发配
/// </summary>
protected void sendReporter()
{
string strReportId = Request.QueryString["report_id"];//报告ID
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
objReport.ID = strReportId;
objReport.IF_SEND = "1";
if (new TMisMonitorReportLogic().Edit(objReport))
{
WriteLog("分配报告编制任务", "", LogInfo.UserInfo.USER_NAME + "发配报告" + strReportId);
}
}
/// <summary>
/// 报告领取信息
/// </summary>
/// <param name="tMisMonitorReport">报告对象</param>
/// <param name="tMisMonitorTask">监测任务对象</param>
/// <param name="pageIndex">页序号</param>
/// <param name="pageSize">单页显示数</param>
/// <returns>返回数据集</returns>
public DataTable SelectByTableForManager(TMisMonitorReportVo tMisMonitorReport, TMisMonitorTaskVo tMisMonitorTask, int pageIndex, int pageSize)
{
string strSQL = "select report.ID,report.REPORT_CODE,report.REMARK1 ,task.CONTRACT_ID,report.TASK_ID," +
" (CASE fee.IF_PAY WHEN '1' THEN '已缴费' WHEN '2' THEN '未缴费(已启动)' ELSE '未缴费' END) as IS_FEE," +
" (CASE report.IF_GET WHEN '1' THEN '已领取' ELSE '未领取' END) as IF_GET," +
" task.CONTRACT_TYPE,task.CONTRACT_CODE,task.PROJECT_NAME,task.CLIENT_COMPANY_ID," +
" (case when task.CONSIGN_DATE is not null then convert(nvarchar(16),task.CONSIGN_DATE,23) else '' end) as CONSIGN_DATE" +
" from (select * from T_MIS_MONITOR_REPORT {0}) report " +
" join (select * from T_MIS_MONITOR_TASK {1}) task on report.TASK_ID=task.ID" +
" left join T_MIS_CONTRACT_FEE fee on fee.CONTRACT_ID=task.CONTRACT_ID order by report.REMARK1 desc";
#region 监测任务查询条件构造 strTaskWhere
string strTaskWhere = " where 1=1 and TASK_STATUS='" + tMisMonitorTask.TASK_STATUS + "'";
//委托书编号
if (!string.IsNullOrEmpty(tMisMonitorTask.CONTRACT_CODE))
{
strTaskWhere += string.Format(" and CONTRACT_CODE='{0}'", tMisMonitorTask.CONTRACT_CODE);
}
//委托类型
if (!string.IsNullOrEmpty(tMisMonitorTask.CONTRACT_TYPE))
{
strTaskWhere += string.Format(" and CONTRACT_TYPE='{0}'", tMisMonitorTask.CONTRACT_TYPE);
}
//项目名称
if (!string.IsNullOrEmpty(tMisMonitorTask.PROJECT_NAME))
{
strTaskWhere += string.Format(" and PROJECT_NAME like '%{0}%'", tMisMonitorTask.PROJECT_NAME);
}
//委托单位
if (!string.IsNullOrEmpty(tMisMonitorTask.CLIENT_COMPANY_ID))
{
strTaskWhere += string.Format(" and CLIENT_COMPANY_ID='{0}'", tMisMonitorTask.CLIENT_COMPANY_ID);
}
//签订日期
if (!string.IsNullOrEmpty(tMisMonitorTask.CONSIGN_DATE))
{
if (tMisMonitorTask.CONSIGN_DATE.Contains("|"))
{
string[] arrDate = tMisMonitorTask.CONSIGN_DATE.Split('|');
if (!string.IsNullOrEmpty(arrDate[0].ToString()))
{
strTaskWhere += string.Format(" and CONSIGN_DATE>='{0}'", arrDate[0].ToString());
}
if (!string.IsNullOrEmpty(arrDate[1].ToString()))
{
strTaskWhere += string.Format(" and CONSIGN_DATE<='{0}'", arrDate[1].ToString());
}
}
}
#endregion
strSQL = string.Format(strSQL, BuildWhereStatement(tMisMonitorReport), strTaskWhere);
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, pageIndex, pageSize)));
}
/// <summary>
/// 报告编制人选择
/// </summary>
protected void changeReporter()
{
string strReportId = Request.QueryString["report_id"]; //报告ID
string strReporter = Request.QueryString["reporter"]; //报告编制人ID
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
objReport.ID = strReportId;
objReport.REPORT_SCHEDULER = strReporter;
objReport.IF_SEND = "0";
if (new TMisMonitorReportLogic().Edit(objReport))
{
WriteLog("分配报告编制人", "", LogInfo.UserInfo.USER_NAME + "分配报告" + strReportId + "给用户" + strReporter);
}
}
/// <summary>
/// 产生和注册业务数据
/// </summary>
void IWFStepRules.CreatAndRegisterBusinessData()
{
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(this.ID.Value);
wfControl.ServiceCode = objTask.CONTRACT_CODE;
wfControl.ServiceName = objTask.PROJECT_NAME;
//保存报告签发人信息
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
objReport.ID = this.ID.Value;
objReport.REPORT_APPROVER = LogInfo.UserInfo.ID;
new TMisMonitorReportLogic().Edit(objReport);
//这里是产生和注册业务数据的地方
wfControl.SaveInstStepServiceData("报告流程", "task_id", this.ID.Value);
}
/// <summary>
/// 报告领取信息 行数
/// </summary>
/// <param name="tMisMonitorReport">报告对象</param>
/// <param name="tMisMonitorTask">监测任务对象</param>
/// <returns>返回影响行数</returns>
public int GetSelectResultCount(TMisMonitorReportVo tMisMonitorReport, TMisMonitorTaskVo tMisMonitorTask)
{
string strSQL = "select count(*)" +
" from (select * from T_MIS_MONITOR_REPORT {0}) report " +
" join (select * from T_MIS_MONITOR_TASK {1}) task on report.TASK_ID=task.ID";
#region 监测任务查询条件构造 strTaskWhere
string strTaskWhere = " where 1=1";
//委托书编号
if (!string.IsNullOrEmpty(tMisMonitorTask.CONTRACT_CODE))
{
strTaskWhere += string.Format(" and CONTRACT_CODE='{0}'", tMisMonitorTask.CONTRACT_CODE);
}
//委托类型
if (!string.IsNullOrEmpty(tMisMonitorTask.CONTRACT_TYPE))
{
strTaskWhere += string.Format(" and CONTRACT_TYPE='{0}'", tMisMonitorTask.CONTRACT_TYPE);
}
//项目名称
if (!string.IsNullOrEmpty(tMisMonitorTask.PROJECT_NAME))
{
strTaskWhere += string.Format(" and PROJECT_NAME like '%{0}%'", tMisMonitorTask.PROJECT_NAME);
}
//委托单位
if (!string.IsNullOrEmpty(tMisMonitorTask.CLIENT_COMPANY_ID))
{
strTaskWhere += string.Format(" and CLIENT_COMPANY_ID='{0}'", tMisMonitorTask.CLIENT_COMPANY_ID);
}
//签订日期
if (!string.IsNullOrEmpty(tMisMonitorTask.CONSIGN_DATE))
{
if (tMisMonitorTask.CONSIGN_DATE.Contains("|"))
{
string[] arrDate = tMisMonitorTask.CONSIGN_DATE.Split('|');
if (!string.IsNullOrEmpty(arrDate[0].ToString()))
{
strTaskWhere += string.Format(" and CONSIGN_DATE>='{0}'", arrDate[0].ToString());
}
if (!string.IsNullOrEmpty(arrDate[1].ToString()))
{
strTaskWhere += string.Format(" and CONSIGN_DATE<='{0}'", arrDate[1].ToString());
}
}
}
#endregion
strSQL = string.Format(strSQL, BuildWhereStatement(tMisMonitorReport), strTaskWhere);
return(Int32.Parse(SqlHelper.ExecuteScalar(strSQL).ToString()));
}
/// <summary>
/// 报告领取状态更新
/// </summary>
protected void EditReportStatus()
{
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
objReport.IF_GET = !string.IsNullOrEmpty(Request.QueryString["status"]) ? Request.QueryString["status"].ToString() : "";
objReport.ID = !string.IsNullOrEmpty(Request.QueryString["id"]) ? Request.QueryString["id"].ToString() : "";
//管理员特殊权限，可以对已领取的报告 取回到未收卷状态
if (objReport.IF_GET == "0")
{
if (LogInfo.UserInfo.REAL_NAME != "超级管理员")
{
objReport.IF_GET = "";
}
}
new TMisMonitorReportLogic().Edit(objReport);
}
public static string AcceptReport(string strValue, string strLocalUserId)
{
TMisMonitorReportVo objvo = new TMisMonitorReportVo();
objvo.ID = strValue;
objvo.IF_SEND = "1";
objvo.IF_ACCEPT = "1";
objvo.REPORT_SCHEDULER = strLocalUserId;
if (new TMisMonitorReportLogic().Edit(objvo))
{
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获取监测报告
/// </summary>
/// <returns></returns>
protected string GetReportInfo()
{
string result = "";
int intTotalCount = 0;
//页数
int pageIndex = Int32.Parse(Request.Params["page"].ToString());
//分页数
int pageSize = Int32.Parse(Request.Params["pagesize"].ToString());
DataTable dtEval = new DataTable();
//监测报告对象
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
//监测任务对象
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
//创建标准JSON数据
objReport.SORT_FIELD = Request.Params["sortname"];
objReport.SORT_TYPE = Request.Params["sortorder"];
//过滤条件
//委托类型
objTask.CONTRACT_TYPE = !String.IsNullOrEmpty(Request.Params["srhContractType"]) ? Request.Params["srhContractType"].ToString() : "";
//委托书编号
objTask.CONTRACT_CODE = !String.IsNullOrEmpty(Request.Params["srhContractCode"]) ? Request.Params["srhContractCode"].ToString() : "";
//项目名称
objTask.PROJECT_NAME = !String.IsNullOrEmpty(Request.Params["srhProjectName"]) ? Request.Params["srhProjectName"].ToString() : "";
//委托单位
objTask.CLIENT_COMPANY_ID = !String.IsNullOrEmpty(Request.Params["srhClientName"]) ? Request.Params["srhClientName"].ToString() : "";
//监测任务状态
objTask.TASK_STATUS = "11";
//签订日期
if (!string.IsNullOrEmpty(Request.QueryString["srhBeginDate"]) || !string.IsNullOrEmpty(Request.QueryString["srhEndDate"]))
{
objTask.CONSIGN_DATE = Request.QueryString["srhBeginDate"].ToString() + "|" + Request.QueryString["srhEndDate"].ToString();
}
//报告单号
objReport.REPORT_CODE = !String.IsNullOrEmpty(Request.Params["srhReportCode"]) ? Request.Params["srhReportCode"].ToString() : "";
intTotalCount = new TMisMonitorReportLogic().GetSelectResultCount(objReport, objTask);
dtEval = new TMisMonitorReportLogic().SelectByTableForManager(objReport, objTask, pageIndex, pageSize);
result = LigerGridDataToJson(dtEval, intTotalCount);
return(result);
}
public static int saveRptAskDate(string strReportId, string strRPT_ASK_DATE)
{
if (strRPT_ASK_DATE.Length == 0)
{
return(1);
}
TMisMonitorReportVo objReport = new TMisMonitorReportVo();
objReport.ID = strReportId;
objReport.RPT_ASK_DATE = DateTime.Parse(strRPT_ASK_DATE).ToShortDateString();
if (new TMisMonitorReportLogic().Edit(objReport))
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisMonitorReport"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisMonitorReportVo tMisMonitorReport)
{
string strSQL = "select * from T_MIS_MONITOR_REPORT " + this.BuildWhereStatement(tMisMonitorReport);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tMisMonitorReport">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisMonitorReportVo tMisMonitorReport)
{
string strSQL = SqlHelper.BuildInsertExpress(tMisMonitorReport, TMisMonitorReportVo.T_MIS_MONITOR_REPORT_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisMonitorReport">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisMonitorReportVo tMisMonitorReport, int iIndex, int iCount)
{
return(access.SelectByTable(tMisMonitorReport, iIndex, iCount));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tMisMonitorReport"></param>
/// <returns></returns>
public string BuildWhereStatement(TMisMonitorReportVo tMisMonitorReport)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tMisMonitorReport)
{
//ID
if (!String.IsNullOrEmpty(tMisMonitorReport.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisMonitorReport.ID.ToString()));
}
//监测计划ID
if (!String.IsNullOrEmpty(tMisMonitorReport.TASK_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND TASK_ID = '{0}'", tMisMonitorReport.TASK_ID.ToString()));
}
//报告单号
if (!String.IsNullOrEmpty(tMisMonitorReport.REPORT_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REPORT_CODE = '{0}'", tMisMonitorReport.REPORT_CODE.ToString()));
}
//报告完成日期
if (!String.IsNullOrEmpty(tMisMonitorReport.REPORT_DATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REPORT_DATE = '{0}'", tMisMonitorReport.REPORT_DATE.ToString()));
}
//报告要求完成时间
if (!String.IsNullOrEmpty(tMisMonitorReport.RPT_ASK_DATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND RPT_ASK_DATE = '{0}'", tMisMonitorReport.RPT_ASK_DATE.ToString()));
}
//验收报告附件ID
if (!String.IsNullOrEmpty(tMisMonitorReport.REPORT_EX_ATTACHE_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REPORT_EX_ATTACHE_ID = '{0}'", tMisMonitorReport.REPORT_EX_ATTACHE_ID.ToString()));
}
//是否领取
if (!String.IsNullOrEmpty(tMisMonitorReport.IF_GET.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IF_GET = '{0}'", tMisMonitorReport.IF_GET.ToString()));
}
//是否发送分配
if (!String.IsNullOrEmpty(tMisMonitorReport.IF_SEND.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IF_SEND = '{0}'", tMisMonitorReport.IF_SEND.ToString()));
}
//是否确认
if (!String.IsNullOrEmpty(tMisMonitorReport.IF_ACCEPT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IF_ACCEPT = '{0}'", tMisMonitorReport.IF_ACCEPT.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tMisMonitorReport.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisMonitorReport.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tMisMonitorReport.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisMonitorReport.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tMisMonitorReport.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisMonitorReport.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tMisMonitorReport.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tMisMonitorReport.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tMisMonitorReport.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tMisMonitorReport.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 功能描述：临时性委托 保存监测任务、样品所有信息（预约）
/// 创建时间：2013-06-06
/// 创建人：胡方扬
/// </summary>
/// <param name="tMisMonitorTask">监测任务</param>
/// <param name="arrTaskPoint">监测任务点位集合</param>
/// <param name="arrSubtask">监测子任务集合</param>
/// <param name="arrPointItem">监测任务点位明细集合</param>
/// <param name="arrSample">样品集合</param>
/// <param name="arrSampleResult">样品结果集合</param>
/// <param name="arrSampleResultApp">分析任务执行集合</param>
/// <returns>布尔值</returns>
public bool SaveTrans(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorReportVo objReportVo, ArrayList arrTaskPoint, ArrayList arrSubtask, ArrayList arrPointItem, ArrayList arrSample, ArrayList arrSampleResult, ArrayList arrSampleResultApp)
{
return(access.SaveTrans(tMisMonitorTask, objReportVo, arrTaskPoint, arrSubtask, arrPointItem, arrSample, arrSampleResult, arrSampleResultApp));
}
/// <summary>
/// 功能描述：保存监测任务、监测报告（验收委托）
/// 创建时间：2012-12-29
/// 创建人：邵世卓
/// </summary>
/// <param name="tMisMonitorTask">监测任务</param>
/// <param name="tMisMonitorTaskCompanyA">监测任务委托单位</param>
/// <param name="tMisMonitorTaskCompanyB">监测任务受检单位</param>
/// <param name="objReportVo">监测报告</param>
/// <returns></returns>
public bool SaveTrans(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyA, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyB, TMisMonitorReportVo objReportVo)
{
return(access.SaveTrans(tMisMonitorTask, tMisMonitorTaskCompanyA, tMisMonitorTaskCompanyB, objReportVo));
}
/// <summary>
/// 功能描述：保存监测任务、样品所有信息（自送样预约）
/// 创建时间：2012-12-20
/// 创建人：胡方扬
/// </summary>
/// <param name="tMisMonitorTask">监测任务</param>
/// <param name="tMisMonitorTaskCompanyA">监测任务委托单位</param>
/// <param name="tMisMonitorTaskCompanyB">监测任务受检单位</param>
/// <param name="arrSubtask">监测子任务集合</param>
/// <param name="arrSample">样品集合</param>
/// <param name="arrSampleResult">样品结果集合</param>
/// <param name="arrSampleResultApp">分析任务执行集合</param>
/// <returns>布尔值</returns>
public bool SaveSampleTrans(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyA, TMisMonitorTaskCompanyVo tMisMonitorTaskCompanyB, TMisMonitorReportVo objReportVo, ArrayList arrSubtask, ArrayList arrSample, ArrayList arrSampleResult, ArrayList arrSampleResultApp)
{
return(access.SaveSampleTrans(tMisMonitorTask, tMisMonitorTaskCompanyA, tMisMonitorTaskCompanyB, objReportVo, arrSubtask, arrSample, arrSampleResult, arrSampleResultApp));
}
private string SendToNext(string strTaskId)
{
//记录当前分析环节的发送人
DataTable objTable = new TMisMonitorResultLogic().geResultChecktItemTypeInfo_QHD(LogInfo.UserInfo.ID, "qc_manager_audit", strTaskId, "03", "0", "60");
foreach (DataRow row in objTable.Rows)
{
string strId = row["ID"].ToString();
//根据子任务ＩＤ获取监测子任务审核表ID
i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo TMisMonitorSubtaskAppVoTemp = new i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo();
TMisMonitorSubtaskAppVoTemp.SUBTASK_ID = strId;
string strSubTaskAppId = new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppLogic().Details(TMisMonitorSubtaskAppVoTemp).ID;
i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo TMisMonitorSubtaskAppVo = new i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo();
TMisMonitorSubtaskAppVo.ID = strSubTaskAppId;
TMisMonitorSubtaskAppVo.RESULT_QC_CHECK = LogInfo.UserInfo.ID;
new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppLogic().Edit(TMisMonitorSubtaskAppVo);
}
//分析环节任务完结状态改变
bool IsSuccess = new TMisMonitorResultLogic().SendQcTaskToNextFlow(strTaskId, LogInfo.UserInfo.ID, "09", "qc_manager_audit");
if (IsSuccess == true)
{
//如果是环境质量将自动对数据进行填报
foreach (DataRow row in objTable.Rows)
{
string strSubTaskId = row["ID"].ToString();
string strMonitorId = row["MONITOR_ID"].ToString();
string strSampleDate = row["SAMPLE_FINISH_DATE"].ToString();
i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskVo();
TMisMonitorSubtaskVo.ID = strSubTaskId;
TMisMonitorSubtaskVo.MONITOR_ID = strMonitorId;
TMisMonitorSubtaskVo.SAMPLE_FINISH_DATE = strSampleDate;
if (strMonitorId == "EnvRiver" || strMonitorId == "EnvReservoir" || strMonitorId == "EnvDrinking" || strMonitorId == "EnvDrinkingSource" || strMonitorId == "EnvStbc" || strMonitorId == "EnvMudRiver" || strMonitorId == "EnvPSoild" || strMonitorId == "EnvSoil" || strMonitorId == "EnvAir" || strMonitorId == "EnvSpeed" || strMonitorId == "EnvDust" || strMonitorId == "EnvRain")
{
new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskLogic().SetEnvFillData(TMisMonitorSubtaskVo, false, "");
}
if (strMonitorId == "AreaNoise" || strMonitorId == "EnvRoadNoise" || strMonitorId == "FunctionNoise")
{
new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskLogic().SetEnvFillData(TMisMonitorSubtaskVo, true, "");
}
}
if (new TMisMonitorResultLogic().allTaskIsFinish_ZZ(strTaskId, "24", "60"))
{
i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo TMisMonitorTaskVo = new i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo();
TMisMonitorTaskVo.ID = strTaskId;
TMisMonitorTaskVo.TASK_STATUS = "09";
new i3.BusinessLogic.Channels.Mis.Monitor.Task.TMisMonitorTaskLogic().Edit(TMisMonitorTaskVo);
i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo TMisMonitorTaskVoTemp = new i3.BusinessLogic.Channels.Mis.Monitor.Task.TMisMonitorTaskLogic().Details(strTaskId);
if (TMisMonitorTaskVoTemp.CONTRACT_TYPE == "05")
{
//根据任务ID获取项目负责人
string strProjectId = TMisMonitorTaskVoTemp.PROJECT_ID;
TMisMonitorReportVo objMrUpdate = new TMisMonitorReportVo();
objMrUpdate.IF_SEND = "1";
objMrUpdate.REPORT_SCHEDULER = strProjectId;
TMisMonitorReportVo objMrWhere = new TMisMonitorReportVo();
objMrWhere.TASK_ID = strTaskId;
new TMisMonitorReportLogic().Edit(objMrUpdate, objMrWhere);
}
}
}
return(IsSuccess == true ? "1" : "0");
}
/// <summary>
/// 根据监测天数拆分任务（验收监测） Create By:weilin 2014-12-04
/// </summary>
/// <param name="strTaskID"></param>
/// <returns></returns>
private static bool SplitAcceptTask(string strTaskID, TBaseSerialruleVo objSerial)
{
bool bResult = true;
TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskLogic().Details(strTaskID);
TMisMonitorReportVo objReportVo = new TMisMonitorReportVo();
if (objTaskVo.CONTRACT_TYPE == "05") //验收监测
{
TMisContractVo objContractVo = new TMisContractLogic().Details(objTaskVo.CONTRACT_ID);
TMisContractPointVo objContractPointVo = new TMisContractPointVo();
objContractPointVo.CONTRACT_ID = objTaskVo.CONTRACT_ID;
objContractPointVo.IS_DEL = "0";
objContractPointVo = new TMisContractPointLogic().Details(objContractPointVo);
if (objContractPointVo.SAMPLE_DAY != "" && IsNumeric(objContractPointVo.SAMPLE_DAY) && objContractVo.REMARK5 == "")
{
int iSampleDay = int.Parse(objContractPointVo.SAMPLE_DAY);
TMisMonitorTaskCompanyVo objClient = new TMisMonitorTaskCompanyLogic().Details(objTaskVo.CLIENT_COMPANY_ID);
TMisMonitorTaskCompanyVo objTested = new TMisMonitorTaskCompanyLogic().Details(objTaskVo.TESTED_COMPANY_ID);
for (int i = 1; i < iSampleDay; i++)
{
TMisMonitorTaskVo objTaskAddVo = new TMisMonitorTaskVo();
objTaskAddVo.ID = GetSerialNumber("t_mis_monitor_taskId");
objTaskAddVo.CONTRACT_ID = objTaskVo.CONTRACT_ID;
objTaskAddVo.PLAN_ID = objTaskVo.PLAN_ID;
objTaskAddVo.CONTRACT_CODE = objTaskVo.CONTRACT_CODE;
objTaskAddVo.TICKET_NUM = objTaskVo.TICKET_NUM + "-" + (i + 1).ToString();
objTaskAddVo.PROJECT_NAME = objTaskVo.PROJECT_NAME;
objTaskAddVo.CONTRACT_YEAR = objTaskVo.CONTRACT_YEAR;
objTaskAddVo.CONTRACT_TYPE = objTaskVo.CONTRACT_TYPE;
objTaskAddVo.TEST_TYPE = objTaskVo.TEST_TYPE;
objTaskAddVo.TEST_PURPOSE = objTaskVo.TEST_PURPOSE;
objTaskAddVo.ASKING_DATE = objTaskVo.ASKING_DATE;
objTaskAddVo.SAMPLE_SOURCE = objTaskVo.SAMPLE_SOURCE;
objTaskAddVo.CREATOR_ID = objTaskVo.CREATOR_ID;
objTaskAddVo.CREATE_DATE = objTaskVo.CREATE_DATE;
objTaskAddVo.TASK_STATUS = objTaskVo.TASK_STATUS;
objTaskAddVo.REMARK1 = objTaskVo.REMARK1;
objTaskAddVo.REMARK2 = objTaskVo.REMARK2;
objTaskAddVo.REMARK3 = objTaskVo.REMARK3;
objTaskAddVo.QC_STATUS = objTaskVo.QC_STATUS;
objTaskAddVo.COMFIRM_STATUS = objTaskVo.COMFIRM_STATUS;
objTaskAddVo.ALLQC_STATUS = objTaskVo.ALLQC_STATUS;
objTaskAddVo.REPORT_HANDLE = objTaskVo.REPORT_HANDLE;
//构造监测任务委托企业信息
TMisMonitorTaskCompanyVo objClientAdd = new TMisMonitorTaskCompanyVo();
PageBase.CopyObject(objClient, objClientAdd);//复制对象
objClientAdd.ID = PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId");
objClientAdd.TASK_ID = objTaskAddVo.ID;
//构造监测任务受检企业信息
TMisMonitorTaskCompanyVo objTestedAdd = new TMisMonitorTaskCompanyVo();
PageBase.CopyObject(objTested, objTestedAdd);//复制对象
objTestedAdd.ID = PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId");
objTestedAdd.TASK_ID = objTaskAddVo.ID;
objTaskAddVo.CLIENT_COMPANY_ID = objClientAdd.ID;
objTaskAddVo.TESTED_COMPANY_ID = objTestedAdd.ID;
TMisMonitorReportVo objReportAdd = new TMisMonitorReportVo();
objReportVo.ID = GetSerialNumber("t_mis_monitor_report_id");
objReportVo.REPORT_CODE = objReportVo.REPORT_CODE + "-" + (i + 1).ToString();
objReportVo.TASK_ID = objTaskAddVo.ID;
objReportVo.IF_GET = "0";
//监测子任务信息 根据委托书监测类别进行构造
ArrayList arrSubTask = new ArrayList(); //监测子任务集合
ArrayList arrSubTaskApp = new ArrayList();
ArrayList arrTaskPoint = new ArrayList(); //监测点位集合
ArrayList arrPointItem = new ArrayList(); //监测点位明细集合
ArrayList arrSample = new ArrayList(); //样品集合
ArrayList arrSampleResult = new ArrayList(); //样品结果集合
ArrayList arrSampleResultApp = new ArrayList(); //样品分析执行表
List <TMisMonitorSubtaskVo> listSubTask = new TMisMonitorSubtaskLogic().SelectByObject(new TMisMonitorSubtaskVo()
{
TASK_ID = objTaskVo.ID
}, 0, 0);
for (int j = 0; j < listSubTask.Count; j++)
{
TMisMonitorSubtaskVo objSubTaskAdd = new TMisMonitorSubtaskVo();
CopyObject(listSubTask[j], objSubTaskAdd);
objSubTaskAdd.ID = GetSerialNumber("t_mis_monitor_subtaskId");
objSubTaskAdd.TASK_ID = objTaskAddVo.ID;
arrSubTask.Add(objSubTaskAdd);
TMisMonitorSubtaskAppVo objSubTaskApp = new TMisMonitorSubtaskAppVo();
objSubTaskApp.SUBTASK_ID = listSubTask[j].ID;
objSubTaskApp = new TMisMonitorSubtaskAppLogic().Details(objSubTaskApp);
TMisMonitorSubtaskAppVo objSubTaskAppAdd = new TMisMonitorSubtaskAppVo();
CopyObject(objSubTaskApp, objSubTaskAppAdd);
objSubTaskAppAdd.ID = GetSerialNumber("TMisMonitorSubtaskAppID");
objSubTaskAppAdd.SUBTASK_ID = objSubTaskAdd.ID;
arrSubTaskApp.Add(objSubTaskAppAdd);
List <TMisMonitorTaskPointVo> listTaskPoint = new TMisMonitorTaskPointLogic().SelectByObject(new TMisMonitorTaskPointVo()
{
TASK_ID = objTaskVo.ID, SUBTASK_ID = listSubTask[j].ID, IS_DEL = "0"
}, 0, 0);
for (int k = 0; k < listTaskPoint.Count; k++)
{
TMisMonitorTaskPointVo objTaskPointAdd = new TMisMonitorTaskPointVo();
CopyObject(listTaskPoint[k], objTaskPointAdd);
objTaskPointAdd.ID = GetSerialNumber("t_mis_monitor_taskpointId");
objTaskPointAdd.TASK_ID = objTaskAddVo.ID;
arrTaskPoint.Add(objTaskPointAdd);
TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoVo();
objSampleInfoVo.SUBTASK_ID = listSubTask[j].ID;
objSampleInfoVo.POINT_ID = listTaskPoint[k].ID;
objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objSampleInfoVo);
TMisMonitorSampleInfoVo objSampleInfoAdd = new TMisMonitorSampleInfoVo();
CopyObject(objSampleInfoVo, objSampleInfoAdd);
objSampleInfoAdd.ID = GetSerialNumber("MonitorSampleId");
objSampleInfoAdd.SUBTASK_ID = objSubTaskAdd.ID;
objSampleInfoAdd.POINT_ID = objTaskPointAdd.ID;
objSampleInfoAdd.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTaskAddVo, objSubTaskAdd);
arrSample.Add(objSampleInfoAdd);
List <TMisMonitorTaskItemVo> listTaskItem = new TMisMonitorTaskItemLogic().SelectByObject(new TMisMonitorTaskItemVo()
{
TASK_POINT_ID = listTaskPoint[k].ID, IS_DEL = "0"
}, 0, 0);
for (int l = 0; l < listTaskItem.Count; l++)
{
TMisMonitorTaskItemVo objTaskItemAdd = new TMisMonitorTaskItemVo();
CopyObject(listTaskItem[l], objTaskItemAdd);
objTaskItemAdd.ID = GetSerialNumber("t_mis_monitor_task_item_id");
objTaskItemAdd.TASK_POINT_ID = objTaskPointAdd.ID;
arrPointItem.Add(objTaskItemAdd);
}
List <TMisMonitorResultVo> listResult = new TMisMonitorResultLogic().SelectByObject(new TMisMonitorResultVo()
{
SAMPLE_ID = objSampleInfoVo.ID
}, 0, 0);
for (int l = 0; l < listResult.Count; l++)
{
TMisMonitorResultVo objResultAdd = new TMisMonitorResultVo();
CopyObject(listResult[l], objResultAdd);
objResultAdd.ID = GetSerialNumber("MonitorResultId");
objResultAdd.SAMPLE_ID = objSampleInfoAdd.ID;
arrSampleResult.Add(objResultAdd);
TMisMonitorResultAppVo objResultAppVo = new TMisMonitorResultAppVo();
objResultAppVo.RESULT_ID = listResult[l].ID;
objResultAppVo = new TMisMonitorResultAppLogic().Details(objResultAppVo);
TMisMonitorResultAppVo objResultAppAdd = new TMisMonitorResultAppVo();
CopyObject(objResultAppVo, objResultAppAdd);
objResultAppAdd.ID = GetSerialNumber("MonitorResultAppId");
objResultAppAdd.RESULT_ID = objResultAdd.ID;
arrSampleResultApp.Add(objResultAppAdd);
}
}
}
if (new TMisMonitorTaskLogic().SaveTrans(objTaskAddVo, objClientAdd, objTestedAdd, objReportVo, arrTaskPoint, arrSubTask, arrSubTaskApp, arrPointItem, arrSample, arrSampleResult, arrSampleResultApp))
{
bResult = true;
}
}
//更新任务单号
objTaskVo.TICKET_NUM = objTaskVo.TICKET_NUM + "-1";
new TMisMonitorTaskLogic().Edit(objTaskVo);
//更新报告单号
objReportVo.REPORT_CODE = objReportVo.REPORT_CODE + "-1";
new TMisMonitorReportLogic().Edit(objReportVo);
//更新验收委托书任务已经拆分任务的标志
objContractVo.REMARK5 = "1";
new TMisContractLogic().Edit(objContractVo);
}
}
return(bResult);
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisMonitorReport">对象条件</param>
/// <returns>对象</returns>
public TMisMonitorReportVo Details(TMisMonitorReportVo tMisMonitorReport)
{
string strSQL = String.Format("select * from T_MIS_MONITOR_REPORT " + this.BuildWhereStatement(tMisMonitorReport));
return(SqlHelper.ExecuteObject(new TMisMonitorReportVo(), strSQL));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisMonitorReport">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisMonitorReportVo> SelectByObject(TMisMonitorReportVo tMisMonitorReport, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_MIS_MONITOR_REPORT " + this.BuildWhereStatement(tMisMonitorReport));
return(SqlHelper.ExecuteObjectList(tMisMonitorReport, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisMonitorReport"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisMonitorReportVo tMisMonitorReport)
{
return(access.SelectByTable(tMisMonitorReport));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisMonitorReport">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisMonitorReportVo tMisMonitorReport)
{
string strSQL = "select Count(*) from T_MIS_MONITOR_REPORT " + this.BuildWhereStatement(tMisMonitorReport);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 预约办理
/// </summary>
/// <param name="strPlanID">预约表ID</param>
protected string doPlanTask()
{
string strReturn = "";
string strTaskFreqType = "0";
string strCodeRule = "";
strTaskFreqType = System.Configuration.ConfigurationManager.AppSettings["TaskFreqType"].ToString();
//预约表对象
TMisContractPlanVo objContractPlan = new TMisContractPlanLogic().Details(strPlanID);
TMisContractVo objContract = new TMisContractVo();
objContract.CONTRACT_TYPE = strContractTypeId;
if (objContractPlan != null)
{
//获取委托书信息
#region 构造监测任务对象
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.ID = GetSerialNumber("t_mis_monitor_taskId");
objTask.PLAN_ID = strPlanID;
objTask.PROJECT_NAME = strProjectName;
objTask.CONTRACT_TYPE = strContractTypeId;
objTask.TEST_TYPE = strTest_Type;
objTask.CREATOR_ID = LogInfo.UserInfo.ID;
objTask.CREATE_DATE = DateTime.Now.ToString();
objTask.TASK_STATUS = "01";
objTask.COMFIRM_STATUS = "0";
objTask.SAMPLE_SOURCE = "抽样";
objTask.TASK_TYPE = strTaskType;
objTask.CONTRACT_YEAR = strContractYear;
objTask.ASKING_DATE = strAskingDate;
//string strQcSetting = ConfigurationManager.AppSettings["QCsetting"].ToString();
//if (!String.IsNullOrEmpty(strQcSetting))
//{
// if (strQcSetting == "1")
// {
// objTask.QC_STATUS = "1";
// }
// else
// {
// objTask.QC_STATUS = "2";
// }
//}
//生成任务编号
TBaseSerialruleVo objSerialTask = new TBaseSerialruleVo();
objSerialTask.SERIAL_TYPE = "4";
//潘德军 2013-12-23 任务单号可改，且初始不生成
objTask.TICKET_NUM = PageBase.CreateBaseDefineCode(objSerialTask, objContract);
//objTask.TICKET_NUM = "未编号";
//生成委托书单号
objSerialTask.SERIAL_TYPE = "1";
strCodeRule = CreateBaseDefineCode(objSerialTask, objContract);
objTask.CONTRACT_CODE = strCodeRule;
#region 构造监测任务委托企业信息
//插入委托企业信息
if (!String.IsNullOrEmpty(strCompanyId))
{
strClientCompanyId = InsertContractCompanyInfo(objTask.ID, strCompanyId);
objTask.CLIENT_COMPANY_ID = strClientCompanyId;
}
//插入受检企业信息
if (!String.IsNullOrEmpty(strCompanyFrimId))
{
strTestCompanyId = InsertContractCompanyInfo(objTask.ID, strCompanyFrimId);
objTask.TESTED_COMPANY_ID = strTestCompanyId;
}
#endregion
#endregion
#region 监测报告 胡方扬 2013-04-23 Modify 将报告记录初始化生成数据移到委托书办理完毕后就生成
TMisMonitorReportVo objReportVo = new TMisMonitorReportVo();
objReportVo.ID = GetSerialNumber("t_mis_monitor_report_id");
//生成报告编号 胡方扬 2013-04-24
//TBaseSerialruleVo objSerial = new TBaseSerialruleVo();
//objSerial.SERIAL_TYPE = "3";
//objReportVo.REPORT_CODE = PageBase.CreateBaseDefineCode(objSerial,objContract);
DataTable objDt = PageBase.getDictList("RptISWT_Code");
if (objDt.Rows.Count > 0)
{
if (objDt.Rows[0]["DICT_CODE"].ToString() == "1")
{
objReportVo.REPORT_CODE = objTask.TICKET_NUM;
}
}
objReportVo.TASK_ID = objTask.ID;
objReportVo.IF_GET = "0";
#endregion
#region 监测子任务信息 根据委托书监测类别进行构造
//监测子任务信息 根据委托书监测类别进行构造
ArrayList arrSubTask = new ArrayList(); //监测子任务集合
ArrayList arrTaskPoint = new ArrayList(); //监测点位集合
ArrayList arrPointItem = new ArrayList(); //监测点位明细集合
ArrayList arrSample = new ArrayList(); //样品集合
ArrayList arrSampleResult = new ArrayList(); //样品结果集合
ArrayList arrSampleResultApp = new ArrayList(); //样品分析执行表
#endregion
//监测类别集合
DataTable dtTestType = new TMisContractPointLogic().GetTestType(strPlanID);
//预约点位
DataTable dtPoint = new TMisContractPointLogic().SelectPointTable(strPlanID);
//获取预约点位明细信息
DataTable dtContractPoint = new TMisContractPointLogic().SelectByTableForPlan(strPlanID);
//监测子任务
#region 注释
//#region 监测子任务
//if (dtTestType.Rows.Count > 0)
//{
// string strSubTaskIDs = GetSerialNumberList("t_mis_monitor_subtaskId", dtTestType.Rows.Count);
// string[] arrSubTaskIDs = strSubTaskIDs.Split(',');
// for (int i = 0; i < dtTestType.Rows.Count; i++)
// {
// string str = dtTestType.Rows[i]["MONITOR_ID"].ToString();//监测类别
// if (str.Length > 0)
// {
// #region 监测子任务
// //监测子任务
// TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
// string strSampleManagerID = "";//采样负责人ID
// string strSampleID = "";//采样协同人ID串
// //GetSamplingMan(str, objContract.ID, ref strSampleManagerID, ref strSampleID);
// objSubtask.ID = arrSubTaskIDs[i];
// objSubtask.TASK_ID = objTask.ID;
// objSubtask.MONITOR_ID = str;
// if (objContract.PROJECT_ID != "")
// {
// objSubtask.SAMPLING_MANAGER_ID = objContract.PROJECT_ID;
// }
// else
// {
// objSubtask.SAMPLING_MANAGER_ID = strSampleManagerID;
// }
// objSubtask.SAMPLING_ID = strSampleID;
// objSubtask.TASK_TYPE = "发送";
// objSubtask.TASK_STATUS = "01";
// arrSubTask.Add(objSubtask);
// #endregion
// #region 按类别分点位
// //按类别分点位
// DataRow[] dtTypePoint = dtPoint.Select("MONITOR_ID=" + str);
// if (dtTypePoint.Length > 0)
// {
// string strTaskPointIDs = GetSerialNumberList("t_mis_monitor_taskpointId", dtTypePoint.Length);
// string[] arrTaskPointIDs = strTaskPointIDs.Split(',');
// string strSampleIDs = GetSerialNumberList("MonitorSampleId", dtTypePoint.Length);
// string[] arrSampleIDs = strSampleIDs.Split(',');
// for (int j = 0; j < dtTypePoint.Length; j++)
// {
// DataRow drPoint = dtTypePoint[j];
// #region 监测点位
// // 监测点位
// TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointVo();
// objTaskPoint.ID = arrTaskPointIDs[j];
// objTaskPoint.TASK_ID = objTask.ID;
// objTaskPoint.SUBTASK_ID = objSubtask.ID;
// objTaskPoint.POINT_ID = drPoint["POINT_ID"].ToString();
// objTaskPoint.MONITOR_ID = str;
// //objTaskPoint.COMPANY_ID = objTaskTested.ID;
// objTaskPoint.CONTRACT_POINT_ID = drPoint["ID"].ToString();
// objTaskPoint.POINT_NAME = drPoint["POINT_NAME"].ToString();
// objTaskPoint.DYNAMIC_ATTRIBUTE_ID = drPoint["DYNAMIC_ATTRIBUTE_ID"].ToString();
// objTaskPoint.ADDRESS = drPoint["ADDRESS"].ToString();
// objTaskPoint.LONGITUDE = drPoint["LONGITUDE"].ToString();
// objTaskPoint.LATITUDE = drPoint["LATITUDE"].ToString();
// objTaskPoint.FREQ = drPoint["FREQ"].ToString();
// objTaskPoint.DESCRIPTION = drPoint["DESCRIPTION"].ToString();
// objTaskPoint.NATIONAL_ST_CONDITION_ID = drPoint["NATIONAL_ST_CONDITION_ID"].ToString();
// objTaskPoint.INDUSTRY_ST_CONDITION_ID = drPoint["INDUSTRY_ST_CONDITION_ID"].ToString();
// objTaskPoint.LOCAL_ST_CONDITION_ID = drPoint["LOCAL_ST_CONDITION_ID"].ToString();
// objTaskPoint.IS_DEL = "0";
// objTaskPoint.NUM = drPoint["NUM"].ToString();
// objTaskPoint.CREATE_DATE = DateTime.Now.ToString();
// arrTaskPoint.Add(objTaskPoint);
// #endregion
// #region 样品
// //样品 与点位对应
// TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo();
// objSampleInfo.ID = arrSampleIDs[j];
// objSampleInfo.SUBTASK_ID = objSubtask.ID;
// objSampleInfo.POINT_ID = objTaskPoint.ID;
// objSampleInfo.SAMPLE_NAME = objTaskPoint.POINT_NAME;
// objSampleInfo.QC_TYPE = "0";//默认原始样
// objSampleInfo.NOSAMPLE = "0";//默认未采样
// arrSample.Add(objSampleInfo);
// #endregion
// //点位采用的标准条件项ID
// string strConditionID = "";
// if (!string.IsNullOrEmpty(objTaskPoint.NATIONAL_ST_CONDITION_ID))
// {
// strConditionID = objTaskPoint.NATIONAL_ST_CONDITION_ID;
// }
// if (!string.IsNullOrEmpty(objTaskPoint.LOCAL_ST_CONDITION_ID))
// {
// strConditionID = objTaskPoint.LOCAL_ST_CONDITION_ID;
// }
// if (!string.IsNullOrEmpty(objTaskPoint.INDUSTRY_ST_CONDITION_ID))
// {
// strConditionID = objTaskPoint.INDUSTRY_ST_CONDITION_ID;
// }
// //预约项目明细
// DataRow[] dtPointItem = dtContractPoint.Select("CONTRACT_POINT_ID=" + drPoint["ID"].ToString());
// if (dtPointItem.Length > 0)
// {
// string strTaskItemIDs = GetSerialNumberList("t_mis_monitor_task_item_id", dtPointItem.Length);
// string[] arrTaskItemIDs = strTaskItemIDs.Split(',');
// string strSampleResultIDs = GetSerialNumberList("MonitorResultId", dtPointItem.Length);
// string[] arrSampleResultIDs = strSampleResultIDs.Split(',');
// string strResultAppIDs = GetSerialNumberList("MonitorResultAppId", dtPointItem.Length);
// string[] arrResultAppIDs = strResultAppIDs.Split(',');
// for (int k = 0; k < dtPointItem.Length; k++)
// {
// DataRow drPointItem = dtPointItem[k];
// //项目采用的标准上限、下限
// string strUp = "";
// string strLow = "";
// string strConditionType = "";
// getStandardValue(drPointItem["ITEM_ID"].ToString(), strConditionID, ref strUp, ref strLow, ref strConditionType);
// #region 构造监测任务点位明细表
// //构造监测任务点位明细表
// TMisMonitorTaskItemVo objMonitorTaskItem = new TMisMonitorTaskItemVo();
// objMonitorTaskItem.ID = arrTaskItemIDs[k];
// objMonitorTaskItem.TASK_POINT_ID = objTaskPoint.ID;
// objMonitorTaskItem.ITEM_ID = drPointItem["ITEM_ID"].ToString();
// objMonitorTaskItem.CONDITION_ID = strConditionID;
// objMonitorTaskItem.CONDITION_TYPE = strConditionType;
// objMonitorTaskItem.ST_UPPER = strUp;
// objMonitorTaskItem.ST_LOWER = strLow;
// objMonitorTaskItem.IS_DEL = "0";
// arrPointItem.Add(objMonitorTaskItem);
// #endregion
// #region 构造样品结果表
// //构造样品结果表
// string strAnalysisID = "";//分析方法ID
// string strStandardID = "";//方法依据ID
// getMethod(drPointItem["ITEM_ID"].ToString(), ref strAnalysisID, ref strStandardID);
// TMisMonitorResultVo objSampleResult = new TMisMonitorResultVo();
// objSampleResult.ID = arrSampleResultIDs[k];
// objSampleResult.SAMPLE_ID = objSampleInfo.ID;
// objSampleResult.QC_TYPE = objSampleInfo.QC_TYPE;
// objSampleResult.ITEM_ID = drPointItem["ITEM_ID"].ToString();
// objSampleResult.SAMPLING_INSTRUMENT =GetItemSamplingInstrumentID( drPointItem["ITEM_ID"].ToString());
// objSampleResult.ANALYSIS_METHOD_ID = strAnalysisID;
// objSampleResult.STANDARD_ID = strStandardID;
// objSampleResult.QC = "0";// 默认原始样手段
// objSampleResult.TASK_TYPE = "发送";
// objSampleResult.RESULT_STATUS = "01";//默认分析结果填报
// objSampleResult.PRINTED = "0";//默认未打印
// arrSampleResult.Add(objSampleResult);
// #endregion
// #region 构造样品执行表
// //构造样品执行表
// TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo();
// objResultApp.ID = arrResultAppIDs[k];
// objResultApp.RESULT_ID = objSampleResult.ID;
// objResultApp.HEAD_USERID = drPointItem["ANALYSIS_MANAGER"].ToString();
// objResultApp.ASSISTANT_USERID = drPointItem["ANALYSIS_ID"].ToString();
// arrSampleResultApp.Add(objResultApp);
// #endregion
// }
// }
// }
// }
// #endregion
// }
// }
//}
//#endregion
#endregion
//监测子任务
#region 监测子任务
if (dtTestType.Rows.Count > 0)
{
string strSubTaskIDs = new PageBase().GetSerialNumberList("t_mis_monitor_subtaskId", dtTestType.Rows.Count);
string[] arrSubTaskIDs = strSubTaskIDs.Split(',');
for (int i = 0; i < dtTestType.Rows.Count; i++)
{
string str = dtTestType.Rows[i]["MONITOR_ID"].ToString();//监测类别
if (str.Length > 0)
{
#region 监测子任务
//监测子任务
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
string strSampleManagerID = ""; //采样负责人ID
string strSampleID = ""; //采样协同人ID串
GetSamplingMan(str, objContract.ID, ref strSampleManagerID, ref strSampleID);
objSubtask.ID = arrSubTaskIDs[i];
objSubtask.TASK_ID = objTask.ID;
objSubtask.MONITOR_ID = str;
if (objContract.PROJECT_ID != "")
{
objSubtask.SAMPLING_MANAGER_ID = objContract.PROJECT_ID;
}
else
{
objSubtask.SAMPLING_MANAGER_ID = strSampleManagerID;
}
objSubtask.SAMPLING_ID = strSampleID;
objSubtask.TASK_TYPE = "发送";
objSubtask.TASK_STATUS = "01";
arrSubTask.Add(objSubtask);
#endregion
#region 类别分点位
//按类别分点位
DataRow[] dtTypePoint = dtPoint.Select("MONITOR_ID='" + str + "'");
if (dtTypePoint.Length > 0)
{
string strTaskPointIDs = new PageBase().GetSerialNumberList("t_mis_monitor_taskpointId", dtTypePoint.Length);
string[] arrTaskPointIDs = strTaskPointIDs.Split(',');
string strSampleIDs = new PageBase().GetSerialNumberList("MonitorSampleId", dtTypePoint.Length);
string[] arrSampleIDs = strSampleIDs.Split(',');
for (int j = 0; j < dtTypePoint.Length; j++)
{
DataRow drPoint = dtTypePoint[j];
#region 监测点位
// 监测点位
TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointVo();
objTaskPoint.ID = arrTaskPointIDs[j];
objTaskPoint.TASK_ID = objTask.ID;
objTaskPoint.SUBTASK_ID = objSubtask.ID;
objTaskPoint.POINT_ID = drPoint["POINT_ID"].ToString();
objTaskPoint.MONITOR_ID = str;
//objTaskPoint.COMPANY_ID = objTaskTested.ID;
objTaskPoint.CONTRACT_POINT_ID = drPoint["ID"].ToString();
objTaskPoint.POINT_NAME = drPoint["POINT_NAME"].ToString();
objTaskPoint.DYNAMIC_ATTRIBUTE_ID = drPoint["DYNAMIC_ATTRIBUTE_ID"].ToString();
objTaskPoint.ADDRESS = drPoint["ADDRESS"].ToString();
objTaskPoint.LONGITUDE = drPoint["LONGITUDE"].ToString();
objTaskPoint.LATITUDE = drPoint["LATITUDE"].ToString();
objTaskPoint.FREQ = drPoint["FREQ"].ToString();
objTaskPoint.DESCRIPTION = drPoint["DESCRIPTION"].ToString();
objTaskPoint.NATIONAL_ST_CONDITION_ID = drPoint["NATIONAL_ST_CONDITION_ID"].ToString();
objTaskPoint.INDUSTRY_ST_CONDITION_ID = drPoint["INDUSTRY_ST_CONDITION_ID"].ToString();
objTaskPoint.LOCAL_ST_CONDITION_ID = drPoint["LOCAL_ST_CONDITION_ID"].ToString();
objTaskPoint.IS_DEL = "0";
objTaskPoint.NUM = drPoint["NUM"].ToString();
objTaskPoint.CREATE_DATE = DateTime.Now.ToString();
arrTaskPoint.Add(objTaskPoint);
#endregion
//点位采用的标准条件项ID
string strConditionID = "";
if (!string.IsNullOrEmpty(objTaskPoint.NATIONAL_ST_CONDITION_ID))
{
strConditionID = objTaskPoint.NATIONAL_ST_CONDITION_ID;
}
if (!string.IsNullOrEmpty(objTaskPoint.LOCAL_ST_CONDITION_ID))
{
strConditionID = objTaskPoint.LOCAL_ST_CONDITION_ID;
}
if (!string.IsNullOrEmpty(objTaskPoint.INDUSTRY_ST_CONDITION_ID))
{
strConditionID = objTaskPoint.INDUSTRY_ST_CONDITION_ID;
}
//计算采样频次
int intFreq = 1, intSampleDay = 1;
if (drPoint["SAMPLE_FREQ"].ToString().Length > 0)
{
intFreq = int.Parse(drPoint["SAMPLE_FREQ"].ToString());
}
//计算周期
if (drPoint["SAMPLE_DAY"].ToString().Length > 0)
{
intSampleDay = int.Parse(drPoint["SAMPLE_DAY"].ToString());
}
#region 样品信息、结果、结果执行
#region 如果 strTaskFreqType 判断为0
if (!String.IsNullOrEmpty(strTaskFreqType) && strTaskFreqType == "0")
{
#region 样品
//样品 与点位对应
TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo();
objSampleInfo.ID = arrSampleIDs[j];
objSampleInfo.SUBTASK_ID = objSubtask.ID;
objSampleInfo.POINT_ID = objTaskPoint.ID;
objSampleInfo.SAMPLE_NAME = objTaskPoint.POINT_NAME;
objSampleInfo.QC_TYPE = "0"; //默认原始样
objSampleInfo.NOSAMPLE = "0"; //默认未采样
arrSample.Add(objSampleInfo);
#endregion
//预约项目明细
DataRow[] dtPointItem = dtContractPoint.Select("CONTRACT_POINT_ID=" + drPoint["ID"].ToString());
if (dtPointItem.Length > 0)
{
string strTaskItemIDs = new PageBase().GetSerialNumberList("t_mis_monitor_task_item_id", dtPointItem.Length);
string[] arrTaskItemIDs = strTaskItemIDs.Split(',');
string strSampleResultIDs = new PageBase().GetSerialNumberList("MonitorResultId", dtPointItem.Length);
string[] arrSampleResultIDs = strSampleResultIDs.Split(',');
string strResultAppIDs = new PageBase().GetSerialNumberList("MonitorResultAppId", dtPointItem.Length);
string[] arrResultAppIDs = strResultAppIDs.Split(',');
for (int k = 0; k < dtPointItem.Length; k++)
{
DataRow drPointItem = dtPointItem[k];
//项目采用的标准上限、下限
string strUp = "";
string strLow = "";
string strConditionType = "";
getStandardValue(drPointItem["ITEM_ID"].ToString(), strConditionID, ref strUp, ref strLow, ref strConditionType);
#region 构造监测任务点位明细表
//构造监测任务点位明细表
TMisMonitorTaskItemVo objMonitorTaskItem = new TMisMonitorTaskItemVo();
objMonitorTaskItem.ID = arrTaskItemIDs[k];
objMonitorTaskItem.TASK_POINT_ID = objTaskPoint.ID;
objMonitorTaskItem.ITEM_ID = drPointItem["ITEM_ID"].ToString();
objMonitorTaskItem.CONDITION_ID = strConditionID;
objMonitorTaskItem.CONDITION_TYPE = strConditionType;
objMonitorTaskItem.ST_UPPER = strUp;
objMonitorTaskItem.ST_LOWER = strLow;
objMonitorTaskItem.IS_DEL = "0";
arrPointItem.Add(objMonitorTaskItem);
#endregion
#region 构造样品结果表
//构造样品结果表
string strAnalysisID = ""; //分析方法ID
string strStandardID = ""; //方法依据ID
string strCheckOut = ""; //检出限
getMethod(drPointItem["ITEM_ID"].ToString(), ref strAnalysisID, ref strStandardID, ref strCheckOut);
TMisMonitorResultVo objSampleResult = new TMisMonitorResultVo();
objSampleResult.ID = arrSampleResultIDs[k];
objSampleResult.SAMPLE_ID = objSampleInfo.ID;
objSampleResult.QC_TYPE = objSampleInfo.QC_TYPE;
objSampleResult.ITEM_ID = drPointItem["ITEM_ID"].ToString();
objSampleResult.SAMPLING_INSTRUMENT = GetItemSamplingInstrumentID(drPointItem["ITEM_ID"].ToString());
objSampleResult.ANALYSIS_METHOD_ID = strAnalysisID;
objSampleResult.STANDARD_ID = strStandardID;
objSampleResult.RESULT_CHECKOUT = strCheckOut;
objSampleResult.QC = "0"; // 默认原始样手段
objSampleResult.TASK_TYPE = "发送";
objSampleResult.RESULT_STATUS = "01"; //默认分析结果填报
objSampleResult.PRINTED = "0"; //默认未打印
arrSampleResult.Add(objSampleResult);
#endregion
#region 构造样品执行表
//构造样品执行表
TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo();
objResultApp.ID = arrResultAppIDs[k];
objResultApp.RESULT_ID = objSampleResult.ID;
objResultApp.HEAD_USERID = drPointItem["ANALYSIS_MANAGER"].ToString();
objResultApp.ASSISTANT_USERID = drPointItem["ANALYSIS_ID"].ToString();
arrSampleResultApp.Add(objResultApp);
#endregion
}
}
}
#endregion
#region 如果 strTaskFreqType 判断为1
if (!String.IsNullOrEmpty(strTaskFreqType) && strTaskFreqType == "1")
{
for (int r = 0; r < intSampleDay; r++)
{
for (int s = 0; s < intFreq; s++)
{
#region 样品
//样品 与点位对应
TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo();
//objSampleInfo.ID = arrSampleIDs[j];
objSampleInfo.ID = new PageBase().GetSerialNumberList("MonitorSampleId", 1);
objSampleInfo.SUBTASK_ID = objSubtask.ID;
objSampleInfo.POINT_ID = objTaskPoint.ID;
//objSampleInfo.SAMPLE_NAME = objTaskPoint.POINT_NAME;
objSampleInfo.SAMPLE_NAME = objTaskPoint.POINT_NAME + " 第" + (r + 1).ToString() + "天" + " 第" + (s + 1).ToString() + "次";
objSampleInfo.QC_TYPE = "0"; //默认原始样
objSampleInfo.NOSAMPLE = "0"; //默认未采样
arrSample.Add(objSampleInfo);
#endregion
//预约项目明细
DataRow[] dtPointItem = dtContractPoint.Select("CONTRACT_POINT_ID=" + drPoint["ID"].ToString());
if (dtPointItem.Length > 0)
{
string strTaskItemIDs = new PageBase().GetSerialNumberList("t_mis_monitor_task_item_id", dtPointItem.Length);
string[] arrTaskItemIDs = strTaskItemIDs.Split(',');
string strSampleResultIDs = new PageBase().GetSerialNumberList("MonitorResultId", dtPointItem.Length);
string[] arrSampleResultIDs = strSampleResultIDs.Split(',');
string strResultAppIDs = new PageBase().GetSerialNumberList("MonitorResultAppId", dtPointItem.Length);
string[] arrResultAppIDs = strResultAppIDs.Split(',');
for (int k = 0; k < dtPointItem.Length; k++)
{
DataRow drPointItem = dtPointItem[k];
//项目采用的标准上限、下限
string strUp = "";
string strLow = "";
string strConditionType = "";
getStandardValue(drPointItem["ITEM_ID"].ToString(), strConditionID, ref strUp, ref strLow, ref strConditionType);
#region 构造监测任务点位明细表
//构造监测任务点位明细表
TMisMonitorTaskItemVo objMonitorTaskItem = new TMisMonitorTaskItemVo();
objMonitorTaskItem.ID = arrTaskItemIDs[k];
objMonitorTaskItem.TASK_POINT_ID = objTaskPoint.ID;
objMonitorTaskItem.ITEM_ID = drPointItem["ITEM_ID"].ToString();
objMonitorTaskItem.CONDITION_ID = strConditionID;
objMonitorTaskItem.CONDITION_TYPE = strConditionType;
objMonitorTaskItem.ST_UPPER = strUp;
objMonitorTaskItem.ST_LOWER = strLow;
objMonitorTaskItem.IS_DEL = "0";
arrPointItem.Add(objMonitorTaskItem);
#endregion
#region 构造样品结果表
//构造样品结果表
string strAnalysisID = ""; //分析方法ID
string strStandardID = ""; //方法依据ID
string strCheckOut = ""; //检出限
getMethod(drPointItem["ITEM_ID"].ToString(), ref strAnalysisID, ref strStandardID, ref strCheckOut);
TMisMonitorResultVo objSampleResult = new TMisMonitorResultVo();
objSampleResult.ID = arrSampleResultIDs[k];
objSampleResult.SAMPLE_ID = objSampleInfo.ID;
objSampleResult.QC_TYPE = objSampleInfo.QC_TYPE;
objSampleResult.ITEM_ID = drPointItem["ITEM_ID"].ToString();
objSampleResult.SAMPLING_INSTRUMENT = GetItemSamplingInstrumentID(drPointItem["ITEM_ID"].ToString());
objSampleResult.ANALYSIS_METHOD_ID = strAnalysisID;
objSampleResult.STANDARD_ID = strStandardID;
objSampleResult.RESULT_CHECKOUT = strCheckOut;
objSampleResult.QC = "0"; // 默认原始样手段
objSampleResult.TASK_TYPE = "发送";
objSampleResult.RESULT_STATUS = "01"; //默认分析结果填报
objSampleResult.PRINTED = "0"; //默认未打印
arrSampleResult.Add(objSampleResult);
#endregion
#region 构造样品执行表
//构造样品执行表
TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo();
objResultApp.ID = arrResultAppIDs[k];
objResultApp.RESULT_ID = objSampleResult.ID;
objResultApp.HEAD_USERID = drPointItem["ANALYSIS_MANAGER"].ToString();
objResultApp.ASSISTANT_USERID = drPointItem["ANALYSIS_ID"].ToString();
arrSampleResultApp.Add(objResultApp);
#endregion
}
}
}
}
}
#endregion
#endregion
}
}
#endregion
}
}
}
#endregion
if (new TMisMonitorTaskLogic().SaveTrans(objTask, objReportVo, arrTaskPoint, arrSubTask, arrPointItem, arrSample, arrSampleResult, arrSampleResultApp))
{
strReturn = "1";
}
}
return(strReturn);
}
