C# Class LightFramework.Data.Restrictions

构造SQL语句的条件类

显示文件 Open project: xianrendzw/LightFramework.Net

Public Methods

Method	Description
Between ( string columnName, object lowerValue, object higherValue ) : BetweenOperand
Bracket ( Bracket bracket ) : BracketOperand
Clause ( SqlClause sqlClause ) : ClauseOperand
Equal ( string columnName, object columnValue ) : EqualOperand
Equal ( string columnName, string columnValue ) : EqualOperand
GreaterThan ( string columnName, object columnValue ) : GreaterThanOperand
GreaterThanOrEqual ( string columnName, object columnValue ) : GreaterThanOrEqualOperand
GroupBy ( ) : GroupByOperand
In ( string columnName, object columnValue ) : InOperand
LessThan ( string columnName, object columnValue ) : LessThanOperand
LessThanOrEqual ( string columnName, object columnValue ) : LessThanOrEqualOperand
Like ( string columnName, object columnValue ) : LikeOperand
NotEqual ( string columnName, object columnValue ) : NotEqualOperand
NotIn ( string columnName, object columnValue ) : NotInOperand
NotLike ( string columnName, object columnValue ) : NotLikeOperand
OrderBy ( SortTypeEnum sortType ) : OrderByOperand

Method Details

Between() public static method

public static Between ( string columnName, object lowerValue, object higherValue ) : BetweenOperand
columnName	string
lowerValue	object
higherValue	object
return	BetweenOperand

Bracket() public static method

public static Bracket ( Bracket bracket ) : BracketOperand
bracket	Bracket
return	BracketOperand

Clause() public static method

public static Clause ( SqlClause sqlClause ) : ClauseOperand
sqlClause	SqlClause
return	ClauseOperand

Equal() public static method

public static Equal ( string columnName, object columnValue ) : EqualOperand
columnName	string
columnValue	object
return	EqualOperand

Equal() public static method

public static Equal ( string columnName, string columnValue ) : EqualOperand
columnName	string
columnValue	string
return	EqualOperand

GreaterThan() public static method

public static GreaterThan ( string columnName, object columnValue ) : GreaterThanOperand
columnName	string
columnValue	object
return	GreaterThanOperand

GreaterThanOrEqual() public static method

public static GreaterThanOrEqual ( string columnName, object columnValue ) : GreaterThanOrEqualOperand
columnName	string
columnValue	object
return	GreaterThanOrEqualOperand

GroupBy() public static method

public static GroupBy ( ) : GroupByOperand
return	GroupByOperand

In() public static method

public static In ( string columnName, object columnValue ) : InOperand
columnName	string
columnValue	object
return	InOperand

LessThan() public static method

public static LessThan ( string columnName, object columnValue ) : LessThanOperand
columnName	string
columnValue	object
return	LessThanOperand

LessThanOrEqual() public static method

public static LessThanOrEqual ( string columnName, object columnValue ) : LessThanOrEqualOperand
columnName	string
columnValue	object
return	LessThanOrEqualOperand

Like() public static method

public static Like ( string columnName, object columnValue ) : LikeOperand
columnName	string
columnValue	object
return	LikeOperand

NotEqual() public static method

public static NotEqual ( string columnName, object columnValue ) : NotEqualOperand
columnName	string
columnValue	object
return	NotEqualOperand

NotIn() public static method

public static NotIn ( string columnName, object columnValue ) : NotInOperand
columnName	string
columnValue	object
return	NotInOperand

NotLike() public static method

public static NotLike ( string columnName, object columnValue ) : NotLikeOperand
columnName	string
columnValue	object
return	NotLikeOperand

OrderBy() public static method

public static OrderBy ( SortTypeEnum sortType ) : OrderByOperand
sortType	SortTypeEnum
return	OrderByOperand