/// <summary>
/// 饼图绑定
/// </summary>
public void FillChart()
{
TMisMonitorTaskVo objItems = new TMisMonitorTaskVo();
objItems.REMARK3 = strYear;
objItems.REMARK4 = strMonth;
objItems.REMARK5 = strQuarter;
objItems.CONTRACT_CODE = strContractCode;
TMisMonitorTaskCompanyVo objComItems = new TMisMonitorTaskCompanyVo();
objComItems.AREA = strArea;
objComItems.COMPANY_NAME = strTestCompany;
dt = new TMisMonitorTaskLogic().GetTaskChartCountWithStatus(objItems, objComItems, strDept);
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dr["FINISHSUM"] = "0";
dr["FINISHTYPE"] = "无数据集";
dt.Rows.Add(dr);
dt.AcceptChanges();
}
ReportDataSource rds = new ReportDataSource("DataSet2", dt);
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
this.reportViewer2.LocalReport.DataSources.Add(rds);
this.reportViewer2.LocalReport.Refresh();
}
private string InsertContractCompanyInfo(string strReqTaskId, string strReqCompanyId)
{
string result = "";
DataTable dt = new DataTable();
TMisMonitorTaskCompanyVo objTmc = new TMisMonitorTaskCompanyVo();
//Update By SSZ 将基础资料企业信息复制到委托书企业信息
//基础企业资料信息
TBaseCompanyInfoVo objCompanyInfo = new TBaseCompanyInfoLogic().Details(strReqCompanyId);
//将相同字段的数据进行复制
CopyObject(objCompanyInfo, objTmc);
objTmc.TASK_ID = strReqTaskId;
objTmc.COMPANY_ID = strReqCompanyId;
objTmc.IS_DEL = "0";
objTmc.ID = i3.View.PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId");
if (new TMisMonitorTaskCompanyLogic().Create(objTmc))
{
result = objTmc.ID.ToString();
string strMessage = LogInfo.UserInfo.USER_NAME + "添加任务企业" + objTmc.ID + "成功";
//WriteLog(i3.ValueObject.ObjectBase.LogType.AddContractCompanyInfo, "", strMessage);
}
return(result);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisMonitorTaskCompany">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, int iIndex, int iCount)
{
string strSQL = " select * from T_MIS_MONITOR_TASK_COMPANY {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorTaskCompany));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorTaskCompany_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisMonitorTaskCompany_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany_UpdateSet, TMisMonitorTaskCompanyVo tMisMonitorTaskCompany_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorTaskCompany_UpdateSet, TMisMonitorTaskCompanyVo.T_MIS_MONITOR_TASK_COMPANY_TABLE);
strSQL += this.BuildWhereStatement(tMisMonitorTaskCompany_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <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));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorTaskCompany">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorTaskCompany, TMisMonitorTaskCompanyVo.T_MIS_MONITOR_TASK_COMPANY_TABLE);
strSQL += string.Format(" where ID='{0}' ", tMisMonitorTaskCompany.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
string strSQL = "delete from T_MIS_MONITOR_TASK_COMPANY ";
strSQL += this.BuildWhereStatement(tMisMonitorTaskCompany);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
protected void btnImport_Click(object sender, EventArgs e)
{
FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/QcSheet.xls"), FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
string strTaskType = "";
//DataTable dt = GetPendingPlanDataTable();
//if (dt.Rows.Count > 0)
//{
// sheet.GetRow(2).GetCell(5).SetCellValue(dt.Rows[0]["TICKET_NUM"].ToString());
// sheet.GetRow(4).GetCell(1).SetCellValue(dt.Rows[0]["COMPANY_NAME"].ToString());
// strTaskType = getDictName(dt.Rows[0]["CONTRACT_TYPE"].ToString(), "Contract_Type");
// sheet.GetRow(4).GetCell(5).SetCellValue(strTaskType);
// sheet.GetRow(5).GetCell(1).SetCellValue(dt.Rows[0]["PROJECT_NAME"].ToString());
// sheet.GetRow(6).GetCell(1).SetCellValue(strTaskType + "表");
// sheet.GetRow(6).GetCell(5).SetCellValue(dt.Rows[0]["COMPANY_NAME"].ToString());
// sheet.GetRow(8).GetCell(0).SetCellValue(dt.Rows[0]["QC_STEP"].ToString());
//}
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
TMisMonitorTaskCompanyVo objCompany = new TMisMonitorTaskCompanyVo();
int isOk = 0;
getPrintQcInfo_pan(ref objTask, ref objCompany, ref isOk);
if (isOk == 1)
{
sheet.GetRow(2).GetCell(5).SetCellValue(objTask.TICKET_NUM);
sheet.GetRow(4).GetCell(1).SetCellValue(objCompany.COMPANY_NAME);
strTaskType = getDictName(objTask.CONTRACT_TYPE, "Contract_Type");
sheet.GetRow(4).GetCell(5).SetCellValue(strTaskType);
sheet.GetRow(5).GetCell(1).SetCellValue(objTask.PROJECT_NAME);
if (objTask.CONTRACT_TYPE == "02" || objTask.CONTRACT_TYPE == "03")
{
sheet.GetRow(6).GetCell(1).SetCellValue("监测表");
}
else
{
sheet.GetRow(6).GetCell(1).SetCellValue("监测报告");
}
sheet.GetRow(6).GetCell(5).SetCellValue(objCompany.COMPANY_NAME);
sheet.GetRow(8).GetCell(0).SetCellValue(objTask.REMARK1);
}
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 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
}
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);
}
/// <summary>
/// 获取已完成的预约任务
/// </summary>
public void GetFinishedPlan()
{
dt = new DataTable();
TMisMonitorTaskVo objItems = new TMisMonitorTaskVo();
objItems.TASK_STATUS = "11";
objItems.REMARK3 = strYear;
objItems.REMARK4 = strMonth;
objItems.REMARK5 = strQuarter;
objItems.CONTRACT_CODE = strContractCode;
TMisMonitorTaskCompanyVo objComItems = new TMisMonitorTaskCompanyVo();
objComItems.AREA = strArea;
objComItems.COMPANY_NAME = strTestCompany;
dt = new TMisMonitorTaskLogic().GetTaskFinishedChart(objItems, objComItems, strDept, true);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tMisMonitorTaskCompany">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
string strSQL = SqlHelper.BuildInsertExpress(tMisMonitorTaskCompany, TMisMonitorTaskCompanyVo.T_MIS_MONITOR_TASK_COMPANY_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <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="tMisMonitorTaskCompany"></param>
/// <returns></returns>
public string BuildWhereStatement(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tMisMonitorTaskCompany)
{
//ID
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisMonitorTaskCompany.ID.ToString()));
}
//任务ID
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.TASK_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND TASK_ID = '{0}'", tMisMonitorTaskCompany.TASK_ID.ToString()));
}
//委托书企业ID
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_ID = '{0}'", tMisMonitorTaskCompany.COMPANY_ID.ToString()));
}
//企业法人代码
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_CODE = '{0}'", tMisMonitorTaskCompany.COMPANY_CODE.ToString()));
}
//企业名称
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_NAME = '{0}'", tMisMonitorTaskCompany.COMPANY_NAME.ToString()));
}
//拼音编码
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.PINYIN.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PINYIN = '{0}'", tMisMonitorTaskCompany.PINYIN.ToString()));
}
//主管部门
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.DIRECTOR_DEPT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DIRECTOR_DEPT = '{0}'", tMisMonitorTaskCompany.DIRECTOR_DEPT.ToString()));
}
//经济类型
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ECONOMY_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ECONOMY_TYPE = '{0}'", tMisMonitorTaskCompany.ECONOMY_TYPE.ToString()));
}
//所在区域
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.AREA.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND AREA = '{0}'", tMisMonitorTaskCompany.AREA.ToString()));
}
//企业规模
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.SIZE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SIZE = '{0}'", tMisMonitorTaskCompany.SIZE.ToString()));
}
//污染源类型
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.POLLUTE_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POLLUTE_TYPE = '{0}'", tMisMonitorTaskCompany.POLLUTE_TYPE.ToString()));
}
//行业类别
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.INDUSTRY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND INDUSTRY = '{0}'", tMisMonitorTaskCompany.INDUSTRY.ToString()));
}
//废气控制级别
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.GAS_LEAVEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND GAS_LEAVEL = '{0}'", tMisMonitorTaskCompany.GAS_LEAVEL.ToString()));
}
//废水控制级别
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WATER_LEAVEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WATER_LEAVEL = '{0}'", tMisMonitorTaskCompany.WATER_LEAVEL.ToString()));
}
//开业时间
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.PRACTICE_DATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PRACTICE_DATE = '{0}'", tMisMonitorTaskCompany.PRACTICE_DATE.ToString()));
}
//联系人
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CONTACT_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTACT_NAME = '{0}'", tMisMonitorTaskCompany.CONTACT_NAME.ToString()));
}
//联系部门
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LINK_DEPT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LINK_DEPT = '{0}'", tMisMonitorTaskCompany.LINK_DEPT.ToString()));
}
//电子邮件
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.EMAIL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND EMAIL = '{0}'", tMisMonitorTaskCompany.EMAIL.ToString()));
}
//联系电话
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LINK_PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LINK_PHONE = '{0}'", tMisMonitorTaskCompany.LINK_PHONE.ToString()));
}
//委托代理人
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.FACTOR.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FACTOR = '{0}'", tMisMonitorTaskCompany.FACTOR.ToString()));
}
//办公电话
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PHONE = '{0}'", tMisMonitorTaskCompany.PHONE.ToString()));
}
//移动电话
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MOBAIL_PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MOBAIL_PHONE = '{0}'", tMisMonitorTaskCompany.MOBAIL_PHONE.ToString()));
}
//传真号码
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.FAX.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FAX = '{0}'", tMisMonitorTaskCompany.FAX.ToString()));
}
//邮政编码
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.POST.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POST = '{0}'", tMisMonitorTaskCompany.POST.ToString()));
}
//联系地址
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CONTACT_ADDRESS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTACT_ADDRESS = '{0}'", tMisMonitorTaskCompany.CONTACT_ADDRESS.ToString()));
}
//监测地址
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MONITOR_ADDRESS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MONITOR_ADDRESS = '{0}'", tMisMonitorTaskCompany.MONITOR_ADDRESS.ToString()));
}
//企业网址
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WEB_SITE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WEB_SITE = '{0}'", tMisMonitorTaskCompany.WEB_SITE.ToString()));
}
//经度
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LONGITUDE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LONGITUDE = '{0}'", tMisMonitorTaskCompany.LONGITUDE.ToString()));
}
//纬度
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.LATITUDE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LATITUDE = '{0}'", tMisMonitorTaskCompany.LATITUDE.ToString()));
}
//使用状态(0为启用、1为停用)
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.IS_DEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tMisMonitorTaskCompany.IS_DEL.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisMonitorTaskCompany.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisMonitorTaskCompany.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisMonitorTaskCompany.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tMisMonitorTaskCompany.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tMisMonitorTaskCompany.REMARK5.ToString()));
}
//企业级别
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_LEVEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_LEVEL = '{0}'", tMisMonitorTaskCompany.COMPANY_LEVEL.ToString()));
}
//法人代表
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.COMPANY_MAN.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_MAN = '{0}'", tMisMonitorTaskCompany.COMPANY_MAN.ToString()));
}
//废水最终排放去向
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WATER_FOLLOW.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WATER_FOLLOW = '{0}'", tMisMonitorTaskCompany.WATER_FOLLOW.ToString()));
}
//现有工程环评批复时间及文号
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CHECK_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CHECK_TIME = '{0}'", tMisMonitorTaskCompany.CHECK_TIME.ToString()));
}
//现有工程竣工环境保护验收时间
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ACCEPTANCE_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ACCEPTANCE_TIME = '{0}'", tMisMonitorTaskCompany.ACCEPTANCE_TIME.ToString()));
}
//执行标准
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.STANDARD.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND STANDARD = '{0}'", tMisMonitorTaskCompany.STANDARD.ToString()));
}
//主要环保设施名称、数量
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MAIN_APPARATUS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MAIN_APPARATUS = '{0}'", tMisMonitorTaskCompany.MAIN_APPARATUS.ToString()));
}
//环保设施运行情况
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.APPARATUS_STATUS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND APPARATUS_STATUS = '{0}'", tMisMonitorTaskCompany.APPARATUS_STATUS.ToString()));
}
//主要产品名称
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MAIN_PROJECT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MAIN_PROJECT = '{0}'", tMisMonitorTaskCompany.MAIN_PROJECT.ToString()));
}
//主要生产原料
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.MAIN_GOOD.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MAIN_GOOD = '{0}'", tMisMonitorTaskCompany.MAIN_GOOD.ToString()));
}
//设计生产能力
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.DESIGN_ANBILITY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DESIGN_ANBILITY = '{0}'", tMisMonitorTaskCompany.DESIGN_ANBILITY.ToString()));
}
//实际生产能力
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.ANBILITY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ANBILITY = '{0}'", tMisMonitorTaskCompany.ANBILITY.ToString()));
}
//监测期间生产负荷（%）
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.CONTRACT_PER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTRACT_PER = '{0}'", tMisMonitorTaskCompany.CONTRACT_PER.ToString()));
}
//全年平均生产负荷（%）
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.AVG_PER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND AVG_PER = '{0}'", tMisMonitorTaskCompany.AVG_PER.ToString()));
}
//废水排放量
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.WATER_COUNT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WATER_COUNT = '{0}'", tMisMonitorTaskCompany.WATER_COUNT.ToString()));
}
//年运行时间
if (!String.IsNullOrEmpty(tMisMonitorTaskCompany.YEAR_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND YEAR_TIME = '{0}'", tMisMonitorTaskCompany.YEAR_TIME.ToString()));
}
}
return(strWhereStatement.ToString());
}
public static string SaveItemSplit(string strSampleID, string strPointName, string strResultItems, string strItems, string strMonitorID, string strSubTaskID)
{
bool isSuccess = true;
TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo();
objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId");
objPoint.IS_DEL = "0";
objPoint.SUBTASK_ID = strSubTaskID;
objPoint.POINT_NAME = strPointName;
objPoint.MONITOR_ID = strMonitorID;
objPoint.FREQ = "1";
objPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorSampleInfoVo objSampleVo = new TMisMonitorSampleInfoLogic().Details(strSampleID);
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
objPoint.TASK_ID = objTask.ID;
//监测任务出现新增排口时，基础资料企业表也要新增
TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo();
objnewPoint.ID = GetSerialNumber("t_base_company_point_id");
objnewPoint.IS_DEL = "0";
objnewPoint.POINT_NAME = strPointName;
objnewPoint.MONITOR_ID = strMonitorID;
objnewPoint.FREQ = "1";
objnewPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo();
objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID);
objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID;
isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint);
objPoint.POINT_ID = objnewPoint.ID;
isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint);
//增加点位样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.ID = GetSerialNumber("MonitorSampleId");
objSample.SUBTASK_ID = strSubTaskID;
objSample.QC_TYPE = "0";
objSample.NOSAMPLE = "0";
objSample.POINT_ID = objPoint.ID;
objSample.SAMPLE_NAME = objPoint.POINT_NAME;
//新增点位时候，自动生成该点位的样品编码
TBaseSerialruleVo objSerial = new TBaseSerialruleVo();
objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE;
objSerial.SERIAL_TYPE = "2";
objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd");
objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask);
isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample);
isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_RESULT", "SAMPLE_ID='" + objSample.ID + "'", "ID in(" + strResultItems.TrimEnd(',') + ")");
isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_TASK_ITEM", "TASK_POINT_ID='" + objPoint.ID + "'", "TASK_POINT_ID='" + objSampleVo.POINT_ID + "' AND ITEM_ID in(" + strItems.TrimEnd(',') + ")");
return(isSuccess ? "true" : "false");
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisMonitorTaskCompany">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
string strSQL = "select Count(*) from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <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>
/// 获取对象List
/// </summary>
/// <param name="tMisMonitorTaskCompany">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisMonitorTaskCompanyVo> SelectByObject(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany));
return(SqlHelper.ExecuteObjectList(tMisMonitorTaskCompany, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisMonitorTaskCompany"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
string strSQL = "select * from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 根据完成状态 获取监测任务完成、未完成、总和
/// </summary>
/// <param name="tMisMonitorTask"></param>
/// <returns></returns>
public DataTable GetTaskChartCountWithStatus(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, string Dept)
{
return(access.GetTaskChartCountWithStatus(tMisMonitorTask, tMisMonitorTaskCompany, Dept));
}
/// <summary>
/// 获取监测任务办理情况统计列表 饼图 Create By 胡方扬 2013-01-02
/// </summary>
/// <param name="tMisMonitorTask"></param>
/// <returns></returns>
public DataTable GetTaskFinishedChart(TMisMonitorTaskVo tMisMonitorTask, TMisMonitorTaskCompanyVo tMisMonitorTaskCompany, string Dept, bool isFinished)
{
return(access.GetTaskFinishedChart(tMisMonitorTask, tMisMonitorTaskCompany, Dept, isFinished));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisMonitorTaskCompany"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
return(access.SelectByTable(tMisMonitorTaskCompany));
}
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");
}
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisMonitorTaskCompany">对象条件</param>
/// <returns>对象</returns>
public TMisMonitorTaskCompanyVo Details(TMisMonitorTaskCompanyVo tMisMonitorTaskCompany)
{
string strSQL = String.Format("select * from T_MIS_MONITOR_TASK_COMPANY " + this.BuildWhereStatement(tMisMonitorTaskCompany));
return(SqlHelper.ExecuteObject(new TMisMonitorTaskCompanyVo(), strSQL));
}
/// <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));
}
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");
}
}
