-
Notifications
You must be signed in to change notification settings - Fork 0
/
MainWindow.xaml.cs
55 lines (51 loc) · 2.23 KB
/
MainWindow.xaml.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
using DevExpress.Data.Filtering;
using DevExpress.Xpf.Core.FilteringUI;
using DevExpress.Xpf.Editors;
using DevExpress.Xpf.Editors.Settings;
using System;
using System.Windows;
namespace WpfPivotCustomFilterDropDownExample
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : DevExpress.Xpf.Core.ThemedWindow
{
public MainWindow()
{
InitializeComponent();
}
private void ThemedWindow_Loaded(object sender, RoutedEventArgs e)
{
pivotGridControl1.BestFitArea = DevExpress.Xpf.PivotGrid.FieldBestFitArea.FieldHeader;
pivotGridControl1.BestFit();
}
private void OnExcelStyleFilterQueryOperators(object sender, ExcelStyleFilterElementQueryOperatorsEventArgs e)
{
e.Operators.Clear();
e.Operators.Add(new ExcelStyleFilterElementOperatorItem(ExcelStyleFilterElementOperatorType.Between) { Caption = "Between" });
e.Operators.Add(new ExcelStyleFilterElementOperatorItem(ExcelStyleFilterElementOperatorType.DateOperators) { Caption = "Date Operators" });
e.Operators.Add(CreateLastYearsOperator());
}
private ExcelStyleFilterElementOperatorItem CreateLastYearsOperator()
{
const 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;
}
);
CriteriaOperator.RegisterCustomFunction(customFunction);
var customFunctionEditSettings = new BaseEditSettings[] {
new TextEditSettings {
MaskType = MaskType.Numeric,
Mask = "D",
MaskUseAsDisplayFormat = true,
NullText ="Enter the number of years before..."}
};
return new ExcelStyleFilterElementOperatorItem(CustomFunctionName, customFunctionEditSettings) { Caption = "Last Years" };
}
}
}