public WhereClip Or(WhereClip where)
{
if (WhereClip.IsNullOrEmpty(where) || where.Sql.Length == 0)
{
return(this);
}
if (sql.Length > 0)
{
sql.Append(" OR ");
}
if (where.isNot && where.sql.Length > 0)
{
sql.Append("NOT ");
}
if (where.sql.Length > 0)
{
sql.Append('(');
sql.Append(where.sql);
sql.Append(')');
}
SqlQueryUtils.AddParameters(parameters, where);
return(this);
}
internal void SetHaving(WhereClip where)
{
if (string.IsNullOrEmpty(where.Sql))
{
Having = string.Empty;
return;
}
Having = where.Sql;
SqlQueryUtils.AddParameters(parameters, where);
}
public WhereClip Or(ExpressionClip left, QueryOperator op, ExpressionClip right)
{
if (this.sql.Length > 0)
{
this.sql.Append(" OR ");
}
this.sql.Append(SqlQueryUtils.ToString(left));
this.sql.Append(SqlQueryUtils.ToString(op));
this.sql.Append(SqlQueryUtils.ToString(right));
SqlQueryUtils.AddParameters(this.parameters, left);
SqlQueryUtils.AddParameters(this.parameters, right);
return(this);
}
