using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?DAL;
using?Model;

namespace?BLL
{
????///?

????///?功能：提供對Club的業務邏輯管理
????///?開發者：曹萍萍
????///?更新日期：2017-11-08
????///?

????public?class?ClubBLL
????{
????????ClubDAL?clubdal?=?new?ClubDAL（）;

????????#region?查詢操作

????????///?

????????///?功能：查詢社團信息
????????///?

????????///?返回查詢結果表
????????public?DataTable?GetClubList（）
????????{
????????????return?clubdal.GetClubList（）;
????????}

????????///?

????????///?功能：根據社團名稱模糊查詢
????????///?

????????///?根據社團名稱查詢
????????///?返回查詢結果表
????????public?DataTable?GetClubListByName（string?name）
????????{
????????????return?clubdal.GetClubListByName（name）;?
????????}

????????///?

????????///?功能：顯示選中單元格的社團詳情
????????///?

????????///?根據社團名稱查詢
????????///?返回查詢結果表
????????public?Club?GetClubByName（string?name）
????????{
????????????return?clubdal.GetClubByName（name）;
????????}
????????#endregion

????????#region?非查詢操作

????????///?

????????///?功能：實現對Club的添加
????????///?

????????///?社團對象
????????///?返回成功或失敗
????????public?int?AddClub（Club?c）?//添加社團
????????{
????????????Club?club?=?clubdal.GetClubByName（c.ClubName）;
????????????//Student?student?=?memberdal.GetMemberListByID（s.StudentID）;
????????????if?（club?==?null）
????????????{
????????????????if?（clubdal.AddClub（c））
????????????????{
????????????????????return?1;??//添加成功
????????????????}
????????????????else
????????????????{
????????????????????return?0;??//添加失敗
????????????????}
????????????}
????????????else
????????????{
????????????????return?-1;??//名字重復
????????????}
????????}

????????///?

????????///?功能：修改社團信息
????????///?

????????///?待修改社團名稱
????????///?返回成功或失敗
????????public?bool?UpdateClub（Club?c）?//修改社團
????????{
????????????return?clubdal.UpdateClub（c）;
????????}

????????///?

????????///?功能：刪除社團信息
????????///?

????????///?待刪除社團名稱
????????///?返回成功或失敗
????????public?bool?DeleteClub（string?clubname）?//刪除社團
????????{
????????????return?clubdal.DeleteClub（clubname）;
????????}

????????#endregion

????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-01-05?22:26??C#學生管理系統\
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\BLL\
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\BLL\bin\
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\BLL\bin\Debug\
?????文件????????6656??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\bin\Debug\BLL.dll
?????文件???????28160??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\bin\Debug\BLL.pdb
?????文件???????15360??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\bin\Debug\DAL.dll
?????文件???????34304??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\bin\Debug\DAL.pdb
?????文件????????8704??2017-11-13?03:36??C#學生管理系統\StudentClubMis02\BLL\bin\Debug\Model.dll
?????文件???????32256??2017-11-13?03:36??C#學生管理系統\StudentClubMis02\BLL\bin\Debug\Model.pdb
?????目錄???????????0??2017-10-25?10:36??C#學生管理系統\StudentClubMis02\BLL\bin\Release\
?????文件????????2913??2017-11-13?01:18??C#學生管理系統\StudentClubMis02\BLL\BLL.csproj
?????文件????????2923??2017-11-13?01:56??C#學生管理系統\StudentClubMis02\BLL\ClubBLL.cs
?????文件????????1103??2017-11-13?01:57??C#學生管理系統\StudentClubMis02\BLL\ClubMemberBLL.cs
?????文件?????????706??2017-11-13?01:58??C#學生管理系統\StudentClubMis02\BLL\DepartmentBLL.cs
?????文件?????????666??2017-11-13?01:58??C#學生管理系統\StudentClubMis02\BLL\GradeBLL.cs
?????文件????????2947??2017-11-08?08:51??C#學生管理系統\StudentClubMis02\BLL\MemberBLL.cs
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\BLL\obj\
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\BLL\obj\Debug\
?????文件?????????523??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt
?????文件????????7745??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\obj\Debug\BLL.csprojResolveAssemblyReference.cache
?????文件????????6656??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\obj\Debug\BLL.dll
?????文件???????28160??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\obj\Debug\BLL.pdb
?????文件????????5794??2017-11-13?03:37??C#學生管理系統\StudentClubMis02\BLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????目錄???????????0??2017-10-25?10:35??C#學生管理系統\StudentClubMis02\BLL\obj\Debug\TempPE\
?????文件?????????720??2017-11-13?01:59??C#學生管理系統\StudentClubMis02\BLL\ProfessionBLL.cs
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\BLL\Properties\
?????文件????????1338??2017-10-25?10:35??C#學生管理系統\StudentClubMis02\BLL\Properties\AssemblyInfo.cs
?????文件????????2097??2017-11-13?01:59??C#學生管理系統\StudentClubMis02\BLL\UserBLL.cs
?????目錄???????????0??2017-11-13?03:38??C#學生管理系統\StudentClubMis02\DAL\
............此處省略229個文件信息