/// <summary> /// 指定部门是否为我的后代 /// </summary> /// <param name="dep">指定部门</param> /// <param name="recursion">是否递归判断后代,默认为true,只找下一代为false</param> /// <returns></returns> public static bool IsMyChildren(this int thisDep, int depId, bool recursion = true) { int parentId = DepartmentLogic.GetInstance().GetDepartmentParentId(depId); if (parentId > 0) { if (parentId == thisDep) //dep=1.2,this=1 { return(true); //dep.parent=1 } if (recursion) //dep=1.2.3 { return(thisDep.IsMyChildren(parentId, true)); //dep=1.2.3,this=1.2 } } return(false); }
public static List <int> GetDepartmentIds(string deps, DepartmentLogic dl = null) { List <int> depts = new List <int>(); string[] ids = deps.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (dl == null) { dl = DepartmentLogic.GetInstance(); } foreach (string id in ids) { int I; if (int.TryParse(id, out I)) { depts.Add(I); } } return(depts); }
public List <User> GetAllUsers() { List <User> users = new List <User>(); string sql = "select * from [User]"; DataTable dt = sqlHelper.Query(sql); if (dt != null && dt.Rows.Count > 0) { DepartmentLogic dl = DepartmentLogic.GetInstance(); RoleLogic rl = RoleLogic.GetInstance(); UserGroupLogic ul = UserGroupLogic.GetInstance(); for (int i = 0; i < dt.Rows.Count; i++) { User user = new User(); user.ID = Convert.ToInt32(dt.Rows[i]["ID"]); user.Username = dt.Rows[i]["Username"].ToString(); user.Departments = Common.GetDepartments(dt.Rows[i]["Depart"].ToString(), dl); user.Flag = Convert.ToInt32(dt.Rows[i]["Flag"]); if (dt.Rows[i]["Password"] != null && dt.Rows[i]["Password"] != DBNull.Value) { user.Password = dt.Rows[i]["Password"].ToString(); } else { user.Password = ""; } if (dt.Rows[i]["Roles"] != null && dt.Rows[i]["Roles"] != DBNull.Value) { user.Roles = Common.GetRoles(dt.Rows[i]["Roles"].ToString(), rl); } if (dt.Rows[i]["Usergroup"] != null && dt.Rows[i]["Usergroup"] != DBNull.Value) { user.Usergroups = Common.GetUserGroups(dt.Rows[i]["Usergroup"].ToString(), ul); } if (dt.Rows[i]["Remark"] != null && dt.Rows[i]["Remark"] != DBNull.Value) { user.Remark = dt.Rows[i]["Remark"].ToString(); } users.Add(user); } } return(users); }