Advertisement
MaysamSh

Untitled

Jan 31st, 2013
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 1.87 KB | None | 0 0
  1.     Public Function GenerateNestedMenus(ByVal fTableName As String, ByVal fID As String, ByVal fCluase As String) As String
  2.         Dim output As String = ""
  3.         Dim x As String = Now.ToString
  4.         SetActionResult = "waiting_GenerateNestedMenus"
  5.         Dim OutputData As String = ""
  6.         Dim SQLCommand As String
  7.         Dim _string As New CoreString
  8.  
  9.         SQLCommand = "SELECT * FROM " & fTableName & " WHERE MenuParent=@ID AND Visible=1 AND " & fCluase
  10.  
  11.         Dim DR As SqlDataReader
  12.         Dim DB As New DeepDB(__ConnectionString, SQLCommand, fTableName)
  13.         DB.ddConnect()
  14.  
  15.         Dim IDParameter As New SqlParameter("@ID", fID)
  16.  
  17.         DB.ddAddParameper(IDParameter)
  18.         Dim temp As String
  19.  
  20.         Try
  21.             DR = DB.ddExecuteReader()
  22.  
  23.             While DR.Read
  24.  
  25.                 If CInt(ChildCounter(fTableName, DR("id"))) > 0 Then
  26.                     temp = "<li>" & vbCrLf & "<a href='#'>" & Trim(DR("MenuName")) & "</a>" & vbCrLf & _
  27.                         vbTab & "<ul> "
  28.                     _temp &= temp
  29.                     GenerateNestedMenus("menus", DR("id"), fCluase)
  30.                     _temp &= vbTab & "</ul>" & vbCrLf & vbTab & "</li>" & vbCrLf
  31.                 Else
  32.                     'For rows they have not child
  33.                     temp = vbTab & "<li><a href='#'>" & Trim(DR("MenuName")) & "</a>" & "</li>" & vbCrLf
  34.                     _temp &= temp
  35.                     GenerateNestedMenus("menus", DR("id"), fCluase)
  36.  
  37.                 End If
  38.                 SetActionResult = "done_GenerateNestedMenus"
  39.             End While
  40.             output = _temp
  41.         Catch exp As Exception
  42.             SetErrorMessage = "GenerateNestedMenus():" & exp.Message
  43.             SetActionResult = "error_GenerateNestedMenus"
  44.         Finally
  45.             DB.ddClose()
  46.         End Try
  47.  
  48.         Return output
  49.     End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement