/// <summary> /// 根据监测类型获取敢为职责用户信息 /// </summary> /// <param name="strItemId">监测项目ID</param> /// <returns></returns> public string getUserInfo(string strItemId, string strSampleId) { //获取监测类别 string strMonitorType = ""; DataTable dtSubtask = new TMisMonitorSubtaskLogic().GetSubTaskObjectBySample(strSampleId); if (dtSubtask.Rows.Count > 0) { strMonitorType = dtSubtask.Rows[0]["MONITOR_ID"].ToString(); } //获取分析分配环节用户信息 DataTable objTable = new TSysDutyLogic().SelectTableDutyUser(new TSysDutyVo() { DICT_CODE = "duty_other_analyse_result", MONITOR_TYPE_ID = strMonitorType, MONITOR_ITEM_ID = strItemId }); string strCurrentUserId = LogInfo.UserInfo.ID; DataRow deleteRow = null; foreach (DataRow row in objTable.Rows) { if (row["USERID"].ToString() == strCurrentUserId) { deleteRow = row; } } if (deleteRow != null) { objTable.Rows.Remove(deleteRow); } return(DataTableToJson(objTable)); }
/// <summary> /// 插入分析类岗位的 监测类别 /// </summary> /// <param name="objcitems"></param> /// <param name="strDutyType"></param> /// <param name="strMonitor"></param> /// <param name="strItems"></param> /// <param name="strUserId"></param> /// <param name="dtis"></param> /// <param name="sAuItems"></param> /// <param name="sExItems"></param> /// <param name="mAuItems"></param> /// <param name="mExItems"></param> /// <returns></returns> public static bool InsertAddMonitorItems(TSysDutyVo objcitems, string strDutyType, string strMonitor, string strUserId, DataTable dtis, string[] strItems, string[] sAuItems, string[] sExItems, string[] mAuItems, string[] mExItems, bool isMonitorType) { bool flag = false; string flag_au = "", flag_ex = "", flag_mau = "", flag_mex = ""; string dutId = ""; int newNum = 0, newSuc = 0; int strCount = strItems.Length - 1; foreach (string str in strItems) { if (!String.IsNullOrEmpty(str)) { //是否存在已经设置了的监测项目组合 DataRow[] dr = dtis.Select("MONITOR_ITEM_ID IS NULL AND DICT_CODE='" + strDutyType + "'"); if (dr.Length > 0) { //获取已经存在符合条件的ID dutId = dr[0]["ID"].ToString(); } else { objcitems.ID = GetSerialNumber("duty_set_infor"); dutId = objcitems.ID; objcitems.DICT_CODE = strDutyType; bool flgs = new TSysDutyLogic().Create(objcitems); if (flgs) { string strMessage = new PageBase().LogInfo.UserInfo.USER_NAME + "新增岗位职责" + objcitems.ID + "成功"; new PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.AddDutyInfo, "", strMessage); } } //直接插入岗位职责用户关联数据 if (UserDutyItem(strUserId, "", dutId)) { newNum++; } else { newSuc++; } //插入默认负责人和默认协同人项目 flag_au = UpdateDefaultAuValue(strUserId, strMonitor, strDutyType, sAuItems, isMonitorType); flag_ex = UpdateDefaultExValue(strUserId, strMonitor, strDutyType, sExItems, isMonitorType); flag_mau = UpdateDefaultMoveAuValue(strUserId, strMonitor, strDutyType, mAuItems, isMonitorType); flag_mex = UpdateDefaultMoveExValue(strUserId, strMonitor, strDutyType, mExItems, isMonitorType); } } if ((newNum + newSuc) == strCount && flag_au != "0" && flag_ex != "0" && flag_mau != "0" & @flag_mex != "0") { flag = true; } return(flag); }
/// <summary> /// 获取用户数据集 /// </summary> /// <returns></returns> protected string getUserList() { DataTable dt = new DataTable(); TSysDutyVo objItems = new TSysDutyVo(); objItems.DICT_CODE = "duty_reportschedule"; dt = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0); return(DataTableToJson(dt)); }
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> /// <returns></returns> protected string getUserInfo() { //获得所有监测类别 DataTable dtSonTask = new TMisMonitorSubtaskLogic().selectAllContractType(this.hdnTaskID.Value); string reslut = ""; DataTable dtTotal = new DataTable(); TSysDutyVo objItems = new TSysDutyVo(); /* * foreach (DataRow dr in dtSonTask.Rows) * { * DataTable dt = new DataTable(); * objItems.DICT_CODE = "duty_reportschedule"; * objItems.MONITOR_TYPE_ID = dr["MONITOR_ID"].ToString(); * dt = new TSysDutyLogic().SelectByUnionTable(objItems, 0, 0); * dt.Columns.Add("MONITOR_NAME"); * dt.Columns.Add("POST_NAME"); * //添加监测类别列 * foreach (DataRow drSon in dt.Rows) * { * drSon["MONITOR_NAME"] = new TBaseMonitorTypeInfoLogic().Details(dr["MONITOR_ID"].ToString()).MONITOR_TYPE_NAME; * drSon["POST_NAME"] = new TSysPostLogic().Details(new TSysUserPostLogic().Details(new TSysUserPostVo() { USER_ID = drSon["ID"].ToString() }).POST_ID).POST_NAME; * } * dtTotal.Merge(dt); * } */ DataTable dt = new DataTable(); objItems.DICT_CODE = "duty_reportschedule"; objItems.MONITOR_TYPE_ID = "000000001"; //默认报告编制人是废水类型的 dt = new TSysDutyLogic().SelectByUnionTable(objItems, 0, 0); dt.Columns.Add("MONITOR_NAME"); dt.Columns.Add("POST_NAME"); //添加监测类别列 foreach (DataRow drSon in dt.Rows) { drSon["MONITOR_NAME"] = new TBaseMonitorTypeInfoLogic().Details("000000001").MONITOR_TYPE_NAME; drSon["POST_NAME"] = new TSysPostLogic().Details(new TSysUserPostLogic().Details(new TSysUserPostVo() { USER_ID = drSon["ID"].ToString() }).POST_ID).POST_NAME; } dtTotal.Merge(dt); reslut = LigerGridDataToJson(dtTotal, dtTotal.Rows.Count); return(reslut); }
/// <summary> /// 加载采样类岗位设置人员列表 /// </summary> /// <param name="strMonitor"></param> /// <param name="strDutyType"></param> /// <param name="iIndex"></param> /// <param name="iCount"></param> /// <returns></returns> public string LoadSetUserList() { //创建标准JSON数据 string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; string strDutyType = Request.Params["strDutyType"]; string strItemID = Request.Params["strItemID"]; TSysDutyVo objItems = new TSysDutyVo(); objItems.MONITOR_ITEM_ID = strItemID; objItems.DICT_CODE = strDutyType; DataTable dt = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0); string reslut = LigerGridDataToJson(dt, dt.Rows.Count); return(reslut); }
public static List <object> GetSubUserItems(string strPost_Dept, string strItemID, string strDutyType) { DataTable dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0); TSysDutyVo objItems = new TSysDutyVo(); objItems.MONITOR_ITEM_ID = strItemID; objItems.DICT_CODE = strDutyType; DataTable dtDuty = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0); 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]["ID"].ToString())) { DataRow[] dr = dt.Select("ID='" + dtDuty.Rows[i]["ID"].ToString() + "'"); if (dr != null) { foreach (DataRow Temrow in dr) { Temrow.Delete(); dt.AcceptChanges(); } } } } } dtItems = dt.Copy(); List <object> listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count); return(listResult); }
/// <summary> /// 加载采样类岗位设置人员列表 /// </summary> /// <param name="strMonitor"></param> /// <param name="strDutyType"></param> /// <param name="iIndex"></param> /// <param name="iCount"></param> /// <returns></returns> public string LoadSetUserList(string strMonitor, string strDutyType, int iIndex, int iCount) { string reslut = ""; dt = new DataTable(); TSysDutyVo objItems = new TSysDutyVo(); objItems.MONITOR_TYPE_ID = strMonitor; objItems.DICT_CODE = strDutyType; dt = new TSysDutyLogic().SelectByUnionTable(objItems, iIndex, iCount); int intCount = new TSysDutyLogic().GetSelectByUnionResultCount(objItems); //TSysUserVo objVo = new TSysUserVo(); //objVo.IS_DEL = "0"; //objVo.IS_USE = "1"; //objVo.IS_HIDE = "0"; //dt = new TSysUserLogic().SelectByTable(objVo, iIndex, iCount); //int intCount = new TSysUserLogic().GetSelectResultCount(objVo); //DataTable dtnew = new DataTable(); //dtnew = new TSysUserDutyLogic().GetSamplingSetUser(strMonitor, strDutyType); //dt.Columns.Add(new DataColumn("IF_DEFAULT", typeof(string))); //dt.Columns.Add(new DataColumn("IF_DEFAULT_EX", typeof(string))); //dt.Columns.Add(new DataColumn("ISEXIST", typeof(string))); //if (!String.IsNullOrEmpty(strMonitor)) //{ // if (dtnew.Rows.Count > 0) // { // for (int i = 0; i < dt.Rows.Count; i++) // { // foreach (DataRow dr in dtnew.Rows) // { // if (dt.Rows[i]["ID"].ToString() == dr["USERID"].ToString()) // { // dt.Rows[i]["IF_DEFAULT"] = dr["IF_DEFAULT"].ToString(); // dt.Rows[i]["IF_DEFAULT_EX"] = dr["IF_DEFAULT_EX"].ToString(); // dt.Rows[i]["ISEXIST"] = "True"; // } // } // } // dt.AcceptChanges(); // DataRow[] drr = dt.Select("ISEXIST='True'"); // DataTable dtTemp = dt.Copy(); // dtTemp.Clear(); // foreach (DataRow ddr in drr) // { // dtTemp.ImportRow(ddr); // } // dt.Clear(); // dt = dtTemp.Copy(); // } // else // { // dt.Clear(); // } //} //else //{ // dt.Clear(); //} //intCount = dt.Rows.Count; reslut = LigerGridDataToJson(dt, intCount); return(reslut); }
/// <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 < 1) { for (int i = 0; i < dt.Rows.Count; i++) { TSysDutyVo objDuty = new TSysDutyVo(); objDuty.MONITOR_TYPE_ID = dt.Rows[i]["MONITOR_ID"].ToString(); objDuty.DICT_CODE = "duty_sampling"; DataTable objDutyDt = new TSysDutyLogic().GetDutyUser(objDuty); DataRow drr = null; if (objDutyDt.Rows.Count > 0) { //如果设置了默认负责人,则取默认负责人 DataRow[] drArr = objDutyDt.Select(" IF_DEFAULT='0'"); if (drArr.Length > 0) { drr = drArr[0]; } else { //如果未设置默认负责人,则取第一行数据 drr = objDutyDt.Rows[0]; } if (drr != null) { TMisMonitorSubtaskVo objUpSubTask = new TMisMonitorSubtaskVo(); objUpSubTask.ID = dt.Rows[i]["ID"].ToString(); objUpSubTask.SAMPLING_MANAGER_ID = drr["USERID"].ToString(); new TMisMonitorSubtaskLogic().Edit(objUpSubTask); } } } } 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> /// 保存默认监测计划岗位负责人 Create By Castle (胡方扬) 2013-4-1 /// </summary> /// <returns></returns> public static void SavePlanPeopleForEnv(string strPlanId) { DataTable dtMonitor = new DataTable(); TMisContractPointFreqVo objItemspan = new TMisContractPointFreqVo(); objItemspan.IF_PLAN = "0"; dtMonitor = new TMisContractPointFreqLogic().GetPointMonitorInforForPlan(objItemspan, strPlanId); //DataTable dtMonitor = GetPointMonitorInfor(strPlanId); DataTable dtTemple = new DataTable(); TSysDutyVo objItemspan1 = new TSysDutyVo(); objItemspan1.DICT_CODE = "duty_sampling"; dtTemple = new TSysDutyLogic().SelectTableDutyUser(objItemspan1); //DataTable dtTemple = GetMonitorDutyInforTable(); DataTable dtMonitorDutyUser = new DataTable(); dtMonitorDutyUser = dtTemple.Copy(); dtMonitorDutyUser.Clear(); //获取默认负责人 for (int n = 0; n < dtMonitor.Rows.Count; n++) { DataRow[] drowArr = dtTemple.Select(" IF_DEFAULT='0' AND MONITOR_TYPE_ID='" + dtMonitor.Rows[0]["ID"].ToString() + "'"); if (drowArr.Length > 0) { foreach (DataRow drow in drowArr) { dtMonitorDutyUser.ImportRow(drow); } dtMonitorDutyUser.AcceptChanges(); } else { drowArr = dtTemple.Select(" MONITOR_TYPE_ID='" + dtMonitor.Rows[0]["ID"].ToString() + "'"); if (drowArr.Length > 0) { dtMonitorDutyUser.ImportRow(drowArr[0]); } dtMonitorDutyUser.AcceptChanges(); } } //if (drowArr.Length > 0) //{ // foreach (DataRow drow in drowArr) // { // dtMonitorDutyUser.ImportRow(drow); // } // dtMonitorDutyUser.AcceptChanges(); //} string strMonitorId = "", strUserId = ""; foreach (DataRow drr in dtMonitor.Rows) { for (int i = 0; i < dtMonitorDutyUser.Rows.Count; i++) { if (drr["ID"].ToString() == dtMonitorDutyUser.Rows[i]["MONITOR_TYPE_ID"].ToString()) { strMonitorId += drr["ID"].ToString() + ";"; strUserId += dtMonitorDutyUser.Rows[i]["USERID"].ToString() + ";"; } } } TMisContractUserdutyVo objItems = new TMisContractUserdutyVo(); if (!String.IsNullOrEmpty(strPlanId)) { objItems.CONTRACT_PLAN_ID = strPlanId; string[] strMonitArr = null, strUserArr = null; if (!String.IsNullOrEmpty(strMonitorId) && !String.IsNullOrEmpty(strUserId)) { strMonitArr = strMonitorId.Substring(0, strMonitorId.Length - 1).Split(';'); strUserArr = strUserId.Substring(0, strUserId.Length - 1).Split(';'); if (strMonitArr != null && strUserArr != null) { new TMisContractUserdutyLogic().SaveContractPlanDutyForEnv(objItems, strMonitArr, strUserArr); } } } }
public static bool SaveTypeDivDate(string strUserId, string strMonitor, string strDutyType, string strMonitorItems, string strMoveId, string strAuItems, string strExItems, string MoveAuId, string MoveExId) { bool result = false; DataTable dtis = new DataTable(); TSysDutyVo objcitems = new TSysDutyVo(); objcitems.MONITOR_TYPE_ID = strMonitor; dtis = new TSysDutyLogic().SelectByTable(objcitems); string[] strItems = null, strmoItems = null, sAuItems = null, sExItems = null, mAuItems = null, mExItems = null; if (!String.IsNullOrEmpty(strMonitorItems)) { strItems = strMonitorItems.Split(';'); } if (!String.IsNullOrEmpty(strMoveId)) { strmoItems = strMoveId.Split(';'); } if (!String.IsNullOrEmpty(strAuItems)) { sAuItems = strAuItems.Split(';'); } if (!String.IsNullOrEmpty(strExItems)) { sExItems = strExItems.Split(';'); } if (!String.IsNullOrEmpty(MoveAuId)) { mAuItems = MoveAuId.Split(';'); } if (!String.IsNullOrEmpty(MoveExId)) { mExItems = MoveExId.Split(';'); } //如果移除已选的和新增已选的项目均不为空 则执行该方法 if (!String.IsNullOrEmpty(strMoveId.ToString()) && !String.IsNullOrEmpty(strMonitorItems.ToString())) { if (DelMoveMonitorItems(strMonitor, strmoItems, strDutyType, strUserId, true)) { if (InsertAddMonitorItems(objcitems, strDutyType, strMonitor, strUserId, dtis, strItems, sAuItems, sExItems, mAuItems, mExItems, true)) { result = true; } } } //如果移除的不为空,新增的监测项目为空 if (!String.IsNullOrEmpty(strMoveId.ToString()) && String.IsNullOrEmpty(strMonitorItems.ToString())) { if (DelMoveMonitorItems(strMonitor, strmoItems, strDutyType, strUserId, true)) { result = true; } } //如果移除的为空,新增的监测项目不为空 if (String.IsNullOrEmpty(strMoveId.ToString()) && !String.IsNullOrEmpty(strMonitorItems.ToString())) { if (InsertAddMonitorItems(objcitems, strDutyType, strMonitor, strUserId, dtis, strItems, sAuItems, sExItems, mAuItems, mExItems, true)) { result = true; } } return(result); }