accountreceivablemaster_update.sql

来自「通用进销存-visual basic编写」· SQL 代码 · 共 29 行

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