/// <summary> /// 根据SQL参数重复执行SQL语句 /// </summary> /// <returns>受影响的行数</returns> public virtual int ExecuteSql() { int rowsCount = -1; Conn = new SqlConnection(this.ConnectionString); Conn.Open(); connIsOpen = true; Sqltrans = Conn.BeginTransaction(IsolationLevel.ReadCommitted, SqlTransactionName); SqlCommand cmd = new SqlCommand(); cmd.Connection = Conn; cmd.CommandText = CmdText; cmd.Transaction = Sqltrans; cmd.CommandType = CommandType.Text;//cmdType; if (CmdParams != null) { cmd.Parameters.AddRange(CmdParams.ToArray()); rowsCount = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } //Sqltrans.Commit(); return(rowsCount); }