[适用版本]

通用

[解决方案]

//请假确认单优先获取借调职位,没有则获取主要职位, 输出变量 positionid

StringBuffer tStrSql = new StringBuffer();

tStrSql.append(select FPOSITIONID from t_hr_emporgrelation where fleffdt={ts '2199-12-31'} and fpersonid='+CancelLeaveBill.entries.person.id +' and FActionTypeID in(select fid from T_HR_AffairActionReason where fname_l2='借调调入'));

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

if(rowSet!=null)

{ while(rowSet.next()){

positionid= rowSet.getString(1);

}}else{

positionid= CancelLeaveBill.entries.position.id;

}