金蝶s-HR-取申请人的职位、直接上级职位、间接上级职位.txt

//输入变量sqr//输出变量position申请人职位//输出变量zjsj申请人直接上级职位//输出变量jjsj申请人间接上级职位StringBuffertStrSql=newStringBuffer();StringBuffertSql=newStringBuffer();StringBufferkSql=newStringBuffer();tStrSql.append("selectFPOSITIONIDfromt_hr_emporgrelationwherefleffdt={ts'2199-12-31'}andfpersonid='"+sqr+"'andFASSIGNTYPE=1andFISINNER=1");com.kingdee.jdbc.rowset.IRowSetrowSet=com.kingdee.eas.util.app.DbUtil.executeQuery(__bosContext,tStrSql.toString());if(rowSet!=null){while(rowSet.next()){position=rowSet.getString(1);}}sql.setLength(0);tSql.append("selectfparentidfromt_org_positionwherefid='"+position+"'");com.kingdee.jdbc.rowset.IRowSetrs=com.kingdee.eas.util.app.DbUtil.executeQuery(__bosContext,tSql.toString());if(rs!=null){while(rs.next()){zjsj=rs.getString(1);}}sql.setLength(0);kSql.append("selectfparentidfromt_org_positionwherefid='"+zjsj+"'");com.kingdee.jdbc.rowset.IRowSetts=com.kingdee.eas.util.app.DbUtil.executeQuery(__bosContext,kSql.toString());if(ts!=null){while(ts.next()){jjsj=ts.getString(1);}}