Biegral Blog

<script language="javascript" type="text/javascript">
    
    var htmlStr=new Array();
    $(function(){
    loadNode(0);
    })
    
    function loadNode(pid)
    {
        var vDtbl=_Default.GetChildren(pid).value;
        if(vDtbl!=null)
        {
            for (var i = 0; i < vDtbl.Rows.length; i++) {  
                    var NodeID = vDtbl.Rows[i]["id"];
                    var NodeName=vDtbl.Rows[i]["Name"];
                    var PID=vDtbl.Rows[i]["pID"];

                    htmlStr.push("<ul>");
                    htmlStr.push("<li id='"+NodeID+"'>");htmlStr.push(NodeName);htmlStr.push("</li>");

                    if(vDtbl.Rows.length!=0)// 判断该NodeID是否存在子集
                    {
                    loadNode(NodeID);
                    }
                    htmlStr.push("</ul>");
                    }// end for
        var htmlcode="";
        htmlcode=htmlStr.join("");             
        $("#loadNode").html(htmlcode);             

        } 
    }
    </script>

    public DataTable GetChildren(int id)
    {
        //string strCon = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["SiteConnectionString"].ConnectionString;
        //string strCon = "Data Source=.;Integrated Security=SSPI;Initial Catalog=test";
        string strCon = "server=.;database=test;Integrated Security=sspi";
        using (SqlConnection conn = new SqlConnection(strCon))
        {
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = "select  id, Name,pID from tab_Tree where pID=" + id;
                conn.Open();
                cmd.CommandType = CommandType.Text;
                SqlDataAdapter dbA = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                dbA.Fill(ds);
                conn.Close();
                return ds.Tables[0];
            }
        }
    }

附件为我写的测试项目

• 遍历树.rar (90.5 KB)
• 下载次数: 100

• 
  
• 大小: 5.9 KB