protected static string GetExpressionColumn(esExpression expression, bool inExpression, bool useAlias) { string sql = String.Empty; if (expression.HasMathmaticalExpression) { sql += GetMathmaticalExpressionColumn(expression.MathmaticalExpression); } else { sql += GetColumnName(expression.Column); } if (expression.SubOperators != null) { if (expression.Column.Distinct) { sql = BuildSubOperationsSql("DISTINCT " + sql, expression.SubOperators); } else { sql = BuildSubOperationsSql(sql, expression.SubOperators); } } if (!inExpression && useAlias) { if (expression.SubOperators != null || expression.Column.HasAlias) { sql += " AS " + Delimiters.StringOpen + expression.Column.Alias + Delimiters.StringClose; } } return(sql); }
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); }