public static SysUserGroupCollection get_Groups(SysUser _user)
{
SysUserGroup grp = new SysUserGroup();
SysUserSysUserGroup sugrp = new SysUserSysUserGroup();
SysUserGroupCollection result = new SysUserGroupCollection();
string sql = "SELECT grp.* FROM " + grp.get_table() + " AS grp";
sql += " INNER JOIN " + sugrp.get_table() + " AS sugrp";
sql += " ON grp.id = sugrp.sysuser_group_id";
sql += " WHERE sugrp.sysuser_id = @sysuser_id";
grp.query.AddParameter("@sysuser_id", _user.id);
DataTable dt = grp.query.get_DataTable(sql);
foreach (DataRow row in dt.Rows)
{
grp = new SysUserGroup();
grp.LoadBy_array(row);
result.Add(grp);
}
return(result);
}
public bool BelongsToGroup(SysUserGroup _group)
{
return(groups.Contains(_group));
}