110,566
社区成员
发帖
与我相关
我的任务
分享
数据库结构:
id name parentid
1 一级 0
2 科技 1
3 沈阳 2
4 二级 0
5 美食 4
6 哈尔滨 5
7 三级 0
8 美食 7
9 大连 8
private void LoadTree()
{
treeView1.Nodes.Clear(); //先清空树
DataTable dt = ds.Tables[0]; //把表结构从数据库查出来放到DataTable中
//循环绑定父节点
foreach (DataRow dr in dt.Rows)
{
//遍历加载父节点
if (Convert.ToInt32(dr["parentid"]) == 0)
{
TreeNode newNode = new TreeNode(dr["name"].ToString());
treeView1.Nodes.Add(newNode);
ChildLoad(dr, newNode, dt);
}
}
this.treeView1.ExpandAll();
}
//绑定子节点
private void ChildLoad(DataRow dr, TreeNode newNode, DataTable dt)
{
foreach (DataRow row in dt.Rows)
{
if (Convert.ToInt32(dr["id"]) == Convert.ToInt32(row["parentid"]))
{
TreeNode childNode = new TreeNode();
childNode.Text = row["name"].ToString();
newNode.Nodes.Add(childNode);
ChildLoad(row, childNode, dt); //递归子节点
}
}
}
/// <summary>
/// 创建DataSet的方法
/// </summary>
/// <param name="nodes">TreeView的根节点</param>
/// <param name="ds">Dataset数据集合</param>
/// <param name="pid">节点的父</param>
private void CreateTreeView(TreeNodeCollection nodes, DataSet ds, int pid)
{
//定义筛选条件
string sql = string.Format("lbcode={0}", pid);
//从Dataset中筛选符合条件的行的集合
DataRow[] drr = ds.Tables[0].Select(sql);
//遍历获得行的集合
foreach (DataRow dr in drr)
{
//创建TreeView节点
TreeNode tnode = new TreeNode();
//添加到根节点中
nodes.Add(tnode);
//设置显示的文本
//tnode.ImageUrl = "images/foldericon1.gif";
tnode.Text = dr["lbname"].ToString();
tnode.Value = dr["lbcode"].ToString();
//设置显示的路径
tnode.NavigateUrl = dr["PurURL"].ToString();
//递归调用方法
CreateTreeView(tnode.ChildNodes, ds, Convert.ToInt32(dr["lbcode"]));
//从Dataset中删除已经添加的行,提高访问效率
ds.Tables[0].Rows.Remove(dr);
}
}
#region 添加所有节点
private void AddNode()
{
//获取到所有信息
DataTable dt = PurViewManager.GetAllPurView();
//获取所有父节点
DataRow[] drs = dt.Select("lbprior=0");
for (int i = 0; i < drs.Length; i++)
{
TreeNode node = new TreeNode();
node.Text = drs[i]["lbname"].ToString();
node.Value = drs[i]["lbcode"].ToString();
//添加子节点
DataRow[] childdrs = dt.Select("lbprior=" + node.Value);
for (int j = 0; j < childdrs.Length; j++)
{
TreeNode childnode = new TreeNode();
childnode.Text = childdrs[j]["lbname"].ToString();
childnode.Value = childdrs[j]["lbcode"].ToString();
node.ChildNodes.Add(childnode);
}
TreeView1.Nodes.Add(node);
}
}
DataTable dtlModel = new DataTable();
private void CreateData() {
dtlModel.Columns.Add("id", typeof(Int32));
dtlModel.Columns.Add("pid", typeof(Int32));
dtlModel.Columns.Add("name");
for (int i = 1; i < 6; i++) {
DataRow dr = dtlModel.NewRow();
dr["id"] = i;
dr["pid"] = 0;
dr["name"] = i.ToString();
dtlModel.Rows.Add(dr);
for (int j = 1; j < 6; j++) {
DataRow dr1 = dtlModel.NewRow();
dr1["id"] = int.Parse(i.ToString() + j.ToString());
dr1["pid"] = i;
dr1["name"] = i + "_" + j;
dtlModel.Rows.Add(dr1);
for (int k = 1; k < 6; k++) {
DataRow dr2 = dtlModel.NewRow();
dr2["id"] = int.Parse(i.ToString() + j.ToString() + k.ToString());
dr2["pid"] = dr1["id"];
dr2["name"] = i + "_" + j + "_" + k;
dtlModel.Rows.Add(dr2);
}
}
}
}
private void BindTree(DataRow[] rows, TreeNode node) {
foreach (DataRow r in rows) {
if (r["pid"] == DBNull.Value)
continue;
//如果是根结点,添加到TreeView控件
if (r["pid"].ToString() == "0") {
TreeNode node1 = new TreeNode();
node1.Text = string.Format("<input name='hd_{0}' type='hidden' value='{1}'/>{2}", r["id"], r["id"], r["name"].ToString());
node1.Value = r["id"].ToString();
//node1.Target = "top";
TreeView1.Nodes.Add(node1);
BindTree(dtlModel.Select("pid=" + r["id"]), node1);
}
else if (node != null) {//否则添加到当前结点
TreeNode node1 = new TreeNode();
node1.Text = string.Format("<input name='hd_{0}' type='hidden' value='{1}'/>{2}", r["id"], r["id"], r["name"].ToString());
node1.Value = r["id"].ToString();
//node1.Target = "top";
node.ChildNodes.Add(node1);
BindTree(dtlModel.Select("pid=" + r["id"]), node1);//递归生成子树
}
}
}
public partial class BindTreeView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
departList = new List<Department>() {
new Department{ ID = 1, ParentID= 0, Name=" 老总"},
new Department{ ID = 2, ParentID= 1, Name=" 市场副总"},
new Department{ ID = 3, ParentID= 1, Name=" 技术副总"},
new Department{ ID = 4, ParentID= 1, Name=" 行政副总"},
new Department{ ID = 5, ParentID= 2, Name=" 市场部"},
new Department{ ID = 6, ParentID= 4, Name=" 财务部"},
new Department{ ID = 7, ParentID= 4, Name=" 行政部"},
new Department{ ID = 8, ParentID= 3, Name=" C#技术部"},
new Department{ ID = 9, ParentID= 3, Name=" JAVA技术部"},
new Department{ ID = 10, ParentID= 9, Name=" J2EE技术部"},
new Department{ ID = 11, ParentID= 9, Name=" J2ME技术部"}
};
TreeNode root = new TreeNode();
root.Text = this.departList[0].Name;
root.Value = this.departList[0].ID.ToString();
root.Checked = true;
this.TreeView1.Nodes.Add(root);
this.BindToTree(root);
}
/// <summary>
/// 对象列表
/// </summary>
private List<Department> departList;
/// <summary>
/// 绑定到树
/// </summary>
/// <param name="node"></param>
private void BindToTree(TreeNode node)
{
if (node != null)
{
var temp = from dept in departList
where dept.ParentID.ToString() == node.Value
select dept;
List<Department> tempList = temp.ToList<Department>();
tempList.ForEach(delegate(Department t)
{
TreeNode tnode = new TreeNode();
tnode.Text = t.Name;
tnode.Value = t.ID.ToString();
tnode.Checked = true;
node.ChildNodes.Add(tnode);
BindToTree(tnode);
});
}
}
}