--OrgID 72  当前的部门ID

ALTER function [dbo].[getOrgAllName](@OrgID int)

returns nvarchar(500)

as

begin

--调试用

--declare @OrgID int

--set @OrgID=72

declare @oname nvarchar(50)

declare @fid int

declare @rtnValue nvarchar(500)

select @oname=orgname,@fid=parentid from sys_org where orgid=@OrgID 

if (@fid=0)

set @rtnValue=@oname

else

begin

	select @rtnValue=dbo.getOrgAllName(@fid)

	set @rtnValue=@rtnValue+'\'+@oname

end

--print @rtnValue

return @rtnValue

end