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?=

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

?????文件???????2581??2007-05-21?13:59??UserControl\51aspx源碼必讀.txt

?????文件????????193??2007-03-14?14:16??UserControl\examlist.ascx

?????文件???????1740??2007-05-21?13:56??UserControl\examlist.ascx.cs

?????文件???????2727??2007-05-08?20:23??UserControl\uc_login.ascx

?????文件???????2673??2007-05-21?13:56??UserControl\uc_login.ascx.cs

?????文件????????125??2007-03-27?14:33??UserControl\最新Asp.Net源碼下載.url

?????目錄??????????0??2007-05-21?14:00??UserControl

?????文件???????2573??2007-05-21?14:00??51aspx源碼必讀.txt

?????文件?????????85??2007-05-21?12:56??DBSet.ini

?????文件???????1484??2007-05-09?13:01??ExamOnline.sln

?????文件???????5764??2007-05-21?13:00??Web.Config

?????文件?????598068??2007-05-20?15:25??畢業設計說明.pdf

?????文件????????125??2007-03-27?14:33??最新Asp.Net源碼下載.url

?????文件???????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?14:00??App_Code

?????目錄??????????0??2007-05-21?12:52??App_Data

?????文件?????699176??2007-03-28?17:18??Bin\System.Web.Extensions.DLL

?????目錄??????????0??2007-05-21?13:42??Bin

?????文件????1310720??2007-05-21?13:59??DB_51aspx\ExamOnline_Data.MDF

?????文件????1835008??2007-05-21?13:59??DB_51aspx\ExamOnline_Log.LDF

?????目錄??????????0??2007-05-21?12:54??DB_51aspx

?????文件???????6467??2006-12-06?08:05??Images\loader.gif

?????目錄??????????0??2007-05-21?12:52??Images

?????文件???????1714??2007-05-05?12:06??JS\antiCommon.js

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