using?System;
using?System.Data;
using?System.Collections;
using?System.Data.SqlClient;
using?OnLineExam.DataAccesslayer;
using?OnLineExam.DataAccessHelper;


namespace?OnLineExam.BusinessLogiclayer
{
????//考試科目類
????public?class?Course
????{
????????#region?私有成員
????????private?int?_ID;???????????????????????????????????????????????//題目編號????????????
????????private?string?_Name;?????????????????????????????????????????//題目????????

????????#endregion?私有成員

????????#region?屬性

????????public?int?ID
????????{
????????????set
????????????{
????????????????this._ID?=?value;
????????????}
????????????get
????????????{
????????????????return?this._ID;
????????????}
????????}
????????public?string?Name
????????{
????????????set
????????????{
????????????????this._Name?=?value;
????????????}
????????????get
????????????{
????????????????return?this._Name;
????????????}
????????}
????????
????????#endregion?屬性

????????#region?方法
????????
????????//向Course表中添加考試科目信息
????????//輸出：
????????//??????插入成功：返回True；
????????//??????插入失敗：返回False；
????????public?bool?InsertByProc（）
????????{
????????????SqlParameter[]?Params?=?new?SqlParameter[1];

????????????Database?DB?=?new?Database（）;

????????????Params[0]?=?DB.MakeInParam（“@Name“?SqlDbType.VarChar?50?Name）;???????????????//考試科目名稱???????????

????????????int?Count?=?-1;
????????????Count?=?DB.RunProc（“Proc_CourseAdd“?Params）;
????????????if?（Count?>?0）
????????????????return?true;
????????????else?return?false;
????????}

????????//更新科目的信息
????????public?bool?UpdateByProc（int?CID）
????????{
????????????SqlParameter[]?Params?=?new?SqlParameter[2];

????????????Database?DB?=?new?Database（）;

????????????Params[0]?=?DB.MakeInParam（“@ID“?SqlDbType.Int?4?CID）;???????????????//用戶編號????????????
????????????Params[1]?=?DB.MakeInParam（“@Name“?SqlDbType.VarChar?200?Name）;??????//用戶權限???????????

????????????int?Count?=?-1;
????????????Count?=?DB.RunProc（“Proc_CourseModify“?Params）;
????????????if?（Count?>?0）
????????????????return?true;
????????????else?return?false;
????????}
????????
????????//刪除科目
????????//輸入：
????????//??????CID?-?科目編號；
????????//輸出：
????????//??????刪除成功：返回True；
????????//??????刪除失敗：返回False；
????????public?bool?DeleteByProc（int?CID）
????????{
????????????SqlParameter[]?Params?=?new?SqlParameter[1];

????????????Database?DB?=?new?Database（）;

????????????Params[0]?=?DB.MakeInParam（“@ID“?SqlDbType.Int4?CID）;???????????????//科目編號??????????
????????????
????????????int?Count?=?-1;
????????????Count?=?DB.RunProc（“Proc_CourseDelete“?Params）;
????????????if?（Count?>?0）
????????????????return?true;
????????????else?return?false;
????????}
????????
????????//查詢所用考試科目
????????//不需要參數
????????public?DataSet?QueryCourse（）
????????{
????????????Database?DB?=?new?Database（）;???????????
????????????return?DB.GetDataSet（“Proc_CourseList“）;
????????}
????????
????????#endregion?方法
????

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

?????文件????????410??2002-12-30?01:40??chinaz.com.txt

?????文件???????4752??2008-06-02?12:16??源碼必讀.txt

?????文件???????3247??2009-11-06?17:10??說明.htm

?????文件????????203??2007-05-11?10:54??Controls\lefttree.ascx

?????文件???????3349??2008-05-25?19:50??Web\CourseAdd.aspx

?????文件???????4654??2008-05-25?19:32??Web\CourseManage.aspx

?????文件????????446??2008-05-20?22:31??Web\Default.aspx

?????文件???????3900??2008-05-25?19:50??Web\DepartmentAdd.aspx

?????文件???????4253??2008-05-25?19:32??Web\DepartmentManage.aspx

?????文件???????4235??2008-05-25?19:46??Web\FillBlankAdd.aspx

?????文件???????4451??2008-05-25?19:50??Web\FillBlankManage.aspx

?????文件???????4076??2008-05-25?19:32??Web\JudgeAdd.aspx

?????文件???????4314??2008-05-25?19:46??Web\JudgeManage.aspx

?????文件???????4034??2008-05-26?21:36??Web\Login.aspx

?????文件???????6147??2008-05-25?19:46??Web\MultiSelectAdd.aspx

?????文件???????4336??2008-05-25?19:50??Web\MultiSelectManage.aspx

?????文件??????13579??2008-05-25?19:33??Web\PaperDetail.aspx

?????文件???????5633??2008-05-25?19:33??Web\PaperLists.aspx

?????文件??????22835??2008-05-25?19:45??Web\PaperSetup.aspx

?????文件??????15488??2008-05-28?12:25??Web\PaperSetup2.aspx

?????文件???????4314??2008-05-25?19:43??Web\PwdModify.aspx

?????文件???????4102??2008-05-25?19:50??Web\QuestionAdd.aspx

?????文件???????4352??2008-05-25?19:46??Web\QuestionManage.aspx

?????文件???????4640??2008-05-25?19:33??Web\Role.aspx

?????文件???????3350??2008-05-25?19:33??Web\RoleAdd.aspx

?????文件???????5863??2008-05-25?19:44??Web\RoleManage.aspx

?????文件???????6089??2008-05-25?19:50??Web\SingleSelectAdd.aspx

?????文件???????4293??2008-05-25?19:46??Web\SingleSelectManage.aspx

?????文件???????8816??2008-05-25?19:29??Web\StudentIndex.aspx

?????文件??????11088??2007-03-05?17:26??Web\TestAnswer.aspx

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