void ColumnFilterControl_Loaded(object sender, RoutedEventArgs e) { DataGridColumn column = null; DataGridColumnHeader colHeader = null; UIElement parent = (UIElement)VisualTreeHelper.GetParent(this); while (parent != null) { parent = (UIElement)VisualTreeHelper.GetParent(parent); if (colHeader == null) { colHeader = parent as DataGridColumnHeader; } if (Grid == null) { Grid = parent as DataGridExtend; } } if (colHeader != null) { column = colHeader.Column; } CanUserFreeze = Grid.CanUserFreeze; CanUserGroup = Grid.CanUserGroup; CanUserSelectDistinct = Grid.CanUserSelectDistinct; FilterColumnInfo = new OptionColumnInfo(column, Grid); if (column != null) { object oCanUserFreeze = column.GetValue(ColumnConfiguration.CanUserFreezeProperty); if (oCanUserFreeze != null) { CanUserFreeze = (bool)oCanUserFreeze; Grid.FreezeColumn(FilterColumnInfo.Column); } object oCanUserGroup = column.GetValue(ColumnConfiguration.CanUserGroupProperty); if (oCanUserGroup != null) { CanUserGroup = (bool)oCanUserGroup; if (!string.IsNullOrWhiteSpace(FilterColumnInfo.PropertyPath)) { Grid.AddGroup(FilterColumnInfo.PropertyPath); } } object oCanUserSelectDistinct = column.GetValue(ColumnConfiguration.CanUserSelectDistinctProperty); if (oCanUserSelectDistinct != null) { CanUserSelectDistinct = (bool)oCanUserSelectDistinct; } } if (Grid.FilterType == null) { return; } Grid.RegisterOptionControl(this); FilterOperations.Clear(); if (FilterColumnInfo.PropertyType != null) { if (TypeHelper.IsNumbericType(FilterColumnInfo.PropertyType) && TypeHelper.IsStringType(FilterColumnInfo.PropertyConvertType)) { FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.Equals, "=", "/Jib.WPF.Controls;component/Images/Equal.png")); CalcControlVisibility(ColumnType.ConvertString); } else { if (TypeHelper.IsStringType(FilterColumnInfo.PropertyType) || TypeHelper.IsStringType(FilterColumnInfo.PropertyConvertType)) { FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.Contains, "Contains", "/Jib.WPF.Controls;component/Images/Contains.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.StartsWith, "Starts With", "/Jib.WPF.Controls;component/Images/StartsWith.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.EndsWith, "Ends With", "/Jib.WPF.Controls;component/Images/EndsWith.png")); CalcControlVisibility(ColumnType.String); } FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.Equals, "=", "/Jib.WPF.Controls;component/Images/Equal.png")); if (TypeHelper.IsNumbericType(FilterColumnInfo.PropertyType)) { FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.GreaterThan, ">", "/Jib.WPF.Controls;component/Images/GreaterThan.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.GreaterThanEqual, ">=", "/Jib.WPF.Controls;component/Images/GreaterThanEqual.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.LessThan, "<", "/Jib.WPF.Controls;component/Images/LessThan.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.LessThanEqual, "<=", "/Jib.WPF.Controls;component/Images/GreaterThanEqual.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.NotEquals, "!=", "/Jib.WPF.Controls;component/Images/NotEqual.png")); CalcControlVisibility(ColumnType.Num); } if (TypeHelper.IsBoolType(FilterColumnInfo.PropertyType) || TypeHelper.IsBoolType(FilterColumnInfo.PropertyConvertType)) { CalcControlVisibility(ColumnType.Bool); } if (TypeHelper.IsDateTimeType(FilterColumnInfo.PropertyType)) { FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.GreaterThan, ">", "/Jib.WPF.Controls;component/Images/GreaterThan.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.GreaterThanEqual, ">=", "/Jib.WPF.Controls;component/Images/GreaterThanEqual.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.LessThan, "<", "/Jib.WPF.Controls;component/Images/LessThan.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.LessThanEqual, "<=", "/Jib.WPF.Controls;component/Images/GreaterThanEqual.png")); FilterOperations.Add(new FilterOperationItem(Enums.FilterOperation.NotEquals, "!=", "/Jib.WPF.Controls;component/Images/NotEqual.png")); CalcControlVisibility(ColumnType.Date); } } if (FilterOperations.Count > 0) { SelectedFilterOperation = FilterOperations[0]; } } if (FilterColumnInfo != null && FilterColumnInfo.IsValid) { foreach (var i in DistinctPropertyValues.Where(i => i.IsChecked)) { i.IsChecked = false; } DistinctPropertyValues.Clear(); FilterText = string.Empty; _boundColumnPropertyAccessor = null; if (!string.IsNullOrWhiteSpace(FilterColumnInfo.PropertyPath)) { if (FilterColumnInfo.PropertyPath.Contains('.')) { throw new ArgumentException(string.Format("This version of the grid does not support a nested property path such as '{0}'. Please make a first-level property for filtering and bind to that.", FilterColumnInfo.PropertyPath)); } this.Visibility = System.Windows.Visibility.Visible; ParameterExpression arg = System.Linq.Expressions.Expression.Parameter(typeof(object), "x"); System.Linq.Expressions.Expression expr = System.Linq.Expressions.Expression.Convert(arg, Grid.FilterType); expr = System.Linq.Expressions.Expression.Property(expr, Grid.FilterType, FilterColumnInfo.PropertyPath); System.Linq.Expressions.Expression conversion = System.Linq.Expressions.Expression.Convert(expr, typeof(object)); _boundColumnPropertyAccessor = System.Linq.Expressions.Expression.Lambda <Func <object, object> >(conversion, arg).Compile(); if (_boundColumnPropertyAccessor != null) { if (DistinctPropertyValues.Count == 0) { //List<object> result = new List<object>(); //foreach (var i in Grid.ItemsSource) //{ // object value = _boundColumnPropertyAccessor(i); // if (value != null) // { // if (result.Where(o => o.ToString() == value.ToString()).Count() == 0) // result.Add(value); // } // else if (FilterColumnInfo.PropertyType == typeof(bool?) && FilterColumnInfo.IsSpecialState) // { // if (result.Where(o => o == value).Count() == 0) // result.Add(value); // } //} //try //{ // result.Sort(); //} //catch //{ // if (System.Diagnostics.Debugger.IsLogging()) // System.Diagnostics.Debugger.Log(0, "Warning", "There is no default compare set for the object type"); //} //if (result.Count > 0) //{ // StringBuilder sb = new StringBuilder(); // foreach (var obj in result) // { // var item = new CheckboxComboItem() // { // Description = GetFormattedValue(obj), // Tag = obj, // IsChecked = true // }; // item.PropertyChanged += new PropertyChangedEventHandler(filter_PropertyChanged); // DistinctPropertyValues.Add(item); // sb.AppendFormat("{0}{1}", sb.Length > 0 ? "," : "",item.Description ); // } // FilterText = sb.ToString(); //} //else //{ // FilterText = string.Empty; //} } } } else { this.Visibility = System.Windows.Visibility.Collapsed; } object oDefaultFilter = column.GetValue(ColumnConfiguration.DefaultFilterProperty); if (oDefaultFilter != null) { FilterText = (string)oDefaultFilter; } } }
protected Predicate <object> GenerateFilterPredicate(string propertyName, string filterValue, Type objType, Type propType, FilterOperationItem filterItem) { ParameterExpression objParam = System.Linq.Expressions.Expression.Parameter(typeof(object), "x"); UnaryExpression param = System.Linq.Expressions.Expression.TypeAs(objParam, objType); var prop = System.Linq.Expressions.Expression.Property(param, propertyName); var val = System.Linq.Expressions.Expression.Constant(filterValue); switch (filterItem.FilterOption) { case Enums.FilterOperation.Contains: return(ExpressionHelper.GenerateGeneric(prop, val, propType, objParam, "Contains")); case Enums.FilterOperation.EndsWith: return(ExpressionHelper.GenerateGeneric(prop, val, propType, objParam, "EndsWith")); case Enums.FilterOperation.StartsWith: return(ExpressionHelper.GenerateGeneric(prop, val, propType, objParam, "StartsWith")); case Enums.FilterOperation.Equals: DateTime dtEquals = new DateTime(); if (DateTime.TryParse(filterValue, out dtEquals)) { return(ExpressionHelper.GenerateEquals(prop, dtEquals, propType, objParam)); } else { if (propertyName == "DebitCreditDirection" && (filterValue != "1" && filterValue != "-1" && filterValue != "0")) { return(new Predicate <object>((p) => { return false; })); } else { return(ExpressionHelper.GenerateEquals(prop, filterValue, propType, objParam)); } } case Enums.FilterOperation.NotEquals: DateTime dtNotEquals = new DateTime(); if (DateTime.TryParse(filterValue, out dtNotEquals)) { return(ExpressionHelper.GenerateNotEquals(prop, dtNotEquals, propType, objParam)); } else { return(ExpressionHelper.GenerateNotEquals(prop, filterValue, propType, objParam)); } case Enums.FilterOperation.GreaterThanEqual: DateTime dtGreaterThanEqual = new DateTime(); if (DateTime.TryParse(filterValue, out dtGreaterThanEqual)) { return(ExpressionHelper.GenerateGreaterThanEqual(prop, dtGreaterThanEqual, propType, objParam)); } else { return(ExpressionHelper.GenerateGreaterThanEqual(prop, filterValue, propType, objParam)); } case Enums.FilterOperation.LessThanEqual: DateTime dtLessThanEqual = new DateTime(); if (DateTime.TryParse(filterValue, out dtLessThanEqual)) { return(ExpressionHelper.GenerateLessThanEqual(prop, dtLessThanEqual, propType, objParam)); } else { return(ExpressionHelper.GenerateLessThanEqual(prop, filterValue, propType, objParam)); } case Enums.FilterOperation.GreaterThan: DateTime dtGreaterThan = new DateTime(); if (DateTime.TryParse(filterValue, out dtGreaterThan)) { return(ExpressionHelper.GenerateGreaterThan(prop, dtGreaterThan, propType, objParam)); } else { return(ExpressionHelper.GenerateGreaterThan(prop, filterValue, propType, objParam)); } case Enums.FilterOperation.LessThan: DateTime dtLessThan = new DateTime(); if (DateTime.TryParse(filterValue, out dtLessThan)) { return(ExpressionHelper.GenerateLessThan(prop, dtLessThan, propType, objParam)); } else { return(ExpressionHelper.GenerateLessThan(prop, filterValue, propType, objParam)); } default: throw new ArgumentException("Could not decode Search Mode. Did you add a new value to the enum, or send in Unknown?"); } }
protected Predicate <object> GenerateFilterPredicate(string propertyName, string filterValue, Type objType, Type propType, FilterOperationItem filterItem) { ParameterExpression objParam = System.Linq.Expressions.Expression.Parameter(typeof(object), "x"); UnaryExpression param = System.Linq.Expressions.Expression.TypeAs(objParam, objType); var prop = System.Linq.Expressions.Expression.Property(param, propertyName); var val = System.Linq.Expressions.Expression.Constant(filterValue); switch (filterItem.FilterOption) { case Enums.FilterOperation.Contains: return(ExpressionHelper.GenerateGeneric(prop, val, propType, objParam, "Contains")); default: throw new ArgumentException("Could not decode Search Mode. Did you add a new value to the enum, or send in Unknown?"); } }