--7.订单
------------------------------------------------------------------------------------------------
--清空记录
set @sdnum=0
select @sdnum=max(id) from sfa_p_PMonOrderAdd_temp
WHILE (@sdnum>0)
BEGIN
DECLARE
@Guid nvarchar(50),
@ProductID int,
@OrderCount varchar(10),--int,
@Price varchar(10), --decimal(18, 2)=0,
@OrderCountUnit varchar(10),
@UserNumber int,
@VisitDate datetime ,
@StoreContact VARCHAR(50),
@StoreContactTel VARCHAR(50),
@Distributorid INT,
@SMSState INT, --订单详细搭赠产品id
@SMSConteng VARCHAR(500), --搭赠数量(瓶)
@CallDuration INT,
@GiveNumer varchar(10), --赠送数量 (箱)
@isplaned VARCHAR(10) --线内线外 1线内 2 线外 3KA订单
SELECT @UserNumber=UserNumber,
@Guid =Guid,
@ProductID=ProductID,
@OrderCount=OrderCount,
@Price=Price,
@OrderCountUnit=OrderCountUnit,
@VisitDate=VisitDate,
@StoreContact=StoreContact,
@StoreContactTel=StoreContactTel,
@Distributorid=Distributorid,
@SMSState=SMSState, --订单详细搭赠产品id
@SMSConteng=SMSConteng, --搭赠数量(瓶)
@CallDuration=CallDuration,
@GiveNumer=GiveNumer, --赠送数量 (箱)
@isplaned=isplaned
FROM sfa_p_PMonOrderAdd_temp where id =@sdnum
EXEC sfa_p_PMonOrderAdd_01
@Guid ,
@ProductID ,
@OrderCount ,
@Price ,
@OrderCountUnit ,
@UserNumber,
@VisitDate,
@StoreContact ,
@StoreContactTel,
@Distributorid ,
@SMSState ,
@SMSConteng,
@CallDuration ,
@GiveNumer ,
@isplaned
delete from sfa_p_PMonOrderAdd_temp where id =@sdnum
set @sdnum=@sdnum-1;
END