/// <summary> /// Get Users with Role /// </summary> /// <param name="role">role</param> /// <returns>array of users</returns> public static MUser[] GetWithRole(MRole role) { List <MUser> list = new List <MUser>(); String sql = "SELECT * FROM AD_User u " + "WHERE u.IsActive='Y'" + " AND EXISTS (SELECT * FROM AD_User_Roles ur " + "WHERE ur.AD_User_ID=u.AD_User_ID AND ur.AD_Role_ID=" + role.GetAD_Role_ID() + " AND ur.IsActive='Y')"; try { DataSet ds = DataBase.DB.ExecuteDataset(sql, null, null); if (ds.Tables.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { list.Add(new MUser(role.GetCtx(), dr, null)); } } } catch (Exception e) { _log.Log(Level.SEVERE, sql, e); } MUser[] retValue = new MUser[list.Count]; retValue = list.ToArray(); return(retValue); }
/// <summary> /// Role Constructor /// </summary> /// <param name="role">role</param> /// <param name="AD_Org_ID">org</param> public MRoleOrgAccess(MRole role, int AD_Org_ID) : this(role.GetCtx(), 0, role.Get_TrxName()) { SetClientOrg(role.GetAD_Client_ID(), AD_Org_ID); SetAD_Role_ID(role.GetAD_Role_ID()); }