zk的问题，200分急问，明早会加分

[antony0203]

<tabs>
<tab id="UFP" label="部门列表" />
<tab id="OPP" label="菜单列表" />

</tabs>
<tabpanels>
<tabpanel>
<tree id="tree" width="100%" mold="paging">
<treecols>
<treecol />
</treecols>
<treechildren>

<treeitem>
<treerow>
<treecell label="Item 1" />
</treerow>
<treechildren>
<treeitem>
<treerow>
<treecell label="Item 1.1"/>
</treerow>


部分代码如上，想让部门结构按照这样的树结构显示，但是demo里是固定写死的，我希望是根据我数据库读取的部门组织列表显示，并且treecell还应该带有该部门名称对应的code。这个需求该怎么做？或者不能用tree的话，该用什么组件来实现呢？
有用过zk的进来帮帮忙吧

[chang1216]

这个跟asp 一样的 从数据库中获取 所有部门 然后do while 循环一下 就可以了

[caffeewithcoke]

jiefen

[我在深圳搬砖-Justin]

TreeView

 private void PopulateRootLevel()
    {
        string connectionString = ConfigurationManager.ConnectionStrings["MySqlProviderConnection"].ConnectionString;
        SqlConnection objConn = new SqlConnection(connectionString);
        SqlCommand objCommand = new SqlCommand(@"select DepartmentID,DepartName,(select count(*) FROM Accounts_Department WHERE ParentDepartID=sc.DepartmentID) childnodecount FROM Accounts_Department sc where ParentDepartID=0", objConn);
        SqlDataAdapter da = new SqlDataAdapter(objCommand);
        DataTable dt = new DataTable();
        da.Fill(dt);
        PopulateNodes(dt, TreeView1.Nodes);
    }

    private void PopulateSubLevel(int parentid, TreeNode parentNode)
    {
        string connectionString = ConfigurationManager.ConnectionStrings["MySqlProviderConnection"].ConnectionString;
        SqlConnection objConn = new SqlConnection(connectionString);
        SqlCommand objCommand = new SqlCommand(@"select DepartmentID,DepartName,(select count(*) FROM Accounts_Department WHERE ParentDepartID=sc.DepartmentID) childnodecount FROM Accounts_Department sc where ParentDepartID=@ParentDepartID", objConn);
        objCommand.Parameters.Add("@ParentDepartID", SqlDbType.Int).Value = parentid;
        SqlDataAdapter da = new SqlDataAdapter(objCommand);
        DataTable dt = new DataTable();
        da.Fill(dt);
        PopulateNodes(dt, parentNode.ChildNodes);
    }


    protected void TreeView1_TreeNodePopulate(object sender, TreeNodeEventArgs e)
    {
        PopulateSubLevel(Int32.Parse(e.Node.Value), e.Node);
    }

    private void PopulateNodes(DataTable dt, TreeNodeCollection nodes)
    {
        foreach (DataRow dr in dt.Rows)
        {
            TreeNode tn = new TreeNode();
            tn.Text = dr["DepartName"].ToString();
            tn.Value = dr["DepartmentID"].ToString();
            tn.NavigateUrl = "departmentMain.aspx?id=" + dr["DepartmentID"].ToString();
            tn.Target = "content";
            nodes.Add(tn);

            //If node has child nodes, then enable on-demand populating
            tn.PopulateOnDemand = ((int)(dr["childnodecount"]) > 0);
        }
    }

[antony0203]

我想要的是zk框架下怎么做，它自带组件的

[阿云ivan]

zk是什么东东？

[mumu_java]

没用过zk,这种常用js实现，帮顶。

[gameboy911]

demo里有个动态树的，可以参照下那个代码