protected void Submit_Click(object sender, EventArgs e)
{
int score_total = 0;
Hashtable Question_Save = (Hashtable)Session["Question_Save"];
ArrayList question_one = (ArrayList)Question_Save["questions_one"];
ArrayList question_more = (ArrayList)Question_Save["questions_more"];
ArrayList question_judge = (ArrayList)Question_Save["questions_judge"];
Hashtable hashtable_question_one = Exam_Drector.Get_Score(DataList_Questoin_One, question_one, "questions_one");
Hashtable hashtable_question_more = Exam_Drector.Get_Score(DataList_Questoin_More, question_more, "questions_more");
Hashtable hashtable_question_judge = Exam_Drector.Get_Score(DataList_Questoin_Judge, question_judge, "questions_judge");
ArrayList questions_one_chosed = (ArrayList)hashtable_question_one["questions_one_chosed"];
ArrayList questions_more_chosed = (ArrayList)hashtable_question_more["questions_more_chosed"];
ArrayList questions_judge_chosed = (ArrayList)hashtable_question_judge["questions_judge_chosed"];
Boolean one_finshed = Exam_Drector.IsFinshed(DataList_Questoin_One, "questions_one");
Boolean more_finshed = Exam_Drector.IsFinshed(DataList_Questoin_More, "questions_more");
Boolean judge_finshed = Exam_Drector.IsFinshed(DataList_Questoin_Judge, "questions_judge");
if (one_finshed && more_finshed && judge_finshed)
{
score_total = Convert.ToInt32(hashtable_question_one["questions_one_score"]) + Convert.ToInt32(hashtable_question_more["questions_more_score"]) + Convert.ToInt32(hashtable_question_judge["questions_judge_score"]);
Exam_Drector.Loading_Result(DataList_Questoin_One, question_one, "questions_one", questions_one_chosed);
Exam_Drector.Loading_Result(DataList_Questoin_More, question_more, "questions_more", questions_more_chosed);
Exam_Drector.Loading_Result(DataList_Questoin_Judge, question_judge, "questions_judge", questions_judge_chosed);
score.Text = score_total.ToString();
}
else
{
#pragma warning disable CS0618 // 类型或成员已过时
this.RegisterStartupScript("hello", "<script>alert('还有题目未完成哦!')</script>");
#pragma warning restore CS0618 // 类型或成员已过时
}
}
protected void Submit1_Click(object sender, EventArgs e)
{
if (count_total == 15)
{
Mysqldb mysqldb = new Mysqldb();
MySqlConnection connection = mysqldb.getConnection();
MySqlCommand cmd = mysqldb.getCommand(connection);
ArrayList questions_one_chosed = null;
ArrayList questions_more_chosed = null;
ArrayList questions_judge_chosed = null;
ConnectMongo();
int score_total = 0;
string userid = Session["sn"].ToString();
Hashtable Question_Save = (Hashtable)Session["Question_Save"];
ArrayList question_one = (ArrayList)Question_Save["questions_one"];
ArrayList question_more = (ArrayList)Question_Save["questions_more"];
ArrayList question_judge = (ArrayList)Question_Save["questions_judge"];
Hashtable hashtable_question_one = Exam_Drector.Get_Score(DataList_Questoin_One, question_one, "questions_one");
Hashtable hashtable_question_more = Exam_Drector.Get_Score(DataList_Questoin_More, question_more, "questions_more");
Hashtable hashtable_question_judge = Exam_Drector.Get_Score(DataList_Questoin_Judge, question_judge, "questions_judge");
score_total = Convert.ToInt32(hashtable_question_one["questions_one_score"]) + Convert.ToInt32(hashtable_question_more["questions_more_score"]) + Convert.ToInt32(hashtable_question_judge["questions_judge_score"]);
Session["hashtable_question_one"] = hashtable_question_one;
Session["hashtable_question_more"] = hashtable_question_more;
Session["hashtable_question_judge"] = hashtable_question_judge;
Session["score_total"] = score_total;
count_total = 0; // 对进度条清0
// 存储这次考试记录
DateTime datetime = DateTime.Now;
string exam_id = userid.ToString() + "_" + datetime.ToString();
string sql = "insert into exam_record (userId, examId, score, datetime) VALUES (@userid, @exam_id, @score_total, @datetime)";
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@userid", userid);
cmd.Parameters.AddWithValue("@exam_id", exam_id);
cmd.Parameters.AddWithValue("@score_total", score_total.ToString());
cmd.Parameters.AddWithValue("@datetime", datetime.ToString());
if (mysqldb.ExceSql(cmd, connection))
{
//成功插入
mysqldb.Close();
}
else
{
Response.Write("mysql 插入失败");
}
mysqldb.ExceSql(cmd, connection);
// 将这次考试的试题信息，以及答题信息存储到 mongodb 中
var document = new BsonDocument
{
{ "examId", exam_id },
};
// 用户题目 选择
question_one = ArraylistToObject(question_one);
question_more = ArraylistToObject(question_more);
question_judge = ArraylistToObject(question_judge);
questions_one_chosed = (ArrayList)hashtable_question_one["questions_one_chosed"];
questions_more_chosed = (ArrayList)hashtable_question_more["questions_more_chosed"];
questions_judge_chosed = (ArrayList)hashtable_question_judge["questions_judge_chosed"];
var question_one_save = new List <ArrayList> {
question_one
};
var question_more_save = new List <ArrayList> {
question_more
};
var question_judge_save = new List <ArrayList> {
question_judge
};
var question_one_chosed_save = new List <ArrayList> {
questions_one_chosed
};
var question_more_chosed_save = new List <ArrayList> {
questions_more_chosed
};
var question_judge_chosed_save = new List <ArrayList> {
questions_judge_chosed
};
document.Add("question_one", new BsonArray(question_one_save));
document.Add("question_more", new BsonArray(question_more_save));
document.Add("question_judge", new BsonArray(question_judge_save));
document.Add("questions_one_chosed", new BsonArray(question_one_chosed_save));
document.Add("questions_more_chosed", new BsonArray(question_more_chosed_save));
document.Add("questions_judge_chosed", new BsonArray(question_judge_chosed_save));
//document.Add("question_chosed", new BsonArray(question_chosed));
mongodb.GetCollection("exam");
mongodb.Insert(document);
Response.Redirect("~/Result.aspx");
}
else
{
#pragma warning disable CS0618 // 类型或成员已过时
this.RegisterStartupScript("hello", "<script>alert('还有题目未完成哦!')</script>");
#pragma warning restore CS0618 // 类型或成员已过时
}
}