[易飞]用途:默认超收率1%，超入率1%,缺领率5%

--=============================================
-- 用途:默认超收率1%，超入率1%,缺领率5% 
-- 品号为1开头的固定前置天数是否可都设为8天（2与3开头的不用设）。
-- 作者:龚德辉 
-- 日期:2011-08-15
--=============================================
ALTER TRIGGER [INSERT_PMC] ON [dbo].[INVMB] 
FOR INSERT
  AS
  declare  @MB001  CHAR(20)  
   BEGIN TRANSACTION
   SET NOCOUNT ON 
 SELECT @MB001=MB001 FROM INSERTED
 UPDATE INVMB SET MB401=0.0100,MB402=0.0100,MB403=0.0500 WHERE MB001=@MB001
    if(left(@MB001,1)='1')
  begin
   UPDATE INVMB SET MB036=8 WHERE MB001=@MB001
  end
  SET NOCOUNT OFF
COMMIT TRANSACTION