本文整理汇总了C#中esDynamicQuerySerializable类的典型用法代码示例。如果您正苦于以下问题：C# esDynamicQuerySerializable类的具体用法？C# esDynamicQuerySerializable怎么用？C# esDynamicQuerySerializable使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
esDynamicQuerySerializable类属于命名空间，在下文中一共展示了esDynamicQuerySerializable类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: GetFromStatement
protected static string GetFromStatement(esDataRequest request, esDynamicQuerySerializable query, VistaDBCommand cmd, ref int pindex)
{
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
string sql = String.Empty;
if (iQuery.InternalFromQuery == null)
{
sql = Shared.CreateFullName(query);
if (iQuery.JoinAlias != " ")
{
sql += " " + iQuery.JoinAlias;
}
}
else
{
IDynamicQuerySerializableInternal iSubQuery = iQuery.InternalFromQuery as IDynamicQuerySerializableInternal;
iSubQuery.IsInSubQuery = true;
sql += "(";
sql += BuildQuery(request, iQuery.InternalFromQuery, cmd, ref pindex);
sql += ")";
if (iSubQuery.SubQueryAlias != " ")
{
sql += " AS " + iSubQuery.SubQueryAlias;
}
iSubQuery.IsInSubQuery = false;
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:35，代码来源:QueryBuilder.cs
示例2: BuildQuery
protected static string BuildQuery(StandardProviderParameters std, esDynamicQuerySerializable query)
{
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
bool selectAll = (iQuery.InternalSelectColumns == null && !query.es.CountAll);
bool paging = false;
if (query.es.PageNumber.HasValue && query.es.PageSize.HasValue)
paging = true;
string select = GetSelectStatement(std, query);
string from = GetFromStatement(std, query);
string join = GetJoinStatement(std, query);
string where = GetComparisonStatement(std, query, iQuery.InternalWhereItems, " WHERE ");
string groupBy = GetGroupByStatement(std, query);
string having = GetComparisonStatement(std, query, iQuery.InternalHavingItems, " HAVING ");
string orderBy = GetOrderByStatement(std, query);
string setOperation = GetSetOperationStatement(std, query);
string sql = String.Empty;
if (paging)
{
int begRow = ((query.es.PageNumber.Value - 1) * query.es.PageSize.Value) + 1;
int endRow = begRow + (query.es.PageSize.Value - 1);
// The WITH statement
sql += "WITH \"withStatement\" AS (";
if (selectAll)
{
sql += "SELECT " +
Delimiters.TableOpen + query.es.QuerySource + Delimiters.TableClose
+ ".*, ROW_NUMBER() OVER(" + orderBy + ") AS ESRN ";
}
else
{
sql += "SELECT " + select + ", ROW_NUMBER() OVER(" + orderBy + ") AS ESRN ";
}
sql += "FROM " + from + join + where + groupBy + ") ";
// The actual select
if (selectAll || join.Length > 0 || groupBy.Length > 0 || query.es.Distinct)
{
sql += "SELECT " +
Delimiters.TableOpen + "withStatement" + Delimiters.TableClose
+ ".* FROM \"withStatement\" ";
}
else
{
sql += "SELECT " + select + " FROM \"withStatement\" ";
}
sql += "WHERE ESRN BETWEEN " + begRow + " AND " + endRow;
sql += " ORDER BY ESRN ASC";
}
else
{
sql += "SELECT " + select + " FROM " + from + join + where + setOperation + groupBy + having + orderBy;
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:60，代码来源:QueryBuilder.cs
示例3: GetOrderByStatement
protected static string GetOrderByStatement(StandardProviderParameters std, esDynamicQuerySerializable query)
{
string sql = String.Empty;
string comma = String.Empty;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
if (iQuery.InternalOrderByItems != null)
{
sql += " ORDER BY ";
foreach (esOrderByItem orderByItem in iQuery.InternalOrderByItems)
{
bool literal = false;
sql += comma;
string columnName = orderByItem.Expression.Column.Name;
if (columnName != null && columnName[0] == '<')
{
sql += columnName.Substring(1, columnName.Length - 2);
if (orderByItem.Direction == esOrderByDirection.Unassigned)
{
literal = true; // They must provide the DESC/ASC in the literal string
}
}
else
{
sql += GetExpressionColumn(std, query, orderByItem.Expression, false, false);
}
if (!literal)
{
if (orderByItem.Direction == esOrderByDirection.Ascending)
sql += " ASC";
else
sql += " DESC";
}
comma = ",";
}
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:47，代码来源:QueryBuilder.cs
示例4: GetComparisonStatement
protected static string GetComparisonStatement(StandardProviderParameters std, esDynamicQuerySerializable query, List<esComparison> items, string prefix)
{
string sql = String.Empty;
string comma = String.Empty;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
//=======================================
// WHERE
//=======================================
if (items != null)
{
sql += prefix;
DbType paramType = DbType.String;
string compareTo = String.Empty;
foreach (esComparison comparisonItem in items)
{
paramType = DbType.String;
esComparison.esComparisonData comparisonData = (esComparison.esComparisonData)comparisonItem;
esDynamicQuerySerializable subQuery = null;
bool requiresParam = true;
bool needsStringParameter = false;
std.needsIntegerParameter = false;
if (comparisonData.IsParenthesis)
{
if (comparisonData.Parenthesis == esParenthesis.Open)
sql += "(";
else
sql += ")";
continue;
}
if (comparisonData.IsConjunction)
{
switch (comparisonData.Conjunction)
{
case esConjunction.And: sql += " AND "; break;
case esConjunction.Or: sql += " OR "; break;
case esConjunction.AndNot: sql += " AND NOT "; break;
case esConjunction.OrNot: sql += " OR NOT "; break;
}
continue;
}
Dictionary<string, SqlParameter> types = null;
if (comparisonData.Column.Query != null)
{
IDynamicQuerySerializableInternal iLocalQuery = comparisonData.Column.Query as IDynamicQuerySerializableInternal;
types = Cache.GetParameters(iLocalQuery.DataID, (esProviderSpecificMetadata)iLocalQuery.ProviderMetadata, (esColumnMetadataCollection)iLocalQuery.Columns);
}
if (comparisonData.IsLiteral)
{
if (comparisonData.Column.Name[0] == '<')
{
sql += comparisonData.Column.Name.Substring(1, comparisonData.Column.Name.Length - 2);
}
else
{
sql += comparisonData.Column.Name;
}
continue;
}
if (comparisonData.ComparisonColumn.Name == null)
{
subQuery = comparisonData.Value as esDynamicQuerySerializable;
if (subQuery == null)
{
if (comparisonData.Column.Name != null)
{
IDynamicQuerySerializableInternal iColQuery = comparisonData.Column.Query as IDynamicQuerySerializableInternal;
esColumnMetadataCollection columns = (esColumnMetadataCollection)iColQuery.Columns;
compareTo = Delimiters.Param + columns[comparisonData.Column.Name].PropertyName + (++std.pindex).ToString();
}
else
{
compareTo = Delimiters.Param + "Expr" + (++std.pindex).ToString();
}
}
else
{
// It's a sub query
compareTo = GetSubquerySearchCondition(subQuery) + " (" + BuildQuery(std, subQuery) + ") ";
requiresParam = false;
}
}
else
{
compareTo = GetColumnName(comparisonData.ComparisonColumn);
requiresParam = false;
}
//.........这里部分代码省略.........
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:101，代码来源:QueryBuilder.cs
示例5: GetMathmaticalExpressionColumn
protected static string GetMathmaticalExpressionColumn(StandardProviderParameters std, esDynamicQuerySerializable query, esMathmaticalExpression mathmaticalExpression)
{
bool isMod = false;
bool needsRounding = false;
string sql = "(";
if (mathmaticalExpression.ItemFirst)
{
sql += GetExpressionColumn(std, query, mathmaticalExpression.SelectItem1, true, false);
sql += esArithmeticOperatorToString(mathmaticalExpression, out isMod, out needsRounding);
if (mathmaticalExpression.SelectItem2 != null)
{
sql += GetExpressionColumn(std, query, mathmaticalExpression.SelectItem2, true, false);
}
else
{
sql += GetMathmaticalExpressionLiteralType(std, mathmaticalExpression);
}
}
else
{
if (mathmaticalExpression.SelectItem2 != null)
{
sql += GetExpressionColumn(std, query, mathmaticalExpression.SelectItem2, true, true);
}
else
{
sql += GetMathmaticalExpressionLiteralType(std, mathmaticalExpression);
}
sql += esArithmeticOperatorToString(mathmaticalExpression, out isMod, out needsRounding);
sql += GetExpressionColumn(std, query, mathmaticalExpression.SelectItem1, true, false);
}
sql += ")";
if (isMod)
{
sql = "MOD(" + sql.Replace("(", String.Empty).Replace(")", String.Empty) + ")";
}
if (needsRounding)
{
sql = "ROUND(" + sql + ", 10)";
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:49，代码来源:QueryBuilder.cs
示例6: GetSelectStatement
protected static string GetSelectStatement(StandardProviderParameters std, esDynamicQuerySerializable query)
{
string sql = String.Empty;
string comma = String.Empty;
bool selectAll = true;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
if (query.es.Distinct) sql += " DISTINCT ";
if (query.es.Top >= 0) sql += " TOP " + query.es.Top.ToString() + " ";
if (iQuery.InternalSelectColumns != null)
{
selectAll = false;
foreach (esExpression expressionItem in iQuery.InternalSelectColumns)
{
if (expressionItem.Query != null)
{
IDynamicQuerySerializableInternal iSubQuery = expressionItem.Query as IDynamicQuerySerializableInternal;
sql += comma;
if (iSubQuery.SubQueryAlias == string.Empty)
{
sql += iSubQuery.JoinAlias + ".*";
}
else
{
iSubQuery.IsInSubQuery = true;
sql += " (" + BuildQuery(std, expressionItem.Query as esDynamicQuerySerializable) + ") AS " + iSubQuery.SubQueryAlias;
iSubQuery.IsInSubQuery = false;
}
comma = ",";
}
else
{
sql += comma;
string columnName = expressionItem.Column.Name;
if (columnName != null && columnName[0] == '<')
sql += columnName.Substring(1, columnName.Length - 2);
else
sql += GetExpressionColumn(std, query, expressionItem, false, true);
comma = ",";
}
}
sql += " ";
}
if (query.es.CountAll)
{
selectAll = false;
sql += comma;
sql += "COUNT(*)";
if (query.es.CountAllAlias != null)
{
// Need DBMS string delimiter here
sql += " AS " + Delimiters.StringOpen + query.es.CountAllAlias + Delimiters.StringClose;
}
}
if (selectAll)
{
sql += "*";
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:74，代码来源:QueryBuilder.cs
示例7: GetJoinStatement
protected static string GetJoinStatement(StandardProviderParameters std, esDynamicQuerySerializable query)
{
string sql = String.Empty;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
if (iQuery.InternalJoinItems != null)
{
foreach (esJoinItem joinItem in iQuery.InternalJoinItems)
{
esJoinItem.esJoinItemData joinData = (esJoinItem.esJoinItemData)joinItem;
switch (joinData.JoinType)
{
case esJoinType.InnerJoin:
sql += " INNER JOIN ";
break;
case esJoinType.LeftJoin:
sql += " LEFT JOIN ";
break;
case esJoinType.RightJoin:
sql += " RIGHT JOIN ";
break;
case esJoinType.FullJoin:
sql += " FULL JOIN ";
break;
}
IDynamicQuerySerializableInternal iSubQuery = joinData.Query as IDynamicQuerySerializableInternal;
sql += Shared.CreateFullName(std.request, joinData.Query);
sql += " " + iSubQuery.JoinAlias;
if (query.es.WithNoLock == true)
{
sql += " WITH (NOLOCK)";
}
sql += " ON ";
sql += GetComparisonStatement(std, query, joinData.WhereItems, String.Empty);
}
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:46，代码来源:QueryBuilder.cs
示例8: GetExpressionColumn
protected static string GetExpressionColumn(StandardProviderParameters std, esDynamicQuerySerializable query, esExpression expression, bool inExpression, bool useAlias)
{
string sql = String.Empty;
if (expression.CaseWhen != null)
{
return GetCaseWhenThenEnd(std, query, expression.CaseWhen);
}
if (expression.HasMathmaticalExpression)
{
sql += GetMathmaticalExpressionColumn(std, query, expression.MathmaticalExpression);
}
else
{
sql += GetColumnName(expression.Column);
}
if (expression.SubOperators != null)
{
if (expression.Column.Distinct)
{
sql = BuildSubOperationsSql(std, "DISTINCT " + sql, expression.SubOperators);
}
else
{
sql = BuildSubOperationsSql(std, sql, expression.SubOperators);
}
}
if (!inExpression && useAlias)
{
if (expression.SubOperators != null || expression.Column.HasAlias)
{
sql += " AS " + Delimiters.StringOpen + expression.Column.Alias + Delimiters.StringClose;
}
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:40，代码来源:QueryBuilder.cs
示例9: esCase
/// <summary>
/// The Constructor
/// </summary>
public esCase(esDynamicQuerySerializable query, esQueryItem queryItem)
{
this.data.Query = query;
this.data.QueryItem = queryItem;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:8，代码来源:esCase.cs
示例10: CreateFullName
static public string CreateFullName(esDynamicQuerySerializable query)
{
IDynamicQueryInternal iQuery = query as IDynamicQueryInternal;
string name = String.Empty;
if ((iQuery.Catalog != null || iQuery.ProviderMetadata.Catalog != null) &&
(iQuery.Schema != null || iQuery.ProviderMetadata.Schema != null))
{
name += Delimiters.TableOpen;
name += iQuery.Catalog != null ? iQuery.Catalog : iQuery.ProviderMetadata.Catalog;
name += Delimiters.TableClose + ".";
}
if (iQuery.Schema != null || iQuery.ProviderMetadata.Schema != null)
{
name += Delimiters.TableOpen;
name += iQuery.Schema != null ? iQuery.Schema : iQuery.ProviderMetadata.Schema;
name += Delimiters.TableClose + ".";
}
name += Delimiters.TableOpen;
if (query.es.QuerySource != null)
name += query.es.QuerySource;
else
name += iQuery.ProviderMetadata.Destination;
name += Delimiters.TableClose;
return name;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:30，代码来源:Shared.cs
示例11: GetGroupByStatement
protected static string GetGroupByStatement(StandardProviderParameters std, esDynamicQuerySerializable query)
{
string sql = String.Empty;
string comma = String.Empty;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
if (iQuery.InternalGroupByItems != null)
{
sql += " GROUP BY ";
foreach (esGroupByItem groupBy in iQuery.InternalGroupByItems)
{
sql += comma;
string columnName = groupBy.Expression.Column.Name;
if (columnName != null && columnName[0] == '<')
sql += columnName.Substring(1, columnName.Length - 2);
else
sql += GetExpressionColumn(std, query, groupBy.Expression, false, false);
comma = ",";
}
if (query.es.WithRollup)
{
sql += " WITH ROLLUP";
}
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:33，代码来源:QueryBuilder.cs
示例12: GetSetOperationStatement
protected static string GetSetOperationStatement(StandardProviderParameters std, esDynamicQuerySerializable query)
{
string sql = String.Empty;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
if (iQuery.InternalSetOperations != null)
{
foreach (esSetOperation setOperation in iQuery.InternalSetOperations)
{
switch (setOperation.SetOperationType)
{
case esSetOperationType.Union: sql += " UNION "; break;
case esSetOperationType.UnionAll: sql += " UNION ALL "; break;
case esSetOperationType.Intersect: sql += " INTERSECT "; break;
case esSetOperationType.Except: sql += " EXCEPT "; break;
}
sql += BuildQuery(std, setOperation.Query);
}
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:24，代码来源:QueryBuilder.cs
示例13: GetSubquerySearchCondition
private static string GetSubquerySearchCondition(esDynamicQuerySerializable query)
{
string searchCondition = String.Empty;
IDynamicQuerySerializableInternal iQuery = query as IDynamicQuerySerializableInternal;
switch (iQuery.SubquerySearchCondition)
{
case esSubquerySearchCondition.All: searchCondition = "ALL"; break;
case esSubquerySearchCondition.Any: searchCondition = "ANY"; break;
case esSubquerySearchCondition.Some: searchCondition = "SOME"; break;
}
return searchCondition;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:15，代码来源:QueryBuilder.cs
示例14: GetCaseWhenThenEnd
protected static string GetCaseWhenThenEnd(StandardProviderParameters std, esDynamicQuerySerializable query, esCase caseWhenThen)
{
string sql = string.Empty;
EntitySpaces.DynamicQuery.esCase.esSimpleCaseData caseStatement = caseWhenThen;
esColumnItem column = caseStatement.QueryItem;
sql += Delimiters.ColumnOpen + column.Alias + Delimiters.ColumnClose + " = ";
sql += "CASE ";
List<esComparison> list = new List<esComparison>();
foreach (EntitySpaces.DynamicQuery.esCase.esSimpleCaseData.esCaseClause caseClause in caseStatement.Cases)
{
sql += " WHEN ";
if (!caseClause.When.IsExpression)
{
sql += GetComparisonStatement(std, query, caseClause.When.Comparisons, string.Empty);
}
else
{
if (!caseClause.When.Expression.IsLiteralValue)
{
sql += GetExpressionColumn(std, query, caseClause.When.Expression, false, true);
}
else
{
if (caseClause.When.Expression.LiteralValue is string)
{
sql += Delimiters.StringOpen + caseClause.When.Expression.LiteralValue + Delimiters.StringClose;
}
else
{
sql += Convert.ToString(caseClause.When.Expression.LiteralValue);
}
}
}
sql += " THEN ";
if (!caseClause.Then.IsLiteralValue)
{
sql += GetExpressionColumn(std, query, caseClause.Then, false, true);
}
else
{
if (caseClause.Then.LiteralValue is string)
{
sql += Delimiters.StringOpen + caseClause.Then.LiteralValue + Delimiters.StringClose;
}
else
{
sql += Convert.ToString(caseClause.Then.LiteralValue);
}
}
}
if (caseStatement.Else != null)
{
sql += " ELSE ";
if (!caseStatement.Else.IsLiteralValue)
{
sql += GetExpressionColumn(std, query, caseStatement.Else, false, true);
}
else
{
if (caseStatement.Else.LiteralValue is string)
{
sql += Delimiters.StringOpen + caseStatement.Else.LiteralValue + Delimiters.StringClose;
}
else
{
sql += Convert.ToString(caseStatement.Else.LiteralValue);
}
}
}
sql += " END ";
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:83，代码来源:QueryBuilder.cs
示例15: ApplyWhereSubOperations
protected static string ApplyWhereSubOperations(StandardProviderParameters std, esDynamicQuerySerializable query, esComparison.esComparisonData comparisonData)
{
string sql = string.Empty;
string delimitedColumnName = GetColumnName(comparisonData.Column);
if (comparisonData.SubOperators != null)
{
sql = BuildSubOperationsSql(std, delimitedColumnName, comparisonData.SubOperators);
}
else
{
sql = delimitedColumnName;
}
return sql;
}
开发者ID:stacyjeptha，项目名称:EntitySpaces-Architecture，代码行数:16，代码来源:QueryBuilder.cs
注：本文中的esDynamicQuerySerializable类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论