DEV系列--treeList用法

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/tingzhiyi/article/details/50838181

从数据库读取数据显示到treeList中

效果图:



数据库表的设计图:


源代码:

<span style="font-size:24px;">using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Data.SqlClient;
using DevExpress.XtraTreeList.Nodes;

namespace lianxi
{
    public partial class treelist_shijian : DevExpress.XtraEditors.XtraForm
    {
        public treelist_shijian()
        {
            InitializeComponent();
            ShuJu();
        }
        //读取数据库绑定到treeList1中
        public void ShuJu()
        {
            SqlConnection conn = new SqlConnection("server=(local);database=DEV_Test;Integrated Security=true;");
            
            SqlCommand comm = new SqlCommand("select * from Table_treelist", conn);//select后面要写“*”否则树形结构的效果出不来
             conn.Open();
            SqlDataReader reader = comm.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Load(reader);
            this.treeList1.DataSource = dt;
            
            this.treeList1.KeyFieldName = "编号";
            treeList1.ParentFieldName = "父类编号";
            treeList1.Columns[0].Caption = "公司";
            conn.Close();

            //显示复选框
            treeList1.OptionsView.ShowCheckBoxes = true;
        }

        //选择某一节点时,该节点的子节点全部选择  取消某一节点时,该节点的子节点全部取消选择
        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);
            }
        }

        
        // 某节点的子节点全部选择时,该节点选择   某节点的子节点未全部选择时,该节点不选择
        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))//只要任意一个与其选中状态不一样即父节点状态不全选
                    {
                        parentCheckState = CheckState.Unchecked;
                        break;
                    }
                    parentCheckState = check;//否则(该节点的兄弟节点选中状态都相同),则父节点选中状态为该节点的选中状态
                }

                node.ParentNode.CheckState = parentCheckState;
                SetCheckedParentNodes(node.ParentNode, check);//遍历上级节点
            }
        }

        //触发选择节点事件
        private void treeList1_AfterCheckNode(object sender, DevExpress.XtraTreeList.NodeEventArgs e)
        {
            SetCheckedChildNodes(e.Node, e.Node.CheckState);
            SetCheckedParentNodes(e.Node, e.Node.CheckState);
        }

        private List<string> lstCheckedOfficeID = new List<string>();//选择局ID集合
        
        // 获取选择状态的数据主键ID集合
        private void GetCheckedOfficeID(TreeListNode parentNode)
        {
            if (parentNode.Nodes.Count == 0)
            {
                return;//递归终止
            }

            foreach (TreeListNode node in parentNode.Nodes)
            {
                if (node.CheckState == CheckState.Checked)
                {
                    DataRowView drv = treeList1.GetDataRecordByNode(node) as DataRowView;
                    if (drv != null)
                    {
                        string OfficeID = (string)drv["名称"];
                        lstCheckedOfficeID.Add(OfficeID);
                    }

                }
                GetCheckedOfficeID(node);
            }
        }

        //查看哪些节点被选中
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            this.lstCheckedOfficeID.Clear();

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

            string idStr = string.Empty;
            foreach (string id in lstCheckedOfficeID)
            {
                idStr += id + " ";
            }
            MessageBox.Show(idStr);
        }
        
    }
}</span>

实例下载:http://download.csdn.net/detail/tingzhiyi/9457044

阅读更多

没有更多推荐了,返回首页