工作流取某个部门某个职位的人员脚本

//新建一个内码型的变量，然后在提交节点把组织id输给adminOrgId

//定义一个参与者变量myPerformer

//把总经理改为你想要取的职位

//节点的参与人配置为变量myPerformer

java . lang . StringBuffer Sql = new java . lang . StringBuffer ( ) ;

java.lang.String mypositionID;

int i = 0 ;

Sql . append ( "select b.FID from T_ORG_ADMIN a,T_ORG_POSITION b  where  a.fid = b.fadminOrgUnitID  and  b.fname_l2 ='总经理' and   b.fadminOrgUnitID in (select a.FID from T_ORG_ADMIN a, T_ORG_BaseUnit b where a.FParentID=b.FID and  b.FID ='"+adminOrgId +"' )"); 

java . sql . Connection con = com . kingdee . bos . framework . ejb . EJBFactory . getConnection ( __bosContext ) ;

java . sql . Statement batchStatement = con . createStatement ( ) ; 

java . sql . ResultSet rst = batchStatement . executeQuery ( Sql . toString ( ) ) ; 

java.util.ArrayList tempArray =new java.util.ArrayList();

while ( rst . next ( ) ) 

  { mypositionID = rst . getString ( "FID" ) . toString ( ) ; } 

    com . kingdee . util . db . SQLUtils . cleanup ( batchStatement , con ) ; 

    com . kingdee . util . db . SQLUtils . cleanup ( con ) ; 

if(!(null == mypositionID || "".equals(mypositionID))){

com.kingdee.eas.basedata.person.app.PersonToWFAdapter adapter = new  

        com.kingdee.eas.basedata.person.app.PersonToWFAdapter();

com.kingdee.bos.workflow.participant.Person[] personList =adapter.getPositionHolders(__bosContext,mypositionID);

for(int j=0;j<personList.length;j++)

{

tempArray.add(personList[j]);

}

}

if(tempArray.size()>0)

{

myPerformer = new com.kingdee.bos.workflow.participant.Person[tempArray.size()];

for(int k=0;k<tempArray.size();k++)

{

  myPerformer[k]=tempArray.get(k);

}

}

return myPerformer;