请问:
我在K3单据自定义单据的领料单上加入了“销售单”一列,通过触发器将“销售单号”自动添加到“领料”单。
现有一个问题,就是要保存单据的时候才能触发。请问能否在选单的时候就带过来呢?就如:输入物料编号,自动会带出物料名称来一样。
create trigger [test]
on [dbo].[ICStockBill]
for insert,update,delete
as
set nocount on
declare @ftrantype int
select @ftrantype=ftrantype from inserted
if (@Ftrantype=24)
begin
update icstockbillentry
set fentryselfb0447=t5.fbillno
from inserted as t1
join icstockbillentry as t2 on t2.finterid=t1.finterid
join icstockbill as t3 on t2.finterid=t3.finterid
join icmo as t4 on t4.finterid=t2.ficmointerid
join seorder as t5 on t5.finterid=t4.forderinterid
return
end
|