public UserExamDetail(string logid) : this() { ArrayList logs = FT.DAL.Orm.SimpleOrmOperator.QueryConditionList <ExamLog>(" where id=" + logid); if (logs != null && logs.Count > 0) { ExamLog log = logs[0] as ExamLog; this.lbWelcome.Text = "身份证明为" + log.IdCard + "的" + log.Name + "在" + log.ExamDate + "时考试详细记录,考试分数为:" + log.Score; string sql = "select b.c_topictext as 试题内容,b.c_answer as 标准答案,a.answer as 考生答案,b.c_answer_a as 答案A,b.c_answer_b as 答案B" + ",b.c_answer_c as 答案C,b.c_answer_d as 答案D " + ",b.c_picpath as 图片路径 from table_exam_log_detail as a left join table_exam_topic as b on a.topicid=b.id where a.logid=" + logid + " order by a.id asc"; DataTable dt = FT.DAL.DataAccessFactory.GetDataAccess().SelectDataTable(sql, "tmp"); if (dt != null) { int colIndex = dt.Columns.Count; dt.Columns.Add("题号"); for (int i = 1; i <= dt.Rows.Count; i++) { dt.Rows[i - 1][colIndex] = i.ToString(); } this.dataGridView1.DataSource = dt; } } }
private void ExamWorkStation_FormClosing(object sender, FormClosingEventArgs e) { if (!this.isTrain && user != null && MessageBoxHelper.Confirm("是否需要保存本次模拟考试成绩?")) { int score = 0; int pass = 0, nopass = 0; for (int i = 0; i < topicsControl.Count; i++) { if (topicsControl[i].IsRightAnswer) { score += topicsControl[i].Score; } } if (score < 90) { nopass = 1; } else { pass = 1; } string sql = "update table_exam_user set i_all_count=i_all_count+1,i_pass_count=i_pass_count+" + pass + ",i_not_pass_count=i_not_pass_count+" + nopass + " where c_idcard='" + user.IdCard + "'"; //FT.DAL.DataAccessFactory.GetDataAccess().ExecuteSql(sql); /*if()*/ //开始保存考试记录并统计考试合格或者错误率 string[] sqls = new string[topicsControl.Count + 1]; sqls[0] = sql; ExamLog log = new ExamLog(); log.ExamDate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); log.IdCard = user.IdCard; log.Name = user.Name; log.Score = score; if (FT.DAL.Orm.SimpleOrmOperator.Create(log)) { for (int i = 0; i < topicsControl.Count; i++) { sqls[i + 1] = "insert into table_exam_log_detail(logid,topicid,answer) values(" + log.Id.ToString() + "," + topicsControl[i].Topic.Id.ToString() + ",'" + topicsControl[i].Answer + "')"; } } FT.DAL.DataAccessFactory.GetDataAccess().ExecuteTransaction(sqls); //Environment.Exit(0); //Application.Exit(); } else { //Environment.Exit(0); //Application.Exit(); } }
protected override void ShowDetail(int index) { ExamLog log = pager.Lists[this.dataGridView1.SelectedRows[0].Index] as ExamLog; if (log != null) { Form form = new UserExamDetail(log.Id.ToString()); form.ShowInTaskbar = false; form.ShowDialog(); } }
private void ExamWorkStation_FormClosing(object sender, FormClosingEventArgs e) { if (!this.isTrain&&user!=null&&MessageBoxHelper.Confirm("�Ƿ���Ҫ���汾��ģ��Գɼ���")) { int score = 0; int pass = 0, nopass = 0; for (int i = 0; i < topicsControl.Count; i++) { if (topicsControl[i].IsRightAnswer) score += topicsControl[i].Score; } if (score < 90) { nopass = 1; } else { pass = 1; } string sql = "update table_exam_user set i_all_count=i_all_count+1,i_pass_count=i_pass_count+" + pass + ",i_not_pass_count=i_not_pass_count+" + nopass + " where c_idcard='" + user.IdCard + "'"; //FT.DAL.DataAccessFactory.GetDataAccess().ExecuteSql(sql); /*if()*/ //��ʼ���濼�Լ�¼��ͳ�ƿ��Ժϸ���ߴ����� string[] sqls = new string[topicsControl.Count+1]; sqls[0] = sql; ExamLog log = new ExamLog(); log.ExamDate=System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); log.IdCard=user.IdCard; log.Name=user.Name; log.Score=score; if(FT.DAL.Orm.SimpleOrmOperator.Create(log)) { for (int i = 0; i < topicsControl.Count; i++) { sqls[i + 1] = "insert into table_exam_log_detail(logid,topicid,answer) values("+ log.Id.ToString()+","+topicsControl[i].Topic.Id.ToString()+",'"+ topicsControl[i].Answer+ "')"; } } FT.DAL.DataAccessFactory.GetDataAccess().ExecuteTransaction(sqls); //Environment.Exit(0); //Application.Exit(); } else{ //Environment.Exit(0); //Application.Exit(); } }