accountreceivablemaster_delete.sql

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

CREATE TRIGGER AccountReceivableMaster_Delete
ON AccountReceivableMaster
FOR DELETE
AS
/* 如果修改记录数是0就结束触发程序 */ 
IF @@ROWCOUNT = 0 RETURN
/* 定义变量 
@CustomerID : 客户编号
@Advance : 暂收款
*/
DECLARE @CustomerID Char(8)
DECLARE @Advance Decimal(12, 0)
/* 找出修改客户编号, 暂收款 */
SELECT @CustomerID = CustomerID, @Advance = Advance
FROM deleted
/*计算暂收款*/
UPDATE Customer SET Advance = Advance - @Advance
WHERE CustomerID = @CustomerID