DEVEXPRESS Archives - 20 중 3 번째 페이지

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 포커스 데이터 행과 포커스 셀의 모양 변경하기

■ GridControl 클래스에서 포커스 데이터 행과 포커스 셀의 모양을 변경하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="GridControl 클래스 : 포커스 데이터 행과 포커스 셀의 모양 변경하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Window.Resources>
        <Style x:Key="CellStyleKey" TargetType="dxg:CellContentPresenter">
            <Style.Triggers>
                 <Trigger Property="dxg:DataViewBase.IsFocusedCell" Value="True">
                    <Setter Property="Background" Value="Green"  />
                    <Setter Property="Foreground" Value="Yellow" />
                </Trigger>
            </Style.Triggers>
        </Style>
        <Style x:Key="RowStyleKey" TargetType="dxg:GridRowContent">
            <Style.Triggers>
                <Trigger Property="dxg:DataViewBase.IsFocusedRow" Value="True">
                    <Setter Property="Background" Value="Gray"  />
                    <Setter Property="Foreground" Value="White" />
                </Trigger>
            </Style.Triggers>
        </Style>
    </Window.Resources>
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            AutoGenerateColumns="AddNew">
            <dxg:GridControl.View>
                <dxg:TableView
                    ShowGroupPanel="False"
                    AllowGrouping="False"
                    CellStyle="{StaticResource CellStyleKey}"
                    RowStyle="{StaticResource RowStyleKey}">
                </dxg:TableView>
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="GridControl 클래스 : 포커스 데이터 행과 포커스 셀의 모양 변경하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Window.Resources>

<Style.Triggers>

</Trigger>

</Style.Triggers>

</Style>

<Style.Triggers>

</Trigger>

</Style.Triggers>

</Style>

</Window.Resources>

<Grid>

<dxg:GridControl x:Name="gridControl"

AutoGenerateColumns="AddNew">

<dxg:GridControl.View>

<dxg:TableView

ShowGroupPanel="False"

AllowGrouping="False"

CellStyle="{StaticResource CellStyleKey}"

RowStyle="{StaticResource RowStyleKey}">

</dxg:TableView>

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new ProductList().GetData();
        }

        #endregion
    }
}

using System.Windows;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new ProductList().GetData();

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] TreeListControl 클래스 : 수동으로 드래그 & 드롭 사용하기

■ TreeListControl 클래스에서 수동으로 드래그 & 드롭을 사용하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
    Width="800"
    Height="600"
    Title="수동으로 드래그 &amp; 드롭 사용하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:TreeListControl x:Name="treeListControl"
            SelectionMode="Row">
            <dxg:TreeListControl.Columns>
                <dxg:TreeListColumn FieldName="Name"       ReadOnly="True" />
                <dxg:TreeListColumn FieldName="Department" ReadOnly="True" />
                <dxg:TreeListColumn FieldName="Position"   ReadOnly="True" />
            </dxg:TreeListControl.Columns>
            <dxg:TreeListControl.View>
                <dxg:TreeListView x:Name="treeListView"
                    KeyFieldName="ID"
                    ParentFieldName="ParentID"
                    EditorShowMode="MouseUpFocused"
                    AutoExpandAllNodes="True" />
            </dxg:TreeListControl.View>
            <i:Interaction.Behaviors>
                <dxg:TreeListDragDropManager
                    AllowDrag="True"
                    AllowDrop="True"
                    ScrollSpacing="50"
                    ScrollSpeed="1"
                    Drop="treeListDragDropManager_Drop" />
            </i:Interaction.Behaviors>
        </dxg:TreeListControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"

Width="800"

Height="600"

Title="수동으로 드래그 & 드롭 사용하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:TreeListControl x:Name="treeListControl"

SelectionMode="Row">

<dxg:TreeListControl.Columns>

<dxg:TreeListColumn FieldName="Name" ReadOnly="True" />

<dxg:TreeListColumn FieldName="Department" ReadOnly="True" />

<dxg:TreeListColumn FieldName="Position" ReadOnly="True" />

</dxg:TreeListControl.Columns>

<dxg:TreeListControl.View>

<dxg:TreeListView x:Name="treeListView"

KeyFieldName="ID"

ParentFieldName="ParentID"

EditorShowMode="MouseUpFocused"

AutoExpandAllNodes="True" />

</dxg:TreeListControl.View>

<i:Interaction.Behaviors>

<dxg:TreeListDragDropManager

AllowDrag="True"

AllowDrop="True"

ScrollSpacing="50"

ScrollSpeed="1"

Drop="treeListDragDropManager_Drop" />

</i:Interaction.Behaviors>

</dxg:TreeListControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

using DevExpress.Xpf.Grid;
using DevExpress.Xpf.Grid.DragDrop;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.treeListControl.ItemsSource = new EmployeeList().GetData();
        }

        #endregion

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

        #region 트리 리스트 드래그/드롭 관리자 드롭시 처리하기 - treeListDragDropManager_Drop(sender, e)

        /// <summary>
        /// 트리 리스트 드래그/드롭 관리자 드롭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void treeListDragDropManager_Drop(object sender, TreeListDropEventArgs e)
        {
            if(e.TargetNode != null)
            {
                foreach(TreeListNode treeListNode in e.DraggedRows)
                {
                    (treeListNode.Content as Employee).Position   = (e.TargetNode.Content as Employee).Position;
                    (treeListNode.Content as Employee).Department = (e.TargetNode.Content as Employee).Department;
                }
            }

            if(e.DropTargetType == DropTargetType.InsertRowsIntoNode)
            {
                foreach(TreeListNode treeListNode in e.DraggedRows)
                {
                    (treeListNode.Content as Employee).Position = "";
                }
            }
        }

        #endregion
    }
}

using System.Windows;

using DevExpress.Xpf.Grid;

using DevExpress.Xpf.Grid.DragDrop;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.treeListControl.ItemsSource = new EmployeeList().GetData();

}

#endregion

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

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

#region 트리 리스트 드래그/드롭 관리자 드롭시 처리하기 - treeListDragDropManager_Drop(sender, e)

/// <summary>

/// 트리 리스트 드래그/드롭 관리자 드롭시 처리하기

/// </summary>

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

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

private void treeListDragDropManager_Drop(object sender, TreeListDropEventArgs e)

{

if(e.TargetNode != null)

{

foreach(TreeListNode treeListNode in e.DraggedRows)

{

(treeListNode.Content as Employee).Position = (e.TargetNode.Content as Employee).Position;

(treeListNode.Content as Employee).Department = (e.TargetNode.Content as Employee).Department;

}

if(e.DropTargetType == DropTargetType.InsertRowsIntoNode)

{

foreach(TreeListNode treeListNode in e.DraggedRows)

{

(treeListNode.Content as Employee).Position = "";

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] TreeListView 클래스 : 드래그 & 드롭 사용하기

■ TreeListView 클래스에서 드래그 & 드롭을 사용하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
    Width="800"
    Height="600"
    Title="TreeListView 클래스 : 드래그 &amp; 드롭 사용하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:TreeListControl x:Name="treeListControl"
            SelectionMode="Row">
            <dxg:TreeListControl.Columns>
                <dxg:TreeListColumn FieldName="Name"       ReadOnly="True" />
                <dxg:TreeListColumn FieldName="Department" ReadOnly="True" />
                <dxg:TreeListColumn FieldName="Position"   ReadOnly="True" />
            </dxg:TreeListControl.Columns>
            <dxg:TreeListControl.View>
                <dxg:TreeListView x:Name="treeListView"
                    KeyFieldName="ID"
                    ParentFieldName="ParentID"
                    EditorShowMode="MouseUpFocused"
                    AutoExpandAllNodes="True" />
            </dxg:TreeListControl.View>
            <i:Interaction.Behaviors>
                <dxg:TreeListDragDropManager
                    AllowDrag="True"
                    AllowDrop="True" />
            </i:Interaction.Behaviors>
        </dxg:TreeListControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"

Width="800"

Height="600"

Title="TreeListView 클래스 : 드래그 & 드롭 사용하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:TreeListControl x:Name="treeListControl"

SelectionMode="Row">

<dxg:TreeListControl.Columns>

<dxg:TreeListColumn FieldName="Name" ReadOnly="True" />

<dxg:TreeListColumn FieldName="Department" ReadOnly="True" />

<dxg:TreeListColumn FieldName="Position" ReadOnly="True" />

</dxg:TreeListControl.Columns>

<dxg:TreeListControl.View>

<dxg:TreeListView x:Name="treeListView"

KeyFieldName="ID"

ParentFieldName="ParentID"

EditorShowMode="MouseUpFocused"

AutoExpandAllNodes="True" />

</dxg:TreeListControl.View>

<i:Interaction.Behaviors>

<dxg:TreeListDragDropManager

AllowDrag="True"

AllowDrop="True" />

</i:Interaction.Behaviors>

</dxg:TreeListControl>

</Grid>

</Window>

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : TableView에서 드래그 & 드롭 사용하기

■ GridControl 클래스의 TableView에서 드래그 & 드롭을 사용하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
    Width="800"
    Height="600"
    Title="GridControl 클래스 : Table View에서 드래그 &amp; 드롭 사용하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            AllowLiveDataShaping="True"
            SelectionMode="Row">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="ID"         ReadOnly="True" />
                <dxg:GridColumn FieldName="Name"       ReadOnly="True" />
                <dxg:GridColumn FieldName="Department" ReadOnly="True" />
                <dxg:GridColumn FieldName="Position"   ReadOnly="True" />
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView
                    ShowGroupedColumns="True"
                    EditorShowMode="MouseUpFocused" />
            </dxg:GridControl.View>
            <i:Interaction.Behaviors>
                <dxg:GridDragDropManager
                    AllowDrag="True"
                    AllowDrop="True" />
            </i:Interaction.Behaviors>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"

Width="800"

Height="600"

Title="GridControl 클래스 : Table View에서 드래그 & 드롭 사용하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

AllowLiveDataShaping="True"

SelectionMode="Row">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="ID" ReadOnly="True" />

<dxg:GridColumn FieldName="Name" ReadOnly="True" />

<dxg:GridColumn FieldName="Department" ReadOnly="True" />

<dxg:GridColumn FieldName="Position" ReadOnly="True" />

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView

ShowGroupedColumns="True"

EditorShowMode="MouseUpFocused" />

</dxg:GridControl.View>

<i:Interaction.Behaviors>

<dxg:GridDragDropManager

AllowDrag="True"

AllowDrop="True" />

</i:Interaction.Behaviors>

</dxg:GridControl>

</Grid>

</Window>

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 편집 셀 간 커스텀 네비게이션 구현하기

■ GridControl 클래스에서 편집 셀 간 커스텀 네비게이션을 구현하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="편집 셀 간 커스텀 네비게이션 구현하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="ProductName" />
                <dxg:GridColumn FieldName="Country"     />
                <dxg:GridColumn FieldName="City"        />
                <dxg:GridColumn FieldName="UnitPrice"   />
                <dxg:GridColumn FieldName="Quantity"    />
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView>
                    <dxg:TableView.DataRowTemplate>
                        <DataTemplate>
                            <StackPanel>
                                <dxg:GridCellContentPresenter
                                    FieldName="ProductName"
                                    Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"
                                    NavigationIndex="0" />
                                <Grid>
                                    <Grid.ColumnDefinitions>
                                        <ColumnDefinition />
                                        <ColumnDefinition />
                                    </Grid.ColumnDefinitions>
                                    <dxg:GridCellContentPresenter
                                        FieldName="Country"
                                        Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"
                                        NavigationIndex="1" />
                                    <dxg:GridCellContentPresenter
                                        Grid.Column="1"
                                        FieldName="City"
                                        Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"
                                        NavigationIndex="2" />
                                </Grid>
                                <dxg:GridCellContentPresenter
                                    FieldName="UnitPrice"
                                    Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"
                                    NavigationIndex="3" />
                                <dxg:GridCellContentPresenter
                                    FieldName="Quantity"
                                    Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"
                                    NavigationIndex="4" />
                            </StackPanel>
                        </DataTemplate>
                    </dxg:TableView.DataRowTemplate>
                </dxg:TableView>
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="편집 셀 간 커스텀 네비게이션 구현하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="ProductName" />

<dxg:GridColumn FieldName="Country" />

<dxg:GridColumn FieldName="City" />

<dxg:GridColumn FieldName="UnitPrice" />

<dxg:GridColumn FieldName="Quantity" />

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView>

<dxg:TableView.DataRowTemplate>

<dxg:GridCellContentPresenter

FieldName="ProductName"

Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"

NavigationIndex="0" />

<Grid>

<Grid.ColumnDefinitions>

</Grid.ColumnDefinitions>

<dxg:GridCellContentPresenter

FieldName="Country"

Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"

NavigationIndex="1" />

<dxg:GridCellContentPresenter

Grid.Column="1"

FieldName="City"

Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"

NavigationIndex="2" />

</Grid>

<dxg:GridCellContentPresenter

FieldName="UnitPrice"

Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"

NavigationIndex="3" />

<dxg:GridCellContentPresenter

FieldName="Quantity"

Style="{Binding Path=(dxg:GridControl.ActiveView).CellStyle, RelativeSource={RelativeSource TemplatedParent}}"

NavigationIndex="4" />

</StackPanel>

</DataTemplate>

</dxg:TableView.DataRowTemplate>

</dxg:TableView>

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 행 더블 클릭 처리하기

■ GridControl 클래스에서 행 더블 클릭을 처리하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="행 더블 클릭 처리하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            MouseDoubleClick="gridControl_MouseDoubleClick">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="ProductName">
                    <dxg:GridColumn.EditSettings>
                        <dxe:TextEditSettings HorizontalContentAlignment="Center" />
                    </dxg:GridColumn.EditSettings>
                </dxg:GridColumn>
                <dxg:GridColumn FieldName="UnitPrice">
                    <dxg:GridColumn.EditSettings>
                        <dxe:SpinEditSettings HorizontalContentAlignment="Left" />
                    </dxg:GridColumn.EditSettings>
                </dxg:GridColumn>
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView Name="tableView" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="행 더블 클릭 처리하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

MouseDoubleClick="gridControl_MouseDoubleClick">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="ProductName">

<dxg:GridColumn.EditSettings>

<dxe:TextEditSettings HorizontalContentAlignment="Center" />

</dxg:GridColumn.EditSettings>

</dxg:GridColumn>

<dxg:GridColumn FieldName="UnitPrice">

<dxg:GridColumn.EditSettings>

<dxe:SpinEditSettings HorizontalContentAlignment="Left" />

</dxg:GridColumn.EditSettings>

</dxg:GridColumn>

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView Name="tableView" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;
using System.Windows.Input;

using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new ProductList().GetData();
        }

        #endregion

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

        #region 그리드 컨트롤 마우스 더블 클릭시 처리하기 - gridControl_MouseDoubleClick(sender, e)

        /// <summary>
        /// 그리드 컨트롤 마우스 더블 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            int rowHandle = this.tableView.GetRowHandleByMouseEventArgs(e);

            if(rowHandle == GridControl.InvalidRowHandle)
            {
                return;
            }

            if(this.gridControl.IsGroupRowHandle(rowHandle))
            {
                MessageBox.Show("A group row has been double clicked.", "Info");
            }
            else
            {
                MessageBox.Show("A data row has been double clicked.", "Info");
            }
        }

        #endregion
    }
}

using System.Windows;

using System.Windows.Input;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new ProductList().GetData();

}

#endregion

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

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

#region 그리드 컨트롤 마우스 더블 클릭시 처리하기 - gridControl_MouseDoubleClick(sender, e)

/// <summary>

/// 그리드 컨트롤 마우스 더블 클릭시 처리하기

/// </summary>

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

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

private void gridControl_MouseDoubleClick(object sender, MouseButtonEventArgs e)

{

int rowHandle = this.tableView.GetRowHandleByMouseEventArgs(e);

if(rowHandle == GridControl.InvalidRowHandle)

{

return;

}

if(this.gridControl.IsGroupRowHandle(rowHandle))

{

MessageBox.Show("A group row has been double clicked.", "Info");

}

else

{

MessageBox.Show("A data row has been double clicked.", "Info");

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : Per-Pixel 스크롤을 위한 커스텀 스크롤 애니메이션 구현하기

■ GridControl 클래스에서 Per-Pixel 스크롤을 위한 커스텀 스크롤 애니메이션을 구현하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="Per-Pixel 스크롤을 위한 커스텀 스크롤 애니메이션 구현하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            AutoPopulateColumns="True">
            <dxg:GridControl.View>
                <dxg:TableView x:Name="tableView"
                    AllowPerPixelScrolling="True"
                    ScrollAnimationMode="Custom"
                    CustomScrollAnimation="tableView_CustomScrollAnimation" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="Per-Pixel 스크롤을 위한 커스텀 스크롤 애니메이션 구현하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

AutoPopulateColumns="True">

<dxg:GridControl.View>

<dxg:TableView x:Name="tableView"

AllowPerPixelScrolling="True"

ScrollAnimationMode="Custom"

CustomScrollAnimation="tableView_CustomScrollAnimation" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System;
using System.Collections.Generic;
using System.Windows;
using System.Windows.Media.Animation;

using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = GetData();
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 테이블 뷰 커스텀 스크롤 애니메이션 처리하기 - tableView_CustomScrollAnimation(sender, e)

        /// <summary>
        /// 테이블 뷰 커스텀 스크롤 애니메이션 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void tableView_CustomScrollAnimation(object sender, CustomScrollAnimationEventArgs e)
        {
            e.Storyboard = new Storyboard();

            DoubleAnimation animation = new DoubleAnimation();

            animation.Duration       = new Duration(TimeSpan.FromMilliseconds(200));
            animation.From           = e.OldOffset;
            animation.To             = e.NewOffset;
            animation.EasingFunction = new ExponentialEase() { Exponent = 0 };

            e.Storyboard.Children.Add(animation);
        }

        #endregion

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

        #region 데이터 구하기 - GetData()

        /// <summary>
        /// 데이터 구하기
        /// </summary>
        /// <returns>샘플 리스트</returns>
        private List<Sample> GetData()
        {
            List<Sample> list = new List<Sample>();

            for(int i = 0; i < 100; i++)
            {
                list.Add(new Sample() { ID = i, Value = string.Format("Value {0}", i)  });
            }

            return list;
        }

        #endregion
    }
}

using System;

using System.Collections.Generic;

using System.Windows;

using System.Windows.Media.Animation;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = GetData();

}

#endregion

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

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

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

#region 테이블 뷰 커스텀 스크롤 애니메이션 처리하기 - tableView_CustomScrollAnimation(sender, e)

/// <summary>

/// 테이블 뷰 커스텀 스크롤 애니메이션 처리하기

/// </summary>

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

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

private void tableView_CustomScrollAnimation(object sender, CustomScrollAnimationEventArgs e)

{

e.Storyboard = new Storyboard();

DoubleAnimation animation = new DoubleAnimation();

animation.Duration = new Duration(TimeSpan.FromMilliseconds(200));

animation.From = e.OldOffset;

animation.To = e.NewOffset;

animation.EasingFunction = new ExponentialEase() { Exponent = 0 };

e.Storyboard.Children.Add(animation);

}

#endregion

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

#region 데이터 구하기 - GetData()

/// <summary>

/// 데이터 구하기

/// </summary>

/// <returns>샘플 리스트</returns>

private List<Sample> GetData()

{

List<Sample> list = new List<Sample>();

for(int i = 0; i < 100; i++)

{

list.Add(new Sample() { ID = i, Value = string.Format("Value {0}", i) });

}

return list;

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 커스텀 정렬 구현하기

■ GridControl 클래스에서 커스텀 정렬을 구현하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="커스텀 정렬 구현하기"
    FontFamily="나눔고딕코딩"
    FontSize="16"
    Loaded="Window_Loaded">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="Auto" />
            <RowDefinition Height="*"    />
        </Grid.RowDefinitions>
        <CheckBox
            Grid.Row="0"
            Margin="10"
            VerticalAlignment="Center"
            HorizontalAlignment="Center"
            Content="Custom Sort"
            Checked="checkBox_Checked"
            Unchecked="checkBox_Unchecked" />
        <dxg:GridControl x:Name="gridControl"
            Grid.Row="1"
            CustomColumnSort="gridControl_CustomColumnSort">
            <dxg:GridControl.View>
                <dxg:TableView x:Name="tableView"
                    ShowGroupPanel="False"
                    NavigationStyle="None" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="커스텀 정렬 구현하기"

FontFamily="나눔고딕코딩"

FontSize="16"

Loaded="Window_Loaded">

<Grid>

<Grid.RowDefinitions>

</Grid.RowDefinitions>

<CheckBox

Grid.Row="0"

Margin="10"

VerticalAlignment="Center"

HorizontalAlignment="Center"

Content="Custom Sort"

Checked="checkBox_Checked"

Unchecked="checkBox_Unchecked" />

<dxg:GridControl x:Name="gridControl"

Grid.Row="1"

CustomColumnSort="gridControl_CustomColumnSort">

<dxg:GridControl.View>

<dxg:TableView x:Name="tableView"

ShowGroupPanel="False"

NavigationStyle="None" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;
using System.Collections.Generic;

using DevExpress.Xpf.Grid;
using DevExpress.XtraGrid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

        #endregion

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

        #region 윈도우 로드시 처리하기 - Window_Loaded(sender, e)

        /// <summary>
        /// 윈도우 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            string[] strMonthArray = new string[]
            {
                "January", "February", "March"    ,
                "April"  , "May"     , "June"     ,
                "July"   , "August"  , "September",
                "October", "November", "December"
            };

            this.gridControl.ItemsSource = strMonthArray;

            this.gridControl.PopulateColumns();

            this.gridControl.SortBy(this.gridControl.Columns[0]);
        }

        #endregion
        #region 체크 박스 체크시 처리하기 - checkBox_Checked(sender, e)

        /// <summary>
        /// 체크 박스 체크시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void checkBox_Checked(object sender, RoutedEventArgs e)
        {
            this.gridControl.Columns[0].SortMode = ColumnSortMode.Custom;

            this.gridControl.SortBy(this.gridControl.Columns[0]);
        }

        #endregion
        #region 체크 박스 체크시 처리하기 - checkBox_Checked(sender, e)

        /// <summary>
        /// 체크 박스 체크시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void checkBox_Unchecked(object sender, RoutedEventArgs e)
        {
            this.gridControl.Columns[0].SortMode = ColumnSortMode.Default;

            this.gridControl.SortBy(this.gridControl.Columns[0]);
        }

        #endregion
        #region 그리드 컨트롤 커스텀 컬럼 정렬시 처리하기 - gridControl_CustomColumnSort(sender, e)

        /// <summary>
        /// 그리드 컨트롤 커스텀 컬럼 정렬시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_CustomColumnSort(object sender, CustomColumnSortEventArgs e)
        {
            e.Result = Comparer<int>.Default.Compare
            (
                e.ListSourceRowIndex1,
                e.ListSourceRowIndex2
            );

            e.Handled = true;
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

using System.Windows;

using System.Collections.Generic;

using DevExpress.Xpf.Grid;

using DevExpress.XtraGrid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

}

#endregion

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

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

#region 윈도우 로드시 처리하기 - Window_Loaded(sender, e)

/// <summary>

/// 윈도우 로드시 처리하기

/// </summary>

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

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

private void Window_Loaded(object sender, RoutedEventArgs e)

{

string[] strMonthArray = new string[]

{

"January", "February", "March" ,

"April" , "May" , "June" ,

"July" , "August" , "September",

"October", "November", "December"

};

this.gridControl.ItemsSource = strMonthArray;

this.gridControl.PopulateColumns();

this.gridControl.SortBy(this.gridControl.Columns[0]);

}

#endregion

#region 체크 박스 체크시 처리하기 - checkBox_Checked(sender, e)

/// <summary>

/// 체크 박스 체크시 처리하기

/// </summary>

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

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

private void checkBox_Checked(object sender, RoutedEventArgs e)

{

this.gridControl.Columns[0].SortMode = ColumnSortMode.Custom;

this.gridControl.SortBy(this.gridControl.Columns[0]);

}

#endregion

#region 체크 박스 체크시 처리하기 - checkBox_Checked(sender, e)

/// <summary>

/// 체크 박스 체크시 처리하기

/// </summary>

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

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

private void checkBox_Unchecked(object sender, RoutedEventArgs e)

{

this.gridControl.Columns[0].SortMode = ColumnSortMode.Default;

this.gridControl.SortBy(this.gridControl.Columns[0]);

}

#endregion

#region 그리드 컨트롤 커스텀 컬럼 정렬시 처리하기 - gridControl_CustomColumnSort(sender, e)

/// <summary>

/// 그리드 컨트롤 커스텀 컬럼 정렬시 처리하기

/// </summary>

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

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

private void gridControl_CustomColumnSort(object sender, CustomColumnSortEventArgs e)

{

e.Result = Comparer<int>.Default.Compare

(

e.ListSourceRowIndex1,

e.ListSourceRowIndex2

);

e.Handled = true;

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 커스텀 필터 드롭 다운 생성하기

■ GridControl 클래스에서 커스텀 필터 드롭 다운을 생성하는 방법을 보여준다. ▶ IntegerToBinaryOperatorValueConverter.cs


using System;
using System.Globalization;
using System.Windows.Data;

using DevExpress.Data.Filtering;

namespace TestProject
{
    /// <summary>
    /// 정수↔바이너리 연산자 값 변환자
    /// </summary>
    public class IntegerToBinaryOperatorValueConverter : IValueConverter
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 변환하기 - Convert(value, targetType, parameter, cultureInfo)

        /// <summary>
        /// 변환하기
        /// </summary>
        /// <param name="value">값</param>
        /// <param name="targetType">타겟 타입</param>
        /// <param name="parameter">매개 변수</param>
        /// <param name="cultureInfo">CultureInfo 객체</param>
        /// <returns>변환 값</returns>
        public object Convert(object value, Type targetType, object parameter, CultureInfo cultureInfo)
        {
            BinaryOperator binaryOperator = value as BinaryOperator;

            if(object.ReferenceEquals(binaryOperator, null))
            {
                return null;
            }

            OperandValue operandValue = binaryOperator.RightOperand as OperandValue;

            return operandValue.Value;
        }

        #endregion
        #region 역변환하기 - ConvertBack(value, targetType, parameter, cultureInfo)

        /// <summary>
        /// 역변환하기
        /// </summary>
        /// <param name="value">값</param>
        /// <param name="targetType">타겟 타입</param>
        /// <param name="parameter">매개 변수</param>
        /// <param name="cultureInfo">CultureInfo 객체</param>
        /// <returns>역변환 값</returns>
        public object ConvertBack(object value, Type targetType, object parameter, CultureInfo cultureInfo)
        {
            return new BinaryOperator("Index", System.Convert.ToInt32(value), BinaryOperatorType.Greater);
        }

        #endregion
    }
}

using System;

using System.Globalization;

using System.Windows.Data;

using DevExpress.Data.Filtering;

namespace TestProject

{

/// <summary>

/// 정수↔바이너리 연산자 값 변환자

/// </summary>

public class IntegerToBinaryOperatorValueConverter : IValueConverter

{

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

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

#region 변환하기 - Convert(value, targetType, parameter, cultureInfo)

/// <summary>

/// 변환하기

/// </summary>

/// <param name="value">값</param>

/// <param name="targetType">타겟 타입</param>

/// <param name="parameter">매개 변수</param>

/// <param name="cultureInfo">CultureInfo 객체</param>

/// <returns>변환 값</returns>

public object Convert(object value, Type targetType, object parameter, CultureInfo cultureInfo)

{

BinaryOperator binaryOperator = value as BinaryOperator;

if(object.ReferenceEquals(binaryOperator, null))

{

return null;

}

OperandValue operandValue = binaryOperator.RightOperand as OperandValue;

return operandValue.Value;

}

#endregion

#region 역변환하기 - ConvertBack(value, targetType, parameter, cultureInfo)

/// <summary>

/// 역변환하기

/// </summary>

/// <param name="value">값</param>

/// <param name="targetType">타겟 타입</param>

/// <param name="parameter">매개 변수</param>

/// <param name="cultureInfo">CultureInfo 객체</param>

/// <returns>역변환 값</returns>

public object ConvertBack(object value, Type targetType, object parameter, CultureInfo cultureInfo)

{

return new BinaryOperator("Index", System.Convert.ToInt32(value), BinaryOperatorType.Greater);

}

#endregion

}

▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    xmlns:local="clr-namespace:TestProject"
    Width="800"
    Height="600"
    Title="커스텀 필터 드롭 다운 생성하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <Grid.Resources>
            <local:IntegerToBinaryOperatorValueConverter x:Key="IntegerToBinaryOperatorValueConverterKey" />
        </Grid.Resources>
        <dxg:GridControl x:Name="gridControl">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="Index" FilterPopupMode="Custom">
                    <dxg:GridColumn.CustomColumnFilterPopupTemplate>
                        <DataTemplate>
                            <StackPanel>
                                <Label Margin="5" Content="Minimum Index :" />
                                    <Slider
                                        Margin="5"
                                        Width="200"
                                        Minimum="1"
                                        Maximum="99"
                                        Value="{Binding Path=CustomColumnFilter, RelativeSource={RelativeSource TemplatedParent},
                                            Converter={StaticResource IntegerToBinaryOperatorValueConverterKey}}" />
                            </StackPanel>
                        </DataTemplate>
                    </dxg:GridColumn.CustomColumnFilterPopupTemplate>
                </dxg:GridColumn>
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

xmlns:local="clr-namespace:TestProject"

Width="800"

Height="600"

Title="커스텀 필터 드롭 다운 생성하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<Grid.Resources>

<local:IntegerToBinaryOperatorValueConverter x:Key="IntegerToBinaryOperatorValueConverterKey" />

</Grid.Resources>

<dxg:GridControl x:Name="gridControl">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="Index" FilterPopupMode="Custom">

<dxg:GridColumn.CustomColumnFilterPopupTemplate>

<Slider

Margin="5"

Width="200"

Minimum="1"

Maximum="99"

Value="{Binding Path=CustomColumnFilter, RelativeSource={RelativeSource TemplatedParent},

Converter={StaticResource IntegerToBinaryOperatorValueConverterKey}}" />

</StackPanel>

</DataTemplate>

</dxg:GridColumn.CustomColumnFilterPopupTemplate>

</dxg:GridColumn>

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new SampleList().GetData();
        }

        #endregion
    }
}

using System.Windows;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new SampleList().GetData();

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 컬럼의 필터 드롭 다운 내에서 커스텀 필터 항목 만들기

■ GridControl 클래스에서 컬럼의 필터 드롭 다운 내에서 커스텀 필터 항목을 만드는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="컬럼의 필터 드롭 다운 내에서 커스텀 필터 항목 만들기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="UserName"         Header="User Name"         />
                <dxg:GridColumn FieldName="RegistrationDate" Header="Registration Date" />
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView
                    AutoWidth="True"
                    ShowFilterPopup="tableView_ShowFilterPopup" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="컬럼의 필터 드롭 다운 내에서 커스텀 필터 항목 만들기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="UserName" Header="User Name" />

<dxg:GridColumn FieldName="RegistrationDate" Header="Registration Date" />

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView

AutoWidth="True"

ShowFilterPopup="tableView_ShowFilterPopup" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System;
using System.Collections.Generic;
using System.Windows;

using DevExpress.Data.Filtering;
using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new AccountList().GetData();
        }

        #endregion

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

        #region 테이블 뷰 필터 팝업 보여주기 처리하기 - tableView_ShowFilterPopup(sender, e)

        /// <summary>
        /// 테이블 뷰 필터 팝업 보여주기 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void tableView_ShowFilterPopup(object sender, FilterPopupEventArgs e)
        {
            if(e.Column.FieldName != "RegistrationDate")
            {
                return;
            }

            List<object> list = new List<object>();

            list.Add
            (
                new CustomComboBoxItem()
                {
                    DisplayValue = "(All)",
                    EditValue    = new CustomComboBoxItem()
                }
            );

            list.Add
            (
                new CustomComboBoxItem()
                {
                    DisplayValue = "Registered in 2008",
                    EditValue    = CriteriaOperator.Parse
                    (
                        string.Format
                        (
                            "[RegistrationDate] >= #{0}# AND [RegistrationDate] < #{1}#",
                            new DateTime(2008, 1, 1).ToString("yyyy-MM-dd"),
                            new DateTime(2009, 1, 1).ToString("yyyy-MM-dd")
                        )
                    )
                }
            );

            list.Add
            (
                new CustomComboBoxItem()
                {
                    DisplayValue = "Registered in 2009",
                    EditValue    = CriteriaOperator.Parse
                    (
                        string.Format
                        (
                            "[RegistrationDate] >= #{0}# AND [RegistrationDate] < #{1}#",
                            new DateTime(2009, 1, 1).ToString("yyyy-MM-dd"),
                            new DateTime(2010, 1, 1).ToString("yyyy-MM-dd")
                        )
                    )
                }
            );

            e.ComboBoxEdit.ItemsSource = list;
        }

        #endregion
    }
}

100

101

using System;

using System.Collections.Generic;

using System.Windows;

using DevExpress.Data.Filtering;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new AccountList().GetData();

}

#endregion

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

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

#region 테이블 뷰 필터 팝업 보여주기 처리하기 - tableView_ShowFilterPopup(sender, e)

/// <summary>

/// 테이블 뷰 필터 팝업 보여주기 처리하기

/// </summary>

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

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

private void tableView_ShowFilterPopup(object sender, FilterPopupEventArgs e)

{

if(e.Column.FieldName != "RegistrationDate")

{

return;

}

List<object> list = new List<object>();

list.Add

(

new CustomComboBoxItem()

{

DisplayValue = "(All)",

EditValue = new CustomComboBoxItem()

}

);

list.Add

(

new CustomComboBoxItem()

{

DisplayValue = "Registered in 2008",

EditValue = CriteriaOperator.Parse

(

string.Format

(

"[RegistrationDate] >= #{0}# AND [RegistrationDate] < #{1}#",

new DateTime(2008, 1, 1).ToString("yyyy-MM-dd"),

new DateTime(2009, 1, 1).ToString("yyyy-MM-dd")

)

}

);

list.Add

(

new CustomComboBoxItem()

{

DisplayValue = "Registered in 2009",

EditValue = CriteriaOperator.Parse

(

string.Format

(

"[RegistrationDate] >= #{0}# AND [RegistrationDate] < #{1}#",

new DateTime(2009, 1, 1).ToString("yyyy-MM-dd"),

new DateTime(2010, 1, 1).ToString("yyyy-MM-dd")

)

}

);

e.ComboBoxEdit.ItemsSource = list;

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 커스텀 필터 구현하기

■ GridControl 클래스에서 커스텀 필터를 구현하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="커스텀 필터 구현하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="Auto" />
            <RowDefinition Height="*"    />
        </Grid.RowDefinitions>
        <StackPanel Grid.Row="0"
            Margin="0 10 0 10"
            Orientation="Horizontal">
            <CheckBox x:Name="hideEvenRowCheckBox"
                Margin="10 0 10 0"
                VerticalAlignment="Center"
                Content="Hide Even Row"
                Checked="checkBox_Checked"
                Unchecked="checkBox_Checked" />
            <CheckBox x:Name="hideOddRowCheckBox"
                VerticalAlignment="Center"
                Content="Hide Odd Row"
                Checked="checkBox_Checked"
                Unchecked="checkBox_Checked" />
        </StackPanel>
        <dxg:GridControl x:Name="gridControl" Grid.Row="1"
            AutoGenerateColumns="AddNew"
            CustomRowFilter="gridControl_CustomRowFilter">
            <dxg:GridControl.View>
                <dxg:TableView x:Name="tableView"
                    AutoWidth="True"
                    ShowGroupPanel="False"
                    NavigationStyle="None" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="커스텀 필터 구현하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<Grid.RowDefinitions>

</Grid.RowDefinitions>

<StackPanel Grid.Row="0"

Margin="0 10 0 10"

Orientation="Horizontal">

<CheckBox x:Name="hideEvenRowCheckBox"

Margin="10 0 10 0"

VerticalAlignment="Center"

Content="Hide Even Row"

Checked="checkBox_Checked"

Unchecked="checkBox_Checked" />

<CheckBox x:Name="hideOddRowCheckBox"

VerticalAlignment="Center"

Content="Hide Odd Row"

Checked="checkBox_Checked"

Unchecked="checkBox_Checked" />

</StackPanel>

<dxg:GridControl x:Name="gridControl" Grid.Row="1"

AutoGenerateColumns="AddNew"

CustomRowFilter="gridControl_CustomRowFilter">

<dxg:GridControl.View>

<dxg:TableView x:Name="tableView"

AutoWidth="True"

ShowGroupPanel="False"

NavigationStyle="None" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new object[] { "A", "B", "C", "D", "E", "F", "G", "H" };
        }

        #endregion

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

        #region 그리드 컨트롤 커스텀 행 필터 처리하기 - gridControl_CustomRowFilter(sender, e)

        /// <summary>
        /// 그리드 컨트롤 커스텀 행 필터 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_CustomRowFilter(object sender, RowFilterEventArgs e)
        {
            if(this.hideOddRowCheckBox.IsChecked.Value && e.ListSourceRowIndex % 2 == 1)
            {
                e.Visible = false;
            }

            if(this.hideEvenRowCheckBox.IsChecked.Value && e.ListSourceRowIndex % 2 == 0)
            {
                e.Visible = false;
            }

            e.Handled = !e.Visible ? true : false;
        }

        #endregion
        #region 체크 박스 체크시 처리하기 - checkBox_Checked(sender, e)

        /// <summary>
        /// 체크 박스 체크시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void checkBox_Checked(object sender, RoutedEventArgs e)
        {
            this.gridControl.RefreshData();
        }

        #endregion
    }
}

using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new object[] { "A", "B", "C", "D", "E", "F", "G", "H" };

}

#endregion

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

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

#region 그리드 컨트롤 커스텀 행 필터 처리하기 - gridControl_CustomRowFilter(sender, e)

/// <summary>

/// 그리드 컨트롤 커스텀 행 필터 처리하기

/// </summary>

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

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

private void gridControl_CustomRowFilter(object sender, RowFilterEventArgs e)

{

if(this.hideOddRowCheckBox.IsChecked.Value && e.ListSourceRowIndex % 2 == 1)

{

e.Visible = false;

}

if(this.hideEvenRowCheckBox.IsChecked.Value && e.ListSourceRowIndex % 2 == 0)

{

e.Visible = false;

}

e.Handled = !e.Visible ? true : false;

}

#endregion

#region 체크 박스 체크시 처리하기 - checkBox_Checked(sender, e)

/// <summary>

/// 체크 박스 체크시 처리하기

/// </summary>

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

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

private void checkBox_Checked(object sender, RoutedEventArgs e)

{

this.gridControl.RefreshData();

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 커스텀 그룹 구현하기

■ GridControl 클래스에서 커스텀 그룹을 구현하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="커스텀 그룹 구현하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            CustomColumnGroup="gridControl_CustomColumnGroup"
            CustomGroupDisplayText="gridControl_CustomGroupDisplayText">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="ProductName"  />
                <dxg:GridColumn FieldName="UnitsInStock" />
                <dxg:GridColumn FieldName="UnitsOnOrder" />
                <dxg:GridColumn
                    FieldName="UnitPrice"
                    SortMode="Custom">
                    <dxg:GridColumn.EditSettings>
                        <dxe:SpinEditSettings DisplayFormat="c2" />
                    </dxg:GridColumn.EditSettings>
                </dxg:GridColumn>
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="커스텀 그룹 구현하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

CustomColumnGroup="gridControl_CustomColumnGroup"

CustomGroupDisplayText="gridControl_CustomGroupDisplayText">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="ProductName" />

<dxg:GridColumn FieldName="UnitsInStock" />

<dxg:GridColumn FieldName="UnitsOnOrder" />

<dxg:GridColumn

FieldName="UnitPrice"

SortMode="Custom">

<dxg:GridColumn.EditSettings>

<dxe:SpinEditSettings DisplayFormat="c2" />

</dxg:GridColumn.EditSettings>

</dxg:GridColumn>

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System;
using System.Collections;
using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new NorthwindEntities().Products;

            this.gridControl.Columns["UnitPrice"].GroupIndex = 0;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 그리드 컨트롤 커스텀 컬럼 그룹 처리하기 - gridControl_CustomColumnGroup(sender, e)

        /// <summary>
        /// 그리드 컨트롤 커스텀 컬럼 그룹 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_CustomColumnGroup(object sender, CustomColumnSortEventArgs e)
        {
            if(e.Column.FieldName == "UnitPrice")
            {
                double value1        = Math.Floor(Convert.ToDouble(e.Value1) / 10);
                double value2        = Math.Floor(Convert.ToDouble(e.Value2) / 10);
                int    compareResult = Comparer.Default.Compare(value1, value2);

                if(value1 > 9 && value2 > 9)
                {
                    compareResult = 0;
                }

                e.Result  = compareResult;
                e.Handled = true;
            }
        }

        #endregion
        #region 그리드 컨트롤 커스텀 그룹 표시 텍스트 처리하기 - gridControl_CustomGroupDisplayText(sender, e)

        /// <summary>
        /// 그리드 컨트롤 커스텀 그룹 표시 텍스트 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_CustomGroupDisplayText(object sender, CustomGroupDisplayTextEventArgs e)
        {
            if(e.Column.FieldName != "UnitPrice")
            {
                return;
            }

            int groupLevel = this.gridControl.GetRowLevelByRowHandle(e.RowHandle);

            if(groupLevel != e.Column.GroupIndex)
            {
                return;
            }

            string interval = GetIntervalString(e.Value);

            e.DisplayText = interval;
        }

        #endregion

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

        #region 간격 문자열 구하기 - GetIntervalString(value)

        /// <summary>
        /// 간격 문자열 구하기
        /// </summary>
        /// <param name="value">값</param>
        /// <returns>간격 문자열</returns>
        private string GetIntervalString(object value)
        {
            double valueDouble = Math.Floor(Convert.ToDouble(value) / 10);

            string interval = string.Format("{0:c} - {1:c} ", valueDouble * 10, (valueDouble + 1) * 10);

            if(valueDouble > 9)
            {
                interval = string.Format(">= {0:c} ", 100);
            }

            return interval;
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

using System;

using System.Collections;

using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new NorthwindEntities().Products;

this.gridControl.Columns["UnitPrice"].GroupIndex = 0;

}

#endregion

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

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

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

#region 그리드 컨트롤 커스텀 컬럼 그룹 처리하기 - gridControl_CustomColumnGroup(sender, e)

/// <summary>

/// 그리드 컨트롤 커스텀 컬럼 그룹 처리하기

/// </summary>

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

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

private void gridControl_CustomColumnGroup(object sender, CustomColumnSortEventArgs e)

{

if(e.Column.FieldName == "UnitPrice")

{

double value1 = Math.Floor(Convert.ToDouble(e.Value1) / 10);

double value2 = Math.Floor(Convert.ToDouble(e.Value2) / 10);

int compareResult = Comparer.Default.Compare(value1, value2);

if(value1 > 9 && value2 > 9)

{

compareResult = 0;

}

e.Result = compareResult;

e.Handled = true;

}

#endregion

#region 그리드 컨트롤 커스텀 그룹 표시 텍스트 처리하기 - gridControl_CustomGroupDisplayText(sender, e)

/// <summary>

/// 그리드 컨트롤 커스텀 그룹 표시 텍스트 처리하기

/// </summary>

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

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

private void gridControl_CustomGroupDisplayText(object sender, CustomGroupDisplayTextEventArgs e)

{

if(e.Column.FieldName != "UnitPrice")

{

return;

}

int groupLevel = this.gridControl.GetRowLevelByRowHandle(e.RowHandle);

if(groupLevel != e.Column.GroupIndex)

{

return;

}

string interval = GetIntervalString(e.Value);

e.DisplayText = interval;

}

#endregion

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

#region 간격 문자열 구하기 - GetIntervalString(value)

/// <summary>

/// 간격 문자열 구하기

/// </summary>

/// <param name="value">값</param>

/// <returns>간격 문자열</returns>

private string GetIntervalString(object value)

{

double valueDouble = Math.Floor(Convert.ToDouble(value) / 10);

string interval = string.Format("{0:c} - {1:c} ", valueDouble * 10, (valueDouble + 1) * 10);

if(valueDouble > 9)

{

interval = string.Format(">= {0:c} ", 100);

}

return interval;

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : SUMMARY 값으로 그룹 행 정렬하기

■ GridControl 클래스에서 SUMMARY 값으로 그룹 행을 정렬하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="SUMMARY 값으로 그룹 행 정렬하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl">
            <dxg:GridControl.Columns>
                <dxg:GridColumn
                    FieldName="UserName"
                    Header="User Name" />
                <dxg:GridColumn
                    FieldName="RegistrationDate"
                    GroupIndex="0"
                    Header="Registration Date" />
                <dxg:GridColumn FieldName="Age" />
            </dxg:GridControl.Columns>
            <dxg:GridControl.GroupSummary>
                <dxg:GridSummaryItem
                    FieldName="Age"
                    SummaryType="Max" />
            </dxg:GridControl.GroupSummary>
            <dxg:GridControl.View>
                <dxg:TableView x:Name="tableView" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="SUMMARY 값으로 그룹 행 정렬하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl">

<dxg:GridControl.Columns>

<dxg:GridColumn

FieldName="UserName"

Header="User Name" />

<dxg:GridColumn

FieldName="RegistrationDate"

GroupIndex="0"

Header="Registration Date" />

<dxg:GridColumn FieldName="Age" />

</dxg:GridControl.Columns>

<dxg:GridControl.GroupSummary>

<dxg:GridSummaryItem

FieldName="Age"

SummaryType="Max" />

</dxg:GridControl.GroupSummary>

<dxg:GridControl.View>

<dxg:TableView x:Name="tableView" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.ComponentModel;
using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new AccountList().GetData();

            SortGroupBySummaryValue
            (
                this.tableView.GroupedColumns[0],
                this.gridControl.GroupSummary[0],
                ListSortDirection.Descending
            );
        }

        #endregion

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

        #region Summary 값으로 Group 정렬하기 - SortGroupBySummaryValue(groupedGridColumn, gridSummaryItem, listSortDirection)

        /// <summary>
        /// Summary 값으로 Group 정렬하기
        /// </summary>
        /// <param name="groupedGridColumn">그룹핑된 GridColumn 객체</param>
        /// <param name="gridSummaryItem">GridSummaryItem 객체</param>
        /// <param name="listSortDirection">리스트 정렬 방향</param>
        private void SortGroupBySummaryValue(GridColumn groupedGridColumn, GridSummaryItem gridSummaryItem, ListSortDirection listSortDirection)
        {
            GridGroupSummarySortInfo gridGroupSummarySortInfo = new GridGroupSummarySortInfo
            (
                gridSummaryItem,
                groupedGridColumn.FieldName,
                listSortDirection
            );

            this.gridControl.GroupSummarySortInfo.Add(gridGroupSummarySortInfo);
        }

        #endregion
    }
}

using System.ComponentModel;

using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new AccountList().GetData();

SortGroupBySummaryValue

(

this.tableView.GroupedColumns[0],

this.gridControl.GroupSummary[0],

ListSortDirection.Descending

);

}

#endregion

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

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

#region Summary 값으로 Group 정렬하기 - SortGroupBySummaryValue(groupedGridColumn, gridSummaryItem, listSortDirection)

/// <summary>

/// Summary 값으로 Group 정렬하기

/// </summary>

/// <param name="groupedGridColumn">그룹핑된 GridColumn 객체</param>

/// <param name="gridSummaryItem">GridSummaryItem 객체</param>

/// <param name="listSortDirection">리스트 정렬 방향</param>

private void SortGroupBySummaryValue(GridColumn groupedGridColumn, GridSummaryItem gridSummaryItem, ListSortDirection listSortDirection)

{

GridGroupSummarySortInfo gridGroupSummarySortInfo = new GridGroupSummarySortInfo

(

gridSummaryItem,

groupedGridColumn.FieldName,

listSortDirection

);

this.gridControl.GroupSummarySortInfo.Add(gridGroupSummarySortInfo);

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : CustomSummary 이벤트를 사용해 값이 비어있는 셀 계수하기

■ GridControl 클래스의 CustomSummary 이벤트를 사용해 값이 비어있는 셀을 계수하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="GridControl 클래스 : CustomSummary 이벤트를 사용해 값이 비어있는 셀 계수하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            CustomSummary="gridControl_CustomSummary"
            GroupCount="1">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="Text"   />
                <dxg:GridColumn FieldName="Number" />
            </dxg:GridControl.Columns>
            <dxg:GridControl.SortInfo>
                <dxg:GridSortInfo FieldName="Text" />
            </dxg:GridControl.SortInfo>
            <dxg:GridControl.GroupSummary>
                <dxg:GridSummaryItem
                    FieldName="Number"
                    SummaryType="Custom"
                    DisplayFormat="Group empty cells count : {0}" />
            </dxg:GridControl.GroupSummary>
            <dxg:GridControl.TotalSummary>
                <dxg:GridSummaryItem
                    FieldName="Number"
                    SummaryType="Custom"
                    DisplayFormat="Total empty cells count : {0}"/>
            </dxg:GridControl.TotalSummary>
            <dxg:GridControl.View>
                <dxg:TableView x:Name="tableView"
                    ShowTotalSummary="True"
                    NavigationStyle="Cell" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="GridControl 클래스 : CustomSummary 이벤트를 사용해 값이 비어있는 셀 계수하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

CustomSummary="gridControl_CustomSummary"

GroupCount="1">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="Text" />

<dxg:GridColumn FieldName="Number" />

</dxg:GridControl.Columns>

<dxg:GridControl.SortInfo>

<dxg:GridSortInfo FieldName="Text" />

</dxg:GridControl.SortInfo>

<dxg:GridControl.GroupSummary>

<dxg:GridSummaryItem

FieldName="Number"

SummaryType="Custom"

DisplayFormat="Group empty cells count : {0}" />

</dxg:GridControl.GroupSummary>

<dxg:GridControl.TotalSummary>

<dxg:GridSummaryItem

FieldName="Number"

SummaryType="Custom"

DisplayFormat="Total empty cells count : {0}"/>

</dxg:GridControl.TotalSummary>

<dxg:GridControl.View>

<dxg:TableView x:Name="tableView"

ShowTotalSummary="True"

NavigationStyle="Cell" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;
using System.Collections.Generic;

using DevExpress.Data;
using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 샘플 데이터 리스트
        /// </summary>
        private List<SampleData> sampleDataList;

        /// <summary>
        /// 빈 셀 전체 수
        /// </summary>
        private int emptyCellTotalCount = 0;

        /// <summary>
        /// 빈 셀 그룹 수
        /// </summary>
        private int emptyCellGroupCount = 0;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.sampleDataList = new List<SampleData>();

            for(int i = 0; i < 100; i++)
            {
                this.sampleDataList.Add(new SampleData() { Text = "group " + i % 10, Number = i });

                if(i % 3 == 0)
                {
                    this.sampleDataList[i].Number = null;
                }
            }

            this.gridControl.ItemsSource = this.sampleDataList;
        }

        #endregion

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

        #region 그리드 컨트롤 커스텀 요약 처리하기 - gridControl_CustomSummary(sender, e)

        /// <summary>
        /// 그리드 컨트롤 커스텀 요약 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_CustomSummary(object sender, CustomSummaryEventArgs e)
        {
            if((e.Item as GridSummaryItem).FieldName != "Number")
            {
                return;
            }

            if(e.IsTotalSummary)
            {
                if(e.SummaryProcess == CustomSummaryProcess.Start)
                {
                    this.emptyCellTotalCount = 0;
                }

                if(e.SummaryProcess == CustomSummaryProcess.Calculate)
                {
                    int? fieldValue = (int?)e.FieldValue;

                    if(!fieldValue.HasValue)
                    {
                        this.emptyCellTotalCount++;
                    }

                    e.TotalValue = this.emptyCellTotalCount;
                }
            }

            if(e.IsGroupSummary)
            {
                if(e.SummaryProcess == CustomSummaryProcess.Start)
                {
                    this.emptyCellGroupCount = 0;
                }

                if(e.SummaryProcess == CustomSummaryProcess.Calculate)
                {
                    int? fieldValue = (int?)e.FieldValue;

                    if(!fieldValue.HasValue)
                    {
                        this.emptyCellGroupCount++;
                    }

                    e.TotalValue = this.emptyCellGroupCount;
                }
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

using System.Windows;

using System.Collections.Generic;

using DevExpress.Data;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

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

#region Field

/// <summary>

/// 샘플 데이터 리스트

/// </summary>

private List<SampleData> sampleDataList;

/// <summary>

/// 빈 셀 전체 수

/// </summary>

private int emptyCellTotalCount = 0;

/// <summary>

/// 빈 셀 그룹 수

/// </summary>

private int emptyCellGroupCount = 0;

#endregion

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.sampleDataList = new List<SampleData>();

for(int i = 0; i < 100; i++)

{

this.sampleDataList.Add(new SampleData() { Text = "group " + i % 10, Number = i });

if(i % 3 == 0)

{

this.sampleDataList[i].Number = null;

}

this.gridControl.ItemsSource = this.sampleDataList;

}

#endregion

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

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

#region 그리드 컨트롤 커스텀 요약 처리하기 - gridControl_CustomSummary(sender, e)

/// <summary>

/// 그리드 컨트롤 커스텀 요약 처리하기

/// </summary>

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

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

private void gridControl_CustomSummary(object sender, CustomSummaryEventArgs e)

{

if((e.Item as GridSummaryItem).FieldName != "Number")

{

return;

}

if(e.IsTotalSummary)

{

if(e.SummaryProcess == CustomSummaryProcess.Start)

{

this.emptyCellTotalCount = 0;

}

if(e.SummaryProcess == CustomSummaryProcess.Calculate)

{

int? fieldValue = (int?)e.FieldValue;

if(!fieldValue.HasValue)

{

this.emptyCellTotalCount++;

}

e.TotalValue = this.emptyCellTotalCount;

}

if(e.IsGroupSummary)

{

if(e.SummaryProcess == CustomSummaryProcess.Start)

{

this.emptyCellGroupCount = 0;

}

if(e.SummaryProcess == CustomSummaryProcess.Calculate)

{

int? fieldValue = (int?)e.FieldValue;

if(!fieldValue.HasValue)

{

this.emptyCellGroupCount++;

}

e.TotalValue = this.emptyCellGroupCount;

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : GROUP SUMMARY 표시하기

■ GridControl 클래스에서 GROUP SUMMARY를 표시하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="GROUP SUMMARY 표시하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            AutoGenerateColumns="AddNew"
            CustomSummaryExists="gridControl_CustomSummaryExists">
            <dxg:GridControl.View>
                <dxg:TableView />
            </dxg:GridControl.View>
            <dxg:GridControl.GroupSummary>
                <dxg:GridSummaryItem FieldName="Age" SummaryType="Min" />
                <dxg:GridSummaryItem FieldName="Age" SummaryType="Max" />
            </dxg:GridControl.GroupSummary>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="GROUP SUMMARY 표시하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

AutoGenerateColumns="AddNew"

CustomSummaryExists="gridControl_CustomSummaryExists">

<dxg:GridControl.View>

<dxg:TableView />

</dxg:GridControl.View>

<dxg:GridControl.GroupSummary>

<dxg:GridSummaryItem FieldName="Age" SummaryType="Min" />

<dxg:GridSummaryItem FieldName="Age" SummaryType="Max" />

</dxg:GridControl.GroupSummary>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

using DevExpress.Data;
using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new AccountList().GetData();

            this.gridControl.GroupBy(this.gridControl.Columns["Married"], ColumnSortOrder.Ascending);
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Private
        //////////////////////////////////////////////////////////////////////////////// Event

        #region 그리드 컨트롤 커스텀 요약 존재 여부 처리하기 - gridControl_CustomSummaryExists(sender, e)

        /// <summary>
        /// 그리드 컨트롤 커스텀 요약 존재 여부 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void gridControl_CustomSummaryExists(object sender, CustomSummaryExistEventArgs e)
        {
            e.Exists = e.GroupLevel == 0;
        }

        #endregion

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

        #region 그룹 요약 생성하기 - CreateGroupSummary()

        /// <summary>
        /// 그룹 요약 생성하기
        /// </summary>
        private void CreateGroupSummary()
        {
            this.gridControl.GroupSummary.Add
            (
                new GridSummaryItem()
                {
                    FieldName = "Age",
                    SummaryType = SummaryItemType.Min
                }
            );

            this.gridControl.GroupSummary.Add
            (
                new GridSummaryItem()
                {
                    FieldName = "Age",
                    SummaryType = SummaryItemType.Max
                }
            );
        }

        #endregion
    }
}

using System.Windows;

using DevExpress.Data;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new AccountList().GetData();

this.gridControl.GroupBy(this.gridControl.Columns["Married"], ColumnSortOrder.Ascending);

}

#endregion

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

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

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

#region 그리드 컨트롤 커스텀 요약 존재 여부 처리하기 - gridControl_CustomSummaryExists(sender, e)

/// <summary>

/// 그리드 컨트롤 커스텀 요약 존재 여부 처리하기

/// </summary>

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

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

private void gridControl_CustomSummaryExists(object sender, CustomSummaryExistEventArgs e)

{

e.Exists = e.GroupLevel == 0;

}

#endregion

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

#region 그룹 요약 생성하기 - CreateGroupSummary()

/// <summary>

/// 그룹 요약 생성하기

/// </summary>

private void CreateGroupSummary()

{

this.gridControl.GroupSummary.Add

(

new GridSummaryItem()

{

FieldName = "Age",

SummaryType = SummaryItemType.Min

}

);

this.gridControl.GroupSummary.Add

(

new GridSummaryItem()

{

FieldName = "Age",

SummaryType = SummaryItemType.Max

}

);

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : TOTAL SUMMARY 표시하기

■ GridControl 클래스에서 TOTAL SUMMARY를 표시하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="TOTAL SUMMARY 표시하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            AutoGenerateColumns="AddNew">
            <dxg:GridControl.TotalSummary>
                <dxg:GridSummaryItem
                    FieldName="UserName"
                    SummaryType="Count"
                    DisplayFormat="Total Users : {0}" />
                <dxg:GridSummaryItem
                    FieldName="Age"
                    SummaryType="Min" />
                <dxg:GridSummaryItem
                    FieldName="Age"
                    SummaryType="Max" />
            </dxg:GridControl.TotalSummary>
            <dxg:GridControl.View>
                <dxg:TableView ShowTotalSummary="True" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="TOTAL SUMMARY 표시하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

AutoGenerateColumns="AddNew">

<dxg:GridControl.TotalSummary>

<dxg:GridSummaryItem

FieldName="UserName"

SummaryType="Count"

DisplayFormat="Total Users : {0}" />

<dxg:GridSummaryItem

FieldName="Age"

SummaryType="Min" />

<dxg:GridSummaryItem

FieldName="Age"

SummaryType="Max" />

</dxg:GridControl.TotalSummary>

<dxg:GridControl.View>

<dxg:TableView ShowTotalSummary="True" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

using DevExpress.Data;
using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new AccountList().GetData();
        }

        #endregion

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

        #region 전체 요약 생성하기 - CreateTotalSummary()

        /// <summary>
        /// 전체 요약 생성하기
        /// </summary>
        private void CreateTotalSummary()
        {
            this.gridControl.TotalSummary.Add
            (
                new GridSummaryItem()
                {
                    FieldName     = "UserName",
                    SummaryType   = SummaryItemType.Count,
                    DisplayFormat = "Total Users : {0}"
                }
            );

            this.gridControl.TotalSummary.Add
            (
                new GridSummaryItem()
                {
                    FieldName   = "Age",
                    SummaryType = SummaryItemType.Min
                }
            );

            this.gridControl.TotalSummary.Add
            (
                new GridSummaryItem()
                {
                    FieldName   = "Age",
                    SummaryType = SummaryItemType.Max
                }
            );
        }

        #endregion
    }
}

using System.Windows;

using DevExpress.Data;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new AccountList().GetData();

}

#endregion

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

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

#region 전체 요약 생성하기 - CreateTotalSummary()

/// <summary>

/// 전체 요약 생성하기

/// </summary>

private void CreateTotalSummary()

{

this.gridControl.TotalSummary.Add

(

new GridSummaryItem()

{

FieldName = "UserName",

SummaryType = SummaryItemType.Count,

DisplayFormat = "Total Users : {0}"

}

);

this.gridControl.TotalSummary.Add

(

new GridSummaryItem()

{

FieldName = "Age",

SummaryType = SummaryItemType.Min

}

);

this.gridControl.TotalSummary.Add

(

new GridSummaryItem()

{

FieldName = "Age",

SummaryType = SummaryItemType.Max

}

);

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] 뷰 내에서 모든 데이터 행 핸들 수집하기 (숨겨진 행 포함)

■ 뷰 내에서 모든 데이터 행 핸들을 수집하는 방법을 보여준다. (숨겨진 행 포함) ▶ 예제 코드 (C#)


using System.Collections.Generic;

using DevExpress.Xpf.Grid;

#region 데이터 행 핸들 리스트 구하기 - GetDataRowHandleList(gridControl)

/// <summary>
/// 데이터 행 핸들 리스트 구하기
/// </summary>
/// <param name="gridControl">GridControl 객체</param>
/// <returns>데이터 행 핸들 리스트</returns>
public List<int> GetDataRowHandleList(GridControl gridControl)
{
    List<int> rowHandleList = new List<int>();

    for(int i = 0; i < gridControl.VisibleRowCount; i++)
    {
        int rowHandle = gridControl.GetRowHandleByVisibleIndex(i);

        if(gridControl.IsGroupRowHandle(rowHandle))
        {
            if(!gridControl.IsGroupRowExpanded(rowHandle))
            {
                rowHandleList.AddRange(GetDataRowHandleListInGroup(gridControl, rowHandle));
            }
        }
        else
        {
            rowHandleList.Add(rowHandle);
        }
    }

    return rowHandleList;
}

#endregion

#region 그룹에서 데이터 행 핸들 리스트 구하기 - GetDataRowHandleListInGroup(gridControl, groupRowHandle)

/// <summary>
/// 그룹에서 데이터 행 핸들 리스트 구하기
/// </summary>
/// <param name="gridControl">GridControl 객체</param>
/// <param name="groupRowHandle">그룹 행 핸들</param>
/// <returns>그룹에서 데이터 행 핸들 리스트</returns>
public List<int> GetDataRowHandleListInGroup(GridControl gridControl, int groupRowHandle)
{
    List<int> rowHandleList = new List<int>();

    for(int i = 0; i < gridControl.GetChildRowCount(groupRowHandle); i++)
    {
        int rowHandle = gridControl.GetChildRowHandle(groupRowHandle, i);

        if(gridControl.IsGroupRowHandle(rowHandle))
        {
            rowHandleList.AddRange(GetDataRowHandleListInGroup(gridControl, rowHandle));
        }
        else
        {
            rowHandleList.Add(rowHandle);
        }
    }

    return rowHandleList;
}

#endregion

using System.Collections.Generic;

using DevExpress.Xpf.Grid;

#region 데이터 행 핸들 리스트 구하기 - GetDataRowHandleList(gridControl)

/// <summary>

/// 데이터 행 핸들 리스트 구하기

/// </summary>

/// <param name="gridControl">GridControl 객체</param>

/// <returns>데이터 행 핸들 리스트</returns>

public List<int> GetDataRowHandleList(GridControl gridControl)

{

List<int> rowHandleList = new List<int>();

for(int i = 0; i < gridControl.VisibleRowCount; i++)

{

int rowHandle = gridControl.GetRowHandleByVisibleIndex(i);

if(gridControl.IsGroupRowHandle(rowHandle))

{

if(!gridControl.IsGroupRowExpanded(rowHandle))

{

rowHandleList.AddRange(GetDataRowHandleListInGroup(gridControl, rowHandle));

}

else

{

rowHandleList.Add(rowHandle);

}

return rowHandleList;

}

#endregion

#region 그룹에서 데이터 행 핸들 리스트 구하기 - GetDataRowHandleListInGroup(gridControl, groupRowHandle)

/// <summary>

/// 그룹에서 데이터 행 핸들 리스트 구하기

/// </summary>

/// <param name="gridControl">GridControl 객체</param>

/// <param name="groupRowHandle">그룹 행 핸들</param>

/// <returns>그룹에서 데이터 행 핸들 리스트</returns>

public List<int> GetDataRowHandleListInGroup(GridControl gridControl, int groupRowHandle)

{

List<int> rowHandleList = new List<int>();

for(int i = 0; i < gridControl.GetChildRowCount(groupRowHandle); i++)

{

int rowHandle = gridControl.GetChildRowHandle(groupRowHandle, i);

if(gridControl.IsGroupRowHandle(rowHandle))

{

rowHandleList.AddRange(GetDataRowHandleListInGroup(gridControl, rowHandle));

}

else

{

rowHandleList.Add(rowHandle);

}

return rowHandleList;

}

#endregion

[C#/WPF/DEVEXPRESS] 뷰 내에서 표시된 그룹 행 수 구하기

■ 뷰 내에서 표시된 그룹 행 수를 구하는 방법을 보여준다. ▶ 예제 코드 (C#)


using DevExpress.Xpf.Grid;

#region 표시 그룹 행 수 구하기 - GetVisibleGroupRowCount(gridControl)

/// <summary>
/// 표시 그룹 행 수 구하기
/// </summary>
/// <param name="gridControl">GridControl 객체</param>
/// <returns>표시 그룹 행 수</returns>
private int GetVisibleGroupRowCount(GridControl gridControl)
{
    int groupRowCount = 0;

    for(int i = 0; i < gridControl.VisibleRowCount; i++)
    {
        int rowHandle = gridControl.GetRowHandleByVisibleIndex(i);

        if(gridControl.IsGroupRowHandle(rowHandle))
        {
            groupRowCount++;
        }
    }

    return groupRowCount;
}

#endregion

using DevExpress.Xpf.Grid;

#region 표시 그룹 행 수 구하기 - GetVisibleGroupRowCount(gridControl)

/// <summary>

/// 표시 그룹 행 수 구하기

/// </summary>

/// <param name="gridControl">GridControl 객체</param>

/// <returns>표시 그룹 행 수</returns>

private int GetVisibleGroupRowCount(GridControl gridControl)

{

int groupRowCount = 0;

for(int i = 0; i < gridControl.VisibleRowCount; i++)

{

int rowHandle = gridControl.GetRowHandleByVisibleIndex(i);

if(gridControl.IsGroupRowHandle(rowHandle))

{

groupRowCount++;

}

return groupRowCount;

}

#endregion

[C#/WPF/DEVEXPRESS] 그룹 데이터 생성시 성능 향상하기

■ 그룹 데이터 생성시 성능을 향상시키는 방법을 보여준다. ▶ 예제 코드 (C#)


using DevExpress.Xpf.Grid;

#region 데이터 그룹 만들기 - GroupData(gridControl, fieldNameArray)

/// <summary>
/// 데이터 그룹 만들기
/// </summary>
/// <param name="gridControl">GridControl 객체</param>
/// <param name="fieldNameArray">필드명 배열</param>
private void GroupData(GridControl gridControl, string[] fieldNameArray)
{
    gridControl.BeginDataUpdate();

    try
    {
        gridControl.ClearGrouping();

        for(int i = 0; i < fieldNameArray.Length; i++)
        {
            GridColumn gridColumn = gridControl.Columns[fieldNameArray[i]];

            if(gridColumn != null)
            {
                gridColumn.GroupIndex = i;
            }
        }
    }
    finally
    {
        gridControl.EndDataUpdate();
    }
}

#endregion

using DevExpress.Xpf.Grid;

#region 데이터 그룹 만들기 - GroupData(gridControl, fieldNameArray)

/// <summary>

/// 데이터 그룹 만들기

/// </summary>

/// <param name="gridControl">GridControl 객체</param>

/// <param name="fieldNameArray">필드명 배열</param>

private void GroupData(GridControl gridControl, string[] fieldNameArray)

{

gridControl.BeginDataUpdate();

try

{

gridControl.ClearGrouping();

for(int i = 0; i < fieldNameArray.Length; i++)

{

GridColumn gridColumn = gridControl.Columns[fieldNameArray[i]];

if(gridColumn != null)

{

gridColumn.GroupIndex = i;

}

finally

{

gridControl.EndDataUpdate();

}

#endregion

[C#/WPF/DEVEXPRESS] GridControl 클래스 : SaveLayoutToStream/RestoreLayoutFromStream 메소드를 사용해 레이아웃 저장하기/복구하기

■ GridControl 클래스의 SaveLayoutToStream/RestoreLayoutFromStream 메소드를 사용해 레이아웃을 저장하고 복구하는 방법을 보여준다. ▶ Issue.cs


namespace TestProject
{
    /// <summary>
    /// 이슈
    /// </summary>
    public class Issue
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 이슈명 - IssueName

        /// <summary>
        /// 이슈명
        /// </summary>
        public string IssueName { get; set; }

        #endregion
        #region 이슈 타입 - IssueType

        /// <summary>
        /// 이슈 타입
        /// </summary>
        public string IssueType { get; set; }

        #endregion
        #region 개인 여부 - IsPrivate

        /// <summary>
        /// 개인 여부
        /// </summary>
        public bool IsPrivate { get; set; }

        #endregion
    }
}

namespace TestProject

{

/// <summary>

/// 이슈

/// </summary>

public class Issue

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

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

#region 이슈명 - IssueName

/// <summary>

/// 이슈명

/// </summary>

public string IssueName { get; set; }

#endregion

#region 이슈 타입 - IssueType

/// <summary>

/// 이슈 타입

/// </summary>

public string IssueType { get; set; }

#endregion

#region 개인 여부 - IsPrivate

/// <summary>

/// 개인 여부

/// </summary>

public bool IsPrivate { get; set; }

#endregion

}

▶ IssueList.cs


using System.Collections.Generic;

namespace TestProject
{
    /// <summary>
    /// 이슈 리스트
    /// </summary>
    public class IssueList
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 데이터 구하기 - GetData()

        /// <summary>
        /// 데이터 구하기
        /// </summary>
        /// <returns>이슈 리스트</returns>
        public List<Issue> GetData()
        {
            List<Issue> list = new List<Issue>
            {
                new Issue() { IssueName = "Transaction History"  , IssueType = "Bug"    , IsPrivate = true  },
                new Issue() { IssueName = "Ledger: Inconsistency", IssueType = "Bug"    , IsPrivate = false },
                new Issue() { IssueName = "Data Import"          , IssueType = "Request", IsPrivate = false },
                new Issue() { IssueName = "Data Archiving"       , IssueType = "Request", IsPrivate = true  }
            };

            return pList;
        }

        #endregion
    }
}

using System.Collections.Generic;

namespace TestProject

{

/// <summary>

/// 이슈 리스트

/// </summary>

public class IssueList

{

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

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

#region 데이터 구하기 - GetData()

/// <summary>

/// 데이터 구하기

/// </summary>

/// <returns>이슈 리스트</returns>

public List<Issue> GetData()

{

List<Issue> list = new List<Issue>

{

new Issue() { IssueName = "Transaction History" , IssueType = "Bug" , IsPrivate = true },

new Issue() { IssueName = "Ledger: Inconsistency", IssueType = "Bug" , IsPrivate = false },

new Issue() { IssueName = "Data Import" , IssueType = "Request", IsPrivate = false },

new Issue() { IssueName = "Data Archiving" , IssueType = "Request", IsPrivate = true }

};

return pList;

}

#endregion

}

▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="그리드 레이아웃을 메모리 스트림에 저장하고 복구하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="*"    />
            <RowDefinition Height="Auto" />
        </Grid.RowDefinitions>
        <dxg:GridControl x:Name="gridControl"
            dx:DXSerializer.SerializationID="gridControl"
            dx:DXSerializer.StoreLayoutMode="All"
            dxg:GridSerializationOptions.AddNewColumns="False"
            dxg:GridSerializationOptions.RemoveOldColumns="False">
            <dxg:GridControl.Columns>
                <dxg:GridColumn x:Name="issueNameGridColumn" FieldName="IssueName" Header="Issue Name" />
                <dxg:GridColumn x:Name="issueTypeGridColumn" FieldName="IssueType" Header="Issue Type" />
                <dxg:GridColumn x:Name="isPrivateGridColumn" FieldName="IsPrivate" Header="Private"    />
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView />
            </dxg:GridControl.View>
        </dxg:GridControl>
        <StackPanel
            Grid.Row="1"
            Orientation="Horizontal">
            <Button
                Margin="0 5 0 0"
                Padding="3"
                Content="Add New Column"
                Click="addNewColumnButton_Click" />
            <Button
                Margin="5 5 0 0"
                Padding="3"
                Content="Save Layout"
                Click="saveLayoutButton_Click" />
            <Button x:Name="restoreLayoutButton"
                Margin="5 5 0 0"
                Padding="3"
                Click="restoreLayoutButton_Click"
                Content="Restore Layout"
                IsEnabled="{Binding IsLayoutSaved}" />
        </StackPanel>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="그리드 레이아웃을 메모리 스트림에 저장하고 복구하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<Grid.RowDefinitions>

</Grid.RowDefinitions>

<dxg:GridControl x:Name="gridControl"

dx:DXSerializer.SerializationID="gridControl"

dx:DXSerializer.StoreLayoutMode="All"

dxg:GridSerializationOptions.AddNewColumns="False"

dxg:GridSerializationOptions.RemoveOldColumns="False">

<dxg:GridControl.Columns>

<dxg:GridColumn x:Name="issueNameGridColumn" FieldName="IssueName" Header="Issue Name" />

<dxg:GridColumn x:Name="issueTypeGridColumn" FieldName="IssueType" Header="Issue Type" />

<dxg:GridColumn x:Name="isPrivateGridColumn" FieldName="IsPrivate" Header="Private" />

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView />

</dxg:GridControl.View>

</dxg:GridControl>

<StackPanel

Grid.Row="1"

Orientation="Horizontal">

<Button

Margin="0 5 0 0"

Padding="3"

Content="Add New Column"

Click="addNewColumnButton_Click" />

<Button

Margin="5 5 0 0"

Padding="3"

Content="Save Layout"

Click="saveLayoutButton_Click" />

<Button x:Name="restoreLayoutButton"

Margin="5 5 0 0"

Padding="3"

Click="restoreLayoutButton_Click"

Content="Restore Layout"

IsEnabled="{Binding IsLayoutSaved}" />

</StackPanel>

</Grid>

</Window>

▶ MainWindow.xaml.cs

[C#/WPF/DEVEXPRESS] 에디터 에러 툴팁 모양 변경하기

■ 에디터 에러 툴팁 모양을 변경하는 방법을 보여준다. ▶ 예제 코드 (XAML)


<Grid xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors">
    <dxe:DateEdit x:Name="dateEdit"
        Width="150"
        Height="25"
        MinValue="01/15/2008"
        MaxValue="12/13/2010">
        <dxe:DateEdit.ErrorToolTipContentTemplate>
            <DataTemplate>
                <TextBlock
                    Text="Value is out of borders"
                    Foreground="Red"
                    FontSize="12" />
            </DataTemplate>
        </dxe:DateEdit.ErrorToolTipContentTemplate>
    </dxe:DateEdit>
</Grid>

<dxe:DateEdit x:Name="dateEdit"

Width="150"

Height="25"

MinValue="01/15/2008"

MaxValue="12/13/2010">

<dxe:DateEdit.ErrorToolTipContentTemplate>

<TextBlock

Text="Value is out of borders"

Foreground="Red"

FontSize="12" />

</DataTemplate>

</dxe:DateEdit.ErrorToolTipContentTemplate>

</dxe:DateEdit>

</Grid>

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 데이터 셀을 위한 컨텍스트 메뉴 생성하기

■ GridControl 클래스에서 데이터 셀을 위한 컨텍스트 메뉴를 생성하는 방법을 보여준다. ▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxb="http://schemas.devexpress.com/winfx/2008/xaml/bars"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="데이터 셀을 위한 컨텍스트 메뉴 생성하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl">
            <dxg:GridControl.Columns>
                <dxg:GridColumn
                    FieldName="UserName"
                    Header="User Name" />
                <dxg:GridColumn
                    FieldName="RegistrationDate"
                    Header="Registration Date" />
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView x:Name="tableView">
                    <dxg:TableView.RowCellMenuCustomizations>
                        <dxb:BarButtonItem x:Name="deleteRowBarButtonItem"
                            Content="Delete Row"
                            ItemClick="deleteRowBarButtonItem_ItemClick" />
                        <dxb:BarButtonItem x:Name="copyCellDataBarButtonItem"
                            Content="Copy Cell Data"
                            ItemClick="copyCellDataBarButtonItem_ItemClick" />
                    </dxg:TableView.RowCellMenuCustomizations>
                </dxg:TableView>
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxb="http://schemas.devexpress.com/winfx/2008/xaml/bars"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="데이터 셀을 위한 컨텍스트 메뉴 생성하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl">

<dxg:GridControl.Columns>

<dxg:GridColumn

FieldName="UserName"

Header="User Name" />

<dxg:GridColumn

FieldName="RegistrationDate"

Header="Registration Date" />

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView x:Name="tableView">

<dxg:TableView.RowCellMenuCustomizations>

<dxb:BarButtonItem x:Name="deleteRowBarButtonItem"

Content="Delete Row"

ItemClick="deleteRowBarButtonItem_ItemClick" />

<dxb:BarButtonItem x:Name="copyCellDataBarButtonItem"

Content="Copy Cell Data"

ItemClick="copyCellDataBarButtonItem_ItemClick" />

</dxg:TableView.RowCellMenuCustomizations>

</dxg:TableView>

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

using DevExpress.Xpf.Bars;
using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = new AccountList().GetData();
        }

        #endregion

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

        #region Delete Row 바 버튼 항목 항목 클릭시 처리하기 - deleteRowBarButtonItem_ItemClick(sender, e)

        /// <summary>
        /// Delete Row 바 버튼 항목 항목 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void deleteRowBarButtonItem_ItemClick(object sender, ItemClickEventArgs e)
        {
            GridCellMenuInfo gridCellMenuInfo = this.tableView.GridMenu.MenuInfo as GridCellMenuInfo;

            if(gridCellMenuInfo != null && gridCellMenuInfo.Row != null)
            {
                int rowHandle = gridCellMenuInfo.Row.RowHandle.Value;

                this.tableView.DeleteRow(rowHandle);
            }
        }

        #endregion
        #region Copy Cell Data 바 버튼 항목 항목 클릭시 처리하기 - copyCellDataBarButtonItem_ItemClick(sender, e)

        /// <summary>
        /// Copy Cell Data 바 버튼 항목 항목 클릭시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void copyCellDataBarButtonItem_ItemClick(object sender, ItemClickEventArgs e)
        {
            GridCellMenuInfo gridCellMenuInfo = this.tableView.GridMenu.MenuInfo as GridCellMenuInfo;

            if(gridCellMenuInfo != null && gridCellMenuInfo.Row != null)
            {
                int        rowHandle  = gridCellMenuInfo.Row.RowHandle.Value;
                GridColumn gridColumn = gridCellMenuInfo.Column as GridColumn;

                object cellValue = this.gridControl.GetCellValue(rowHandle, gridColumn);

                Clipboard.SetText(cellValue == null ? string.Empty : cellValue.ToString());
            }
        }

        #endregion
    }
}

using System.Windows;

using DevExpress.Xpf.Bars;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = new AccountList().GetData();

}

#endregion

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

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

#region Delete Row 바 버튼 항목 항목 클릭시 처리하기 - deleteRowBarButtonItem_ItemClick(sender, e)

/// <summary>

/// Delete Row 바 버튼 항목 항목 클릭시 처리하기

/// </summary>

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

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

private void deleteRowBarButtonItem_ItemClick(object sender, ItemClickEventArgs e)

{

GridCellMenuInfo gridCellMenuInfo = this.tableView.GridMenu.MenuInfo as GridCellMenuInfo;

if(gridCellMenuInfo != null && gridCellMenuInfo.Row != null)

{

int rowHandle = gridCellMenuInfo.Row.RowHandle.Value;

this.tableView.DeleteRow(rowHandle);

}

#endregion

#region Copy Cell Data 바 버튼 항목 항목 클릭시 처리하기 - copyCellDataBarButtonItem_ItemClick(sender, e)

/// <summary>

/// Copy Cell Data 바 버튼 항목 항목 클릭시 처리하기

/// </summary>

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

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

private void copyCellDataBarButtonItem_ItemClick(object sender, ItemClickEventArgs e)

{

GridCellMenuInfo gridCellMenuInfo = this.tableView.GridMenu.MenuInfo as GridCellMenuInfo;

if(gridCellMenuInfo != null && gridCellMenuInfo.Row != null)

{

int rowHandle = gridCellMenuInfo.Row.RowHandle.Value;

GridColumn gridColumn = gridCellMenuInfo.Column as GridColumn;

object cellValue = this.gridControl.GetCellValue(rowHandle, gridColumn);

Clipboard.SetText(cellValue == null ? string.Empty : cellValue.ToString());

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] IDXDataErrorInfo 인터페이스 : 데이터 검증하기

■ IDXDataErrorInfo 인터페이스를 사용해 데이터를 검증하는 방법을 보여준다. ▶ Task.cs


using System;

using DevExpress.XtraEditors.DXErrorProvider;

namespace TestProject
{
    /// <summary>
    /// 작업
    /// </summary>
    public class Task : IDXDataErrorInfo
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 작업명 - TaskName

        /// <summary>
        /// 작업명
        /// </summary>
        public string TaskName { get; set; }

        #endregion
        #region 시작 일자 - StartDate

        /// <summary>
        /// 시작 일자
        /// </summary>
        public DateTime StartDate { get; set; }

        #endregion
        #region 종료 일자 - EndDate

        /// <summary>
        /// 종료 일자
        /// </summary>
        public DateTime EndDate { get; set; }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        // IDXDataErrorInfo
        #region 에러 구하기 - GetError(errorInfo)

        /// <summary>
        /// 에러 구하기
        /// </summary>
        /// <param name="errorInfo">ErrorInfo 객체</param>
        public void GetError(ErrorInfo errorInfo)
        {
            if(StartDate > EndDate)
            {
                SetErrorInfo(errorInfo, "Either StartDate or EndDate should be corrected.", ErrorType.Critical);
            }
        }

        #endregion

        // IDXDataErrorInfo
        #region 속성 에러 구하기 - GetPropertyError(propertyName, errorInfo)

        /// <summary>
        /// 속성 에러 구하기
        /// </summary>
        /// <param name="propertyName">속성명</param>
        /// <param name="errorInfo">ErrorInfo 객체</param>
        public void GetPropertyError(string propertyName, ErrorInfo errorInfo)
        {
            switch(propertyName)
            {
                case "StartDate" :

                    if(StartDate > EndDate)
                    {
                        SetErrorInfo(errorInfo, "StartDate must be less than EndDate", ErrorType.Critical);
                    }

                    break;

                case "EndDate" :

                    if(StartDate > EndDate)
                    {
                        SetErrorInfo(errorInfo, "EndDate must be greater than StartDate", ErrorType.Critical);
                    }

                    break;

                case "TaskName" :

                    if(IsStringEmpty(TaskName))
                    {
                        SetErrorInfo(errorInfo, "Task name hasn't been entered", ErrorType.Information);
                    }

                    break;
            }
        }

        #endregion

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

        #region ErrorInfo 객체 설정하기 - SetErrorInfo(errorInfo, errorMessage, errorType)

        /// <summary>
        /// ErrorInfo 객체 설정하기
        /// </summary>
        /// <param name="errorInfo">ErrorInfo 객체</param>
        /// <param name="errorMessage">에러 메시지</param>
        /// <param name="errorType">에러 타입</param>
        private void SetErrorInfo(ErrorInfo errorInfo, string errorMessage, ErrorType errorType)
        {
            errorInfo.ErrorText = errorMessage;
            errorInfo.ErrorType = errorType;
        }

        #endregion
        #region 빈 문자열 여부 조사하기 - IsStringEmpty(source)

        /// <summary>
        /// 빈 문자열 여부 조사하기
        /// </summary>
        /// <param name="source">소스 문자열</param>
        /// <returns>빈 문자열 여부</returns>
        private bool IsStringEmpty(string source)
        {
            return (source != null && source.Trim().Length == 0);
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

using System;

using DevExpress.XtraEditors.DXErrorProvider;

namespace TestProject

{

/// <summary>

/// 작업

/// </summary>

public class Task : IDXDataErrorInfo

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

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

#region 작업명 - TaskName

/// <summary>

/// 작업명

/// </summary>

public string TaskName { get; set; }

#endregion

#region 시작 일자 - StartDate

/// <summary>

/// 시작 일자

/// </summary>

public DateTime StartDate { get; set; }

#endregion

#region 종료 일자 - EndDate

/// <summary>

/// 종료 일자

/// </summary>

public DateTime EndDate { get; set; }

#endregion

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

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

// IDXDataErrorInfo

#region 에러 구하기 - GetError(errorInfo)

/// <summary>

/// 에러 구하기

/// </summary>

/// <param name="errorInfo">ErrorInfo 객체</param>

public void GetError(ErrorInfo errorInfo)

{

if(StartDate > EndDate)

{

SetErrorInfo(errorInfo, "Either StartDate or EndDate should be corrected.", ErrorType.Critical);

}

#endregion

// IDXDataErrorInfo

#region 속성 에러 구하기 - GetPropertyError(propertyName, errorInfo)

/// <summary>

/// 속성 에러 구하기

/// </summary>

/// <param name="propertyName">속성명</param>

/// <param name="errorInfo">ErrorInfo 객체</param>

public void GetPropertyError(string propertyName, ErrorInfo errorInfo)

{

switch(propertyName)

{

case "StartDate" :

if(StartDate > EndDate)

{

SetErrorInfo(errorInfo, "StartDate must be less than EndDate", ErrorType.Critical);

}

break;

case "EndDate" :

if(StartDate > EndDate)

{

SetErrorInfo(errorInfo, "EndDate must be greater than StartDate", ErrorType.Critical);

}

break;

case "TaskName" :

if(IsStringEmpty(TaskName))

{

SetErrorInfo(errorInfo, "Task name hasn't been entered", ErrorType.Information);

}

break;

}

#endregion

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

#region ErrorInfo 객체 설정하기 - SetErrorInfo(errorInfo, errorMessage, errorType)

/// <summary>

/// ErrorInfo 객체 설정하기

/// </summary>

/// <param name="errorInfo">ErrorInfo 객체</param>

/// <param name="errorMessage">에러 메시지</param>

/// <param name="errorType">에러 타입</param>

private void SetErrorInfo(ErrorInfo errorInfo, string errorMessage, ErrorType errorType)

{

errorInfo.ErrorText = errorMessage;

errorInfo.ErrorType = errorType;

}

#endregion

#region 빈 문자열 여부 조사하기 - IsStringEmpty(source)

/// <summary>

/// 빈 문자열 여부 조사하기

/// </summary>

/// <param name="source">소스 문자열</param>

/// <returns>빈 문자열 여부</returns>

private bool IsStringEmpty(string source)

{

return (source != null && source.Trim().Length == 0);

}

#endregion

}

▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="IDXDataErrorInfo 인터페이스 : 데이터 검증하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl">
            <dxg:GridControl.Columns>
                <dxg:GridColumn FieldName="TaskName"  />
                <dxg:GridColumn FieldName="StartDate" />
                <dxg:GridColumn FieldName="EndDate"   />
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView
                    ValidateRow="tableView_ValidateRow"
                    InvalidRowException="tableView_InvalidRowException" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="IDXDataErrorInfo 인터페이스 : 데이터 검증하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl">

<dxg:GridControl.Columns>

<dxg:GridColumn FieldName="TaskName" />

<dxg:GridColumn FieldName="StartDate" />

<dxg:GridColumn FieldName="EndDate" />

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView

ValidateRow="tableView_ValidateRow"

InvalidRowException="tableView_InvalidRowException" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System;
using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

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

            this.gridControl.ItemsSource = TaskList.GetData();
        }

        #endregion

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

        #region 테이블 뷰 행 검증하기 - tableView_ValidateRow(sender, e)

        /// <summary>
        /// 테이블 뷰 행 검증하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void tableView_ValidateRow(object sender, GridRowValidationEventArgs e)
        {
            DateTime startDate = (e.Row as Task).StartDate;
            DateTime endDate   = (e.Row as Task).EndDate;

            e.IsValid = startDate < endDate;
        }

        #endregion
        #region 테이블 뷰 적절치 못한 행 예외 처리하기 - tableView_InvalidRowException(sender, e)

        /// <summary>
        /// 테이블 뷰 적절치 못한 행 예외 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        private void tableView_InvalidRowException(object sender, InvalidRowExceptionEventArgs e)
        {
            e.ExceptionMode = ExceptionMode.NoAction;
        }

        #endregion
    }
}

using System;

using System.Windows;

using DevExpress.Xpf.Grid;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeComponent();

this.gridControl.ItemsSource = TaskList.GetData();

}

#endregion

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

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

#region 테이블 뷰 행 검증하기 - tableView_ValidateRow(sender, e)

/// <summary>

/// 테이블 뷰 행 검증하기

/// </summary>

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

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

private void tableView_ValidateRow(object sender, GridRowValidationEventArgs e)

{

DateTime startDate = (e.Row as Task).StartDate;

DateTime endDate = (e.Row as Task).EndDate;

e.IsValid = startDate < endDate;

}

#endregion

#region 테이블 뷰 적절치 못한 행 예외 처리하기 - tableView_InvalidRowException(sender, e)

/// <summary>

/// 테이블 뷰 적절치 못한 행 예외 처리하기

/// </summary>

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

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

private void tableView_InvalidRowException(object sender, InvalidRowExceptionEventArgs e)

{

e.ExceptionMode = ExceptionMode.NoAction;

}

#endregion

}

TestProject.zip

[C#/WPF/DEVEXPRESS] XPO를 통해 데이터 표시하기

■ XPO를 통해 데이터를 표시하는 방법을 보여준다. ▶ ProductDataObject.cs


using DevExpress.Xpo;

namespace TestProject
{
    /// <summary>
    /// 제품 데이터 객체
    /// </summary>
    public class ProductDataObject : XPObject
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 제품명
        /// </summary>
        private string productName;

        /// <summary>
        /// 단가
        /// </summary>
        private int unitPrice;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 제품명 - ProductName

        /// <summary>
        /// 제품명
        /// </summary>
        public string ProductName
        {
            get
            {
                return this.productName;
            }
            set
            {
                SetPropertyValue<string>("ProductName", ref this.productName, value);
            }
        }

        #endregion
        #region 단가 - UnitPrice

        /// <summary>
        /// 단가
        /// </summary>
        public int UnitPrice
        {
            get
            {
                return this.unitPrice;
            }
            set
            {
                SetPropertyValue<int>("UnitPrice", ref this.unitPrice, value);
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - ProductDataObject()

        /// <summary>
        /// 생성자
        /// </summary>
        public ProductDataObject() : base()
        {
        }

        #endregion
        #region 생성자 - ProductDataObject(session)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="session">Session 객체</param>
        public ProductDataObject(Session session) : base(session)
        {
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성 후 처리하기 - AfterConstruction()

        /// <summary>
        /// 생성 후 처리하기
        /// </summary>
        public override void AfterConstruction()
        {
            base.AfterConstruction();
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

using DevExpress.Xpo;

namespace TestProject

{

/// <summary>

/// 제품 데이터 객체

/// </summary>

public class ProductDataObject : XPObject

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

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

#region Field

/// <summary>

/// 제품명

/// </summary>

private string productName;

/// <summary>

/// 단가

/// </summary>

private int unitPrice;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

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

#region 제품명 - ProductName

/// <summary>

/// 제품명

/// </summary>

public string ProductName

{

get

{

return this.productName;

}

set

{

SetPropertyValue<string>("ProductName", ref this.productName, value);

}

#endregion

#region 단가 - UnitPrice

/// <summary>

/// 단가

/// </summary>

public int UnitPrice

{

get

{

return this.unitPrice;

}

set

{

SetPropertyValue<int>("UnitPrice", ref this.unitPrice, value);

}

#endregion

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

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

#region 생성자 - ProductDataObject()

/// <summary>

/// 생성자

/// </summary>

public ProductDataObject() : base()

{

}

#endregion

#region 생성자 - ProductDataObject(session)

/// <summary>

/// 생성자

/// </summary>

/// <param name="session">Session 객체</param>

public ProductDataObject(Session session) : base(session)

{

}

#endregion

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

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

#region 생성 후 처리하기 - AfterConstruction()

/// <summary>

/// 생성 후 처리하기

/// </summary>

public override void AfterConstruction()

{

base.AfterConstruction();

}

#endregion

}

▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    Width="800"
    Height="600"
    Title="XPO를 통해 데이터 표시하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Grid>
        <dxg:GridControl x:Name="gridControl"
            AutoPopulateColumns="True">
            <dxg:GridControl.View>
                <dxg:TableView Name="tableView" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

Width="800"

Height="600"

Title="XPO를 통해 데이터 표시하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Grid>

<dxg:GridControl x:Name="gridControl"

AutoPopulateColumns="True">

<dxg:GridControl.View>

<dxg:TableView Name="tableView" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

</Window>

▶ MainWindow.xaml.cs


using System.Windows;

using DevExpress.Xpo;
using DevExpress.Xpo.DB;

namespace TestProject
{
    /// <summary>
    /// 메인 윈도우
    /// </summary>
    public partial class MainWindow : Window
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - MainWindow()

        /// <summary>
        /// 생성자
        /// </summary>
        public MainWindow()
        {
            InitializeDataAccessLayer();

            GenerateData();

            InitializeComponent();

            this.gridControl.ItemsSource = new XPCollection<ProductDataObject>();
        }

        #endregion

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

        #region 데이터 액세스 레이어 초기화 하기 - InitializeDataAccessLayer()

        /// <summary>
        /// 데이터 액세스 레이어 초기화 하기
        /// </summary>
        private void InitializeDataAccessLayer()
        {
            XpoDefault.DataLayer = XpoDefault.GetDataLayer
            (
                AccessConnectionProvider.GetConnectionString(@"c:\\nwind.mdb"),
                AutoCreateOption.DatabaseAndSchema
            );
        }

        #endregion
        #region 데이터 생성하기 - GenerateData()

        /// <summary>
        /// 데이터 생성하기
        /// </summary>
        private void GenerateData()
        {
            if(Session.DefaultSession.FindObject<ProductDataObject>(null) != null)
            {
                return;
            }

            using(UnitOfWork unitOfWork = new UnitOfWork())
            {
                ProductDataObject productDataObject1 = new ProductDataObject(unitOfWork) { ProductName = "Product A", UnitPrice = 99  };
                ProductDataObject productDataObject2 = new ProductDataObject(unitOfWork) { ProductName = "Product B", UnitPrice = 199 };

                unitOfWork.CommitChanges();
            }
        }

        #endregion
    }
}

using System.Windows;

using DevExpress.Xpo;

using DevExpress.Xpo.DB;

namespace TestProject

{

/// <summary>

/// 메인 윈도우

/// </summary>

public partial class MainWindow : Window

{

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

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

#region 생성자 - MainWindow()

/// <summary>

/// 생성자

/// </summary>

public MainWindow()

{

InitializeDataAccessLayer();

GenerateData();

InitializeComponent();

this.gridControl.ItemsSource = new XPCollection<ProductDataObject>();

}

#endregion

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

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

#region 데이터 액세스 레이어 초기화 하기 - InitializeDataAccessLayer()

/// <summary>

/// 데이터 액세스 레이어 초기화 하기

/// </summary>

private void InitializeDataAccessLayer()

{

XpoDefault.DataLayer = XpoDefault.GetDataLayer

(

AccessConnectionProvider.GetConnectionString(@"c:\\nwind.mdb"),

AutoCreateOption.DatabaseAndSchema

);

}

#endregion

#region 데이터 생성하기 - GenerateData()

/// <summary>

/// 데이터 생성하기

/// </summary>

private void GenerateData()

{

if(Session.DefaultSession.FindObject<ProductDataObject>(null) != null)

{

return;

}

using(UnitOfWork unitOfWork = new UnitOfWork())

{

ProductDataObject productDataObject1 = new ProductDataObject(unitOfWork) { ProductName = "Product A", UnitPrice = 99 };

ProductDataObject productDataObject2 = new ProductDataObject(unitOfWork) { ProductName = "Product B", UnitPrice = 199 };

unitOfWork.CommitChanges();

}

#endregion

}

TestProject.zip nwind.zip

[C#/WPF/DEVEXPRESS] GridControl 클래스 : 인스턴트 피드백 UI 모드에서 메모리 데이터 병렬 처리하기

■ GridControl 클래스의 인스턴트 피드백 UI 모드에서 메모리 데이터를 병렬 처리하는 방법을 보여준다. ▶ OrderDataListSource.cs


using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;

namespace TestProject
{
    /// <summary>
    /// 주문 데이터 리스트 소스
    /// </summary>
    public class OrderDataListSource : IListSource
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Static
        //////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 잠금자
        /// </summary>
        private static object _locker = new object();

        #endregion

        ////////////////////////////////////////////////////////////////////////////////////////// Instance
        //////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 주문 데이터 리스트
        /// </summary>
        private List<OrderData> orderDataList;

        /// <summary>
        /// 카운트
        /// </summary>
        private int count = 0;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 리스트 컬렉션 포함 여부 - ContainsListCollection

        /// <summary>
        /// 리스트 컬렉션 포함 여부
        /// </summary>
        public bool ContainsListCollection
        {
            get
            {
                return false;
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - OrderDataListSource(count)

        /// <summary>
        /// 생성자
        /// </summary>
        /// <param name="count">카운트</param>
        public OrderDataListSource(int count)
        {
            this.count = count;
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 리스트 구하기 - GetList()

        /// <summary>
        /// 리스트 구하기
        /// </summary>
        /// <returns>리스트</returns>
        public IList GetList()
        {
            if(this.orderDataList == null)
            {
                lock(_locker)
                {
                    if(this.orderDataList == null)
                    {
                        GenerateOrderData();
                    }
                }
            }

            return this.orderDataList;
        }

        #endregion

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

        #region 주문 데이터 생성하기 - GenerateOrderData()

        /// <summary>
        /// 주문 데이터 생성하기
        /// </summary>
        private void GenerateOrderData()
        {
            this.orderDataList = new List<OrderData>(this.count);

            Random random = new Random();

            int customerCount = Data.CustomerList.Count;
            int productCount  = Data.ProductList.Count;

            for(int i = 0; i < this.count; i++)
            {
                OrderData orderData = new OrderData();

                orderData.OrderID      = i + 1;
                orderData.CustomerName = Data.CustomerList[random.Next(customerCount)];
                orderData.OrderDate    = DateTime.Today.Subtract(TimeSpan.FromDays(random.Next(180)));

                KeyValuePair<string, decimal> productKeyValuePair = Data.ProductList[random.Next(productCount)];

                orderData.ProductName = productKeyValuePair.Key;
                orderData.Price       = productKeyValuePair.Value;
                orderData.Quantity    = random.Next(200) + 1;

                this.orderDataList.Add(orderData);
            }
        }

        #endregion
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

using System;

using System.Collections;

using System.Collections.Generic;

using System.ComponentModel;

namespace TestProject

{

/// <summary>

/// 주문 데이터 리스트 소스

/// </summary>

public class OrderDataListSource : IListSource

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

////////////////////////////////////////////////////////////////////////////////////////// Static

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

#region Field

/// <summary>

/// 잠금자

/// </summary>

private static object _locker = new object();

#endregion

////////////////////////////////////////////////////////////////////////////////////////// Instance

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

#region Field

/// <summary>

/// 주문 데이터 리스트

/// </summary>

private List<OrderData> orderDataList;

/// <summary>

/// 카운트

/// </summary>

private int count = 0;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

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

#region 리스트 컬렉션 포함 여부 - ContainsListCollection

/// <summary>

/// 리스트 컬렉션 포함 여부

/// </summary>

public bool ContainsListCollection

{

get

{

return false;

}

#endregion

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

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

#region 생성자 - OrderDataListSource(count)

/// <summary>

/// 생성자

/// </summary>

/// <param name="count">카운트</param>

public OrderDataListSource(int count)

{

this.count = count;

}

#endregion

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

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

#region 리스트 구하기 - GetList()

/// <summary>

/// 리스트 구하기

/// </summary>

/// <returns>리스트</returns>

public IList GetList()

{

if(this.orderDataList == null)

{

lock(_locker)

{

if(this.orderDataList == null)

{

GenerateOrderData();

}

return this.orderDataList;

}

#endregion

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

#region 주문 데이터 생성하기 - GenerateOrderData()

/// <summary>

/// 주문 데이터 생성하기

/// </summary>

private void GenerateOrderData()

{

this.orderDataList = new List<OrderData>(this.count);

Random random = new Random();

int customerCount = Data.CustomerList.Count;

int productCount = Data.ProductList.Count;

for(int i = 0; i < this.count; i++)

{

OrderData orderData = new OrderData();

orderData.OrderID = i + 1;

orderData.CustomerName = Data.CustomerList[random.Next(customerCount)];

orderData.OrderDate = DateTime.Today.Subtract(TimeSpan.FromDays(random.Next(180)));

KeyValuePair<string, decimal> productKeyValuePair = Data.ProductList[random.Next(productCount)];

orderData.ProductName = productKeyValuePair.Key;

orderData.Price = productKeyValuePair.Value;

orderData.Quantity = random.Next(200) + 1;

this.orderDataList.Add(orderData);

}

#endregion

}

▶ ViewModel.cs


using System.ComponentModel;

namespace TestProject
{
    /// <summary>
    /// 뷰 모델
    /// </summary>
    public class ViewModel : INotifyPropertyChanged
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Event
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 속성 변경시 - PropertyChanged

        /// <summary>
        /// 속성 변경시
        /// </summary>
        public event PropertyChangedEventHandler PropertyChanged;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Field
        ////////////////////////////////////////////////////////////////////////////////////////// Private

        #region Field

        /// <summary>
        /// 주문 데이터 리스트 소스
        /// </summary>
        private OrderDataListSource orderDataListSource;

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Property
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 주문 데이터 리스트 소스 - OrderDataListSource

        /// <summary>
        /// 주문 데이터 리스트 소스
        /// </summary>
        public OrderDataListSource OrderDataListSource
        {
            get
            {
                return this.orderDataListSource;
            }
            set
            {
                if(this.orderDataListSource == value)
                {
                    return;
                }

                this.orderDataListSource = value;

                OnPropertyChanged("OrderDataListSource");
            }
        }

        #endregion

        //////////////////////////////////////////////////////////////////////////////////////////////////// Constructor
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 생성자 - ViewModel()

        /// <summary>
        /// 생성자
        /// </summary>
        public ViewModel()
        {
            OrderDataListSource = new OrderDataListSource(1000000);
        }

        #endregion

        ////////////////////////////////////////////////////////////////////////////////////////// Protected

        #region 속성 변경시 처리하기 - OnPropertyChanged(propertyName)

        /// <summary>
        /// 속성 변경시 처리하기
        /// </summary>
        /// <param name="propertyName">속성명</param>
        protected virtual void OnPropertyChanged(string propertyName)
        {
            PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));
        }

        #endregion
    }
}

using System.ComponentModel;

namespace TestProject

{

/// <summary>

/// 뷰 모델

/// </summary>

public class ViewModel : INotifyPropertyChanged

{

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

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

#region 속성 변경시 - PropertyChanged

/// <summary>

/// 속성 변경시

/// </summary>

public event PropertyChangedEventHandler PropertyChanged;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Field

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

#region Field

/// <summary>

/// 주문 데이터 리스트 소스

/// </summary>

private OrderDataListSource orderDataListSource;

#endregion

//////////////////////////////////////////////////////////////////////////////////////////////////// Property

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

#region 주문 데이터 리스트 소스 - OrderDataListSource

/// <summary>

/// 주문 데이터 리스트 소스

/// </summary>

public OrderDataListSource OrderDataListSource

{

get

{

return this.orderDataListSource;

}

set

{

if(this.orderDataListSource == value)

{

return;

}

this.orderDataListSource = value;

OnPropertyChanged("OrderDataListSource");

}

#endregion

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

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

#region 생성자 - ViewModel()

/// <summary>

/// 생성자

/// </summary>

public ViewModel()

{

OrderDataListSource = new OrderDataListSource(1000000);

}

#endregion

////////////////////////////////////////////////////////////////////////////////////////// Protected

#region 속성 변경시 처리하기 - OnPropertyChanged(propertyName)

/// <summary>

/// 속성 변경시 처리하기

/// </summary>

/// <param name="propertyName">속성명</param>

protected virtual void OnPropertyChanged(string propertyName)

{

PropertyChanged?.Invoke(this, new PropertyChangedEventArgs(propertyName));

}

#endregion

}

▶ MainWindow.xaml


<Window x:Class="TestProject.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
    xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core"
    xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors"
    xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"
    xmlns:local="clr-namespace:TestProject"
    Width="800"
    Height="600"
    Title="인스턴트 피드백 UI 모드에서 메모리 데이터 병렬 처리하기"
    FontFamily="나눔고딕코딩"
    FontSize="16">
    <Window.DataContext>
        <local:ViewModel />
    </Window.DataContext>
    <Grid>
        <dx:PLinqInstantFeedbackDataSource x:Name="pLinqInstantFeedbackDataSource"
            ListSource="{Binding Path=OrderDataListSource}" />
        <dxg:GridControl x:Name="gridControl"
            ItemsSource="{Binding ElementName=pLinqInstantFeedbackDataSource, Path=Data}">
            <dxg:GridControl.Columns>
                <dxg:GridColumn x:Name="idGridColumn"
                    FieldName="OrderID"
                    Header="ID"
                    Width="60"
                    MinWidth="60"
                    AllowColumnFiltering="False"
                    AllowGrouping="False" />
                <dxg:GridColumn x:Name="customerNameGridColumn"
                    FieldName="CustomerName"
                    Width="200" />
                <dxg:GridColumn x:Name="orderDateGridColumn"
                    FieldName="OrderDate"
                    Width="100"
                    AllowColumnFiltering="False">
                    <dxg:GridColumn.EditSettings>
                        <dxe:DateEditSettings DisplayFormat="d" />
                    </dxg:GridColumn.EditSettings>
                </dxg:GridColumn>
                <dxg:GridColumn x:Name="productNameGridColumn"
                    FieldName="ProductName"
                    Width="200" />
                <dxg:GridColumn x:Name="priceGridColumn"
                    FieldName="Price"
                    Width="60" />
                <dxg:GridColumn x:Name="quantityGridColumn"
                    FieldName="Quantity"
                    Width="60" />
            </dxg:GridControl.Columns>
            <dxg:GridControl.View>
                <dxg:TableView
                    AutoWidth="False"
                    ShowTotalSummary="False"
                    RowAnimationKind="Opacity" />
            </dxg:GridControl.View>
        </dxg:GridControl>
    </Grid>
    <i:Interaction.Triggers>
        <i:EventTrigger EventName="Closed">
            <i:InvokeCommandAction Command="{Binding ElementName=pLinqInstantFeedbackDataSource, Path=DisposeCommand}" />
        </i:EventTrigger>
    </i:Interaction.Triggers>
</Window>

<Window x:Class="TestProject.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"

xmlns:dx="http://schemas.devexpress.com/winfx/2008/xaml/core"

xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors"

xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid"

xmlns:local="clr-namespace:TestProject"

Width="800"

Height="600"

Title="인스턴트 피드백 UI 모드에서 메모리 데이터 병렬 처리하기"

FontFamily="나눔고딕코딩"

FontSize="16">

<Window.DataContext>

<local:ViewModel />

</Window.DataContext>

<Grid>

<dx:PLinqInstantFeedbackDataSource x:Name="pLinqInstantFeedbackDataSource"

ListSource="{Binding Path=OrderDataListSource}" />

<dxg:GridControl x:Name="gridControl"

ItemsSource="{Binding ElementName=pLinqInstantFeedbackDataSource, Path=Data}">

<dxg:GridControl.Columns>

<dxg:GridColumn x:Name="idGridColumn"

FieldName="OrderID"

Header="ID"

Width="60"

MinWidth="60"

AllowColumnFiltering="False"

AllowGrouping="False" />

<dxg:GridColumn x:Name="customerNameGridColumn"

FieldName="CustomerName"

Width="200" />

<dxg:GridColumn x:Name="orderDateGridColumn"

FieldName="OrderDate"

Width="100"

AllowColumnFiltering="False">

<dxg:GridColumn.EditSettings>

<dxe:DateEditSettings DisplayFormat="d" />

</dxg:GridColumn.EditSettings>

</dxg:GridColumn>

<dxg:GridColumn x:Name="productNameGridColumn"

FieldName="ProductName"

Width="200" />

<dxg:GridColumn x:Name="priceGridColumn"

FieldName="Price"

Width="60" />

<dxg:GridColumn x:Name="quantityGridColumn"

FieldName="Quantity"

Width="60" />

</dxg:GridControl.Columns>

<dxg:GridControl.View>

<dxg:TableView

AutoWidth="False"

ShowTotalSummary="False"

RowAnimationKind="Opacity" />

</dxg:GridControl.View>

</dxg:GridControl>

</Grid>

<i:Interaction.Triggers>

<i:EventTrigger EventName="Closed">

<i:InvokeCommandAction Command="{Binding ElementName=pLinqInstantFeedbackDataSource, Path=DisposeCommand}" />

</i:EventTrigger>

</i:Interaction.Triggers>

</Window>