@Override
public void doAction(IBusinessEvent arg0) throws BusinessException {
// TODO 自动生成的方法存根
BusinessEvent be = (BusinessEvent) arg0;
AggregatedValueObject[] values = (AggregatedValueObject[]) be.getObject();
AggPayableBillVO[] aggvos = new AggPayableBillVO[values.length];
for(int i=0;i<values.length;i++){
aggvos[i] = (AggPayableBillVO) values[i];
}
for(AggPayableBillVO aggvo : aggvos){
PayableBillVO hvo = aggvo.getHeadVO();
String def70 = hvo.getDef70();//机场合同主键
Integer approvestatus = hvo.getApprovestatus();//审批状态
String pk_payablebill = hvo.getPk_payablebill();//应付单主键
int effectstatus = hvo.getEffectstatus();//是否生效
if(approvestatus!=1&&effectstatus==0){//不是通过态删除vo
deleteJchtCvo(def70,pk_payablebill);
}
}
}
/**
* 删除回写信息
* @param def70
* @param pk_payablebill
*/
private void deleteJchtCvo(String def70, String pk_payablebill) {
String sql = " delete from xsjc_jchtmanage_c where pk_jchtmanage='"+def70+"' and vbdef1='"+pk_payablebill+"'; ";
StringBuffer sb = new StringBuffer();
sb.append(sql);
BaseDAO dao = new BaseDAO(dataSource);
try {
dao.executeUpdate(sb.toString());
dao.executeUpdate("commit");
} catch (DAOException e) {
e.printStackTrace();
}
}
1.节点位置: