岗位限制对象获取

if(jObject.containsKey(CNConsts.posteRstriction)){
if(StringUtils.isNotBlank(jObject.getString(CNConsts.posteRstriction))){
String sql = "select fid id from CT_HR_PosteRstriction where fname_l2 ='"+jObject.getString(CNConsts.posteRstriction)+"'";
IRowSet rs = DbUtil.executeQuery(ctx, sql);
try {
while(rs.next()){
String id = rs.getString("id");
if(!StringUtils.isEmpty(id)){
CoreBillBaseCustomInfo posteRstrictionInfo = new CoreBillBaseCustomInfo();
posteRstrictionInfo.setId(BOSUuid.read(id));
posteRstrictionInfo.setBOSType(new BOSObjectType("17773787"));
pInfo.put(ENConsts.posteRstriction,posteRstrictionInfo);
}
}
} catch (Exception e) {
e.printStackTrace();
}

}
}