private string Values(
IEnumerable <string> valueCollection,
SqlContainer sqlContainer,
SqlCommand sqlCommand,
int?commandCount)
{
if (Select == null)
{
return("values(" + valueCollection.Join() + "); ");
}
else
{
if (AddUpdatorParam)
{
Select.SqlColumnCollection.InsertRange(0, new List <SqlColumn>
{
new SqlColumn("@_U as [Creator]"),
new SqlColumn("@_U as [Updator]")
});
}
return(Select.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: "_sub",
commandCount: commandCount));
}
}
private IEnumerable <string> Left(
ISqlObjectFactory factory,
SqlContainer sqlContainer,
ISqlCommand sqlCommand,
int?commandCount)
{
if (SubLeft != null)
{
return(new List <string>
{
"(" + SubLeft.GetCommandText(
factory: factory,
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: SubPrefix
? "_sub"
: null,
commandCount: commandCount) + ")"
});
}
else
{
return(ColumnBrackets);
}
}
private string Sql_Sub(
SqlContainer sqlContainer,
SqlCommand sqlCommand,
IEnumerable <string> left,
string tableBracket,
int?commandCount,
bool select)
{
var commandText = Sub.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: SubPrefix
? "_sub"
: null,
commandCount: commandCount);
return(left != null
? left.Select(columnBracket =>
TableAndColumnBracket(
tableBracket : tableBracket,
columnBracket : columnBracket,
select : select) +
Operator +
"(" + commandText + ")")
.Join(MultiColumnOperator)
: Value == null
? "(" + commandText + ")"
: "(" + commandText + Operator + Value + ")");
}
private string Sql_Sub(
SqlContainer sqlContainer,
SqlCommand sqlCommand,
IEnumerable <string> left,
Sqls.TableTypes tableType,
int?commandCount)
{
var commandText = Sub.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: "_sub",
commandCount: commandCount);
return(left != null
? left.Select(columnBracket =>
Sqls.TableAndColumnBracket(
tableName : TableName,
tableType : tableType,
columnBracket : columnBracket) +
Operator +
"(" + commandText + ")")
.Join(MultiColumnOperator)
: Value == null
? "(" + commandText + ")"
: "(" + commandText + Operator + Value + ")");
}
private string Values(
ISqlObjectFactory factory,
IEnumerable <string> valueCollection,
SqlContainer sqlContainer,
ISqlCommand sqlCommand,
int?commandCount)
{
if (Select == null)
{
return("values(" + valueCollection.Join() + ")" +
factory.SqlCommandText.CreateSelectStatementTerminator(SelectIdentity) +
" ");
}
else
{
if (AddUpdatorParam)
{
Select.SqlColumnCollection.InsertRange(0, new List <SqlColumn>
{
new SqlColumn($"{Parameters.Parameter.SqlParameterPrefix}U as \"Creator\""),
new SqlColumn($"{Parameters.Parameter.SqlParameterPrefix}U as \"Updator\"")
});
}
return(Select.GetCommandText(
factory: factory,
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: "_sub",
commandCount: commandCount));
}
}
private string Sql_Sub(
SqlContainer sqlContainer,
SqlCommand sqlCommand,
string orderType)
{
return("(" + Sub.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand) + ")"
+ orderType);
}
private string Sql_Sub(SqlContainer sqlContainer, SqlCommand sqlCommand, int?commandCount)
{
return("(" + Sub.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: "_sub",
commandCount: commandCount) + ")" +
(As != null
? " as [" + As + "]"
: string.Empty));
}
private string Sql_Sub(
ISqlObjectFactory factory,
SqlContainer sqlContainer,
ISqlCommand sqlCommand,
string orderType)
{
return("(" + Sub.GetCommandText(
factory: factory,
sqlContainer: sqlContainer,
sqlCommand: sqlCommand) + ")"
+ orderType);
}
private string Sql_Sub(
ISqlObjectFactory factory,
SqlContainer sqlContainer,
ISqlCommand sqlCommand,
int?commandCount)
{
return("(" + Sub.GetCommandText(
factory: factory,
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: SubPrefix
? "_sub"
: null,
commandCount: commandCount) + ")" +
(As != null
? " as \"" + As + "\""
: string.Empty));
}
private string Sql_Sub(
SqlContainer sqlContainer,
SqlCommand sqlCommand,
Sqls.TableTypes tableType,
int?commandCount)
{
var commandText = Sub.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: "_sub",
commandCount: commandCount);
return(ColumnBracket != null
? Functions(tableType) + Operator + "(" + commandText + ")"
: Value == null
? "(" + commandText + ")"
: "(" + commandText + Operator + Value + ")");
}
private string Sql_Sub(
SqlContainer sqlContainer,
SqlCommand sqlCommand,
string tableBracket,
int?commandCount)
{
var commandText = Sub.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: SubPrefix
? "_sub"
: string.Empty,
commandCount: commandCount);
return(ColumnBracket != null
? Functions(tableBracket) + Operator + "(" + commandText + ")"
: Value == null
? "(" + commandText + ")"
: "(" + commandText + Operator + Value + ")");
}
private IEnumerable <string> Left(
SqlContainer sqlContainer,
SqlCommand sqlCommand,
int?commandCount)
{
if (SubLeft != null)
{
return(new List <string>
{
"(" + SubLeft.GetCommandText(
sqlContainer: sqlContainer,
sqlCommand: sqlCommand,
prefix: "_sub",
commandCount: commandCount) + ")"
});
}
else
{
return(ColumnBrackets);
}
}
