前日，根據客戶需要，要根據如下的表動態產生如下的菜單：表中的資料是動態更新的。
我們平時IEWebContr來做菜單時都是在html中直接輸入，也就是說是靜態，現在要做成動態，而且菜單級數不定，怎麼來實現呢？筆者通過研究發現，用IEWebContr來做菜單時，功能表項目可以直接輸入，也可以用如下的方法指定從某一個檔案中讀取功能表項目：
|
〈iewc:TreeView runat="server" ID="Treeview1" NAME="Treeview1"〉
〈iewc:TreeNode id="Treenode1" runat="server" TreeNodeSrc="menuone.txt" Expanded="True" Text="資訊類別列表"〉〈/iewc:TreeNode〉
〈/iewc:TreeView〉 |
其中menuone.txt的內容如下：
|
〈TREENODES〉
〈treenode text='蔬菜' NavigateUrl='xxcb_add.aspx?classname=蔬菜&classid=01'? Target='main1'〉
〈treenode text='白菜' NavigateUrl='xxcb_add.aspx?classname=白菜&classid=0101'?? Target='main1'/〉
〈treenode text='蘿蔔' NavigateUrl='xxcb_add.aspx?classname=蘿蔔&classid=0102'?? Target='main1'/〉
〈treenode text='黃花菜' NavigateUrl='xxcb_add.aspx?classname=黃花菜&classid=0103'?? Target='main1'/〉
〈/treenode〉
〈treenode text='水果' NavigateUrl='xxcb_add.aspx?classname=水果&classid=02'? Target='main1'〉
〈treenode text='蘋果' NavigateUrl='xxcb_add.aspx?classname=蘋果&classid=0201'? Target='main1'〉
〈treenode text='紅富士' NavigateUrl='xxcb_add.aspx?classname=紅富士&classid=020101'?? Target='main1'/〉
〈treenode text='其它蘋果' NavigateUrl='xxcb_add.aspx?classname=其它蘋果&classid=020102'?? Target='main1'/〉 |
|
〈/treenode〉
〈treenode text='桃子' NavigateUrl='xxcb_add.aspx?classname=桃子&classid=0202'?? Target='main1'/〉
〈treenode text='荔枝' NavigateUrl='xxcb_add.aspx?classname=荔枝&classid=0203'?? Target='main1'/〉
〈/treenode〉
〈treenode text='糧食' NavigateUrl='xxcb_add.aspx?classname=糧食&classid=03'? Target='main1'〉
〈treenode text='大米' NavigateUrl='xxcb_add.aspx?classname=大米&classid=0301'?? Target='main1'/〉
〈treenode text='玉米' NavigateUrl='xxcb_add.aspx?classname=玉米&classid=0302'?? Target='main1'/〉
〈/treenode〉
〈/TREENODES〉 |
現在的問題變成了如何將資料表根據“類別號”修改menuone.txt檔案。將該過程放在對資料表修改後進行。下面是根據表的內容產生menuone.txt的原始碼：
|
Imports System.IO
Dim txtwriter As StreamWriter
txtwriter = File.CreateText(Server.MapPathstrpath ("\menuone.txt"))
txtwriter.WriteLine("<TREENODES>") Dim objConn As OleDbConnection
Dim objCmd As OleDbCommand
Dim objRead As OleDbDataReader
Dim strSQL, strDSN As String
Dim strid, strname, strid1, strname1 As String
Dim strand As String
strand = "&" |
|
Dim i, j, k, m As Integer
i = 0
j = 0
k = 0
m = 0 strSQL = "select * from class order by classid " objConn = New OleDbConnection(ConfigurationSettings.AppSettings("connString"))
objCmd = New OleDbCommand(strSQL, objConn)
objCmd.Connection.Open()
objRead = objCmd.ExecuteReader() While objRead.Read() |
|
If j = 0 Then
j = Len(Trim(objRead.Item("classid")))
Else
strid = strid1
strname = strname1
i = Len(Trim(objRead.Item("classid"))) k = i - j Select Case k
Case Is > 0
txtwriter.WriteLine("<treenode text='" & strname & "' NavigateUrl='xxcb_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' Target='main1'>")
Case Is = 0
txtwriter.WriteLine("<treenode text='" & strname & "' NavigateUrl='xxcb_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' Target='main1'/>")
Case Is < 0
txtwriter.WriteLine("<treenode text='" & strname & "' NavigateUrl='xxcb_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' Target='main1'/>")
'txtwriter.WriteLine("</treenode>") m = k
While m < 0
txtwriter.WriteLine("</treenode>")
m = m + 2
End While End Select j = Len(Trim(objRead.Item("classid"))) End If strid1 = Trim(objRead.Item("classid"))
strname1 = Trim(objRead.Item("classname")) End While |
|
'strid = strid1
'strname = strname1
i = Len(strid)
k = j - i
strid = strid1
strname = strname1
Select Case k
Case Is > 0
txtwriter.WriteLine("<treenode text='" & strname & "' NavigateUrl='xxcb_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' Target='main1'/>")
'txtwriter.WriteLine("</treenode>") m = Len(strid) / 2 While m > 1
txtwriter.WriteLine("</treenode>")
m = m - 1
End While
Case Is = 0
txtwriter.WriteLine("<treenode text='" & strname & "' NavigateUrl='xxcb_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' Target='main1'/>")
'txtwriter.WriteLine("</treenode>")
m = Len(strid) / 2 While m > 1
txtwriter.WriteLine("</treenode>")
m = m - 1
End While
Case Is <= 0
txtwriter.WriteLine("<treenode text='" & strname & "' NavigateUrl='xxcb_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' Target='main1'/>")
'txtwriter.WriteLine("</treenode>") m = Len(strid) / 2 While m > 1
txtwriter.WriteLine("</treenode>")
m = m - 1
End While End Select
txtwriter.WriteLine("</TREENODES>")
txtwriter.Close() |
這樣menuone.txt就按要求產生了菜單源檔案。
