private string GetCompany_UnderTask(string strTaskID)
{
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(strTaskID);
TMisMonitorTaskCompanyVo objCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
return(objCompany.COMPANY_NAME);
}
/// <summary>
/// 获得委托书信息
/// </summary>
/// <returns>Json</returns>
protected string GetContractInfo()
{
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(this.SUBTASK_ID.Value);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
TMisMonitorTaskCompanyVo objConCompany = new TMisMonitorTaskCompanyVo();
objConCompany.TASK_ID = objTask.ID;
objConCompany = new TMisMonitorTaskCompanyLogic().Details(objConCompany);
objSubtask.MONITOR_ID = getMonitorTypeName(objSubtask.MONITOR_ID);
objSubtask.SAMPLING_MANAGER_ID = new TSysUserLogic().Details(LogInfo.UserInfo.ID).REAL_NAME;
objSubtask.REMARK1 = objTask.CONTRACT_CODE;
objSubtask.REMARK2 = getDictName(objTask.CONTRACT_TYPE, "Contract_Type");
objSubtask.REMARK3 = objConCompany.COMPANY_NAME;
objSubtask.REMARK4 = objConCompany.CONTACT_NAME;
objSubtask.REMARK5 = objConCompany.LINK_PHONE;
if (!String.IsNullOrEmpty(objSubtask.SAMPLE_ASK_DATE))
{
objSubtask.SAMPLE_ASK_DATE = DateTime.Parse(objSubtask.SAMPLE_ASK_DATE).ToString("yyyy-MM-dd");
}
if (!String.IsNullOrEmpty(objSubtask.SAMPLE_FINISH_DATE))
{
objSubtask.SAMPLE_FINISH_DATE = DateTime.Parse(objSubtask.SAMPLE_FINISH_DATE).ToString("yyyy-MM-dd");
}
return(ToJson(objSubtask));
}
private void getPrintQcInfo_pan(ref TMisMonitorTaskVo objTask, ref TMisMonitorTaskCompanyVo objCompany, ref int isOk)
{
if (!String.IsNullOrEmpty(strPlanId))
{
TMisMonitorTaskVo objTaskWhere = new TMisMonitorTaskVo();
objTaskWhere.PLAN_ID = strPlanId;
objTask = new TMisMonitorTaskLogic().Details(objTaskWhere);
objCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
isOk = 1;
}
}
private void getPrintQcInfo_pan(ref TMisMonitorTaskVo objTask, ref TMisMonitorTaskCompanyVo objCompany, ref int isOk)
{
string strTaskId = hidTaskId.Value;
if (!String.IsNullOrEmpty(strTaskId) && strTaskId.Length > 0)
{
objTask = new TMisMonitorTaskLogic().Details(strTaskId);
objCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
isOk = 1;
}
}
/// <summary>
/// 获得委托书信息
/// </summary>
/// <returns>Json</returns>
protected string GetContractInfo()
{
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(this.SUBTASK_ID.Value);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
TMisMonitorTaskCompanyVo objConCompany = new TMisMonitorTaskCompanyVo();
//objConCompany.TASK_ID = objTask.ID;
objConCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
objSubtask.MONITOR_ID = getMonitorTypeName(objSubtask.MONITOR_ID);
objSubtask.SAMPLING_MANAGER_ID = new TSysUserLogic().Details(objSubtask.SAMPLING_MANAGER_ID).REAL_NAME;
objSubtask.REMARK1 = objTask.CONTRACT_CODE;
objSubtask.REMARK2 = getDictName(objTask.CONTRACT_TYPE, "Contract_Type");
objSubtask.REMARK3 = objConCompany.COMPANY_NAME;
objSubtask.REMARK4 = objConCompany.CONTACT_NAME;
objSubtask.REMARK5 = objConCompany.PHONE;
objSubtask.SAMPLE_APPROVE_INFO = objTask.TEST_PURPOSE;
if (!String.IsNullOrEmpty(objSubtask.SAMPLE_ASK_DATE))
{
objSubtask.SAMPLE_ASK_DATE = DateTime.Parse(objSubtask.SAMPLE_ASK_DATE).ToString("yyyy-MM-dd");
}
if (!String.IsNullOrEmpty(objSubtask.SAMPLE_FINISH_DATE))
{
objSubtask.SAMPLE_FINISH_DATE = DateTime.Parse(objSubtask.SAMPLE_FINISH_DATE).ToString("yyyy-MM-dd");
}
//获取退回意见信息
TMisReturnInfoVo ReturnInfoVo = new TMisReturnInfoVo();
ReturnInfoVo.TASK_ID = objSubtask.TASK_ID;
ReturnInfoVo.SUBTASK_ID = objSubtask.ID;
if (Request.QueryString["strLink"].ToString() == "Sample")
{
ReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_003;
ReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_002;
}
if (Request.QueryString["strLink"].ToString() == "Check")
{
ReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_004;
ReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_003;
}
if (Request.QueryString["strLink"].ToString() == "QcCheck")
{
ReturnInfoVo.CURRENT_STATUS = "111";
ReturnInfoVo.BACKTO_STATUS = "222";
}
ReturnInfoVo = new TMisReturnInfoLogic().Details(ReturnInfoVo);
if (ReturnInfoVo.ID.Length > 0)
{
objSubtask.SAMPLING_METHOD = "退回意见：" + ReturnInfoVo.SUGGESTION;
}
return(ToJson(objSubtask));
}
/// <summary>
/// 获得受检单位信息
/// </summary>
/// <returns>Json</returns>
protected string GetTestedInfo()
{
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(this.ID.Value);
TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo();
if (!string.IsNullOrEmpty(objTask.TESTED_COMPANY_ID))
{
objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(new TMisMonitorTaskCompanyVo()
{
ID = objTask.TESTED_COMPANY_ID, IS_DEL = "0"
});
}
return(ToJson(objTaskCompany));
}
/// <summary>
/// 创建原因：根据子任务ID获取企业信息
/// 创建人：胡方扬
/// 创建时间：2013-07-09
/// </summary>
/// <returns></returns>
public string getCompanyInfor()
{
string result = "";
if (!String.IsNullOrEmpty(strSubTask_Id))
{
TMisMonitorResultVo objResult = new TMisMonitorResultLogic().Details(strSubTask_Id);
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(objResult.SAMPLE_ID);
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubTask.TASK_ID);
TMisMonitorTaskCompanyVo objCompany = new TMisMonitorTaskCompanyVo();
objCompany.ID = objTask.TESTED_COMPANY_ID;
DataTable dt = new TMisMonitorTaskCompanyLogic().SelectByTable(objCompany);
dt.Columns.Add("SAMPLE_CODE");
dt.Rows[0]["SAMPLE_CODE"] = objSample.SAMPLE_CODE;
result = LigerGridDataToJson(dt, dt.Rows.Count);
}
return(result);
}
public static string SaveData(string strPointID, string strSubtaskID, string strPOINT_NAME, string strMONITOR_ID, string strPOINT_TYPE, string strDYNAMIC_ATTRIBUTE_ID, string strFREQ,
string strCREATE_DATE, string strADDRESS, string strLONGITUDE, string strLATITUDE, string strNUM, string strAttribute,
string strNATIONAL_ST_CONDITION_ID, string strLOCAL_ST_CONDITION_ID, string strINDUSTRY_ST_CONDITION_ID)
{
bool isSuccess = true;
TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo();
objPoint.ID = strPointID.Length > 0 ? strPointID : GetSerialNumber("t_mis_monitor_taskpointId");
objPoint.IS_DEL = "0";
objPoint.SUBTASK_ID = strSubtaskID;
objPoint.POINT_NAME = strPOINT_NAME;
objPoint.MONITOR_ID = strMONITOR_ID;
objPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID;
objPoint.FREQ = strFREQ;
objPoint.CREATE_DATE = strCREATE_DATE;
objPoint.ADDRESS = strADDRESS;
objPoint.LONGITUDE = strLONGITUDE;
objPoint.LATITUDE = strLATITUDE;
objPoint.NUM = strNUM;
objPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID;
objPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID;
objPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID;
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubtaskID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
objPoint.TASK_ID = objTask.ID;
//监测任务出现新增排口时，基础资料企业表也要新增
TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo();
if (strPointID.Length == 0)
{
objnewPoint.ID = GetSerialNumber("t_base_company_point_id");
objnewPoint.IS_DEL = "0";
objnewPoint.POINT_NAME = strPOINT_NAME;
objnewPoint.MONITOR_ID = strMONITOR_ID;
objnewPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID;
objnewPoint.FREQ = strFREQ;
objnewPoint.CREATE_DATE = strCREATE_DATE;
objnewPoint.ADDRESS = strADDRESS;
objnewPoint.LONGITUDE = strLONGITUDE;
objnewPoint.LATITUDE = strLATITUDE;
objnewPoint.NUM = strNUM;
objnewPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID;
objnewPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID;
objnewPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID;
TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo();
objTaskCompany.TASK_ID = objTask.ID;;
objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTaskCompany);
TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID);
objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID;
new TBaseCompanyPointLogic().Create(objnewPoint);
objPoint.POINT_ID = objnewPoint.ID;
}
if (strPointID.Length > 0)
{
isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint);
}
else
{
isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint);
//增加点位样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.ID = GetSerialNumber("MonitorSampleId");
objSample.SUBTASK_ID = strSubtaskID;
objSample.QC_TYPE = "0";
objSample.NOSAMPLE = "0";
objSample.POINT_ID = objPoint.ID;
objSample.SAMPLE_NAME = objPoint.POINT_NAME;
string[] strSampleCode = new string[2] {
"S" + DateTime.Now.Year + DateTime.Now.Month, i3.View.PageBase.GetSerialNumber("monitor_samplecode")
};
objSample.SAMPLE_CODE = CreateSerialNumber(strSampleCode);
new TMisMonitorSampleInfoLogic().Create(objSample);
}
TBaseAttrbuteValue3Logic logicAttrValue = new TBaseAttrbuteValue3Logic();
//清掉原有动态属性值
TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo();
objAttrValueDelWhere.OBJECT_ID = objPoint.ID;
objAttrValueDelWhere.IS_DEL = "0";
TBaseAttrbuteValue3Vo objAttrValueDelSet = new TBaseAttrbuteValue3Vo();
objAttrValueDelSet.IS_DEL = "1";
logicAttrValue.Edit(objAttrValueDelSet, objAttrValueDelWhere);
//新增动态属性值
if (strAttribute.Length > 0)
{
string[] arrAttribute = strAttribute.Split('-');
for (int i = 0; i < arrAttribute.Length; i++)
{
string[] arrAttrValue = arrAttribute[i].Split('|');
TBaseAttrbuteValue3Vo objAttrValueAdd = new TBaseAttrbuteValue3Vo();
objAttrValueAdd.ID = GetSerialNumber("t_base_attribute_value3_id");
objAttrValueAdd.IS_DEL = "0";
objAttrValueAdd.OBJECT_TYPE = arrAttrValue[0];
objAttrValueAdd.OBJECT_ID = objPoint.ID;
objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1];
objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2];
isSuccess = logicAttrValue.Create(objAttrValueAdd);
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
if (this.hidPlanId.Value.Length == 0)
{
return;
}
TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(this.hidPlanId.Value);
string strContractID = objPlan.CONTRACT_ID;
TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskVo();
objTaskVo.PLAN_ID = hidPlanId.Value.Trim();
objTaskVo = new TMisMonitorTaskLogic().Details(objTaskVo);
TMisMonitorTaskCompanyVo objTaskCompanyVo = new TMisMonitorTaskCompanyLogic().Details(objTaskVo.TESTED_COMPANY_ID);
string strContractType = getDictName(objTaskVo.CONTRACT_TYPE, "Contract_Type");
string strMonitorNames = "";
string strPointNames = "";
string strItemS = "";
string strFREQ = "";
GetInfoForPrint(ref strMonitorNames, ref strPointNames, ref strFREQ, ref strItemS);
string strSAMPLE_ASK_DATE = DateTime.Now.ToString("yyyy-MM-dd");
string strSAMPLE_FINISH_DATE = DateTime.Parse(objTaskVo.ASKING_DATE).ToString("yyyy-MM-dd");
FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/MoniterTaskNotify.xls"), FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
sheet.GetRow(3).GetCell(3).SetCellValue("编号：" + objTaskVo.TICKET_NUM);
sheet.GetRow(4).GetCell(1).SetCellValue(strContractType);
sheet.GetRow(5).GetCell(1).SetCellValue(objTaskVo.PROJECT_NAME);
sheet.GetRow(3).GetCell(0).SetCellValue(objTaskVo.STATE == "01" ? "现场室：" : "分析室：");
sheet.GetRow(4).GetCell(3).SetCellValue(objTaskCompanyVo.COMPANY_NAME);
sheet.GetRow(5).GetCell(3).SetCellValue(objTaskCompanyVo.CONTACT_NAME + " " + objTaskCompanyVo.PHONE + " " + objTaskCompanyVo.CONTACT_ADDRESS);
sheet.GetRow(7).GetCell(0).SetCellValue(strMonitorNames);
sheet.GetRow(7).GetCell(1).SetCellValue(strPointNames);
sheet.GetRow(7).GetCell(2).SetCellValue(strFREQ);
sheet.GetRow(7).GetCell(3).SetCellValue(strItemS);
sheet.GetRow(8).GetCell(1).SetCellValue(strSAMPLE_ASK_DATE);
sheet.GetRow(8).GetCell(3).SetCellValue(strSAMPLE_FINISH_DATE);
//复制一份
sheet.GetRow(16).GetCell(3).SetCellValue("编号：" + objTaskVo.TICKET_NUM);
sheet.GetRow(17).GetCell(1).SetCellValue(strContractType);
sheet.GetRow(18).GetCell(1).SetCellValue(objTaskVo.PROJECT_NAME);
sheet.GetRow(16).GetCell(0).SetCellValue(objTaskVo.STATE == "01" ? "现场室：" : "分析室：");
sheet.GetRow(17).GetCell(3).SetCellValue(objTaskCompanyVo.COMPANY_NAME);
sheet.GetRow(18).GetCell(3).SetCellValue(objTaskCompanyVo.CONTACT_NAME + " " + objTaskCompanyVo.PHONE + " " + objTaskCompanyVo.CONTACT_ADDRESS);
sheet.GetRow(20).GetCell(0).SetCellValue(strMonitorNames);
sheet.GetRow(20).GetCell(1).SetCellValue(strPointNames);
sheet.GetRow(20).GetCell(2).SetCellValue(strFREQ);
sheet.GetRow(20).GetCell(3).SetCellValue(strItemS);
sheet.GetRow(21).GetCell(1).SetCellValue(strSAMPLE_ASK_DATE);
sheet.GetRow(21).GetCell(3).SetCellValue(strSAMPLE_FINISH_DATE);
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("任务通知单.xls", Encoding.UTF8));
curContext.Response.BinaryWrite(stream.GetBuffer());
curContext.Response.End();
}
}
/// <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);
}
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");
}
public static string SaveDataPoint(string strSubTaskID, string strPointName, string strMonitorID)
{
bool isSuccess = true;
TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo();
objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId");
objPoint.IS_DEL = "0";
objPoint.SUBTASK_ID = strSubTaskID;
objPoint.POINT_NAME = strPointName;
objPoint.MONITOR_ID = strMonitorID;
objPoint.FREQ = "1";
objPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
objPoint.TASK_ID = objTask.ID;
//监测任务出现新增排口时，基础资料企业表也要新增
TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo();
objnewPoint.ID = GetSerialNumber("t_base_company_point_id");
objnewPoint.IS_DEL = "0";
objnewPoint.POINT_NAME = strPointName;
objnewPoint.MONITOR_ID = strMonitorID;
objnewPoint.FREQ = "1";
objnewPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo();
//objTaskCompany.TASK_ID = objTask.ID; ;
objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID);
objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID;
isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint);
objPoint.POINT_ID = objnewPoint.ID;
isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint);
//增加点位样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.ID = GetSerialNumber("MonitorSampleId");
objSample.SUBTASK_ID = strSubTaskID;
objSample.QC_TYPE = "0";
objSample.NOSAMPLE = "0";
objSample.POINT_ID = objPoint.ID;
objSample.SAMPLE_NAME = objPoint.POINT_NAME;
isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample);
//为新增的测点添加监测项目
DataTable dt = new TMisMonitorSubtaskLogic().getItemBySubTaskID(strSubTaskID);
string strItemIDs = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
strItemIDs += dt.Rows[i]["ID"].ToString() + ",";
}
isSuccess = SaveDataItem(strSubTaskID, objSample.ID, strItemIDs.TrimEnd(','), true);
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获得委托书信息
/// </summary>
/// <returns>Json</returns>
protected string GetContractInfo()
{
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(this.SUBTASK_ID.Value);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
TMisMonitorTaskCompanyVo objConCompany = new TMisMonitorTaskCompanyVo();
//objConCompany.TASK_ID = objTask.ID;
objConCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
objSubtask.MONITOR_ID = getMonitorTypeName(objSubtask.MONITOR_ID);
objSubtask.SAMPLING_MANAGER_ID = base.LogInfo.UserInfo.REAL_NAME;// new TSysUserLogic().Details(objSubtask.SAMPLING_MANAGER_ID).REAL_NAME;
objSubtask.REMARK1 = objTask.TICKET_NUM;
objSubtask.REMARK2 = getDictName(objTask.CONTRACT_TYPE, "Contract_Type");
objSubtask.REMARK3 = objConCompany.COMPANY_NAME;
objSubtask.REMARK4 = objConCompany.CONTACT_NAME;
objSubtask.REMARK5 = objConCompany.PHONE;
TMisMonitorSampleInfoVo sampleVo = new TMisMonitorSampleInfoVo {
SUBTASK_ID = objSubtask.ID
};
sampleVo = new TMisMonitorSampleInfoLogic().Details(sampleVo);
IList <string> userList = new List <string>();
var userIdList = sampleVo.REMARK4.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (var userId in userIdList)
{
userList.Add(new TSysUserLogic().Details(userId).REAL_NAME);
}
objSubtask.SAMPLING_MAN = string.Join(",", userList);
//if (String.IsNullOrEmpty(objSubtask.SAMPLE_ASK_DATE))
//{
// objSubtask.SAMPLE_ASK_DATE = DateTime.Parse(objSubtask.SAMPLE_ASK_DATE).ToString("yyyy-MM-dd");
//}
//if (String.IsNullOrEmpty(objSubtask.SAMPLE_FINISH_DATE))
//{
// objSubtask.SAMPLE_FINISH_DATE = DateTime.Parse(objSubtask.SAMPLE_FINISH_DATE).ToString("yyyy-MM-dd");
//}
//获取退回意见信息
TMisReturnInfoVo ReturnInfoVo = new TMisReturnInfoVo();
ReturnInfoVo.TASK_ID = objSubtask.TASK_ID;
if (this.SUBTASK_ID.Value == Request.QueryString["strSourceID"].ToString())
{
ReturnInfoVo.SUBTASK_ID = this.SUBTASK_ID.Value;
ReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_005;
}
else
{
ReturnInfoVo.SUBTASK_ID = Request.QueryString["strSourceID"].ToString();
ReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_003;
}
ReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_002;
ReturnInfoVo = new TMisReturnInfoLogic().Details(ReturnInfoVo);
if (ReturnInfoVo.ID.Length > 0)
{
objSubtask.SAMPLING_METHOD = "退回意见：" + ReturnInfoVo.SUGGESTION;
}
return(ToJson(objSubtask));
}
