trigger

alter trigger trig_forguangligonghao
on sys_flowinfo
for insert
as
declare @docid varchar(100),@flowid varchar(100),@stepnum int,
@sfnjsdy varchar(50),@sqlb varchar(100)
select @docid=DocID,@flowid=FlowID,@stepnum=StepNum from inserted
if @stepnum = 2
begin
 select @sfnjsdy=sfnjsdy,@sqlb=sqlb from ghqxapply where fid=@docid
 if @sfnjsdy = '否' or @sqlb like '%修改角色权限%'
 begin
  print @stepnum
  update sys_flowinfo set NextAboutNoteName = '市场部业务主管审核;',AboutDirectionName = '送市场部业务主管审核;'
 
  where (DocID = @docid) and (FlowID = @flowid) and (StepNum = @stepnum)
 end
end