《采购价管理-最低限价-物料触发》由会员分享,可在线阅读,更多相关《采购价管理-最低限价-物料触发(1页珍藏版)》请在金锄头文库上搜索。
1、create trigger t_item_price on t_itemafter insertasdeclare fitemid intselect fitemid=fitemid from inserted where FItemClassID=4beginINSERT INTO t_Supply (FBrNo,FItemID,FSupID,FCurrencyID,FPOHighPrice,FPType) VALUES (0,1,160114,1,0.01,1)-UPDATE t_ICItem SET FPOHighPrice=0.01,FPOHghPrcMnyType=1 Where
2、FBrNo=0 and FItemID=fitemid-UPDATE t_ICItem SET FPriceFixingType=1 where FItemID=fitemidend- drop trigger t_item_price/*select fitemid,fnumber,fname from t_supplier where fname=限价供应商 160114select fitemid,fnumber,fname from t_icitem where fnumber=08.AAA3select FCurrencyID,FPOHighPrice,FPType,* from t
3、_supply where FItemID in (86623)select fpohighprice,FPOHghPrcMnyType,FPriceFixingType,* from t_ICItem where FItemID in (86623)delete from t_supply where FItemID=1select * from t_icitem order by fitemidselect * from t_item order by fitemidselect FCurrencyID,FPOHighPrice,FPType,* from t_supply order by fitemid*/