Create Function Function_Sys_Organization_GetDirectory(@RecordID Char(36) = null, @IncludeCurrentNode Bit = 0)
Returns NVarChar(500)
As
Begin
Declare @First Bit
Set @First = 0
Declare @FDirectory NVarChar(500)
Declare @FName NVarChar(30)
Declare @FRecordID Char(36)
Declare @FParentID Char(36)
Set @FDirectory = ''
Set @FName = ''
Set @FParentID = @RecordID
While @First = 0 Or IsNull(RTrim(@FName), '') <> ''
Begin
Set @FName = ''
Set @First = 1
Select @FRecordID = RecordID, @FParentID = ParentID, @FName = Name From [Sys_Organization] Where RecordID = @FParentID
If IsNull(RTrim(@FName), '') <> ''
Begin
If @IncludeCurrentNode = 1 Or @FRecordID <> @RecordID
Begin
Set @FDirectory = RTrim(@FName) + '\' + @FDirectory
End
End
End
Return @FDirectory
End
本站僅提供存儲服務(wù)，所有內容均由用戶(hù)發(fā)布，如發(fā)現有害或侵權內容，請
點(diǎn)擊舉報。
