c#Oracle帮助类

using System;
using System.Data;
using System.Collections.Generic;
using System.Configuration;
using System.Text;
using System.IO;
using Oracle.ManagedDataAccess.Client;
using Tools;

namespace DBUtility
{
    /// <summary>
    /// Oracle数据库操作类
    /// </summary>
    public class OracleHelper
    {
        #region 私有字段
        private string _connString;
        private OracleConnection _conn;
        private OracleCommand _comm;
        private List<OracleParameter> _parmList;
        private OracleTransaction _transaction;
        #endregion

        #region 构造函数
        public OracleHelper(string connString)
        {
            this._connString = connString;
        }
        #endregion

        #region 私有方法
        /// <summary>
        /// 初始化创建conn对象并返回
        /// </summary>
        /// <returns></returns>
        private OracleConnection Init()
        {
            try
            {
                _conn = new OracleConnection(_connString);
                if (_conn.State != ConnectionState.Open)
                {
                    _conn.Open();
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message.ToString());
            }
            return _conn;
        }

        /// <summary>
        /// 设置cmd对象
        /// </summary>
        /// <param name="sqlStr"></param>
        /// <returns></returns>
        private void SetCommand(string sqlStr)
        {
            Init();
            _comm = new OracleCommand(sqlStr, _conn);
            _comm.CommandType = CommandType.Text;
            if (_parmList != null && _parmList.Count > 0)
            {
                foreach (OracleParameter parm in _parmList)
                {
                    _comm.Parameters.Add(parm);
                }
            }
        }

        /// <sum