豬的全部 .Jacky

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[up_tb_WD_uporadd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[up_tb_WD_uporadd]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

create   procedure  up_tb_WD_uporadd
@warehouseID bigint,
@productID bigint,
@amount bigint
as
declare @quantity int
declare @count int

select @count=count(*) from tb_WarehouseDetails where productID=@productID and warehouseID=@warehouseID

if(@count>0)
   begin
  
      select @quantity=quantity from  tb_WarehouseDetails where productID=@productID and warehouseID=@warehouseID

      select @quantity=@quantity+@amount

      update tb_WarehouseDetails set quantity=@quantity where productID=@productID and warehouseID=@warehouseID

   end
else
   begin
      insert into tb_WarehouseDetails
      ([quantity],[productID],[warehouseID])
      values(@amount,@productID,@warehouseID)
   end
go