2021-01-26

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}