insertstock.txt

来自「< 飞鸿商品>>零售是基于VB+SQL2000开的商品零售管理」· 文本 代码 · 共 13 行

CREATE PROCEDURE dbo.InsertStock @ID varchar(20),@yaopin_ID varchar(20),
@unit varchar(20),@num int,@inprice smallmoney,@fapiao varchar(20)
  AS
Declare @Switch float
insert into ruku_list values(@id,@yaopin_id,@unit,@num,@inprice,@fapiao)
SELECT @switch=switch FROM yaopin_unit WHERE id=@yaopin_id and unit=@unit
UPDATE yaopin_num SET num=num+(@switch*@num) WHERE id=@yaopin_id
if (select count(*) from yaopin_cost where id=@yaopin_id) = 0
	insert into yaopin_cost values(@yaopin_id,@inprice/@Switch)
else
	update yaopin_cost set cost=(cost+@inprice/@switch)/2 where id=@yaopin_id
GO