U8其他入库单触发器【调拨单生成的其他出库单和入库单自动审核，并且限制对应的制单人】

用友小张

ALTER trigger [dbo].[qitaruku001]

on [dbo].[RdRecord08]

for insert

update rdrecord08 set

chandler=cMaker, dVeriDate=dDate

where (chandler is NULL) and (cMaker='周志磊’or cMaker='蒋艳梅’or cMaker='郑媛媛’or cMaker='刘广梅’or cMaker='张黔’or cMaker='王静’or cMaker=‘潘锦萍’)and (cSource='调拨’or cSource=‘形态转换’)

用友小张

其他出库单

ALTER trigger [dbo].[qitachuku001]

on [dbo].[RdRecord09]

for insert

update rdrecord09 set

chandler=cMaker, dVeriDate=dDate

where (chandler is null) and (cMaker='周志磊’or cMaker='郑媛媛’or cMaker='蒋艳梅’or cMaker='刘广梅’or cMaker='张黔’or cMaker='王静’or cMaker=‘潘锦萍’)and (cSource='调拨’or cSource=‘形态转换’)