[DEVEXPRESS/WINFORM] TreeList 클래스 : FilterPopupExcelData 이벤트를 사용해 필터 팝업 엑셀 데이터 설정하기

TestProject.zip

다운로드

▶ MainForm.cs

using System;

using DevExpress.XtraEditors;
using DevExpress.XtraTreeList;

namespace TestProject
{
    /// <summary>
    /// 메인 폼
    /// </summary>
    public partial class MainForm : XtraForm
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainForm()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainForm()
        {
            InitializeComponent();

            Load                               += Form_Load;
            this.treeList.FilterPopupExcelData += treeList_FilterPopupExcelData;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region 폼 로드시 처리하기 - Form_Load(sender, e)

        /// <summary>
        /// 폼 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Form_Load(object sender, EventArgs e)
        {
            this.treeList.RowHeight                              = 25;
            this.treeList.OptionsView.AutoWidth                  = false;
            this.treeList.OptionsBehavior.ReadOnly               = true;
            this.treeList.OptionsBehavior.PopulateServiceColumns = true;
            this.treeList.KeyFieldName                           = "ID";
            this.treeList.ParentFieldName                        = "RegionID";

            this.treeList.DataSource = SalesData.GetSalesDataList();

            this.treeList.Columns[this.treeList.KeyFieldName   ].Visible = false;
            this.treeList.Columns[this.treeList.ParentFieldName].Visible = false;

            this.treeList.BestFitColumns();
        }

        #endregion
        #region 트리 리스트 팝업 엑셀 데이터 필터 설정하기 - treeList_FilterPopupExcelData(sender, e)

        /// <summary>
        /// 트리 리스트 팝업 엑셀 데이터 필터 설정하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void treeList_FilterPopupExcelData(object sender, FilterPopupExcelDataEventArgs e)
        {
            TreeList treeList = sender as TreeList;

            if(e.Column == treeList.Columns["Region"])
            {
                e.AddFilter("<color=green>Europe</color>"  , "Contains([Region], 'Europe')" , true);
                e.AddFilter("<color=orange>America</color>", "Contains([Region], 'America')", true);
                e.AddFilter("<color=red>Asia</color>"      , "Contains([Region], 'Asia')"   , true);
            }
        }

        #endregion
    }
}