********************************************************************************************************
--消耗品种类字典 UT_GOODS_DICT_KIND
--alter table UT_GOODS_DICT_KIND add n_last numeric(18,0) null;
go
alter TRIGGER tr_DICT_KIND_n_last ON UT_GOODS_DICT_KIND for UPDATE
AS
BEGIN
begin transaction
update UT_GOODS_DICT_KIND set UT_GOODS_DICT_KIND.n_last = isnull(UT_GOODS_DICT_KIND.n_last,0) + 1
from UT_GOODS_DICT_KIND inserted
where UT_GOODS_DICT_KIND.GOODS_KIND_CODE = inserted.GOODS_KIND_CODE;
if (@@error <> 0)
begin
rollback transaction;
return;
end;
commit transaction;
END;
--消耗品明细字典 UT_GOODS_DICT_ITEMS
--alter table UT_GOODS_DICT_ITEMS add n_last numeric(18,0) null;
go
alter TRIGGER tr_DICT_ITEMS_n_last ON UT_GOODS_DICT_ITEMS for UPDATE
AS
BEGIN
begin transaction
update UT_GOODS_DICT_ITEMS set UT_GOODS_DICT_ITEMS.n_last = isnull(UT_GOODS_DICT_ITEMS.n_last,0) + 1
from UT_GOODS_DICT_ITEMS inserted
where UT_GOODS_DICT_ITEMS.GOODS_CODE = inserted.GOODS_CODE;
if (@@error <> 0)
begin
rollback transaction;
return;
end;
commit transaction;
END;
--货源单位字典 UT_GOODS_FACTORY
--alter table UT_GOODS_FACTORY add n_last numeric(18,0) null;
go
alter TRIGGER tr_GOODS_FACTORY_n_last ON UT_GOODS_FACTORY for UPDATE
AS
BEGIN
begin transaction
update UT_GOODS_FACTORY set UT_GOODS_FACTORY.n_last = isnull(UT_GOODS_FACTORY.n_last,0) + 1
from UT_GOODS_FACTORY inserted
where UT_GOODS_FACTORY.FACTORY_CODE = inserted.FACTORY_CODE;
if (@@error <> 0)
begin
rollback transaction;
return;
end;
commit transaction;
END;
--仪器消耗参数设置 UT_GOODS_DICT_REAGENT
--alter table UT_GOODS_DICT_REAGENT add id_shared numeric(18,0) null;
