废话不多说,直接附上代码,如有不对之处,欢迎各位大咖留言指导!
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();