远程订单提示信息传输的思想

1、通过控制总量，多次传送的之和。
2、一次批量发送就把信息表传给总厂，包括本次的发送条件
3、总厂通过
DECLARE @OrderCon varchar(300), @OrderCons varchar(500), @Orderstr varchar(550)
SET @OrderCons = '' DECLARE MyCursor CURSOR FOR
          (SELECT OrderCon
         FROM TBL_OrderConfirm
         WHERE IsConfirmed = 0)
        
         OPEN MyCursor
         FETCH Next FROM MyCursor  INTO @OrderCon
While(@@Fetch_Status = 0)
BEGIN
    IF (@OrderCons != '')
    Begin
        SET @OrderCons = @OrderCons + 'OR'
    End
    SET @OrderCons =  @OrderCons + @OrderCon
    FETCH Next FROM MyCursor INTO @OrderCon
END
CLOSE myCursor DEALLOCATE myCursor
SET @Orderstr = 'SELECT COUNT(*) AS A_Count FROM Tbl_order WHERE Isdelete = 0 AND IsConfirmed = 1 AND IsPrint = 0 AND OrderNo IS NOT NULL AND DeliveryWay = 1
AND ( '+ @OrderCons + ' ) ' print @Orderstr
EXEC (@Orderstr)
获取本次发送的补单数，当然如果没有存在IsConfirmed = 0的值，运行本语句将出错（不管此原因因为IsConfirmed 值的改变只有在全部订单都确认后再更改的）。