insertPaylog
===
    INSERT INTO `xzx_pay_request_log`
    (`id`, `user_id`, `money`, `create_time`, `pay_status`, `wx_openid`, `account_before_money`, `account_id`, `request_params`) 
    VALUES (#id#, #userId#, #money#, #createTime#, #payStatus#, #wxOpenid#, #accountBeforeMoney#, #accountId#, #requestParams#);

updatePaylogResponseData
===
    update `xzx_pay_request_log` set response_data=#responseData#, pay_status=#payStatus# where id=#id#

updateAccountMoney
===
    update `xzx_account_info` set money=money-#money#
     where account_id=#accountId# 

updateAccountMoneyDouble
===
    update `xzx_account_info` set money=#money#
     where account_id=#accountId# 
          
updatePaylogMoney
===
    update `xzx_pay_request_log` set account_after_money=#accountAfterMoney#
       , pay_status=#payStatus# where id=#id#

updatePaylogRemark
===
    update `xzx_pay_request_log` set remark=#remark# where id=#id#

insertMessage
===
    insert into xzx_sys_message (message, user_id, mobile_phone, create_time, create_user_id, message_type, message_sub_type_name,flag)
         values (
            #message#, #userId#, #mobilePhone#, #createTime#, #userId#, #messageType#, #messageSubTypeName#,2
         )

addReason
===
    update `xzx_pay_request_info` set status=3,unpass_reason=#reason# where pay_order_id=#payOrderId#  


insertAccountLog
===
    insert into xzx_account_log (account_id, old_money, new_money, old_limit, new_limit, old_fixed_limit, new_fixed_limit,create_user_id,create_time,channel_type,order_id)
         values (
            #accountId#, #oldMoney#, #newMoney#, #oldLimit#, #newLimit#, #oldFixedLimit#, #newFixedLimit#,#createUserId#,#createTime#,#channelType#,#orderId#
         )         
             
queryPAccountByAccountId
===
    select * from xzx_partner_account where account=#accountId# and del_flag=0