using?System;
using?System.Collections.Generic;
using?System.Data;
using?System.Linq;
using?System.Text;

namespace?HY.DataAccess
{
????///?

????///?數據庫連接事務的Session對象
????///?

????public?class?DBSessionbase?:?IDBSession?
????{
????????private?IDbConnection?_connection;
????????private?IDbTransaction?_transaction;
????????private?readonly?DatabaseType?_databaseType;
????????private?readonly?string?_connKey;
????????
????????public?DatabaseType?DatabaseType
????????{
????????????get?{?return?_databaseType;?}
????????}

????????public?string?ConnKey
????????{
????????????get?{?return?_connKey;?}
????????}

????????///?

????????///?數據庫連接對象
????????///?

????????public?IDbConnection?Connection
????????{
????????????get?{?return?_connection;?}
????????}

????????///?

????????///?數據庫事務對象
????????///?

????????public?IDbTransaction?Transaction
????????{
????????????get?{?return?_transaction;?}
????????}

????????public?DBSessionbase（IDatabase?Database）
????????{
????????????_connection?=?Database.Connection;
????????????_databaseType?=?Database.DatabaseType;
????????????_connKey?=?Database.ConnKey;
????????}

????????///?

????????///?開啟會話
????????///?

????????///?
????????///?
????????public?IDbTransaction?Begin（IsolationLevel?isolation?=?IsolationLevel.ReadCommitted）
????????{
????????????_connection.Open（）;
????????????_transaction?=?_connection.BeginTransaction（isolation）;
????????????return?_transaction;
????????}

????????///?

????????///?事務提交
????????///?

????????public?void?Commit（）
????????{
????????????_transaction.Commit（）;
????????????_transaction?=?null;
????????}

????????///?

????????///?事務回滾
????????///?

????????public?void?Rollback（）
????????{
????????????_transaction.Rollback（）;
????????????_transaction?=?null;
????????}

????????///?

????????///?資源釋放
????????///?

????????public?void?Dispose（）
????????{
????????????if?（_connection.State?!=?ConnectionState.Closed）
????????????{
????????????????if?（_transaction?!=?null）
????????????????{
????????????????????_transaction.Rollback（）;
????????????????????_transaction?=?null;
????????????????}
????????????????_connection.Close（）;
????????????????_connection?=?null;
????????????}
????????????GC.SuppressFinalize（this）;
????????}


????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????I.A....???????477??2015-03-03?09:19??HY.DataAccess\app.config

????I.A....??????2596??2015-06-09?09:16??HY.DataAccess\DBSession.cs

????I.A....??????3163??2015-08-05?17:56??HY.DataAccess\HY.DataAccess.csproj

????I.A....??????9564??2015-06-09?09:16??HY.DataAccess\IDBHelper.cs

????I.A....??????1412??2015-06-09?09:16??HY.DataAccess\IDbSession.cs

????I.A....?????14684??2015-03-03?09:19??HY.DataAccess\MySqlDBHelper\MySqlAdaptor.cs

????I.A....?????20991??2015-03-03?09:19??HY.DataAccess\MySqlDBHelper\MySqlHelper.cs

????I.A....?????14159??2015-06-09?09:16??HY.DataAccess\OracleDBHelper\OracleAdaptor.cs

????I.A....?????18461??2015-06-09?09:16??HY.DataAccess\OracleDBHelper\OracleHelper.cs

????I.A....???????316??2015-03-03?09:19??HY.DataAccess\packages.config

????I.A....??????3344??2015-03-03?09:19??HY.DataAccess\PageHelper\PageHelper.cs

????I.A....??????1350??2015-03-03?09:19??HY.DataAccess\Properties\AssemblyInfo.cs

????I.A....??????1377??2015-06-09?09:16??HY.DataAccess\SqlConnectionFactory.cs

????I.A....?????13982??2015-06-09?09:16??HY.DataAccess\SqlDBHelper\DBAdaptor.cs

????I.A....?????20068??2015-03-03?09:19??HY.DataAccess\SqlDBHelper\SQLHelper.cs

?????目錄??????????0??2015-03-03?09:19??HY.DataAccess\MySqlDBHelper

?????目錄??????????0??2015-06-09?09:16??HY.DataAccess\OracleDBHelper

?????目錄??????????0??2015-03-03?09:19??HY.DataAccess\PageHelper

?????目錄??????????0??2015-03-03?09:19??HY.DataAccess\Properties

?????目錄??????????0??2015-06-09?09:16??HY.DataAccess\SqlDBHelper

?????目錄??????????0??2015-08-26?13:05??HY.DataAccess

-----------?---------??----------?-----??----

???????????????125944????????????????????21