C# Class DotNetNuke.Extensions.Data.Filter

Inheritance: IFilter

Afficher le fichier Open project: JonHaywood/DotNetNuke.Extensions Class Usage Examples

Méthodes publiques

Méthode	Description
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'`.

Private Methods

Méthode	Description
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

Method Details

And() public méthode

public And ( ) : Filter
Résultat	Filter

ContainsString() public méthode

public ContainsString ( string columnName, string subString ) : Filter
columnName	string
subString	string
Résultat	Filter

ContainsStringWithinCommaSeparatedValues() public méthode

public ContainsStringWithinCommaSeparatedValues ( string columnName, string csvValue ) : Filter
columnName	string
csvValue	string
Résultat	Filter

CreateEmpty() public static méthode

Gets an empty query.

public static CreateEmpty ( ) : Filter
Résultat	Filter

EqualTo() public méthode

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
Résultat	Filter

Equals() public méthode

public Equals ( object obj ) : bool
obj	object
Résultat	bool

Filter() public méthode

Constructs a new, empty, query.

public Filter ( ) : System
Résultat	System

GetExpressionString() public méthode

Returns the where clause without the leading 'Where' command. To access the statement with a where command, use ToString().

public GetExpressionString ( ) : string
Résultat	string

GetHashCode() public méthode

public GetHashCode ( ) : int
Résultat	int

GreaterThan() public méthode

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
Résultat	Filter

GreaterThanOrEqualTo() public méthode

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
Résultat	Filter

IsNotNull() public méthode

public IsNotNull ( string columnName ) : Filter
columnName	string
Résultat	Filter

IsNull() public méthode

public IsNull ( string columnName ) : Filter
columnName	string
Résultat	Filter

LessThan() public méthode

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.
Résultat	Filter

LessThanOrEqualTo() public méthode

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.
Résultat	Filter

Like() public méthode

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.
Résultat	Filter

NotEqualTo() public méthode

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
Résultat	Filter

Or() public méthode

Adds the specified sub-query using the OR logical operator.

public Or ( ) : Filter
Résultat	Filter

OrContainsString() public méthode

public OrContainsString ( string columnName, string subString ) : Filter
columnName	string
subString	string
Résultat	Filter

OrContainsStringWithinCommaSeparatedValues() public méthode

public OrContainsStringWithinCommaSeparatedValues ( string columnName, string csvValue ) : Filter
columnName	string
csvValue	string
Résultat	Filter

OrEqualTo() public méthode

public OrEqualTo ( string columnName, object equalTo ) : Filter
columnName	string
equalTo	object
Résultat	Filter

OrGreaterThan() public méthode

public OrGreaterThan ( string columnName, object greaterThan ) : Filter
columnName	string
greaterThan	object
Résultat	Filter

OrGreaterThanOrEqualTo() public méthode

public OrGreaterThanOrEqualTo ( string columnName, object greaterThanOrEqualTo ) : Filter
columnName	string
greaterThanOrEqualTo	object
Résultat	Filter

OrIsNotNull() public méthode

public OrIsNotNull ( string columnName ) : Filter
columnName	string
Résultat	Filter

OrIsNull() public méthode

public OrIsNull ( string columnName ) : Filter
columnName	string
Résultat	Filter

OrLessThan() public méthode

public OrLessThan ( string columnName, object lessThan ) : Filter
columnName	string
lessThan	object
Résultat	Filter

OrLessThanOrEqualTo() public méthode

public OrLessThanOrEqualTo ( string columnName, object lessThanOrEqualTo ) : Filter
columnName	string
lessThanOrEqualTo	object
Résultat	Filter

OrLike() public méthode

public OrLike ( string columnName, string likePattern ) : Filter
columnName	string
likePattern	string
Résultat	Filter

OrNotEqualTo() public méthode

public OrNotEqualTo ( string columnName, object notEqualTo ) : Filter
columnName	string
notEqualTo	object
Résultat	Filter

OrStartsWithString() public méthode

public OrStartsWithString ( string columnName, string prefix ) : Filter
columnName	string
prefix	string
Résultat	Filter

StartsWithString() public méthode

public StartsWithString ( string columnName, string prefix ) : Filter
columnName	string
prefix	string
Résultat	Filter

ToString() public méthode

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

public ToString ( ) : string
Résultat	string