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 select , from cku_user_payList where id = #{id,jdbcType=INTEGER} SELECT top ${limit} tab.* FROM ( SELECT patList.id, patList.user_id, patList.table_id, ( CASE WHEN patList.money_type = '0' THEN '账户充值' ELSE payType.subject_name END ) money_type, patList.money_type type, patList.money_date, patList.money_amount, ( CASE WHEN patList.money_way = 'cku.org' and patList.money_type in (163,84,157 ,158,156,155,148,146,145,143,147,199,144) THEN '退费' WHEN patList.money_way = 'cku.org' THEN '余额支付' WHEN patList.money_way = '1' THEN '支付宝充值' WHEN patList.money_way = '1' THEN '支付宝充值' WHEN patList.money_way = '2' THEN '建设网银充值' WHEN patList.money_way = '6' THEN '兴业银行充值' WHEN patList.money_way = '3' THEN '现金缴纳' WHEN patList.money_way = '21' THEN '比赛现场收入' WHEN patList.money_way = '22' THEN '集中鉴定收入' WHEN patList.money_way = '4' THEN '邮局汇款' WHEN patList.money_way = '5' THEN '挂账转入' WHEN patList.money_way = '8' THEN '巡回收入' WHEN patList.money_way = '9' THEN '系统导入' WHEN patList.money_way = '10' THEN '其他会员转入' WHEN patList.money_way = '20' THEN '财务往来' ELSE '其他' END ) money_way, patList.year_id, patList.running_number, patList.pay_state, patList.state_time, patList.out_trade_no, patList.alipay_s, patList.payout_Remarks, patList.add_time FROM cku_user_paylist patList LEFT JOIN cku_user_payType payType ON patList.money_type = payType.id ) tab WHERE id NOT IN ( SELECT top ${start} pay.id FROM cku_user_paylist pay WHERE user_id = #{userId} AND money_type = '0' AND money_way = 'cku.org' AND (money_type = '0' or money_way = 'cku.org') ORDER BY id DESC ) AND type = '0' AND (money_way = '余额支付' or money_way = '退费') AND (type = '0' or money_way = '余额支付' or money_way = '退费') AND user_id = #{userId} ORDER BY id DESC delete from cku_user_payList where id = #{id,jdbcType=INTEGER} 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=INTEGER}, #{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 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, #{id,jdbcType=INTEGER}, #{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}, 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=CHAR}, sysPrice = #{sysprice,jdbcType=DECIMAL}, operater = #{operater,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=INTEGER} 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=CHAR}, sysPrice = #{sysprice,jdbcType=DECIMAL}, operater = #{operater,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=INTEGER} 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=CHAR}, sysPrice = #{sysprice,jdbcType=DECIMAL} where id = #{id,jdbcType=INTEGER} SELECT ( CASE money_way WHEN '1' THEN '支付宝充值' WHEN '2' THEN '建行网银充值' WHEN '3' THEN '现金缴纳' WHEN '4' THEN '邮局汇款' WHEN '5' THEN '挂账转入' WHEN '6' THEN '兴业银行充值' WHEN '8' THEN '巡回收入' WHEN '9' THEN '系统导入' WHEN '10' THEN '其他会员转入' WHEN '20' THEN '财务往来' WHEN '21' THEN '比赛现场收入' WHEN '22' THEN '财务往来' WHEN 'cku.org' THEN '余额支付' END ) AS moneyWay FROM cku_user_payList WHERE running_number = #{runningNumber,jdbcType=VARCHAR}