22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER t_ReGoods ON dbo.tb_ReGoods
FOR INSERT,UPDATE
AS
UPDATE tb_Stock SET tb_Stock.StockNum = tb_Stock.StockNum+INSERTED.ReGoodsNum
,tb_Stock.NeedPay= tb_Stock.NeedPay+ INSERTED.ReGoodsNum*tb_Stock.GoodsPrice
,tb_Stock.HasPay=tb_Stock.HasPay+INSERTED.ReGoodsNum*tb_Stock.GoodsPrice
FROM INSERTED,tb_Stock
WHERE tb_Stock.GoodsID = INSERTED.GoodsID AND INSERTED.ReGoodsSort = 1
UPDATE tb_Sell SET tb_Sell.GoodsNum= tb_sell.GoodsNum-INSERTED.ReGoodsNum
,HasPay= tb_Sell.HasPay-INSERTED.ReGoodsNum*INSERTED.ReGoodsPrice
,NeedPay = tb_Sell.NeedPay-INSERTED.ReGoodsNum*INSERTED.ReGoodsPrice
FROM INSERTED,tb_Sell
WHERE tb_Sell.GoodsID = INSERTED.GoodsID AND INSERTED.ReGoodsSort = 1