示例#1
0
        private Data.Compare GetCompare(Syntax.Query.WhereOperators opr)
        {
            if (opr == Syntax.Query.WhereOperators.Equal)
            {
                return(Compare.Equals);
            }
            switch (opr)
            {
            case Syntax.Query.WhereOperators.Equal:
                return(Compare.Equals);

            case Syntax.Query.WhereOperators.notEqual:
                return(Compare.NotEqual);

            case Syntax.Query.WhereOperators.In:
                return(Compare.In);

            case Syntax.Query.WhereOperators.NotIn:
                return(Compare.NotIn);

            case Syntax.Query.WhereOperators.start:
                return(Compare.Like);

            case Syntax.Query.WhereOperators.end:
                return(Compare.Like);

            case Syntax.Query.WhereOperators.greater:
                return(Compare.GreaterThan);

            case Syntax.Query.WhereOperators.greaterthan:
                return(Compare.GreaterThanEqual);

            case Syntax.Query.WhereOperators.lesser:
                return(Compare.LessThan);

            case Syntax.Query.WhereOperators.lesserthan:
                return(Compare.LessThanEqual);

            case Syntax.Query.WhereOperators.Like:
                return(Compare.Like);

            default:
                return(Compare.Equals);
            }
        }
示例#2
0
 private string getValue(Syntax.Query.WhereOperators d, string val)
 {
     if (d == Syntax.Query.WhereOperators.Like)
     {
         return("%" + val + "%");
     }
     else if (d == Syntax.Query.WhereOperators.end)
     {
         return("%" + val);
     }
     else if (d == Syntax.Query.WhereOperators.start)
     {
         return(val + "%");
     }
     else
     {
         return(val);
     }
 }