コード例 #1
0
 private LiteFilter(LiteVariable leftVar, CompareTypeEnum _compareType, LiteVariable rightVar)
 {
     this.filterType  = FilterTypeEnum.AND;
     this.filterType  = FilterTypeEnum.CONDITION;
     this.LeftVar     = leftVar;
     this.compareType = _compareType;
     this.RightVar    = rightVar;
 }
コード例 #2
0
        public static LiteVariable FromField(FilterField field)
        {
            LiteVariable variable = new LiteVariable
            {
                VariableType = VariableTypeEnum.Field,
                TableAlias   = field.TableAlias,
                FieldName    = field.FieldName,
                DataType     = field._dataType
            };

            if (field.FieldNameList.Count > 1)
            {
                variable.FullTextType     = field.FullTextType;
                variable.FieldNameList    = field.FieldNameList;
                variable.IsFullTextSearch = true;
            }
            return(variable);
        }
コード例 #3
0
        public static LiteFilter FieldIn(FilterField field, ArrayList arrayConst)
        {
            LiteVariable leftVar = LiteVariable.FromField(field);

            return(new LiteFilter(leftVar, CompareTypeEnum.IN, LiteVariable.FromConstArray(arrayConst)));
        }
コード例 #4
0
        public static LiteFilter FieldIn(FilterField field, LiteQuery subQuery)
        {
            LiteVariable leftVar = LiteVariable.FromField(field);

            return(new LiteFilter(leftVar, CompareTypeEnum.IN, LiteVariable.FromSubQuery(subQuery)));
        }
コード例 #5
0
        public static LiteFilter EqualField(FilterField left, FilterField right)
        {
            LiteVariable leftVar = LiteVariable.FromField(left.TableAlias, left.FieldName);

            return(new LiteFilter(leftVar, CompareTypeEnum.Equal, LiteVariable.FromField(right.TableAlias, right.FieldName)));
        }
コード例 #6
0
        private static LiteFilter CompareWith(object constValueLeft, CompareTypeEnum compareType, object constValueRight)
        {
            LiteVariable leftVar = LiteVariable.FromConst(constValueLeft);

            return(new LiteFilter(leftVar, compareType, LiteVariable.FromConst(constValueRight)));
        }
コード例 #7
0
        public static LiteFilter CompareWith(FilterField field, CompareTypeEnum compareType, object constValue)
        {
            LiteVariable leftVar = LiteVariable.FromField(field);

            return(new LiteFilter(leftVar, compareType, LiteVariable.FromConst(constValue)));
        }
コード例 #8
0
 public static LiteFilter IsNull(FilterField field)
 {
     return(new LiteFilter(LiteVariable.FromField(field), CompareTypeEnum.IsNull, null));
 }