INSERT INTO eb_huifu_wallet_trade create_time, amount, business_partner_seq, business_code, expend_account_no, income_account_no, req_seq_id, hf_seq_id, trans_finish_time, trade_type, trade_status, good_desc, remark, uni_id, error_msg, #{createTime}, #{amount}, #{businessPartnerSeq}, #{businessCode}, #{expendAccountNo}, #{incomeAccountNo}, #{reqSeqId}, #{hfSeqId}, #{transFinishTime}, #{tradeType}, #{tradeStatus}, #{goodDesc}, #{remark}, #{uniId}, #{errorMsg}, UPDATE eb_huifu_wallet_trade SET update_time=#{updateTime}, trans_finish_time=#{transFinishTime}, trade_status = #{tradeStatus}, bank_trade_no = #{bankTradeNo}, error_msg = #{errorMsg}, WHERE id = #{id} SELECT id, create_time createTime, amount, business_partner_seq businessPartnerSeq, business_code businessCode, trade_type tradeType, trade_status tradeStatus, error_msg errorMsg, uni_id uniId FROM eb_huifu_wallet_trade WHERE id = #{id} SELECT id, create_time createTime, amount, business_partner_seq businessPartnerSeq, business_code businessCode, req_seq_id reqSeqId, hf_seq_id hfSeqId, expend_account_no expendAccountNo, income_account_no incomeAccountNo, good_desc goodDesc, remark, trans_finish_time transFinishTime, trade_type tradeType, trade_status tradeStatus, error_msg errorMsg, uni_id uniId FROM eb_huifu_wallet_trade WHERE hf_seq_id = #{hfSeqId} SELECT b.wallet_account_no accountNo, a.hf_seq_id hfSeqId, date_format(trans_finish_time, '%Y%m%d') AS tradeDate FROM eb_huifu_wallet_trade a, eb_huifu_wallet_account b WHERE a.uni_id = b.uni_id and length(a.hf_seq_id)>0 and length(a.expend_account_no)>0 and length(a.income_account_no)>0 and NOT EXISTS(SELECT 1 FROM eb_huifu_wallet_account_detail WHERE trade_flow_no = a.hf_seq_id) SELECT count(1) FROM eb_huifu_wallet_trade WHERE business_partner_seq = #{businessPartnerSeq} AND trade_type = #{tradeType} AND trade_status='1' SELECT count(1) FROM eb_huifu_wallet_trade WHERE (business_partner_seq in (SELECT order_no FROM eb_order WHERE plat_order_no=#{businessPartnerSeq}) OR business_partner_seq = (SELECT plat_order_no FROM eb_order WHERE order_no=#{businessPartnerSeq})) AND trade_type = #{tradeType} AND trade_status='1' SELECT count(1) FROM eb_huifu_wallet_trade WHERE (business_partner_seq in (SELECT CONCAT(order_no,'-P',#{sellFeePriority}) FROM eb_order WHERE plat_order_no=#{businessPartnerSeq}) OR business_partner_seq = (SELECT CONCAT(plat_order_no,'-P',#{sellFeePriority}) FROM eb_order WHERE order_no=#{businessPartnerSeq})) AND trade_type = #{tradeType} AND trade_status='1' SELECT id, create_time createTime, amount, req_seq_id reqSeqId, hf_seq_id hfSeqId, business_partner_seq businessPartnerSeq, business_code businessCode, trade_type tradeType, trade_status tradeStatus, error_msg errorMsg, uni_id uniId FROM eb_huifu_wallet_trade WHERE 1=1 AND business_partner_seq = #{businessPartnerSeq} AND business_code = #{businessCode} SELECT id, create_time createTime, amount, business_partner_seq businessPartnerSeq, business_code businessCode, trade_type tradeType, trade_status tradeStatus, error_msg errorMsg, uni_id uniId FROM eb_huifu_wallet_trade WHERE uni_id = #{uniId} AND id = #{id} AND INSTR(comment,#{comment}) AND trade_status = #{tradeStatus}