C# Class Tiraggo.SqlServerCe4Provider.QueryBuilder

Afficher le fichier Open project: BrewDawg/Tiraggo

Méthodes publiques

Méthode Description
PrepareCommand ( tgDataRequest request ) : SqlCeCommand

Méthodes protégées

Méthode 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
GetOrderByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetSelectStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetSetOperationStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string

Private Methods

Méthode Description
GetSubquerySearchCondition ( tgDynamicQuerySerializable query ) : string
NextParamIndex ( IDbCommand cmd ) : int

Method Details

ApplyWhereSubOperations() protected static méthode

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

BuildQuery() protected static méthode

protected static BuildQuery ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
Résultat string

BuildSubOperationsSql() protected static méthode

protected static BuildSubOperationsSql ( StandardProviderParameters std, string columnName, List subOperators ) : string
std StandardProviderParameters
columnName string
subOperators List
Résultat string

GetCaseWhenThenEnd() protected static méthode

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

GetCastSql() protected static méthode

protected static GetCastSql ( tgCastType castType ) : string
castType tgCastType
Résultat string

GetColumnName() protected static méthode

protected static GetColumnName ( tgColumnItem column ) : string
column Tiraggo.DynamicQuery.tgColumnItem
Résultat string

GetComparisonStatement() protected static méthode

protected static GetComparisonStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query, List items, string prefix ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
items List
prefix string
Résultat string

GetExpressionColumn() protected static méthode

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
Résultat string

GetFromStatement() protected static méthode

protected static GetFromStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
Résultat string

GetGroupByStatement() protected static méthode

protected static GetGroupByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
Résultat string

GetJoinStatement() protected static méthode

protected static GetJoinStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
Résultat string

GetMathmaticalExpressionColumn() protected static méthode

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

GetOrderByStatement() protected static méthode

protected static GetOrderByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
Résultat string

GetSelectStatement() protected static méthode

protected static GetSelectStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
Résultat string

GetSetOperationStatement() protected static méthode

protected static GetSetOperationStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std StandardProviderParameters
query tgDynamicQuerySerializable
Résultat string

PrepareCommand() public static méthode

public static PrepareCommand ( tgDataRequest request ) : SqlCeCommand
request Tiraggo.Interfaces.tgDataRequest
Résultat SqlCeCommand