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