public GroupByList Append(bool copyToColumns, params string[] columns)
{
foreach (string column in columns)
{
GroupBy expression = new GroupBy(column);
this.Append(expression, copyToColumns);
}
return(this);
}
public GroupByList Append(GroupBy expression, bool copyToColumns = false)
{
this._expressions.Add(expression);
if (copyToColumns)
{
this.Columns.Append(expression.Column);
}
return(this);
}
public IGroupByList Raw(params string[] rawSql)
{
foreach (string sql in rawSql)
{
GroupBy expression = new GroupBy(sql)
{
IsRaw = true,
TableAlias = string.Empty,
};
this.Append(expression);
}
return(this);
}
public IGroupByList Append(bool copyToColumns = false, params string[] columns)
{
foreach (string column in columns)
{
GroupBy expression = new GroupBy(column)
{
IsRaw = false,
TableAlias = this.TableAlias,
};
this.Append(expression, copyToColumns);
}
return(this);
}
public GroupByList AppendWithColumn(GroupBy expression, string column, string columnAlias, string prefix = "", string postfix = "")
{
this._expressions.Add(expression);
this.Columns.AppendAlias(column, columnAlias, prefix, postfix);
return(this);
}