Raysoft.Framework.BindingUtility.TreeViewHelper

using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using Raysoft.DBUtility;
using System.Data;

namespace Raysoft.Framework.BindingUtility
{
    public partial class TreeViewHelper
    {

        #region 递归绑定树控件
        /// <summary>
        /// 动态创建TreeView
        /// </summary>
        /// <param name="sqlText">传入的SQL语句</param>
        /// <param name="nodes">TreeView节点集</param>
        /// <param name="conn">数据库连接旁字串</param>
        public void BindingTreeView(string sqlText, TreeNodeCollection nodes,string conn)
        {
            try
            {
                DataTable dbTable = new DataTable();//实例化一个DataTable数据表对象

                if (conn == "")
                {
                    dbTable = SqlHelper.ExecuteDataSet(sqlText, null).Tables[0];//返数据表
                }
                else
                {
                    dbTable = SqlHelper.ExecuteDataSet(conn,CommandType.Text ,sqlText, null).Tables[0];//返数据表
                }

                //将第一级菜单取出生成TreeView的节点,作为递归运算的入口递归查询出TreeView的所有节点数据
                CreateTreeViewRecursive(nodes, dbTable, 0);
            }
            catch (Exception tv_ex)
            {
                MessageBox.Show(tv_ex.Message);
            }
        }


        /// <summary>
        /// 递归查询
        /// </summary>
        /// <param name="nodes">TreeView节点集合</param>
        /// <param name="dataSource">数据源</param>
        /// <param name="parentid">上一级菜单节点标识码</param>
        public void CreateTreeViewRecursive(TreeNodeCollection nodes, DataTable dataSource, int parentid)
        {
            string filter;//定义一个过滤器
            filter = string.Format("FParentId={0}", parentid);

            DataRow[] drarr = dataSource.Select(filter);//将过滤的ID放入数组中

            TreeNode node;
            foreach (DataRow dr in drarr)//递归循环查询出数据
            {
                node = new TreeNode();
                node.Text = dr["FName"].ToString();
                node.Tag = Convert.ToInt32(dr["fItemId"]);
                node.ToolTipText = dr["FFullNumber"].ToString();
                nodes.Add(node);//加入节点
                CreateTreeViewRecursive(node.Nodes, dataSource, Convert.ToInt32(node.Tag));
            }
        }

        #endregion


        #region 连带全选所有子节点
        /// <summary>
        /// TreeView的checkbox父节点连带子节点
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public  void CheckAllChildNode(TreeViewEventArgs e)
        {
            if (e.Action == TreeViewAction.ByMouse)
            {

                if (e.Node.Checked)
                {

                    //节点选中之后，取消所有父节点的选中状态   
                    setChildNodeCheckedState(e.Node, true);

                }
                else
                {
                    //取消节点选中状态之后，取消所有父节点的选中状态   
                    setChildNodeCheckedState(e.Node, false);
                    //如果节点存在父节点，取消父节点的选中状态 
                    if (e.Node.Parent != null) 
                    { 
                        setParentNodeCheckedState(e.Node, false); 
                    }                   
                }
            }
        }
        //取消节点选中状态之后，取消所有父节点的选中状态   
        private void setParentNodeCheckedState(TreeNode currNode, bool state)
        {
            TreeNode parentNode = currNode.Parent;

            parentNode.Checked = state;
            if (currNode.Parent.Parent != null)
            {
                setParentNodeCheckedState(currNode.Parent, state);
            }
        }
        //选中节点之后，选中节点的所有子节点   
        private void setChildNodeCheckedState(TreeNode currNode, bool state)
        {
            TreeNodeCollection nodes = currNode.Nodes;
            if (nodes.Count > 0)
                foreach (TreeNode tn in nodes)
                {

                    tn.Checked = state;
                    setChildNodeCheckedState(tn, state);
                }

        }
	#endregion
        

        /// <summary>
        /// 在点子节点的时候一定要点击父节点
        /// </summary>
        /// <param name="e"></param>
        public void CheckParentNode(TreeViewCancelEventArgs e)
        {
            if (e.Action == TreeViewAction.ByMouse)
            {
                if (!e.Node.Parent.Checked)
                {
                    MessageBox.Show("请先选择" + e.Node.Parent.Text + "！");
                    e.Cancel = true;
                    return;
                }
            }
        }
    }
}