tree的使用

?

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

 js

?

1 2 3 4 5 6 7

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="../Scripts/easyui/themes/default/easyui.css" rel="stylesheet" />
    　　　　　 <link href="../Scripts/easyui/themes/icon.css" rel="stylesheet" />
     　　　　　<link href="../Scripts/easyui/demo/demo.css" rel="stylesheet" />
    　　　　　 <script type="text/javascript" src="../Scripts/easyui/jquery.min.js"></script>
                   <script type="text/javascript" src="../Scripts/easyui/jquery.easyui.min.js"></script>
    　　　　    <script type="text/javascript" src="../Scripts/easyui/locale/easyui-lang-zh_CN.js"></script>