如何用界面组件DevExpress WPF创建Excel式的过滤功能？

DevExpress WPF拥有120个控件和库将帮助您交付满足甚至超出企业需求的高性能业务应用程序。通过DevExpress WPF能创建有着强大互动功能的XAML基础应用程序这些应用程序专注于当代客户的需求和构建未来新一代支持触摸的解决方案。DevExpress WPF在v19.2版本中添加了新的excel样式下拉过滤器旨在简化使用并为最终用户提供各种数据分析增强功能这个下拉过滤器还被设计为为开发人员扩展定制功能。DevExpress新旧版本帮助文档下载可进QQ qun获取169725316在v19.2及之后的版本中这个下拉过滤器默认在以下几个控件中使用Data GridTreeListPivot Grid接下来我们将详细介绍Excel样式下拉过滤器的功能。记录计数显示在应用筛选器时您可能希望知道有多少条记录与给定筛选器值匹配Excel-Style Drop-Down Filter在过滤器值旁边显示一个记录计数。日期时间间隔Excel-Style Drop-Down Filter允许您在其中组合不同的日期间隔。数据分析过滤器您可以在xcel-Style Drop-Down Filter中应用以下数字过滤器Top / Bottom NAbove / Below AverageUnique / Duplicate这些筛选器允许分析数据网格中的信息而无需构造复杂的筛选条件。条件格式过滤器Data Grid和TreeList允许您指定条件格式规则并给予这些规则应用过滤器。分组过滤器在Data Grid和TreeList中可以对来自两个或多个列的筛选值进行分组并将结果显示为一个分层检查列表这个功能允许用户根据多个列筛选数据。要合并此功能请将ColumnBase.FilterPopupGroupFields属性设置为针对筛选器值进行分组的字段的名称名称之间用逗号、分号或空格隔开字段名的顺序决定了组内的层次结构。dxg:GridControl dxg:GridControl.Columns dxg:GridColumn FieldNameID / dxg:GridColumn FieldNameTrademark / dxg:GridColumn FieldNameModel FilterPopupGroupFieldsTrademark;Model / /dxg:GridControl.Columns ... /dxg:GridControl预定义的过滤器Excel-style Drop-Down Filter允许您附带预定义的过滤器预定义过滤器显示在Filter Rules选项卡中。Data Grid和TreeList允许您使用ColumnBase.PredefinedFilters 属性指定这样的过滤器。dxg:GridColumn FieldNameUnitPrice dxg:GridColumn.PredefinedFilters dxfui:PredefinedFilterCollection dxfui:PredefinedFilter NameLess than 10 Filter?p ≤ 10 / dxfui:PredefinedFilter NameBetween 10 and 50 Filter?p 10 and ?p ≤ 50 / dxfui:PredefinedFilter NameBetween 50 and 100 Filter?p 50 and ?p ≤ 100 / dxfui:PredefinedFilter NameGreater than 100 Filter?p 100 / /dxfui:PredefinedFilterCollection /dxg:GridColumn.PredefinedFilters /dxg:GridColumn自定义使用 ColumnBase.CustomColumnFilterPopupTemplate 属性来指定一个自定义数据模板在这个模板中定义一个筛选器元素并指定其设置。自定义过滤器弹出内容dxg:GridControl x:Namegrid ItemsSource... dxg:GridControl.Columns ... dxg:GridColumn FieldNameQuantity dxg:GridColumn.CustomColumnFilterPopupTemplate DataTemplate dxfui:RangeFilterElement x:NamePART_FilterElement/ /DataTemplate /dxg:GridColumn.CustomColumnFilterPopupTemplate /dxg:GridColumn ... /dxg:GridControl.Columns /dxg:GridControl自定义运算符列表dxg:GridColumn FieldNameOrderDate dxg:GridColumn.CustomColumnFilterPopupTemplate DataTemplate dxfui:ExcelStyleFilterElement x:NamePART_FilterElement QueryOperatorsOnExcelStyleFilterQueryOperators/ /DataTemplate /dxg:GridColumn.CustomColumnFilterPopupTemplate /dxg:GridColumn void OnExcelStyleFilterQueryOperators(object sender, ExcelStyleFilterElementQueryOperatorsEventArgs e) { if(e.FieldName OrderDate) { e.Operators.Clear(); e.Operators.Add(new ExcelStyleFilterElementOperatorItem( ExcelStyleFilterElementOperatorType.Equal)); e.Operators.Add(new ExcelStyleFilterElementOperatorItem( ExcelStyleFilterElementOperatorType.NotEqual)); } }创建自定义运算符dxg:GridColumn FieldNameOrderDate dxg:GridColumn.CustomColumnFilterPopupTemplate DataTemplate dxfui:ExcelStyleFilterElement x:NamePART_FilterElement QueryOperatorsOnExcelStyleFilterQueryOperators/ /DataTemplate /dxg:GridColumn.CustomColumnFilterPopupTemplate /dxg:GridColumnconst string CustomFunctionName LastYears; var currentYear DateTime.Now.Year; ICustomFunctionOperatorBrowsable customFunction CustomFunctionFactory.Create( CustomFunctionName, (DateTime date, int threshold) { return currentYear date.Year currentYear - date.Year threshold; } ); void OnExcelStyleFilterQueryOperators(object sender, ExcelStyleFilterElementQueryOperatorsEventArgs e) { if(e.FieldName OrderDate) { // ... var customFunctionEditSettings new BaseEditSettings[] { new TextEditSettings { MaskType MaskType.Numeric, Mask D, MaskUseAsDisplayFormat true } }; e.Operators.Add(new ExcelStyleFilterElementOperatorItem(CustomFunctionName, customFunctionEditSettings) { Caption Last Years }); } }自定义操作数模板UserControl.Resources DataTemplate x:KeyternaryTemplate dxe:TrackBarEdit Minimum0 Maximum300 MinWidth120 TickPlacementNone dxe:TrackBarEdit.EditValue MultiBinding Converter{local:TrackBarEditRangeConverter} Binding PathLeftValueItem.Value/ Binding PathRightValueItem.Value/ /MultiBinding /dxe:TrackBarEdit.EditValue dxe:TrackBarEdit.StyleSettings dxe:TrackBarRangeStyleSettings / /dxe:TrackBarEdit.StyleSettings /dxe:TrackBarEdit /DataTemplate /UserControl.Resources ... dxg:GridColumn FieldNameQuantity dxg:GridColumn.CustomColumnFilterPopupTemplate DataTemplate dxfui:ExcelStyleFilterElement x:NamePART_FilterElement QueryOperatorsOnExcelStyleFilterQueryOperators/ /DataTemplate /dxg:GridColumn.CustomColumnFilterPopupTemplate /dxg:GridColumn void OnExcelStyleFilterQueryOperators(object sender, ExcelStyleFilterElementQueryOperatorsEventArgs e) { if(e.FieldName Quantity) { var template (DataTemplate)FindResource(ternaryTemplate); e.Operators[ExcelStyleFilterElementOperatorType.Between].OperandTemplate template; e.Operators[ExcelStyleFilterElementOperatorType.NotBetween].OperandTemplate template; } }