資源簡介
使用三層架構,搭建層與層的調用,使用GridView進行數據展示,對數據庫數據進行增刪改查操作。

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Threading.Tasks;
using?System.Data;
namespace?BLL
{
????public?class?BLLManager
????{
????????//登錄
????????public?static?bool?BLLLogin(string?username?string?password)
????????{
????????????return?DAL.DALServer.DALLogin(username?password);
????????}
????????//datageid數據加載
????????public?static?DataTable?BLLGVLoad()
????????{
????????????return?DAL.DALServer.DALGVLoad();
????????}
????????//加載下拉列表
????????public?static?DataTable?BLLDDLLoad()
????????{
????????????return?DAL.DALServer.DALDDLLoad();
????????}
????????//添加
????????public?static?int?BLLInsertAdd(string?username?string?password?string?usersex?string?usertel?int?userage?int?Did)
????????{
????????????return?DAL.DALServer.DALInsertAdd(username?password?usersex?usertel?userage?Did);
????????}
????????//修改員工?
????????public?static?int?BLLUpdateAdd(string?username?string?password?string?usersex?string?usertel?int?userage?int?Did?int?id)
????????{
????????????return?DAL.DALServer.DALUpdateAdd(username?password?usersex?usertel?userage?Did?id);
????????}
????????//刪除員工
????????public?static?int?BLLDeleteEmployee(int?id)
????????{
????????????return?DAL.DALServer.DALDeleteEmployee(id);
????????}
????????//加載部門
????????public?static?DataTable?DepartmentList()
????????{
????????????return?DAL.DALServer.DepartmentList();
????????}
????????//刪除部門
????????public?static?int?BLLDeleteDepartment(int?id)
????????{
????????????return?DAL.DALServer.DALDeleteDepartment(id);
????????}
????????//根據部門查詢部門中的員工信息
????????public?static?DataTable?DALSelect(int?id)
????????{
????????????return?DAL.DALServer.DALSelect(id);
????????}
????????//查詢
????????public?static?DataTable?BLLSelectEmployee(string?username)
????????{
????????????return?DAL.DALServer.DALSelectEmployee(username);
????????}
????????//查詢數據庫有沒有這個用戶
????????public?static?bool?BLLSelectName(string?name)?{
????????????return?DAL.DALServer.SelectEmployeeName(name);
????????}
????????//添加部門
????????public?static?int?BLLDempartmentAdd(string?name)?{
????????????return?DAL.DALServer.DALDepartmentAdd(name);
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????5632??2015-08-07?14:53??Employee\BLL\bin\Debug\BLL.dll
?????文件??????15872??2015-08-07?14:53??Employee\BLL\bin\Debug\BLL.pdb
?????文件???????9216??2015-08-07?14:53??Employee\BLL\bin\Debug\DAL.dll
?????文件??????22016??2015-08-07?14:53??Employee\BLL\bin\Debug\DAL.pdb
?????文件???????2596??2015-08-06?20:43??Employee\BLL\BLL.csproj
?????文件???????2374??2015-08-07?14:53??Employee\BLL\BLLManager.cs
?????文件????????327??2015-08-07?11:35??Employee\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt
?????文件???????5581??2015-08-07?14:53??Employee\BLL\obj\Debug\BLL.csprojResolveAssemblyReference.cache
?????文件???????5632??2015-08-07?14:53??Employee\BLL\obj\Debug\BLL.dll
?????文件??????15872??2015-08-07?14:53??Employee\BLL\obj\Debug\BLL.pdb
?????文件???????6515??2015-08-06?20:41??Employee\BLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件??????????0??2015-08-06?20:31??Employee\BLL\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件??????????0??2015-08-06?20:31??Employee\BLL\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件??????????0??2015-08-06?20:31??Employee\BLL\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
?????文件???????1330??2015-08-06?20:31??Employee\BLL\Properties\AssemblyInfo.cs
?????文件???????9216??2015-08-07?14:53??Employee\DAL\bin\Debug\DAL.dll
?????文件??????22016??2015-08-07?14:53??Employee\DAL\bin\Debug\DAL.pdb
?????文件???????6144??2015-08-06?20:52??Employee\DAL\bin\Debug\Mondel.dll
?????文件???????7680??2015-08-06?20:52??Employee\DAL\bin\Debug\Mondel.pdb
?????文件???????2643??2015-08-06?20:43??Employee\DAL\DAL.csproj
?????文件???????3716??2015-08-07?14:53??Employee\DAL\DALServer.cs
?????文件???????3709??2015-08-06?20:59??Employee\DAL\DBHelper.cs
?????文件????????333??2015-08-06?20:52??Employee\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt
?????文件???????4938??2015-08-06?20:52??Employee\DAL\obj\Debug\DAL.csprojResolveAssemblyReference.cache
?????文件???????9216??2015-08-07?14:53??Employee\DAL\obj\Debug\DAL.dll
?????文件??????22016??2015-08-07?14:53??Employee\DAL\obj\Debug\DAL.pdb
?????文件???????6521??2015-08-06?20:37??Employee\DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件??????????0??2015-08-06?20:31??Employee\DAL\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
?????文件??????????0??2015-08-06?20:31??Employee\DAL\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
?????文件??????????0??2015-08-06?20:31??Employee\DAL\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
............此處省略99個文件信息
- 上一篇:光耦隔離與運算放大電路
- 下一篇:BaiduPanKey.rar
評論
共有 條評論