C# Класс DotNetNuke.Extensions.Data.Filter

Наследование: IFilter
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
And ( ) : Filter
ContainsString ( string columnName, string subString ) : Filter
ContainsStringWithinCommaSeparatedValues ( string columnName, string csvValue ) : Filter
CreateEmpty ( ) : Filter

Gets an empty query.
EqualTo ( string columnName, object equalTo ) : Filter

Extends the Query (using the AND operator) such that only rows with values equal to that specified in the named column should be included.
Equals ( object obj ) : bool
Filter ( ) : System

Constructs a new, empty, query.
GetExpressionString ( ) : string

Returns the where clause without the leading 'Where' command. To access the statement with a where command, use ToString().
GetHashCode ( ) : int
GreaterThan ( string columnName, object greaterThan ) : Filter

Extends the Query (using the AND operator) such that only rows with values greater than that specified in the named column should be included.
GreaterThanOrEqualTo ( string columnName, object greaterThanOrEqualTo ) : Filter

Extends the Query (using the AND operator) such that only rows with values greater than or equal to that specified in the named column should be included.
IsNotNull ( string columnName ) : Filter
IsNull ( string columnName ) : Filter
LessThan ( string columnName, object lessThan ) : Filter

Extends the Query (using the AND operator) such that only rows with values less than that specified in the named column should be included.
LessThanOrEqualTo ( string columnName, object lessThanOrEqualTo ) : Filter

Extends the Query (using the AND operator) such that only rows with values less than or equal to that specified in the named column should be included.
Like ( string columnName, string likePattern ) : Filter

Performs wildcard string matching upon the specified column.
NotEqualTo ( string columnName, object notEqualTo ) : Filter

Extends the Query (using the AND operator) such that only rows with values not equal to that specified in the named column should be included.
Or ( ) : Filter

Adds the specified sub-query using the OR logical operator.
OrContainsString ( string columnName, string subString ) : Filter
OrContainsStringWithinCommaSeparatedValues ( string columnName, string csvValue ) : Filter
OrEqualTo ( string columnName, object equalTo ) : Filter
OrGreaterThan ( string columnName, object greaterThan ) : Filter
OrGreaterThanOrEqualTo ( string columnName, object greaterThanOrEqualTo ) : Filter
OrIsNotNull ( string columnName ) : Filter
OrIsNull ( string columnName ) : Filter
OrLessThan ( string columnName, object lessThan ) : Filter
OrLessThanOrEqualTo ( string columnName, object lessThanOrEqualTo ) : Filter
OrLike ( string columnName, string likePattern ) : Filter
OrNotEqualTo ( string columnName, object notEqualTo ) : Filter
OrStartsWithString ( string columnName, string prefix ) : Filter
StartsWithString ( string columnName, string prefix ) : Filter
ToString ( ) : string

Returns the query's expression as a SQL string, prefixed with the 'Where' command. For example, Where Column1='Value1'.

Приватные методы

Метод Описание
And ( ConditionNode newCondition ) : Filter
CreateContainsStringCondition ( string subString, string columnName ) : ConditionNode
CreateContainsStringWithinCommaSeparatedValuesCondition ( string columnName, string csvValue ) : ConditionNode
CreateEqualToCondition ( string columnName, object equalTo ) : ConditionNode
CreateGreaterThanCondition ( string columnName, object greaterThan ) : ConditionNode
CreateGreaterThanOrEqualToCondition ( string columnName, object greaterThanOrEqualTo ) : ConditionNode
CreateIsNotNullCondition ( string columnName ) : ConditionNode
CreateIsNullCondition ( string columnName ) : ConditionNode
CreateLessThanCondition ( string columnName, object lessThan ) : ConditionNode
CreateLessThanOrEqualToCondition ( string columnName, object lessThanOrEqualTo ) : ConditionNode
CreateLikeCondition ( string columnName, string likePattern ) : ConditionNode
CreateNotEqualToCondition ( string columnName, object notEqualTo ) : ConditionNode
CreateStartsWithStringCondition ( string prefix, string columnName ) : ConditionNode
MergeConditionIntoTree ( LogicalOperator desiredLogicalOperator, ConditionNode newCondition ) : void
Or ( ConditionNode newCondition ) : Filter

Описание методов

And() публичный Метод

public And ( ) : Filter
Результат Filter

ContainsString() публичный Метод

public ContainsString ( string columnName, string subString ) : Filter
columnName string
subString string
Результат Filter

ContainsStringWithinCommaSeparatedValues() публичный Метод

public ContainsStringWithinCommaSeparatedValues ( string columnName, string csvValue ) : Filter
columnName string
csvValue string
Результат Filter

CreateEmpty() публичный статический Метод

Gets an empty query.
public static CreateEmpty ( ) : Filter
Результат Filter

EqualTo() публичный Метод

Extends the Query (using the AND operator) such that only rows with values equal to that specified in the named column should be included.
public EqualTo ( string columnName, object equalTo ) : Filter
columnName string The column to filter within.
equalTo object
Результат Filter

Equals() публичный Метод

public Equals ( object obj ) : bool
obj object
Результат bool

Filter() публичный Метод

Constructs a new, empty, query.
public Filter ( ) : System
Результат System

GetExpressionString() публичный Метод

Returns the where clause without the leading 'Where' command. To access the statement with a where command, use ToString().
public GetExpressionString ( ) : string
Результат string

GetHashCode() публичный Метод

public GetHashCode ( ) : int
Результат int

GreaterThan() публичный Метод

Extends the Query (using the AND operator) such that only rows with values greater than that specified in the named column should be included.
public GreaterThan ( string columnName, object greaterThan ) : Filter
columnName string The column to filter within.
greaterThan object
Результат Filter

GreaterThanOrEqualTo() публичный Метод

Extends the Query (using the AND operator) such that only rows with values greater than or equal to that specified in the named column should be included.
public GreaterThanOrEqualTo ( string columnName, object greaterThanOrEqualTo ) : Filter
columnName string The column to filter within.
greaterThanOrEqualTo object
Результат Filter

IsNotNull() публичный Метод

public IsNotNull ( string columnName ) : Filter
columnName string
Результат Filter

IsNull() публичный Метод

public IsNull ( string columnName ) : Filter
columnName string
Результат Filter

LessThan() публичный Метод

Extends the Query (using the AND operator) such that only rows with values less than that specified in the named column should be included.
public LessThan ( string columnName, object lessThan ) : Filter
columnName string The column to filter within.
lessThan object The value that remaining rows must be less than.
Результат Filter

LessThanOrEqualTo() публичный Метод

Extends the Query (using the AND operator) such that only rows with values less than or equal to that specified in the named column should be included.
public LessThanOrEqualTo ( string columnName, object lessThanOrEqualTo ) : Filter
columnName string The column to filter within.
lessThanOrEqualTo object The value that remaining rows must be less than or equal to.
Результат Filter

Like() публичный Метод

Performs wildcard string matching upon the specified column.
public Like ( string columnName, string likePattern ) : Filter
columnName string The column to match within.
likePattern string The wildcard expression. Patterns commonly use the % symbol as a wildcard.
Результат Filter

NotEqualTo() публичный Метод

Extends the Query (using the AND operator) such that only rows with values not equal to that specified in the named column should be included.
public NotEqualTo ( string columnName, object notEqualTo ) : Filter
columnName string The column to filter within.
notEqualTo object
Результат Filter

Or() публичный Метод

Adds the specified sub-query using the OR logical operator.
public Or ( ) : Filter
Результат Filter

OrContainsString() публичный Метод

public OrContainsString ( string columnName, string subString ) : Filter
columnName string
subString string
Результат Filter

OrContainsStringWithinCommaSeparatedValues() публичный Метод

public OrContainsStringWithinCommaSeparatedValues ( string columnName, string csvValue ) : Filter
columnName string
csvValue string
Результат Filter

OrEqualTo() публичный Метод

public OrEqualTo ( string columnName, object equalTo ) : Filter
columnName string
equalTo object
Результат Filter

OrGreaterThan() публичный Метод

public OrGreaterThan ( string columnName, object greaterThan ) : Filter
columnName string
greaterThan object
Результат Filter

OrGreaterThanOrEqualTo() публичный Метод

public OrGreaterThanOrEqualTo ( string columnName, object greaterThanOrEqualTo ) : Filter
columnName string
greaterThanOrEqualTo object
Результат Filter

OrIsNotNull() публичный Метод

public OrIsNotNull ( string columnName ) : Filter
columnName string
Результат Filter

OrIsNull() публичный Метод

public OrIsNull ( string columnName ) : Filter
columnName string
Результат Filter

OrLessThan() публичный Метод

public OrLessThan ( string columnName, object lessThan ) : Filter
columnName string
lessThan object
Результат Filter

OrLessThanOrEqualTo() публичный Метод

public OrLessThanOrEqualTo ( string columnName, object lessThanOrEqualTo ) : Filter
columnName string
lessThanOrEqualTo object
Результат Filter

OrLike() публичный Метод

public OrLike ( string columnName, string likePattern ) : Filter
columnName string
likePattern string
Результат Filter

OrNotEqualTo() публичный Метод

public OrNotEqualTo ( string columnName, object notEqualTo ) : Filter
columnName string
notEqualTo object
Результат Filter

OrStartsWithString() публичный Метод

public OrStartsWithString ( string columnName, string prefix ) : Filter
columnName string
prefix string
Результат Filter

StartsWithString() публичный Метод

public StartsWithString ( string columnName, string prefix ) : Filter
columnName string
prefix string
Результат Filter

ToString() публичный Метод

Returns the query's expression as a SQL string, prefixed with the 'Where' command. For example, Where Column1='Value1'.
public ToString ( ) : string
Результат string