public void ExecuteNonQuery(string command)
        {
            try
            {
                using (var orclDbManager = new OrclDBManager())
                {
                    using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None))
                    {
                        try
                        {
                            orclTranManager.CommandType = CommandType.Text;

                            orclTranManager.CommandText = command;

                            orclTranManager.ExecuteNonQuery();
                        }
                        catch (Exception)
                        {
                            throw;
                        }
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
        public DataTable GetDatatable(string command)
        {
            DataSet dataSet;

            try
            {
                using (var orclDbManager = new OrclDBManager())
                {
                    using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None))
                    {
                        try
                        {
                            orclTranManager.CommandType = CommandType.Text;

                            orclTranManager.CommandText = command;

                            dataSet = orclTranManager.GetData();
                        }
                        catch (Exception)
                        {
                            throw;
                        }
                    }
                }
            }
            catch (Exception ex)
            {

                throw;
            }

            if (dataSet.Tables.Count == 0)
            {
                return new DataTable();
            }

            return dataSet.Tables[0];
        }
        public OrclTranManager(OrclDBManager dBManager, OrclTranOption tranOption)
        {
            _dBManager = dBManager;
            _tranOption = tranOption;

            _orclCommand = new OracleCommand();
            _orclCommand.Connection = _dBManager.Connection;
            switch (_tranOption)
            {
                case OrclTranOption.Require:
                    _orclTransaction = _dBManager.Connection.BeginTransaction();
                    _orclCommand.Transaction = _orclTransaction;
                    break;
                default:
                    break;
            }
        }