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