Ejemplo n.º 1
0
        /// <summary>
        /// 更新记录(无事物)
        /// </summary>
        /// <param name="condition">条件(格式字段=?),例:b=? and c = ? and d =?</param>
        /// <param name="parameters">参数值,建议采用parameters参数,parameters防Sql注入</param>
        /// <returns>受影响的行数</returns>
        public int UpdateNoTrans(string condition, params object[] parameters)
        {
            if (__EditColumns.Count == 0 || !condition.HasValue())
            {
                return(0);
            }

            var paras = new List <object>();
            var sb    = new StringBuilder();

            sb.Append("update ").Append(TableName).Append(" set ");
            foreach (var column in __EditColumns)
            {
                sb.Append("[").Append(column.Key).Append("] = ?,");
                paras.Add(column.Value);
            }
            if (sb.ToString().EndsWith(","))
            {
                sb.Remove(sb.Length - 1, 1);
            }

            sb.Append(" where ").Append(condition);

            paras.AddRange(parameters);

            Clear();

            return(DbBase2 <TK> .ExecuteNonQueryNoTrans(sb.ToString(), paras.ToArray()));
        }