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)); }