SELECT i.IOrderNo,
i.IDiscount,
i.IAmount,
i.IRemark,
i.IRateId,
i.IPlatform,
i.IUserName,
i.PayTime,
i.IRefund,
i.RefundTime,
i.Req,
i.Rep,
0 AS STATUS
FROM IOrders i WITH(NOLOCK)
WHERE i.IOrderNo IS NOT NULL
AND i.IOrderNo != ''
AND i.OrderNo = @OrderNo
AND i.IAmount = (
SELECT MIN(io1.IAmount)
FROM IOrders io1
WHERE io1.orderNo = @OrderNo
AND i.IPlatform = io1.IPlatform
)
i.IDiscount,
i.IAmount,
i.IRemark,
i.IRateId,
i.IPlatform,
i.IUserName,
i.PayTime,
i.IRefund,
i.RefundTime,
i.Req,
i.Rep,
0 AS STATUS
FROM IOrders i WITH(NOLOCK)
WHERE i.IOrderNo IS NOT NULL
AND i.IOrderNo != ''
AND i.OrderNo = @OrderNo
AND i.IAmount = (
SELECT MIN(io1.IAmount)
FROM IOrders io1
WHERE io1.orderNo = @OrderNo
AND i.IPlatform = io1.IPlatform
)