C# 클래스 Hd.QueryExtensions.Render.SqlOmRenderer

Provides common implementation for ISqlOmRenderer

상속: ISqlOmRenderer

파일 보기 프로젝트 열기: TargetProcess/Tp.HelpDesk

공개 메소드들

메소드	설명
RenderPage ( int pageIndex, int pageSize, int totalRowCount, SelectQuery query ) : string	Renders a SELECT statement which a result-set page To generate pagination SQL you must supply totalRowCount. To aquire the total number of rows use the RenderRowCount method.
RenderRowCount ( SelectQuery query ) : string	Renders a row count SELECT statement.
RenderSelect ( SelectQuery query ) : string	Renders a SELECT statement
SqlEncode ( string val ) : string	Encodes a textual string. All text string must be encoded before they are appended to a SQL statement.
SqlOmRenderer ( char identifierOpeningQuote, char identifierClosingQuote ) : System	Creates a new SqlOmRenderer

보호된 메소드들

메소드	설명
BitwiseAnd ( StringBuilder builder, WhereTerm term ) : void	Renders bitwise and
Coma ( StringBuilder builder ) : void	Renders a separator between select columns
Constant ( StringBuilder builder, SqlConstant expr ) : void	Renders a constant
ConstantList ( StringBuilder builder, SqlConstantCollection values ) : void	Renders a list of values
Expression ( StringBuilder builder, SqlExpression expr ) : void	Renders SqlExpression
From ( StringBuilder builder ) : void	Renders the begining of a FROM clause
FromClause ( StringBuilder builder, FromClause fromClause, string tableSpace ) : void	Renders the terms of a from clause
Function ( StringBuilder builder, SqlAggregationFunction func, SqlExpression param ) : void	Renders a SqlExpression of type Function
GroupBy ( StringBuilder builder, GroupByTermCollection groupByTerms ) : void	Renders the begining of a GROUP BY statement. If groupByTerms has no items, nothing will be appended.
GroupByTerm ( StringBuilder builder, GroupByTerm term ) : void	Renders a single GROUP BY term
GroupByTerms ( StringBuilder builder, GroupByTermCollection groupByTerms ) : void	Renders GROUP BY terms
Having ( StringBuilder builder, WhereClause group ) : void	Renders the begining of a HAVING statement
Identifier ( StringBuilder builder, string name ) : void	Renders an identifier name.
IfNull ( StringBuilder builder, SqlExpression expr ) : void	Renders IfNull SqlExpression
Operator ( StringBuilder builder, CompareOperator op ) : void	Renders a comaprison operator
OrderBy ( StringBuilder builder, OrderByTermCollection orderByTerms ) : void	Renders the begining of a ORDER BY statement. If orderByTerms has no items, nothing will be appended.
OrderByTerm ( StringBuilder builder, OrderByTerm term ) : void	Renders a single ORDER BY term
OrderByTerms ( StringBuilder builder, OrderByTermCollection orderByTerms ) : void	Renders ORDER BY terms
QualifiedIdentifier ( StringBuilder builder, string qnamespace, string name ) : void	Renders a fully qualified identifer. QualifiedIdentifier is usually to render database fields with optional table alias prefixes. name is a mandatory parameter while qnamespace is optional. If qnamespace is null, identifier will be rendered without a namespace (aka table alias)
RelationshipOperator ( StringBuilder builder, WhereClauseRelationship relationship ) : void	Renders a relationship operator
RenderFromTerm ( StringBuilder builder, FromTerm table, string tableSpace ) : void	Renders a single FROM term
Select ( StringBuilder builder, bool distinct ) : void	Renders a the beginning of a SELECT clause with an optional DISTINCT setting
SelectColumn ( StringBuilder builder, SelectColumn col ) : void	Renders a sinle select column
SelectColumns ( StringBuilder builder, SelectColumnCollection columns ) : void	Renders columns of SELECT clause
TableNamespace ( StringBuilder builder, string ns ) : void	Renders the table namespace
Where ( StringBuilder builder, WhereClause group ) : void	Renders the begining of a WHERE statement
WhereClause ( StringBuilder builder, WhereClause group ) : void	Recursivly renders a WhereClause
WhereClause ( StringBuilder builder, WhereTerm term ) : void	Renders a single WhereTerm

비공개 메소드들

메소드	설명
ApplyOrderBy ( OrderByTermCollection terms, SelectQuery orderQuery, bool forward, FromTerm table ) : void
FormatSortFieldName ( string fieldName ) : string

메소드 상세

BitwiseAnd() 보호된 메소드

Renders bitwise and

protected BitwiseAnd ( StringBuilder builder, WhereTerm term ) : void
builder	StringBuilder
term	WhereTerm
리턴	void

Coma() 보호된 메소드

Renders a separator between select columns

protected Coma ( StringBuilder builder ) : void
builder	StringBuilder
리턴	void

Constant() 보호된 메소드

Renders a constant

protected Constant ( StringBuilder builder, SqlConstant expr ) : void
builder	StringBuilder
expr	SqlConstant
리턴	void

ConstantList() 보호된 메소드

Renders a list of values

protected ConstantList ( StringBuilder builder, SqlConstantCollection values ) : void
builder	StringBuilder
values	SqlConstantCollection
리턴	void

Expression() 보호된 메소드

Renders SqlExpression

protected Expression ( StringBuilder builder, SqlExpression expr ) : void
builder	StringBuilder
expr	SqlExpression
리턴	void

From() 보호된 메소드

Renders the begining of a FROM clause

protected From ( StringBuilder builder ) : void
builder	StringBuilder
리턴	void

FromClause() 보호된 메소드

Renders the terms of a from clause

protected FromClause ( StringBuilder builder, FromClause fromClause, string tableSpace ) : void
builder	StringBuilder
fromClause	FromClause
tableSpace	string	Common prefix for all tables in the clause
리턴	void

Function() 보호된 메소드

Renders a SqlExpression of type Function

protected Function ( StringBuilder builder, SqlAggregationFunction func, SqlExpression param ) : void
builder	StringBuilder
func	SqlAggregationFunction
param	SqlExpression
리턴	void

GroupBy() 보호된 메소드

Renders the begining of a GROUP BY statement.

If groupByTerms has no items, nothing will be appended.

protected GroupBy ( StringBuilder builder, GroupByTermCollection groupByTerms ) : void
builder	StringBuilder
groupByTerms	GroupByTermCollection
리턴	void

GroupByTerm() 보호된 메소드

Renders a single GROUP BY term

protected GroupByTerm ( StringBuilder builder, GroupByTerm term ) : void
builder	StringBuilder
term	GroupByTerm
리턴	void

GroupByTerms() 보호된 메소드

Renders GROUP BY terms

protected GroupByTerms ( StringBuilder builder, GroupByTermCollection groupByTerms ) : void
builder	StringBuilder
groupByTerms	GroupByTermCollection
리턴	void

Having() 보호된 메소드

Renders the begining of a HAVING statement

protected Having ( StringBuilder builder, WhereClause group ) : void
builder	StringBuilder
group	WhereClause
리턴	void

Identifier() 보호된 메소드

Renders an identifier name.

protected Identifier ( StringBuilder builder, string name ) : void
builder	StringBuilder
name	string	Identifier name
리턴	void

IfNull() 보호된 추상적인 메소드

Renders IfNull SqlExpression

protected abstract IfNull ( StringBuilder builder, SqlExpression expr ) : void
builder	StringBuilder
expr	SqlExpression
리턴	void

Operator() 보호된 메소드

Renders a comaprison operator

protected Operator ( StringBuilder builder, CompareOperator op ) : void
builder	StringBuilder
op	CompareOperator
리턴	void

OrderBy() 보호된 메소드

Renders the begining of a ORDER BY statement.

If orderByTerms has no items, nothing will be appended.

protected OrderBy ( StringBuilder builder, OrderByTermCollection orderByTerms ) : void
builder	StringBuilder
orderByTerms	OrderByTermCollection
리턴	void

OrderByTerm() 보호된 메소드

Renders a single ORDER BY term

protected OrderByTerm ( StringBuilder builder, OrderByTerm term ) : void
builder	StringBuilder
term	OrderByTerm
리턴	void

OrderByTerms() 보호된 메소드

Renders ORDER BY terms

protected OrderByTerms ( StringBuilder builder, OrderByTermCollection orderByTerms ) : void
builder	StringBuilder
orderByTerms	OrderByTermCollection
리턴	void

QualifiedIdentifier() 보호된 메소드

Renders a fully qualified identifer.

QualifiedIdentifier is usually to render database fields with optional table alias prefixes. name is a mandatory parameter while qnamespace is optional. If qnamespace is null, identifier will be rendered without a namespace (aka table alias)

protected QualifiedIdentifier ( StringBuilder builder, string qnamespace, string name ) : void
builder	StringBuilder	Select statement string builder
qnamespace	string	Identifier namespace
name	string	Identifier name
리턴	void

RelationshipOperator() 보호된 메소드

Renders a relationship operator

protected RelationshipOperator ( StringBuilder builder, WhereClauseRelationship relationship ) : void
builder	StringBuilder
relationship	WhereClauseRelationship
리턴	void

RenderFromTerm() 보호된 메소드

Renders a single FROM term

protected RenderFromTerm ( StringBuilder builder, FromTerm table, string tableSpace ) : void
builder	StringBuilder
table	FromTerm
tableSpace	string	Common prefix for all tables in the term
리턴	void

RenderPage() 공개 메소드

Renders a SELECT statement which a result-set page

To generate pagination SQL you must supply totalRowCount. To aquire the total number of rows use the RenderRowCount method.

public RenderPage ( int pageIndex, int pageSize, int totalRowCount, SelectQuery query ) : string
pageIndex	int	The zero based index of the page to be returned
pageSize	int	The size of a page
totalRowCount	int	Total number of rows the query would yeild if not paged
query	SelectQuery	Query definition to apply paging on
리턴	string

RenderRowCount() 공개 추상적인 메소드

Renders a row count SELECT statement.

public abstract RenderRowCount ( SelectQuery query ) : string
query	SelectQuery	Query definition to count rows for
리턴	string

RenderSelect() 공개 추상적인 메소드

Renders a SELECT statement

public abstract RenderSelect ( SelectQuery query ) : string
query	SelectQuery	Query definition
리턴	string

Select() 보호된 메소드

Renders a the beginning of a SELECT clause with an optional DISTINCT setting

protected Select ( StringBuilder builder, bool distinct ) : void
builder	StringBuilder	Select statement string builder
distinct	bool	Turns on or off SQL distinct option
리턴	void

SelectColumn() 보호된 메소드

Renders a sinle select column

protected SelectColumn ( StringBuilder builder, SelectColumn col ) : void
builder	StringBuilder
col	SelectColumn
리턴	void

SelectColumns() 보호된 메소드

Renders columns of SELECT clause

protected SelectColumns ( StringBuilder builder, SelectColumnCollection columns ) : void
builder	StringBuilder
columns	SelectColumnCollection
리턴	void

SqlEncode() 공개 메소드

Encodes a textual string.

All text string must be encoded before they are appended to a SQL statement.

public SqlEncode ( string val ) : string
val	string	Text to be encoded
리턴	string

SqlOmRenderer() 공개 메소드

Creates a new SqlOmRenderer

public SqlOmRenderer ( char identifierOpeningQuote, char identifierClosingQuote ) : System
identifierOpeningQuote	char
identifierClosingQuote	char
리턴	System

TableNamespace() 보호된 메소드

Renders the table namespace

protected TableNamespace ( StringBuilder builder, string ns ) : void
builder	StringBuilder
ns	string
리턴	void

Where() 보호된 메소드

Renders the begining of a WHERE statement

protected Where ( StringBuilder builder, WhereClause group ) : void
builder	StringBuilder
group	WhereClause
리턴	void

WhereClause() 보호된 메소드

Recursivly renders a WhereClause

protected WhereClause ( StringBuilder builder, WhereClause group ) : void
builder	StringBuilder
group	WhereClause
리턴	void

WhereClause() 보호된 메소드

Renders a single WhereTerm

protected WhereClause ( StringBuilder builder, WhereTerm term ) : void
builder	StringBuilder
term	WhereTerm
리턴	void