jquery-ztree

来源：互联网发布：工程院院士 2017 知乎编辑：程序博客网时间：2024/05/19 18:41

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Admin_left2.aspx.cs" Inherits="JX.Web.Admin.Admin_left2" %><!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"><head runat="server">    <title></title>    <link href="zTreeStyle/zTreeStyle.css" rel="stylesheet" type="text/css" />    <script type="text/javascript" src="js/jquery-1.3.2.js"></script>    <script type="text/javascript" src="js/jquery-1.3.2-vsdoc2.js"></script>    <script type="text/javascript" src="js/jquery-ztree-2.4.js"></script></head><body> <form id="form1" runat="server"><div><ul id="tree" class="tree" style="width:500px; height:100%; overflow:auto;"></ul></div><script type="text/javascript">var zTree;var demoIframe;var setting = {isSimpleData: true,//简单Array数组转换为JSON嵌套数据参数treeNodeKey: "Id",treeNodeParentKey: "PId",nameCol: "Name",//用户自定义名称列showLine: true,//是否显示树的线root: {isRoot: true,nodes: []}};zNodes = [<% = NodesData %>];$(document).ready(function() {zTree = $("#tree").zTree(setting, zNodes);});</script></form></body></html>

cs文件

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.SqlClient;using System.Configuration;namespace JX.Web.Admin{    public partial class Admin_left2 : System.Web.UI.Page    {        protected string NodesData;        protected void Page_Load(object sender, EventArgs e)        {            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["demo1"].ConnectionString);            string sqlText = "SELECT * FROM TreeNodes";            SqlCommand cmd = new SqlCommand(sqlText, conn);            List<string> treenodes = new List<string>();            try            {                conn.Open();                SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);                while (reader.Read())                {                    string node = string.Format("{{ 'Id':{0}, 'PId':{1}, 'Name':'{2}', 'url':'{3}' }}",                        reader["NodeId"], reader["PId"], reader["Name"], reader["Url"]);                    treenodes.Add(node);                }                if (reader.IsClosed == false)                    reader.Close();            }            catch (Exception ex)            {            }            finally            {                if (conn.State != System.Data.ConnectionState.Closed)                    conn.Close();            }            NodesData = string.Join(",", treenodes.ToArray());            //{ 'Id':1, 'PId':0, 'Name':'数据融合系统', 'url':'' },            //{ 'Id':2, 'PId':1, 'Name':'统计数据', 'url':'' },            //{ 'Id':3, 'PId':2, 'Name':'全业务套餐发展量', 'url':'' },            //{ 'Id':4, 'PId':2, 'Name':'状态统计查询', 'url':'' },            //{ 'Id':5, 'PId':2, 'Name':'装拆机统计查询', 'url':'' },            //{ 'Id':6, 'PId':2, 'Name':'产品（分客户群）装拆机统计', 'url':'' },            //{ 'Id':7, 'PId':1, 'Name':'清单', 'url':'' },            //{ 'Id':8, 'PId':7, 'Name':'子项一', 'url':'' },            //{ 'Id':9, 'PId':7, 'Name':'子项二', 'url':'' }        }    }}