public ISqlGenerator WhereBetween(object field, object value1, object value2)
{
var f = FieldGenerator.GetFieldFromObject(field);
var betweenValue = CreateBetweenValue(f.DataType, value1, value2);
Where(new FieldCondition(f, Common.Sql.RelationalOperators.Between, betweenValue));
return(this);
}
public IConditionGroup Add(object field, FieldDataType dataType, RelationalOperators relationalOperator,
object value, object ignoreValue = null)
{
var fld = FieldGenerator.GetFieldFromObject(field);
if (fld.DataType != dataType && dataType != FieldDataType._Unspecified)
{
fld.DataType = dataType;
}
Add(fld, (Common.Sql.RelationalOperators)relationalOperator, value, ignoreValue);
return(this);
}
public ISqlGenerator Having(object field, RelationalOperators relationalOperator, object value)
{
Having(new FieldCondition(FieldGenerator.GetFieldFromObject(field), (Common.Sql.RelationalOperators)relationalOperator, value));
return(this);
}
public ISqlGenerator WhereBetween(object field, int value1, int value2)
{
Where(new FieldCondition(FieldGenerator.GetFieldFromObject(field), Common.Sql.RelationalOperators.Between, new BetweenValue(value1, value2)));
return(this);
}
