Class FilterExpression

Inheritance
System.Object
FilterExpression
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: FChoice.Foundation.Filters
Assembly: fcSDK.dll
Syntax
public class FilterExpression

Constructors

FilterExpression()

Declaration
public FilterExpression()

Methods

After(String, DateTime)

Declaration
public AfterFilter After(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
AfterFilter

And(Filter, Filter)

Declaration
public AndFilter And(Filter filter1, Filter filter2)
Parameters
Type Name Description
Filter filter1
Filter filter2
Returns
Type Description
AndFilter

And(Filter[])

Declaration
public AndManyFilter And(params Filter[] filters)
Parameters
Type Name Description
Filter[] filters
Returns
Type Description
AndManyFilter

Before(String, DateTime)

Declaration
public BeforeFilter Before(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
BeforeFilter

Between(String, DateTime, DateTime)

Declaration
public BetweenFilter Between(string columnName, DateTime value1, DateTime value2)
Parameters
Type Name Description
System.String columnName
System.DateTime value1
System.DateTime value2
Returns
Type Description
BetweenFilter

Between(String, Decimal, Decimal)

Declaration
public BetweenFilter Between(string columnName, decimal value1, decimal value2)
Parameters
Type Name Description
System.String columnName
System.Decimal value1
System.Decimal value2
Returns
Type Description
BetweenFilter

Between(String, Int32, Int32)

Declaration
public BetweenFilter Between(string columnName, int value1, int value2)
Parameters
Type Name Description
System.String columnName
System.Int32 value1
System.Int32 value2
Returns
Type Description
BetweenFilter

Between(String, String, String)

Declaration
public BetweenFilter Between(string columnName, string value1, string value2)
Parameters
Type Name Description
System.String columnName
System.String value1
System.String value2
Returns
Type Description
BetweenFilter

Contains(String, String)

Declaration
public ContainsFilter Contains(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
ContainsFilter

EndsWith(String, String)

Declaration
public EndsWithFilter EndsWith(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
EndsWithFilter

Equals(String, Boolean)

Declaration
public EqualsFilter Equals(string columnName, bool value)
Parameters
Type Name Description
System.String columnName
System.Boolean value
Returns
Type Description
EqualsFilter

Equals(String, DateTime)

Declaration
public EqualsFilter Equals(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
EqualsFilter

Equals(String, Decimal)

Declaration
public EqualsFilter Equals(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
EqualsFilter

Equals(String, Int32)

Declaration
public EqualsFilter Equals(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
EqualsFilter

Equals(String, String)

Declaration
public EqualsFilter Equals(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
EqualsFilter

IsIn(String, DateTime[])

Declaration
public IsInFilter IsIn(string columnName, params DateTime[] values)
Parameters
Type Name Description
System.String columnName
System.DateTime[] values
Returns
Type Description
IsInFilter

IsIn(String, Decimal[])

Declaration
public IsInFilter IsIn(string columnName, params decimal[] values)
Parameters
Type Name Description
System.String columnName
System.Decimal[] values
Returns
Type Description
IsInFilter

IsIn(String, Int32[])

Declaration
public IsInFilter IsIn(string columnName, params int[] values)
Parameters
Type Name Description
System.String columnName
System.Int32[] values
Returns
Type Description
IsInFilter

IsIn(String, String[])

Declaration
public IsInFilter IsIn(string columnName, params string[] values)
Parameters
Type Name Description
System.String columnName
System.String[] values
Returns
Type Description
IsInFilter

IsNotIn(String, DateTime[])

Declaration
public IsInFilter IsNotIn(string columnName, params DateTime[] values)
Parameters
Type Name Description
System.String columnName
System.DateTime[] values
Returns
Type Description
IsInFilter

IsNotIn(String, Decimal[])

Declaration
public IsInFilter IsNotIn(string columnName, params decimal[] values)
Parameters
Type Name Description
System.String columnName
System.Decimal[] values
Returns
Type Description
IsInFilter

IsNotIn(String, Int32[])

Declaration
public IsInFilter IsNotIn(string columnName, params int[] values)
Parameters
Type Name Description
System.String columnName
System.Int32[] values
Returns
Type Description
IsInFilter

IsNotIn(String, String[])

Declaration
public IsInFilter IsNotIn(string columnName, params string[] values)
Parameters
Type Name Description
System.String columnName
System.String[] values
Returns
Type Description
IsInFilter

IsNotNull(String)

Declaration
public IsNullFilter IsNotNull(string columnName)
Parameters
Type Name Description
System.String columnName
Returns
Type Description
IsNullFilter

IsNull(String)

Declaration
public IsNullFilter IsNull(string columnName)
Parameters
Type Name Description
System.String columnName
Returns
Type Description
IsNullFilter

LessThan(String, DateTime)

Declaration
public LessThanFilter LessThan(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
LessThanFilter

LessThan(String, Decimal)

Declaration
public LessThanFilter LessThan(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
LessThanFilter

LessThan(String, Int32)

Declaration
public LessThanFilter LessThan(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
LessThanFilter

LessThan(String, String)

Declaration
public LessThanFilter LessThan(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
LessThanFilter

LessThanOrEqual(String, DateTime)

Declaration
public Filter LessThanOrEqual(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
Filter

LessThanOrEqual(String, Decimal)

Declaration
public LessThanOrEqualFilter LessThanOrEqual(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
LessThanOrEqualFilter

LessThanOrEqual(String, Int32)

Declaration
public LessThanOrEqualFilter LessThanOrEqual(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
LessThanOrEqualFilter

LessThanOrEqual(String, String)

Declaration
public Filter LessThanOrEqual(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
Filter

Like(String, String)

Declaration
public LikeFilter Like(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
LikeFilter

MoreThan(String, DateTime)

Declaration
public MoreThanFilter MoreThan(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
MoreThanFilter

MoreThan(String, Decimal)

Declaration
public MoreThanFilter MoreThan(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
MoreThanFilter

MoreThan(String, Int32)

Declaration
public MoreThanFilter MoreThan(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
MoreThanFilter

MoreThan(String, String)

Declaration
public MoreThanFilter MoreThan(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
MoreThanFilter

MoreThanOrEqual(String, DateTime)

Declaration
public MoreThanOrEqualFilter MoreThanOrEqual(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
MoreThanOrEqualFilter

MoreThanOrEqual(String, Decimal)

Declaration
public MoreThanOrEqualFilter MoreThanOrEqual(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
MoreThanOrEqualFilter

MoreThanOrEqual(String, Int32)

Declaration
public MoreThanOrEqualFilter MoreThanOrEqual(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
MoreThanOrEqualFilter

MoreThanOrEqual(String, String)

Declaration
public MoreThanOrEqualFilter MoreThanOrEqual(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
MoreThanOrEqualFilter

NotBetween(String, DateTime, DateTime)

Declaration
public BetweenFilter NotBetween(string columnName, DateTime value1, DateTime value2)
Parameters
Type Name Description
System.String columnName
System.DateTime value1
System.DateTime value2
Returns
Type Description
BetweenFilter

NotBetween(String, Decimal, Decimal)

Declaration
public BetweenFilter NotBetween(string columnName, decimal value1, decimal value2)
Parameters
Type Name Description
System.String columnName
System.Decimal value1
System.Decimal value2
Returns
Type Description
BetweenFilter

NotBetween(String, Int32, Int32)

Declaration
public BetweenFilter NotBetween(string columnName, int value1, int value2)
Parameters
Type Name Description
System.String columnName
System.Int32 value1
System.Int32 value2
Returns
Type Description
BetweenFilter

NotBetween(String, String, String)

Declaration
public BetweenFilter NotBetween(string columnName, string value1, string value2)
Parameters
Type Name Description
System.String columnName
System.String value1
System.String value2
Returns
Type Description
BetweenFilter

NotContains(String, String)

Declaration
public NotContainsFilter NotContains(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
NotContainsFilter

NotEndsWith(String, String)

Declaration
public NotEndsWithFilter NotEndsWith(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
NotEndsWithFilter

NotEqual(String, Boolean)

Declaration
public EqualsFilter NotEqual(string columnName, bool value)
Parameters
Type Name Description
System.String columnName
System.Boolean value
Returns
Type Description
EqualsFilter

NotEqual(String, DateTime)

Declaration
public Filter NotEqual(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
Filter

NotEqual(String, Decimal)

Declaration
public Filter NotEqual(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
Filter

NotEqual(String, Int32)

Declaration
public EqualsFilter NotEqual(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
EqualsFilter

NotEqual(String, String)

Declaration
public Filter NotEqual(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
Filter

NotLike(String, String)

Declaration
public NotLikeFilter NotLike(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
NotLikeFilter

NotStartsWith(String, String)

Declaration
public NotStartsWithFilter NotStartsWith(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
NotStartsWithFilter

OlderThanDays(String, Decimal)

Declaration
public OlderThanDaysFilter OlderThanDays(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
OlderThanDaysFilter

OlderThanDays(String, Int32)

Declaration
public OlderThanDaysFilter OlderThanDays(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
OlderThanDaysFilter

OlderThanHours(String, Decimal)

Declaration
public OlderThanHoursFilter OlderThanHours(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
OlderThanHoursFilter

OlderThanHours(String, Int32)

Declaration
public OlderThanHoursFilter OlderThanHours(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
OlderThanHoursFilter

On(String, DateTime)

Declaration
public OnFilter On(string columnName, DateTime value)
Parameters
Type Name Description
System.String columnName
System.DateTime value
Returns
Type Description
OnFilter

Or(Filter, Filter)

Declaration
public OrFilter Or(Filter filter1, Filter filter2)
Parameters
Type Name Description
Filter filter1
Filter filter2
Returns
Type Description
OrFilter

Or(Filter[])

Declaration
public OrManyFilter Or(params Filter[] filters)
Parameters
Type Name Description
Filter[] filters
Returns
Type Description
OrManyFilter

SoundsLike(String, String)

Declaration
public SoundsLikeFilter SoundsLike(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
SoundsLikeFilter

StartsWith(String, String)

Declaration
public StartsWithFilter StartsWith(string columnName, string value)
Parameters
Type Name Description
System.String columnName
System.String value
Returns
Type Description
StartsWithFilter

Today(String)

Declaration
public TodayFilter Today(string columnName)
Parameters
Type Name Description
System.String columnName
Returns
Type Description
TodayFilter

Tomorrow(String)

Declaration
public TomorrowFilter Tomorrow(string columnName)
Parameters
Type Name Description
System.String columnName
Returns
Type Description
TomorrowFilter

WithinDays(String, Decimal)

Declaration
public WithinDaysFilter WithinDays(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
WithinDaysFilter

WithinDays(String, Int32)

Declaration
public WithinDaysFilter WithinDays(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
WithinDaysFilter

WithinHours(String, Decimal)

Declaration
public WithinHoursFilter WithinHours(string columnName, decimal value)
Parameters
Type Name Description
System.String columnName
System.Decimal value
Returns
Type Description
WithinHoursFilter

WithinHours(String, Int32)

Declaration
public WithinHoursFilter WithinHours(string columnName, int value)
Parameters
Type Name Description
System.String columnName
System.Int32 value
Returns
Type Description
WithinHoursFilter

Yesterday(String)

Declaration
public YesterdayFilter Yesterday(string columnName)
Parameters
Type Name Description
System.String columnName
Returns
Type Description
YesterdayFilter