public SqlCondition AddHaving(ExpressionOperation operation, string exp)
{
var condition = new SqlCondition(operation, exp);
if (_currentHavingExp != null)
{
_currentHavingExp.AddCondition(condition);
}
else
{
if (HavingConditions == null)
{
HavingConditions = new List <SqlConditionItem>();
}
HavingConditions.Add(condition);
}
return(condition);
}
public SqlExpression AddHavingExp(ExpressionOperation operation)
{
if (HavingConditions == null)
{
HavingConditions = new List <SqlConditionItem>();
}
var condition = new SqlExpression(operation);
if (_currentHavingExp != null)
{
_currentHavingExp.AddCondition(condition);
}
else
{
HavingConditions.Add(condition);
}
_currentHavingExp = condition;
return(condition);
}
public SelectQuery HavingLowerEqualThanAggregate(object havingLowerEqualThanValue, AggregateFunction aggregateFunction, string columnName, bool distinct = false)
{
HavingConditions.Last().Add(Query.ConditionComparatorAggregate(havingLowerEqualThanValue, aggregateFunction, columnName, distinct, Query.LowerEqualThan));
return(this);
}
public SelectQuery HavingOr()
{
HavingConditions.Add(new List <string>());
return(this);
}
