Example #1
0
        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;
        }
Example #2
0
 public SimpleFilterCondition(QField Field, string Value, SimpleFilterType Type) : base(Field)
 {
     if (Value != null)
     {
         _Value = "{0} {1} " + base.GetSqlValue(Field, Value);
     }
     _Type = Type;
 }
Example #3
0
        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;
        }
Example #4
0
 public SimpleFilterCondition(QField	Field, string Value, SimpleFilterType Type)
     : base(Field)
 {
     if(Value!=null)
         _Value = "{0} {1} " + base.GetSqlValue(Field, Value);
     _Type = Type;
 }