public static List <object> GetMonitorItems(string strMonitor, string strUserId) { List <object> reslut = new List <object>(); DataTable dtSt = new DataTable(); TBaseItemInfoVo objtd = new TBaseItemInfoVo(); objtd.IS_DEL = "0"; objtd.MONITOR_ID = strMonitor; dtSt = new TBaseItemInfoLogic().SelectByTable(objtd); DataTable dtnew = new DataTable(); dtnew = new TSysUserDutyLogic().GetExistMonitor(strMonitor, strUserId, false, false); for (int i = 0; i < dtnew.Rows.Count; i++) { DataRow[] drr = dtSt.Select("ID='" + dtnew.Rows[i]["ITEM_ID"] + "'"); if (drr.Length > 0) { foreach (DataRow drow in drr) { drow.Delete(); } } } dtSt.AcceptChanges(); reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count); return(reslut); }
public static string SetDefaultEx(string strUSERDUTYIDs) { string[] strUSERDUTYIDsArr = strUSERDUTYIDs.Split(';'); foreach (string str in strUSERDUTYIDsArr) { TSysUserDutyVo objUserDuty = new TSysUserDutyLogic().Details(str); if (objUserDuty.IF_DEFAULT_EX == "0") { new TSysUserDutyLogic().Edit(new TSysUserDutyVo() { IF_DEFAULT_EX = "1" }, new TSysUserDutyVo { ID = str }); } else { new TSysUserDutyLogic().Edit(new TSysUserDutyVo() { IF_DEFAULT_EX = "0" }, new TSysUserDutyVo { ID = str }); } } return("1"); }
public static List <object> GetExistMonitorItems(string strMonitor, string strUserId, string strDefaultAu, string strDefaultEx) { List <object> reslut = new List <object>(); DataTable dtnew = new DataTable(); DataTable dtAll = new DataTable(); //获取当前用户加载作为项目负责人的项目 if (!String.IsNullOrEmpty(strDefaultAu)) { dtnew = new TSysUserDutyLogic().GetExistMonitor(strMonitor, strUserId, true, false); //获取分析岗位职责中 设置监测类型为岗位职责的数据 dtAll = new TSysUserDutyLogic().GetExistMonitorType(strMonitor, strUserId, true, false); for (int i = 0; i < dtAll.Rows.Count; i++) { if (i == 0) { dtAll.Rows[0]["ITEM_NAME"] = "所有(" + dtAll.Rows[0]["ITEM_NAME"].ToString() + "类)"; dtAll.AcceptChanges(); dtnew.ImportRow(dtAll.Rows[0]); } } } //获取当前用户加载作为项目协同人的项目 if (!String.IsNullOrEmpty(strDefaultEx)) { dtnew = new TSysUserDutyLogic().GetExistMonitor(strMonitor, strUserId, false, true); dtAll = new TSysUserDutyLogic().GetExistMonitorType(strMonitor, strUserId, false, true); for (int i = 0; i < dtAll.Rows.Count; i++) { if (i == 0) { dtAll.Rows[0]["ITEM_NAME"] = "所有(" + dtAll.Rows[0]["ITEM_NAME"].ToString() + "类)"; dtAll.AcceptChanges(); dtnew.ImportRow(dtAll.Rows[0]); } } } if (String.IsNullOrEmpty(strDefaultAu) && String.IsNullOrEmpty(strDefaultEx)) { //获取当前用户已设置的监测项目 dtnew = new TSysUserDutyLogic().GetExistMonitor(strMonitor, strUserId, false, false); dtAll = new TSysUserDutyLogic().GetExistMonitorType(strMonitor, strUserId, false, false); for (int i = 0; i < dtAll.Rows.Count; i++) { if (i == 0) { dtAll.Rows[0]["ITEM_NAME"] = "所有(" + dtAll.Rows[0]["ITEM_NAME"].ToString() + "类)"; dtAll.AcceptChanges(); dtnew.ImportRow(dtAll.Rows[0]); } } } reslut = LigerGridSelectDataToJson(dtnew, dtnew.Rows.Count); return(reslut); }
public static bool InsertSelectedUser(string strUserId, string strItemID, string strDutyType) { string strDutyID = ""; string strMonitorID = new TBaseItemInfoLogic().Details(strItemID).MONITOR_ID; TSysDutyVo objDutySrh = new TSysDutyVo(); objDutySrh.MONITOR_TYPE_ID = strMonitorID; objDutySrh.MONITOR_ITEM_ID = strItemID; objDutySrh.DICT_CODE = strDutyType; DataTable dtDuty = new TSysDutyLogic().SelectByTable(objDutySrh); if (dtDuty.Rows.Count == 0) { //如果不存在岗位配置,增加 objDutySrh.ID = GetSerialNumber("duty_set_infor"); if (new TSysDutyLogic().Create(objDutySrh)) { strDutyID = objDutySrh.ID; } } else { strDutyID = dtDuty.Rows[0]["ID"].ToString(); } TSysUserDutyVo objUserDutySrh = new TSysUserDutyVo(); objUserDutySrh.DUTY_ID = strDutyID; DataTable dtUserDuty = new TSysUserDutyLogic().SelectByTable(objUserDutySrh); //删除移除的 for (int i = 0; i < dtUserDuty.Rows.Count; i++) { string strTmpUserID = dtUserDuty.Rows[i]["USERID"].ToString(); if (!strUserId.Contains(strTmpUserID)) { new TSysUserDutyLogic().Delete(dtUserDuty.Rows[i]["ID"].ToString()); } } string[] strUerArr = strUserId.Split(';'); new TSysUserDutyLogic().InsertSelectedUser(strUerArr, strDutyID); return(true); }
/// <summary> /// 获得指定职责的默认负责人,如果不存在则取第一个 /// </summary> /// <param name="strDutyType">职责编码</param> /// <param name="strMonitorType">监测类别</param> /// <returns></returns> private string GetDefaultOrFirstDutyUser(string strDutyType, string strMonitorType) { DataTable dtDuty = new TSysUserDutyLogic().SelectUserDuty(strDutyType, strMonitorType); //过滤默认负责人 DataRow[] drDuty = dtDuty.Select(" IF_DEFAULT"); if (drDuty.Length > 0) { return(GetSampleManager(drDuty[0]["USERID"].ToString())); } else { if (dtDuty.Rows.Count > 0) { return(GetSampleManager(dtDuty.Rows[0]["USERID"].ToString())); } } return(""); }
public static List <object> GetSubUserItems(string strPost_Dept, string strMonitorId, string strDutyType) { List <object> listResult = new List <object>(); DataTable dt = new DataTable(); DataTable dtDuty = new DataTable(); dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0); dtDuty = new TSysUserDutyLogic().SelectUserDuty(strDutyType, strMonitorId); DataTable dtItems = new DataTable(); dtItems = dt.Copy(); dtItems.Clear(); if (dtDuty.Rows.Count > 0) { for (int i = 0; i < dtDuty.Rows.Count; i++) { if (!String.IsNullOrEmpty(dtDuty.Rows[i]["USERID"].ToString())) { DataRow[] dr = dt.Select("ID='" + dtDuty.Rows[i]["USERID"].ToString() + "'"); if (dr != null) { foreach (DataRow Temrow in dr) { Temrow.Delete(); dt.AcceptChanges(); } } } } } dtItems = dt.Copy(); listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count); return(listResult); }
public static string SetDefaultAu(string strUSERDUTYIDs) { string[] strUSERDUTYIDsArr = strUSERDUTYIDs.Split(';'); foreach (string str in strUSERDUTYIDsArr) { TSysUserDutyVo objUserDuty = new TSysUserDutyLogic().Details(str); new TSysUserDutyLogic().Edit(new TSysUserDutyVo() { IF_DEFAULT = "1" }, new TSysUserDutyVo { DUTY_ID = objUserDuty.DUTY_ID }); new TSysUserDutyLogic().Edit(new TSysUserDutyVo() { IF_DEFAULT = "0" }, new TSysUserDutyVo { ID = str }); } return("1"); }
protected void ReturnAllTaskStep() { //任务对象 TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(this.TASK_ID.Value); //子任务信息 TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskLogic().Details(new TMisMonitorSubtaskVo() { TASK_ID = this.TASK_ID.Value, MONITOR_ID = this.dllMonitor.SelectedValue }); //样品信息 TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(new TMisMonitorSampleInfoVo() { SUBTASK_ID = objSubTask.ID, QC_TYPE = "0" }); //样品结果信息 DataTable dtResult = new TMisMonitorResultLogic().SelectResultAndAppWithSubtaskID(objSubTask.ID); //校阅 //委托书对象 TMisContractVo objContract = new TMisContractLogic().Details(objTask.CONTRACT_ID); //预约表 TMisContractPlanVo objPlan = new TMisContractPlanLogic().Details(new TMisContractPlanVo() { CONTRACT_ID = objContract.ID }); //预约频次表(已预约未办理数) int intIsPlanNoDo = new TMisContractPointFreqLogic().GetSelectResultCount(new TMisContractPointFreqVo() { CONTRACT_ID = objContract.ID, IF_PLAN = "0" }); #region 暂行的定制生成任务追踪方法 页面HTML构建 //定义已处理DIV样式 string strDivHas = "<div style='width:150px;height:50px;background-color:#5a8f5a;text-align: center;vertical-align: middle;'>{0}</div>"; //定义待处理DIV样式 string strDivWait = "<div style='width:150px;height:50px;background-color:#de9a1d;text-align: center;vertical-align: middle;'>{0}</div>"; //定义特殊处理DIV样式 //string strDivSepecial = "<div style='width:100px;height:50px;background-color:#e34323;text-align: center;vertical-align: middle;'>{0}</div"; //定义未处理DIV样式 //string strDivNo = "<div style='width:100px;height:50px;background-color:#a9a9a9;text-align: center;vertical-align: middle;'>{0}</div>"; Table table1 = new Table(); table1.CssClass = "tMain"; TableRow row1 = new TableRow();//委托流程连接 TableCell cell1 = new TableCell(); cell1.Text = string.Format(strDivHas, "<a href='#' onclick='ShowContract();'>委托流程</a>"); row1.Cells.Add(cell1); table1.Rows.Add(row1); //是否已预约 if (intIsPlanNoDo > 0) { table1 = GetCommonRow(table1, strDivHas, "采样预约", ""); } else { table1 = GetCommonRow(table1, strDivWait, "采样预约", ""); this.divSample.Controls.Add(table1); return; } //是否预约办理 if (objPlan.HAS_DONE == "1")//已办理 { table1 = GetCommonRow(table1, strDivHas, "预约办理", ""); } else { table1 = GetCommonRow(table1, strDivWait, "预约办理", ""); this.divSample.Controls.Add(table1); return; } //采样负责人 string strSampleManager = GetSampleManager(objSubTask.SAMPLING_MANAGER_ID); //交接人 string strSampleAccept = string.Empty; DataTable dtSampleAccept = new TSysUserDutyLogic().SelectUserDuty("sample_allocation_sheet", this.dllMonitor.SelectedValue); if (dtSampleAccept.Rows.Count > 0) { strSampleAccept = GetSampleManager(dtSampleAccept.Rows[0]["USERID"].ToString()); } //是否采样 if (objSubTask.TASK_STATUS == "02") { table1 = GetCommonRow(table1, strDivWait, "采样", strSampleManager); } //样品交接 if (objSubTask.TASK_STATUS == "021") { table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager); table1 = GetCommonRow(table1, strDivWait, "样品交接", strSampleAccept); } //分析任务分配 DataRow[] dr1 = dtResult.Select(" RESULT_STATUS='01'");//过滤过分析分配环节任务 //分析结果录入 DataRow[] dr2 = dtResult.Select(" RESULT_STATUS='20'"); //数据审核 DataRow[] dr3 = dtResult.Select(" RESULT_STATUS='30'"); //分析室主任审核 DataRow[] dr4 = dtResult.Select(" RESULT_STATUS='40'"); //技术室主任审核 DataRow[] dr5 = dtResult.Select(" RESULT_STATUS='50'"); if (objSubTask.TASK_STATUS == "03") { if (dr1.Length > 0)//环节在分析任务分配 { table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager); table1 = GetCommonRow(table1, strDivHas, "样品交接", strSampleAccept); table1 = GetCommonRow(table1, strDivWait, "分析任务分配", ""); } else { table1 = GetCommonRow(table1, strDivHas, "采样", strSampleManager); table1 = GetCommonRow(table1, strDivHas, "样品交接", strSampleAccept); table1 = GetCommonRow(table1, strDivHas, "分析任务分配", ""); table1 = GetResultRow(table1, strDivHas, strDivWait, "分析结果录入", dtResult); if (dr2.Length > 0) //结果提交不完全时 { if (dr5.Length > 0) //流程已到技术室审核环节(最后环节) { table1 = GetCommonRow(table1, strDivWait, "数据审核", ""); table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", ""); table1 = GetCommonRow(table1, strDivWait, "技术室主任审核", ""); } else { if (dr4.Length > 0)//流程仅到分析室审核 { table1 = GetCommonRow(table1, strDivWait, "数据审核", ""); table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", ""); } else { if (dr3.Length > 0)//流程仅到数据审核 { table1 = GetCommonRow(table1, strDivWait, "数据审核", ""); } } } } else//结果提交完全时 { if (dr3.Length > 0)//数据审核不完全 { table1 = GetCommonRow(table1, strDivWait, "数据审核", ""); } else { table1 = GetCommonRow(table1, strDivHas, "数据审核", ""); } if (dr4.Length > 0)//分析审核不完全 { table1 = GetCommonRow(table1, strDivWait, "分析室主任审核", ""); } else { table1 = GetCommonRow(table1, strDivHas, "分析室主任审核", ""); } if (dr5.Length > 0) //流程已到技术室审核环节(最后环节) { if (objSubTask.TASK_STATUS == "09" && objTask.TASK_STATUS == "09") //分析流程完成 { table1 = GetCommonRow(table1, strDivHas, "技术室主任审核", ""); TableRow row = new TableRow();//委托流程连接 TableCell cell = new TableCell(); cell.Text = string.Format(strDivHas, "<a href='#' onclick='ShowReport();'>报告流程</a>"); row.Cells.Add(cell); table1.Rows.Add(row); } else { table1 = GetCommonRow(table1, strDivWait, "技术室主任审核", ""); } } } } } this.divSample.Controls.Add(table1); #endregion }
/// <summary> /// 获得指定职责的默认负责人,如果不存在则取第一个 /// </summary> /// <param name="strDutyType">职责编码</param> /// <param name="strMonitorType">监测类别</param> /// <returns></returns> private DataTable GetDefaultOrFirstDutyUser(string strDutyType, string strMonitorType) { DataTable dtDuty = new TSysUserDutyLogic().SelectUserDuty(strDutyType, strMonitorType); return(dtDuty); }