public static LiteFilter FieldIn(FilterField field, ArrayList arrayConst)
{
LiteVariable leftVar = LiteVariable.FromField(field);
return(new LiteFilter(leftVar, CompareTypeEnum.IN, LiteVariable.FromConstArray(arrayConst)));
}
public static LiteFilter FieldIn(FilterField field, LiteQuery subQuery)
{
LiteVariable leftVar = LiteVariable.FromField(field);
return(new LiteFilter(leftVar, CompareTypeEnum.IN, LiteVariable.FromSubQuery(subQuery)));
}
public static LiteFilter CompareWith(FilterField field, CompareTypeEnum compareType, object constValue)
{
LiteVariable leftVar = LiteVariable.FromField(field);
return(new LiteFilter(leftVar, compareType, LiteVariable.FromConst(constValue)));
}
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)));
}
public static LiteFilter IsNull(FilterField field)
{
return(new LiteFilter(LiteVariable.FromField(field), CompareTypeEnum.IsNull, null));
}