• 홈
• Habanero
• DB
• SelectQueryDB

C# 클래스 Habanero.DB.SelectQueryDB

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

공개 메소드들

메소드	설명
CreateSqlStatement ( ) : ISqlStatement	Creates an ISqlStatement out of the SelectQuery given in the constructor, to be used to load from a database
CreateSqlStatement ( ISqlFormatter sqlFormatter ) : ISqlStatement	Creates an ISqlStatement out of the SelectQuery given in the constructor, to be used to load from a database
SelectQueryDB ( ISelectQuery selectQuery, IDatabaseConnection databaseConnection ) : System	Creates a SelectQueryDB, wrapping an ISelectQuery (Decorator pattern)

비공개 메소드들

메소드	설명
AddAliasForSource ( Source source ) : void
AddParameter ( object value, SqlStatement statement ) : string
AppendAsc ( StringBuilder builder ) : void
AppendDesc ( StringBuilder builder ) : void
AppendFields ( StringBuilder builder ) : void
AppendFrom ( StringBuilder builder ) : void
AppendLimitClauseAtBeginning ( StringBuilder builder ) : void
AppendLimitClauseAtEnd ( StringBuilder builder ) : void
AppendMainSelectClause ( SqlStatement statement, StringBuilder builder ) : void
AppendNoOfRecordsClauseAtBeginning ( StringBuilder builder ) : void
AppendNoOfRecordsClauseAtEnd ( StringBuilder builder ) : void
AppendOrderBy ( StringBuilder builder, string selectName, bool reverseSortDirection ) : void
AppendOrderByClause ( StringBuilder builder ) : void
AppendOrderByField ( StringBuilder orderByClause, OrderCriteriaField orderOrderCriteriaField ) : void
AppendOrderByFirstSelect ( StringBuilder builder ) : void
AppendOrderBySecondSelect ( StringBuilder builder ) : void
AppendWhereClause ( StringBuilder builder, SqlStatement statement ) : void
CheckRecordOffSetAndAppendFields ( StringBuilder builder ) : void
CreateInClause ( SqlStatement statement, object value ) : string
DelimitField ( string entityName, string fieldName ) : string
DelimitFieldName ( string fieldName ) : string
DelimitTable ( string tableName ) : string
GetOrderByFieldName ( OrderCriteriaField orderOrderCriteriaField ) : string
SetupAliases ( ) : void	Sets up the aliases to use for each of the sources in this select query.

메소드 상세