Пример #1
0
        public static Int32Expression IndexOf(this StringExpression expr, StringExpression value)
        {
            var newExpr = new Int32Expression("CHARINDEX(?, " + expr._sql + ") - 1", ((StringExpression)expr.Clone())._childExpressions);

            newExpr.ChildExpressions.Insert(0, value);

            return(newExpr);
        }
Пример #2
0
        public static Int32Expression IndexOf(this StringExpression expr, string value)
        {
            var newExpr = new Int32Expression("CHARINDEX(?, " + expr._sql + ") - 1", ((StringExpression)expr.Clone())._childExpressions);

            newExpr.ChildExpressions.Insert(0, new StringParameterExpression(value, expr.IsUnicode));

            return(newExpr);
        }
Пример #3
0
        /// <summary>
        /// Index of specified substring in current string expression.
        /// </summary>
        /// <param name="expr">The expr.</param>
        /// <param name="value">The substring value.</param>
        /// <returns></returns>
        public static Int32Expression IndexOf(this StringExpression expr, StringExpression value)
        {
            var newExpr = new Int32Expression("INSTR(" + expr.Sql + ", ?) - 1", ((StringExpression)expr.Clone()).ChildExpressions);

            newExpr.ChildExpressions.Insert(0, value);

            return(newExpr);
        }
Пример #4
0
        public static DateTimeExpression AddMonth(this DateTimeExpression expr, Int32Expression n)
        {
            if (n == null)
            {
                throw new ArgumentNullException("n");
            }

            var newExpr = (DateTimeExpression)expr.Clone();

            newExpr._sql = "DATEADD(month, ?, " + newExpr._sql + ")";
            newExpr._childExpressions.Insert(0, n);

            return(newExpr);
        }
Пример #5
0
        public static StringExpression Right(this StringExpression expr, Int32Expression length)
        {
            if (ReferenceEquals(length, null))
            {
                throw new ArgumentNullException("length");
            }

            var newExpr = (StringExpression)expr.Clone();

            newExpr._sql = "RIGHT(" + newExpr._sql + ", ?)";
            newExpr._childExpressions.Add(length);

            return(newExpr);
        }
Пример #6
0
        internal Int32Column(Int32Expression expr, string columnName)
            : this(columnName)
        {
            if (ReferenceEquals(expr, null))
            {
                throw new ArgumentNullException("expr");
            }

            Sql = expr.Sql;
            if (expr.ChildExpressions != null)
            {
                ChildExpressions.AddRange(expr.ChildExpressions);
            }
        }
Пример #7
0
        public static StringExpression Substring(this StringExpression expr, Int32Expression begin, int length)
        {
            if (ReferenceEquals(begin, null))
            {
                throw new ArgumentNullException("begin");
            }

            var newExpr = (StringExpression)expr.Clone();

            newExpr._sql = "SUBSTRING(" + newExpr._sql + ", ? + 1, ?)";
            newExpr._childExpressions.Add(begin);
            newExpr._childExpressions.Add(new Int32ParameterExpression(length));

            return(newExpr);
        }
Пример #8
0
        /// <summary>
        /// Substring of specified expr.
        /// </summary>
        /// <param name="expr">The expr.</param>
        /// <param name="begin">The begin.</param>
        /// <param name="length">The length.</param>
        /// <returns></returns>
        public static StringExpression Substring(this StringExpression expr, Int32Expression begin, Int32Expression length)
        {
            if (ReferenceEquals(begin, null))
            {
                throw new ArgumentNullException("begin");
            }
            if (ReferenceEquals(length, null))
            {
                throw new ArgumentNullException("length");
            }

            var newExpr = (StringExpression)expr.Clone();

            newExpr.Sql = "SUBSTR(" + newExpr.Sql + ", ? + 1, ?)";
            newExpr.ChildExpressions.Add(begin);
            newExpr.ChildExpressions.Add(length);

            return(newExpr);
        }
Пример #9
0
 internal OracleInt32Column(Int32Expression expr, string columnName)
     : base(expr, columnName)
 {
 }
Пример #10
0
 public StringExpression Substring(Int32Expression begin, Int32Expression length)
 {
     return(OracleExtensionMethods.Substring(this, begin, length));
 }
Пример #11
0
 public DateTimeExpression AddMonth(Int32Expression n)
 {
     return(OracleExtensionMethods.AddMonth(this, n));
 }
Пример #12
0
 public StringExpression Right(Int32Expression length)
 {
     return(SqlExtensionMethods.Right(this, length));
 }
Пример #13
0
 public StringExpression Substring(int begin, Int32Expression length)
 {
     return(SqlExtensionMethods.Substring(this, begin, length));
 }
Пример #14
0
 public DateTimeExpression AddSecond(Int32Expression n)
 {
     return(SqlExtensionMethods.AddSecond(this, n));
 }
Пример #15
0
 /// <summary>
 /// To a char.
 /// </summary>
 /// <param name="expr">The expr.</param>
 /// <returns></returns>
 public static StringExpression ToChar(this Int32Expression expr)
 {
     return(new StringExpression(false, "CHR(" + expr.Sql + ")", ((Int32Expression)expr.Clone()).ChildExpressions));
 }
Пример #16
0
 public static StringExpression ToNChar(this Int32Expression expr)
 {
     return(new StringExpression(false, "NCHAR(" + expr._sql + ")", ((Int32Expression)expr.Clone())._childExpressions));
 }
Пример #17
0
 public Assignment Set(Int32Expression value)
 {
     return(new Assignment(this, ((object)value) == null ? (IExpression)NullExpression.Value : value));
 }
Пример #18
0
 public DateTimeExpression AddMinute(Int32Expression n)
 {
     return(SqlExtensionMethods.AddMinute(this, n));
 }