id, OrderID, cku_id, pid, pcount, sp_price, total_price, sp_integral, add_time, xmid, pz_id, PayConfirm, operate, operate_time, memberid select from SP_carts where id = #{id,jdbcType=VARCHAR} delete from SP_carts where id = #{id,jdbcType=VARCHAR} insert into SP_carts (id, OrderID, cku_id, pid, pcount, sp_price, total_price, sp_integral, add_time, xmid, pz_id, PayConfirm, operate, operate_time, memberid ) values (#{id,jdbcType=VARCHAR}, #{orderid,jdbcType=VARCHAR}, #{ckuId,jdbcType=VARCHAR}, #{pid,jdbcType=VARCHAR}, #{pcount,jdbcType=INTEGER}, #{spPrice,jdbcType=DECIMAL}, #{totalPrice,jdbcType=DECIMAL}, #{spIntegral,jdbcType=INTEGER}, #{addTime,jdbcType=TIMESTAMP}, #{xmid,jdbcType=VARCHAR}, #{pzId,jdbcType=VARCHAR}, #{payconfirm,jdbcType=CHAR}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{memberid,jdbcType=VARCHAR} ) insert into payment_order_detail id, order_code, member_code, charging_item_id, num, price, total_price, sp_integral, add_time, create_date, xmid, pz_id, PayConfirm, operate, operate_time, memberid, del_flag, business_ids, business_table, business_order_code, business_name, business_id, business_refund, update_date, create_by, update_by, charging_item_name, #{id,jdbcType=VARCHAR}, #{orderid,jdbcType=VARCHAR}, #{ckuId,jdbcType=VARCHAR}, #{pid,jdbcType=VARCHAR}, #{pcount,jdbcType=INTEGER}, #{spPrice,jdbcType=DECIMAL}, #{totalPrice,jdbcType=DECIMAL}, #{spIntegral,jdbcType=INTEGER}, #{addTime,jdbcType=TIMESTAMP}, #{addTime,jdbcType=TIMESTAMP}, #{xmid,jdbcType=VARCHAR}, #{pzId,jdbcType=VARCHAR}, #{payconfirm,jdbcType=CHAR}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{memberid,jdbcType=VARCHAR}, #{delFlag,jdbcType=VARCHAR}, #{businessIds,jdbcType=VARCHAR}, #{businessTable,jdbcType=VARCHAR}, #{businessOrderCode,jdbcType=VARCHAR}, #{businessName,jdbcType=VARCHAR}, #{businessId,jdbcType=VARCHAR}, #{businessRefund,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{createBy,jdbcType=VARCHAR}, #{updateBy,jdbcType=VARCHAR}, #{chargingItemName,jdbcType=VARCHAR}, update SP_carts OrderID = #{orderid,jdbcType=VARCHAR}, cku_id = #{ckuId,jdbcType=VARCHAR}, pid = #{pid,jdbcType=VARCHAR}, pcount = #{pcount,jdbcType=INTEGER}, sp_price = #{spPrice,jdbcType=DECIMAL}, total_price = #{totalPrice,jdbcType=DECIMAL}, sp_integral = #{spIntegral,jdbcType=INTEGER}, add_time = #{addTime,jdbcType=TIMESTAMP}, xmid = #{xmid,jdbcType=VARCHAR}, pz_id = #{pzId,jdbcType=VARCHAR}, PayConfirm = #{payconfirm,jdbcType=CHAR}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, memberid = #{memberid,jdbcType=VARCHAR}, where id = #{id,jdbcType=VARCHAR} update SP_carts set OrderID = #{orderid,jdbcType=VARCHAR}, cku_id = #{ckuId,jdbcType=VARCHAR}, pid = #{pid,jdbcType=VARCHAR}, pcount = #{pcount,jdbcType=INTEGER}, sp_price = #{spPrice,jdbcType=DECIMAL}, total_price = #{totalPrice,jdbcType=DECIMAL}, sp_integral = #{spIntegral,jdbcType=INTEGER}, add_time = #{addTime,jdbcType=TIMESTAMP}, xmid = #{xmid,jdbcType=VARCHAR}, pz_id = #{pzId,jdbcType=VARCHAR}, PayConfirm = #{payconfirm,jdbcType=CHAR}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, memberid = #{memberid,jdbcType=VARCHAR} where id = #{id,jdbcType=VARCHAR} update payment_order_detail set PayConfirm = '2' where order_code = #{orderID} update payment_order_detail set del_flag = '1' where order_code = #{orderId}