Select.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using System.Linq;
using System.Data.Linq;

public partial class Select : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		if(!Page.IsPostBack)
		{
			BindPageData();
			///显示考生名称
			if(Session["Username"] != null)
			{
				lbUsername.Text = Session["Username"].ToString();
			}
		}
    }

	private void BindPageData()
	{	///创建ExamineDB数据库的数据上下文
		ExamineDBDataContext db = new ExamineDBDataContext(OnlineExamineSystem.ExamineDBConnectionString);

		ddlSubject.DataTextField = "Name";
		ddlSubject.DataValueField = "ID";
		ddlSubject.DataSource = db.Subject;
		ddlSubject.DataBind();
	}

	protected void ibtCommit_Click(object sender,ImageClickEventArgs e)
	{	///创建ExamineDB数据库的数据上下文
		ExamineDBDataContext db = new ExamineDBDataContext(OnlineExamineSystem.ExamineDBConnectionString);
		///判断用户是否登录
		if(Session["UserID"] == null) return;
		///添加考生登录信息
		OnlineExamine oe = new OnlineExamine();
		oe.ExamineeID = Int32.Parse(Session["UserID"].ToString());
		oe.SubjectID = Int32.Parse(ddlSubject.SelectedValue);
		oe.StartTime = DateTime.Now;
		oe.EndTime = DateTime.Now.AddHours(2);
		///插入到数据库，并保存修改
		db.OnlineExamine.InsertOnSubmit(oe);
		db.SubmitChanges();
		///获取刚才插入考生的在线考试的ID值
		var query = from oex in db.OnlineExamine
					orderby oex.StartTime descending
					select oex;
		if(query.Count() > 0)
		{   ///保存到Session中