C# 클래스 Hd.QueryExtensions.WhereTerm

상속: ICloneable
파일 보기 프로젝트 열기: TargetProcess/Tp.HelpDesk 1 사용 예제들

공개 메소드들

메소드 설명
Clone ( ) : WhereTerm

Creates a copy of this WhereTerm
CreateBetween ( SqlExpression expr, SqlExpression lowBound, SqlExpression highBound ) : WhereTerm

Creates a WhereTerm which checks weather a value is in a specifed range.

CreateBetween only accepts expressions which yeild a 'Date' or 'Number' values. All expressions must be of compatible types.

CreateCompare ( SqlExpression expr1, SqlExpression expr2, CompareOperator op ) : WhereTerm

Creates a comparison WhereTerm.

A comparison term compares two expression on the basis of their values. Expressions can be of any type but their results must be of comparible types. For instance, you can not compare a database field of type 'date' and a static value of type 'int'.

CreateExists ( string sql ) : WhereTerm

Creates a WhereTerm which encapsulates SQL EXISTS clause
CreateIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm

Creates a WhereTerm which represents SQL IN clause
CreateIn ( SqlExpression expr, string sql ) : WhereTerm

Creates a WhereTerm which represents SQL IN clause
CreateIsNotNull ( SqlExpression expr ) : WhereTerm

Creates a WhereTerm which returns TRUE if an expression is NOT NULL
CreateIsNull ( SqlExpression expr ) : WhereTerm

Creates a WhereTerm which returns TRUE if an expression is NULL
CreateNotExists ( string sql ) : WhereTerm

Creates a WhereTerm which encapsulates SQL NOT EXISTS clause
CreateNotIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm

Creates a WhereTerm which represents SQL NOT IN clause
CreateNotIn ( SqlExpression expr, string sql ) : WhereTerm

Creates a WhereTerm which represents SQL NOT IN clause
WhereTerm ( ) : System

비공개 메소드들

메소드 설명
ICloneable ( ) : object

메소드 상세

Clone() 공개 메소드

Creates a copy of this WhereTerm
public Clone ( ) : WhereTerm
리턴 WhereTerm

CreateBetween() 공개 정적인 메소드

Creates a WhereTerm which checks weather a value is in a specifed range.
CreateBetween only accepts expressions which yeild a 'Date' or 'Number' values. All expressions must be of compatible types.
public static CreateBetween ( SqlExpression expr, SqlExpression lowBound, SqlExpression highBound ) : WhereTerm
expr SqlExpression Expression which yeilds the value to be checked
lowBound SqlExpression Expression which yeilds the low bound of the range
highBound SqlExpression Expression which yeilds the high bound of the range
리턴 WhereTerm

CreateCompare() 공개 정적인 메소드

Creates a comparison WhereTerm.
A comparison term compares two expression on the basis of their values. Expressions can be of any type but their results must be of comparible types. For instance, you can not compare a database field of type 'date' and a static value of type 'int'.
public static CreateCompare ( SqlExpression expr1, SqlExpression expr2, CompareOperator op ) : WhereTerm
expr1 SqlExpression Expression on the left side of the operator
expr2 SqlExpression Expression on the right side of the operator
op CompareOperator Conditional operator to be applied on the expressions
리턴 WhereTerm

CreateExists() 공개 정적인 메소드

Creates a WhereTerm which encapsulates SQL EXISTS clause
public static CreateExists ( string sql ) : WhereTerm
sql string Sub query for the EXISTS clause
리턴 WhereTerm

CreateIn() 공개 정적인 메소드

Creates a WhereTerm which represents SQL IN clause
public static CreateIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm
expr SqlExpression Expression to be looked up
values SqlConstantCollection List of values
리턴 WhereTerm

CreateIn() 공개 정적인 메소드

Creates a WhereTerm which represents SQL IN clause
public static CreateIn ( SqlExpression expr, string sql ) : WhereTerm
expr SqlExpression Expression to be looked up
sql string Sub query
리턴 WhereTerm

CreateIsNotNull() 공개 정적인 메소드

Creates a WhereTerm which returns TRUE if an expression is NOT NULL
public static CreateIsNotNull ( SqlExpression expr ) : WhereTerm
expr SqlExpression
리턴 WhereTerm

CreateIsNull() 공개 정적인 메소드

Creates a WhereTerm which returns TRUE if an expression is NULL
public static CreateIsNull ( SqlExpression expr ) : WhereTerm
expr SqlExpression Expression to be evaluated
리턴 WhereTerm

CreateNotExists() 공개 정적인 메소드

Creates a WhereTerm which encapsulates SQL NOT EXISTS clause
public static CreateNotExists ( string sql ) : WhereTerm
sql string Sub query for the NOT EXISTS clause
리턴 WhereTerm

CreateNotIn() 공개 정적인 메소드

Creates a WhereTerm which represents SQL NOT IN clause
public static CreateNotIn ( SqlExpression expr, SqlConstantCollection values ) : WhereTerm
expr SqlExpression Expression to be looked up
values SqlConstantCollection
리턴 WhereTerm

CreateNotIn() 공개 정적인 메소드

Creates a WhereTerm which represents SQL NOT IN clause
public static CreateNotIn ( SqlExpression expr, string sql ) : WhereTerm
expr SqlExpression Expression to be looked up
sql string Sub query
리턴 WhereTerm

WhereTerm() 공개 메소드

public WhereTerm ( ) : System
리턴 System