public SimpleFilterCondition(QField Field, string[] Values, SimpleFilterType Type) : base(Field) { bool bFirst = true; _Value = ""; if (Values != null) { foreach (string Value in Values) { if (bFirst) { bFirst = false; } else { _Value += " OR "; } if (Value == "NULL" || Value == "NOT NULL") { _Value += "{0} IS " + base.GetSqlValue(Field, Value); } else { _Value += "{0} {1} " + base.GetSqlValue(Field, Value); } } } _Type = Type; }
public SimpleFilterCondition(QField Field, string Value, SimpleFilterType Type) : base(Field) { if (Value != null) { _Value = "{0} {1} " + base.GetSqlValue(Field, Value); } _Type = Type; }
public SimpleFilterCondition(QField Field, string[] Values, SimpleFilterType Type) : base(Field) { bool bFirst = true; _Value = ""; if(Values!=null) { foreach(string Value in Values) { if(bFirst) bFirst = false; else _Value += " OR "; if(Value=="NULL"||Value=="NOT NULL") _Value += "{0} IS " + base.GetSqlValue(Field, Value); else _Value += "{0} {1} " + base.GetSqlValue(Field, Value); } } _Type = Type; }
public SimpleFilterCondition(QField Field, string Value, SimpleFilterType Type) : base(Field) { if(Value!=null) _Value = "{0} {1} " + base.GetSqlValue(Field, Value); _Type = Type; }