UPDATE pay_voucher_bill
set
ex_pay_amt = #{voucherBillDto.exPayAmt},
ex_pay_date = #{voucherBillDto.exPayDate},
ex_agnet_business_no = #{voucherBillDto.exAgnetBusinessNo},
ex_check_no = #{voucherBillDto.exCheckNo},
ex_payee_acct_bank_name = #{voucherBillDto.exPayeeAcctBankName},
ex_payee_acct_name = #{voucherBillDto.exPayeeAcctName},
ex_payee_acct_no = #{voucherBillDto.exPayeeAcctNo},
reason = #{voucherBillDto.reason},
vt_status = #{voucherBillDto.vtStatus}
where pay_cert_no = #{voucherBillDto.payCertNo} and tenant_id = #{tendId}
update pay_voucher set
ex_pay_date = #{voucherDto.exPayDate},
ex_agnet_business_no = #{voucherDto.exAgentBusinessNo},
ex_check_no = #{voucherDto.exCheckNo},
ex_pay_amt = #{voucherDto.exPayAmt},
ex_payee_acct_bank_name = #{voucherDto.exPayeeAcctBankName},
ex_payee_acct_no = #{voucherDto.exPayeeAcctNo},
receipt_add_word = #{voucherDto.receiptAddWord},
ex_payee_acct_name = #{voucherDto.exPayeeAcctName},
vt_status = #{voucherDto.vtStatus}
where
pay_app_id =#{voucherDto.payAppId}
update pay_plan_balance set on_way_amt=on_way_amt-#{exPayAmt},used_amt=used_amt+#{exPayAmt} where
plan_balance_id=#{planBalanceId}
