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?方法
????

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

?????文件???????3259??2008-04-27?13:34??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\Course.cs

?????文件???????4699??2008-05-20?10:58??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\Department.cs

?????文件???????6502??2008-04-27?13:34??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\FillBlankProblem.cs

?????文件???????5765??2008-04-27?13:35??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\JudgeProblem.cs

?????文件???????8254??2008-04-27?13:35??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\MultiProblem.cs

?????文件???????8076??2008-12-01?14:16??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\Paper.cs

?????文件???????5593??2008-05-23?13:26??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\QuestionProblem.cs

?????文件??????10962??2008-05-25?19:05??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\Role.cs

?????文件???????5390??2008-05-24?13:13??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\Scores.cs

?????文件???????8326??2008-04-27?13:35??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\SingleProblem.cs

?????文件??????11320??2008-05-20?10:59??在線考試系統的例子\aa\App_Code\BusinessLogiclayer\Users.cs

?????文件???????4184??2008-11-30?15:48??在線考試系統的例子\aa\App_Code\CommonComponent\Tree.cs

?????文件???????2680??2008-04-27?13:34??在線考試系統的例子\aa\App_Code\DataAccessHelper\GetSafeData.cs

?????文件???????2943??2008-11-30?15:14??在線考試系統的例子\aa\App_Code\DataAccessHelper\SQLString.cs

?????文件??????12533??2008-11-30?15:14??在線考試系統的例子\aa\App_Code\DataAccesslayer\Database.cs

?????文件????????203??2007-05-11?10:54??在線考試系統的例子\aa\Controls\lefttree.ascx

?????文件???????1418??2008-05-25?16:29??在線考試系統的例子\aa\Controls\lefttree.ascx.cs

?????文件????????669??2008-05-24?13:58??在線考試系統的例子\aa\CSS\CSS.css

?????文件???????4792??2008-11-30?22:14??在線考試系統的例子\aa\Database\sql.txt

?????文件???????4945??2007-07-18?09:38??在線考試系統的例子\aa\from.gif

?????文件???????1238??2007-03-05?17:26??在線考試系統的例子\aa\Images\Answer.GIF

?????文件????????651??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnAdd.gif

?????文件????????619??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnBack.gif

?????文件????????619??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnDelete.gif

?????文件????????588??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnDetail.gif

?????文件????????679??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnDispose.gif

?????文件????????588??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnGiant.gif

?????文件????????491??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnLogin.gif

?????文件????????542??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnQuery.gif

?????文件????????618??2007-03-05?17:26??在線考試系統的例子\aa\Images\BtnResetPassword.gif

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