C#实现TreeView动态显示树形结构 收藏
今日因需要，制作了一个GridView显示树形结构的例子，查阅了不少资料，实现的过程很艰辛啊。
不具体代码拿出来，大家分享一下。
数据表的创建：
CREATE TABLE [crm_treemenu] (
[i_Id] [int] NOT NULL ,
[c_mkdm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[v_mkmc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[v_cdlj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[v_img] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[i_xh] [int] NULL ,
[i_childNum] [int] NULL ,
[IsBasic] [char] (1) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT
[DF_crm_treemenu_IsBasic] DEFAULT (1),
[IsMaintainable] [char] (1) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT
[DF_crm_treemenu_IsMaintainable] DEFAULT (0),
[C_BS] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_CRM_TREEMENU] PRIMARY KEY CLUSTERED
(
[i_Id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
存储过程
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER procedure ShowPrivilege
as
select c_mkdm ,v_mkmc, '0'as fdm from crm_treemenu crm_role,crm_role_Privilege
where len(c_mkdm) =2
union
select c_mkdm ,v_mkmc ,left(c_mkdm, len(c_mkdm) -2) as fdm
from crm_treemenu where len(c_mkdm) >2
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
前台代码：
JS部分用来实现选中复选框的操作，如没有必要，可删除！
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="role_Privilege.aspx.cs" Inherits="BaseSetting_role_Privilege" %>
<html xmlns="
http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
<script language="javascript">
function window.onload()
{
document.getElementById("trePrivitegeInfo").onclick = OnTreeNodeChecked;//这里把TreeView名改一下~
}
function OnTreeNodeChecked()
{
var ele = event.srcElement;
if(ele.type=='checkbox')
{
ele.className = "";
var childrenDivID = ele.id.replace('CheckBox','Nodes');
var div = document.getElementById(childrenDivID);
if(div!=null)
{
var checkBoxs = div.getElementsByTagName('INPUT');
for(var i=0;i<checkBoxs.length;i++)
{
if(checkBoxs[i].type=='checkbox')
checkBoxs[i].checked=ele.checked;
}
}
setParentClassName(ele);
}
}
function setParentClassName(currCheckBox)
{
var objParentNode= public_GetParentNode(currCheckBox);
if(public_IsObjectNull(objParentNode))
return;
var checkBoxs = objParentNode.getElementsByTagName("INPUT");
var allSelect = true;
var allUnSelect = true;
for(var i=0;i<checkBoxs.length;i++)
{
if(checkBoxs[i].type=='checkbox')
{
if(checkBoxs[i].checked) allUnSelect = false;
else allSelect = false;
if((!allSelect) && (!allUnSelect)) break;
}
}
var objParentCheckBox = public_Node2CheckBox(objParentNode);
if(public_IsObjectNull(objParentCheckBox)) return;
setParentClassName(objParentCheckBox);
if(allSelect)
{
objParentCheckBox.className = "";
objParentCheckBox.checked = true;
return;
}
if(allUnSelect)
{
objParentCheckBox.className = "";
objParentCheckBox.checked = false;
return;
}
objParentCheckBox.checked = false;
objParentCheckBox.className = "parentbox_style";
}
//得到本节点所在的Node(Div对象)
function public_GetParentNode(element)
{
var parent = element.parentNode;
var upperTagName = "DIV";
//如果这个元素还不是想要的tag就继续上溯
while (parent && (parent.tagName.toUpperCase() != upperTagName))
{
parent = parent.parentNode ? parent.parentNode : parent.parentElement;
}
return parent;
}
function public_Node2CheckBox(element)
{
var objID = element.getAttribute("ID");
objID = objID.substring(0,objID.indexOf("Nodes"));
return document.getElementById(objID+"CheckBox");
}
function public_IsObjectNull(element)
{
if(element==null || element == "undefined")
return true;
else
return false;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TreeView ID="trePrivitegeInfo" runat="server" ShowCheckBoxes="All" ShowLines="True">
</asp:TreeView>
</div>
</form>
</body>
</html>
后台代码：
// showPriviAction.ShowPrivilegeInfo();是用来显示数据的方法。改成自己的数据集即可！
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using crm.entcrm.action;
public partial class BaseSetting_role_Privilege : System.Web.UI.Page
{
/// <summary>
/// 实例化ShowPrivilegeAction
/// </summary>
ShowPrivilegeAction showPriviAction = new ShowPrivilegeAction();
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
this.trePrivitegeInfo.Nodes.Clear();
//调用递归函数，完成树形结构的生成
AddTree("0", trePrivitegeInfo.Nodes);
}
}
/// <summary>
/// 递归添加树的节点
/// </summary>
/// <param name="fdm">父代码</param>
/// <param name="nodes">节点对象的集合</param>
public void AddTree(string fdm, System.Web.UI.WebControls.TreeNodeCollection nodes)
{
DataTable dt = showPriviAction.ShowPrivilegeInfo();
DataView dvTree = new DataView(dt);
// 过滤c_mkdm,得到当前的所有子节点
dvTree.RowFilter = "[fdm] = " + fdm;
foreach (DataRowView Row in dvTree)
{
TreeNode Node = new TreeNode();
// 添加节点
Node.Value = Row["c_mkdm"].ToString();
Node.Text = Row["v_mkmc"].ToString();
nodes.Add(Node);
//trePrivitegeInfo.Nodes.Add(Node);
//Node.Expanded = true;
AddTree(Row["c_mkdm"].ToString(), Node.ChildNodes); //再次递归
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
///设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
