C# Class PetShop.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