|
private AppendSelect ( string commandText, Clauses clauses, SegmentPositions segmentPositions ) : |
||
| commandText | string | |
| clauses | Clauses | |
| segmentPositions | SegmentPositions | |
| Результат | ||
/// <summary>
/// Parses the specified command text into a SqlString instance populating the specified <see cref="Clauses"/> if
/// present in the command text.
/// </summary>
/// <param name="commandText">The SQL command text.</param>
/// <param name="clauses">The clauses to include in the SqlString.</param>
/// <returns>An SqlString instance populating the specified <see cref="Clauses"/> if present in the command text.</returns>
public static SqlString Parse(string commandText, Clauses clauses)
{
if (string.IsNullOrEmpty(commandText))
{
return(new SqlString());
}
if (commandText.Contains(Environment.NewLine))
{
commandText = commandText.Replace(Environment.NewLine, " ");
}
var segmentPositions = SegmentPositions.GetSegmentPositions(commandText);
var sqlString = new SqlString();
sqlString.AppendSelect(commandText, clauses, segmentPositions)
.AppendFrom(commandText, clauses, segmentPositions)
.AppendWhere(commandText, clauses, segmentPositions)
.AppendGroupBy(commandText, clauses, segmentPositions)
.AppendOrderBy(commandText, clauses, segmentPositions);
return(sqlString);
}
/// <summary>
/// Parses the specified command text into a SqlString instance populating the specified <see cref="Clauses"/> if
/// present in the command text.
/// </summary>
/// <param name="commandText">The SQL command text.</param>
/// <param name="clauses">The clauses to include in the SqlString.</param>
/// <returns>An SqlString instance populating the specified <see cref="Clauses"/> if present in the command text.</returns>
public static SqlString Parse(string commandText, Clauses clauses)
{
if (string.IsNullOrEmpty(commandText))
{
return new SqlString();
}
if (commandText.Contains(Environment.NewLine))
{
commandText = commandText.Replace(Environment.NewLine, " ");
}
var segmentPositions = SegmentPositions.GetSegmentPositions(commandText);
var sqlString = new SqlString();
sqlString.AppendSelect(commandText, clauses, segmentPositions)
.AppendFrom(commandText, clauses, segmentPositions)
.AppendWhere(commandText, clauses, segmentPositions)
.AppendGroupBy(commandText, clauses, segmentPositions)
.AppendOrderBy(commandText, clauses, segmentPositions);
return sqlString;
}
