첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
유용한 소스 코드가 있으면 icodebroker@naver.com으로 보내주시면 감사합니다.
블로그 자료는 자유롭게 사용하세요.

■ GridView 클래스 : 모든 마스터/클론 뷰의 행들 나열하기

------------------------------------------------------------------------------------------------------------------------


TestProject.zip


MainForm.cs

 

 

using System;

using System.Data;

using System.Data.OleDb;

using System.Text;

using System.Windows.Forms;

 

using DevExpress.Utils;

using DevExpress.XtraEditors;

using DevExpress.XtraGrid.Views.Grid;

 

namespace TestProject

{

    /// <summary>

    /// 메인 폼

    /// </summary>

    public partial class MainForm : XtraForm

    {

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor

        ////////////////////////////////////////////////////////////////////////////////////////// Public

 

        #region 생성자 - MainForm()

 

        /// <summary>

        /// 생성자

        /// </summary>

        public MainForm()

        {

            InitializeComponent();

 

            #region 데이터를 로드한다.

 

            DataSet dataSet = new DataSet();

 

            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb");

 

            OleDbDataAdapter customersAdapter = new OleDbDataAdapter("SELECT * FROM Customers", connection);

 

            OleDbDataAdapter ordersAdapter = new OleDbDataAdapter("SELECT * FROM Orders", connection);

 

            OleDbDataAdapter orderDetailsAdapter = new OleDbDataAdapter("SELECT * FROM [Order Details]", connection);

 

            customersAdapter.Fill(dataSet, "Customers");

 

            ordersAdapter.Fill(dataSet, "Orders");

 

            orderDetailsAdapter.Fill(dataSet, "Order Details");

 

            DataColumn customerIDKeyColumn        = dataSet.Tables["Customers"].Columns["CustomerID"];

            DataColumn customerIDForeignKeyColumn = dataSet.Tables["Orders"   ].Columns["CustomerID"];

 

            dataSet.Relations.Add("CustomersOrders", customerIDKeyColumn, customerIDForeignKeyColumn);

 

            DataColumn orderIDKeyColumn        = dataSet.Tables["Orders"       ].Columns["OrderID"];

            DataColumn orderIDForeignKeyColumn = dataSet.Tables["Order Details"].Columns["OrderID"];

 

            dataSet.Relations.Add("OrdersOrderDatails", orderIDKeyColumn, orderIDForeignKeyColumn);

 

            #endregion

            #region 조부모 그리드 뷰를 설정한다.

 

            this.gridView1.InitializeView

            (

                true,                           // Multi Select

                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style

                true,                           // Show Indicator

                true,                           // Show Column Headers

                true,                           // Allow Column Moving

                true,                           // Allow Column Resizing

                true,                           // Allow Filter

                true,                           // Allow Sort

                false,                          // Allow Cell Merge

                EditorShowMode.Default,         // Editor Show Mode

                false                           // Editable

            );

 

            this.gridView1.OptionsDetail.EnableMasterViewMode = true;

 

            this.gridView1.OptionsBehavior.AutoPopulateColumns = true;

 

            #endregion

            #region 부모 그리드 뷰를 설정한다.

 

            this.gridView2.InitializeView

            (

                true,                           // Multi Select

                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style

                true,                           // Show Indicator

                true,                           // Show Column Headers

                true,                           // Allow Column Moving

                true,                           // Allow Column Resizing

                true,                           // Allow Filter

                true,                           // Allow Sort

                false,                          // Allow Cell Merge

                EditorShowMode.Default,         // Editor Show Mode

                false                           // Editable

            );

 

            this.gridView2.OptionsBehavior.AutoPopulateColumns = true;

 

            #endregion

            #region 자식 그리드 뷰를 설정한다.

 

            this.gridView3.InitializeView

            (

                true,                           // Multi Select

                GridMultiSelectMode.CellSelect, // Grid Multi Select Mode

                DrawFocusRectStyle.CellFocus,   // Draw Focus Rect Style

                true,                           // Show Indicator

                true,                           // Show Column Headers

                true,                           // Allow Column Moving

                true,                           // Allow Column Resizing

                true,                           // Allow Filter

                true,                           // Allow Sort

                false,                          // Allow Cell Merge

                EditorShowMode.Default,         // Editor Show Mode

                false                           // Editable

            );

 

            this.gridView3.OptionsBehavior.AutoPopulateColumns = true;

 

            #endregion

 

            this.gridControl.DataSource = dataSet;

            this.gridControl.DataMember = "Customers";

 

            this.gridView1.BestFitColumns();

 

            this.gridView1.MasterRowExpanded += gridView_MasterRowExpanded;

            this.executeButton.Click         += executeButton_Click;

        }

 

        #endregion

 

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method

        ////////////////////////////////////////////////////////////////////////////////////////// Private

        //////////////////////////////////////////////////////////////////////////////// Event

 

        #region 그리드 뷰 마스터 행 확장시 처리하기 - gridView_MasterRowExpanded(sender, e)

 

        /// <summary>

        /// 그리드 뷰 마스터 행 확장시 처리하기

        /// </summary>

        /// <param name="sender">이벤트 발생자</param>

        /// <param name="e">이벤트 인자</param>

        private void gridView_MasterRowExpanded(object sender, CustomMasterRowEventArgs e)

        {

            GridView gridView = sender as GridView;

 

            GridView childGridView = gridView.GetDetailView(e.RowHandle, e.RelationIndex) as GridView;

 

            if(childGridView.Name == "gridView1")

            {

                childGridView.Name = "gridView2";

 

                childGridView.BestFitColumns();

 

                childGridView.MasterRowExpanded += gridView_MasterRowExpanded;

            }

            else if(childGridView.Name == "gridView2")

            {

                childGridView.Name = "gridView3";

 

                childGridView.BestFitColumns();

            }

        }

 

        #endregion

        #region 실행 버튼 클릭시 처리하기 - executeButton_Click(sender, e)

 

        /// <summary>

        /// 실행 버튼 클릭시 처리하기

        /// </summary>

        /// <param name="sender">이벤트 발생자</param>

        /// <param name="e">이벤트 인자</param>

        private void executeButton_Click(object sender, EventArgs e)

        {

            StringBuilder stringBuilder = new StringBuilder();

 

            EnumerateAllRows(this.gridView1, stringBuilder);

 

            XtraMessageBox.Show

            (

                this,

                "INFORMATION",

                stringBuilder.ToString(),

                MessageBoxButtons.OK,

                MessageBoxIcon.Information

            );

        }

 

        #endregion

 

        //////////////////////////////////////////////////////////////////////////////// Function

 

        #region 모든 행 나열하기 - EnumerateAllRows(gridView, stringBuilder)

 

        /// <summary>

        /// 모든 행 나열하기

        /// </summary>

        /// <param name="gridView">그리드 뷰</param>

        /// <param name="stringBuilder">문자열 빌더</param>

        /// <remarks>상세 뷰를 액세스하기 위해서 마스터 행이 반드시 확장되어야 한다.</remarks>

        private void EnumerateAllRows(GridView gridView, StringBuilder stringBuilder)

        {

            if(gridView == null)

            {

                return;

            }

 

            gridView.BeginUpdate();

 

            try

            {

                int dataRowCount = gridView.DataRowCount;

 

                string padding = string.Empty.PadLeft(gridView.DetailLevel * 4, ' ');

 

                for(int rowHandle = 0; rowHandle < dataRowCount; rowHandle++)

                {

                    stringBuilder.AppendLine($"{padding}{rowHandle}"); // 여기서 현재 행을 처리한다.

 

                    int relationCount = gridView.GetRelationCount(rowHandle);

 

                    for(int relationIndex = 0; relationIndex < relationCount; relationIndex++)

                    {

                        bool wasExpanded = gridView.GetMasterRowExpandedEx(rowHandle, relationIndex);

 

                        if(!wasExpanded)

                        {

                            gridView.SetMasterRowExpandedEx(rowHandle, relationIndex, true);

                        }

 

                        EnumerateAllRows(gridView.GetDetailView(rowHandle, relationIndex) as GridView, stringBuilder);

 

                        gridView.SetMasterRowExpandedEx(rowHandle, relationIndex, wasExpanded);

                    }

                }

            }

            finally

            {

                gridView.EndUpdate();

            }

        }

 

        #endregion

    }

}

 

------------------------------------------------------------------------------------------------------------------------

Posted by 사용자 icodebroker
TAG

댓글을 달아 주세요