public Example()
{
InitializeComponent();
this.radGridView.FilterDescriptors.SuspendNotifications();
IColumnFilterDescriptor birthDateFilter = this.radGridView.Columns["CompanyName"].ColumnFilterDescriptor;
birthDateFilter.SuspendNotifications();
birthDateFilter.FieldFilter.Filter1.Operator = FilterOperator.Contains;
birthDateFilter.FieldFilter.Filter1.Value = "Delikatessen";
birthDateFilter.FieldFilter.Filter1.IsCaseSensitive = true;
birthDateFilter.FieldFilter.LogicalOperator = FilterCompositionLogicalOperator.Or;
birthDateFilter.FieldFilter.Filter2.Operator = FilterOperator.Contains;
birthDateFilter.FieldFilter.Filter2.Value = "market";
birthDateFilter.FieldFilter.Filter2.IsCaseSensitive = false;
birthDateFilter.ResumeNotifications();
IColumnFilterDescriptor countryFilter = this.radGridView.Columns["Country"].ColumnFilterDescriptor;
countryFilter.SuspendNotifications();
countryFilter.DistinctFilter.AddDistinctValue("USA");
countryFilter.DistinctFilter.AddDistinctValue("Canada");
countryFilter.DistinctFilter.AddDistinctValue("Germany");
countryFilter.ResumeNotifications();
this.radGridView.FilterDescriptors.ResumeNotifications();
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
DataContext = RequirementViewModelLocator.GetRequirementVM();
// Link the RichTextBoxRibbon to the commands defined in the RichTextBox control, part of the Telerik library
radRichTextBoxRibbonUI.DataContext = radRichTextBox.Commands;
IColumnFilterDescriptor DeletedRequirementFilter = this.RequirementTreeListView.Columns["IsDeleted"].ColumnFilterDescriptor;
DeletedRequirementFilter.FieldFilter.Filter1.Operator = FilterOperator.IsEqualTo;
DeletedRequirementFilter.FieldFilter.Filter1.Value = "False";
}
//видалити значення фільтра з GridView - звільнені
private void NotWorkingCheckBox_Unchecked(object sender, RoutedEventArgs e)
{
Telerik.Windows.Controls.GridViewColumn isworkColumn = this.RadGridView.Columns["IsWork"];
IColumnFilterDescriptor workerFilter = isworkColumn.ColumnFilterDescriptor;
// Призупинити фільтр GridView
workerFilter.SuspendNotifications();
// видалити з GridView фільтр
workerFilter.DistinctFilter.RemoveDistinctValue("Звільнений");
workerFilter.FieldFilter.Filter1.IsCaseSensitive = true;
//оновити фільтр GridView
workerFilter.ResumeNotifications();
}
//вивести всіх працюючих на даний час працівників в GridView
private void WorkingCheckBox_Checked(object sender, RoutedEventArgs e)
{
if (WorkingCheckBox.IsChecked == true)
{
Telerik.Windows.Controls.GridViewColumn isworkColumn = this.RadGridView.Columns["IsWork"];
IColumnFilterDescriptor workerFilter = isworkColumn.ColumnFilterDescriptor;
// Призупинити фільтр GridView
workerFilter.SuspendNotifications();
// додати значенння фільтру в GridView
workerFilter.DistinctFilter.AddDistinctValue("Працює");
workerFilter.FieldFilter.Filter1.IsCaseSensitive = true;
//оновити фільтр GridView
workerFilter.ResumeNotifications();
}
}
//加载过滤设定;
public static void LoadColumnFilters(GridViewDataControl grid
, IEnumerable <FilterSetting> savedSettings)
{
if (savedSettings.Count() == 0)
{
grid.FilterDescriptors.Clear();
return;
}
grid.FilterDescriptors.SuspendNotifications();
foreach (FilterSetting setting in savedSettings)
{
Telerik.Windows.Controls.GridViewColumn column = grid.Columns[setting.ColumnUniqueName];
IColumnFilterDescriptor columnFilter = column.ColumnFilterDescriptor;
foreach (object distinctValue in setting.SelectedDistinctValues)
{
columnFilter.DistinctFilter.AddDistinctValue(distinctValue);
}
if (setting.Filter1 != null)
{
columnFilter.FieldFilter.Filter1.Operator = setting.Filter1.Operator;
columnFilter.FieldFilter.Filter1.Value = setting.Filter1.Value;
columnFilter.FieldFilter.Filter1.IsCaseSensitive = setting.Filter1.IsCaseSensitive;
}
columnFilter.FieldFilter.LogicalOperator = setting.FieldFilterLogicalOperator;
if (setting.Filter2 != null)
{
columnFilter.FieldFilter.Filter2.Operator = setting.Filter2.Operator;
columnFilter.FieldFilter.Filter2.Value = setting.Filter2.Value;
columnFilter.FieldFilter.Filter2.IsCaseSensitive = setting.Filter2.IsCaseSensitive;
}
}
grid.FilterDescriptors.ResumeNotifications();
}
private void ApplyFilters(String[] statuses, TAB activeTab, string colName, bool resetFilter)
{
GridViewColumn statusColumn = null;
RadGridView radGrid = null;
if (activeTab == TAB.MY_IDEAS)
{
radGrid = myideasGrid;
}
else if (activeTab == TAB.TEAM_IDEAS)
{
radGrid = myteamGrid;
}
else if (activeTab == TAB.FINANCE)
{
radGrid = financeGrid;
}
else if (activeTab == TAB.ADMIN)
{
BindGrid(statuses, resetFilter);
return;
}
if (resetFilter)
{
statusColumn = radGrid.Columns[colName];
IColumnFilterDescriptor columnDescriptor = statusColumn.ColumnFilterDescriptor;
columnDescriptor.SuspendNotifications();
//radGrid.FilterDescriptors.Clear();
columnDescriptor.DistinctFilter.Clear();
foreach (String status in statuses)
{
columnDescriptor.DistinctFilter.AddDistinctValue(status);
}
columnDescriptor.ResumeNotifications();
}
}
private void BindGrid(string[] statuses, bool resetFilters)
{
List <Idea> ideas = new List <Idea>();
ClientContext context = ClientContext.Current;
CamlQuery query = new CamlQuery();
if (statuses.Contains(Consts.LOB1.GBS) && statuses.Contains(Consts.LOB1.HR))
{
query.ViewXml = "<View><Query>" +
"<Where>" +
"<Or>" +
"<Eq>" +
"<FieldRef Name='Line_x0020_Of_x0020_Business_x001' /><Value Type='Choice'>" + Consts.LOB1.GBS + "</Value>" +
"</Eq>" +
"<Eq>" +
"<FieldRef Name='Line_x0020_Of_x0020_Business_x001' /><Value Type='Choice'>" + Consts.LOB1.HR + "</Value>" +
"</Eq>" +
"</Or>" +
"</Where>" +
"</Query></View>";
}
else if (statuses.Contains(Consts.LOB1.GCP))
{
query.ViewXml = "<View><Query>" +
"<Where>" +
"<Eq>" +
"<FieldRef Name='Line_x0020_Of_x0020_Business_x001' /><Value Type='Choice'>" + Consts.LOB1.GCP + "</Value>" +
"</Eq>" +
"</Where>" +
"</Query></View>";
}
else if (statuses.Contains(Consts.LOB1.GBT))
{
query.ViewXml = "<View><Query>" +
"<Where>" +
"<Eq>" +
"<FieldRef Name='Line_x0020_Of_x0020_Business_x001' /><Value Type='Choice'>" + Consts.LOB1.GBT + "</Value>" +
"</Eq>" +
"</Where>" +
"</Query></View>";
}
else if (statuses.Contains(Consts.LOB1.PBMT))
{
query.ViewXml = "<View><Query>" +
"<Where>" +
"<Eq>" +
"<FieldRef Name='Line_x0020_Of_x0020_Business_x001' /><Value Type='Choice'>" + Consts.LOB1.PBMT + "</Value>" +
"</Eq>" +
"</Where>" +
"</Query></View>";
}
else if (statuses.Contains(Consts.LOB1.WSGCAT))
{
query.ViewXml = "<View><Query>" +
"<Where>" +
"<Eq>" +
"<FieldRef Name='Line_x0020_Of_x0020_Business_x001' /><Value Type='Choice'>" + Consts.LOB1.WSGCAT + "</Value>" +
"</Eq>" +
"</Where>" +
"</Query></View>";
}
else
{
query.ViewXml = "<View><Query>" +
"</Query></View>";
}
ListItemCollection returnedItems = context.Web.Lists.GetByTitle("Idea").GetItems(query);
context.Load(returnedItems);
adminGrid.IsBusy = true;
context.ExecuteQueryAsync((ssss, eeeee) =>
{
Dispatcher.BeginInvoke(() =>
{
foreach (var item in returnedItems)
{
ideas.Add(new Idea(item));
}
adminGrid.ItemsSource = ideas;
adminGrid.DataContext = ideas;
if (resetFilters)
{
GridViewColumn statusColumn = adminGrid.Columns[Status.STATUS_COLUMN];
IColumnFilterDescriptor columnDescriptor = statusColumn.ColumnFilterDescriptor;
columnDescriptor.SuspendNotifications();
adminGrid.FilterDescriptors.Clear();
columnDescriptor.DistinctFilter.Clear();
foreach (String status in new String[] { Status.SUBMIT_APPROVAL, Status.PENDING_ACTUALS, Status.FINANCE_REVIEW })
{
columnDescriptor.DistinctFilter.AddDistinctValue(status);
}
columnDescriptor.ResumeNotifications();
}
adminGrid.IsBusy = false;
}
);
},
(ssss, eeeee) =>
{
Console.WriteLine(eeeee.Message);
Dispatcher.BeginInvoke(() =>
{
adminGrid.IsBusy = false;
}
);
});
}
