public IExpressionJoin <T, TQ> NotIn(params DateTime[] items) { _parent.Add(QueryMaker.NotIn(_propertyName, items.Cast <object>().ToArray(), true)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
private static FilterExpression GetExpression(string type, string propName, object value, bool quoted) { switch (type.ToLower()) { case "equals": case "eq": return(QueryMaker.EqualsTo(propName, value, quoted)); case "notequals": case "neq": case "ne": return(QueryMaker.NotEquals(propName, value, quoted)); case "contains": case "c": return(QueryMaker.Contains(propName, value)); case "notcontains": case "doesnotcontain": case "dnc": case "nc": return(QueryMaker.NotContains(propName, value)); case "startswith": case "sw": return(QueryMaker.StartsWith(propName, value)); case "notstartswith": case "nsw": return(QueryMaker.NotStartsWith(propName, value)); case "endswith": case "ew": return(QueryMaker.EndsWith(propName, value)); case "notendswith": case "new": return(QueryMaker.NotEndsWith(propName, value)); case "isempty": case "ie": return(QueryMaker.IsEmpty(propName)); case "isnotempty": case "ino": return(QueryMaker.IsNotEmpty(propName)); case "isnull": case "in": return(QueryMaker.IsNull(propName)); case "isnotnull": case "inn": return(QueryMaker.IsNotNull(propName)); case "greaterthan": case "gt": return(QueryMaker.GreaterThan(propName, value, quoted)); case "lessthan": case "lt": return(QueryMaker.LessThan(propName, value, quoted)); case "greaterthanorequals": case "gtoe": case "gte": return(QueryMaker.GreaterThanOrEquals(propName, value, quoted)); case "lessthanorequals": case "ltoe": case "lte": return(QueryMaker.LessThanOrEquals(propName, value, quoted)); case "istrue": case "it": return(QueryMaker.IsTrue(propName)); case "isfalse": case "if": return(QueryMaker.IsFalse(propName)); default: return(null); } }
public IExpressionJoin <T, TQ> IsNull() { _parent.Add(QueryMaker.IsNull(_propertyName)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> IsNull(bool isNull) { _parent.Add(isNull ? QueryMaker.IsNull(_propertyName) : QueryMaker.IsNotNull(_propertyName)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> LessThanOrEqualTo(DateTime date) { _parent.Add(QueryMaker.LessThanOrEquals(_propertyName, date, true)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> Between(DateTime from, DateTime to) { _parent.Add(QueryMaker.Between(_propertyName, from, to, true)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> In(params double[] items) { _parent.Add(QueryMaker.In(_propertyName, items.Cast <object>().ToArray(), false)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> LargerThan(DateTime date) { _parent.Add(QueryMaker.GreaterThan(_propertyName, date, true)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> LessThanOrEqualTo(double number) { _parent.Add(QueryMaker.LessThanOrEquals(_propertyName, number, false)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> Between(double from, double to) { _parent.Add(QueryMaker.Between(_propertyName, from, to, false)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> LargerThan(double number) { _parent.Add(QueryMaker.GreaterThan(_propertyName, number, false)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> NotEndsWith(string str) { _parent.Add(QueryMaker.NotEndsWith(_propertyName, str)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> Contains(string str) { _parent.Add(QueryMaker.Contains(_propertyName, str)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> NotEquals(string str) { _parent.Add(QueryMaker.NotEquals(_propertyName, str, true)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }
public IExpressionJoin <T, TQ> Is(bool value) { _parent.Add(QueryMaker.EqualsTo(_propertyName, value ? "1": "0", false)); return(new ExpressionJoin <T, TQ>(_parent, _q)); }