using?System;
using?System.Data;
using?System.Configuration;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;
using?System.IO;


namespace?ExamOnline
{
	//該源碼下載自www.51aspx.com（５１ａｓｐｘ．ｃｏｍ）

????///?

????///?AutoExercise?的摘要說明:在線練習－－自動組卷的功能實現
????///?

????public?class?AutoExercise
????{
????????string?strcon?=?““;???//連接字符串

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

????????///?構造函數，連接字符串
????????///?

????????public?AutoExercise（）???
????????{
????????????if?（strcon?==?““）
????????????{
????????????????if?（HttpContext.Current.Application[“strcon“]?==?null）
????????????????{
????????????????????string?path?=?HttpContext.Current.Request.PhysicalApplicationPath?+?“DBSet.ini“;//獲取文件物理路徑
????????????????????StreamReader?sr?=?new?StreamReader（path?System.Text.Encoding.Default）;
????????????????????strcon?=?sr.ReadLine（）;//讀取文件內容
????????????????????HttpContext.Current.Application[“strcon“]?=?strcon;
????????????????}
????????????????else
????????????????{
????????????????????strcon?=?HttpContext.Current.Application[“strcon“].ToString（）;
????????????????}
????????????}
????????}

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

????????///?用SQL語句綁定GridView
????????///?

????????///?要綁定的GridView
????????///?SQL語句
????????public?void?bindGV（GridView?gv?string?strcmd）
????????{
????????????SqlDataSource?sqlds?=?new?SqlDataSource（）;
????????????sqlds.ConnectionString?=?strcon;
????????????sqlds.SelectCommandType?=?SqlDataSourceCommandType.Text;
????????????sqlds.SelectCommand?=?strcmd;
????????????gv.DataSource?=?sqlds;
????????????gv.DataBind（）;
????????}

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

????????///?取得一門課程某題型難度的最大值
????????///?

????????///?
????????///?
????????///?
????????public?int?getQlevel（string?cid?int?sid）
????????{
????????????SqlConnection?con?=?new?SqlConnection（strcon）;
????????????string?strcmd?=?“select?max（qlevel）?from?questions?where?cid=‘“?+?cid?+?“‘?and?sid=‘“?+?sid?+?“‘“;
????????????SqlCommand?cmd?=?new?SqlCommand（strcmd?con）;
????????????con.Open（）;
????????????int?heighLevel?=Convert.ToInt32（cmd.ExecuteScalar（））;
????????????con.Close（）;
????????????return?heighLevel;
????????}

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

????????///?取得一門課程某題型的總題量
????????///?

????????///?
????????///?
????????///?
????????public?int?getQNum（string?cid?int?sid）
????????{
????????????SqlConnection?con?=?new?SqlConnection（strcon）;
????????????string?strcmd?=?“select?count（*）?from?questions?where?cid=‘“?+?cid?+?“‘?and?sid=‘“?+?sid?+?“‘“;
????????????SqlCommand?cmd?=?new?SqlCommand（strcmd?con）;
????????????con.Open（）;
????????????int?qNum?=

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-09-25?16:51??在線考試系統\
?????文件????????2573??2007-05-21?14:00??在線考試系統\51aspx源碼必讀.txt
?????目錄???????????0??2007-05-21?14:00??在線考試系統\App_Code\
?????文件????????2581??2007-05-21?13:59??在線考試系統\App_Code\51aspx源碼必讀.txt
?????文件???????12196??2007-05-21?13:56??在線考試系統\App_Code\AutoExercise.cs
?????文件????????1170??2007-05-14?00:14??在線考試系統\App_Code\Common.cs
?????文件???????17551??2007-05-21?13:56??在線考試系統\App_Code\Exam.cs
?????文件?????????773??2007-04-08?14:00??在線考試系統\App_Code\examEnum.cs
?????文件????????7778??2007-05-20?13:35??在線考試系統\App_Code\login.cs
?????文件?????????125??2007-03-27?14:33??在線考試系統\App_Code\最新Asp.Net源碼下載.url
?????目錄???????????0??2007-05-21?12:52??在線考試系統\App_Data\
?????目錄???????????0??2007-05-21?13:42??在線考試系統\Bin\
?????文件??????699176??2007-03-28?17:18??在線考試系統\Bin\System.Web.Extensions.DLL
?????文件??????????85??2007-05-21?12:56??在線考試系統\DBSet.ini
?????目錄???????????0??2007-05-21?12:54??在線考試系統\DB_51aspx\
?????文件?????1310720??2007-05-21?13:59??在線考試系統\DB_51aspx\ExamOnline_Data.MDF
?????文件?????1835008??2007-05-21?13:59??在線考試系統\DB_51aspx\ExamOnline_Log.LDF
?????文件????????1484??2007-05-09?13:01??在線考試系統\ExamOnline.sln
?????目錄???????????0??2007-05-21?12:52??在線考試系統\Images\
?????文件????????6467??2006-12-06?08:05??在線考試系統\Images\loader.gif
?????目錄???????????0??2007-05-21?12:52??在線考試系統\JS\
?????文件????????1714??2007-05-05?12:06??在線考試系統\JS\antiCommon.js
?????目錄???????????0??2007-05-21?14:00??在線考試系統\Students\
?????文件????????2581??2007-05-21?13:59??在線考試系統\Students\51aspx源碼必讀.txt
?????文件????????4781??2007-05-16?21:28??在線考試系統\Students\autoexercise.aspx
?????文件????????7353??2007-05-15?00:09??在線考試系統\Students\autoexercise.aspx.cs
?????文件????????2135??2007-05-16?22:11??在線考試系統\Students\autopage.aspx
?????文件????????7410??2007-05-17?19:58??在線考試系統\Students\autopage.aspx.cs
?????文件?????????580??2007-04-28?14:19??在線考試系統\Students\end.htm
?????文件????????1333??2007-04-28?14:29??在線考試系統\Students\examlogin.aspx
?????文件?????????715??2007-05-09?13:02??在線考試系統\Students\examlogin.aspx.cs
............此處省略33個文件信息