public Query Where(string tableName, string columnName, WhereComparision comparison, object value)
{
if (_ListWhere == null) _ListWhere = new WhereList();
_ListWhere.Clear();
_ListWhere.Add(new Where(WhereCondition.AND, tableName, columnName, comparison, value));
return this;
}
public Query AddWhere(string tableName, string columnName, WhereComparision comparison, string otherTableName, string otherColumnName)
{
if (_ListWhere == null) _ListWhere = new WhereList();
_ListWhere.Add(new Where(WhereCondition.AND, tableName, columnName, comparison, otherTableName, otherColumnName));
return this;
}
public Query AddWhere(string columnName, WhereComparision comparison, object value)
{
return Where(new Where(WhereCondition.AND, columnName, ValueObjectType.ColumnName, comparison, value, ValueObjectType.Value), false);
}
public Query AddWhere(WhereCondition condition, object thisObject, ValueObjectType thisObjectType, WhereComparision comparison, object thatObject, ValueObjectType thatObjectType)
{
return Where(new Where(condition, thisObject, thisObjectType, comparison, thatObject, thatObjectType), false);
}
public Query OR(string tableName, string columnName, WhereComparision comparison, string otherTableName, string otherColumnName)
{
return Where(new Where(WhereCondition.OR, tableName, columnName, comparison, otherTableName, otherColumnName), false);
}
public Query OR(string tableName, string columnName, WhereComparision comparison, object value)
{
return Where(new Where(WhereCondition.OR, tableName, columnName, comparison, value), false);
}
public Where(object thisObject, ValueObjectType thisObjectType, WhereComparision comparedBy, object thatObject, ValueObjectType thatObjectType)
{
Comparision = comparedBy;
First = thisObject;
FirstType = thisObjectType;
Second = thatObject;
SecondType = thatObjectType;
}
public Where(object thisLiteral, WhereComparision comparedBy, object thatLiteral)
{
Comparision = comparedBy;
First = thisLiteral;
Second = thatLiteral;
}
public Where(WhereCondition condition,
string tableName, string columnName,
WhereComparision comparedBy, string thatTableName, string thatColumnName)
{
Condition = condition;
Comparision = comparedBy;
FirstTableName = tableName;
First = columnName;
FirstType = ValueObjectType.ColumnName;
SecondTableName = thatTableName;
Second = thatColumnName;
SecondType = ValueObjectType.ColumnName;
}
public Where(string tableName, string columnName,
WhereComparision comparedBy, object value)
{
Comparision = comparedBy;
FirstTableName = tableName;
First = columnName;
FirstType = ValueObjectType.ColumnName;
Second = value;
SecondType = ValueObjectType.Value;
}
