类代码：

 private int ExecuteNonQuery(string sql, IList<DbParameter> parameters, CommandType type, DbTransaction tran)
        {
            bool flag = false;
            flag = this.CheckConnection();
            using (DbCommand command = CreateDbCommand(sql, type, parameters, tran))
            {
                int affectedRows = -1;
                try
                {
                    affectedRows = command.ExecuteNonQuery();
                    command.Parameters.Clear();
                }
                catch (Exception ex)
                {
                    this.CloseConnection();
                    throw new Exception(ex.Message);
                }

                if (flag && tran == null)
                {
                    this.CloseConnection();
                }
                return affectedRows;
            }
        }