【分享】SBO使用存储过程控制业务-库存收发货单据必填类型字段

declare@StoType_in nvarchar(10)

 

_declare@StoType_out nvarchar(10)

if @object_type = '59' 

begin

if @transaction_type = 'A'

    begin

       _select@StoType_in=U_StoType from OIGN T0 INNER JOIN IGN1 T1 ON T0.DocNum=T1.DocEntry where T0.DocNum=@list_of_cols_val_tab_del and T1.BaseType=-1

       begin

           if @StoType_in is null or @StoType_in=''

           begin

               _select@error = 1

               _select@error_message = N'必须录入库存收货类型'         end

           end

        end

end

else if @object_type = '60'

begin

    if @transaction_type = 'A'

    begin

       _select@StoType_out=U_StoType from OIGE T2 INNER JOIN IGN1 T3 ON T2.DocNum=T3.DocEntry where T2.DocNum=@list_of_cols_val_tab_del and T3.BaseType=-1

       begin

           if @StoType_out is null or @StoType_out=''

           begin

               _select@error = 1

              _select@error_message = N'必须录入库存发货类型'

           end

       end

    end

end

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23503339/viewspace-678459/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23503339/viewspace-678459/