C# Class Nettiers.AdventureWorks.Data.SqlUtil

ファイルを表示 Open project: netTiers/netTiers Class Usage Examples

Public Properties

Property	Type	Description
AND	String
ASC	String
COMMA	String
DESC	String
LEFT	String
NULL	String
OR	String
PAGE_INDEX	String
QUOTE	String
RIGHT	String
STAR	String
TOKEN	String
WILD	String

Public Methods

Method	Description
Contains ( String value ) : String	Encodes the value for a SqlComparisonType.Contains expression.
Contains ( String column, String value ) : String	Creates a SqlComparisonType.Contains expression.
Contains ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.Contains expression.
Contains ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.Contains expression.
Encode ( String value ) : String	Encodes the specified value for use in SQL expressions.
Encode ( String value, bool surround ) : String	Encodes the specified value for use in SQL expressions and optionally surrounds the value with single-quotes.
EndsWith ( String value ) : String	Encodes the value for a SqlComparisonType.EndsWith expression.
EndsWith ( String column, String value ) : String	Creates a SqlComparisonType.EndsWith expression.
EndsWith ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.EndsWith expression.
EndsWith ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.EndsWith expression.
Equals ( String value ) : String	Encodes the value for a SqlComparisonType.Equals expression.
Equals ( String column, String value ) : String	Creates an SqlComparisonType.Equals expression.
Equals ( String column, String value, bool ignoreCase ) : String	Creates an SqlComparisonType.Equals expression.
Equals ( String column, String value, bool ignoreCase, bool surround ) : String	Creates an SqlComparisonType.Equals expression.
GetEqualFormat ( bool ignoreCase ) : String	Gets the equal format string.
GetEqualFormat ( bool ignoreCase, bool surround ) : String	Gets the equal format string.
GetLikeFormat ( bool ignoreCase ) : String	Gets the like format string.
GetLikeFormat ( bool ignoreCase, bool surround ) : String	Gets the like format string.
GetNotLikeFormat ( bool ignoreCase ) : String	Gets the not like format string.
GetNotLikeFormat ( bool ignoreCase, bool surround ) : String	Gets the not like format string.
IsNotNull ( String column ) : String	Creates an IS NOT NULL expression.
IsNull ( String column ) : String	Creates an IS NULL expression.
Like ( String value ) : String	Encodes the value for a SqlComparisonType.Like expression.
Like ( String column, String value ) : String	Creates a SqlComparisonType.Like expression.
Like ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.Like expression.
Like ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.Like expression.
NotContains ( String value ) : String	Encodes the value for a SqlComparisonType.NotContains expression.
NotContains ( String column, String value ) : String	Creates a SqlComparisonType.NotContains expression.
NotContains ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.NotContains expression.
NotContains ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.NotContains expression.
NotLike ( String value ) : String	Encodes the value for a SqlComparisonType.NotLike expression.
NotLike ( String column, String value ) : String	Creates a SqlComparisonType.NotLike expression.
NotLike ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.NotLike expression.
NotLike ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.NotLike expression.
StartsWith ( String value ) : String	Encodes the value for a SqlComparisonType.StartsWith expression.
StartsWith ( String column, String value ) : String	Creates a SqlComparisonType.StartsWith expression.
StartsWith ( String column, String value, bool ignoreCase ) : String	Creates a SqlComparisonType.StartsWith expression.
StartsWith ( String column, String value, bool ignoreCase, bool surround ) : String	Creates a SqlComparisonType.StartsWith expression.

Method Details

Contains() public static method

Encodes the value for a SqlComparisonType.Contains expression.

public static Contains ( String value ) : String
value	String	The value.
return	String

Contains() public static method

Creates a SqlComparisonType.Contains expression.

public static Contains ( String column, String value ) : String
column	String
value	String
return	String

Contains() public static method

Creates a SqlComparisonType.Contains expression.

public static Contains ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

Contains() public static method

Creates a SqlComparisonType.Contains expression.

public static Contains ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

Encode() public static method

Encodes the specified value for use in SQL expressions.

public static Encode ( String value ) : String
value	String
return	String

Encode() public static method

Encodes the specified value for use in SQL expressions and optionally surrounds the value with single-quotes.

public static Encode ( String value, bool surround ) : String
value	String
surround	bool
return	String

EndsWith() public static method

Encodes the value for a SqlComparisonType.EndsWith expression.

public static EndsWith ( String value ) : String
value	String	The value.
return	String

EndsWith() public static method

Creates a SqlComparisonType.EndsWith expression.

public static EndsWith ( String column, String value ) : String
column	String
value	String
return	String

EndsWith() public static method

Creates a SqlComparisonType.EndsWith expression.

public static EndsWith ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

EndsWith() public static method

Creates a SqlComparisonType.EndsWith expression.

public static EndsWith ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

Equals() public static method

Encodes the value for a SqlComparisonType.Equals expression.

public static Equals ( String value ) : String
value	String	The value.
return	String

Equals() public static method

Creates an SqlComparisonType.Equals expression.

public static Equals ( String column, String value ) : String
column	String
value	String
return	String

Equals() public static method

Creates an SqlComparisonType.Equals expression.

public static Equals ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

Equals() public static method

Creates an SqlComparisonType.Equals expression.

public static Equals ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

GetEqualFormat() public static method

Gets the equal format string.

public static GetEqualFormat ( bool ignoreCase ) : String
ignoreCase	bool	if set to true [ignore case].
return	String

GetEqualFormat() public static method

Gets the equal format string.

public static GetEqualFormat ( bool ignoreCase, bool surround ) : String
ignoreCase	bool	if set to true [ignore case].
surround	bool
return	String

GetLikeFormat() public static method

Gets the like format string.

public static GetLikeFormat ( bool ignoreCase ) : String
ignoreCase	bool	if set to true [ignore case].
return	String

GetLikeFormat() public static method

Gets the like format string.

public static GetLikeFormat ( bool ignoreCase, bool surround ) : String
ignoreCase	bool	if set to true [ignore case].
surround	bool
return	String

GetNotLikeFormat() public static method

Gets the not like format string.

public static GetNotLikeFormat ( bool ignoreCase ) : String
ignoreCase	bool	if set to true [ignore case].
return	String

GetNotLikeFormat() public static method

Gets the not like format string.

public static GetNotLikeFormat ( bool ignoreCase, bool surround ) : String
ignoreCase	bool	if set to true [ignore case].
surround	bool
return	String

IsNotNull() public static method

Creates an IS NOT NULL expression.

public static IsNotNull ( String column ) : String
column	String
return	String

IsNull() public static method

Creates an IS NULL expression.

public static IsNull ( String column ) : String
column	String
return	String

Like() public static method

Encodes the value for a SqlComparisonType.Like expression.

public static Like ( String value ) : String
value	String	The value.
return	String

Like() public static method

Creates a SqlComparisonType.Like expression.

public static Like ( String column, String value ) : String
column	String
value	String
return	String

Like() public static method

Creates a SqlComparisonType.Like expression.

public static Like ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

Like() public static method

Creates a SqlComparisonType.Like expression.

public static Like ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

NotContains() public static method

Encodes the value for a SqlComparisonType.NotContains expression.

public static NotContains ( String value ) : String
value	String	The value.
return	String

NotContains() public static method

Creates a SqlComparisonType.NotContains expression.

public static NotContains ( String column, String value ) : String
column	String
value	String
return	String

NotContains() public static method

Creates a SqlComparisonType.NotContains expression.

public static NotContains ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

NotContains() public static method

Creates a SqlComparisonType.NotContains expression.

public static NotContains ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

NotLike() public static method

Encodes the value for a SqlComparisonType.NotLike expression.

public static NotLike ( String value ) : String
value	String	The value.
return	String

NotLike() public static method

Creates a SqlComparisonType.NotLike expression.

public static NotLike ( String column, String value ) : String
column	String
value	String
return	String

NotLike() public static method

Creates a SqlComparisonType.NotLike expression.

public static NotLike ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

NotLike() public static method

Creates a SqlComparisonType.NotLike expression.

public static NotLike ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

StartsWith() public static method

Encodes the value for a SqlComparisonType.StartsWith expression.

public static StartsWith ( String value ) : String
value	String	The value.
return	String

StartsWith() public static method

Creates a SqlComparisonType.StartsWith expression.

public static StartsWith ( String column, String value ) : String
column	String
value	String
return	String

StartsWith() public static method

Creates a SqlComparisonType.StartsWith expression.

public static StartsWith ( String column, String value, bool ignoreCase ) : String
column	String
value	String
ignoreCase	bool
return	String

StartsWith() public static method

Creates a SqlComparisonType.StartsWith expression.

public static StartsWith ( String column, String value, bool ignoreCase, bool surround ) : String
column	String
value	String
ignoreCase	bool
surround	bool
return	String

Property Details

AND public_oe static_oe property

SQL AND keyword.

public static String AND
return	String

ASC public_oe static_oe property

SQL ASC keyword.

public static String ASC
return	String

COMMA public_oe static_oe property

Delimiter for optional search terms.

public static String COMMA
return	String

DESC public_oe static_oe property

SQL DESC keyword.

public static String DESC
return	String

LEFT public_oe static_oe property

SQL grouping open character.

public static String LEFT
return	String

NULL public_oe static_oe property

SQL NULL keyword.

public static String NULL
return	String

OR public_oe static_oe property

SQL OR keyword.

public static String OR
return	String

PAGE_INDEX public_oe static_oe property

PageIndex Temp Table

public static String PAGE_INDEX
return	String

QUOTE public_oe static_oe property

Delimiter for quoted search terms.

public static String QUOTE
return	String

RIGHT public_oe static_oe property

SQL grouping close character.

public static String RIGHT
return	String

STAR public_oe static_oe property

Used as wildcard character within search text.

public static String STAR
return	String

TOKEN public_oe static_oe property

Used to represent quoted search terms.

public static String TOKEN
return	String

WILD public_oe static_oe property

SQL wildcard character.

public static String WILD
return	String