public static HavingFilterCollection HavingColumnValue(this HavingFilterCollection query, Aggregate aggregate, string leftTableAlias, string leftField, Compare comparison, string rightValue, DbType rightType, string parameterAlias = null, string isNullValue = null)
{
var HavingFilter = new ColumnValueHavingFilter()
{
Aggregate = aggregate,
LeftColumn = new Column(leftTableAlias, leftField),
Operator = comparison,
RightValue = new LiteralValue(rightValue, rightType),
ParameterAlias = parameterAlias,
IsNullValue = isNullValue
};
query.Add(HavingFilter);
return(query);
}
public static HavingFilterCollection Having(this HavingFilterCollection query, string sql)
{
query.Add(new SqlHavingFilter(sql));
return(query);
}
public static HavingFilterCollection HavingCollection(this HavingFilterCollection query, Combine groupingOperator, HavingFilterCollection collection)
{
collection.GroupingOperator = groupingOperator;
query.Add(collection);
return(query);
}