id, cku_zsid, cku_dltype, cku_dlid, cku_qz, cku_userid, cku_state, running_number, payout, add_time, edit_time, del_tag, order_price, info_Confirm, info_Confirm_time, payout_time, operate, operate_time, pay_ckuid, cku_yjType, cku_address, cku_yjPrice, dynum, cku_dytime info_Confirm_why, remark, operater select , from cku_gjdl where id = #{id,jdbcType=INTEGER} delete from cku_gjdl where id = #{id,jdbcType=INTEGER} insert into cku_gjdl (id, cku_zsid, cku_dltype, cku_dlid, cku_qz, cku_userid, cku_state, running_number, payout, add_time, edit_time, del_tag, order_price, info_Confirm, info_Confirm_time, payout_time, operate, operate_time, pay_ckuid, cku_yjType, cku_address, cku_yjPrice, dynum, cku_dytime, info_Confirm_why, remark, operater ) values (#{id,jdbcType=INTEGER}, #{ckuZsid,jdbcType=VARCHAR}, #{ckuDltype,jdbcType=VARCHAR}, #{ckuDlid,jdbcType=VARCHAR}, #{ckuQz,jdbcType=VARCHAR}, #{ckuUserid,jdbcType=VARCHAR}, #{ckuState,jdbcType=INTEGER}, #{runningNumber,jdbcType=VARCHAR}, #{payout,jdbcType=CHAR}, #{addTime,jdbcType=TIMESTAMP}, #{editTime,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{orderPrice,jdbcType=DECIMAL}, #{infoConfirm,jdbcType=CHAR}, #{infoConfirmTime,jdbcType=TIMESTAMP}, #{payoutTime,jdbcType=TIMESTAMP}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{payCkuid,jdbcType=CHAR}, #{ckuYjtype,jdbcType=VARCHAR}, #{ckuAddress,jdbcType=VARCHAR}, #{ckuYjprice,jdbcType=VARCHAR}, #{dynum,jdbcType=CHAR}, #{ckuDytime,jdbcType=TIMESTAMP}, #{infoConfirmWhy,jdbcType=LONGVARCHAR}, #{remark,jdbcType=LONGVARCHAR}, #{operater,jdbcType=LONGVARCHAR} ) insert into cku_gjdl id, cku_zsid, cku_dltype, cku_dlid, cku_qz, cku_userid, cku_state, running_number, payout, add_time, edit_time, del_tag, order_price, info_Confirm, info_Confirm_time, payout_time, operate, operate_time, pay_ckuid, cku_yjType, cku_address, cku_yjPrice, dynum, cku_dytime, info_Confirm_why, remark, operater, #{id,jdbcType=INTEGER}, #{ckuZsid,jdbcType=VARCHAR}, #{ckuDltype,jdbcType=VARCHAR}, #{ckuDlid,jdbcType=VARCHAR}, #{ckuQz,jdbcType=VARCHAR}, #{ckuUserid,jdbcType=VARCHAR}, #{ckuState,jdbcType=INTEGER}, #{runningNumber,jdbcType=VARCHAR}, #{payout,jdbcType=CHAR}, #{addTime,jdbcType=TIMESTAMP}, #{editTime,jdbcType=TIMESTAMP}, #{delTag,jdbcType=CHAR}, #{orderPrice,jdbcType=DECIMAL}, #{infoConfirm,jdbcType=CHAR}, #{infoConfirmTime,jdbcType=TIMESTAMP}, #{payoutTime,jdbcType=TIMESTAMP}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{payCkuid,jdbcType=CHAR}, #{ckuYjtype,jdbcType=VARCHAR}, #{ckuAddress,jdbcType=VARCHAR}, #{ckuYjprice,jdbcType=VARCHAR}, #{dynum,jdbcType=CHAR}, #{ckuDytime,jdbcType=TIMESTAMP}, #{infoConfirmWhy,jdbcType=LONGVARCHAR}, #{remark,jdbcType=LONGVARCHAR}, #{operater,jdbcType=LONGVARCHAR}, update cku_gjdl cku_zsid = #{ckuZsid,jdbcType=VARCHAR}, cku_dltype = #{ckuDltype,jdbcType=VARCHAR}, cku_dlid = #{ckuDlid,jdbcType=VARCHAR}, cku_qz = #{ckuQz,jdbcType=VARCHAR}, cku_userid = #{ckuUserid,jdbcType=VARCHAR}, cku_state = #{ckuState,jdbcType=INTEGER}, running_number = #{runningNumber,jdbcType=VARCHAR}, payout = #{payout,jdbcType=CHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, edit_time = #{editTime,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, order_price = #{orderPrice,jdbcType=DECIMAL}, info_Confirm = #{infoConfirm,jdbcType=CHAR}, info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP}, payout_time = #{payoutTime,jdbcType=TIMESTAMP}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, pay_ckuid = #{payCkuid,jdbcType=CHAR}, cku_yjType = #{ckuYjtype,jdbcType=VARCHAR}, cku_address = #{ckuAddress,jdbcType=VARCHAR}, cku_yjPrice = #{ckuYjprice,jdbcType=VARCHAR}, dynum = #{dynum,jdbcType=CHAR}, cku_dytime = #{ckuDytime,jdbcType=TIMESTAMP}, info_Confirm_why = #{infoConfirmWhy,jdbcType=LONGVARCHAR}, remark = #{remark,jdbcType=LONGVARCHAR}, operater = #{operater,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=INTEGER} update cku_gjdl set cku_zsid = #{ckuZsid,jdbcType=VARCHAR}, cku_dltype = #{ckuDltype,jdbcType=VARCHAR}, cku_dlid = #{ckuDlid,jdbcType=VARCHAR}, cku_qz = #{ckuQz,jdbcType=VARCHAR}, cku_userid = #{ckuUserid,jdbcType=VARCHAR}, cku_state = #{ckuState,jdbcType=INTEGER}, running_number = #{runningNumber,jdbcType=VARCHAR}, payout = #{payout,jdbcType=CHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, edit_time = #{editTime,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, order_price = #{orderPrice,jdbcType=DECIMAL}, info_Confirm = #{infoConfirm,jdbcType=CHAR}, info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP}, payout_time = #{payoutTime,jdbcType=TIMESTAMP}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, pay_ckuid = #{payCkuid,jdbcType=CHAR}, cku_yjType = #{ckuYjtype,jdbcType=VARCHAR}, cku_address = #{ckuAddress,jdbcType=VARCHAR}, cku_yjPrice = #{ckuYjprice,jdbcType=VARCHAR}, dynum = #{dynum,jdbcType=CHAR}, cku_dytime = #{ckuDytime,jdbcType=TIMESTAMP}, info_Confirm_why = #{infoConfirmWhy,jdbcType=LONGVARCHAR}, remark = #{remark,jdbcType=LONGVARCHAR}, operater = #{operater,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=INTEGER} update cku_gjdl set cku_zsid = #{ckuZsid,jdbcType=VARCHAR}, cku_dltype = #{ckuDltype,jdbcType=VARCHAR}, cku_dlid = #{ckuDlid,jdbcType=VARCHAR}, cku_qz = #{ckuQz,jdbcType=VARCHAR}, cku_userid = #{ckuUserid,jdbcType=VARCHAR}, cku_state = #{ckuState,jdbcType=INTEGER}, running_number = #{runningNumber,jdbcType=VARCHAR}, payout = #{payout,jdbcType=CHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, edit_time = #{editTime,jdbcType=TIMESTAMP}, del_tag = #{delTag,jdbcType=CHAR}, order_price = #{orderPrice,jdbcType=DECIMAL}, info_Confirm = #{infoConfirm,jdbcType=CHAR}, info_Confirm_time = #{infoConfirmTime,jdbcType=TIMESTAMP}, payout_time = #{payoutTime,jdbcType=TIMESTAMP}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, pay_ckuid = #{payCkuid,jdbcType=CHAR}, cku_yjType = #{ckuYjtype,jdbcType=VARCHAR}, cku_address = #{ckuAddress,jdbcType=VARCHAR}, cku_yjPrice = #{ckuYjprice,jdbcType=VARCHAR}, dynum = #{dynum,jdbcType=CHAR}, cku_dytime = #{ckuDytime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=INTEGER} SELECT id, cku_zsid, cku_dltype, cku_dlid, cku_qz, cku_userid, cku_state, running_number, ( CASE payout WHEN '0' THEN '未缴费' WHEN '1' THEN '已缴费' WHEN '7' THEN '业务核对中' WHEN '8' THEN '已提交' WHEN '9' THEN '提交中' END ) as payout, add_time, edit_time, del_tag, order_price, ( CASE info_Confirm WHEN '0' THEN '未审核' WHEN '1' THEN '通过' WHEN '2' THEN '未通过' WHEN '3' THEN '已注销' WHEN '4' THEN 'FCI' END ) AS info_Confirm, info_Confirm_time, payout_time, operate, operate_time, pay_ckuid, cku_yjType, cku_address, cku_yjPrice, dynum, cku_dytime, info_Confirm_why, remark, operater FROM cku_gjdl WHERE running_number =#{orderId}