public CondGroup <TDbParam> Add(Cond <TDbParam> cond)
{
// Empty cond makes an empty SQL.
var cSql = (cond == null ? string.Empty : cond.FetchSql());
if (string.IsNullOrEmpty(cSql))
{
return(this);
}
// append SQL
if (string.IsNullOrEmpty(Sql))
{
Sql = $"({cSql})";
}
else
{
Sql += $" {CondJoin} ({cSql})";
}
// push parameters
Debug.Assert(cond != null, ""); // Never asserts
DbParams.AddRange(cond.FetchDbParams());
return(this);
}
public CondRaw(string raw, IEnumerable <TDbParam> paramList = null)
{
// Null or empty raw string makes an empty SQL:
if (string.IsNullOrEmpty(raw))
{
return;
}
Sql = raw;
if (paramList != null)
{
DbParams.AddRange(paramList);
}
}
public CondNot(Cond <TDbParam> cond)
{
// Empty cond makes an empty SQL.
var cSql = (cond == null ? string.Empty : cond.FetchSql());
if (string.IsNullOrEmpty(cSql))
{
return;
}
// set SQL
Sql = $"NOT ({cSql})";
// push parameters
Debug.Assert(cond != null, ""); // Never asserts
DbParams.AddRange(cond.FetchDbParams());
}
