【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了PurchaseMaster_Update.sql相关资料,希望对各位网友有所帮助!
CREATE TRIGGER PurchaseMaster_Update
ON dbo.PurchaseMaster
FOR UPDATE
AS
IF @@ROWCOUNT = 0 RETURN
DECLARE @PurchaseID Char(10), @PurchaseProperty Char(10)
DECLARE @Amount Decimal(12, 0)
SELECT @PurchaseID = PurchaseID, @Amount = Amount,
@PurchaseProperty = PurchaseProperty
FROM inserted
IF EXISTS(SELECT SourceID FROM VoucMaster
WHERE SourceID = @PurchaseID) AND (UPDATE(Amount))
BEGIN
RAISERROR('本张进货单已转入支票, 不可修改。', 16, 1)
ROLLBACK
RETURN
END
IF @PurchaseProperty = '1'
BEGIN
UPDATE PurchaseMaster SET AccountPayable = @Amount
WHERE PurchaseID = @PurchaseID
END
ELSE
BEGIN
UPDATE PurchaseMaster SET AccountPayable = @Amount * -1
WHERE PurchaseID = @PurchaseID
END