/// <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());
}
