accountpayablemaster_update.sql

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

CREATE TRIGGER AccountPayableMaster_Update
ON AccountPayableMaster
FOR UPDATE
AS
/* 如果修改记录数是0就结束触发程序 */ 
IF @@ROWCOUNT = 0 RETURN
/* 定义变量 
@SupplierID : 供应商编号
@NewPrepaid : 新的暂付款
@OldPrepaid : 旧的暂付款
*/
DECLARE @SupplierID Char(8)
DECLARE @NewPrepaid Decimal(12, 0), @OldPrepaid Decimal(12, 0)
/* 找出修改的供应商编号, 修改后的暂付款 */
SELECT @SupplierID = SupplierID, @NewPrepaid = Prepaid
FROM inserted
SELECT @OldPrepaid = Prepaid
FROM deleted
/*计算暂付款*/
UPDATE Supplier SET Prepaid = Prepaid + @NewPrepaid - @OldPrepaid
WHERE SupplierID = @SupplierID