Class SqlFilterDefs

Namespace

Tripous.Data

Assembly

Tripous.Data.dll

A list of filter items.

It can be used to to construct the RowFilter or to construct the WHERE clause of a SELECT statement.

public class SqlFilterDefs : DefList<SqlFilterDef>, IList<SqlFilterDef>, IList, ICollection<SqlFilterDef>, IEnumerable<SqlFilterDef>, ICollection, IEnumerable, INotifyCollectionChanged, INotifyPropertyChanged, IJsonLoadable

Inheritance

object

TripousList<SqlFilterDef>

DefList<SqlFilterDef>

SqlFilterDefs

Implements

IList<SqlFilterDef>

IList

ICollection<SqlFilterDef>

IEnumerable<SqlFilterDef>

ICollection

IEnumerable

INotifyCollectionChanged

INotifyPropertyChanged

IJsonLoadable

Inherited Members

DefList<SqlFilterDef>.CheckAdding(SqlFilterDef)

DefList<SqlFilterDef>.Contains(string)

DefList<SqlFilterDef>.Find(string)

DefList<SqlFilterDef>.Get(string)

DefList<SqlFilterDef>.FindOrdAdd(string)

DefList<SqlFilterDef>.FindOrAddRange(string[])

DefList<SqlFilterDef>.IndexOf(string)

DefList<SqlFilterDef>.InsertBefore(string, SqlFilterDef)

DefList<SqlFilterDef>.InsertAfter(string, SqlFilterDef)

DefList<SqlFilterDef>.CheckDescriptors()

DefList<SqlFilterDef>.UpdateReferences()

DefList<SqlFilterDef>.JsonLoaded()

DefList<SqlFilterDef>.Sort()

DefList<SqlFilterDef>.this[string]

DefList<SqlFilterDef>.ReadOnlyList

DefList<SqlFilterDef>.AllowDuplicateNames

TripousList<SqlFilterDef>.Items

TripousList<SqlFilterDef>.CheckRemoving(SqlFilterDef)

TripousList<SqlFilterDef>.OnCollectionChanged(NotifyCollectionChangedAction, object, int)

TripousList<SqlFilterDef>.OnCollectionChanged(NotifyCollectionChangedAction, object, object, int)

TripousList<SqlFilterDef>.OnCollectionChanged(NotifyCollectionChangedEventArgs)

TripousList<SqlFilterDef>.OnPropertyChanged(string)

TripousList<SqlFilterDef>.Add(SqlFilterDef)

TripousList<SqlFilterDef>.Insert(int, SqlFilterDef)

TripousList<SqlFilterDef>.Remove(SqlFilterDef)

TripousList<SqlFilterDef>.RemoveAt(int)

TripousList<SqlFilterDef>.AddRange(IEnumerable<SqlFilterDef>)

TripousList<SqlFilterDef>.Clear()

TripousList<SqlFilterDef>.IndexOf(SqlFilterDef)

TripousList<SqlFilterDef>.Contains(SqlFilterDef)

TripousList<SqlFilterDef>.CopyTo(SqlFilterDef[], int)

TripousList<SqlFilterDef>.Count

TripousList<SqlFilterDef>.IsReadOnly

TripousList<SqlFilterDef>.this[int]

TripousList<SqlFilterDef>.GetEnumerator()

TripousList<SqlFilterDef>.CollectionChanged

TripousList<SqlFilterDef>.PropertyChanged

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

ListExtensions.Split<T>(IEnumerable<T>, int)

ListExtensions.ToDataTable<T>(IList<T>)

MenuExtensions.AddCheckBoxMenuItem(IList, string)

MenuExtensions.AddCheckBoxMenuItem(IList, string, Action)

MenuExtensions.AddCheckBoxMenuItem(IList, string, bool)

MenuExtensions.AddCheckBoxMenuItem(IList, string, bool, Action)

MenuExtensions.AddCheckBoxMenuItem(IList, string, bool, Action, object)

MenuExtensions.AddCheckBoxMenuItem(IList, string, bool, EventHandler<RoutedEventArgs>)

MenuExtensions.AddCheckBoxMenuItem(IList, string, bool, EventHandler<RoutedEventArgs>, object)

MenuExtensions.AddMenuItem(IList, string)

MenuExtensions.AddMenuItem(IList, string, Action)

MenuExtensions.AddMenuItem(IList, string, Action, object)

MenuExtensions.AddMenuItem(IList, string, EventHandler<RoutedEventArgs>)

MenuExtensions.AddMenuItem(IList, string, EventHandler<RoutedEventArgs>, object)

MenuExtensions.AddSeparator(IList)

ListExtensions.AsArray(IList)

ListExtensions.CanMove(IList, int, bool)

ListExtensions.CanMove(IList, object, bool)

ListExtensions.Exchange(IList, int, int)

ListExtensions.Exchange(IList, object, object)

ListExtensions.IsValidIndex(IList, int)

ListExtensions.LoadFromFile(IList, string)

ListExtensions.Move(IList, int, bool)

ListExtensions.Move(IList, object, bool)

ListExtensions.SaveToFile(IList, string)

TypeExtensions.InheritsFrom(object, Type)

Constructors

SqlFilterDefs()

Constructor

public SqlFilterDefs()

Methods

Add(string, string, DataFieldType, BoolOp, ConditionOp, string)

Adds a new filter definition.

public SqlFilterDef Add(string Name, string FieldName = null, DataFieldType FilterDataType = DataFieldType.String, BoolOp BoolOp = BoolOp.And, ConditionOp ConditionOp = ConditionOp.Equal, string TitleKey = null)

Parameters

Name string

FieldName string

FilterDataType DataFieldType

BoolOp BoolOp

ConditionOp ConditionOp

TitleKey string

Returns

SqlFilterDef

CheckDescriptorsWithValues()

Checks all descriptors with values.

public void CheckDescriptorsWithValues()

GetDataViewRowFilterText()

Formats a filter definition for the RowFilter.

public string GetDataViewRowFilterText()

Returns

string

GetSqlWhereFilterTextInline()

Formats SQL WHERE filter definitions as inline SQL text.

public string GetSqlWhereFilterTextInline()

Returns

string

GetSqlWhereFilterTextParameterized(IDictionary<string, object>)

Formats SQL WHERE filter definitions as parameterized SQL text.

NOTE: The Params should be an empty dictionary. The formatter adds Parameter Names and Values to it.

public string GetSqlWhereFilterTextParameterized(IDictionary<string, object> Params)

Parameters

Params IDictionary<string, object>

Returns

string