[适用版本]

8.6sp1,2021H1

[分析处理]

问题:根据职员id获取职务类

处理方案:自定义工作流脚本处理,参考脚本如下

//输入变量:personid是职员id 

//输出变量:JobCateName职层名称

StringBuffer tStrSql = new StringBuffer();  

tStrSql.append(select fname_l2 from T_HR_HRJobCategory where fid in(select FHRJOBCATEGORYID from T_HR_hrjob where fid in(select FHRJOBID from  t_hr_positionextend where FPOSITIONID in (select FPOSITIONID  from T_org_positionmember where fpersonid ='+ personid +' and FISPRIMARY =1))));

com.kingdee.jdbc.rowset.IRowSet rowSet = com.kingdee.eas.util.app.DbUtil.executeQuery(__bosContext,tStrSql.toString());

if(rowSet!=null)

{

 while(rowSet.next()){

JobCateName= rowSet.getString(1);

 }

}