using?System;
using?System.Data;
using?System.Data.SqlClient;
namespace?LcdAndonDemo
{
????/********************************************************************
????????**?????Name?????????:?DataAccess???????????????????????????????
????????**?????Des??????????:?數(shù)據(jù)庫訪問類??????????????????????????????????
????????**?????Author???????:???????
????????**?????Fin.Date?????:
????*********************************************************************/
????///?

????///?數(shù)據(jù)庫訪問類
????///?

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

????????///?數(shù)據(jù)庫連接對象?表示SQL?Server數(shù)據(jù)庫的一個打開的連接
????????///?

????????//private?OracleConnection?conn;

????????private?SqlConnection?conn;
??????
????????///?

????????///?數(shù)據(jù)庫命令?表示要對SQL?Server數(shù)據(jù)庫執(zhí)行的一個Transact_SQL語句或存儲過程
????????///?

????????//private?OracleCommand?cm;

????????private?SqlCommand?cm;

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

????????///?數(shù)據(jù)庫命令?表示用于填充DataSet和更新SQL?Server數(shù)據(jù)庫的一組數(shù)據(jù)命令和一個數(shù)據(jù)庫連接
????????///?

????????//private?OracleDataAdapter?aAdapter;

????????private?SqlDataAdapter?aAdapter;

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

????????///?數(shù)據(jù)庫命令?表示要在SQL?Server數(shù)據(jù)庫中處理的Transact_SQL事務(wù)
????????///?

????????//private?OracleTransaction?aTrans;

????????private?SqlTransaction?aTrans;

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

????????///?數(shù)據(jù)查詢表達式或存儲過程的名字
????????///?

????????private?string?str_QueryString;

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

????????///?表示是否在進行事務(wù)處理
????????///?

????????private?bool?b_IsInTrans;

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

????????///?當(dāng)前頁數(shù)
????????///?

????????private?int?i_CurrentPage;

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

????????///?每頁的紀錄數(shù)
????????///?

????????private?int?i_PageSize;

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

????????///?頁面總數(shù)
????????///?

????????private?int?i_PageCount;

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

????????///?紀錄總數(shù)
????????///?

????????private?int?i_RecordCount;

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

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

????????private?string?str_ConnString;

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

????????///?b_FirstPage、b_PreviousPage、b_NextPage、b_LastPage上下頁的狀態(tài)
????????///?

????????private?bool?b_FirstPage;
????????private?bool?b_PreviousPage;
????????private?bool?b_NextPage;
????????private?bool?b_LastPage;

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

????????///?構(gòu)造函數(shù)
????????///?

????????///?數(shù)據(jù)庫連接字符串
????????public?DataAccess（string?strConnString）
????????{
????????????this.str_ConnString?=?strConnString;
????????????this.conn?=?new?SqlConnection（str_ConnString）;
????????????aAdapter?=?new?SqlDataAdapter（““?conn）;
????????????
????????????this.cm?=?aAdapter.SelectCommand;
????????????this.cm.CommandTimeout?=?600;
????????????this.b_IsInTrans?=?false;
????????????this.i_CurrentPage?=?0;
????????????//this.i_PageSize?=?nPageSize;
????????????this.i_PageCount?=?0;
????????????this.i_RecordCount?=?0;
????????????this.b_FirstPage?=?false;
???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-11-17?18:49??data_up（2）\
?????目錄???????????0??2020-11-17?18:50??data_up（2）\.vs\
?????目錄???????????0??2020-11-17?18:50??data_up（2）\.vs\data_up\
?????目錄???????????0??2020-11-17?18:50??data_up（2）\.vs\data_up\v14\
?????文件???????82432??2020-11-17?18:58??data_up（2）\.vs\data_up\v14\.suo
?????文件?????1142784??2020-11-17?18:49??data_up（2）\DATA.accdb
?????文件??????749568??2020-11-17?18:49??data_up（2）\DATA1.mdb
?????文件??????954368??2020-11-17?18:49??data_up（2）\DATA1_勿刪.mdb
?????目錄???????????0??2020-11-17?18:58??data_up（2）\LcdAndonDemo\
?????文件?????????766??2020-11-17?18:49??data_up（2）\LcdAndonDemo\87.ico
?????文件???????36564??2020-11-17?18:49??data_up（2）\LcdAndonDemo\DBOracle.cs
?????文件????????3635??2020-11-17?18:49??data_up（2）\LcdAndonDemo\Form1.Designer.cs
?????文件???????22114??2020-11-17?18:49??data_up（2）\LcdAndonDemo\Form1.cs
?????文件???????11746??2020-11-17?18:49??data_up（2）\LcdAndonDemo\Form1.resx
?????文件????????5907??2020-11-17?18:49??data_up（2）\LcdAndonDemo\Form1.sq-AL.resx
?????文件????????1409??2020-11-17?18:49??data_up（2）\LcdAndonDemo\Form2.Designer.cs
?????文件?????????362??2020-11-17?18:49??data_up（2）\LcdAndonDemo\Form2.cs
?????文件????????5817??2020-11-17?18:49??data_up（2）\LcdAndonDemo\Form2.resx
?????文件???????17645??2020-11-17?18:50??data_up（2）\LcdAndonDemo\OPC.cs
?????文件???????34908??2020-11-17?18:50??data_up（2）\LcdAndonDemo\OracleDataAccess.cs
?????文件????????3337??2020-11-17?18:58??data_up（2）\LcdAndonDemo\Program.cs
?????目錄???????????0??2020-11-17?18:50??data_up（2）\LcdAndonDemo\Properties\
?????文件????????1356??2020-11-17?18:50??data_up（2）\LcdAndonDemo\Properties\AssemblyInfo.cs
?????文件????????2854??2020-11-17?18:50??data_up（2）\LcdAndonDemo\Properties\Resources.Designer.cs
?????文件????????5612??2020-11-17?18:50??data_up（2）\LcdAndonDemo\Properties\Resources.resx
?????文件????????1107??2020-11-17?18:50??data_up（2）\LcdAndonDemo\Properties\Settings.Designer.cs
?????文件?????????249??2020-11-17?18:50??data_up（2）\LcdAndonDemo\Properties\Settings.settings
?????文件????????4081??2020-11-17?18:50??data_up（2）\LcdAndonDemo\SQLHelper.cs
?????目錄???????????0??2020-11-17?18:50??data_up（2）\LcdAndonDemo\bin\
?????目錄???????????0??2020-11-17?18:50??data_up（2）\LcdAndonDemo\bin\Debug\
?????文件?????????766??2020-11-17?18:50??data_up（2）\LcdAndonDemo\bin\Debug\87.ico
............此處省略45個文件信息