using?System;
using?System.Data;
using?System.Configuration;
using?System.Data.OleDb;
using?System.Text;
using?System.Windows.Forms;

///?

///?DataAccess?為數據庫操作等全局定義的一些類
///?

public?class?DataAccess
{
????public?DataAccess（）
????{
????}
????public?static?bool?DataIsChange;

????#region?配置數據庫連接字符串
????///?

????///?獲取C/S系統根目錄
????///?

????public?static?string?SysRootPath（）
????{
????????string?resultPath?=?string.Empty;

????????string?sysPath?=?Application.StartupPath;
????????if?（sysPath.LastIndexOf（“bin“）?>?0）
????????{
????????????resultPath?=?sysPath.Substring（0?sysPath.LastIndexOf（“bin“））;
????????}
????????else
????????{
????????????resultPath?=?sysPath;
????????}

????????return?resultPath;
????}



????///?

????///?配置數據庫連接字符串
????///?

????private?static?string?ConnectionString?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?System.Environment.CurrentDirectory?+?“\\data\\LD.mdb;Persist?Security?Info=False;Jet?OLEDB:Database?Password=xuandawei;“;
????#endregion

????#region??執行SQL語句，返回Bool值
????///?

????///?執行SQL語句，返回Bool值
????///?

????///?要執行的SQL語句
????///?返回BOOL值，True為執行成功
????public?bool?ExecuteSQL（string?sql）
????{
????????OleDbConnection?con?=?new?OleDbConnection（ConnectionString）;
????????OleDbCommand?cmd?=?new?OleDbCommand（sql?con）;
????????try
????????{
????????????con.Open（）;
????????????cmd.ExecuteNonQuery（）;
????????????return?true;
????????}
????????catch
????????{
????????????return?false;
????????}
????????finally
????????{
????????????con.Close（）;
????????????con.Dispose（）;
????????????cmd.Dispose（）;
????????}
????}
????#endregion


????#region?讀取帶參數的結果集
????///?

????///?讀取帶參數的結果集
????///?

????///?SQL語句
????///?參數列表
????///?結果集
????public?OleDbDataReader?ExecuteReader（string?sql）
????{
????????OleDbDataReader?reader?=?null;
????????OleDbConnection?con?=?new?OleDbConnection（ConnectionString）;
????????OleDbCommand?cmd?=?new?OleDbCommand（sql?con）;
????????try
????????{
????????????con.Open（）;
????????????reader?=?cmd.ExecuteReader（CommandBehavior.CloseConnection）;
????????}
????????catch
????????{
????????}
????????
????????return?reader;
????}
????#endregion

????#region??執行SQL語句，返回DataTable
????///?

????///?執行SQL語句，返回DataTable
????///?

????///?要執行的SQL語句
????///?返回DataTable類型的執行結果
????public?DataTable?GetDataTable（string?sql）
????{
????????DataSet?ds?=?new?DataSet（）;
????????OleDbConnection?con?=?new?OleDbConnection（ConnectionString）;
????????OleDbDataAdapter?da?=?new?OleDbDataAdapter（sql?con）;
????????try
????????{
????????????da.Fill（ds?“tb“）;
????????}
????????catch?（Exception?ex）
????????{
????????????throw?new?Exception

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

?????文件?????352906??2014-01-01?15:14??CCFS\bin\data\choujiang.wav

?????文件????1764112??2014-01-01?21:14??CCFS\bin\data\gongxi.wav

?????文件????1764112??2014-01-01?21:14??CCFS\bin\data\join.wav

?????文件???28887664??2013-12-31?17:33??CCFS\bin\data\yinyue.wav

?????文件???????7913??2019-01-18?11:39??CCFS\CCFS.csproj

?????文件????????609??2013-12-30?20:42??CCFS\CCFS.csproj.user

?????文件???????1676??2019-01-08?19:07??CCFS\CCFS_TemporaryKey.pfx

?????文件???????5229??2019-01-09?09:52??CCFS\DataAccess.cs

?????文件??????25140??2019-01-25?13:23??CCFS\FS_Main.cs

?????文件??????24822??2019-01-25?13:23??CCFS\FS_Main.Designer.cs

?????文件??????13715??2019-01-25?13:23??CCFS\FS_Main.resx

?????文件?????294369??2010-01-25?17:59??CCFS\img\BJ003.jpg

?????文件???????3397??2019-01-08?15:29??CCFS\img\enter1.png

?????文件???????2525??2004-12-08?11:15??CCFS\img\kai.png

?????文件??????20339??2019-01-09?11:50??CCFS\img\kai1.jpg

?????文件???????7788??2019-01-09?11:59??CCFS\img\kai2.jpg

?????文件???????1396??2019-01-08?15:49??CCFS\img\kaishi1.png

?????文件???????4286??2019-01-08?17:17??CCFS\img\logo.ico

?????文件?????399654??2019-01-08?16:20??CCFS\img\logo.png

?????文件???????3341??2019-01-08?15:29??CCFS\img\space1.png

?????文件???????1164??2019-01-08?15:54??CCFS\img\tingzhi.png

?????文件??????10901??2019-01-08?19:36??CCFS\LD_DataManage.cs

?????文件??????12065??2019-01-08?19:12??CCFS\LD_DataManage.Designer.cs

?????文件??????44309??2019-01-08?18:32??CCFS\LD_DataManage.resx

?????文件???????7299??2019-01-08?19:10??CCFS\LD_Setting.cs

?????文件??????13225??2019-01-08?19:09??CCFS\LD_Setting.Designer.cs

?????文件??????43940??2019-01-08?18:32??CCFS\LD_Setting.resx

?????文件???????4286??2019-01-08?17:17??CCFS\logo.ico

?????文件??????78848??2007-02-17?06:43??CCFS\msiexec.exe

?????文件???????1496??2019-01-29?12:49??CCFS\obj\Debug\CCFS.csproj.FileListAbsolute.txt

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