在DataGrid中使用字段过滤可以用来进行数据的筛选,查找出符合条件的信息。本文将为大家介绍如何对DataGrid执行字段过滤。
需要了解的知识
1)PagedCollectionView
它代表了一个有关分组、排序、筛选和导航的分页数据集合。
2)PagedCollectionView的Filter属性
用来设置PagedCollectionView的过滤器,进行字段信息等过滤。
3)过滤器函数
用作过滤器的主体
实例
详细的说明在代码注释中给出。
MainPage.xaml文件代码:
MainPage.xaml.cs文件代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.Windows.Data;
namespace SilverlightClient
{
public class Employees
{
public int EmployeeID { get; set; }
public string EmployeeName { get; set; }
public int EmployeeAge { get; set; }
public string DepartmentName { get; set; }
public string Level { get; set; }
}
public partial class MainPage : UserControl
{
PagedCollectionView pcv;
public MainPage()
{
InitializeComponent();
this.Loaded += new RoutedEventHandler(MainPage_Loaded);
this.btnFilter.Click += new RoutedEventHandler(btnFilter_Click);
this.btnRestore.Click += new RoutedEventHandler(btnRestore_Click);
}
public List<string> GetColumns()
{
List<string> c = new List<string>();
c.Add("员工号");
c.Add("姓名");
c.Add("年龄");
c.Add("部门");
c.Add("级别");
return c;
}
public List
{
List
returnedValue.Add(new Employees() { EmployeeID = 1, EmployeeName = "张三", EmployeeAge = 23, DepartmentName = "财务部", Level = "初级" });
returnedValue.Add(new Employees() { EmployeeID = 2, EmployeeName = "李四", EmployeeAge = 24, DepartmentName = "财务部", Level = "中级" });
returnedValue.Add(new Employees() { EmployeeID = 3, EmployeeName = "王五", EmployeeAge = 25, DepartmentName = "管理部", Level = "中级" });
returnedValue.Add(new Employees() { EmployeeID = 4, EmployeeName = "赵六", EmployeeAge = 26, DepartmentName = "管理部", Level = "初级" });
returnedValue.Add(new Employees() { EmployeeID = 5, EmployeeName = "钱七", EmployeeAge = 27, DepartmentName = "工程部", Level = "中级" });
returnedValue.Add(new Employees() { EmployeeID = 6, EmployeeName = "孙八", EmployeeAge = 28, DepartmentName = "工程部", Level = "初级" });
returnedValue.Add(new Employees() { EmployeeID = 7, EmployeeName = "小赵", EmployeeAge = 26, DepartmentName = "财务部", Level = "中级" });
returnedValue.Add(new Employees() { EmployeeID = 8, EmployeeName = "小钱", EmployeeAge = 28, DepartmentName = "财务部", Level = "高级" });
return returnedValue;
}
void MainPage_Loaded(object sender, RoutedEventArgs e)
{
GetRestore();
}
void btnRestore_Click(object sender, RoutedEventArgs e)
{
GetRestore();
}
void btnFilter_Click(object sender, RoutedEventArgs e)
{
if (cbColumns.SelectedIndex != -1 && tbValue.Text != "")
{
switch (cbColumns.SelectedIndex)
{
case 0:
pcv.Filter = new Predicate<object>(FilterEmployeeID);
break;
case 1:
pcv.Filter = new Predicate<object>(FilterEmployeeName);
break;
case 2:
pcv.Filter = new Predicate<object>(FilterEmployeeAge);
break;
case 3:
pcv.Filter = new Predicate<object>(FilterDepartmentName);
break;
case 4:
pcv.Filter = new Predicate<object>(FilterLevel);
break;
}
}
}
//过滤器函数
public bool FilterEmployeeID(object t)
{
Employees em = t as Employees;
return (em.EmployeeID == Convert.ToInt32(tbValue.Text));
}
public bool FilterEmployeeName(object t)
{
Employees em = t as Employees;
return (em.EmployeeName == Convert.ToString(tbValue.Text));
}
public bool FilterEmployeeAge(object t)
{
Employees em = t as Employees;
return (em.EmployeeAge >= Convert.ToInt32(tbValue.Text));//这里用的是大于等于条件
}
public bool FilterDepartmentName(object t)
{
Employees em = t as Employees;
return (em.DepartmentName == Convert.ToString(tbValue.Text));
}
public bool FilterLevel(object t)
{
Employees em = t as Employees;
return (em.Level == Convert.ToString(tbValue.Text));
}
//重置信息
public void GetRestore()
{
pcv = new PagedCollectionView(GetEmployees());
dgEmployee.ItemsSource = pcv;
cbColumns.ItemsSource = GetColumns();
cbColumns.SelectedIndex = 0;
tbValue.Text = String.Empty;
}
}
}
最终效果图
