EAS工作流脚本

EAS工作流中需要修改单据状态值,不需要自动节点,通过脚本直接完成.

com.kingdee.eas.scm.cal.CostAdjustBillInfo info=com.kingdee.eas.scm.cal.CostAdjustBillFactory.getLocalInstance(__bosContext).getCostAdjustBillInfo(new com.kingdee.bos.dao.ormapping.ObjectUuidPK(billID)); com.kingdee.eas.scm.cal.CostAdjustBillEntryCollection col=info.get("entry"); companyid=col.get(0).getCompanyOrgUnit().getId(); auditAfterSubmit = com.kingdee.eas.scm.common.app.SCMServerUtils. isAuditWhenSubmit( __bosContext , storageid.toString ( ),4,"410" ) ; getVoucherAfterAudit = com.kingdee.eas.scm.common.app.SCMServerUtils. isVoucherWhenAudit( __bosContext , companyid.toString ( ),"410") ;

 

 

 

com.kingdee.eas.mx.imp.ipo.ImpPurContractSelfInfo info = com.kingdee.eas.mx.imp.ipo.ImpPurContractSelfFactory.getLocalInstance(__bosContext).getImpPurContractSelfInfo( new com.kingdee.bos.dao.ormapping.ObjectUuidPK(com.kingdee.bos.util.BOSUuid.read(billID)));

info.setState(info.getState().auditing);

com.kingdee.eas.framework.CoreBaseCollection cbColl = new com.kingdee.eas.framework.CoreBaseCollection();

cbColl.add(info);

com.kingdee.eas.mx.imp.ipo.ImpPurContractSelfFactory.getLocalInstance(__bosContext).update(new com.kingdee.bos.dao.ormapping.ObjectUuidPK(com.kingdee.bos.util.BOSUuid.read(billID)),info);

com.kingdee.eas.mx.imp.WorkFlowFacadeFactory.getLocalInstance(__bosContext).setState(billID,null.creator.id,"4");

 

 

上面两个都是别人写的没测试过，下面这个经过了工作流里的测试。

 

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

sql = "update t_ap_payrequestbill set fauditorid='" + auditorId . toString ( ) + "'  where fid='" + billid . toString ( ) + "'" ;

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

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

  batchStatement . execute ( sql . toString ( ) ) ;

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

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

 

 

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

sql = "/*dialect*/update CT_STU_AODOrder set CFCheckdate=to_timestamp('" + auditorDate + "','yyyy-mm-dd hh24:mi:ss.ff')  where fid='" + billID . toString ( ) + "'" ;

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

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

  batchStatement . execute ( sql . toString ( ) ) ;

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

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