Пример #1
0
        public int Execute(Type elementType, IDictionary <MemberExpression, object> properties, Expression predicate)
        {
            OracleUpdateCommandBuilder updateBuilder = new OracleUpdateCommandBuilder(elementType.Name);

            foreach (var item in properties)
            {
                updateBuilder.AddColumn(item.Key.Member.Name, item.Value);
            }

            if (predicate != null)
            {
                OracleWherePartsCommandBuilder whereBuider = new OracleWherePartsCommandBuilder(updateBuilder.Parameters);

                Expression expression = PartialEvaluatingExpressionTreeVisitor.EvaluateIndependentSubtrees(predicate);

                OracleWhereClauseVisitor visitor = new OracleWhereClauseVisitor();

                visitor.Translate(expression, whereBuider);

                updateBuilder.WhereParts = whereBuider.WherePartsBuilder.ToString();
            }

            this.sessionProvider.ExecutedCommandBuilder = updateBuilder;

            return(this.sessionProvider.ExecuteNonQuery(updateBuilder));
        }
Пример #2
0
        /// <summary>
        /// 设置过滤条件
        /// </summary>
        /// <param name="func"></param>
        /// <returns></returns>
        public IUpdateable <T> Where(Expression <Func <T, bool> > func)
        {
            Expression expression = PartialEvaluatingExpressionTreeVisitor.EvaluateIndependentSubtrees(func);

            OracleWhereClauseVisitor visitor = new OracleWhereClauseVisitor(this.parameters);

            string whereSqlParts = visitor.Translate(expression);

            if (this.updatePartsAggregator.Where.Length == 0)
            {
                this.updatePartsAggregator.Where.AppendFormat(" ( {0} )", whereSqlParts);
            }
            else
            {
                this.updatePartsAggregator.Where.AppendFormat(" AND ( {0} )", whereSqlParts);
            }

            return(this);
        }
Пример #3
0
        public int Execute(Type elementType, Expression predicate)
        {
            OracleDeleteCommandBuilder deleteBuilder = new OracleDeleteCommandBuilder(elementType.Name);

            if (predicate != null)
            {
                OracleWherePartsCommandBuilder whereBuilder = new OracleWherePartsCommandBuilder(deleteBuilder.Parameters);

                Expression expression = PartialEvaluatingExpressionTreeVisitor.EvaluateIndependentSubtrees(predicate);

                OracleWhereClauseVisitor visitor = new OracleWhereClauseVisitor();

                visitor.Translate(expression, whereBuilder);

                deleteBuilder.WhereParts = whereBuilder.WherePartsBuilder.ToString();
            }

            this.sessionProvider.ExecutedCommandBuilder = deleteBuilder;

            return(this.sessionProvider.ExecuteNonQuery(deleteBuilder));
        }
Пример #4
0
        /// <summary>
        /// 解析 Where 语句
        /// </summary>
        /// <param name="whereClause"></param>
        /// <param name="queryModel"></param>
        /// <param name="index"></param>
        public override void VisitWhereClause( WhereClause whereClause, QueryModel queryModel, int index )
        {
            OracleWherePartsCommandBuilder whereBuilder = new OracleWherePartsCommandBuilder( this.commandBuilder.Parameters );

            OracleWhereClauseVisitor visitor = new OracleWhereClauseVisitor();

            visitor.Translate( whereClause.Predicate, whereBuilder );

            commandBuilder.WhereParts.Add( whereBuilder.ToString() );

            base.VisitWhereClause( whereClause, queryModel, index );
        }
Пример #5
0
        /// <summary>
        /// 解析 Where 语句
        /// </summary>
        /// <param name="whereClause"></param>
        /// <param name="queryModel"></param>
        /// <param name="index"></param>
        public override void VisitWhereClause( WhereClause whereClause, QueryModel queryModel, int index )
        {
            OracleWhereClauseVisitor visitor = new OracleWhereClauseVisitor( this.parameters );

            string whereParts = visitor.Translate( whereClause.Predicate );

            queryPartsAggregator.WhereParts.Add( whereParts );

            base.VisitWhereClause( whereClause, queryModel, index );
        }