public WhereList OR(string tableName, string columnName, WhereComparison comparison, string otherTableName, string otherColumnName)
{
var wl = new WhereList();
wl.Add(this);
return wl.OR(tableName, columnName, comparison, otherTableName, otherColumnName);
}
public WhereMemberExpression(string field, object value, WhereComparison comparison)
{
this.FieldName = field;
this.Value = value;
this.Comparison = comparison;
}
public WhereList OR(object thisObject, ValueObjectType thisObjectType, WhereComparison comparison, object thatObject, ValueObjectType thatObjectType)
{
var wl = new WhereList();
wl.Add(this);
return wl.OR(thisObject, thisObjectType, comparison, thatObject, thatObjectType);
}
public WhereList OR(IPhrase phrase, WhereComparison comparison, string tableName, string columnName)
{
var wl = new WhereList();
wl.Add(this);
return wl.OR(phrase, comparison, tableName, columnName);
}
public Where(WhereCondition condition, IPhrase phrase, WhereComparison comparison, string tableName, string columnName)
{
Condition = condition;
First = phrase;
FirstType = ValueObjectType.Value;
Comparison = comparison;
SecondTableName = tableName;
Second = columnName;
SecondType = ValueObjectType.ColumnName;
}
public Where(WhereCondition condition, Query query, WhereComparison comparison, string tableName, string columnName)
{
Condition = condition;
First = query;
FirstType = ValueObjectType.Value;
Comparison = comparison;
SecondTableName = tableName;
Second = columnName;
SecondType = ValueObjectType.ColumnName;
}
public Query Having(WhereCondition condition, object thisObject, ValueObjectType thisObjectType, WhereComparison comparison, object thatObject, ValueObjectType thatObjectType)
{
return Having(new Where(condition, thisObject, thisObjectType, comparison, thatObject, thatObjectType));
}
public Where(WhereCondition condition,
string tableName, string columnName,
WhereComparison comparedBy, string thatTableName, string thatColumnName)
{
Condition = condition;
Comparison = comparedBy;
FirstTableName = tableName;
First = columnName;
FirstType = ValueObjectType.ColumnName;
SecondTableName = thatTableName;
Second = thatColumnName;
SecondType = ValueObjectType.ColumnName;
}
public Query Having(IPhrase phrase, WhereComparison comparison, object value, ValueObjectType valueType = ValueObjectType.Value)
{
return Having(WhereCondition.AND, phrase, comparison, value, valueType);
}
public Query Having(Query query, WhereComparison comparison, string tableName, string columnName)
{
return Having(WhereCondition.AND, query, comparison, tableName, columnName);
}
public Query Having(string tableName, string columnName, WhereComparison comparison, string otherTableName, string otherColumnName)
{
return Having(WhereCondition.AND, tableName, columnName, comparison, otherTableName, otherColumnName);
}
public Query Having(string tableName, string columnName, WhereComparison comparison, object value)
{
return Having(WhereCondition.AND, tableName, columnName, comparison, value);
}
public Query Where(Query query, WhereComparison comparison, object value, ValueObjectType valueType = ValueObjectType.Value)
{
return Where(new Where(WhereCondition.AND, query, comparison, value, valueType));
}
public Query Where(Query query, WhereComparison comparison, string tableName, string columnName)
{
return Where(new Where(WhereCondition.AND, query, comparison, tableName, columnName));
}
public Query Having(WhereCondition condition, string columnName, WhereComparison comparison, object value)
{
return Having(new Where(condition, columnName, ValueObjectType.ColumnName, comparison, value, ValueObjectType.Value));
}
public Where(WhereCondition condition, object thisObject, ValueObjectType thisObjectType, WhereComparison comparedBy, object thatObject, ValueObjectType thatObjectType)
{
Condition = condition;
Comparison = comparedBy;
First = thisObject;
FirstType = thisObjectType;
Second = thatObject;
SecondType = thatObjectType;
}
public Query Having(WhereCondition condition, string tableName, string columnName, WhereComparison comparison, object value)
{
Having(new Where(condition, tableName, columnName, comparison, value));
return this;
}
public Where(WhereCondition condition, IPhrase phrase, WhereComparison comparison, object value, ValueObjectType valueType = ValueObjectType.Value)
{
Condition = condition;
First = phrase;
FirstType = ValueObjectType.Value;
Comparison = comparison;
Second = value;
SecondType = valueType;
}
public Query Having(WhereCondition condition, string tableName, string columnName, WhereComparison comparison, string otherTableName, string otherColumnName)
{
Having(new Where(condition, tableName, columnName, comparison, otherTableName, otherColumnName));
return this;
}
public Where(WhereCondition condition, Query query, WhereComparison comparison, object value, ValueObjectType valueType = ValueObjectType.Value)
{
Condition = condition;
First = query;
FirstType = ValueObjectType.Value;
Comparison = comparison;
Second = value;
SecondType = valueType;
}
public Query Having(WhereCondition condition, IPhrase phrase, WhereComparison comparison, string tableName, string columnName)
{
return Having(new Where(condition, phrase, comparison, tableName, columnName));
}
public WhereList AND(IPhrase phrase, WhereComparison comparison, object value)
{
var wl = new WhereList();
wl.Add(this);
return wl.AND(phrase, comparison, value);
}
public Query Having(WhereCondition condition, Query query, WhereComparison comparison, string tableName, string columnName)
{
return Having(new Where(condition, query, comparison, tableName, columnName));
}
public WhereList OR(IPhrase phrase, WhereComparison comparison, object value, ValueObjectType valueType)
{
var wl = new WhereList();
wl.Add(this);
return wl.OR(phrase, comparison, value, valueType);
}
public Query Having(WhereCondition condition, Query query, WhereComparison comparison, object value, ValueObjectType valueType = ValueObjectType.Value)
{
return Having(new Where(condition, query, comparison, value, valueType));
}
public WhereList OR(string tableName, string columnName, WhereComparison comparison, object columnValue)
{
var wl = new WhereList();
wl.Add(this);
return wl.OR(tableName, columnName, comparison, columnValue);
}
public Where(string tableName, string columnName,
WhereComparison comparedBy, object value)
{
Comparison = comparedBy;
FirstTableName = tableName;
First = columnName;
FirstType = ValueObjectType.ColumnName;
Second = value;
SecondType = ValueObjectType.Value;
}
public Where(object thisLiteral, WhereComparison comparedBy, object thatLiteral)
{
Comparison = comparedBy;
First = thisLiteral;
Second = thatLiteral;
}
public Where(IPhrase phrase, WhereComparison comparison, object value)
{
First = phrase;
FirstType = ValueObjectType.Value;
Comparison = comparison;
Second = value;
SecondType = ValueObjectType.Value;
}
public WhereMemberExpression(string field, object value, WhereComparison comparison)
{
this.FieldName = field;
this.Value = value;
this.Comparison = comparison;
}
public Query Where(IPhrase phrase, WhereComparison comparison, object value, ValueObjectType valueType = ValueObjectType.Value)
{
return Where(new Where(WhereCondition.AND, phrase, comparison, value, valueType));
}
