采购限价触发器（K310.3）

最新推荐文章于 2020-11-23 09:43:34 发布

sumeing

最新推荐文章于 2020-11-23 09:43:34 发布

阅读量920

点赞数

CC 4.0 BY-SA版权

分类专栏：金蝶K3二次开发金蝶K3维护 SQL Server 文章标签： join insert

本文链接：https://blog.youkuaiyun.com/sumeing/article/details/6019759

create trigger [poorder_insert_01] on [dbo].[poorder]
for insert
as
declare @poorder_interid int
select @poorder_interid=finterid from inserted
if IF EXISTS ( SELECT 1 FROM poorder p1 inner join poorderentry p2 on
p1.finterid=p2.finterid inner join t_supplyentry t1 on
t1.supid=p1.fsupplyid
where p2.fitemid=t1.fitemid and p2.ftaxprice>t1.fprice
)
    BEGIN
        ROLLBACK TRAN
        RAISERROR('含税单价不能高于供应商报价!',18,18)
END

CREATE trigger [poorder_insert_01] on [dbo].[poorder]
for insert
as
declare @poorder_interid int
select @poorder_interid=finterid from inserted
if EXISTS ( SELECT 1 FROM poorder p1 inner join poorderentry p2 on
p1.finterid=p2.finterid inner join t_supplyentry t1 on
t1.fsupid=p1.fsupplyid
where p2.fitemid=t1.fitemid and p2.ftaxprice>t1.fprice
)
    BEGIN
        ROLLBACK TRAN
        RAISERROR('含税单价不能高于供应商报价!',18,18)
    END