XtraTreeList 控件使用

 DevExpress控件,最近的项目里有用到·功能确实强大，一个控件抵的上以前vs自带控件的几个，算得上是复合控件的。今天来记下XtraTreeList 控件使用，备忘···

1.treeList1绑定数据

C#代码 复制代码 收藏代码
  1. public void InitDate()   
  2.         {   
  3.             ds = SqlData.QueryDataSet("select deptid,name,code,rootid from dbo.bm_dept");   
  4.   
  5.             treeList1.OptionsBehavior.PopulateServiceColumns = true;   
  6.             //this.treeList1.PopulateColumns();   
  7.             this.treeList1.ParentFieldName = "rootid";   
  8.             this.treeList1.KeyFieldName = "deptid";   
  9.   
  10.             this.treeList1.DataSource = ds.Tables[0];   
  11.         }  
public void InitDate()
        {
            ds = SqlData.QueryDataSet("select deptid,name,code,rootid from dbo.bm_dept");

            treeList1.OptionsBehavior.PopulateServiceColumns = true;
            //this.treeList1.PopulateColumns();
            this.treeList1.ParentFieldName = "rootid";
            this.treeList1.KeyFieldName = "deptid";

            this.treeList1.DataSource = ds.Tables[0];
        }

 

其中的 this.treeList1.ParentFieldName = "rootid";
            this.treeList1.KeyFieldName = "deptid";很重要 ParentFieldName 设置的字段是从属于KeyFieldName设置的字段的。如果A数据ParentFieldName 字段等于B数据的KeyFieldName字段，那A是B的子节点，设置成0 那A是根节点·

所以添加新数据时，要注意KeyFieldName字段的选择，确立从属关系··

2.修改时 具备XtraGridControl 列修改的功能

C#代码 复制代码 收藏代码
  1. private void treeList1_CellValueChanged(object sender, DevExpress.XtraTreeList.CellValueChangedEventArgs e)   
  2.         {   
  3.             try  
  4.             {   
  5.                 string colKey = e.Column.FieldName;   
  6.                 string sqlStr = "";   
  7.                 switch (colKey)   
  8.                 {   
  9.                         //select deptid,name,code,rootid from bm_dept   
  10.                     case "deptid":   
  11.                         sqlStr = string.Format("update bm_dept set {0}='{1}' where deptid='{2}'", colKey, e.Value, treeList1.FocusedNode.GetValue("deptid").ToString());   
  12.                         break;   
  13.                     case "name":   
  14.                         sqlStr = string.Format("update bm_dept set {0}='{1}' where deptid='{2}'", colKey, e.Value, treeList1.FocusedNode.GetValue("deptid").ToString());   
  15.                         break;   
  16.                     default:   
  17.                         break;   
  18.                 }   
  19.                 if (!sqlStr.Trim().Equals(""))   
  20.                     SqlData.ExecuteSql(sqlStr);   
  21.                 InitDate();   
  22.             }   
  23.             catch (Exception ex)   
  24.             {   
  25.                 XtraMessageBox.Show(ex.Message.ToString());   
  26.             }   
  27.         }  
private void treeList1_CellValueChanged(object sender, DevExpress.XtraTreeList.CellValueChangedEventArgs e)
        {
            try
            {
                string colKey = e.Column.FieldName;
                string sqlStr = "";
                switch (colKey)
                {
                        //select deptid,name,code,rootid from bm_dept
                    case "deptid":
                        sqlStr = string.Format("update bm_dept set {0}='{1}' where deptid='{2}'", colKey, e.Value, treeList1.FocusedNode.GetValue("deptid").ToString());
                        break;
                    case "name":
                        sqlStr = string.Format("update bm_dept set {0}='{1}' where deptid='{2}'", colKey, e.Value, treeList1.FocusedNode.GetValue("deptid").ToString());
                        break;
                    default:
                        break;
                }
                if (!sqlStr.Trim().Equals(""))
                    SqlData.ExecuteSql(sqlStr);
                InitDate();
            }
            catch (Exception ex)
            {
                XtraMessageBox.Show(ex.Message.ToString());
            }
        }

 

3.删除功能 注意：treeList1.FocusedNode.GetValue("deptid").ToString() 获取行的列值

C#代码 复制代码 收藏代码
  1. private void sBtnDel_Click(object sender, EventArgs e)   
  2.         {   
  3.             //if(treeList1.FocusedNode != null)   
  4.             //    treeList1.DeleteNode(treeList1.FocusedNode);   
  5.             int deid = int.Parse(treeList1.FocusedNode.GetValue("deptid").ToString());   
  6.             SqlDataReader dr = SqlData.QueryDataReader("select rootid from bm_dept");   
  7.             while (dr.Read())   
  8.             {   
  9.                 int rtid = int.Parse(dr["rootid"].ToString());   
  10.                 if ( rtid== deid)   
  11.                 {   
  12.                     MessageBox.Show("根节点不能删除！请先删除子节点。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);   
  13.                     return;   
  14.                 }   
  15.             }   
  16.   
  17.             if (treeList1.FocusedNode != null)   
  18.             {   
  19.                 if (MessageBox.Show("确认删除嘛？", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)   
  20.                 {   
  21.                     try  
  22.                     {   
  23.                         int i= SqlData.ExecuteSql("delete from bm_dept where deptid='" + treeList1.FocusedNode.GetValue("deptid").ToString() + "'");   
  24.                         if (i > 0)   
  25.                         {   
  26.                             InitDate();   
  27.                         }   
  28.                     }   
  29.                     catch (Exception ex)   
  30.                     {   
  31.                         MessageBox.Show(ex.Message);   
  32.                     }   
  33.                 }   
  34.             }   
  35.             else  
  36.             { MessageBox.Show("请选择行", "系统提示"); }   
  37.   
  38.         }  
private void sBtnDel_Click(object sender, EventArgs e)
        {
            //if(treeList1.FocusedNode != null)
            //    treeList1.DeleteNode(treeList1.FocusedNode);
            int deid = int.Parse(treeList1.FocusedNode.GetValue("deptid").ToString());
            SqlDataReader dr = SqlData.QueryDataReader("select rootid from bm_dept");
            while (dr.Read())
            {
                int rtid = int.Parse(dr["rootid"].ToString());
                if ( rtid== deid)
                {
                    MessageBox.Show("根节点不能删除！请先删除子节点。", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
            }

            if (treeList1.FocusedNode != null)
            {
                if (MessageBox.Show("确认删除嘛？", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
                {
                    try
                    {
                        int i= SqlData.ExecuteSql("delete from bm_dept where deptid='" + treeList1.FocusedNode.GetValue("deptid").ToString() + "'");
                        if (i > 0)
                        {
                            InitDate();
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
            else
            { MessageBox.Show("请选择行", "系统提示"); }

        }

 

4.TreeList 节点拖放

C#代码 复制代码 收藏代码
  1. string mubiao tuo ；//全局变量   
  2.   
  3. private void treeList1_DragDrop(object sender, DragEventArgs e)   
  4.         {   
  5.             DevExpress.XtraTreeList.TreeListHitInfo hi = treeList1.CalcHitInfo(treeList1.PointToClient(new Point(e.X, e.Y)));   
  6.             mubiao = hi.Node.GetValue("deptid").ToString();   
  7.   
  8.             if (index == 0)   
  9.             {   
  10.                 //MessageBox.Show("放到当前节点的下级");   
  11.                 string sql = string.Format("update bm_dept set rootid='{0}' where deptid='{1}'", mubiao, tuo);   
  12.                 SqlData.ExecuteSql(sql);   
  13.   
  14.             }   
  15.             else  
  16.             {   
  17.                 //MessageBox.Show("放到当前节点同级");   
  18.                 SqlDataReader dr = SqlData.QueryDataReader("select rootid from bm_dept where deptid='" + mubiao + "'");   
  19.                 dr.Read();   
  20.                 string roots=dr["rootid"].ToString();   
  21.                 string sql = string.Format("update bm_dept set rootid='{0}' where deptid='{1}'", roots, tuo);   
  22.                 SqlData.ExecuteSql(sql);   
  23.             }   
  24.   
  25.               
  26.             mubiao = "";   
  27.         }   
  28.   
  29.         private void treeList1_DragEnter(object sender, DragEventArgs e)   
  30.         {   
  31.             tuo = treeList1.FocusedNode.GetValue("deptid").ToString();   
  32.         }   
  33.   
  34.         private void treeList1_CalcNodeDragImageIndex(object sender, DevExpress.XtraTreeList.CalcNodeDragImageIndexEventArgs e)   
  35.         {   
  36.             index = e.ImageIndex;   
  37.         }   
  38.    
string mubiao tuo ；//全局变量

private void treeList1_DragDrop(object sender, DragEventArgs e)
        {
            DevExpress.XtraTreeList.TreeListHitInfo hi = treeList1.CalcHitInfo(treeList1.PointToClient(new Point(e.X, e.Y)));
            mubiao = hi.Node.GetValue("deptid").ToString();

            if (index == 0)
            {
                //MessageBox.Show("放到当前节点的下级");
                string sql = string.Format("update bm_dept set rootid='{0}' where deptid='{1}'", mubiao, tuo);
                SqlData.ExecuteSql(sql);

            }
            else
            {
                //MessageBox.Show("放到当前节点同级");
                SqlDataReader dr = SqlData.QueryDataReader("select rootid from bm_dept where deptid='" + mubiao + "'");
                dr.Read();
                string roots=dr["rootid"].ToString();
                string sql = string.Format("update bm_dept set rootid='{0}' where deptid='{1}'", roots, tuo);
                SqlData.ExecuteSql(sql);
            }

           
            mubiao = "";
        }

        private void treeList1_DragEnter(object sender, DragEventArgs e)
        {
            tuo = treeList1.FocusedNode.GetValue("deptid").ToString();
        }

        private void treeList1_CalcNodeDragImageIndex(object sender, DevExpress.XtraTreeList.CalcNodeDragImageIndexEventArgs e)
        {
            index = e.ImageIndex;
        }
posted @ 2012-12-10 16:25  水一木  阅读(464)  评论(0)    收藏  举报