public string Sql(string tableBracket, Sqls.TableTypes tableType)
{
string columnBracket = Sqls.TableAndColumnBracket(
tableBracket:
tableType == Sqls.TableTypes.NormalAndHistory
? string.Empty
: tableBracket,
columnBracket: ColumnBracket);
var orderType = " " + OrderType.ToString().ToLower();
switch (Function)
{
case Sqls.Functions.Count:
case Sqls.Functions.Sum:
case Sqls.Functions.Min:
case Sqls.Functions.Max:
case Sqls.Functions.Avg:
return
(Function.ToString().ToLower() +
"(" +
columnBracket +
")" +
orderType);
default:
return(columnBracket + orderType);
}
}
public string Sql(Sqls.TableTypes tableType, Sqls.UnionTypes unionType)
{
var columnBracket = Sqls.TableAndColumnBracket(
tableName: unionType == Sqls.UnionTypes.None
? TableName
: null,
tableType: tableType,
columnBracket: ColumnBracket);
var orderType = " " + OrderType.ToString().ToLower();
switch (Function)
{
case Sqls.Functions.Count:
case Sqls.Functions.Sum:
case Sqls.Functions.Min:
case Sqls.Functions.Max:
case Sqls.Functions.Avg:
return
(Function.ToString().ToLower() +
"(" +
columnBracket +
")" +
orderType);
default:
return(columnBracket + orderType);
}
}
