asp.net用标签递归一颗树

最新推荐文章于 2018-01-17 14:29:00 发布

weixin_30505043

最新推荐文章于 2018-01-17 14:29:00 发布

阅读量109

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/htht530/archive/2011/09/03/2165533.html

本博客介绍了一种使用C#语言和Oscar框架从数据库中获取数据并构建树形菜单的方法，通过递归函数实现菜单的层级展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 protected void Page_Load(object sender, EventArgs e)
    {
        inintbind();
    }
    /// <summary>
    /// 初始化所有数据
    /// </summary>
    public void inintbind()
    {
        string connstr = "Server=127.0.0.1;Port=2003;User Id=SYSDBA;Password=123456;Database=OSRDB;Encoding=GBK;";
        OscarConnection conn = new OscarConnection(connstr);
        conn.Open();
        string sql = "select * from FUNDSOURCE   order by id desc ";

        OscarCommand cmd = new OscarCommand(sql,conn);
        OscarDataAdapter da = new OscarDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds,"tab");
        createmenu(ds, "0", mainnav);
    }

    /// <summary>
    /// 递归树形菜单
    /// </summary>
    /// <param name="ds">数据源</param>
    /// <param name="parentId">父节点id</param>
    /// <param name="UL">前台UL标记id</param>
    private void createmenu(DataSet ds, string parentId, HtmlGenericControl UL)
    {
        DataRow[] rows;
        //判断id是否为空
        if (string.IsNullOrEmpty(parentId))
        {
            rows = ds.Tables[0].Select("pid is null");//为空说明没有数据
        }

        else
        {
            rows = ds.Tables[0].Select("pid='" + parentId + "'");//找到匹配的数据
        }
           
        foreach (DataRow t in rows)
        {
            HtmlGenericControl serverUL = new HtmlGenericControl("ul");//创建ul标签
            HtmlGenericControl serverLi = new HtmlGenericControl("li");//生成Li标签，作为父节点

            if (t["pid"].ToString() == "0")
            {
                serverLi.InnerHtml = "<a href='#######' onclick='liclick(this)'>" + t["INVENAME"].ToString() + "</a>";
                //serverUL.Attributes.Add("style", "display:none");
            }
            else
            {
                serverLi.InnerHtml = "<a href='#######' onclick='liclick(this)'>" + t["INVENAME"].ToString() + "</a>";
                //serverUL.Attributes.Add("style", "display:none");
            }
            serverLi.Controls.Add(serverUL);
            UL.Controls.Add(serverLi);
            createmenu(ds, t["id"].ToString(), serverUL);

        }
    }

View Code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head  runat="server">
<title></title>
<script src="js/jquery-1.5.min.js" type="text/javascript"></script>
<script type="text/javascript">
        function liclick(obj) {
            $(obj).parent().find("ul").toggle();
        }
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<ul id="mainnav" runat="server"></ul>
</div>
</form>
</body>
</html>