public void AddRange(WhereClause[] val)
{
for (int i = 0; i < val.Length; i++)
{
this.Add(val[i]);
}
}
private string RenderSelect(SelectQuery query, int limitRows)
{
query.Validate();
StringBuilder builder = new StringBuilder();
this.Select(builder, query.Distinct);
this.SelectColumns(builder, query.Columns);
this.FromClause(builder, query.FromClause, query.TableSpace);
WhereClause group = new WhereClause(WhereClauseRelationship.And);
group.SubClauses.Add(query.WherePhrase);
if (limitRows > -1)
{
group.Terms.Add(WhereTerm.CreateCompare(SqlExpression.PseudoField("rownum"), SqlExpression.Number(limitRows), CompareOperator.LessOrEqual));
}
this.Where(builder, group);
this.WhereClause(builder, group);
this.GroupBy(builder, query.GroupByTerms);
if (query.GroupByWithCube)
{
builder.Append(" cube (");
}
else if (query.GroupByWithRollup)
{
builder.Append(" rollup (");
}
this.GroupByTerms(builder, query.GroupByTerms);
if (query.GroupByWithCube || query.GroupByWithRollup)
{
builder.Append(" )");
}
this.Having(builder, query.HavingPhrase);
this.WhereClause(builder, query.HavingPhrase);
this.OrderBy(builder, query.OrderByTerms);
this.OrderByTerms(builder, query.OrderByTerms);
return builder.ToString();
}
public WhereClause Clone()
{
WhereClause clause = new WhereClause();
clause.relationship = this.relationship;
clause.whereTerms = new WhereTermCollection(this.whereTerms);
foreach (WhereClause clause2 in this.clauses)
{
clause.clauses.Add(clause2.Clone());
}
return clause;
}
public void Remove(WhereClause val)
{
base.List.Remove(val);
}
public void Insert(int index, WhereClause val)
{
base.List.Insert(index, val);
}
public int IndexOf(WhereClause val)
{
return base.List.IndexOf(val);
}
public void CopyTo(WhereClause[] array, int index)
{
base.List.CopyTo(array, index);
}
public bool Contains(WhereClause val)
{
return base.List.Contains(val);
}
public int Add(WhereClause val)
{
return base.List.Add(val);
}
public WhereClauseCollection(WhereClause[] val)
{
this.AddRange(val);
}
public CaseTerm(WhereClause condition, SqlExpression val)
{
this.cond = condition;
this.val = val;
}