TSUser user = ResourceUtil.getSessionUser();
String departid = user.getDepartid();
TSDepart tsDepart = systemService.getEntity(TSDepart.class, departid);
String sysOrgCode = tsDepart.getOrgCode();
select a.username,a.realname,c.org_code,c.departname,rolecode,rolename
from t_s_base_user a
left join t_s_user_org b on (a.id = b.user_id)
left join t_s_depart c on (b.org_id = c.id)
left join t_s_role_user d on (a.id = d.userid)
left join t_s_role f on (d.roleid = f.id)
where f.rolecode = ''
and c.org_code = ''
and a.username = '' ;