NC65 sql查看各个部门的负责人

废话不多说，直接附上代码，如有不对之处，欢迎各位大咖留言指导！

select distinct dept.code as dept_code,
       dept.name as dept_name,
       psn.code  as psndoc_code,
       psn.name  as psndoc_name
  from sm_user u
  inner join bd_psndoc psn
    on u.pk_psndoc = psn.pk_psndoc
  inner join org_dept dept
    on psn.pk_psndoc = dept.principal
  inner join org_orgmanager manager
    on dept.pk_dept = manager.pk_dept
    and psn.pk_psndoc = manager.pk_psndoc
  where nvl(u.dr, 0) = 0
  and nvl(psn.dr, 0) = 0
  and nvl(dept.dr, 0) = 0
  and nvl(manager.dr, 0) = 0
  and nvl(u.islocked, 'N') = 'N'
  and manager.principalflag = 'Y'
  order by dept.code

可用于根据当前登录人Id判断当前登录人是否是部门负责人。

获取当前登录人Id

LoginContext context = getModel().getContext();
String userId = context.getPk_loginUser();

或者

String userId = InvocationInfoProxy.getInstance().getUserId();