/// <summary>
/// 发送到下一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string SendToNext(string strTaskId)
{
bool IsSuccess = true;
DataTable dt = new TMisMonitorResultLogic().getItemTypeInfo(LogInfo.UserInfo.ID, "sample_delivery", strTaskId, "021", "01");
for (int i = 0; i < dt.Rows.Count; i++)
{
string strMonitorID = dt.Rows[i]["MONITOR_ID"].ToString();
TMisMonitorSubtaskVo objSsubtask = new TMisMonitorSubtaskVo();
objSsubtask.TASK_ID = strTaskId;
objSsubtask.MONITOR_ID = strMonitorID;
objSsubtask = new TMisMonitorSubtaskLogic().Details(objSsubtask);
objSsubtask.SAMPLE_ACCESS_ID = LogInfo.UserInfo.ID;
objSsubtask.SAMPLE_ACCESS_DATE = DateTime.Now.ToString();
objSsubtask.TASK_STATUS = "03";
if (!new TMisMonitorSubtaskLogic().Edit(objSsubtask))
{
IsSuccess = false;
}
}
if (IsSuccess)
{
//如果配置文件的IsToDelivery=0，则直接跳过分析任务分配环节，到监测分析环节
if (ConfigurationManager.AppSettings["IsToDelivery"].ToString() != "1")
{
new TMisMonitorResultLogic().sendToAnalysis(strTaskId, "03", "01", "20");
}
}
return(IsSuccess == true ? "1" : "0");
}
/// <summary>
/// 发送到下一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string SendToNext(string strTaskId)
{
bool IsSuccess = true;
//把样品从交接发送到分配环节
DataTable dtSample = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet_QHD(strTaskId, "", "021,02");
for (int i = 0; i < dtSample.Rows.Count; i++)
{
TMisMonitorSampleInfoVo objSampleVo = new TMisMonitorSampleInfoVo();
objSampleVo.ID = dtSample.Rows[i]["ID"].ToString();
objSampleVo.NOSAMPLE = "2";
IsSuccess = new TMisMonitorSampleInfoLogic().Edit(objSampleVo);
}
//如果子任务的样品都采样完，刚更新子任务的状态
DataTable dt = new TMisMonitorResultLogic().getItemTypeInfo_QHD(strTaskId, "021", "01", "2", true);
for (int i = 0; i < dt.Rows.Count; i++)
{
string strMonitorID = dt.Rows[i]["MONITOR_ID"].ToString();
TMisMonitorSubtaskVo objSsubtask = new TMisMonitorSubtaskVo();
objSsubtask.TASK_ID = strTaskId;
objSsubtask.MONITOR_ID = strMonitorID;
objSsubtask = new TMisMonitorSubtaskLogic().Details(objSsubtask);
objSsubtask.SAMPLE_ACCESS_ID = LogInfo.UserInfo.ID;
objSsubtask.TASK_STATUS = "03";
if (!new TMisMonitorSubtaskLogic().Edit(objSsubtask))
{
IsSuccess = false;
}
}
return(IsSuccess == true ? "1" : "0");
}
/// <summary>
/// 获取样品信息
/// </summary>
/// <returns></returns>
private string getSampleGridInfo(string strTaskID, string strSubTaskID)
{
//huangjinjun add 2016.1.26 如果REMARK3等于true，将ph值、电导率、溶解氧设为分析项目
TMisMonitorTaskVo tm = new TMisMonitorTaskVo();
TMisMonitorSubtaskVo tmsub = new TMisMonitorSubtaskVo();
tmsub = new TMisMonitorSubtaskLogic().Details(strSubTaskID);
tm.ID = tmsub.TASK_ID;
DataTable dtRemark = new TMisMonitorTaskLogic().SelectByTable(tm);
if (dtRemark.Rows[0]["REMARK3"].ToString() == "true")
{
bool bl = new TBaseItemInfoLogic().EditItemTypeFX();
}
else
{
bool bl = new TBaseItemInfoLogic().EditItemTypeXC();
}
var strCCflowWorkId = Request.QueryString["strCCflowWorkId"];
var identification = CCFlowFacade.GetFlowIdentification(LogInfo.UserInfo.USER_NAME, Convert.ToInt64(strCCflowWorkId));
var sampleIdList = identification.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries).ToList();
if (sampleIdList.Count > 0)
{
sampleIdList.RemoveAt(0);
}
if (sampleIdList.Count == 0)
{
DataTable dt = new TMisMonitorResultLogic().getSampleCodeInAlloction_MAS(strTaskID, strSubTaskID);
string strJson = CreateToJson(dt, 0);
return(strJson);
}
else
{
DataTable dt = new TMisMonitorResultLogic().getSampleCodeInAlloction_MAS(strTaskID, strSubTaskID);
var newDT = new DataTable();
foreach (DataColumn column in dt.Columns)
{
newDT.Columns.Add(column.ColumnName);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!sampleIdList.Contains(dt.Rows[i]["ID"].ToString()))
{
continue;
}
newDT.Rows.Add(dt.Rows[i].ItemArray);
}
string strJson = CreateToJson(newDT, 0);
return(strJson);
}
}
/// <summary>
/// 获得委托书信息
/// </summary>
/// <returns>Json</returns>
protected string GetContractInfo()
{
if (this.PLAN_ID.Value.Length == 0)
{
return("");
}
TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(this.PLAN_ID.Value);
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.PLAN_ID = this.PLAN_ID.Value;
objTask = new TMisMonitorTaskLogic().Details(objTask);
//如果是验收监测
if (objTask.CONTRACT_TYPE == "05")
{
//获取方案编制人信息
string strProjectId = objTask.PROJECT_ID;
//将方案编制人信息写入监测子任务表中
TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVo.TASK_ID = objTask.ID;
DataTable objTable = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo);
foreach (DataRow row in objTable.Rows)
{
string strSubTaskId = row["ID"].ToString();
TMisMonitorSubtaskVo TMisMonitorSubtaskVoTemp = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVoTemp.ID = strSubTaskId;
TMisMonitorSubtaskVoTemp.SAMPLING_MANAGER_ID = strProjectId;
new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVoTemp);
}
}
objTask.TESTED_COMPANY_ID = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID).COMPANY_NAME;
objTask.CONTRACT_TYPE = new TSysDictLogic().GetDictNameByDictCodeAndType(objTask.CONTRACT_TYPE, "Contract_Type");
return(ToJson(objTask));
}
/// <summary>
/// 获取监测子任务列表信息
/// </summary>
/// <returns></returns>
protected void selectsubTask()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
//构造查询对象
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskLogic objSubTaskLogic = new TMisMonitorSubtaskLogic();
if (strSortname == null || strSortname.Length == 0)
{
strSortname = TMisMonitorSubtaskVo.ID_FIELD;
}
objSubTask.SORT_FIELD = strSortname;
objSubTask.SORT_TYPE = strSortorder;
objSubTask.TASK_ID = !string.IsNullOrEmpty(Request.QueryString["task_id"]) ? Request.QueryString["task_id"].ToString() : "";
string strJson = "";
//int intTotalCount = objSubTaskLogic.GetSelectResultCount(objSubTask);//总计的数据条数
DataTable dt = objSubTaskLogic.SelectByTable(objSubTask, 0, 0);
DataTable dtRe = doWithSubtaskData(dt);
strJson = CreateToJson(dtRe, dtRe.Rows.Count);
Response.Write(strJson);
Response.End();
}
/// <summary>
/// 将任务发送至下一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string SendToNext(string strOneGridId)
{
string strSubTaskID = Request["strSubTaskID"].ToString();
string strUserID = Request["strUserID"].ToString();
int SuccessCount = 0;
DataTable dt = new TMisMonitorSubtaskLogic().SelectSampleSubTaskForQY(strSubTaskID, strOneGridId, "022", "sample_result_check");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo();
objSubtaskVo.ID = dt.Rows[i]["ID"].ToString();
objSubtaskVo.TASK_STATUS = "023";
objSubtaskVo.TASK_TYPE = "发送";
if (new TMisMonitorSubtaskLogic().Edit(objSubtaskVo))
{
SuccessCount++;
}
TMisMonitorSubtaskAppVo objSubAppSet = new TMisMonitorSubtaskAppVo();
objSubAppSet.REMARK2 = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); //复核时间
objSubAppSet.SAMPLING_QC_CHECK = strUserID;
TMisMonitorSubtaskAppVo objSubAppWhere = new TMisMonitorSubtaskAppVo();
objSubAppWhere.SUBTASK_ID = dt.Rows[i]["ID"].ToString();
new TMisMonitorSubtaskAppLogic().Edit(objSubAppSet, objSubAppWhere);
}
}
return(SuccessCount > 0 ? "1" : "0");
}
public static string GoToBack(string strTaskId)
{
TMisMonitorTaskVo TMisMonitorTaskVo = new TMisMonitorTaskVo();
TMisMonitorTaskVo.ID = strTaskId;
TMisMonitorTaskVo.QC_STATUS = "NULL";
bool IsTaskEditSuccess = new TMisMonitorTaskLogic().Edit(TMisMonitorTaskVo);
TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVo.TASK_ID = strTaskId;
TMisMonitorSubtaskVo.TASK_STATUS = "04";
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo);
bool IsSubTaskEditSuccess = true;
foreach (DataRow row in dt.Rows)
{
string strSubTaskId = row["ID"].ToString();
TMisMonitorSubtaskVo TMisMonitorSubtaskVoTemp = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVoTemp.ID = strSubTaskId;
TMisMonitorSubtaskVoTemp.TASK_STATUS = "01";
IsSubTaskEditSuccess = new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVoTemp);
}
return IsTaskEditSuccess && IsSubTaskEditSuccess == true ? "1" : "0";
}
/// <summary>
/// 修改项目复制人
/// </summary>
/// <param name="strPlanId"></param>
private void ModifTaskSampleDutyUser(string strPlanId)
{
if (!String.IsNullOrEmpty(strPlanId))
{
TMisMonitorTaskVo objTaskDetail = new TMisMonitorTaskLogic().Details(new TMisMonitorTaskVo {
PLAN_ID = strPlanId
});
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo();
objSubTask.TASK_ID = objTaskDetail.ID;
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask, 0, 0);
TMisContractUserdutyVo objUserDuty = new TMisContractUserdutyVo();
objUserDuty.CONTRACT_PLAN_ID = strPlanId;
DataTable dtDuty = new TMisContractUserdutyLogic().SelectByTable(objUserDuty, 0, 0);
if (dt.Rows.Count > 0 && dtDuty.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
foreach (DataRow drr in dtDuty.Rows)
{
if (dr["MONITOR_ID"].ToString() == drr["MONITOR_TYPE_ID"].ToString())
{
TMisMonitorSubtaskVo objUpSubTask = new TMisMonitorSubtaskVo();
objUpSubTask.ID = dr["ID"].ToString();
objUpSubTask.SAMPLING_MANAGER_ID = drr["SAMPLING_MANAGER_ID"].ToString();
new TMisMonitorSubtaskLogic().Edit(objUpSubTask);
}
}
}
}
}
}
/// <summary>
/// 任务退回
/// </summary>
/// <param name="strTaskId">任务Id</param>
/// <returns></returns>
private string GoToBack(string strTaskId, string strSubTaskId, string strSuggestion)
{
bool isSuccess = false;
TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo();
objSubtaskVo.ID = strSubTaskId;
objSubtaskVo.TASK_STATUS = "02";
objSubtaskVo.TASK_TYPE = "退回";
isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo);
TMisReturnInfoVo objReturnInfoVo = new TMisReturnInfoVo();
objReturnInfoVo.TASK_ID = strTaskId;
objReturnInfoVo.SUBTASK_ID = strSubTaskId;
objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_005;
objReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_002;
TMisReturnInfoVo obj = new TMisReturnInfoLogic().Details(objReturnInfoVo);
if (obj.ID.Length > 0)
{
objReturnInfoVo.ID = obj.ID;
objReturnInfoVo.SUGGESTION = strSuggestion;
isSuccess = new TMisReturnInfoLogic().Edit(objReturnInfoVo);
}
else
{
objReturnInfoVo.ID = GetSerialNumber("t_mis_return_id");
objReturnInfoVo.SUGGESTION = strSuggestion;
isSuccess = new TMisReturnInfoLogic().Create(objReturnInfoVo);
}
return(isSuccess == true ? "1" : "0");
}
private void GetInfoForPrint(ref string strMonitorNames, ref string strPointNames, ref string strFREQ, ref string strItemS)
{
if (this.hidPlanId.Value.Length == 0)
{
return;
}
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.PLAN_ID = this.hidPlanId.Value;
objTask = new TMisMonitorTaskLogic().Details(objTask);
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
objSubtask.TASK_ID = objTask.ID;
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubtask, 0, 0);
for (int i = 0; i < dt.Rows.Count; i++)
{
TBaseMonitorTypeInfoVo objMonitorTypeInfoVo = new TBaseMonitorTypeInfoLogic().Details(dt.Rows[i]["MONITOR_ID"].ToString());
strMonitorNames += objMonitorTypeInfoVo.MONITOR_TYPE_NAME + "\n";
GetPoint_UnderTask(objTask.CONTACT_ID, dt.Rows[i]["ID"].ToString(), ref strPointNames, ref strFREQ, ref strItemS);
}
}
public string SaveUserInfo()
{
bool isSuccess = true;
string strSamplingMan = "";
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
if (this.strTaskId.Value.Trim() == "")
{
objSubtask.ID = this.strSubTaskId.Value;
objSubtask.SAMPLING_ID = Request["txtDefaultUserId"];
for (int i = 0; i < objSubtask.SAMPLING_ID.Split(',').Length; i++)
{
TSysUserVo objUser = new TSysUserLogic().Details(objSubtask.SAMPLING_ID.Split(',')[i]);
strSamplingMan += (strSamplingMan.Length > 0) ? "," + objUser.REAL_NAME : objUser.REAL_NAME;
}
objSubtask.SAMPLING_MAN = strSamplingMan;
isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask);
}
else
{
//在采样分配环节批量修改协同人 add by weilin
objSubtask.SAMPLING_ID = Request["txtDefaultUserId"];
for (int i = 0; i < objSubtask.SAMPLING_ID.Split(',').Length; i++)
{
TSysUserVo objUser = new TSysUserLogic().Details(objSubtask.SAMPLING_ID.Split(',')[i]);
strSamplingMan += (strSamplingMan.Length > 0) ? "," + objUser.REAL_NAME : objUser.REAL_NAME;
}
objSubtask.SAMPLING_MAN = strSamplingMan;
TMisMonitorSubtaskVo objWhere = new TMisMonitorSubtaskVo();
objWhere.TASK_ID = this.strTaskId.Value.Trim();
objWhere.TASK_STATUS = "01";
isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask, objWhere);
}
return isSuccess == true ? "1" : "0";
}
/// <summary>
/// 采样任务列表信息
/// </summary>
/// <returns>Json</returns>
protected string getSampleTask()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
//objSubtask.SORT_FIELD = "SAMPLE_ASK_DATE";
//DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0);
//DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithAllTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0);
//int intTotalCount = dt.Rows.Count;
//string strJson = CreateToJson(dt, intTotalCount);
objSubtask.SORT_FIELD = "CREATE_DATE";
objSubtask.SORT_TYPE = "desc";
DataTable dtTreeRoot = new TMisMonitorSubtaskLogic().SelectByTableWithAllTaskForFatherTree(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0);
objSubtask.SORT_FIELD = "TASK_ID";
objSubtask.SORT_TYPE = "asc";
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithAllTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0);
int RecordCount = dtTreeRoot.Rows.Count + dt.Rows.Count;
string strJson = LigerGridTreeDataToJson(dtTreeRoot, dt, "TASK_ID", RecordCount);
return(strJson);
}
/// <summary>
/// 发送到下一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string SendToNext(string strSampleAskDate, string strSampleFinishDate)
{
bool IsSuccess = true;
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.PLAN_ID = this.PLAN_ID.Value;
objTask = new TMisMonitorTaskLogic().Details(objTask);
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo();
objSubTask.TASK_ID = objTask.ID;
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask);
for (int i = 0; i < dt.Rows.Count; i++)
{
objSubTask.ID = dt.Rows[i]["ID"].ToString();
objSubTask.TASK_STATUS = "02";
objSubTask.SAMPLE_ASK_DATE = strSampleAskDate;
objSubTask.SAMPLE_FINISH_DATE = strSampleFinishDate;
if (!new TMisMonitorSubtaskLogic().Edit(objSubTask))
{
IsSuccess = false;
}
TMisMonitorSubtaskAppVo objSubApp = new TMisMonitorSubtaskAppVo();
DataTable dtApp = new TMisMonitorSubtaskAppLogic().SelectByTable(new TMisMonitorSubtaskAppVo {
SUBTASK_ID = dt.Rows[i]["ID"].ToString()
});
if (dtApp.Rows.Count > 0)
{
objSubApp.ID = dtApp.Rows[0]["ID"].ToString();
objSubApp.SUBTASK_ID = dt.Rows[i]["ID"].ToString();
objSubApp.QC_APP_USER_ID = new PageBase().LogInfo.UserInfo.ID;
objSubApp.QC_APP_DATE = DateTime.Now.ToString();
new TMisMonitorSubtaskAppLogic().Edit(objSubApp);
}
else
{
objSubApp.ID = GetSerialNumber("TMisMonitorSubtaskAppID");
objSubApp.SUBTASK_ID = dt.Rows[i]["ID"].ToString();
objSubApp.QC_APP_USER_ID = new PageBase().LogInfo.UserInfo.ID;
objSubApp.QC_APP_DATE = DateTime.Now.ToString();
new TMisMonitorSubtaskAppLogic().Create(objSubApp);
}
}
if (IsSuccess)
{
TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(this.PLAN_ID.Value);
objPlan.HAS_DONE = "1";
new TMisContractPlanLogic().Edit(objPlan);
}
return(IsSuccess == true ? "1" : "0");
}
//发送到下一环节
private string SendToNext(string strTaskId)
{
TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVo.TASK_ID = strTaskId;
TMisMonitorSubtaskVo.TASK_STATUS = "023";
DataTable objTable = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo);
#region 审核人修改
foreach (DataRow row in objTable.Rows)
{
string strId = row["ID"].ToString();
//根据子任务ＩＤ获取监测子任务审核表ID
i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo TMisMonitorSubtaskAppVoTemp = new i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo();
TMisMonitorSubtaskAppVoTemp.SUBTASK_ID = strId;
string strSubTaskAppId = new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppLogic().Details(TMisMonitorSubtaskAppVoTemp).ID;
i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo TMisMonitorSubtaskAppVo = new i3.ValueObject.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppVo();
TMisMonitorSubtaskAppVo.ID = strSubTaskAppId;
TMisMonitorSubtaskAppVo.SAMPLING_QC_CHECK = LogInfo.UserInfo.ID;
new i3.BusinessLogic.Channels.Mis.Monitor.SubTask.TMisMonitorSubtaskAppLogic().Edit(TMisMonitorSubtaskAppVo);
}
#endregion
//bool IsSuccess = new TMisMonitorResultLogic().TaskGoBackInSampleResultQcCheck(strTaskId, "023", "24");
bool IsSuccess = new TMisMonitorResultLogic().SetSampleResultStatus(strTaskId, "023", "50");
if (IsSuccess == true)
{
new TMisMonitorResultLogic().TaskGoBackInSampleResultQcCheck(strTaskId, "023", "03");
}
#region 注释
//if (IsSuccess == true)
//{
// if (new TMisMonitorResultLogic().allTaskIsFinish_ZZ(strTaskId, "24", "50"))
// {
// i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo TMisMonitorTaskVo = new i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo();
// TMisMonitorTaskVo.ID = strTaskId;
// TMisMonitorTaskVo.TASK_STATUS = "09";
// new i3.BusinessLogic.Channels.Mis.Monitor.Task.TMisMonitorTaskLogic().Edit(TMisMonitorTaskVo);
// i3.ValueObject.Channels.Mis.Monitor.Task.TMisMonitorTaskVo TMisMonitorTaskVoTemp = new i3.BusinessLogic.Channels.Mis.Monitor.Task.TMisMonitorTaskLogic().Details(strTaskId);
// if (TMisMonitorTaskVoTemp.CONTRACT_TYPE == "05")
// {
// //根据任务ID获取项目负责人
// string strProjectId = TMisMonitorTaskVoTemp.PROJECT_ID;
// TMisMonitorReportVo objMrUpdate = new TMisMonitorReportVo();
// objMrUpdate.IF_SEND = "1";
// objMrUpdate.REPORT_SCHEDULER = strProjectId;
// TMisMonitorReportVo objMrWhere = new TMisMonitorReportVo();
// objMrWhere.TASK_ID = strTaskId;
// new TMisMonitorReportLogic().Edit(objMrUpdate, objMrWhere);
// }
// }
//}
#endregion
return(IsSuccess == true ? "1" : "0");
}
public static string updateDate(string strSubTaskID, string strAskDate, string strFinishDate)
{
TMisMonitorSubtaskVo SubTaskVo = new TMisMonitorSubtaskVo();
SubTaskVo.ID = strSubTaskID;
SubTaskVo.SAMPLE_ASK_DATE = strAskDate;
SubTaskVo.SAMPLE_FINISH_DATE = strFinishDate;
new TMisMonitorSubtaskLogic().Edit(SubTaskVo);
return("1");
}
public static string setReceiveSubTask(string strSubTaskId)
{
TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVo.ID = strSubTaskId;
TMisMonitorSubtaskVo.REMARK2 = "1";
bool isSuccess = new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVo);
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 将任务发送至下一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string SendToNext(string strSubtaskId)
{
TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo();
objSubtaskVo.ID = strSubtaskId;
objSubtaskVo.TASK_STATUS = "023";
objSubtaskVo.TASK_TYPE = "发送";
bool isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo);
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 将任务回退到上一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string GoToBackTask(string strSubTaskId)
{
TMisMonitorSubtaskVo objSubTaskVo = new TMisMonitorSubtaskVo();
objSubTaskVo.ID = strSubTaskId;
objSubTaskVo.TASK_STATUS = "122";//退回状态
objSubTaskVo.TASK_TYPE = "退回";
bool isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubTaskVo);
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 采样任务分配信息
/// </summary>
/// <returns></returns>
private string getTwoGridInfo(string strTaskID)
{
if (this.PLAN_ID.Value.Length == 0)
{
return("");
}
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.ID = strTaskID;
objTask.PLAN_ID = this.PLAN_ID.Value;
objTask = new TMisMonitorTaskLogic().Details(objTask);
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
objSubtask.TASK_ID = objTask.ID;
objSubtask.TASK_STATUS = "01";
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubtask, intPageIndex, intPageSize);
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["SAMPLING_MANAGER_ID"].ToString().Length > 0)
{
dt.Rows[i]["SAMPLING_MANAGER_ID"] = new TSysUserLogic().Details(dt.Rows[i]["SAMPLING_MANAGER_ID"].ToString()).REAL_NAME;
}
else
{
dt.Rows[i]["SAMPLING_MANAGER_ID"] = "请选择";
}
//退回意见
TMisReturnInfoVo objReturnInfoVo = new TMisReturnInfoVo();
objReturnInfoVo.TASK_ID = dt.Rows[i]["TASK_ID"].ToString();
objReturnInfoVo.SUBTASK_ID = dt.Rows[i]["ID"].ToString();
objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_002;
objReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_001;
objReturnInfoVo = new TMisReturnInfoLogic().Details(objReturnInfoVo);
dt.Rows[i]["REMARK1"] = objReturnInfoVo.SUGGESTION;
}
dt.DefaultView.Sort = "MONITOR_ID ASC";
DataTable dtTemp = dt.DefaultView.ToTable();
int intTotalCount = new TMisMonitorSubtaskLogic().GetSelectResultCount(objSubtask);
string strJson = CreateToJson(dtTemp, intTotalCount);
return(strJson);
}
public static string EnvFinish(string strSubTaskId)
{
TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVo.ID = strSubTaskId;
TMisMonitorSubtaskVo.TASK_STATUS = "09";
if (new TMisMonitorSubtaskLogic().Edit(TMisMonitorSubtaskVo))
{
return("1");
}
else
{
return("0");
}
}
protected void btnImportCode_Click(object sender, EventArgs e)
{
string strPrintId = this.strPrintId.Value;
string strCompanyName = GetCompany_UnderTask(strPrintId);
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo();
objSubTask.TASK_ID = strPrintId;
DataTable dtSub = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask);
string strSampleIDs = "";
for (int i = 0; i < dtSub.Rows.Count; i++)
{
GetPoint_UnderTask(dtSub.Rows[i]["ID"].ToString(), ref strSampleIDs);
}
//获取基本信息
DataTable dt = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheetInfoBySampleId(strSampleIDs, "021", "0");
FileStream file = new FileStream(HttpContext.Current.Server.MapPath("template/SamplingCodingSheet.xls"), FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
sheet.GetRow(2).GetCell(1).SetCellValue(DateTime.Now.ToString("yyyy年MM月dd日"));
for (int i = 0; i < dt.Rows.Count; i++)
{
int j = i + 1;
sheet.GetRow(i + 6).GetCell(0).SetCellValue(j.ToString());
sheet.GetRow(i + 6).GetCell(1).SetCellValue(strCompanyName + dt.Rows[i]["SAMPLE_NAME"].ToString());
//sheet.GetRow(i + 6).GetCell(3).SetCellValue("1");
sheet.GetRow(i + 6).GetCell(5).SetCellValue(dt.Rows[i]["SAMPLE_CODE"].ToString());
}
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();
}
}
protected string GetMonitorType(string strTaskID)
{
string strMonitorType = "";//合同类型字符串
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo();
objSubTask.TASK_ID = strTaskID;
List <TMisMonitorSubtaskVo> listSubTask = new TMisMonitorSubtaskLogic().SelectByObject(objSubTask, 0, 0);
if (listSubTask.Count > 0)
{
foreach (TMisMonitorSubtaskVo obj in listSubTask)
{
strMonitorType += new TBaseMonitorTypeInfoLogic().Details(obj.MONITOR_ID).MONITOR_TYPE_NAME + "，";
}
}
return(strMonitorType.Length > 0 ? strMonitorType.Remove(strMonitorType.LastIndexOf("，")) : "");
}
/// <summary>
/// 获取监测点信息
/// </summary>
/// <returns></returns>
private string getOneGridInfo()
{
TMisMonitorSubtaskVo TMisMonitorSubtaskVo = new TMisMonitorSubtaskVo();
TMisMonitorSubtaskVo.TASK_ID = Request["formId"].ToString();
DataTable objTable = new TMisMonitorSubtaskLogic().SelectByTable(TMisMonitorSubtaskVo);
DataTable dt = objTable.Clone();
foreach (DataRow row in objTable.Rows)
{
if (row["REMARK1"].ToString() == "")
{
dt.ImportRow(row);
}
}
string strJson = CreateToJson(dt, dt.Rows.Count);
return(strJson);
}
/// <summary>
/// 采样任务列表信息
/// </summary>
/// <returns>Json</returns>
protected string getSampleTask()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
objSubtask.SORT_FIELD = "SAMPLE_ASK_DATE";
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTableWithTask(objSubtask, strMonitorID, "02", strTestedCompanyID, strContractCode, LogInfo.UserInfo.ID, 0, 0);
int intTotalCount = dt.Rows.Count;
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 构造监测结论
/// </summary>
/// <param name="strTaskID">监测任务ID</param>
protected string AutoSaveConclusion(string strTaskID)
{
string strConclusion = "";// 监测结论
TMisMonitorSubtaskVo objMonitorSubTask = new TMisMonitorSubtaskVo();
objMonitorSubTask.TASK_ID = strTaskID;
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objMonitorSubTask);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
//如果子任务中不存在监测结论则自动生成新的监测结论
string strCon = dr["PROJECT_CONCLUSION"].ToString().Length > 0 ? dr["PROJECT_CONCLUSION"].ToString() : GetConclusion(strTaskID, dr["ID"].ToString());
strConclusion += strCon.Length > 0 ? strCon + "；" : "";
}
strConclusion += "对执行标准如有异议，以环保管理部门核定为准。";
}
return(strConclusion);
}
/// <summary>
/// 发送到下一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string SendToNext(string strTaskId)
{
bool IsSuccess = true;
DataTable dt = new TMisMonitorResultLogic().getItemTypeInfo(LogInfo.UserInfo.ID, "sample_qc_end", strTaskId, "024", "01");
for (int i = 0; i < dt.Rows.Count; i++)
{
string strMonitorID = dt.Rows[i]["MONITOR_ID"].ToString();
TMisMonitorSubtaskVo objSsubtask = new TMisMonitorSubtaskVo();
objSsubtask.TASK_ID = strTaskId;
objSsubtask.MONITOR_ID = strMonitorID;
objSsubtask = new TMisMonitorSubtaskLogic().Details(objSsubtask);
objSsubtask.TASK_STATUS = "021";
if (!new TMisMonitorSubtaskLogic().Edit(objSsubtask))
{
IsSuccess = false;
}
}
return(IsSuccess == true ? "1" : "0");
}
/// <summary>
/// 任务退回
/// </summary>
/// <param name="strTaskId">任务Id</param>
/// <returns></returns>
private string GoToBack(string strTaskId, string strSubTaskID, string strSuggestion)
{
//TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo();
//objSubtaskVo.ID = strSubTaskId;
//objSubtaskVo.TASK_STATUS = "022";
//objSubtaskVo.TASK_TYPE = "退回";
//bool IsSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo);
//bool IsSuccess = new TMisMonitorSubtaskLogic().SampleResultQcCheckBackTo(strTaskId, "023", "022", "退回");
bool IsSuccess = true;
TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskVo();
objSubtaskVo.ID = strSubTaskID;
objSubtaskVo.TASK_STATUS = "022";
objSubtaskVo.TASK_TYPE = "退回";
IsSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtaskVo);
TMisReturnInfoVo objReturnInfoVo = new TMisReturnInfoVo();
objReturnInfoVo.TASK_ID = strTaskId;
objReturnInfoVo.SUBTASK_ID = strSubTaskID;
objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_004;
objReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_003;
TMisReturnInfoVo obj = new TMisReturnInfoLogic().Details(objReturnInfoVo);
if (obj.ID.Length > 0)
{
objReturnInfoVo.ID = obj.ID;
objReturnInfoVo.SUGGESTION = strSuggestion;
IsSuccess = new TMisReturnInfoLogic().Edit(objReturnInfoVo);
}
else
{
objReturnInfoVo.ID = GetSerialNumber("t_mis_return_id");
objReturnInfoVo.SUGGESTION = strSuggestion;
IsSuccess = new TMisReturnInfoLogic().Create(objReturnInfoVo);
}
return(IsSuccess == true ? "1" : "0");
}
public static string btnBackClick(string strPlanID)
{
bool IsSuccess = true;
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.PLAN_ID = strPlanID;
objTask = new TMisMonitorTaskLogic().Details(objTask);
TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo();
objSubTask.TASK_ID = objTask.ID;
//判断是否经过质控，如果经过质控，则将数据发送到质控环节
if (true)
{
TMisMonitorTaskVo objTaskEdit = new TMisMonitorTaskVo();
objTaskEdit.ID = objTask.ID;
objTaskEdit.QC_STATUS = "1";
new TMisMonitorTaskLogic().Edit(objTaskEdit);
}
return(IsSuccess == true ? "1" : "0");
}
private void GetInfoForPrint(ref string strPointNames, ref int intPointCount, ref string strItemS)
{
if (this.PLAN_ID.Value.Length == 0)
{
return;
}
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.PLAN_ID = this.PLAN_ID.Value;
objTask = new TMisMonitorTaskLogic().Details(objTask);
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
objSubtask.TASK_ID = objTask.ID;
DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubtask, 0, 0);
for (int i = 0; i < dt.Rows.Count; i++)
{
GetPoint_UnderTask(dt.Rows[i]["ID"].ToString(), ref strPointNames, ref intPointCount, ref strItemS);
}
}
public string SaveUserInfo()
{
bool isSuccess = true;
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
if (this.strTaskId.Value.Trim() == "")
{
objSubtask.ID = this.strSubTaskId.Value;
objSubtask.SAMPLING_MANAGER_ID = Request["DEFAULT_USER"];
isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask);
}
else
{
//在采样分配环节批量修改采样人 add by weilin
objSubtask.SAMPLING_MANAGER_ID = Request["DEFAULT_USER"];
TMisMonitorSubtaskVo objWhere = new TMisMonitorSubtaskVo();
objWhere.TASK_ID = this.strTaskId.Value.Trim();
objWhere.TASK_STATUS = "01";
isSuccess = new TMisMonitorSubtaskLogic().Edit(objSubtask, objWhere);
}
return(isSuccess == true ? "1" : "0");
}
