accountpayablemaster_delete.sql

来自「用vb.net写的基于c/s结构的进销存程序设计源代码」· SQL 代码 · 共 25 行

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