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,
wallet_account_no,
#{uniId},
#{createTime},
#{comName},
#{shortName},
#{hfComType},
#{comCerNo},
#{licenseValidityType},
#{licenseBeginDate},
#{licenseEndDate},
#{regProvId},
#{regAreaId},
#{regDistrictId},
#{regAddress},
#{legalRepName},
#{idcardType},
#{idcardNo},
#{legalCertValidityType},
#{legalCertBeginDate},
#{legalCertEndDate},
#{contactName},
#{contactPhone},
#{walletAccountNo},
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},
WHERE uni_id = #{uniId} AND acct_stat = 'N'
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 = (frozen_amount+#{amount}),update_time=NOW() WHERE uni_id = #{uniId}