C# Class Tiraggo.VistaDB4Provider.QueryBuilder

Show file Open project: BrewDawg/Tiraggo

Public Methods

Method	Description
PrepareCommand ( tgDataRequest request ) : VistaDBCommand

Protected Methods

Method	Description
ApplyWhereSubOperations ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgComparison comparisonData ) : string
BuildQuery ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
BuildSubOperationsSql ( StandardProviderParameters std, string columnName, List subOperators ) : string
GetCaseWhenThenEnd ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgCase caseWhenThen ) : string
GetCastSql ( tgCastType castType ) : string
GetColumnName ( tgColumnItem column ) : string
GetComparisonStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query, List items, string prefix ) : string
GetExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgExpression expression, bool inExpression, bool useAlias ) : string
GetFromStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetGroupByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetJoinStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetMathmaticalExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgMathmaticalExpression mathmaticalExpression ) : string
GetMathmaticalExpressionLiteralType ( StandardProviderParameters std, tgMathmaticalExpression mathmaticalExpression ) : string
GetOrderByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetSelectStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetSetOperationStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
esArithmeticOperatorToString ( tgArithmeticOperator arithmeticOperator ) : string

Private Methods

Method	Description
GetSubquerySearchCondition ( tgDynamicQuerySerializable query ) : string
NextParamIndex ( IDbCommand cmd ) : int

Method Details

ApplyWhereSubOperations() protected static method

protected static ApplyWhereSubOperations ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgComparison comparisonData ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
comparisonData	Tiraggo.DynamicQuery.tgComparison
return	string

BuildQuery() protected static method

protected static BuildQuery ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
return	string

BuildSubOperationsSql() protected static method

protected static BuildSubOperationsSql ( StandardProviderParameters std, string columnName, List subOperators ) : string
std	StandardProviderParameters
columnName	string
subOperators	List
return	string

GetCaseWhenThenEnd() protected static method

protected static GetCaseWhenThenEnd ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgCase caseWhenThen ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
caseWhenThen	Tiraggo.DynamicQuery.tgCase
return	string

GetCastSql() protected static method

protected static GetCastSql ( tgCastType castType ) : string
castType	tgCastType
return	string

GetColumnName() protected static method

protected static GetColumnName ( tgColumnItem column ) : string
column	Tiraggo.DynamicQuery.tgColumnItem
return	string

GetComparisonStatement() protected static method

protected static GetComparisonStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query, List items, string prefix ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
items	List
prefix	string
return	string

GetExpressionColumn() protected static method

protected static GetExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgExpression expression, bool inExpression, bool useAlias ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
expression	Tiraggo.DynamicQuery.tgExpression
inExpression	bool
useAlias	bool
return	string

GetFromStatement() protected static method

protected static GetFromStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
return	string

GetGroupByStatement() protected static method

protected static GetGroupByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
return	string

GetJoinStatement() protected static method

protected static GetJoinStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
return	string

GetMathmaticalExpressionColumn() protected static method

protected static GetMathmaticalExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgMathmaticalExpression mathmaticalExpression ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
mathmaticalExpression	Tiraggo.DynamicQuery.tgMathmaticalExpression
return	string

GetMathmaticalExpressionLiteralType() protected static method

protected static GetMathmaticalExpressionLiteralType ( StandardProviderParameters std, tgMathmaticalExpression mathmaticalExpression ) : string
std	StandardProviderParameters
mathmaticalExpression	Tiraggo.DynamicQuery.tgMathmaticalExpression
return	string

GetOrderByStatement() protected static method

protected static GetOrderByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
return	string

GetSelectStatement() protected static method

protected static GetSelectStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
return	string

GetSetOperationStatement() protected static method

protected static GetSetOperationStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
return	string

PrepareCommand() public static method

public static PrepareCommand ( tgDataRequest request ) : VistaDBCommand
request	Tiraggo.Interfaces.tgDataRequest
return	VistaDBCommand

esArithmeticOperatorToString() protected static method

protected static esArithmeticOperatorToString ( tgArithmeticOperator arithmeticOperator ) : string
arithmeticOperator	tgArithmeticOperator
return	string