private void WriteGroupBy(ParserWriter writer, APSqlGroupByClause clause, OracleCommand dbCmd)
{
if (clause != null && clause.Next != null)
{
writer.WriteLine();
writer.WriteDirect("GROUP BY");
APSqlExprPhrase phrase = clause.Next as APSqlExprPhrase;
bool isFirst = true;
while (phrase != null)
{
if (!isFirst)
{
writer.Write(',');
}
else
{
isFirst = false;
}
WriteSelectExpression(writer, phrase.Expr);
//writer.Write(phrase.Expr.SelectExpr);
phrase = phrase.Next as APSqlExprPhrase;
}
}
}
/// <summary>
/// SQL 'GROUP BY' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="clause">The 'GROUP BY' clause.</param>
/// <returns>The command.</returns>
public static APSqlSelectCommand group_by(this APSqlSelectCommand command, APSqlGroupByClause clause)
{
command.GroupByClause = clause;
return(command);
}
private void WriteGroupBy(ParserWriter writer, APSqlGroupByClause clause, SqlCommand dbCmd)
{
if (clause != null && clause.Next != null)
{
writer.WriteLine();
writer.WriteDirect("GROUP BY");
APSqlExprPhrase phrase = clause.Next as APSqlExprPhrase;
bool isFirst = true;
while (phrase != null)
{
if (!isFirst)
writer.Write(',');
else
isFirst = false;
WriteSelectExpression(writer, phrase.Expr);
//writer.Write(phrase.Expr.SelectExpr);
phrase = phrase.Next as APSqlExprPhrase;
}
}
}