select @Row1=0
select @TempDeptNo =DeptNo from Bas_DeptCode where DeptName=@S_DeptName
if @S_PrivilageType='SF'
begin
if (@S_NodeNo='7')or(@S_NodeNo='8')or(@S_NodeNo='9')or(@S_NodeNo='10')or(@S_NodeNo='13')
begin
select @Row1=Count(*) from Sf_Privilege where (SfNodeNo=@S_NodeNo)and(DeptNo=@TempDeptNo)
if @Row1>0
begin
select iRet=2 -----------------------select @iRet=2 ????
return
end
end
select @Row1=0
select @TempDeptNo =DeptNo from Bas_DeptCode where DeptName=@S_DeptName
if @S_PrivilageType='SF'
begin
if (@S_NodeNo='7')or(@S_NodeNo='8')or(@S_NodeNo='9')or(@S_NodeNo='10')or(@S_NodeNo='13')
begin
select @Row1=Count(*) from Sf_Privilege where (SfNodeNo=@S_NodeNo)and(DeptNo=@TempDeptNo)
if @Row1>0
begin
select iRet=2
return
end
end