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); }