using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.SqlClient;
using?System.Data;
using?System.Configuration;

namespace?DataAccess
{
????public?class?sqlHandler
????{
????????private?SqlConnection?_conn?=?null;
????????private?SqlCommand?_cmd?=?null;
????????private?SqlDataAdapter?_da?=?null;
???????
????????public?sqlHandler（）
????????{
????????????
????????????
????????}
????????///?

????????///?得到數(shù)據(jù)
????????///?

????????///?sql查詢語句
????????///?
????????public?DataTable?GetData（string?sql）
????????{
????????????
????????????try
????????????{
????????????????this._conn?=?new?SqlConnection（ConfigurationSettings.AppSettings[“con“]）;
????????????????this._da?=?new?SqlDataAdapter（sql?_conn）;
????????????????DataTable?dt?=?new?DataTable（）;
????????????????_da.Fill（dt）;
????????????????return?dt;
????????????}
????????????catch
????????????{
????????????????return?null;
????????????}


????????}
????????///?

????????///?對數(shù)據(jù)進行?增?刪?改?的操作
????????///?

????????///?sql語句
????????///?
????????public?int?ExecuteNonQuery（string?sql）
????????{
????????????try
????????????{
????????????????this._conn?=?new?SqlConnection（ConfigurationSettings.AppSettings[“con“]）;
????????????????_conn.Open（）;
????????????????this._cmd?=?new?SqlCommand（sql_conn）;
????????????????int?efect?=?_cmd.ExecuteNonQuery（）;
????????????????return?efect?;
????????????}
????????????catch
????????????{
????????????????
????????????????return?0;
????????????}
????????????finally
????????????{
????????????????_conn.Close（）;
????????????}

?
????????}
????????///?

????????///?從備份日志中還原數(shù)據(jù)
????????///?

????????///?數(shù)據(jù)庫還原語句
????????///?
????????public?int?ExecuteRestore（string?sql）
????????{
????????????//連接master數(shù)據(jù)庫
????????????SqlConnection??_restore?=?new?SqlConnection（ConfigurationSettings.AppSettings[“restore“]）;
????????????try
????????????{?
????????????????
????????????????_restore.Open（）;
????????????????this._cmd?=?new?SqlCommand（sql?_restore）;
????????????????int?efect?=?_cmd.ExecuteNonQuery（）;
????????????????return?efect;
????????????}
????????????catch
????????????{

????????????????return?0;
????????????}
????????????finally
????????????{
????????????????_restore.Close（）;
????????????}


????????}
????????///?

????????///?執(zhí)行大容量數(shù)據(jù)的添加刪除修改操作
????????///?

????????///?代參SQL語句
????????///?SQL中的參數(shù)
????????///?result:sql對數(shù)據(jù)表影響的行數(shù)
????????public?int?ExecuteSQL（string?sql?params?SqlParameter[]?commandParameters）
????????{
????????????this._conn?=?new?SqlConnection（ConfigurationSettings.AppSettings[“con“]）;
????????????_cmd?=?new?SqlCommand（sql?_conn）;
??????

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

?????文件????????182??2008-04-21?16:27??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\App.config

?????文件??????16384??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\bin\Debug\DataAccess.dll

?????文件????????182??2008-04-21?16:27??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\bin\Debug\DataAccess.dll.config

?????文件??????15872??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\bin\Debug\DataAccess.pdb

?????文件??????????1??2008-05-22?11:29??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\ClassDiagram1.cd

?????文件???????2033??2008-05-22?11:40??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\DataAccess.csproj

?????文件????????146??2008-05-22?11:27??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\obj\DataAccess.csproj.FileList.txt

?????文件????????812??2010-08-26?09:00??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\obj\DataAccess.csproj.FileListAbsolute.txt

?????文件??????16384??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\obj\Debug\DataAccess.dll

?????文件??????15872??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\obj\Debug\DataAccess.pdb

?????文件???????1335??2008-04-20?15:48??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\Properties\AssemblyInfo.cs

?????文件???????4899??2008-05-16?19:37??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataAccess\sqlHandler.cs

?????文件???????1380??2017-10-11?14:00??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\AddTypeMgr.cs

?????文件??????16384??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\bin\Debug\DataAccess.dll

?????文件??????15872??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\bin\Debug\DataAccess.pdb

?????文件??????36864??2010-08-25?13:35??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\bin\Debug\DataBusiness.dll

?????文件?????116224??2010-08-25?13:35??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\bin\Debug\DataBusiness.pdb

?????文件??????20480??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\bin\Debug\DataEntity.dll

?????文件??????48640??2010-08-25?13:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\bin\Debug\DataEntity.pdb

?????文件???????3166??2008-05-10?10:37??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\BoroowMgr.cs

?????文件????????141??2008-04-20?16:07??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\Class1.cs

?????文件??????????1??2008-05-22?11:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\ClassDiagram1.cd

?????文件???????2599??2008-05-10?09:04??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\ClearMgr.cs

?????文件???????1517??2008-05-02?14:59??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\ClearTypeMgr.cs

?????文件???????1262??2008-05-02?14:58??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\ConpanyInfoMgr.cs

?????文件???????2064??2008-05-07?17:33??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\DataBackupMgr.cs

?????文件???????3136??2008-05-22?11:40??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\DataBusiness.csproj

?????文件???????2426??2017-10-11?14:00??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\DepartMgr.cs

?????文件???????4263??2008-05-14?08:32??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\EmployeeMgr.cs

?????文件???????4387??2008-04-27?21:01??srcfans.com\accessc#資產(chǎn)管理系統(tǒng)源碼\DataBusiness\EpMgr.cs

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