创建触发器携带销售出库单日期和成本到关联的发票并计算毛利

--创建触发器销售发票保存的时候自动把关联的销售出库单上成本和日期带入销售发票表体自定义列并计算毛利，发票保存、审核、反审核时会自动更新数据
--FEntrySelfI0440发票成本列，FEntrySelfI0441发票日期列，FEntrySelfI0442发票毛利列
create trigger icsale_cost_date on icsale
after
insert,
update

as
update icsaleentry
set FEntrySelfI0441 = icstockbill.fdate,FEntrySelfI0440 = icsaleentry.fauxqty * icstockbillentry.fauxprice,FEntrySelfI0442 = icsaleentry.famount - icsaleentry.fauxqty * icstockbillentry.fauxprice
from icstockbill,icstockbillentry
where icsaleentry.fsourceinterid = icstockbill.finterid
and icsaleentry.fsourceinterid = icstockbillentry.finterid
and icsaleentry.fitemid = icstockbillentry.fitemid
and icsaleentry.finterid in (select finterid from inserted)

--删除触发器
drop trigger icsale_cost_date