/// <summary>
/// Add a another condition to the HAVING Clause that need to be true
/// </summary>
/// <param name="having">The HAVING Clause to add</param>
public virtual Having And(Having having)
{
if (having == null)
{
throw new System.ArgumentNullException();
}
Havings.Add(having);
return(this);
}
/// <summary>
/// Add a another condition to the HAVING Clause that can be true instead
/// </summary>
/// <param name="having">The HAVING Clause to add</param>
public virtual Having Or(Having having)
{
if (having == null)
{
throw new System.ArgumentNullException();
}
having.IsAnd = false;
Havings.Add(having);
return(this);
}
protected string BuildHavingClause()
{
return(!Havings.Any() ? string.Empty : "\nHAVING " + string.Join("\n, ", Havings));
}
public void AdicionarCondicaoAgrupamento(string condicao)
{
Havings.Add("(" + condicao + ")");
}
public void AdicionarCondicaoAgrupamento(string condicao)
{
Havings.Add(string.Concat("(", condicao, ")"));
}
private string BuildHavingClause()
{
return(!Havings.Any() ? string.Empty : $"\nHAVING {string.Join("\n, ", Havings)}");
}
