对多个列排序DataGridView？ [英] Sort a DataGridView on multiple columns?
问题描述
我搜索了一个在多个列上排序DataGridView的示例，但似乎无法找到一个我想要的例子。
I've searched for an example of sorting a DataGridView on multiple columns, but don't seem to be able to find an example which does what I would like.
基本上，我有一个绑定的DataGridView控件（绑定到DataTable / DataView），绑定的DataTable有两列： - 优先级和日期。我想按日期排序优先。也就是说，优先级列是先决条件，那么它的日期，但都可以是升序或降序。
Basically, I have a bound DataGridView control (bound to a DataTable/DataView), and the bound DataTable has two columns:- priority and date. I would like to sort by date within priority. That is, the priority column takes precendence, then its the date but both can be ascending or descending.
所以，例如，我可能优先级低， （按优先级顺序排列，日期为asc），并且通过单击日期列标题切换到低优先级，迟到日期首先（按优先级排序，日期描述） 。如果我然后点击优先级，首先要高优先级，然后是迟到日期（当前排序顺序为日期列 - 按优先级顺序排序，日期描述），但是可以点击日期列标题切换到高优先级，提前日期（按优先级排序，日期为asc）
So, for example, I may have low priority, early date first (order by priority asc, date asc), and, by clicking the date column header, switch to low priority, late date first (order by priority asc, date desc). If I then click on the priority, I would like to have high priority first, then late date (the current sort order for the date column - order by priority desc, date desc), but then be able to click the date column header to switch to high priority, early date (order by priority desc, date asc).
理想情况下，像两列上的排序字形一样显示升序或降序。
Ideally, I would like sort glyphs on both columns to show ascending or descending.
任何想法或指针都将被感激地收到。
Any ideas or pointers would be gratefully received.
（见下文）似乎很接近，但字形不正常。
This (see below) seems to get pretty close, but the glyphs aren't working right.
using System;
using System.Windows.Forms;
namespace WindowsFormsApplication4
{
public partial class Form1 : Form
{
DataSet1 dataset;
public Form1()
{
InitializeComponent();
dataset = new DataSet1(); // two columns: Priority(Int32) and date (DateTime)
dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("01-jan-10"));
dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("02-jan-10"));
dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("03-jan-10"));
dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("04-jan-10"));
dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("05-jan-10"));
dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("06-jan-10"));
dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("07-jan-10"));
dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("08-jan-10"));
dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("09-jan-10"));
dataGridView1.DataSource = dataset.DataTable1.DefaultView;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[0].HeaderCell.SortGlyphDirection = SortOrder.Ascending;
dataGridView1.Columns[1].HeaderCell.SortGlyphDirection = SortOrder.Ascending;
}
private void dataGridView1_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridViewColumn[] column = new[] { dataGridView1.Columns[0], dataGridView1.Columns[1] };
DataGridViewColumnHeaderCell headerCell = dataGridView1.Columns[e.ColumnIndex].HeaderCell;
if (headerCell.SortGlyphDirection != SortOrder.Ascending)
headerCell.SortGlyphDirection = SortOrder.Ascending;
else
headerCell.SortGlyphDirection = SortOrder.Descending;
String sort = column[0].DataPropertyName + " " + fnSortDirection(column[0])
+ ", "
+ column[1].DataPropertyName + " " + fnSortDirection(column[1]);
dataset.DataTable1.DefaultView.Sort = sort;
this.textBox1.Text = sort;
}
private String fnSortDirection(DataGridViewColumn column)
{
return column.HeaderCell.SortGlyphDirection != SortOrder.Descending ? "asc" : "desc";
}
}
}
推荐答案
好的。
从Cody上面的建议开始，我现在有一些似乎按预期工作的东西。我已经对HeaderCell进行了子类化，并且覆盖了Paint方法（但是通过在base.Paint之前立即设置SortGlyphDirection而被欺骗），而DGV现在可以绘制多个排序字形。
Following from Cody's suggestions above, I now have something which seems to work as expected. I have sub-classed the HeaderCell and over-ridden the Paint method (but cheated by setting the SortGlyphDirection immediately prior to the base.Paint) and the DGV now paints multiple sorting glyphs.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows.Forms;
namespace WindowsFormsApplication4
{
public partial class Form1 : Form
{
DataSet1 dataset;
public Form1()
{
InitializeComponent();
dataset = new DataSet1(); // three columns: Priority(Int32), Date (DateTime) and Description(String)
dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("01-jan-10"), "this");
dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("02-jan-10"), "is");
dataset.DataTable1.AddDataTable1Row(1, DateTime.Parse("03-jan-10"), "a");
dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("04-jan-10"), "sample");
dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("05-jan-10"), "of");
dataset.DataTable1.AddDataTable1Row(2, DateTime.Parse("06-jan-10"), "the");
dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("07-jan-10"), "data");
dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("08-jan-10"), "in");
dataset.DataTable1.AddDataTable1Row(3, DateTime.Parse("09-jan-10"), "use");
dataGridView1.DataSource = dataset.DataTable1.DefaultView;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.Columns[0].HeaderCell = new MyDataGridViewColumnHeaderCell();
dataGridView1.Columns[1].HeaderCell = new MyDataGridViewColumnHeaderCell();
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.Programmatic;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.Programmatic;
}
private void dataGridView1_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridViewColumn clickedColumn = dataGridView1.Columns[e.ColumnIndex];
if (clickedColumn.HeaderCell is MyDataGridViewColumnHeaderCell)
{
DoMultiColumnSort();
}
else
{
dataGridView1.Columns.OfType<DataGridViewColumn>()
.Where(column => column.HeaderCell is MyDataGridViewColumnHeaderCell)
.ForEach(column => ((MyDataGridViewColumnHeaderCell)column.HeaderCell).SortOrderDirection = SortOrder.None);
}
this.textBox1.Text = dataset.DataTable1.DefaultView.Sort;
}
private void DoMultiColumnSort()
{
var sortClauses = dataGridView1.Columns.OfType<DataGridViewColumn>()
.Where(column => column.HeaderCell is MyDataGridViewColumnHeaderCell)
.Select(column => GetSortClause(column));
dataset.DataTable1.DefaultView.Sort = String.Join(",", sortClauses);
}
private String GetSortClause(DataGridViewColumn column)
{
SortOrder direction = column.HeaderCell.SortGlyphDirection;
if (column.HeaderCell is MyDataGridViewColumnHeaderCell)
{
direction = ((MyDataGridViewColumnHeaderCell)column.HeaderCell).SortOrderDirection;
}
return column.DataPropertyName + " " + (direction == SortOrder.Descending ? "DESC" : "ASC");
}
}
public partial class MyDataGridViewColumnHeaderCell : DataGridViewColumnHeaderCell
{
public SortOrder SortOrderDirection { get; set; } // defaults to zero = SortOrder.None;
protected override void Paint(System.Drawing.Graphics graphics, System.Drawing.Rectangle clipBounds, System.Drawing.Rectangle cellBounds, int rowIndex, DataGridViewElementStates dataGridViewElementState, object value, object formattedValue, string errorText, DataGridViewCellStyle cellStyle, DataGridViewAdvancedBorderStyle advancedBorderStyle, DataGridViewPaintParts paintParts)
{
this.SortGlyphDirection = this.SortOrderDirection;
base.Paint(graphics, clipBounds, cellBounds, rowIndex, dataGridViewElementState, value, formattedValue, errorText, cellStyle, advancedBorderStyle, paintParts);
}
public override object Clone()
{
MyDataGridViewColumnHeaderCell result = (MyDataGridViewColumnHeaderCell)base.Clone();
result.SortOrderDirection = this.SortOrderDirection;
return result;
}
protected override void OnClick(DataGridViewCellEventArgs e)
{
this.SortOrderDirection = (this.SortOrderDirection != SortOrder.Ascending) ? SortOrder.Ascending : SortOrder.Descending;
base.OnClick(e);
}
}
public static partial class Extensions
{
public static void ForEach<T>(this IEnumerable<T> value, Action<T> action) { foreach (T item in value) { action(item); } }
}
}
这篇关于对多个列排序DataGridView？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
