public List <string> GetUserIDs(string userid, int level) { int deepth = 1; List <string> result = new List <string>(); var urs = urdao.Query(new User_RoleQueryForm { UserID = userid }); foreach (var ur in urs) { RescGetUserIDs(result, ur.RoleID, level, deepth); } return(result); }
public List<string> Handle(ActivityAuth auth) { List<string> result = new List<string>(); ISqlMapper mapper = Common.GetMapperFromSession(); UserBLL bll = new UserBLL(); string userid = bll.GetCurrentUser().User.ID; //string userid = "16"; RoleDao roledao = new RoleDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); string[] roleids = auth.Value.Split(','); var subroles = roledao.Query(new RoleQueryForm { ParentIDs = roleids.ToList() }); var urs = urdao.Query(new User_RoleQueryForm { UserID = userid }); var roles = subroles.FindAll(t => urs.Exists(p => p.RoleID == t.ID)); if (roles == null || roles.Count == 0) { result.Add(userid); } else { IWorkflowAuthorityHandler handler = new RoleWorkflowAuthorityHandler(); foreach (var role in roles) { if (roleids.Any(t => t == role.ParentID)) { result.AddRange(handler.Handle(new ActivityAuth { Value = role.ParentID, })); } } } return result; }
public List <string> Handle(ActivityAuth auth) { ISqlMapper mapper = Common.GetMapperFromSession(); RoleDao roledao = new RoleDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); List <string> result = new List <string>(); var role = roledao.Query(new RoleQueryForm { ID = auth.Value, IsDeleted = 0 }).FirstOrDefault(); if (role != null) { var userrole = urdao.Query(new User_RoleQueryForm { RoleID = role.ID }); if (userrole != null) { foreach (var ur in userrole) { if (!result.Contains(ur.UserID)) { result.Add(ur.UserID); } } } } return(result); }
public LoginResultForm Login(string username, string password) { LoginResultForm result = new LoginResultForm(); ISqlMapper mapper = MapperHelper.GetMapper(); UserDao userdao = new UserDao(mapper); UserInfoDao userInfoDao = new UserInfoDao(mapper); RoleDao roleDao = new RoleDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); LogonHistoryDao historyDao = new LogonHistoryDao(mapper); MenuDao menudao = new MenuDao(mapper); Menu_RoleDao mrdao = new Menu_RoleDao(mapper); var user = userdao.Query(new UserQueryForm { Name = username, Password = password }).FirstOrDefault(); if (user != null) { if (user.Enabled == 0) throw new Exception("该用户已被禁用,请联系管理员!"); string token = Guid.NewGuid().ToString().Replace("-", ""); var userinfo = userInfoDao.Query(new UserInfoQueryForm { ID = user.ID }).FirstOrDefault(); var ur = urdao.Query(new User_RoleQueryForm { UserID = user.ID }); List<string> roleidlist = new List<string>(); ur.ForEach(t => { roleidlist.Add(t.RoleID); }); var roles = roleDao.Query(new RoleQueryForm { IDs = roleidlist }); var mrs = mrdao.Query(new Menu_RoleQueryForm { RoleIDs = roleidlist }); var menuids = (from mr in mrs select mr.MenuID).Distinct().ToList(); result.Menu = menudao.Query(new MenuQueryForm { IDs = menuids, Enabled = 1 }); UserEntireInfo u = new UserEntireInfo { User = user, UserInfo = userinfo, Role = roles, }; CacheItem item = new CacheItem(token, u); LogonHistory history = new LogonHistory { LogonTime = DateTime.Now, Token = token, UserID = user.ID, ActiveTime = DateTime.Now, }; historyDao.Add(history); result.User = u; result.token = token; cache.AddItem(item, 1800); //MonitorCache.GetInstance().PushMessage(new CacheMessage { Message = "login user:"******",token:" + token }, SOAFramework.Library.CacheEnum.FormMonitor); return result; } else { throw new Exception("用户名或者密码错误!请输入正确的用户名和密码!"); } }
private void button10_Click(object sender, EventArgs e) { UserBLL bll = new UserBLL(); RoleBLL rolebll = new RoleBLL(); User_RoleDao dao = new User_RoleDao(); var urs = dao.Query(new User_RoleQueryForm { UserID = "155f1092db4043a0b9ecd62a60ffc51d" }).ToList(); var roleids = (from ur in urs select ur.RoleID).ToList(); var role = rolebll.Query(new RoleQueryForm { IDs = roleids }).ToList(); var result = rolebll.GetUserSubUserIDs("155f1092db4043a0b9ecd62a60ffc51d"); }
/// <summary> /// 获得用户角色子级下的所有用户 /// </summary> /// <param name="userid"></param> /// <returns></returns> public List <string> GetUserSubUserIDs(string userid) { UserBLL userbll = new UserBLL(); ISqlMapper mapper = Common.GetMapperFromSession(); User_RoleDao urdao = new User_RoleDao(mapper); RoleDao roledao = new RoleDao(mapper); var urs = urdao.Query(new User_RoleQueryForm { UserID = userid }); List <string> useridlist = new List <string>(); //检查用户的角色有没有全数据权限 var roles = roledao.QueryRoleByUserID(userid); foreach (var role in roles) { if (role.DataAccessType == (int)DataAccesssEnum.All) { return(null); } } useridlist.Add(userid); List <Role> list = new List <Role>(); foreach (var ur in urs) { list.AddRange(GetAllSubRoles(ur.RoleID)); } var roleids = (from r in list select r.ID).ToList(); if (roleids.Count == 0) { return(useridlist); } var users = urdao.Query(new User_RoleQueryForm { RoleIDs = roleids }); useridlist.AddRange((from u in users select u.UserID).ToList()); return(useridlist); }
/// <summary> /// 获得角色下的所有用户以及角色子级下的所有角色 /// </summary> /// <param name="roleid"></param> /// <returns></returns> public List <string> GetRoleUserIDs(string roleid) { ISqlMapper mapper = Common.GetMapperFromSession(); User_RoleDao urdao = new User_RoleDao(mapper); var roles = GetAllSubRoles(roleid); var roleids = (from r in roles select r.ID).ToList(); var urs = urdao.Query(new User_RoleQueryForm { RoleIDs = roleids }); return((from u in urs select u.UserID).ToList()); }
public List <string> Handle(ActivityAuth auth) { List <string> result = new List <string>(); ISqlMapper mapper = Common.GetMapperFromSession(); UserBLL bll = new UserBLL(); string userid = bll.GetCurrentUser().User.ID; //string userid = "16"; RoleDao roledao = new RoleDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); string[] roleids = auth.Value.Split(','); var subroles = roledao.Query(new RoleQueryForm { ParentIDs = roleids.ToList() }); var urs = urdao.Query(new User_RoleQueryForm { UserID = userid }); var roles = subroles.FindAll(t => urs.Exists(p => p.RoleID == t.ID)); if (roles == null || roles.Count == 0) { result.Add(userid); } else { IWorkflowAuthorityHandler handler = new RoleWorkflowAuthorityHandler(); foreach (var role in roles) { if (roleids.Any(t => t == role.ParentID)) { result.AddRange(handler.Handle(new ActivityAuth { Value = role.ParentID, })); } } } return(result); }
public List<string> Handle(ActivityAuth auth) { ISqlMapper mapper = Common.GetMapperFromSession(); RoleDao roledao = new RoleDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); List<string> result = new List<string>(); var role = roledao.Query(new RoleQueryForm { ID = auth.Value, IsDeleted = 0 }).FirstOrDefault(); if (role != null) { var userrole = urdao.Query(new User_RoleQueryForm { RoleID = role.ID }); if (userrole != null) { foreach (var ur in userrole) { if (!result.Contains(ur.UserID)) { result.Add(ur.UserID); } } } } return result; }
/// <summary> /// 查询所有用户 /// </summary> /// <returns></returns> public List <FullUser> Query(FullUserQueryForm form) { ISqlMapper mapper = Common.GetMapperFromSession(); FullUserDao dao = new FullUserDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); RoleDao roledao = new RoleDao(mapper); var userlist = dao.Query(form); var userids = (from u in userlist select u.ID).ToList(); var urs = urdao.Query(new User_RoleQueryForm { UserIDs = userids }); var roleids = (from ur in urs select ur.RoleID).Distinct().ToList(); var roles = roledao.Query(new RoleQueryForm { IDs = roleids }); foreach (var u in userlist) { var ur_temp = urs.FindAll(t => t.UserID == u.ID); var rolelist = (from ur in ur_temp join r in roles on ur.RoleID equals r.ID select r).ToList(); u.RoleList = rolelist; } return(userlist); }
public List <InitApprovalResultForm> Query(List <string> projectids, List <string> taskids, string currentuserid) { #region init dao List <InitApprovalResultForm> result = new List <InitApprovalResultForm>(); if (projectids == null || projectids.Count == 0) { return(new List <InitApprovalResultForm>()); } ISqlMapper mapper = Common.GetMapperFromSession(); ProjectDao dao = new ProjectDao(mapper); Customer_ProjectDao cpdao = new Customer_ProjectDao(mapper); Customer_AssetDao cadao = new Customer_AssetDao(mapper); Asset_ProjectDao apdao = new Asset_ProjectDao(mapper); WorkflowDao workflowdao = new WorkflowDao(mapper); ActivityDao activitydao = new ActivityDao(mapper); ApprovalDao appvoraldao = new ApprovalDao(mapper); TaskDao taskdao = new TaskDao(mapper); UserInfoDao uidao = new UserInfoDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); TrackingChangeOwnerDao tcodao = new TrackingChangeOwnerDao(mapper); TrackingMortgageDao tmdao = new TrackingMortgageDao(mapper); LinkDao linkdao = new LinkDao(mapper); Role_Module_ActionDao rmadao = new Role_Module_ActionDao(mapper); ReturnBackConfirmDao rbcdao = new ReturnBackConfirmDao(mapper); CreditReceiverInfoDao cridao = new CreditReceiverInfoDao(mapper); #endregion #region 查询数据 List <Customer_Project> cps = new List <Customer_Project>(); List <Customer_Asset> cas = new List <Customer_Asset>(); List <Asset_Project> aps = new List <Asset_Project>(); List <Activity> activities = new List <Activity>(); List <Approval> approvals = new List <Approval>(); List <Task> tasks = new List <Task>(); List <TrackingChangeOwner> tco = new List <TrackingChangeOwner>(); List <TrackingMortgage> tm = new List <TrackingMortgage>(); List <string> projectidlist = new List <string>(); List <string> workflowids = new List <string>(); List <CreditReceiverInfo> criList = new List <CreditReceiverInfo>(); List <Link> links = new List <Link>(); List <ReturnBackConfirm> returnBackMoneyInfo = new List <ReturnBackConfirm>(); List <Workflow> workflows = null; List <Project> list = null; var rma = rmadao.Query(new Role_Module_ActionQueryForm { }); if (taskids != null && taskids.Count > 0) { tasks = taskdao.Query(new TaskQueryForm { IDs = taskids }); workflowids = (from t in tasks select t.WorkflowID).Distinct().ToList(); workflows = workflowdao.Query(new WorkflowQueryForm { IDs = workflowids }); activities = activitydao.Query(new ActivityQueryForm { WorkflowIDs = workflowids }); approvals = appvoraldao.Query(new ApprovalQueryForm { WorkflowIDs = workflowids }); projectidlist = (from w in workflows select w.ProcessID).ToList(); list = dao.Query(new ProjectQueryForm { IDs = projectidlist }); } else if (projectids != null && projectids.Count > 0) { list = dao.Query(new ProjectQueryForm { IDs = projectids }); projectidlist = (from p in list select p.ID).ToList(); workflows = workflowdao.Query(new WorkflowQueryForm { ProcessIDs = projectidlist }); workflowids = (from w in workflows select w.ID).ToList(); if (workflowids.Count > 0) { activities = activitydao.Query(new ActivityQueryForm { WorkflowIDs = workflowids }); approvals = appvoraldao.Query(new ApprovalQueryForm { WorkflowIDs = workflowids }); tasks = taskdao.Query(new TaskQueryForm { WorkflowIDs = workflowids }); } } else { return(result); } if (projectidlist.Count > 0) { cps = cpdao.Query(new Customer_ProjectQueryForm { ProjectIDs = projectidlist }); cas = cadao.Query(new Customer_AssetQueryForm { ProjectIDs = projectidlist }); aps = apdao.Query(new Asset_ProjectQueryForm { ProjectIDs = projectidlist }); } var users = uidao.Query(new UserInfoQueryForm { }); var userroles = urdao.Query(new User_RoleQueryForm { }); criList = cridao.Query(new CreditReceiverInfoQueryForm { ProjectIDs = projectids }); tco = tcodao.Query(new TrackingChangeOwnerQueryForm { ProjectIDs = projectidlist }); tm = tmdao.Query(new TrackingMortgageQueryForm { ProjectIDs = projectidlist }); returnBackMoneyInfo = rbcdao.Query(new ReturnBackConfirmQueryForm { ProjectIDs = projectidlist }); //从缓存中取得 var customers = TableCacheHelper.GetDataFromCache <Customer>(typeof(CustomerDao)); var assets = TableCacheHelper.GetDataFromCache <Asset>(typeof(AssetDao)); #endregion #region 处理废单权限 //处理废单权限 var hasDisplayDiscard = (from ur in userroles join r in rma on ur.RoleID equals r.RoleID where r.ModuleID == "4" && r.ActionID == "4" && ur.UserID == currentuserid select r).FirstOrDefault(); #endregion foreach (Project project in list) { var data = QueryDetail(project, customers, assets, cps, cas, aps, workflows, activities, approvals, tasks, users, userroles, tco, tm, returnBackMoneyInfo, criList, currentuserid); if (hasDisplayDiscard != null) { data.DisplayDiscard = true; } result.Add(data); } return(result); }
public List<FullUser> Query(FullUserQueryForm form) { ISqlMapper mapper = MapperHelper.GetMapper(); UserDao dao = new UserDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); RoleDao roledao = new RoleDao(mapper); var users = dao.QueryFullUser(form); var userids = (from u in users select u.ID).ToList(); var urs = urdao.Query(new User_RoleQueryForm { UserIDs = userids }); var roleids = (from ur in urs select ur.RoleID).Distinct().ToList(); var roles = roledao.Query(new RoleQueryForm { IDs = roleids }); foreach (var u in users) { u.Roles = (from ur in urs join role in roles on ur.RoleID equals role.ID where ur.UserID.Equals(u.ID) select role).ToList(); } return users; }
/// <summary> /// 查询所有用户 /// </summary> /// <returns></returns> public List<FullUser> Query(FullUserQueryForm form) { ISqlMapper mapper = Common.GetMapperFromSession(); FullUserDao dao = new FullUserDao(mapper); User_RoleDao urdao = new User_RoleDao(mapper); RoleDao roledao = new RoleDao(mapper); var userlist = dao.Query(form); var userids = (from u in userlist select u.ID).ToList(); var urs = urdao.Query(new User_RoleQueryForm { UserIDs = userids }); var roleids = (from ur in urs select ur.RoleID).Distinct().ToList(); var roles = roledao.Query(new RoleQueryForm { IDs = roleids }); foreach (var u in userlist) { var ur_temp = urs.FindAll(t => t.UserID == u.ID); var rolelist = (from ur in ur_temp join r in roles on ur.RoleID equals r.ID select r).ToList(); u.RoleList = rolelist; } return userlist; }
/// <summary> /// 获得角色下的所有用户以及角色子级下的所有角色 /// </summary> /// <param name="roleid"></param> /// <returns></returns> public List<string> GetRoleUserIDs(string roleid) { ISqlMapper mapper = MapperHelper.GetMapper(); User_RoleDao urdao = new User_RoleDao(mapper); var roles = GetAllSubRoles(roleid); var roleids = (from r in roles select r.ID).ToList(); var urs = urdao.Query(new User_RoleQueryForm { RoleIDs = roleids }); return (from u in urs select u.UserID).ToList(); }
/// <summary> /// 获得用户角色子级下的所有用户 /// </summary> /// <param name="userid"></param> /// <returns></returns> public List<string> GetUserSubUserIDs(string userid) { UserBLL userbll = new UserBLL(); ISqlMapper mapper = MapperHelper.GetMapper(); User_RoleDao urdao = new User_RoleDao(mapper); RoleDao roledao = new RoleDao(mapper); var urs = urdao.Query(new User_RoleQueryForm { UserID = userid }); List<string> useridlist = new List<string>(); //检查用户的角色有没有全数据权限 var roles = roledao.QueryRoleByUserID(userid); foreach (var role in roles) { if (role.DataAccessType == (int)DataAccesssEnum.All) return null; } useridlist.Add(userid); List<Role> list = new List<Role>(); foreach (var ur in urs) { list.AddRange(GetAllSubRoles(ur.RoleID)); } var roleids = (from r in list select r.ID).ToList(); if (roleids.Count == 0) return useridlist; var users = urdao.Query(new User_RoleQueryForm { RoleIDs = roleids }); useridlist.AddRange((from u in users select u.UserID).ToList()); return useridlist; }