INSERT INTO
eb_huifu_wallet_translog
(id,create_time,uni_id,trans_id,trans_date,card_no,card_name,bank_code
,trans_amt,fee_amt,trans_type,remark,trans_stat,trans_desc)
VALUES
(#{item.id},now(),#{item.uniId},#{item.transId},#{item.transDate}
,#{item.cardNo},#{item.cardName},#{item.bankCode}
,#{item.transAmt},#{item.feeAmt},#{item.transType},#{item.remark}
,#{item.transStat},#{item.transDesc})
UPDATE eb_huifu_wallet_translog SET update_time=NOW(),trans_stat=#{transStat} WHERE trans_date=#{transDate} AND trans_id=#{transId}