Class BetweenFilter

Inheritance

System.Object

Filter

ColumnBasedFilter

BetweenFilter

OnFilter

WithinDaysFilter

WithinHoursFilter

YesterdayFilter

Inherited Members

ColumnBasedFilter.GetColumnNameForRender(FCGeneric)

ColumnBasedFilter.ColumnName

Filter.ValidateFilter(FCSession, FCGeneric)

Filter.Render(FCSession, FCGeneric, SqlHelper)

Filter.GetActualDateValue(FCSession, Object)

Filter.ConvertDate(FCSession, DateTime, Boolean)

Filter.ValidateDate(DateTime)

Filter.ValidateValidField(FCGeneric, String)

Filter.ValidateValidField(FCGeneric, String, Boolean)

Filter.ValidateIsIntegerField(FCGeneric, String)

Filter.ValidateIsDecimalField(FCGeneric, String)

Filter.ValidateIsDateField(FCGeneric, String)

Filter.ValidateIsStringField(FCGeneric, String)

Filter.SetParameterValue(FCGeneric, SqlHelper, String, String, Object)

Filter.Session

Filter.Generic

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 BetweenFilter : ColumnBasedFilter

Constructors

BetweenFilter(String, Boolean, DateTime, Filter)

Declaration

protected BetweenFilter(string columnName, bool isBetween, DateTime value1, Filter value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.DateTime	value1
Filter	value2

BetweenFilter(String, Boolean, DateTime, DateTime)

Declaration

protected BetweenFilter(string columnName, bool isBetween, DateTime value1, DateTime value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.DateTime	value1
System.DateTime	value2

BetweenFilter(String, Boolean, Decimal, Filter)

Declaration

protected BetweenFilter(string columnName, bool isBetween, decimal value1, Filter value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.Decimal	value1
Filter	value2

BetweenFilter(String, Boolean, Decimal, Decimal)

Declaration

protected BetweenFilter(string columnName, bool isBetween, decimal value1, decimal value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.Decimal	value1
System.Decimal	value2

BetweenFilter(String, Boolean, Int32, Filter)

Declaration

protected BetweenFilter(string columnName, bool isBetween, int value1, Filter value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.Int32	value1
Filter	value2

BetweenFilter(String, Boolean, Int32, Int32)

Declaration

protected BetweenFilter(string columnName, bool isBetween, int value1, int value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.Int32	value1
System.Int32	value2

BetweenFilter(String, Boolean, Object, Object)

Declaration

protected BetweenFilter(string columnName, bool isBetween, object value1, object value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.Object	value1
System.Object	value2

BetweenFilter(String, Boolean, String, Filter)

Declaration

protected BetweenFilter(string columnName, bool isBetween, string value1, Filter value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.String	value1
Filter	value2

BetweenFilter(String, Boolean, String, String)

Declaration

protected BetweenFilter(string columnName, bool isBetween, string value1, string value2)

Parameters

Type	Name	Description
System.String	columnName
System.Boolean	isBetween
System.String	value1
System.String	value2

Fields

FILTER_BETWEEN

Declaration

protected const string FILTER_BETWEEN = "BETWEEN"

Field Value

Type	Description
System.String

FILTER_NOT_BETWEEN

Declaration

protected const string FILTER_NOT_BETWEEN = "NOT BETWEEN"

Field Value

Type	Description
System.String

Properties

IsBetween

Declaration

public bool IsBetween { get; }

Property Value

Type	Description
System.Boolean

Value1

Declaration

public object Value1 { get; }

Property Value

Type	Description
System.Object

Value1Present

Declaration

public bool Value1Present { get; }

Property Value

Type	Description
System.Boolean

Value2

Declaration

public object Value2 { get; }

Property Value

Type	Description
System.Object

Value2Present

Declaration

public bool Value2Present { get; }

Property Value

Type	Description
System.Boolean

Methods

GetValue1ForRender(FCSession, FCGeneric, SqlHelper)

Declaration

protected virtual object GetValue1ForRender(FCSession sess, FCGeneric gen, SqlHelper dbHelper)

Parameters

Type	Name	Description
FCSession	sess
FCGeneric	gen
SqlHelper	dbHelper

Returns

Type	Description
System.Object

GetValue2ForRender(FCSession, FCGeneric, SqlHelper)

Declaration

protected virtual object GetValue2ForRender(FCSession sess, FCGeneric gen, SqlHelper dbHelper)

Parameters

Type	Name	Description
FCSession	sess
FCGeneric	gen
SqlHelper	dbHelper

Returns

Type	Description
System.Object

PerformRender(FCSession, FCGeneric, SqlHelper)

Declaration

protected override string PerformRender(FCSession sess, FCGeneric gen, SqlHelper dbHelper)

Parameters

Type	Name	Description
FCSession	sess
FCGeneric	gen
SqlHelper	dbHelper

Returns

Type	Description
System.String

Overrides

Filter.PerformRender(FCSession, FCGeneric, SqlHelper)

PerformValidateFilter(FCSession, FCGeneric)

Declaration

protected override void PerformValidateFilter(FCSession session, FCGeneric gen)

Parameters

Type	Name	Description
FCSession	session
FCGeneric	gen

Overrides

Filter.PerformValidateFilter(FCSession, FCGeneric)

ValidateOperand(FCGeneric, Object)

Declaration

protected virtual void ValidateOperand(FCGeneric gen, object value)

Parameters

Type	Name	Description
FCGeneric	gen
System.Object	value