這種數(shù)據(jù)庫設(shè)計是比較常見的，一般數(shù)據(jù)滿足樹形關(guān)系就可以這樣設(shè)計。綁定數(shù)據(jù)時，只需指定DataSource為對應(yīng) 的DataTable,指定KeyFieldName為表主鍵字段，ParentFieldName為表指向主鍵的外鍵字段名。

復(fù)制代碼代碼如下:

private void BindData()
{
    this.tlOffice.DataSource = dtOffice;
    tlOffice.KeyFieldName = "OfficeID";
    //tlOffice.DataMember = "OfficeName";
    tlOffice.Columns["OfficeName"].Caption = "局名稱";
    tlOffice.ParentFieldName = "ParentOfficeID";
}

2 基本功能的實現(xiàn)

① . 選擇某一節(jié)點時,該節(jié)點的子節(jié)點全部選擇取消某一節(jié)點時,該節(jié)點的子節(jié)點全部取消選擇

哪個節(jié)點引起行為的？節(jié)點是選中還是取消選中？由此確定方法的兩個參數(shù)：TreeListNode和CheckState。遍歷該節(jié)點及其子孫，并將其選中狀態(tài)設(shè)置為該節(jié)點的狀態(tài)即可。

復(fù)制代碼代碼如下:

/// <summary>
         /// 選擇某一節(jié)點時,該節(jié)點的子節(jié)點全部選擇  取消某一節(jié)點時,該節(jié)點的子節(jié)點全部取消選擇
         /// </summary>
         /// <param name="node"></param>
         /// <param name="state"></param>
         private void SetCheckedChildNodes(TreeListNode node, CheckState check)
         {
             for (int i = 0; i < node.Nodes.Count; i++)
             {
                 node.Nodes[i].CheckState = check;
                 SetCheckedChildNodes(node.Nodes[i], check);
             }
         }

② .某節(jié)點的子節(jié)點全部選擇時,該節(jié)點選擇；某節(jié)點的子節(jié)點未全部選擇時,該節(jié)點不選擇

復(fù)制代碼代碼如下:

/// <summary>
         /// 某節(jié)點的子節(jié)點全部選擇時,該節(jié)點選擇   某節(jié)點的子節(jié)點未全部選擇時,該節(jié)點不選擇
         /// </summary>
         /// <param name="node"></param>
         /// <param name="check"></param>
         private void SetCheckedParentNodes(TreeListNode node, CheckState check)
         {
             if (node.ParentNode != null)
             {

                 CheckState parentCheckState = node.ParentNode.CheckState;
                 CheckState nodeCheckState;
                 for (int i = 0; i < node.ParentNode.Nodes.Count; i++)
                 {
                     nodeCheckState = (CheckState)node.ParentNode.Nodes[i].CheckState;
                     if (!check.Equals(nodeCheckState))//只要任意一個與其選中狀態(tài)不一樣即父節(jié)點狀態(tài)不全選
                     {
                         parentCheckState = CheckState.Unchecked;
                         break;
                     }
                     parentCheckState = check;//否則（該節(jié)點的兄弟節(jié)點選中狀態(tài)都相同），則父節(jié)點選中狀態(tài)為該節(jié)點的選中狀態(tài)
                 }

                 node.ParentNode.CheckState = parentCheckState;
                 SetCheckedParentNodes(node.ParentNode, check);//遍歷上級節(jié)點
             }
         }

上兩步寫好了，別忘了上面的兩個方法在TreeList_AfterCheckNode里面觸發(fā)：

復(fù)制代碼代碼如下:

private void tlOffice_AfterCheckNode(object sender, DevExpress.XtraTreeList.NodeEventArgs e)
{
    SetCheckedChildNodes(e.Node, e.Node.CheckState);
    SetCheckedParentNodes(e.Node, e.Node.CheckState);
}

3.獲取選中的復(fù)選框數(shù)據(jù)列表

復(fù)制代碼代碼如下:

private List<int> lstCheckedOfficeID = new List<int>();//選擇局ID集合
            /// <summary>
         /// 獲取選擇狀態(tài)的數(shù)據(jù)主鍵ID集合
         /// </summary>
         /// <param name="parentNode">父級節(jié)點</param>
         private void GetCheckedOfficeID(TreeListNode parentNode)
         {
             if (parentNode.Nodes.Count == 0)
             {
                 return;//遞歸終止
             }

             foreach (TreeListNode node in parentNode.Nodes)
             {
                 if (node.CheckState == CheckState.Checked)
                 {
                     DataRowView drv = tlOffice.GetDataRecordByNode(node) as DataRowView;
                                          //關(guān)鍵代碼，就是不知道是這樣獲取數(shù)據(jù)而糾結(jié)了很久(鬼知道可以轉(zhuǎn)換為DataRowView啊)
                     if (drv != null)
                     {
                         int OfficeID = (int)drv["OfficeID"];
                         lstCheckedOfficeID.Add(OfficeID);
                     }

                     
                 }
                 GetCheckedOfficeID(node);
             }
         }

下面測試獲取主鍵列表：

復(fù)制代碼代碼如下:

private void btnCheck_Click(object sender, EventArgs e)
         {
             this.lstCheckedOfficeID.Clear();

             if (tlOffice.Nodes.Count > 0)
             {
                 foreach (TreeListNode root in tlOffice.Nodes)
                 {
                     GetCheckedOfficeID(root);
                 }
             }

             string idStr = string.Empty;
             foreach (int id in lstCheckedOfficeID)
             {
                 idStr += id + " ";
             }
             MessageBox.Show(idStr);
         }