示例#1
0
        /// <summary>
        /// Insert
        /// </summary>
        /// <param name="expression">表达式树</param>
        /// <param name="sqlWrapper">sql打包对象</param>
        /// <returns>SqlWrapper</returns>
        public override SqlWrapper Insert(NewArrayExpression expression, SqlWrapper sqlWrapper)
        {
            foreach (Expression expressionItem in expression.Expressions)
            {
                SqlExpressionProvider.Insert(expressionItem, sqlWrapper);
                if (sqlWrapper.DatabaseType == DatabaseType.Oracle)
                {
                    sqlWrapper += " UNION ALL SELECT ";
                }
                else
                {
                    sqlWrapper += ",";
                }
            }

            if (sqlWrapper[sqlWrapper.Length - 1] == ',')
            {
                sqlWrapper.Remove(sqlWrapper.Length - 1, 1);
            }

            if (sqlWrapper.LastIndexOf(" UNION ALL SELECT ") > -1)
            {
                sqlWrapper.Remove(sqlWrapper.Length - 18, 18);
            }

            return(sqlWrapper);
        }
示例#2
0
        /// <summary>
        /// Insert
        /// </summary>
        /// <param name="expression">表达式树</param>
        /// <param name="sqlWrapper">sql打包对象</param>
        /// <returns>SqlWrapper</returns>
        public override SqlWrapper Insert(UnaryExpression expression, SqlWrapper sqlWrapper)
        {
            SqlExpressionProvider.Insert(expression.Operand, sqlWrapper);

            return(sqlWrapper);
        }