/// <summary> /// 获取气象监测组织机构树 /// </summary> /// <param name="DEPT_CODE"></param> /// <param name="PARENT_CODE"></param> /// <param name="isCheckAll"></param> /// <returns></returns> public static string GetWeatherDeptTree(string DEPT_CODE, string PARENT_CODE, bool isCheckAll) { string strJson = string.Empty; List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>(); List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && m.DEPT_CODE.Length <= 8 && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE)) .OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList(); if (listMenu.Count > 0) { foreach (SYS_DEPT org in listMenu) { listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = org.DEPT_CODE, PARENT_CODE = org.PARENT_CODE, ORGRY_NAME = org.DEPT_NAME, ICO = org.C_ICO, RYMOBILE = "", STATE = org.STATUS_FLAG//0关闭 }); } } List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll); strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); return(strJson); }
/// <summary> /// 获取用户对应部门组织树 /// </summary> /// <returns></returns> public static string GetMyORGandRYTree(string DEPT_CODE, string PARENT_CODE, bool isCheckAll) { string strJson = string.Empty; List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>(); //获取人员 List <SYS_MEMBER> listRyMenu = oc.BllSession.ISYS_MEMBERService.GetListByCondition <string>(m => m.DEL_FLAG == "0" && m.LOCATION_FLAG == "1" && m.DEPT_CODE.StartsWith(DEPT_CODE), m => m.MOBILE).Select(mb => mb.ToPOCO()).ToList(); if (listRyMenu.Count > 0) { foreach (SYS_MEMBER ry in listRyMenu) { string icon = "icon-Off-line"; if (ry.MOBILE_STATE == "1") { icon = "icon-status_busy"; } listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = ry.MOBILE, PARENT_CODE = ry.DEPT_CODE, ORGRY_NAME = ry.NAME, ICO = icon, RYMOBILE = ry.MOBILE, STATE = "0"//关闭 }); } } //获得组织 //List<SYS_ORG> listMenu = oc.BllSession.ISYS_ORGService.GetListByCondition<string>(m => m.DEL_FLAG == "0", m => m.DEPT_CODE).Select(mb => mb.ToPOCO()).ToList(); List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE)) .OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList(); if (listMenu.Count > 0) { foreach (SYS_DEPT org in listMenu) { listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = org.DEPT_CODE, PARENT_CODE = org.PARENT_CODE, ORGRY_NAME = org.DEPT_NAME, ICO = org.C_ICO, RYMOBILE = "", STATE = org.STATUS_FLAG//0关闭 }); } } //List<EasyUITreeNode> listTreeNodes = SYS_DEPTANDMEMBER.ConvertTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll); List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll); strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); return(strJson); }
public static string GetCarTree_TWO(string DEPT_CODE, string PARENT_CODE, bool isCheckAll) { string strJson = string.Empty; List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>(); //获取人员 List <CAR_BDATA_CAR> listCarMenu = oc.BllSession.ICAR_BDATA_CARService.GetListByCondition <string>(m => m.DEPT_CODE.StartsWith(DEPT_CODE), m => m.CAR_NO).Select(mb => mb.ToPOCO()).ToList(); if (listCarMenu.Count > 0) { foreach (CAR_BDATA_CAR ry in listCarMenu) { listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = ry.CAR_NO, PARENT_CODE = ry.DEPT_CODE, ORGRY_NAME = ry.CAR_LICENSENO, ICO = "car-Off-line", RYMOBILE = ry.CAR_NO, STATE = "0"//关闭 }); } } //获得组织 //List<SYS_ORG> listMenu = oc.BllSession.ISYS_ORGService.GetListByCondition<string>(m => m.DEL_FLAG == "0", m => m.DEPT_CODE).Select(mb => mb.ToPOCO()).ToList(); List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE)) .OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList(); if (listMenu.Count > 0) { foreach (SYS_DEPT org in listMenu) { listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = org.DEPT_CODE, PARENT_CODE = org.PARENT_CODE, ORGRY_NAME = org.DEPT_NAME, ICO = org.C_ICO, RYMOBILE = "", STATE = org.STATUS_FLAG//0关闭 }); } } List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll); //return ObjToJson.GetToJson(listTreeNodes, true); strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); return(strJson); }
public static string GetPosLevelCheckedTree(string DEPT_CODE, string PARENT_CODE, bool isCheckAll) { string strJson = string.Empty; List <SYS_DEPTANDMEMBER_TEMP> listOrgRy = new List <SYS_DEPTANDMEMBER_TEMP>(); //获取人员 List <SYS_MEMBER> listRyMenu = oc.BllSession.ISYS_MEMBERService.GetListByCondition <string>(m => m.DEL_FLAG == "0" && m.LOCATION_FLAG == "1" && m.DEPT_CODE.StartsWith(DEPT_CODE), m => m.MOBILE) .Select(mb => mb.ToPOCO()).ToList(); //级别 List <SYS_POSLEVEL_DIC> PosLevellist = oc.BllSession.ISYS_POSLEVEL_DICService.Entities.OrderBy(u => u.DIC_ORDER).ToList(); if (listRyMenu.Count > 0) { foreach (SYS_MEMBER ry in listRyMenu) { string icon = "icon-Off-line"; if (ry.MOBILE_STATE == "1") { icon = "icon-status_busy"; } listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = ry.MOBILE, PARENT_CODE = (ry.DEPT_CODE.Length >= 4 ? ry.DEPT_CODE.Substring(0, 4) : ry.DEPT_CODE) + (!PosLevellist.Select(u => u.DIC_ID).Contains(ry.POS_LEVEL) ? "1A" : ry.POS_LEVEL), //如果没有归类(空或者在字典表不存在),则默认到其他 ORGRY_NAME = ry.NAME, ICO = icon, RYMOBILE = ry.MOBILE, STATE = "0"//关闭 }); } } //获取资质 List <SYS_DEPTANDMEMBER_TEMP> listTemp = new List <SYS_DEPTANDMEMBER_TEMP>(); List <string> parList = listOrgRy.Select(u => u.PARENT_CODE).Distinct().ToList(); if (PosLevellist.Count > 0) { foreach (string parcode in parList) { string deptcode = parcode.Substring(0, parcode.Length - 2); string diccode = parcode.Substring(parcode.Length - 2); if (PosLevellist.Where(u => u.DIC_ID.Equals(diccode)).Count() > 0) { SYS_POSLEVEL_DIC dic = PosLevellist.Where(u => u.DIC_ID.Equals(diccode)).FirstOrDefault(); listTemp.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = parcode, PARENT_CODE = deptcode, ORGRY_NAME = dic.DIC_NAME, ICO = dic.DIC_ICON, ORDER = dic.DIC_ORDER, RYMOBILE = string.Empty, //parcode, STATE = "0" //关闭 }); } } } listOrgRy.AddRange(listTemp.OrderBy(u => u.ORDER)); //获得组织 List <SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE) && m.DEPT_CODE.Length <= 4) .OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList(); if (listMenu.Count > 0) { foreach (SYS_DEPT org in listMenu) { listOrgRy.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = org.DEPT_CODE, PARENT_CODE = org.PARENT_CODE, ORGRY_NAME = org.DEPT_NAME, ICO = org.C_ICO, RYMOBILE = "", STATE = org.STATUS_FLAG//0关闭 }); } } List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listOrgRy, PARENT_CODE, DEPT_CODE, isCheckAll); strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); return(strJson); }
/// <summary> /// 获取气象监测线名树 /// </summary> /// <param name="DEPT_CODE"></param> /// <param name="PARENT_CODE"></param> /// <returns></returns> public static string GetWeatherLineTree(string DEPT_CODE, string PARENT_CODE) { Dictionary <string, string> deptDict = new Dictionary <string, string>(); if (DEPT_CODE.Length == 2) { IQueryable <SYS_DEPT> dic = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && m.DEPT_CODE.Length <= 4); foreach (var item in dic) { deptDict.Add(item.DEPT_CODE, item.DEPT_NAME); } } string strJson = string.Empty; List <SYS_DEPTANDMEMBER_TEMP> listorgHost = new List <SYS_DEPTANDMEMBER_TEMP>(); //获取主机 List <BROKENRAIL_BDATA_SECTION> listHost = oc.BllSession.IBROKENRAIL_BDATA_SECTIONService .GetListByCondition <string>(g => g.DEPT_CODE.StartsWith(DEPT_CODE), g => g.SECTION_ID).ToList(); listHost = listHost.OrderBy(o => o.START_MILE).ToList(); //cwb List <BROKENRAIL_BDATA_DEVICE> listDevice = oc.BllSession.IBROKENRAIL_BDATA_DEVICEService.Entities.Where(o => o.TYPE == "主机").ToList(); if (listHost.Count > 0) { foreach (BROKENRAIL_BDATA_SECTION host in listHost) { string head = string.Empty; if (DEPT_CODE.Length == 2) { head = deptDict[host.DEPT_CODE]; } listorgHost.Add(new SYS_DEPTANDMEMBER_TEMP { ORGRY_CODE = host.SECTION_ID, PARENT_CODE = host.LINE_NAME, ORGRY_NAME = host.SECTION_NAME, ICO = "icon-drive", RYMOBILE = head + "(" + GetToKDESC(host.START_MILE) + "~" + GetToKDESC(host.END_MILE) + ")", STATE = "0", //cwb // PHONE = host.SECTION_ID//oc.BllSession.IBROKENRAIL_BDATA_DEVICEService.Entities.Where(o => o.SECTION_ID == host.SECTION_ID && o.TYPE == "主机").FirstOrDefault().POINT_NO PHONE = listDevice.Where(o => o.SECTION_ID == host.SECTION_ID).FirstOrDefault().POINT_NO }); } } List <string> line = oc.BllSession.IBROKENRAIL_BDATA_SECTIONService.Entities.Select(o => o.LINE_NAME).Distinct().ToList(); IQueryable <T_JOB_LINE> listLineMenu = oc.BllSession.IT_JOB_LINEService.Entities.Where(o => o.LINE_DEPTCODE.Contains(DEPT_CODE)); foreach (var item in listLineMenu) { if (!line.Contains(item.LINE_NAME)) { line.Insert(line.Count, item.LINE_NAME); } } SYS_DEPT dept = oc.BllSession.ISYS_DEPTService.Entities.Where(m => m.DEL_FLAG == "0" && m.DEPT_CODE == DEPT_CODE).FirstOrDefault(); //List<SYS_DEPT> listMenu = oc.BllSession.ISYS_DEPTService.Entities // .Where(m => m.DEL_FLAG == "0" && (m.PARENT_CODE.StartsWith(DEPT_CODE) || m.DEPT_CODE == DEPT_CODE)) // .OrderBy(m => m.DEPT_ORDER).ThenBy(m => m.DEPT_CODE).ToList(); if (dept != null) { listorgHost.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = dept.DEPT_CODE, PARENT_CODE = dept.PARENT_CODE, ORGRY_NAME = dept.DEPT_NAME, ICO = "icon-DepartMent", RYMOBILE = "", STATE = "0"//0关闭 }); if (listLineMenu.Count() > 0) { foreach (var org in line) { listorgHost.Add(new SYS_DEPTANDMEMBER_TEMP() { ORGRY_CODE = org, PARENT_CODE = DEPT_CODE, ORGRY_NAME = org, ICO = "icon-DepartMent", RYMOBILE = "", STATE = "0"//0关闭 }); } } } List <ZTreeNode> listTreeNodes = SYS_DEPTANDMEMBER_TEMP.ConvertZTreeNodes(listorgHost, PARENT_CODE, DEPT_CODE, true); strJson = ObjToJson.GetToJson(listTreeNodes).Replace("Checked", "checked"); return(strJson); }