//定义字符串类型变量fzr主要任职为员工所在部门负责人//定义字符串类型变量fg兼职任职为员工所在部门负责人java.sql.Connectioncon=com.kingdee.bos.framework.ejb.EJBFactory.getConnection(__bosContext);java.sql.Statementst=con.createStatement();java.sql.ResultSetrs=null;java.sql.ResultSetrt=null;Stringtsql="selectfpersonidasfzrfromt_org_positionmemberwhereFISPRIMARY=1andFPOSITIONIDin(selectFResponPositionIDfromt_org_adminwherefid='"+bizObj.entries.adminOrgUnit.id+"')";Stringmsql="selectfpersonidasfgfromt_org_positionmemberwhereFISPRIMARY=0andFPOSITIONIDin(selectFResponPositionIDfromt_org_adminwherefid='"+bizObj.entries.adminOrgUnit.id+"')";rs=st.executeQuery(tsql);if(rs.next){fzr=rs.getString("fzr");}rt=st.executeQuery(msql);if(rt.next){fg=rt.getString("fg");}com.kingdee.util.db.SQLUtils.cleanup(st,con);com.kingdee.util.db.SQLUtils.cleanup(con);
