private void WriteSelect(ParserWriter writer, APSqlSelectCommand command)
{
writer.WriteDirect("SELECT");
if (command.SelectMode == APSqlSelectMode.DISTINCT)
{
writer.Write("DISTINCT");
}
APSqlSelectPhrase phrase = command.SelectExprClause.Next as APSqlSelectPhrase;
bool isFirst = true;
while (phrase != null)
{
if (!isFirst)
{
writer.Write(',');
}
else
{
isFirst = false;
}
WriteSelectExpression(writer, phrase.Expr);
if (!string.IsNullOrEmpty(phrase.Alias))
{
writer.Write("AS " + JudgeAliasName(phrase.Alias));
}
phrase = phrase.Next as APSqlSelectPhrase;
}
}
private void WriteInsertWithSubQuery(ParserWriter writer, APSqlInsertCommand command)
{
writer.WriteDirect("INSERT INTO");
writer.Write(command.TableDef.TableName);
if (command.SelectClause != null)
{
writer.Write("(");
APSqlSelectPhrase phrase = command.SelectClause.Next as APSqlSelectPhrase;
bool isFirst = true;
while (phrase != null)
{
if (!isFirst)
{
writer.Write(',');
}
else
{
isFirst = false;
}
WriteSelectExpression(writer, phrase.Expr);
phrase = phrase.Next as APSqlSelectPhrase;
}
writer.Write(")");
}
}
/// <summary>
/// Create a new 'SELECT' clause with 'SELECT' phrase.
/// </summary>
/// <param name="phrase">The 'SELECT' phrase.</param>
public APSqlSelectClause(APSqlSelectPhrase phrase)
{
SetNext(phrase);
}
/// <summary>
/// Create a new 'SELECT' command with 'SELECT' phrase.
/// </summary>
/// <param name="phrase">The 'SELECT' phrase.</param>
public APSqlSelectCommand(APSqlSelectPhrase phrase)
{
_selectExprClause = new APSqlSelectClause(phrase);
}
/// <summary>
/// Create a new 'SELECT' command with 'SELECT' phrase.
/// </summary>
/// <param name="phrase">The 'SELECT' phrase.</param>
public static APSqlSelectCommand select(APSqlSelectPhrase phrase)
{
return new APSqlSelectCommand(phrase);
}
/// <summary>
/// Create a new 'SELECT' command with 'SELECT' phrase.
/// </summary>
/// <param name="phrase">The 'SELECT' phrase.</param>
public APSqlSelectCommand(APSqlSelectPhrase phrase)
{
_selectExprClause = new APSqlSelectClause(phrase);
}
/// <summary>
/// Create a new 'SELECT' clause with 'SELECT' phrase.
/// </summary>
/// <param name="phrase">The 'SELECT' phrase.</param>
public APSqlSelectClause(APSqlSelectPhrase phrase)
{
SetNext(phrase);
}
/// <summary>
/// Create a new 'SELECT' command with 'SELECT' phrase.
/// </summary>
/// <param name="phrase">The 'SELECT' phrase.</param>
public static APSqlSelectCommand select(APSqlSelectPhrase phrase)
{
return(new APSqlSelectCommand(phrase));
}