using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
using?System.Data.SqlClient;
using?System.Configuration;

namespace?DAL
{
????public?class?DBHelper
????{
????????public?static?string?getConnectionString（）
????????{
????????????return?ConfigurationManager.ConnectionStrings[“constr“].ConnectionString;
????????}
????????//查詢方法
????????public?static?DataTable?select（string?sql?CommandType?type?params?SqlParameter[]?param）
????????{
????????????using?（SqlDataAdapter?adapter?=?new?SqlDataAdapter（sql?getConnectionString（）））
????????????{
????????????????DataTable?dt?=?new?DataTable（）;
????????????????adapter.SelectCommand.Parameters.AddRange（param）;
????????????????adapter.Fill（dt）;
????????????????return?dt;
????????????}
????????}
????????//受影響的行數
????????public?static?int?Excute（string?sql?CommandType?type?params?SqlParameter[]?param）
????????{
????????????using?（SqlConnection?conn?=?new?SqlConnection（getConnectionString（）））
????????????{
????????????????using?（SqlCommand?cmd?=?new?SqlCommand（sql?conn））
????????????????{
????????????????????conn.Open（）;
????????????????????cmd.CommandText?=?sql;
????????????????????cmd.Parameters.AddRange（param）;
????????????????????return?cmd.ExecuteNonQuery（）;
????????????????}
????????????}
????????}
????}
}

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

?????文件???????6656??2018-12-03?13:08??三層\DAL\bin\Debug\DAL.dll

?????文件??????17920??2018-12-03?13:08??三層\DAL\bin\Debug\DAL.pdb

?????文件???????5120??2018-11-30?16:40??三層\DAL\bin\Debug\Model.dll

?????文件???????7680??2018-11-30?16:40??三層\DAL\bin\Debug\Model.pdb

?????文件???????2769??2018-12-03?12:50??三層\DAL\DAL.csproj

?????文件???????1421??2018-12-03?12:50??三層\DAL\DBHelper.cs

?????文件????????268??2018-12-03?12:50??三層\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt

?????文件???????5063??2018-12-03?12:50??三層\DAL\obj\Debug\DAL.csprojResolveAssemblyReference.cache

?????文件???????6656??2018-12-03?13:08??三層\DAL\obj\Debug\DAL.dll

?????文件??????17920??2018-12-03?13:08??三層\DAL\obj\Debug\DAL.pdb

?????文件???????6605??2018-12-03?11:23??三層\DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????????0??2018-11-30?14:04??三層\DAL\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2018-11-30?14:04??三層\DAL\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2018-11-30?14:04??三層\DAL\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件???????1344??2018-11-30?14:04??三層\DAL\Properties\AssemblyInfo.cs

?????文件???????2464??2018-12-03?12:55??三層\DAL\UserDAL.cs

?????文件???????6656??2018-12-03?13:08??三層\DLL\bin\Debug\DAL.dll

?????文件??????17920??2018-12-03?13:08??三層\DLL\bin\Debug\DAL.pdb

?????文件???????4608??2018-12-03?13:08??三層\DLL\bin\Debug\DLL.dll

?????文件??????13824??2018-12-03?13:08??三層\DLL\bin\Debug\DLL.pdb

?????文件???????5120??2018-11-30?16:40??三層\DLL\bin\Debug\Model.dll

?????文件???????7680??2018-11-30?16:40??三層\DLL\bin\Debug\Model.pdb

?????文件???????2764??2018-11-30?15:00??三層\DLL\DLL.csproj

?????文件???????6529??2018-11-30?14:09??三層\DLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????334??2018-11-30?15:01??三層\DLL\obj\Debug\DLL.csproj.FileListAbsolute.txt

?????文件???????9304??2018-12-03?13:08??三層\DLL\obj\Debug\DLL.csprojResolveAssemblyReference.cache

?????文件???????4608??2018-12-03?13:08??三層\DLL\obj\Debug\DLL.dll

?????文件??????13824??2018-12-03?13:08??三層\DLL\obj\Debug\DLL.pdb

?????文件??????????0??2018-11-30?14:04??三層\DLL\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2018-11-30?14:04??三層\DLL\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

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