C# Class Nettiers.AdventureWorks.Data.SqlExpressionParser

Inheritance: ExpressionParserBase

Afficher le fichier Open project: netTiers/netTiers

Méthodes publiques

Méthode	Description
Parse ( String value ) : String	Parses the specified value into separate search terms.
SqlExpressionParser ( String propertyName ) : System	Initializes a new instance of the SqlExpressionParser class.
SqlExpressionParser ( String propertyName, SqlComparisonType comparisonType ) : System	Initializes a new instance of the SqlExpressionParser class.
SqlExpressionParser ( String propertyName, SqlComparisonType comparisonType, bool ignoreCase ) : System	Initializes a new instance of the SqlExpressionParser class.
SqlExpressionParser ( String propertyName, bool ignoreCase ) : System	Initializes a new instance of the SqlExpressionParser class.

Méthodes protégées

Méthode	Description
AppendAnd ( ) : void	Appends "AND" to the SQL statement.
AppendOr ( ) : void	Appends "OR" to the SQL statement.
AppendSearchText ( string searchText ) : void	Appends the specified search text to the SQL statement.
AppendSpace ( ) : void	Appends a space to the SQL statement.
CloseGrouping ( ) : void	Appends a right parentheses to the SQL statement.
Contains ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.Contains expression.
EndsWith ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.EndsWith expression.
Equals ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.Equals expression.
Like ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.Like expression.
OpenGrouping ( ) : void	Appends a left parentheses to the SQL statement.
StartsWith ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.StartsWith expression.
WrapWithSQL ( String propertyName, String value, bool ignoreCase ) : String	Converts the search text into a valid search expression.

Method Details

AppendAnd() protected méthode

Appends "AND" to the SQL statement.

protected AppendAnd ( ) : void
Résultat	void

AppendOr() protected méthode

Appends "OR" to the SQL statement.

protected AppendOr ( ) : void
Résultat	void

AppendSearchText() protected méthode

Appends the specified search text to the SQL statement.

protected AppendSearchText ( string searchText ) : void
searchText	string	The search text to append.
Résultat	void

AppendSpace() protected méthode

Appends a space to the SQL statement.

protected AppendSpace ( ) : void
Résultat	void

CloseGrouping() protected méthode

Appends a right parentheses to the SQL statement.

protected CloseGrouping ( ) : void
Résultat	void

Contains() protected méthode

Creates a SqlComparisonType.Contains expression.

protected Contains ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
Résultat	String

EndsWith() protected méthode

Creates a SqlComparisonType.EndsWith expression.

protected EndsWith ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
Résultat	String

Equals() protected méthode

Creates a SqlComparisonType.Equals expression.

protected Equals ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
Résultat	String

Like() protected méthode

Creates a SqlComparisonType.Like expression.

protected Like ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
Résultat	String

OpenGrouping() protected méthode

Appends a left parentheses to the SQL statement.

protected OpenGrouping ( ) : void
Résultat	void

Parse() public méthode

Parses the specified value into separate search terms.

public Parse ( String value ) : String
value	String	The search text.
Résultat	String

SqlExpressionParser() public méthode

Initializes a new instance of the SqlExpressionParser class.

public SqlExpressionParser ( String propertyName ) : System
propertyName	String
Résultat	System

SqlExpressionParser() public méthode

Initializes a new instance of the SqlExpressionParser class.

public SqlExpressionParser ( String propertyName, SqlComparisonType comparisonType ) : System
propertyName	String
comparisonType	SqlComparisonType
Résultat	System

SqlExpressionParser() public méthode

Initializes a new instance of the SqlExpressionParser class.

public SqlExpressionParser ( String propertyName, SqlComparisonType comparisonType, bool ignoreCase ) : System
propertyName	String
comparisonType	SqlComparisonType
ignoreCase	bool
Résultat	System

SqlExpressionParser() public méthode

Initializes a new instance of the SqlExpressionParser class.

public SqlExpressionParser ( String propertyName, bool ignoreCase ) : System
propertyName	String
ignoreCase	bool
Résultat	System

StartsWith() protected méthode

Creates a SqlComparisonType.StartsWith expression.

protected StartsWith ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
Résultat	String

WrapWithSQL() protected méthode

Converts the search text into a valid search expression.

protected WrapWithSQL ( String propertyName, String value, bool ignoreCase ) : String
propertyName	String
value	String
ignoreCase	bool
Résultat	String