private void WriteOrderBy(ParserWriter writer, APSqlOrderByClause clause)
{
if (clause != null && clause.Next != null)
{
writer.WriteLine();
writer.WriteDirect("ORDER BY");
APSqlOrderPhrase phrase = clause.Next;
bool isFirst = true;
while (phrase != null)
{
if (!isFirst)
{
writer.Write(',');
}
else
{
isFirst = false;
}
WriteSelectExpression(writer, phrase.Expr);
if (phrase.OrderAccording == APSqlOrderAccording.Desc)
{
writer.Write("DESC");
}
phrase = phrase.Next as APSqlOrderPhrase;
}
}
}
/// <summary>
/// SQL 'ORDER BY' clause extensions.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="clause">The 'ORDER BY' clause.</param>
/// <returns>The command.</returns>
public static APSqlSelectCommand order_by(this APSqlSelectCommand command, APSqlOrderByClause clause)
{
command.OrderByClause = clause;
return(command);
}
private void WriteOrderBy(ParserWriter writer, APSqlOrderByClause clause)
{
if (clause != null && clause.Next != null)
{
writer.WriteLine();
writer.WriteDirect("ORDER BY");
APSqlOrderPhrase phrase = clause.Next;
bool isFirst = true;
while (phrase != null)
{
if (!isFirst)
writer.Write(',');
else
isFirst = false;
WriteSelectExpression(writer, phrase.Expr);
if (phrase.OrderAccording == APSqlOrderAccording.Desc)
writer.Write("DESC");
phrase = phrase.Next as APSqlOrderPhrase;
}
}
}