Example #1
0
        public virtual ISqlParam Update()
        {
            var strWhereSql = WhereVisitor.Visit(ExpBuilder.ExpWhere);
            var strAssemble = AssignVisitor.Visit(ExpBuilder.ExpAssign);

            // 主键如果有值、或者设置成只读条件,则自动转成条件
            if (!string.IsNullOrWhiteSpace(strWhereSql))
            {
                strWhereSql = "WHERE " + strWhereSql;
            }

            Sql.AppendFormat("UPDATE {0} SET {1} {2}", DbProvider.KeywordAegis(Name), strAssemble, strWhereSql);
            return(this);
        }
Example #2
0
        public virtual ISqlParam AddUp()
        {
            Check.IsTure(ExpBuilder.ExpAssign == null, "赋值的参数不能为空!");

            var strWhereSql = WhereVisitor.Visit(ExpBuilder.ExpWhere);
            var strAssemble = AssignVisitor.Visit(ExpBuilder.ExpAssign);

            if (!string.IsNullOrWhiteSpace(strWhereSql))
            {
                strWhereSql = "WHERE " + strWhereSql;
            }

            Sql.AppendFormat("UPDATE {0} SET {1} {2}", DbProvider.KeywordAegis(Name), strAssemble, strWhereSql);
            return(this);
        }