ASP.NET TreeView 递归绑定数据

最新推荐文章于 2024-09-09 17:58:15 发布

置顶 Ch920427

最新推荐文章于 2024-09-09 17:58:15 发布

阅读量709

点赞数

分类专栏： C# ASP.NET 文章标签： asp.net sql string list object

本文链接：https://blog.csdn.net/Ch920427/article/details/7282144

版权

C# ASP.NET 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

 187713732 asp.net 交流群，希望有更多的人可以加入，大家可以互相学习，帮助需要帮助的人，帮助刚入门的同行或即将入门的同行解决问题。

DAL方法，BLL省略

public static List<SysFun> GetSysFunByParentNodeId(int parentNodeid)
       {
           List<SysFun> listSysFun = new List<SysFun>();
           string sql = " SELECT *  FROM [MYBOOKSHOP].[dbo].[SysFun] WHERE ParentNodeId =@parentNodeid ";
           SqlParameter[] par = 
           {
               new SqlParameter("@parentNodeid",parentNodeid)
           };
           using (SqlDataReader sqlReader =DBHelper.GetReader(sql,CommandType.Text,par))
           {
               while (sqlReader.Read())
               {
                   SysFun sysFun = new SysFun();
                   sysFun.NodeId = (int)sqlReader["NodeId"];
                   sysFun.DisplayName = sqlReader["DisplayName"].ToString();
                   sysFun.ParentNodeId = (int)sqlReader["ParentNodeid"];
                   listSysFun.Add(sysFun);
               }
           }
           return listSysFun;
       }

       public static List<SysFun> GetSysFun(int parentNodeid)
       {
           List<SysFun> listSysFun = new List<SysFun>();
           string sql = " SELECT *  FROM [MYBOOKSHOP].[dbo].[SysFun] WHERE ParentNodeid =@parentNodeid ";
           SqlParameter[] par = 
           {
               new SqlParameter("@parentNodeid",parentNodeid)
           };
           using (SqlDataReader sqlReader = DBHelper.GetReader(sql, CommandType.Text, par))
           {
               while (sqlReader.Read())
               {
                   SysFun sysFun = new SysFun();
                   sysFun.NodeId = (int)sqlReader["NodeId"];
                   sysFun.DisplayName = sqlReader["DisplayName"].ToString();
                   sysFun.ParentNodeId = (int)sqlReader["ParentNodeid"];
                   listSysFun.Add(sysFun);
               }
           }
           return listSysFun;
       }

页面后台代码：

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            TVSysFun.ExpandDepth = 0;
            BindTreeView();
        }
        

    }
    private void BindTreeView()
    {
        
        List<SysFun> list = BookManager.GetSysFun(0);
        //遍历父节点
        foreach (SysFun parentNode in list)
        {
            TreeNode pNode = new TreeNode();
            pNode.Value = parentNode.NodeId.ToString();
            pNode.Text = parentNode.DisplayName.ToString();

            //遍历父节点下的子节点
            List<SysFun> childNode = BookManager.GetSysFunByParentNodeId(Convert.ToInt32( parentNode.NodeId));
            foreach (SysFun cNode in childNode)
            {
                TreeNode node = new TreeNode();
                node.Value = cNode.NodeId.ToString();
                node.Text = cNode.DisplayName.ToString();
                pNode.ChildNodes.Add(node);
            }
            TVSysFun.Nodes.Add(pNode);
        }
    }