//видалити значення фільтра з 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(); }
public void Prepare(Telerik.Windows.Controls.GridViewColumn column) { this.column = column as GridViewBoundColumnBase; if (this.column == null) { return; } if (this.compositeFilter == null) { this.CreateFilters(); } this.fromFilter.Value = this.FromDate; this.toFilter.Value = this.ToDate; }
//вивести всіх працюючих на даний час працівників в 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 ProductWin(int CustomerId) { InitializeComponent(); DataContext = new vmProductLight(); this.RadGridView1.MouseDoubleClick += this.OnGridMouseDoubleClick; textBoxFilterValue.Focus(); this.Left = SystemParameters.PrimaryScreenWidth - this.Width; Telerik.Windows.Controls.GridViewColumn productColumn = this.RadGridView1.Columns["ProductId"]; Telerik.Windows.Controls.GridView.IColumnFilterDescriptor productFilter = productColumn.ColumnFilterDescriptor; //productColumn = this.RadGridView1.Columns["Description"]; //Telerik.Windows.Controls.GridView.IColumnFilterDescriptor productFilter2 = productColumn.ColumnFilterDescriptor; SunSeven.DataSource.JSDataContext lDataContext = new CommonFunction().JSDataContext(); foreach (var l in lDataContext.ProductFiltering(CustomerId)) { productFilter.DistinctFilter.AddDistinctValue(l.productId); // productFilter2.DistinctFilter.AddDistinctValue(l.Description); } }
public void RestoreValue(CustomPropertyInfo customPropertyInfo, object context, object value) { RadGridView gridView = context as RadGridView; switch (customPropertyInfo.Name) { case "Columns": { List <ColumnProxy> columnProxies = value as List <ColumnProxy>; foreach (ColumnProxy proxy in columnProxies) { GridViewColumn column = gridView.Columns[proxy.UniqueName]; column.DisplayIndex = proxy.DisplayOrder; column.Header = proxy.Header; column.Width = proxy.Width; } } break; case "SortDescriptors": { gridView.SortDescriptors.SuspendNotifications(); gridView.SortDescriptors.Clear(); List <SortDescriptorProxy> sortDescriptoProxies = value as List <SortDescriptorProxy>; foreach (SortDescriptorProxy proxy in sortDescriptoProxies) { GridViewColumn column = gridView.Columns[proxy.ColumnUniqueName]; gridView.SortDescriptors.Add(new ColumnSortDescriptor() { Column = column, SortDirection = proxy.SortDirection }); } gridView.SortDescriptors.ResumeNotifications(); } break; case "GroupDescriptors": { gridView.GroupDescriptors.SuspendNotifications(); gridView.GroupDescriptors.Clear(); List <GroupDescriptorProxy> groupDescriptorProxies = value as List <GroupDescriptorProxy>; foreach (GroupDescriptorProxy proxy in groupDescriptorProxies) { GridViewColumn column = gridView.Columns[proxy.ColumnUniqueName]; gridView.GroupDescriptors.Add(new ColumnGroupDescriptor() { Column = column, SortDirection = proxy.SortDirection }); } gridView.GroupDescriptors.ResumeNotifications(); } break; case "FilterDescriptors": { gridView.FilterDescriptors.SuspendNotifications(); foreach (var c in gridView.Columns) { if (c.ColumnFilterDescriptor.IsActive) { c.ClearFilters(); } } List <FilterSetting> filterSettings = value as List <FilterSetting>; foreach (FilterSetting setting in filterSettings) { Telerik.Windows.Controls.GridViewColumn column = gridView.Columns[setting.ColumnUniqueName]; Telerik.Windows.Controls.GridView.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; } } gridView.FilterDescriptors.ResumeNotifications(); } break; } }
public MyFilteringControl(Telerik.Windows.Controls.GridViewColumn column) : base(column) { this.Loaded += MyFilteringControl_Loaded; }
public CustomFilter(Telerik.Windows.Controls.GridViewColumn column, Popup popup) : base(column) { // Apply the line below only when using NoXaml binaries // this.DefaultStyleKey=typeof(MyFilteringControl); FilterPopup = popup; }
public static Telerik.Windows.Controls.GridView.GridViewCellBase GetCell(this Telerik.Windows.Controls.GridView.GridViewRow row, Telerik.Windows.Controls.GridViewColumn column) { if (row != null) { foreach (var cell in row.Cells) { if (cell.Column == column) { return(cell); } } } return(null); }