EAS 删除单据时的反写逻辑代码

	public void actionRemove_actionPerformed(ActionEvent e) throws Exception {
		if (!(confirmRemove()))
  			return;
		
		String contractNo=this.prmtcontractNo.getValue().toString();
		String sql="UPDATE T_DUC_BreedingContract SET  CFBALANCE=0 WHERE  fnumber ='"+contractNo+"'";
		boolean exeSQL = SQLFacadeFactory.getRemoteInstance().exeSQL(sql);
		IObjectPK pk = new ObjectUuidPK(this.editData.getId());
		removeByPK(pk);
	 
	}
 public void actionRemove_actionPerformed(ActionEvent e)
    throws Exception
  {
	
		if (!(confirmRemove())) {
			return;
		}
    List ids = getSelectedIdValues();
    if ((ids != null) && (ids.size() > 0)) {
      for (int i = 0; i < ids.size(); i++)
      {
        String id = (String)ids.get(i);
        CheckOrderInfo info = CheckOrderFactory.getRemoteInstance().getCheckOrderInfo(new ObjectUuidPK(id));
        if ((info != null) && ((info.getBillStatus().equals(BillStatus.processed)) || (info.getBillStatus().equals(BillStatus.approved))))
        {
          MsgBox.showInfo("单据编号为" + info.getNumber() + "的单据已审核,不允许删除!");
          SysUtil.abort();
        }else{
            String sqlfx = "   update   T_IM_PurInWarehsEntry   set    CFISCHECKW='未检验'   where FParentID   =(select  FID  from T_IM_PurInWarehsBill where  FNumber='" + 
            info.getPurchaseOrderNumber() + "')     ";
          boolean bool = SQLFacadeFactory.getRemoteInstance().exeSQL(sqlfx);
        }
      }
    }
 
	Remove();
	saveCurrentLocation();
	refresh(e);
	restoreCurrentLocation();
  }
  

 

  • 1
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值