jeecg当前登录人信息

  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 = '' ;

 

posted @ 2020-02-20 16:22  薛柏梁  阅读(690)  评论(0编辑  收藏  举报