id, cku_id, username, MailAddressID, OrderID, sp_integral, SP_prices, OrderUndo, OrderUndoTime, OrderUndoType, OrderConfirm, OrderConfirmTime, PayConfirm, PayConfirmTime, PayInfo, ExpressConfirm, ExpressConfirmTime, ExpressCompany, ExpressNumber, add_time, out_trade_no, locked OrderRemarks select , from SP_OrderInfo where id = #{id,jdbcType=INTEGER} select , from SP_OrderInfo where OrderID = #{OrderID,jdbcType=VARCHAR} and cku_id = #{ckuId,jdbcType=VARCHAR} update SP_OrderInfo set PayConfirm = '1',PayConfirmTime = getdate() where OrderID = #{orderID} delete from SP_OrderInfo where id = #{id,jdbcType=INTEGER} insert into SP_OrderInfo (id, cku_id, username, MailAddressID, OrderID, sp_integral, SP_prices, OrderUndo, OrderUndoTime, OrderUndoType, OrderConfirm, OrderConfirmTime, PayConfirm, PayConfirmTime, PayInfo, ExpressConfirm, ExpressConfirmTime, ExpressCompany, ExpressNumber, add_time, out_trade_no, locked, OrderRemarks) values (#{id,jdbcType=INTEGER}, #{ckuId,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR}, #{mailaddressid,jdbcType=INTEGER}, #{orderid,jdbcType=VARCHAR}, #{spIntegral,jdbcType=INTEGER}, #{spPrices,jdbcType=DECIMAL}, #{orderundo,jdbcType=CHAR}, #{orderundotime,jdbcType=TIMESTAMP}, #{orderundotype,jdbcType=CHAR}, #{orderconfirm,jdbcType=CHAR}, #{orderconfirmtime,jdbcType=TIMESTAMP}, #{payconfirm,jdbcType=CHAR}, #{payconfirmtime,jdbcType=TIMESTAMP}, #{payinfo,jdbcType=VARCHAR}, #{expressconfirm,jdbcType=CHAR}, #{expressconfirmtime,jdbcType=TIMESTAMP}, #{expresscompany,jdbcType=VARCHAR}, #{expressnumber,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{outTradeNo,jdbcType=VARCHAR}, #{locked,jdbcType=CHAR}, #{orderremarks,jdbcType=LONGVARCHAR}) insert into SP_OrderInfo id, cku_id, username, MailAddressID, OrderID, sp_integral, SP_prices, OrderUndo, OrderUndoTime, OrderUndoType, OrderConfirm, OrderConfirmTime, PayConfirm, PayConfirmTime, PayInfo, ExpressConfirm, ExpressConfirmTime, ExpressCompany, ExpressNumber, add_time, out_trade_no, locked, OrderRemarks, #{id,jdbcType=INTEGER}, #{ckuId,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR}, #{mailaddressid,jdbcType=INTEGER}, #{orderid,jdbcType=VARCHAR}, #{spIntegral,jdbcType=INTEGER}, #{spPrices,jdbcType=DECIMAL}, #{orderundo,jdbcType=CHAR}, #{orderundotime,jdbcType=TIMESTAMP}, #{orderundotype,jdbcType=CHAR}, #{orderconfirm,jdbcType=CHAR}, #{orderconfirmtime,jdbcType=TIMESTAMP}, #{payconfirm,jdbcType=CHAR}, #{payconfirmtime,jdbcType=TIMESTAMP}, #{payinfo,jdbcType=VARCHAR}, #{expressconfirm,jdbcType=CHAR}, #{expressconfirmtime,jdbcType=TIMESTAMP}, #{expresscompany,jdbcType=VARCHAR}, #{expressnumber,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{outTradeNo,jdbcType=VARCHAR}, #{locked,jdbcType=CHAR}, #{orderremarks,jdbcType=LONGVARCHAR}, update SP_OrderInfo cku_id = #{ckuId,jdbcType=VARCHAR}, username = #{username,jdbcType=VARCHAR}, MailAddressID = #{mailaddressid,jdbcType=INTEGER}, OrderID = #{orderid,jdbcType=VARCHAR}, sp_integral = #{spIntegral,jdbcType=INTEGER}, SP_prices = #{spPrices,jdbcType=DECIMAL}, OrderUndo = #{orderundo,jdbcType=CHAR}, OrderUndoTime = #{orderundotime,jdbcType=TIMESTAMP}, OrderUndoType = #{orderundotype,jdbcType=CHAR}, OrderConfirm = #{orderconfirm,jdbcType=CHAR}, OrderConfirmTime = #{orderconfirmtime,jdbcType=TIMESTAMP}, PayConfirm = #{payconfirm,jdbcType=CHAR}, PayConfirmTime = #{payconfirmtime,jdbcType=TIMESTAMP}, PayInfo = #{payinfo,jdbcType=VARCHAR}, ExpressConfirm = #{expressconfirm,jdbcType=CHAR}, ExpressConfirmTime = #{expressconfirmtime,jdbcType=TIMESTAMP}, ExpressCompany = #{expresscompany,jdbcType=VARCHAR}, ExpressNumber = #{expressnumber,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, out_trade_no = #{outTradeNo,jdbcType=VARCHAR}, locked = #{locked,jdbcType=CHAR}, OrderRemarks = #{orderremarks,jdbcType=LONGVARCHAR}, where id = #{id,jdbcType=INTEGER} update SP_OrderInfo set cku_id = #{ckuId,jdbcType=VARCHAR}, username = #{username,jdbcType=VARCHAR}, MailAddressID = #{mailaddressid,jdbcType=INTEGER}, OrderID = #{orderid,jdbcType=VARCHAR}, sp_integral = #{spIntegral,jdbcType=INTEGER}, SP_prices = #{spPrices,jdbcType=DECIMAL}, OrderUndo = #{orderundo,jdbcType=CHAR}, OrderUndoTime = #{orderundotime,jdbcType=TIMESTAMP}, OrderUndoType = #{orderundotype,jdbcType=CHAR}, OrderConfirm = #{orderconfirm,jdbcType=CHAR}, OrderConfirmTime = #{orderconfirmtime,jdbcType=TIMESTAMP}, PayConfirm = #{payconfirm,jdbcType=CHAR}, PayConfirmTime = #{payconfirmtime,jdbcType=TIMESTAMP}, PayInfo = #{payinfo,jdbcType=VARCHAR}, ExpressConfirm = #{expressconfirm,jdbcType=CHAR}, ExpressConfirmTime = #{expressconfirmtime,jdbcType=TIMESTAMP}, ExpressCompany = #{expresscompany,jdbcType=VARCHAR}, ExpressNumber = #{expressnumber,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, out_trade_no = #{outTradeNo,jdbcType=VARCHAR}, locked = #{locked,jdbcType=CHAR}, OrderRemarks = #{orderremarks,jdbcType=LONGVARCHAR} where id = #{id,jdbcType=INTEGER} update SP_OrderInfo set cku_id = #{ckuId,jdbcType=VARCHAR}, username = #{username,jdbcType=VARCHAR}, MailAddressID = #{mailaddressid,jdbcType=INTEGER}, OrderID = #{orderid,jdbcType=VARCHAR}, sp_integral = #{spIntegral,jdbcType=INTEGER}, SP_prices = #{spPrices,jdbcType=DECIMAL}, OrderUndo = #{orderundo,jdbcType=CHAR}, OrderUndoTime = #{orderundotime,jdbcType=TIMESTAMP}, OrderUndoType = #{orderundotype,jdbcType=CHAR}, OrderConfirm = #{orderconfirm,jdbcType=CHAR}, OrderConfirmTime = #{orderconfirmtime,jdbcType=TIMESTAMP}, PayConfirm = #{payconfirm,jdbcType=CHAR}, PayConfirmTime = #{payconfirmtime,jdbcType=TIMESTAMP}, PayInfo = #{payinfo,jdbcType=VARCHAR}, ExpressConfirm = #{expressconfirm,jdbcType=CHAR}, ExpressConfirmTime = #{expressconfirmtime,jdbcType=TIMESTAMP}, ExpressCompany = #{expresscompany,jdbcType=VARCHAR}, ExpressNumber = #{expressnumber,jdbcType=VARCHAR}, add_time = #{addTime,jdbcType=TIMESTAMP}, out_trade_no = #{outTradeNo,jdbcType=VARCHAR}, locked = #{locked,jdbcType=CHAR} where id = #{id,jdbcType=INTEGER} SELECT TOP ${count} * FROM SP_OrderInfo WHERE id NOT IN ( SELECT TOP ${indexNum} id FROM SP_OrderInfo WHERE cku_id =#{ckuId} AND PayConfirm =${PayConfirm} ORDER BY PayConfirmTime DESC ) AND cku_id =#{ckuId} AND PayConfirm =${PayConfirm} ORDER BY PayConfirmTime DESC SELECT COUNT(orders.id) FROM SP_OrderInfo orders,SP_carts cart WHERE orders.OrderID=cart.OrderID AND orders.cku_id=#{ckuId} AND orders.PayConfirm=#{PayConfirm} AND cart.pid IN(45,140,141,142) select count(*) from SP_OrderInfo where cku_id=#{ckuId} AND PayConfirm='0' delete from SP_OrderInfo where OrderID = #{orderId} SELECT count(id) from SP_OrderInfo where PayConfirm='0' and cku_id=#{ckuId} SELECT count(id) from SP_OrderInfo where PayConfirm='1' and cku_id=#{ckuId}