【ASP.NET 进阶】TreeView控件学习
这几天上班没事做，也不好打酱油，学点没接触过的新东西吧，基本了解了下TreeView控件。
TreeView 控件用于在树结构中显示分层数据，例如目录或文件目录等。
下面看代码吧：
1.效果图
2.静态数据方式（即在页面上使用标签<asp:TreeNode>）
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TreeViewTest.aspx.cs" Inherits="Yc_TestS.TreeViewTest" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>TreeView</title> </head> <body> <form id="form1" runat="server"> <div> <asp:TreeView ID="treeT" runat="server"> <Nodes> <asp:TreeNode NavigateUrl="#" Text="城市" Expanded="True"> <asp:TreeNode NavigateUrl="#" Text="北京市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="上海市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="天津市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="重庆市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="湖北省"> <asp:TreeNode NavigateUrl="#" Text="武汉市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="黄冈市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="荆州市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="武穴市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="十堰市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="黄石市"></asp:TreeNode> </asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="河北省"> <asp:TreeNode NavigateUrl="#" Text="石家庄市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="唐山市"></asp:TreeNode> </asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="山西省"> <asp:TreeNode NavigateUrl="#" Text="太原市"></asp:TreeNode> <asp:TreeNode NavigateUrl="#" Text="大同市"></asp:TreeNode> </asp:TreeNode> </asp:TreeNode> </Nodes> </asp:TreeView> </div> </form> </body> </html>
3.前台数据源绑定方式
a.xml数据
<?xml version="1.0" encoding="utf-8" ?> <Area iAreaID ="0" cAreaName="城市"> <Province iAreaID ="1" cAreaName="北京市"/> <Province iAreaID ="2" cAreaName="上海市"/> <Province iAreaID ="3" cAreaName="天津市"/> <Province iAreaID ="4" cAreaName="重庆市"/> <Province iAreaID ="5" cAreaName="湖北省"> <City iAreaID ="51" cAreaName="武汉市"/> <City iAreaID ="52" cAreaName="黄冈市" /> <City iAreaID ="53" cAreaName="荆州市"/> <City iAreaID ="54" cAreaName="武穴市" /> <City iAreaID ="55" cAreaName="十堰市"/> <City iAreaID ="56" cAreaName="黄石市" /> </Province> <Province iAreaID ="6" cAreaName="河北省"> <City iAreaID ="61" cAreaName="石家庄市"/> <City iAreaID ="62" cAreaName="唐山市" /> </Province> <Province iAreaID ="7" cAreaName="山西省"> <City iAreaID ="71" cAreaName="太原市" /> <City iAreaID ="72" cAreaName="大同市" /> </Province> </Area>
b.前台页面（这里绑定了Xml的数据源）
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TreeViewTest.aspx.cs" Inherits="Yc_TestS.TreeViewTest" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>TreeView</title> </head> <body> <form id="form1" runat="server"> <div> <%--TreeView控件的DataSourceID属性指定数据源控件源ID。--%> <asp:TreeView ID="treeT" runat="server" DataSourceID="XmlDataSource1"> </asp:TreeView> <asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/Xml/Area.xml"> </asp:XmlDataSource> </div> </form> </body> </html>
c.后台代码
using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.Security; using System.Data; using Yc_TestS.BaseClass; namespace Yc_TestS { public partial class TreeViewTest : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { /** * TreeNodeBinding类在TreeView控件中定义数据项与该数据项绑定到的节点之间的关系。 * 该类的DataMember属性指定在节点显示的数据源对应XML的节点。 * ValueField属性对应TreeNode对象的Value属性。 * TreeNodeBinding类的Text属性指定向用户显示的文本， 如果该属性没有指定，则默认与ValueField属性相同。 * */ this.treeT.ShowLines = false;//显示连接子节点和父节点之间的线条 TreeNodeBinding Area = new TreeNodeBinding(); Area.DataMember = "Area";//指定绑定的成员 Area.ValueField = "cAreaName";//取值的字段 this.treeT.DataBindings.Add(Area); TreeNodeBinding Province = new TreeNodeBinding(); Province.DataMember = "Province";//添加与"省份"绑定 Province.ValueField = "cAreaName"; this.treeT.DataBindings.Add(Province); TreeNodeBinding City = new TreeNodeBinding(); City.DataMember = "City";//添加与"城市"绑定 City.ValueField = "cAreaName"; this.treeT.DataBindings.Add(City); } } }
4.后台数据库数据填充方式
a.数据库数据
b.前台页面
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TreeViewTest.aspx.cs" Inherits="Yc_TestS.TreeViewTest" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>TreeView</title> <script type="text/javascript"> function show(msg) { alert(msg); } </script> </head> <body> <form id="form1" runat="server"> <div> <asp:TreeView ID="treeT" runat="server"> </asp:TreeView> </div> </form> </body> </html>
c.后台代码
using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.Security; using System.Data; using Yc_TestS.BaseClass; namespace Yc_TestS { public partial class TreeViewTest : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { AddTree(0, null); } private void AddTree(int Pid, TreeNode PNode) { string sqlStr = "SELECT Item_id,Item_name,Parent_ID FROM Para_item"; DataTable dt = YSqlHelper.ExecuteQuery(sqlStr, CommandType.Text); if (dt.Rows.Count > 0) { DataView dv = new DataView(dt); //过滤ParentID,得到当前的所有子节点 ParentID为父节点ID dv.RowFilter = "[Parent_ID] = " + Pid; //循环递归 foreach (DataRowView Row in dv) { //声明节点 TreeNode Node = new TreeNode(); //绑定超级链接 Node.NavigateUrl = String.Format("javascript:show('{0}')", Row["Item_Name"].ToString()); //开始递归 if (PNode == null) { //添加根节点 Node.Text = Row["Item_Name"].ToString(); treeT.Nodes.Add(Node); Node.Expanded = true; //节点状态展开 AddTree(Int32.Parse(Row["Item_ID"].ToString()), Node); //再次递归 } else { //添加当前节点的子节点 Node.Text = Row["Item_Name"].ToString(); PNode.ChildNodes.Add(Node); Node.Expanded = true; //节点状态展开 AddTree(Int32.Parse(Row["Item_ID"].ToString()), Node); //再次递归 } } } } } }
d.配置文件
<?xml version="1.0"?> <!-- 有关如何配置 ASP.NET 应用程序的详细消息，请访问 http://go.microsoft.com/fwlink/?LinkId=169433 --> <configuration> <appSettings> <add key="sqlStr" value="0dd8de75eb51766d66d42ead8ea26b0c533f6fdb009e9fd2e6e1c9867d2766ec499405047e4173a74015f57800e3afb982fd39d96dcc1590c8c943242992c84b "/> </appSettings> <system.web> <compilation debug="true"/> </system.web> </configuration>
e.两个助手类
using System; using System.Collections.Generic; using System.Web; using System.IO; using System.Security.Cryptography; using System.Text; namespace Yc_TestS.BaseClass { public class EntryCode { /// <summary>加密</summary> public static string EncodeCode(string str) { string key = "david.yc"; DESCryptoServiceProvider provider = new DESCryptoServiceProvider(); provider.Key = Encoding.ASCII.GetBytes(key.Substring(0, 8)); provider.IV = Encoding.ASCII.GetBytes(key.Substring(0, 8)); byte[] bytes = Encoding.GetEncoding("GB2312").GetBytes(str); MemoryStream stream = new MemoryStream(); CryptoStream stream2 = new CryptoStream(stream, provider.CreateEncryptor(), CryptoStreamMode.Write); stream2.Write(bytes, 0, bytes.Length); stream2.FlushFinalBlock(); StringBuilder builder = new StringBuilder(); foreach (byte num in stream.ToArray()) { builder.AppendFormat("{0:X2}", num); } stream.Close(); return builder.ToString().Trim(); } /// <summary> Des 解密 GB2312 </summary> public static string DecodeCode(string str) { string key = "david.yc"; DESCryptoServiceProvider provider = new DESCryptoServiceProvider(); provider.Key = Encoding.ASCII.GetBytes(key.Substring(0, 8)); provider.IV = Encoding.ASCII.GetBytes(key.Substring(0, 8)); byte[] buffer = new byte[str.Length / 2]; for (int i = 0; i < (str.Length / 2); i++) { int num2 = Convert.ToInt32(str.Substring(i * 2, 2), 0x10); buffer[i] = (byte)num2; } MemoryStream stream = new MemoryStream(); CryptoStream stream2 = new CryptoStream(stream, provider.CreateDecryptor(), CryptoStreamMode.Write); stream2.Write(buffer, 0, buffer.Length); stream2.FlushFinalBlock(); stream.Close(); return Encoding.GetEncoding("GB2312").GetString(stream.ToArray()).Trim(); } } }
using System; using System.Collections.Generic; using System.Web; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace Yc_TestS.BaseClass { public class YSqlHelper { private static string connectionString = EntryCode.DecodeCode(ConfigurationManager.AppSettings["sqlStr"]);//获取解密后的数据库连接字符串 /// <summary>执行不带参数的增删改SQL语句或存储过程</summary> /// <param name="cmdText">增删改SQL语句或存储过程</param> /// <param name="ct">命令类型</param> /// <returns>受影响的行数</returns> public static int ExecuteNonQuery(string cmdText, CommandType ct) { int res = 0; using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); using (SqlCommand cmd = new SqlCommand(cmdText, conn)) { cmd.CommandType = ct; res = cmd.ExecuteNonQuery(); } } catch { } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return res; } /// <summary>执行带参数的增删改SQL语句或存储过程</summary> /// <param name="cmdText">增删改SQL语句或存储过程</param> /// <param name="ct">命令类型</param> /// <returns>受影响的行数</returns> public static int ExecuteNonQuery(string cmdText, SqlParameter[] paras, CommandType ct) { int res = 0; using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); using (SqlCommand cmd = new SqlCommand(cmdText, conn)) { cmd.CommandType = ct; cmd.Parameters.AddRange(paras); res = cmd.ExecuteNonQuery(); } } catch { } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return res; } /// <summary> 执行带参数的查询SQL语句或存储过程</summary> /// <param name="cmdText">查询SQL语句或存储过程ì</param> /// <param name="paras">参数集合?</param> /// <param name="ct">命令类型</param> /// <returns>DataTable对象</returns> public static DataTable ExecuteQuery(string cmdText, CommandType ct) { DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); using (SqlCommand cmd = new SqlCommand(cmdText, conn)) { cmd.CommandType = ct; using (SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { dt.Load(sdr); } } } catch { } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return dt; } /// <summary> 执行带参数的查询SQL语句或存储过程</summary> /// <param name="cmdText">查询SQL语句或存储过程ì</param> /// <param name="paras">参数集合?</param> /// <param name="ct">命令类型</param> /// <returns>DataTable对象</returns> public static DataTable ExecuteQuery(string cmdText, SqlParameter[] paras, CommandType ct) { DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(connectionString)) { try { conn.Open(); using (SqlCommand cmd = new SqlCommand(cmdText, conn)) { cmd.CommandType = ct; cmd.Parameters.AddRange(paras); using (SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { dt.Load(sdr); } } } catch { } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return dt; } } }
5.一些方法记录
a.控制父结点的开/合状态
TreeView_Tree.GetNodeFromIndex("1").Expanded=false/true;
b.清除某个父结点下的所有子节点
TreeView_IndexLeft.GetNodeFromIndex("1").Nodes.Clear();
c.设置所选节点，如选中第二个节点
function SetSelNode() { TreeView_Tree.selectedNodeIndex="1"; }
d.得到所选节点的Text，ID或NodeData
function GetAttribute() { alert(TreeView_Tree.getTreeNode(TreeView_Tree.selectedNodeIndex).getAttribute("Text")); }
//替换Text为ID或NodeData，可分别得到所选节点的ID或NodeData
e.修改节点属性，如修改第一个节点的Text
function ModifyNode() { var node=TreeView_Tree.getTreeNode("0"); node.setAttribute("Text","第一个节点"); }
f.添加节点
function AddNode() { var node=TreeView_Tree.createTreeNode(); node.setAttribute("Text","第一个节点"); TreeView_Tree.add(node); }
g.TreeView 中的SelectedIndexChange不执行
AutoPostBack=true，SelectedIndexChange才能被执行。
h.判断 TreeView 的一个节点下是否有子节点
if(SelectNode.Nodes.Count==0) { //该节点没有字节点 }
