/// <summary>
/// 获取委托书下下有监测点位的所有监测类别 Create By Castle (胡方扬) 2012-12-21
/// </summary>
/// <returns></returns>
private string GetPointMonitorInfor()
{
DataTable dt = new DataTable();
TMisContractPointFreqVo objItems = new TMisContractPointFreqVo();
objItems.CONTRACT_ID = Request.QueryString["task_id"].ToString();
dt = new TMisContractPointFreqLogic().GetPointMonitorInforForPlan(objItems, Request.QueryString["strPlanId"].ToString());
return(PageBase.LigerGridDataToJson(dt, dt.Rows.Count));
}
protected void btnExport_Click(object sender, EventArgs e)
{
FileStream file = null;
if (strType == "QY")
{
file = new FileStream(HttpContext.Current.Server.MapPath("../Monitor/sampling/template/WorkTaskSheetQY.xls"), FileMode.Open, FileAccess.Read);
}
else if (strType == "ZZ")
{
file = new FileStream(HttpContext.Current.Server.MapPath("../Monitor/sampling/template/WorkTaskSheet.xls"), FileMode.Open, FileAccess.Read);
}
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
string strTaskType = "", strMonitorList = "", Monitor = "", strWorkContent = "";
DataTable dt = GetPendingPlanDataTable();
//插入委托书单号
if (dt.Rows.Count > 0)
{
sheet.GetRow(4).GetCell(1).SetCellValue(dt.Rows[0]["TICKET_NUM"].ToString());
sheet.GetRow(4).GetCell(6).SetCellValue(dt.Rows[0]["REPORT_CODE"].ToString());
strTaskType = getDictName(dt.Rows[0]["CONTRACT_TYPE"].ToString(), "Contract_Type");
sheet.GetRow(5).GetCell(1).SetCellValue(strTaskType + "任务");
sheet.GetRow(5).GetCell(7).SetCellValue(dt.Rows[0]["CONTRACT_CODE"].ToString());
string[] strMonitroTypeArr = dt.Rows[0]["TEST_TYPE"].ToString().Split(';');
//string[] strMonitroTypeArr = dt.Rows[0]["TEST_TYPES"].ToString().Split(';');
//foreach (string str in strMonitroTypeArr) {
// string strMonitor = "";
// strMonitor = GetMonitorName(str);
// strMonitorList += (strMonitor == "水和废水" ? "废水" : (strMonitor == "气和废气" ? "废气" : strMonitor)) + "、";
//}
// strMonitorList = strMonitorList.Substring(0, strMonitorList.Length - 1);
TMisContractPointFreqVo objItems = new TMisContractPointFreqVo();
objItems.CONTRACT_ID = "";
DataTable dts = new TMisContractPointFreqLogic().GetPointMonitorInforForPlan(objItems, dt.Rows[0]["ID"].ToString());
if (dts.Rows.Count > 0)
{
strMonitorList = dts.Rows[0][1].ToString();
}
sheet.GetRow(7).GetCell(1).SetCellValue(strMonitorList);
if (dt.Rows[0]["SAMPLE_SOURCE"].ToString() == "送样")
{
//strWorkContent += "地表水、地下水(送样)\n";
int intLen = strMonitroTypeArr.Length;
int INTSHOWLEN = 0;
foreach (string strMonitor in strMonitroTypeArr)
{
INTSHOWLEN++;
strWorkContent += GetMonitorName(strMonitor) + "、";
if (INTSHOWLEN == intLen - 1)
{
strWorkContent += "(送样)\n";
}
}
}
//获取当前监测类别信息
DataTable dtMonitor = GetPendingPlanDistinctMonitorDataTable();
DataTable dtPoint = GetPendingPlanPointDataTable();
string strOutValuePoint = "", strOutValuePointItems = "";
int IS_SAMPLEDEPT = 0; //是否存在现场监测项目
int IS_CERTIFICATE = 0; //是否存在实验室监测项目
if (dtMonitor.Rows.Count > 0)
{
foreach (DataRow drr in dtMonitor.Rows)
{
string strMonitorName = "", strPointName = "";
DataRow[] drPoint = dtPoint.Select("MONITOR_ID='" + drr["MONITOR_ID"].ToString() + "'");
if (drPoint.Length > 0)
{
foreach (DataRow drrPoint in drPoint)
{
string strPointNameForItems = "", strPointItems = "";
strMonitorName = drrPoint["MONITOR_TYPE_NAME"].ToString() + "：";
strPointName += drrPoint["POINT_NAME"].ToString() + "、";
//获取当前点位的监测项目
DataTable dtPointItems = GetPendingPlanPointItemsDataTable(drrPoint["CONTRACT_POINT_ID"].ToString());
if (dtPointItems.Rows.Count > 0)
{
foreach (DataRow drItems in dtPointItems.Rows)
{
strPointNameForItems = strMonitorName.Substring(0, strMonitorName.Length - 1) + drrPoint["POINT_NAME"] + "(" + (drrPoint["SAMPLE_DAY"].ToString() == "" ? "1" : drrPoint["SAMPLE_DAY"].ToString()) + "天" + (drrPoint["SAMPLE_FREQ"].ToString() == "" ? "1" : drrPoint["SAMPLE_FREQ"].ToString()) + "次):";
strPointItems += drItems["ITEM_NAME"].ToString() + "、";
if (drItems["IS_SAMPLEDEPT"].ToString() == "是")
{
IS_SAMPLEDEPT = 1;
}
if (drItems["IS_SAMPLEDEPT"].ToString() == "否")
{
IS_CERTIFICATE = 1;
}
}
strOutValuePointItems += strPointNameForItems + strPointItems.Substring(0, strPointItems.Length - 1) + "；\n";
}
}
//获取输出监测类型监测点位信息
strOutValuePoint += strMonitorName + strPointName.Substring(0, strPointName.Length - 1) + "；\n";
}
}
}
strWorkContent += "监测点位：\n" + strOutValuePoint;
strWorkContent += "监测因子与频次：\n" + strOutValuePointItems;
sheet.GetRow(9).GetCell(1).SetCellValue(strWorkContent);
string strLinkPerple = "";
//if (dt.Rows[0]["CONTRACT_TYPE"].ToString() == "02" || dt.Rows[0]["CONTRACT_TYPE"].ToString() == "03")//应急或者管理类的 strMonitorList
if (strMonitorList == "02" || strMonitorList == "03")//应急或者管理类的 strMonitorList
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：韩永博 \n";
}
else
{
#region//暂不用代码
//string[] strMonitroType = dt.Rows[0]["TEST_TYPE"].ToString().Split(';');
//foreach (string strs in strMonitroType)
//{
// string strMonitors = "";
// strMonitors = GetMonitorName(strs);
// if (strMonitors == "水和废水")
// {
// Monitor = "水";
// }
// else if (strMonitors == "气和废气")
// {
// Monitor = "气";
// }
// else if (strMonitors == "固废和土壤")
// {
// Monitor = "固体";
// }
// else if (strMonitors.Contains("噪声"))
// {
// Monitor = "噪声";
// }
// Monitor = Monitor + "、";
//}
//Monitor = Monitor.Substring(0, Monitor.Length - 1);
#endregion
if (strMonitorList == "水" || strMonitorList == "固体")
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：韩永博 \n";
}
else if (strMonitorList == "气" || strMonitorList == "噪声")
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：马振芳\n";
}
else if (strMonitorList == "水、气、声、固体")
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：王志远\n";
}
}
//strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + "\n";
//strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
//if (!String.IsNullOrEmpty(dt.Rows[0]["PROJECT_ID"].ToString()))
//{
// strLinkPerple += "项目负责人:" + GetUserName(dt.Rows[0]["PROJECT_ID"].ToString());
//}
//else
//{
// strLinkPerple += "报告编写：";
//}
sheet.GetRow(10).GetCell(1).SetCellValue(strLinkPerple);
//任务来源
sheet.GetRow(6).GetCell(1).SetCellValue(dt.Rows[0]["COMPANY_NAME"].ToString());
//接收科室
string strJSKS = "";
strJSKS += "现场室、";
//if (IS_SAMPLEDEPT == 1)
//{
// strJSKS += "现场室、";
//}
if (IS_CERTIFICATE == 1)
{
strJSKS += "实验室、";
}
sheet.GetRow(8).GetCell(1).SetCellValue(strJSKS.TrimEnd('、'));
if (!String.IsNullOrEmpty(dt.Rows[0]["ASKING_DATE"].ToString()))
{
sheet.GetRow(11).GetCell(1).SetCellValue(DateTime.Parse(dt.Rows[0]["ASKING_DATE"].ToString()).ToString("yyyy-MM-dd"));
}
//sheet.GetRow(11).GetCell(3).SetCellValue(LogInfo.UserInfo.REAL_NAME);
sheet.GetRow(11).GetCell(6).SetCellValue(DateTime.Now.ToString("yyyy-MM-dd"));
}
using (MemoryStream stream = new MemoryStream())
{
hssfworkbook.Write(stream);
HttpContext curContext = HttpContext.Current;
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = Encoding.UTF8;
curContext.Response.Charset = "";
curContext.Response.AppendHeader("Content-Disposition",
"attachment;filename=" + HttpUtility.UrlEncode("工作任务通知单-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", Encoding.UTF8));
curContext.Response.BinaryWrite(stream.GetBuffer());
curContext.Response.End();
}
}
protected void ReturnAllTaskStep()
{
//任务对象
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(this.TASK_ID.Value);
//子任务信息
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskLogic().Details(new TMisMonitorSubtaskVo()
{
TASK_ID = this.TASK_ID.Value,
MONITOR_ID = this.dllMonitor.SelectedValue
});
//样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(new TMisMonitorSampleInfoVo()
{
SUBTASK_ID = objSubTask.ID,
QC_TYPE = "0"
});
//样品结果信息
DataTable dtResult = new TMisMonitorResultLogic().SelectResultAndAppWithSubtaskID(objSubTask.ID);
//校阅
//委托书对象
TMisContractVo objContract = new TMisContractLogic().Details(objTask.CONTRACT_ID);
//预约表
TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(new TMisContractPlanVo()
{
CONTRACT_ID = objContract.ID
});
//预约频次表(已预约未办理数)
TMisContractPointFreqVo objPointFreq = new TMisContractPointFreqLogic().Details(new TMisContractPointFreqVo()
{
CONTRACT_ID = objContract.ID
});
//自送样预约数(已预约未办理数)
TMisContractSamplePlanVo objSamplePlan = new TMisContractSamplePlanLogic().Details(new TMisContractSamplePlanVo()
{
CONTRACT_ID = objContract.ID,
});
#region 暂行的定制生成任务追踪方法 页面HTML构建
//定义已处理DIV样式
string strDivHas = "<div style='width:150px;height:auto;background-color:#5a8f5a;text-align: center;vertical-align: middle;'>{0}</div>";
//定义待处理DIV样式
string strDivWait = "<div style='width:150px;height:auto;background-color:#de9a1d;text-align: center;vertical-align: middle;'>{0}</div>";
//定义特殊处理DIV样式
//string strDivSepecial = "<div style='width:100px;height:50px;background-color:#e34323;text-align: center;vertical-align: middle;'>{0}</div";
//定义未处理DIV样式
//string strDivNo = "<div style='width:100px;height:50px;background-color:#a9a9a9;text-align: center;vertical-align: middle;'>{0}</div>";
#region 办理人
//采样负责人
string strSampleManager = GetSampleManager(objSubTask.SAMPLING_MANAGER_ID);
//交接人
string strSampleAccept = GetDefaultOrFirstDutyUser("sample_allocation_sheet", this.dllMonitor.SelectedValue);
//采样任务分配人
string strSampleSender = GetDefaultOrFirstDutyUser("duty_other_sampling", this.dllMonitor.SelectedValue);
//采样后质控人
string strQcEnd = GetDefaultOrFirstDutyUser("sample_qc_end", this.dllMonitor.SelectedValue);
//分析任务分配人
string strAnalyseSender = GetDefaultOrFirstDutyUser("duty_other_analyse", this.dllMonitor.SelectedValue);
//校核人
string strAnalyseChecker = GetDefaultOrFirstDutyUser("duty_other_audit ", this.dllMonitor.SelectedValue);
//复核人
string strAnalyseAgainChecker = GetDefaultOrFirstDutyUser("duty_other_analyse_result", this.dllMonitor.SelectedValue);
//审核人
string strQcChecker = GetDefaultOrFirstDutyUser("duty_other_analyse_control", this.dllMonitor.SelectedValue);
#endregion
Table table1 = new Table();
table1.CssClass = "tMain";
TableRow row1 = new TableRow();//委托流程连接
TableCell cell1 = new TableCell();
cell1.Text = string.Format(strDivHas, "委托流程");
row1.Cells.Add(cell1);
table1.Rows.Add(row1);
//是否已预约
if (!string.IsNullOrEmpty(objPointFreq.ID))
{
if (objPointFreq.IF_PLAN == null)//未预约
{
table1 = GetCommonRow(table1, strDivWait, "采样预约", "");
this.divSample.Controls.Add(table1);
return;
}
else if (objPointFreq.IF_PLAN == "0")//已预约未办理
{
table1 = GetCommonRow(table1, strDivHas, "采样预约", "");
}
}
//自送样 预约
if (objSamplePlan.IF_PLAN == "0")//未预约
{
table1 = GetCommonRow(table1, strDivWait, "送样预约", "");
this.divSample.Controls.Add(table1);
return;
}
else if (objSamplePlan.IF_PLAN == "1")//已预约
{
table1 = GetCommonRow(table1, strDivWait, "送样预约", "");
this.divSample.Controls.Add(table1);
return;
}
else if (objSamplePlan.IF_PLAN == "2")//预约办理
{
table1 = GetCommonRow(table1, strDivHas, "送样预约", "");
}
//是否预约办理
if (objPlan.ID != "")
{
if (objPlan.HAS_DONE == "1")//已办理
{
table1 = GetCommonRow(table1, strDivHas, "预约办理", strSampleSender);
}
else if (objPlan.HAS_DONE == "0" || string.IsNullOrEmpty(objPlan.HAS_DONE))
{
table1 = GetCommonRow(table1, strDivWait, "预约办理", strSampleSender);
this.divSample.Controls.Add(table1);
return;
}
}
//是否采样
if (objSubTask.TASK_STATUS == "02")
{
table1 = GetCommonRow(table1, strDivWait, "采样", strSampleManager);
}
//样品交接
if (objSubTask.TASK_STATUS == "021")
{
if (!string.IsNullOrEmpty(objPlan.ID))
{
table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager);
}
table1 = GetCommonRow(table1, strDivWait, "样品交接", strSampleAccept);
}
//分析任务分配
DataRow[] dr1 = dtResult.Select(" RESULT_STATUS='01'");//过滤过分析分配环节任务
//分析结果录入
DataRow[] dr2 = dtResult.Select(" RESULT_STATUS='20'");
//数据审核
DataRow[] dr3 = dtResult.Select(" RESULT_STATUS='30'");
//分析室主任审核
DataRow[] dr4 = dtResult.Select(" RESULT_STATUS='40'");
//技术室主任审核
DataRow[] dr5 = dtResult.Select(" RESULT_STATUS='50'");
if (objSubTask.TASK_STATUS == "03")
{
if (dr1.Length > 0)//环节在分析任务分配
{
if (!string.IsNullOrEmpty(objPlan.ID))
{
table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager);
}
table1 = GetCommonRow(table1, strDivHas, "样品交接", strSampleAccept);
table1 = GetCommonRow(table1, strDivWait, "分析任务分配", strAnalyseSender);
}
else
{
if (!string.IsNullOrEmpty(objPlan.ID))
{
table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager);
}
table1 = GetCommonRow(table1, strDivHas, "样品交接", strSampleAccept);
table1 = GetCommonRow(table1, strDivHas, "分析任务分配", strAnalyseSender);
table1 = GetResultRow(table1, strDivHas, strDivWait, "分析结果录入", dtResult);
if (dr2.Length > 0) //结果提交不完全时
{
if (dr5.Length > 0) //流程已到技术室审核环节（最后环节）
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", strAnalyseChecker);
table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", strAnalyseAgainChecker);
table1 = GetCommonRow(table1, strDivWait, "技术室主任审核", strQcChecker);
}
else
{
if (dr4.Length > 0)//流程仅到分析室审核
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", strAnalyseChecker);
table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", strAnalyseAgainChecker);
}
else
{
if (dr3.Length > 0)//流程仅到数据审核
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", strAnalyseChecker);
}
}
}
}
else//结果提交完全时
{
if (dr3.Length > 0)//数据审核不完全
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", strAnalyseChecker);
}
else
{
table1 = GetCommonRow(table1, strDivHas, "数据审核", strAnalyseChecker);
}
if (dr4.Length > 0)//分析审核不完全
{
table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", strAnalyseAgainChecker);
}
else if (dr3.Length == 0)//已经全部发送
{
table1 = GetCommonRow(table1, strDivHas, "分析室主任审核", strAnalyseAgainChecker);
}
if (dr5.Length > 0) //流程已到技术室审核环节（最后环节）
{
if (objSubTask.TASK_STATUS == "09" && objTask.TASK_STATUS == "09") //分析流程完成
{
table1 = GetCommonRow(table1, strDivHas, "技术室主任审核", strQcChecker);
}
else
{
table1 = GetCommonRow(table1, strDivWait, "技术室主任审核", strQcChecker);
}
}
}
}
}
else if (objTask.TASK_STATUS == "09" && objSubTask.TASK_STATUS == "09")//报告
{
if (!string.IsNullOrEmpty(objPlan.ID))
{
table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager);
}
table1 = GetCommonRow(table1, strDivHas, "样品交接", strSampleAccept);
table1 = GetCommonRow(table1, strDivHas, "分析任务分配", strAnalyseSender);
table1 = GetResultRow(table1, strDivHas, strDivWait, "分析结果录入", dtResult);
table1 = GetCommonRow(table1, strDivHas, "数据审核", strAnalyseChecker);
table1 = GetCommonRow(table1, strDivHas, "分析室主任审核", strAnalyseAgainChecker);
table1 = GetCommonRow(table1, strDivHas, "技术室主任审核", strQcChecker);
table1.Rows.Add(GetFollowRow());
TableRow row = new TableRow();//报告流程连接
TableCell cell = new TableCell();
// cell.Text = string.Format(strDivHas, "<a href='#' onclick='ShowReport(" + this.TASK_ID.Value + ");'>报告流程</a>");
cell.Text = string.Format(strDivHas, "报告流程");
row.Cells.Add(cell);
table1.Rows.Add(row);
}
this.divSample.Controls.Add(table1);
#endregion
}
/// <summary>
/// 保存默认监测计划岗位负责人 Create By Castle (胡方扬) 2013-4-1
/// </summary>
/// <returns></returns>
public static void SavePlanPeopleForEnv(string strPlanId)
{
DataTable dtMonitor = new DataTable();
TMisContractPointFreqVo objItemspan = new TMisContractPointFreqVo();
objItemspan.IF_PLAN = "0";
dtMonitor = new TMisContractPointFreqLogic().GetPointMonitorInforForPlan(objItemspan, strPlanId);
//DataTable dtMonitor = GetPointMonitorInfor(strPlanId);
DataTable dtTemple = new DataTable();
TSysDutyVo objItemspan1 = new TSysDutyVo();
objItemspan1.DICT_CODE = "duty_sampling";
dtTemple = new TSysDutyLogic().SelectTableDutyUser(objItemspan1);
//DataTable dtTemple = GetMonitorDutyInforTable();
DataTable dtMonitorDutyUser = new DataTable();
dtMonitorDutyUser = dtTemple.Copy();
dtMonitorDutyUser.Clear();
//获取默认负责人
for (int n = 0; n < dtMonitor.Rows.Count; n++)
{
DataRow[] drowArr = dtTemple.Select(" IF_DEFAULT='0' AND MONITOR_TYPE_ID='" + dtMonitor.Rows[0]["ID"].ToString() + "'");
if (drowArr.Length > 0)
{
foreach (DataRow drow in drowArr)
{
dtMonitorDutyUser.ImportRow(drow);
}
dtMonitorDutyUser.AcceptChanges();
}
else
{
drowArr = dtTemple.Select(" MONITOR_TYPE_ID='" + dtMonitor.Rows[0]["ID"].ToString() + "'");
if (drowArr.Length > 0)
{
dtMonitorDutyUser.ImportRow(drowArr[0]);
}
dtMonitorDutyUser.AcceptChanges();
}
}
//if (drowArr.Length > 0)
//{
// foreach (DataRow drow in drowArr)
// {
// dtMonitorDutyUser.ImportRow(drow);
// }
// dtMonitorDutyUser.AcceptChanges();
//}
string strMonitorId = "", strUserId = "";
foreach (DataRow drr in dtMonitor.Rows)
{
for (int i = 0; i < dtMonitorDutyUser.Rows.Count; i++)
{
if (drr["ID"].ToString() == dtMonitorDutyUser.Rows[i]["MONITOR_TYPE_ID"].ToString())
{
strMonitorId += drr["ID"].ToString() + ";";
strUserId += dtMonitorDutyUser.Rows[i]["USERID"].ToString() + ";";
}
}
}
TMisContractUserdutyVo objItems = new TMisContractUserdutyVo();
if (!String.IsNullOrEmpty(strPlanId))
{
objItems.CONTRACT_PLAN_ID = strPlanId;
string[] strMonitArr = null, strUserArr = null;
if (!String.IsNullOrEmpty(strMonitorId) && !String.IsNullOrEmpty(strUserId))
{
strMonitArr = strMonitorId.Substring(0, strMonitorId.Length - 1).Split(';');
strUserArr = strUserId.Substring(0, strUserId.Length - 1).Split(';');
if (strMonitArr != null && strUserArr != null)
{
new TMisContractUserdutyLogic().SaveContractPlanDutyForEnv(objItems, strMonitArr, strUserArr);
}
}
}
}
protected void ReturnAllTaskStep()
{
//任务对象
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(this.TASK_ID.Value);
//子任务信息
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskLogic().Details(new TMisMonitorSubtaskVo()
{
TASK_ID = this.TASK_ID.Value,
MONITOR_ID = this.dllMonitor.SelectedValue
});
//样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(new TMisMonitorSampleInfoVo()
{
SUBTASK_ID = objSubTask.ID,
QC_TYPE = "0"
});
//样品结果信息
DataTable dtResult = new TMisMonitorResultLogic().SelectResultAndAppWithSubtaskID(objSubTask.ID);
//校阅
//委托书对象
TMisContractVo objContract = new TMisContractLogic().Details(objTask.CONTRACT_ID);
//预约表
TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(new TMisContractPlanVo()
{
CONTRACT_ID = objContract.ID
});
//预约频次表(已预约未办理数)
int intIsPlanNoDo = new TMisContractPointFreqLogic().GetSelectResultCount(new TMisContractPointFreqVo()
{
CONTRACT_ID = objContract.ID,
IF_PLAN = "0"
});
#region 暂行的定制生成任务追踪方法 页面HTML构建
//定义已处理DIV样式
string strDivHas = "<div style='width:150px;height:50px;background-color:#5a8f5a;text-align: center;vertical-align: middle;'>{0}</div>";
//定义待处理DIV样式
string strDivWait = "<div style='width:150px;height:50px;background-color:#de9a1d;text-align: center;vertical-align: middle;'>{0}</div>";
//定义特殊处理DIV样式
//string strDivSepecial = "<div style='width:100px;height:50px;background-color:#e34323;text-align: center;vertical-align: middle;'>{0}</div";
//定义未处理DIV样式
//string strDivNo = "<div style='width:100px;height:50px;background-color:#a9a9a9;text-align: center;vertical-align: middle;'>{0}</div>";
Table table1 = new Table();
table1.CssClass = "tMain";
TableRow row1 = new TableRow();//委托流程连接
TableCell cell1 = new TableCell();
cell1.Text = string.Format(strDivHas, "<a href='#' onclick='ShowContract();'>委托流程</a>");
row1.Cells.Add(cell1);
table1.Rows.Add(row1);
//是否已预约
if (intIsPlanNoDo > 0)
{
table1 = GetCommonRow(table1, strDivHas, "采样预约", "");
}
else
{
table1 = GetCommonRow(table1, strDivWait, "采样预约", "");
this.divSample.Controls.Add(table1);
return;
}
//是否预约办理
if (objPlan.HAS_DONE == "1")//已办理
{
table1 = GetCommonRow(table1, strDivHas, "预约办理", "");
}
else
{
table1 = GetCommonRow(table1, strDivWait, "预约办理", "");
this.divSample.Controls.Add(table1);
return;
}
//采样负责人
string strSampleManager = GetSampleManager(objSubTask.SAMPLING_MANAGER_ID);
//交接人
string strSampleAccept = string.Empty;
DataTable dtSampleAccept = new TSysUserDutyLogic().SelectUserDuty("sample_allocation_sheet", this.dllMonitor.SelectedValue);
if (dtSampleAccept.Rows.Count > 0)
{
strSampleAccept = GetSampleManager(dtSampleAccept.Rows[0]["USERID"].ToString());
}
//是否采样
if (objSubTask.TASK_STATUS == "02")
{
table1 = GetCommonRow(table1, strDivWait, "采样", strSampleManager);
}
//样品交接
if (objSubTask.TASK_STATUS == "021")
{
table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager);
table1 = GetCommonRow(table1, strDivWait, "样品交接", strSampleAccept);
}
//分析任务分配
DataRow[] dr1 = dtResult.Select(" RESULT_STATUS='01'");//过滤过分析分配环节任务
//分析结果录入
DataRow[] dr2 = dtResult.Select(" RESULT_STATUS='20'");
//数据审核
DataRow[] dr3 = dtResult.Select(" RESULT_STATUS='30'");
//分析室主任审核
DataRow[] dr4 = dtResult.Select(" RESULT_STATUS='40'");
//技术室主任审核
DataRow[] dr5 = dtResult.Select(" RESULT_STATUS='50'");
if (objSubTask.TASK_STATUS == "03")
{
if (dr1.Length > 0)//环节在分析任务分配
{
table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager);
table1 = GetCommonRow(table1, strDivHas, "样品交接", strSampleAccept);
table1 = GetCommonRow(table1, strDivWait, "分析任务分配", "");
}
else
{
table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager);
table1 = GetCommonRow(table1, strDivHas, "样品交接", strSampleAccept);
table1 = GetCommonRow(table1, strDivHas, "分析任务分配", "");
table1 = GetResultRow(table1, strDivHas, strDivWait, "分析结果录入", dtResult);
if (dr2.Length > 0) //结果提交不完全时
{
if (dr5.Length > 0) //流程已到技术室审核环节（最后环节）
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", "");
table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", "");
table1 = GetCommonRow(table1, strDivWait, "技术室主任审核", "");
}
else
{
if (dr4.Length > 0)//流程仅到分析室审核
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", "");
table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", "");
}
else
{
if (dr3.Length > 0)//流程仅到数据审核
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", "");
}
}
}
}
else//结果提交完全时
{
if (dr3.Length > 0)//数据审核不完全
{
table1 = GetCommonRow(table1, strDivWait, "数据审核", "");
}
else
{
table1 = GetCommonRow(table1, strDivHas, "数据审核", "");
}
if (dr4.Length > 0)//分析审核不完全
{
table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", "");
}
else
{
table1 = GetCommonRow(table1, strDivHas, "分析室主任审核", "");
}
if (dr5.Length > 0) //流程已到技术室审核环节（最后环节）
{
if (objSubTask.TASK_STATUS == "09" && objTask.TASK_STATUS == "09") //分析流程完成
{
table1 = GetCommonRow(table1, strDivHas, "技术室主任审核", "");
TableRow row = new TableRow();//委托流程连接
TableCell cell = new TableCell();
cell.Text = string.Format(strDivHas, "<a href='#' onclick='ShowReport();'>报告流程</a>");
row.Cells.Add(cell);
table1.Rows.Add(row);
}
else
{
table1 = GetCommonRow(table1, strDivWait, "技术室主任审核", "");
}
}
}
}
}
this.divSample.Controls.Add(table1);
#endregion
}
