ASP.NET中不定級動態(tài)菜單的實(shí)現(xiàn)
2024-07-10 12:57:36
供稿：網(wǎng)友
前日，根據(jù)客戶需要，要根據(jù)如下的表動態(tài)生成如下的菜單：表中的數(shù)據(jù)是動態(tài)更新的。
我們平時(shí)iewebcontr來做菜單時(shí)都是在html中直接輸入，也就是說是靜態(tài)的，現(xiàn)在要做成動態(tài)的，而且菜單級數(shù)不定，怎么來實(shí)現(xiàn)呢？筆者通過研究發(fā)現(xiàn)，用 iewebcontr來做菜單時(shí)，菜單項(xiàng)可以直接輸入，也可以用如下的方法指定從某一個(gè)文件中讀取菜單項(xiàng)：
〈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的內(nèi)容如下：
〈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〉
&n bsp;現(xiàn)在的問題變成了如何將數(shù)據(jù)表根據(jù)“類別號”修改menuone.txt文件。將該過程放在對數(shù)據(jù)表修改后進(jìn)行。下面是根據(jù)表的內(nèi)容生成menuone.txt的源代碼：
imports system.io
dim txtwriter as streamwriter
txtwriter = file.createtext(server.mappath("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='adminclass_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' target='main2'>")
case is = 0
txtwriter.writeline("<treenode text='" & strname & "' navigateurl='adminclass_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' target='main2'/>")
case is < 0
txtwriter.writeline("<treenode text='" & strname & "' navigateurl='adminclass_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' target='main2'/>")
'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='adminclass_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' target='main2'/>")
'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='adminclass_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' target='main2'/>")
'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='adminclass_add.aspx?classname=" & strname & "" & strand & "classid=" & strid & "' target='main2'/>")
'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()
end sub
sub creatmenuone(byval strpath as string)
dim txtwriter as streamwriter
txtwriter = file.createtext(strpath + ("/../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()
