首页 > 代码库 > tree的使用

tree的使用

//html
<ul id="tree"></ul>

 js

 function initTree() {        $(‘#tree‘).tree({            url: ‘/OnlineMonitoring/ashx/departMgr.ashx?type=tree‘                         });    }

 后台

  根据父id返回当前子节点就好了。(父id为0时返回根节点)

json示例

     [
    {
        "id": "2",
        "text": "监事会",
        "state": "closed"
    },
    {
        "id": "4259045978553",
        "text": "2",
        "state": "open"
    },
    {
        "id": "4259055249969",
        "text": "a",
        "state": "open"
    }
]

id:node的id

text:节点名称

state:closed或open(closed说明有子项)

贴上一个sqlserver procedure:

  

 create procedure [dbo].[Tree]    @pid varchar(30) as begin    select      a.department_id as [id],     a.department_name as [text],     case     when     (select COUNT(department_id) from dbo.department_info as b where b.department_parent_id=a.department_id)>0     then closed else open     end as [state]     from dbo.department_info as a where a.department_parent_id=@pid; end

根据pid返回树(pid为0时返回根节点)

  依赖:

         <link href="http://www.mamicode.com/Scripts/easyui/themes/default/easyui.css" rel="stylesheet" />
          <link href="http://www.mamicode.com/Scripts/easyui/themes/icon.css" rel="stylesheet" />
          <link href="http://www.mamicode.com/Scripts/easyui/demo/demo.css" rel="stylesheet" />
          <script type="text/javascript" src="http://www.mamicode.com/Scripts/easyui/jquery.min.js"></script>
                   <script type="text/javascript" src="http://www.mamicode.com/Scripts/easyui/jquery.easyui.min.js"></script>
            <script type="text/javascript" src="http://www.mamicode.com/Scripts/easyui/locale/easyui-lang-zh_CN.js"></script>

 

tree的使用