INSERT INTO eb_huifu_wallet_account
uni_id,
create_time,
com_name,
short_name,
hf_com_type,
com_cer_no,
license_validity_type,
license_begin_date,
license_end_date,
reg_prov_id,
reg_area_id,
reg_district_id,
reg_address,
legal_rep_name,
idcard_Type,
idcard_No,
legal_cert_validity_type,
legal_cert_begin_date,
legal_cert_end_date,
contact_name,
contact_phone,
contact_idcard_type,
contact_idcard_no,
wallet_account_no,
order_no,
license_photo,
cert_photo_a,
cert_photo_b,
pay_channel,
out_merchant_id,
#{uniId},
#{createTime},
#{comName},
#{shortName},
#{hfComType},
#{comCerNo},
#{licenseValidityType},
#{licenseBeginDate},
#{licenseEndDate},
#{regProvId},
#{regAreaId},
#{regDistrictId},
#{regAddress},
#{legalRepName},
#{idcardType},
#{idcardNo},
#{legalCertValidityType},
#{legalCertBeginDate},
#{legalCertEndDate},
#{contactName},
#{contactPhone},
#{contactIdcardType},
#{contactIdcardNo},
#{walletAccountNo},
#{orderNo},
#{licensePhoto},
#{certPhotoA},
#{certPhotoB},
#{payChannel},
#{outMerchantId},
UPDATE eb_huifu_wallet_account SET
update_time = #{updateTime},
com_name = #{comName},
short_name = #{shortName},
hf_com_type = #{hfComType},
com_cer_no = #{comCerNo},
license_validity_type = #{licenseValidityType},
license_begin_date = #{licenseBeginDate},
license_end_date = #{licenseEndDate},
reg_prov_id = #{regProvId},
reg_area_id = #{regAreaId},
reg_district_id = #{regDistrictId},
reg_address = #{regAddress},
legal_rep_name = #{legalRepName},
idcard_type = #{idcardType},
idcard_no = #{idcardNo},
legal_cert_validity_type = #{legalCertValidityType},
legal_cert_begin_date = #{legalCertBeginDate},
legal_cert_end_date = #{legalCertEndDate},
contact_name = #{contactName},
contact_phone = #{contactPhone},
contact_idcard_type = #{contactIdcardType},
contact_idcard_no = #{contactIdcardNo},
order_no = #{orderNo},
license_photo = #{licensePhoto},
cert_photo_a = #{certPhotoA},
cert_photo_b = #{certPhotoB},
fail_reason = #{failReason},
wallet_account_no = #{walletAccountNo},
out_merchant_id = #{outMerchantId},
WHERE uni_id = #{uniId} and pay_channel = #{payChannel}
UPDATE eb_huifu_wallet_account SET
update_time=#{updateTime},
hf_com_type = #{hfComType},
com_cer_no = #{comCerNo},
WHERE id = #{id}
UPDATE eb_huifu_wallet_account SET
update_time=#{updateTime},
wallet_account_no = #{walletAccountNo},
WHERE id = #{id}
UPDATE eb_huifu_wallet_account SET acct_stat = #{acctStat},update_time=NOW() WHERE id = #{id}
UPDATE eb_huifu_wallet_account SET frozen_amount = #{frozenAmount},update_time=NOW() WHERE uni_id = #{uniId}
UPDATE eb_huifu_wallet_account SET frozen_amount = #{amount},update_time=NOW() WHERE uni_id = #{uniId} AND frozen_amount = #{frozenAmount} AND pay_channel = #{payChannel}