请假申请审核流程1

CREATE procedure St_hw_leave1
        @billno varchar(30),
        @mkerid varchar(10)
as                    
declare @a varchar(10) ,@b varchar(10),@c varchar(10),@d varchar(10),@e varchar(10),@tdptno varchar(50),@JLpostNo varchar(20),@isYX int
select @tdptno=dpt.tdptno from ba_employeeinfo emp with(nolock) left join ba_dptinfo dpt with(nolock) on emp.dptno=dpt.dptno where empno=@mkerid and empflg  in (0,3)
select @JLpostNo=Empno from hw_postsetep with(nolock) where empflg in (0,3) and postno in (select B.JLpostNo from hw_postsetep A with(nolock),hw_postset B with(nolock) where A.postno=B.postno and zhuyao=1 and A.empflg in (0,3) and A.empno=@mkerid)
set @JLpostNo=isnull(@JLpostNo,dbo.get_cpost(@mkerid,1))
-------------------------------
if (select leavetypeno from hw_leave a with(nolock) where leaveNo=@Billno)=1
    set @isYX=1   --无薪假（事假）
else
    set @isYX=0   --有薪假
---------------------------------------------------------------------------------------------------
IF exists(select 1 from hw_postsetep A with(nolock),hw_postset B with(nolock) where A.postno=B.PostNo and A.empflg in (0,3) and B.levelNo<=40 and A.EmpNo=@mkerid)
Begin
        select @a=@mkerid where @mkerid='00001'
        select @a=dbo.get_cpost(@mkerid,1) where @mkerid<>'00001'
        select @b=empno from hw_postsetep where postno='C159' and empflg=0 and zhuyao=1 and @isYX=0 
End
Else
begin
        select @a=dbo.get_cpost(@mkerid,1)
        select @b=@JLpostNo  where dbo.get_cpost(@mkerid,1)<>@JLpostNo and @isYX=1
        select @c=empno from hw_postsetep where postno='C159' and empflg=0 and zhuyao=1 and @isYX=0 
end
----------------------------------------------------------------------------------------------------
exec distincts2 @a,@b,@c,@d,@e    ---修改返回审核人的存储过程，调用distincts2