/// <summary>
/// 绑定树目录
/// </summary>
/// <param name="parentId">父ID</param>
/// <param name="node">父节点</param>
private void BindTree(int parentId, TreeListNode parentNode)
{
    StringBuilder sb = new StringBuilder();
    sb.Append("select * from tbTree order by [Index]");
    DataSet ds = DbHelperSQL.QueryDataSet(sb.ToString());           
    DataRow[] rows = ds.Tables[0].Select("ParentID=" + parentId);
    foreach (DataRow row in rows)
    {
        TreeListNode treeNode;
        //添加根节点
        if (parentNode == null)
        {
            treeNode = this.treeList1.AppendNode(new object[] { row["ConText"] }, null);
        }
        else
        {
            treeNode = parentNode.TreeList.AppendNode(new object[] { row["ConText"] }, parentNode);
        }
        BindTree(Convert.ToInt32(row["ID"]), treeNode);
        treeNode.ExpandAll();
    }
}

 

posted on 2014-10-15 10:51  梦中谁在耳边低语  阅读(773)  评论(0编辑  收藏  举报