資源簡介
一個功能比較全的Asp.net在線考試系統源碼，可以實現單選題、多選題維護、填空題、判斷題的在線維護和管理，添加生成試卷后可以自動從題庫進行調用試題，考試完成后自動打分，后臺可以進行統計。
后臺模塊包括：
考試科目
考試科目添加 考試科目維護
用戶信息
用戶添加 用戶維護 用戶成績
試卷
試卷制定 試卷維護
試題
單選題維護 多選題維護 填空題維護 判斷題維護
該系統采用三層結構開發，核心層在App_code下
前臺登陸地址：/web/login.aspx
默認學生帳號密碼：001/admin
后臺管理地址：/Web/admin_login.aspx
默認管理帳號/密碼：admin/admin
DB_CNZZ下為Sql2005數據庫文件，需要導入。
DB_CNZZ2000下為sql2000數據庫文件，附加即可。
默認為Sql2005數據庫，Sql2000格式是轉換的
注意：轉換后的數據庫沒有測試，如果運行相關代碼出錯，需要自行設置對應表的主鍵并自增
代碼片段和文件信息
using?System;
using?System.Data;
using?System.Collections;
using?System.Data.SqlClient;
using?MyOnLineExam.DataAccesslayer;
using?MyOnLineExam.DataAccessHelper;
namespace?MyOnLineExam.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?方法 ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1340??2008-03-31?10:03??MyOnLineExam\Web\adminMain.aspx
?????文件????????414??2007-03-05?17:26??MyOnLineExam\Web\adminMain.aspx.cs
?????文件???????1770??2007-03-05?17:26??MyOnLineExam\Web\admin_CourseAdd.aspx
?????文件???????3648??2007-03-05?17:26??MyOnLineExam\Web\admin_CourseLists.aspx
?????文件???????2882??2007-03-05?17:26??MyOnLineExam\Web\admin_CourseLists.aspx.cs
?????文件???????2425??2007-03-05?17:26??MyOnLineExam\Web\admin_FillBlankAdd.aspx
?????文件???????3728??2007-03-05?17:26??MyOnLineExam\Web\admin_FillBlankAdd.aspx.cs
?????文件???????4759??2007-03-05?17:26??MyOnLineExam\Web\admin_FillBlankLists.aspx
?????文件???????3710??2007-03-05?17:26??MyOnLineExam\Web\admin_FillBlankLists.aspx.cs
?????文件???????2376??2007-03-05?17:26??MyOnLineExam\Web\admin_JudgeAdd.aspx
?????文件???????3572??2007-03-05?17:26??MyOnLineExam\Web\admin_JudgeAdd.aspx.cs
?????文件???????4031??2007-03-05?17:26??MyOnLineExam\Web\admin_JudgeLists.aspx
?????文件???????3651??2007-03-05?17:26??MyOnLineExam\Web\admin_JudgeLists.aspx.cs
?????文件???????1328??2007-03-05?17:26??MyOnLineExam\Web\admin_Login.aspx.cs
?????文件???????4015??2007-03-05?17:26??MyOnLineExam\Web\admin_MultiSelectAdd.aspx
?????文件???????4603??2007-03-05?17:26??MyOnLineExam\Web\admin_MultiSelectAdd.aspx.cs
?????文件???????4048??2007-03-05?17:26??MyOnLineExam\Web\admin_MultiSelectLists.aspx
?????文件???????3100??2007-03-05?17:26??MyOnLineExam\Web\admin_MultiSelectLists.aspx.cs
?????文件???????4325??2007-03-05?17:26??MyOnLineExam\Web\admin_PaperLists.aspx
?????文件???????2655??2007-03-05?17:26??MyOnLineExam\Web\admin_PaperLists.aspx.cs
?????文件??????12192??2007-03-05?17:26??MyOnLineExam\Web\admin_PaperSetup.aspx
?????文件???????5036??2007-03-05?17:26??MyOnLineExam\Web\admin_PaperSetup.aspx.cs
?????文件???????3938??2007-03-05?17:26??MyOnLineExam\Web\admin_SingleSelectAdd.aspx
?????文件???????4019??2007-03-05?17:26??MyOnLineExam\Web\admin_SingleSelectAdd.aspx.cs
?????文件???????4051??2008-04-02?07:13??MyOnLineExam\Web\admin_SingleSelectLists.aspx
?????文件???????3207??2007-03-05?17:26??MyOnLineExam\Web\admin_SingleSelectLists.aspx.cs
?????文件???????2889??2007-03-05?17:26??MyOnLineExam\Web\admin_UserAdd.aspx
?????文件???????1110??2007-03-05?17:26??MyOnLineExam\Web\admin_UserAdd.aspx.cs
?????文件???????4445??2007-03-05?17:26??MyOnLineExam\Web\admin_UserLists.aspx
?????文件???????3754??2007-03-05?17:26??MyOnLineExam\Web\admin_UserLists.aspx.cs
............此處省略139個文件信息
評論
共有 條評論
川公網安備 51152502000135號