id, user_id, table_id, money_type, money_date, money_amount, money_way, year_id,
running_number, pay_state, state_time, out_trade_no, alipay_s, payout_Remarks, add_time,
edit_time, del_tag, sysPrice
operater
delete from cku_user_payList
where id = #{id,jdbcType=VARCHAR}
insert into cku_user_payList (id, user_id, table_id,
money_type, money_date, money_amount,
money_way, year_id, running_number,
pay_state, state_time, out_trade_no,
alipay_s, payout_Remarks, add_time,
edit_time, del_tag, sysPrice,
operater)
values (#{id,jdbcType=VARCHAR}, #{userId,jdbcType=VARCHAR}, #{tableId,jdbcType=INTEGER},
#{moneyType,jdbcType=VARCHAR}, #{moneyDate,jdbcType=TIMESTAMP}, #{moneyAmount,jdbcType=DECIMAL},
#{moneyWay,jdbcType=VARCHAR}, #{yearId,jdbcType=INTEGER}, #{runningNumber,jdbcType=VARCHAR},
#{payState,jdbcType=CHAR}, #{stateTime,jdbcType=TIMESTAMP}, #{outTradeNo,jdbcType=VARCHAR},
#{alipayS,jdbcType=VARCHAR}, #{payoutRemarks,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP},
#{editTime,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{sysprice,jdbcType=DECIMAL},
#{operater,jdbcType=LONGVARCHAR})
insert into payment_record
id,
member_code,
business_id,
charging_item_id,
payment_amount,
payment_way,
running_number,
payment_state,
payment_time,
out_trade_no,
alipay_s,
create_date,
update_date,
del_flag,
create_by,
update_by,
update_date,
#{id,jdbcType=VARCHAR},
#{userId,jdbcType=VARCHAR},
#{tableId,jdbcType=INTEGER},
#{moneyType,jdbcType=VARCHAR},
#{moneyAmount,jdbcType=DECIMAL},
#{moneyWay,jdbcType=VARCHAR},
#{runningNumber,jdbcType=VARCHAR},
#{payState,jdbcType=CHAR},
#{addTime,jdbcType=TIMESTAMP},
#{outTradeNo,jdbcType=VARCHAR},
#{alipayS,jdbcType=VARCHAR},
#{addTime,jdbcType=TIMESTAMP},
#{editTime,jdbcType=TIMESTAMP},
#{delTag,jdbcType=VARCHAR},
#{createBy,jdbcType=VARCHAR},
#{updateBy,jdbcType=VARCHAR},
#{addTime,jdbcType=TIMESTAMP},
update cku_user_payList
user_id = #{userId,jdbcType=VARCHAR},
table_id = #{tableId,jdbcType=INTEGER},
money_type = #{moneyType,jdbcType=VARCHAR},
money_date = #{moneyDate,jdbcType=TIMESTAMP},
money_amount = #{moneyAmount,jdbcType=DECIMAL},
money_way = #{moneyWay,jdbcType=VARCHAR},
year_id = #{yearId,jdbcType=INTEGER},
running_number = #{runningNumber,jdbcType=VARCHAR},
pay_state = #{payState,jdbcType=CHAR},
state_time = #{stateTime,jdbcType=TIMESTAMP},
out_trade_no = #{outTradeNo,jdbcType=VARCHAR},
alipay_s = #{alipayS,jdbcType=VARCHAR},
payout_Remarks = #{payoutRemarks,jdbcType=VARCHAR},
add_time = #{addTime,jdbcType=TIMESTAMP},
edit_time = #{editTime,jdbcType=TIMESTAMP},
del_tag = #{delTag,jdbcType=VARCHAR},
sysPrice = #{sysprice,jdbcType=DECIMAL},
operater = #{operater,jdbcType=LONGVARCHAR},
where id = #{id,jdbcType=VARCHAR}
update cku_user_payList
set user_id = #{userId,jdbcType=VARCHAR},
table_id = #{tableId,jdbcType=INTEGER},
money_type = #{moneyType,jdbcType=VARCHAR},
money_date = #{moneyDate,jdbcType=TIMESTAMP},
money_amount = #{moneyAmount,jdbcType=DECIMAL},
money_way = #{moneyWay,jdbcType=VARCHAR},
year_id = #{yearId,jdbcType=INTEGER},
running_number = #{runningNumber,jdbcType=VARCHAR},
pay_state = #{payState,jdbcType=CHAR},
state_time = #{stateTime,jdbcType=TIMESTAMP},
out_trade_no = #{outTradeNo,jdbcType=VARCHAR},
alipay_s = #{alipayS,jdbcType=VARCHAR},
payout_Remarks = #{payoutRemarks,jdbcType=VARCHAR},
add_time = #{addTime,jdbcType=TIMESTAMP},
edit_time = #{editTime,jdbcType=TIMESTAMP},
del_tag = #{delTag,jdbcType=VARCHAR},
sysPrice = #{sysprice,jdbcType=DECIMAL},
operater = #{operater,jdbcType=LONGVARCHAR}
where id = #{id,jdbcType=VARCHAR}
update cku_user_payList
set user_id = #{userId,jdbcType=VARCHAR},
table_id = #{tableId,jdbcType=INTEGER},
money_type = #{moneyType,jdbcType=VARCHAR},
money_date = #{moneyDate,jdbcType=TIMESTAMP},
money_amount = #{moneyAmount,jdbcType=DECIMAL},
money_way = #{moneyWay,jdbcType=VARCHAR},
year_id = #{yearId,jdbcType=INTEGER},
running_number = #{runningNumber,jdbcType=VARCHAR},
pay_state = #{payState,jdbcType=CHAR},
state_time = #{stateTime,jdbcType=TIMESTAMP},
out_trade_no = #{outTradeNo,jdbcType=VARCHAR},
alipay_s = #{alipayS,jdbcType=VARCHAR},
payout_Remarks = #{payoutRemarks,jdbcType=VARCHAR},
add_time = #{addTime,jdbcType=TIMESTAMP},
edit_time = #{editTime,jdbcType=TIMESTAMP},
del_tag = #{delTag,jdbcType=VARCHAR},
sysPrice = #{sysprice,jdbcType=DECIMAL}
where id = #{id,jdbcType=VARCHAR}