declare @dingdanid int declare @fanhuizhi int

set @dingdanid = 1

exec 检测订单出库资格 @dingdanid ,@fanhuizhi output   (注意别忘了output否则返回值是NULL)

select @fanhuizhi

 

 

create proc dbo.检测订单出库资格

@dingdanID int,     @returnValue int output

as

 

-- 输入变量 订单编号

set @returnValue = 1

-- 监测订单的出库资格

-- 如果已出库，返回0

-- 如果未出库并且该订单所属的总成需求量均小于等于库存，即满足出库状态,返回1e;否则返回0

 

if '已出库' = (select 订单状态 from 订单1 where 订单编号 = @dingdanID)

begin

   set @returnValue = 0

   return @returnValue

end

 

 declare @zongchengID nvarchar(50)

 declare @chazhi      int

DECLARE Employee_Cursor CURSOR FOR select 订单2.总成编号,(库存量- sum(订单2.需求数量)) as 差值  from 订单2 , 总成表  where 订单编号 and 订单2.总成编号 = 总成表.总成编号  group by 订单2.总成编号,库存量 OPEN Employee_Cursor

FETCH NEXT FROM Employee_Cursor into  @zongchengID,@chazhi

WHILE @@FETCH_STATUS = 0 BEGIN

    if(@chazhi <0 )

    begin     set @returnValue = 0    

    return @returnValue   

    break

    end

    FETCH NEXT FROM Employee_Cursor into  @zongchengID,@chazhi END

    CLOSE Employee_Cursor

    DEALLOCATE Employee_Cursor

   return @returnValue