• 홈
• PetShop
• Data
• SqlUtil

C# 클래스 PetShop.Data.SqlUtil

파일 보기 프로젝트 열기: netTiers/netTiers 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
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

공개 메소드들

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

메소드 상세

프로퍼티 상세