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（）
????????{
????????????
????????????
????????}
????????///?

????????///?得到數據
????????///?

????????///?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;
????????????}


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

????????///?對數據進行?增?刪?改?的操作
????????///?

????????///?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（）;
????????????}

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

????????///?從備份日志中還原數據
????????///?

????????///?數據庫還原語句
????????///?
????????public?int?ExecuteRestore（string?sql）
????????{
????????????//連接master數據庫
????????????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（）;
????????????}


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

????????///?執行大容量數據的添加刪除修改操作
????????///?

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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-11-06?08:12??VIN固定資產管理系統源碼\
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\CrystalDecisions\
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\
?????文件??????434176??2010-11-19?16:49??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Crystalreports.Engine.dll
?????文件???????32768??2016-03-04?17:36??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Data.AdoDotNetInterop.dll
?????文件???????81920??2016-03-04?17:36??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Enterprise.Desktop.Report.dll
?????文件???????45056??2010-11-19?16:50??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Enterprise.framework.dll
?????文件???????86016??2010-09-17?14:43??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Enterprise.InfoStore.dll
?????文件???????36864??2004-05-13?15:23??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.ReportSource.dll
?????文件??????393216??2010-11-19?16:55??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Shared.dll
?????文件??????307200??2016-03-04?17:36??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Web.dll
?????文件??????233472??2010-11-19?16:59??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\CrystalDecisions.Windows.Forms.dll
?????文件?????????841??2019-04-19?21:13??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\使用說明.txt
?????文件?????????209??2019-06-13?16:01??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\更多軟件下載.url
?????文件?????????211??2019-06-13?16:00??VIN固定資產管理系統源碼\CrystalDecisions\CrystalDecisions\CrystalDecisions.Windows.Forms\CrystalDecisions\淘寶優惠券.url
?????文件??????349450??2020-10-09?15:02??VIN固定資產管理系統源碼\CrystalDecisions.rar
?????目錄???????????0??2020-11-06?08:08??VIN固定資產管理系統源碼\DB_51aspx\
?????文件?????5242880??2016-01-28?16:44??VIN固定資產管理系統源碼\DB_51aspx\Equipment_Manage_dat.mdf
?????文件?????2097152??2016-01-28?16:44??VIN固定資產管理系統源碼\DB_51aspx\Equipment_Manage_log.ldf
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\DataAccess\
?????文件?????????182??2008-04-21?16:27??VIN固定資產管理系統源碼\DataAccess\App.config
?????文件???????????1??2008-05-22?11:29??VIN固定資產管理系統源碼\DataAccess\ClassDiagram1.cd
?????文件????????3784??2016-01-22?10:49??VIN固定資產管理系統源碼\DataAccess\DataAccess.csproj
?????文件?????????452??2016-01-22?10:49??VIN固定資產管理系統源碼\DataAccess\DataAccess.csproj.user
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\DataAccess\Properties\
?????文件????????1335??2008-04-20?15:48??VIN固定資產管理系統源碼\DataAccess\Properties\AssemblyInfo.cs
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\DataAccess\bin\
?????目錄???????????0??2020-11-06?08:07??VIN固定資產管理系統源碼\DataAccess\bin\Debug\
?????文件????????6144??2020-10-10?19:45??VIN固定資產管理系統源碼\DataAccess\bin\Debug\DataAccess.dll
............此處省略341個文件信息