C# Class PetShop.Data.SqlUtil

Afficher le fichier Open project: netTiers/netTiers Class Usage Examples

Méthodes publiques

Свойство 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

Méthodes publiques

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

Encodes the value for a SqlComparisonType.Contains expression.
public static Contains ( String value ) : String
value String The value.
Résultat String

Contains() public static méthode

Creates a SqlComparisonType.Contains expression.
public static Contains ( String column, String value ) : String
column String
value String
Résultat String

Contains() public static méthode

Creates a SqlComparisonType.Contains expression.
public static Contains ( String column, String value, bool ignoreCase ) : String
column String
value String
ignoreCase bool
Résultat String

Contains() public static méthode

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

Encode() public static méthode

Encodes the specified value for use in SQL expressions.
public static Encode ( String value ) : String
value String
Résultat String

Encode() public static méthode

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

EndsWith() public static méthode

Encodes the value for a SqlComparisonType.EndsWith expression.
public static EndsWith ( String value ) : String
value String The value.
Résultat String

EndsWith() public static méthode

Creates a SqlComparisonType.EndsWith expression.
public static EndsWith ( String column, String value ) : String
column String
value String
Résultat String

EndsWith() public static méthode

Creates a SqlComparisonType.EndsWith expression.
public static EndsWith ( String column, String value, bool ignoreCase ) : String
column String
value String
ignoreCase bool
Résultat String

EndsWith() public static méthode

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

Equals() public static méthode

Encodes the value for a SqlComparisonType.Equals expression.
public static Equals ( String value ) : String
value String The value.
Résultat String

Equals() public static méthode

Creates an SqlComparisonType.Equals expression.
public static Equals ( String column, String value ) : String
column String
value String
Résultat String

Equals() public static méthode

Creates an SqlComparisonType.Equals expression.
public static Equals ( String column, String value, bool ignoreCase ) : String
column String
value String
ignoreCase bool
Résultat String

Equals() public static méthode

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

GetEqualFormat() public static méthode

Gets the equal format string.
public static GetEqualFormat ( bool ignoreCase ) : String
ignoreCase bool if set to true [ignore case].
Résultat String

GetEqualFormat() public static méthode

Gets the equal format string.
public static GetEqualFormat ( bool ignoreCase, bool surround ) : String
ignoreCase bool if set to true [ignore case].
surround bool
Résultat String

GetLikeFormat() public static méthode

Gets the like format string.
public static GetLikeFormat ( bool ignoreCase ) : String
ignoreCase bool if set to true [ignore case].
Résultat String

GetLikeFormat() public static méthode

Gets the like format string.
public static GetLikeFormat ( bool ignoreCase, bool surround ) : String
ignoreCase bool if set to true [ignore case].
surround bool
Résultat String

GetNotLikeFormat() public static méthode

Gets the not like format string.
public static GetNotLikeFormat ( bool ignoreCase ) : String
ignoreCase bool if set to true [ignore case].
Résultat String

GetNotLikeFormat() public static méthode

Gets the not like format string.
public static GetNotLikeFormat ( bool ignoreCase, bool surround ) : String
ignoreCase bool if set to true [ignore case].
surround bool
Résultat String

IsNotNull() public static méthode

Creates an IS NOT NULL expression.
public static IsNotNull ( String column ) : String
column String
Résultat String

IsNull() public static méthode

Creates an IS NULL expression.
public static IsNull ( String column ) : String
column String
Résultat String

Like() public static méthode

Encodes the value for a SqlComparisonType.Like expression.
public static Like ( String value ) : String
value String The value.
Résultat String

Like() public static méthode

Creates a SqlComparisonType.Like expression.
public static Like ( String column, String value ) : String
column String
value String
Résultat String

Like() public static méthode

Creates a SqlComparisonType.Like expression.
public static Like ( String column, String value, bool ignoreCase ) : String
column String
value String
ignoreCase bool
Résultat String

Like() public static méthode

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

NotContains() public static méthode

Encodes the value for a SqlComparisonType.NotContains expression.
public static NotContains ( String value ) : String
value String The value.
Résultat String

NotContains() public static méthode

Creates a SqlComparisonType.NotContains expression.
public static NotContains ( String column, String value ) : String
column String
value String
Résultat String

NotContains() public static méthode

Creates a SqlComparisonType.NotContains expression.
public static NotContains ( String column, String value, bool ignoreCase ) : String
column String
value String
ignoreCase bool
Résultat String

NotContains() public static méthode

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

NotLike() public static méthode

Encodes the value for a SqlComparisonType.NotLike expression.
public static NotLike ( String value ) : String
value String The value.
Résultat String

NotLike() public static méthode

Creates a SqlComparisonType.NotLike expression.
public static NotLike ( String column, String value ) : String
column String
value String
Résultat String

NotLike() public static méthode

Creates a SqlComparisonType.NotLike expression.
public static NotLike ( String column, String value, bool ignoreCase ) : String
column String
value String
ignoreCase bool
Résultat String

NotLike() public static méthode

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

StartsWith() public static méthode

Encodes the value for a SqlComparisonType.StartsWith expression.
public static StartsWith ( String value ) : String
value String The value.
Résultat String

StartsWith() public static méthode

Creates a SqlComparisonType.StartsWith expression.
public static StartsWith ( String column, String value ) : String
column String
value String
Résultat String

StartsWith() public static méthode

Creates a SqlComparisonType.StartsWith expression.
public static StartsWith ( String column, String value, bool ignoreCase ) : String
column String
value String
ignoreCase bool
Résultat String

StartsWith() public static méthode

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

Property Details

AND public_oe static_oe property

SQL AND keyword.
public static String AND
Résultat String

ASC public_oe static_oe property

SQL ASC keyword.
public static String ASC
Résultat String

COMMA public_oe static_oe property

Delimiter for optional search terms.
public static String COMMA
Résultat String

DESC public_oe static_oe property

SQL DESC keyword.
public static String DESC
Résultat String

LEFT public_oe static_oe property

SQL grouping open character.
public static String LEFT
Résultat String

NULL public_oe static_oe property

SQL NULL keyword.
public static String NULL
Résultat String

OR public_oe static_oe property

SQL OR keyword.
public static String OR
Résultat String

PAGE_INDEX public_oe static_oe property

PageIndex Temp Table
public static String PAGE_INDEX
Résultat String

QUOTE public_oe static_oe property

Delimiter for quoted search terms.
public static String QUOTE
Résultat String

RIGHT public_oe static_oe property

SQL grouping close character.
public static String RIGHT
Résultat String

STAR public_oe static_oe property

Used as wildcard character within search text.
public static String STAR
Résultat String

TOKEN public_oe static_oe property

Used to represent quoted search terms.
public static String TOKEN
Résultat String

WILD public_oe static_oe property

SQL wildcard character.
public static String WILD
Résultat String