using?System;
using?System.Data;
using?System.Data.OleDb;
using?System.Web;
using?System.Text;

namespace?XinZe.Bank.Statistics.Dal
{
????///?

????///?conn?的摘要說明。
????///?

????public?class?DataAccess
????{
????????///?

????????///?連接數(shù)據(jù)庫字符串
????????///?

????????private?string?connectionString;
????????private?int?mvrTrasactionFlag?=?0;?//0:不使用事務1:使用事務
????????OleDbTransaction?myTrans;
????????private?string?connOpen?=?“OPEN“;

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

????????///?存儲數(shù)據(jù)庫連接（保護類，只有由它派生的類才能訪問）
????????///?

????????protected?OleDbConnection?_connection;

????????#region?構造函數(shù)：數(shù)據(jù)庫的默認連接
????????///?

????????///?構造函數(shù)：數(shù)據(jù)庫的默認連接
????????///?

????????public?DataAccess（）
????????{

????????????string?connName?=?System.Configuration.ConfigurationManager.AppSettings[“CurrentConn“].ToString（）;
????????????string?connectString?=?System.Configuration.ConfigurationManager.AppSettings[connName].ToString（）;


????????????connectionString?=?connectString;


????????}

????????#endregion

????????#region?構造函數(shù)：數(shù)據(jù)庫的默認連接
????????///?

????????///?構造函數(shù)：數(shù)據(jù)庫的默認連接
????????///?

????????///?配置數(shù)據(jù)庫的節(jié)點的名字
????????public?DataAccess（string?configName）
????????{
??????????
????????????string?connectString?=?System.Configuration.ConfigurationManager.AppSettings[configName].ToString（）;


????????????connectionString?=?connectString;


????????}
????????#endregion


????????#region?設置或讀取事務屬性
????????///?

??????///?設置或讀取事務屬性
??????///?

????????public?OleDbTransaction?MyTransaction
????????{
????????????get?{?return?myTrans;?}
????????????set?{?myTrans?=?value;?mvrTrasactionFlag?=?1;?}
????????}
????????#endregion

????????#region??關閉鏈接
????????///?

????????///?關閉鏈接
????????///?

????????public?void?CloseConnect（）
????????{

????????????if?（_connection.State?==?ConnectionState.Open）
????????????{
????????????????_connection.Close（）;
????????????}

????????}
????????#endregion


????????#region?鏈接打開狀態(tài)true:打開
????????///?

????????///?鏈接打開狀態(tài)true:打開
????????///?

????????public?bool?OpenStatus（）
????????{

????????????if?（_connection.State==ConnectionState.Open）
????????????{
????????????????return?true;
????????????}
????????????else
????????????{
????????????????return?false;
????????????}

????????}
????????#endregion



????????#region?獲得連接字符串
????????///?

????????///?獲得連接字符串
????????///?

????????public?string?ConnectionString
????????{
????????????get
????????????{
????????????????return?connectionString;
????????????}
????????}
????????#endregion


????????#region?開啟事務
????????///?

????????///?開啟事務
????????///?

????????public?void?BeginTrans（）
????????{
????????????GetConnection（）;
????????????//_connection.Open（）;
????????????if?（_connection.State?!=?C

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

?????文件??????11264??2014-04-26?10:37??Statistics\Statistics.Dal\bin\Debug\XinZe.Bank.Statistics.Dal.dll

?????文件??????28160??2014-04-26?10:37??Statistics\Statistics.Dal\bin\Debug\XinZe.Bank.Statistics.Dal.pdb

?????文件??????10240??2014-04-26?18:02??Statistics\Statistics.Dal\bin\Release\XinZe.Bank.Statistics.Dal.dll

?????文件??????24064??2014-04-26?18:02??Statistics\Statistics.Dal\bin\Release\XinZe.Bank.Statistics.Dal.pdb

?????文件????????256??2014-03-25?11:52??Statistics\Statistics.Dal\BskdErp.Dal.csproj.vspscc

?????文件??????23656??2014-04-26?09:34??Statistics\Statistics.Dal\DataAccess.cs

?????文件????????190??2014-04-23?13:48??Statistics\Statistics.Dal\mssccprj.scc

?????文件????????365??2014-03-25?19:00??Statistics\Statistics.Dal\obj\Debug\BskdErp.Dal.csproj.FileListAbsolute.txt

?????文件??????11264??2014-03-25?19:00??Statistics\Statistics.Dal\obj\Debug\BskdErp.Dal.dll

?????文件??????28160??2014-03-25?19:00??Statistics\Statistics.Dal\obj\Debug\BskdErp.Dal.pdb

?????文件???????4608??2014-04-01?09:56??Statistics\Statistics.Dal\obj\Debug\Refactor\BskdErp.Dal.dll

?????文件???????4608??2014-04-26?11:45??Statistics\Statistics.Dal\obj\Debug\Refactor\XinZe.Bank.Statistics.Dal.dll

?????文件????????476??2014-04-26?10:37??Statistics\Statistics.Dal\obj\Debug\Statistics.Dal.csproj.FileListAbsolute.txt

?????文件??????11264??2014-04-26?10:37??Statistics\Statistics.Dal\obj\Debug\XinZe.Bank.Statistics.Dal.dll

?????文件??????28160??2014-04-26?10:37??Statistics\Statistics.Dal\obj\Debug\XinZe.Bank.Statistics.Dal.pdb

?????文件????????375??2014-04-23?16:30??Statistics\Statistics.Dal\obj\Release\BskdErp.Dal.csproj.FileListAbsolute.txt

?????文件??????10240??2014-04-23?16:30??Statistics\Statistics.Dal\obj\Release\BskdErp.Dal.dll

?????文件??????24064??2014-04-23?16:30??Statistics\Statistics.Dal\obj\Release\BskdErp.Dal.pdb

?????文件???????4608??2014-04-26?10:09??Statistics\Statistics.Dal\obj\Release\Refactor\XinZe.Bank.Statistics.Dal.dll

?????文件????????486??2014-04-26?18:02??Statistics\Statistics.Dal\obj\Release\Statistics.Dal.csproj.FileListAbsolute.txt

?????文件??????10240??2014-04-26?18:02??Statistics\Statistics.Dal\obj\Release\XinZe.Bank.Statistics.Dal.dll

?????文件??????24064??2014-04-26?18:02??Statistics\Statistics.Dal\obj\Release\XinZe.Bank.Statistics.Dal.pdb

?????文件???????1372??2014-03-25?11:52??Statistics\Statistics.Dal\Properties\AssemblyInfo.cs

????..A.SHR???????127??2014-04-23?13:50??Statistics\Statistics.Dal\Properties\vssver2.scc

?????文件???????3626??2014-04-26?09:34??Statistics\Statistics.Dal\SMSOperater.cs

?????文件???????2784??2014-04-26?09:34??Statistics\Statistics.Dal\Statistics.Dal.csproj

????..A.SHR???????222??2014-04-23?13:50??Statistics\Statistics.Dal\vssver2.scc

?????文件???????1425??2014-04-26?09:34??Statistics\Statistics.sln

????..A..H.?????51712??2014-04-26?18:03??Statistics\Statistics.suo

?????文件????????493??2014-04-26?16:17??Statistics\Statistics.UI\app.config

............此處省略107個文件信息