deliverymaster_delete.sql

用vb.net写的基于c/s结构的进销存程序设计源代码

CREATE TRIGGER DeliveryMaster_Delete
ON DeliveryMaster
FOR Delete
AS
IF @@ROWCOUNT = 0 RETURN
/*定义变量
@CustomerID : 客户编号
@AccountReceivable : 应收帐款
*/
DECLARE @CustomerID Char(10)
DECLARE @AccountReceivable Decimal(12, 0)
/*找出 客户编号, 应收帐款*/
SELECT @CustomerID = CustomerID, @AccountReceivable = AccountReceivable
FROM deleted
/*计算客户的信用额度余额*/
UPDATE Customer SET CreditBalance = CreditBalance + @AccountReceivable
WHERE CustomerID = @CustomerID