/// <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())); }