使用绑定数据和转换器对数据网格列进行排序 [英] Sorting on datagrid column with binded data and converter

问题描述

我正在尝试对数据网格中的数据进行排序，但是当我单击与转换器绑定的列的标题时，没有任何反应.我使用 MVVM 模式.下面附上例子.在示例中，网格显示列 (Type)，该列显示人员类型，因此我使用转换器(TypeValueConverter 类).当我使用这个转换器时，网格不会对列类型进行排序.

I'm trying to sort data in datagrid, but when I click on the header of the column which has binding with the converter, nothing happens. I use MVVM pattern. Example is attached below. In the example, the grid shows column (Type) which displays type of person and therefore I use converter (class TypeValueConverter). When I use this converter, the grid doesn't sort column Type.

<Window x:Class="GridSort.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:my="clr-namespace:GridSort"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <DataGrid ItemsSource="{Binding People}" AutoGenerateColumns="False">
            <DataGrid.Resources>
                <my:TypeValueConverter x:Key="typeConverter" />
            </DataGrid.Resources>
            <DataGrid.Columns>
                <DataGridTextColumn Binding="{Binding FirstName}" Header="FirstName" />
                <DataGridTextColumn Binding="{Binding Surname}" Header="Surname" />
                <DataGridTextColumn Binding="{Binding Converter={StaticResource ResourceKey=typeConverter}}" Header="Type" />
            </DataGrid.Columns>
        </DataGrid>
    </Grid>
</Window>

public class ViewModel
{
    private ICollection<Person> people;
    public ICollection<Person> People
    {
        get
        {
            if (this.people == null)
            {
                this.people = new List<Person>();
                this.people.Add(new Student() { FirstName = "Charles", Surname = "Simons" });
                this.people.Add(new Student() { FirstName = "Jake", Surname = "Baron" });
                this.people.Add(new Teacher() { FirstName = "John", Surname = "Jackson" });
                this.people.Add(new Student() { FirstName = "Patricia", Surname = "Phillips" });
                this.people.Add(new Student() { FirstName = "Martin", Surname = "Weber" });
            }

            return this.people;
        }
    }
}

public class TypeValueConverter : IValueConverter
    {
        public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            if (value == null)
            {
                return DependencyProperty.UnsetValue;
            }

            return value.GetType().Name;
        }

        public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            throw new NotImplementedException();
        }
    }

public abstract class Person
    {
        public string FirstName
        {
            get;
            set;
        }

        public string Surname
        {
            get;
            set;
        }
    }

    public class Student : Person
    {
    }

    public class Teacher : Person
    {
    }

推荐答案

我自己解决了这个问题 :)

I resolved this issue myself :)

我为带有附加属性 UseBindingToSort 的网格创建了新行为.当我将此属性设置为 true 时，会订阅网格上的事件排序.在网格触发事件排序后，我将自定义比较器与绑定中定义的 IValueConverter 一起使用.解决方法如下:

I created new behavior for grid with attached property UseBindingToSort. When I set this property to true then event Sorting on grid is subscribed. After grid fires event sorting I use custom comparer with IValueConverter which is defined in binding. Solution is below:

更改视图

<DataGrid ItemsSource="{Binding People}" AutoGenerateColumns="False"  my:GridSortingBehavior.UseBindingToSort="True">

带有附加属性的新行为:

New behavior with attached property:

public static class GridSortingBehavior
    {
        public static readonly DependencyProperty UseBindingToSortProperty = DependencyProperty.RegisterAttached("UseBindingToSort", typeof(bool), typeof(GridSortingBehavior), new PropertyMetadata(new PropertyChangedCallback(GridSortPropertyChanged)));

        public static void SetUseBindingToSort(DependencyObject element, bool value)
        {
            element.SetValue(UseBindingToSortProperty, value);
        }

        private static void GridSortPropertyChanged(DependencyObject elem, DependencyPropertyChangedEventArgs e)
        {
            DataGrid grid = elem as DataGrid;
            if (grid != null){
                if ((bool)e.NewValue)
                {
                    grid.Sorting += new DataGridSortingEventHandler(grid_Sorting);
                }
                else
                {
                    grid.Sorting -= new DataGridSortingEventHandler(grid_Sorting);
                }
            }
        }

        static void grid_Sorting(object sender, DataGridSortingEventArgs e)
        {
            DataGridTextColumn clm = e.Column as DataGridTextColumn;
            if (clm != null)
            {
                DataGrid grid = ((DataGrid)sender);
                IValueConverter converter = null;
                if (clm.Binding != null)
                {
                    Binding binding = clm.Binding as Binding;
                    if (binding.Converter != null)
                    {
                        converter = binding.Converter;
                    }
                }

                if (converter != null)
                {
                    e.Handled = true;
                    ListSortDirection direction = (clm.SortDirection != ListSortDirection.Ascending) ? ListSortDirection.Ascending : ListSortDirection.Descending;
                    clm.SortDirection = direction;
                    ListCollectionView lcv = (ListCollectionView)CollectionViewSource.GetDefaultView(grid.ItemsSource);
                    lcv.CustomSort = new ComparerWithComparer(converter, direction);
                }
            }
        }

最后是我的自定义比较器:

And finally my custom comparer:

class ComparerWithComparer : IComparer
    {
        private System.Windows.Data.IValueConverter converter;
        private System.ComponentModel.ListSortDirection direction;


        public ComparerWithComparer(System.Windows.Data.IValueConverter converter, System.ComponentModel.ListSortDirection direction)
        {
            this.converter = converter;
            this.direction = direction;
        }

        public int Compare(object x, object y)
        {
            object transx = this.converter.Convert(x, typeof(string), null, System.Threading.Thread.CurrentThread.CurrentCulture);
            object transy = this.converter.Convert(y, typeof(string), null, System.Threading.Thread.CurrentThread.CurrentCulture);
            if (direction== System.ComponentModel.ListSortDirection.Ascending){
                return Comparer.Default.Compare(transx, transy);
            }
            else
            {
                return Comparer.Default.Compare(transx, transy) * (-1);
            }
        }
    }

仅此而已.

这篇关于使用绑定数据和转换器对数据网格列进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！