• 홈
• DotNetNuke
• Extensions
• Data
• Filter

C# 클래스 DotNetNuke.Extensions.Data.Filter

파일 보기 프로젝트 열기: JonHaywood/DotNetNuke.Extensions 1 사용 예제들

공개 메소드들

메소드	설명
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

메소드 상세