public int addOnlyExam(Examination exam) { string strSql = "insert into ex_examination(EXAM_CAT, EXAM_NAME, START_TIME, TOTAL_MINS, SCORES, EX_TYPE,NUM,EX_TYPE_LX) values(?examCat, ?examName, ?startTime, ?totalMins, ?scores, ?exType, ?Num,?exType_lx); select last_insert_id();"; MySqlParameter[] parames = new MySqlParameter[] { new MySqlParameter("?examCat", MySqlDbType.VarChar), new MySqlParameter("?examName", MySqlDbType.VarChar), new MySqlParameter("?startTime", MySqlDbType.VarChar), new MySqlParameter("?totalMins", MySqlDbType.Int32), new MySqlParameter("?scores", MySqlDbType.VarChar), new MySqlParameter("?exType", MySqlDbType.VarChar), new MySqlParameter("?Num", MySqlDbType.Int32), new MySqlParameter("?exType_lx", MySqlDbType.VarChar) }; parames[0].Value = exam.ExamCat; parames[1].Value = exam.ExamName; parames[2].Value = exam.StartTime; parames[3].Value = exam.TotalMins; parames[4].Value = exam.Scores; parames[5].Value = "1"; parames[6].Value = exam.Num; parames[7].Value = exam.ExType_lx;//选题方式 int examId = Convert.ToInt32(MySqlHelper.ExecuteScalar(strSql, parames)); exam.ExaminationId = examId; return examId; }
public AddExam(Examination examination_in) { if (examination_in!=null) { examination = examination_in; } InitializeComponent(); topicCategory.Items.Clear(); topicCategory.DataSource = Constant.getTopicType(); topicCategory.DisplayMember = "name"; topicCategory.ValueMember = "id"; exType.Items.Clear(); exType.DataSource = Constant.getExamType(); exType.DisplayMember = "name"; exType.ValueMember = "id"; exType.SelectedIndex = 0; button1.BackColor = Color.FromArgb(255, 80, 151, 228); button2.BackColor = Color.FromArgb(255, 80, 151, 228); button1.ForeColor = Color.White; button2.ForeColor = Color.White; }
public int addOnlyExam(Examination exam) { int examId = exam.ExaminationId; int flag = 0; if (examId < 1) { flag = examDao.addOnlyExam(exam); examId = exam.ExaminationId; } else { flag = examDao.updateOnlyExam(exam); //examDetailDao.deleteExamDetail(exam.ExaminationId); } return flag; }
public int addExam(Examination exam, string topicIds) { int examId = exam.ExaminationId; int flag = 0; if (examId < 1) { flag = examDao.addExam(exam); examId = exam.ExaminationId; } else { flag = examDao.updateExam(exam); examDetailDao.deleteExamDetail(exam.ExaminationId); } if (topicIds.IndexOf(",") > -1) //多个题目时 { topicIds = topicIds.Substring(0, topicIds.Length - 1); string[] ids = topicIds.Split(','); for (int i = 0; i < ids.Length; i++) { ExaminationDetail examDetail = new ExaminationDetail(); examDetail.ExaminationId = examId; examDetail.TopicId = Convert.ToInt32(ids[i]); examDetail.TopicOrder = i + 1; examDetailDao.addExamDetail(examDetail); } } else { ExaminationDetail examDetail = new ExaminationDetail(); examDetail.ExaminationId = examId; examDetail.TopicId = Convert.ToInt32(topicIds == "" ? "0" : topicIds); examDetail.TopicOrder = 1; examDetailDao.addExamDetail(examDetail); } return flag; }
public static chooseTopics createForm(Examination exam_in) { exam = exam_in; //if (instance == null || instance.IsDisposed) //{ instance = new chooseTopics(); //} if (topicService == null) { topicService = TopicService.getInstance(); } if (examService == null) { examService = ExamService.getInstance(); } if (strWheres == null) { strWheres = new Dictionary<string, string>(); } return instance; }
public int updateOnlyExam(Examination exam) { string strSql = "update ex_examination set EXAM_CAT =?examCat, EXAM_NAME = ?examName, START_TIME = ?startTime, TOTAL_MINS = ?totalMins, EX_TYPE = ?exType, NUM = ?Num where examination_id = ?examId"; MySqlParameter[] parames = new MySqlParameter[] { new MySqlParameter("?examCat", MySqlDbType.VarChar), new MySqlParameter("?examName", MySqlDbType.VarChar), new MySqlParameter("?startTime", MySqlDbType.VarChar), new MySqlParameter("?totalMins", MySqlDbType.Int32), new MySqlParameter("?exType", MySqlDbType.VarChar), new MySqlParameter("?examId", MySqlDbType.Int32), new MySqlParameter("?Num", MySqlDbType.Int32) }; parames[0].Value = exam.ExamCat; parames[1].Value = exam.ExamName; parames[2].Value = exam.StartTime; parames[3].Value = exam.TotalMins; parames[4].Value = exam.ExType; parames[5].Value = exam.ExaminationId; parames[6].Value = exam.Num; return Convert.ToInt32(MySqlHelper.ExecuteNonQuery(strSql, parames)); }
private void button7_Click(object sender, EventArgs e) { if (xz == 0 && feib == 0 && fub == 0) { MessageBox.Show("请选择题目!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { Examination exam = new Examination(); exam.ExamCat = Convert.ToString(addExam.topicCategory.SelectedValue); exam.ExamName = addExam.txtExamName.Text; exam.StartTime = addExam.startTime.Text; exam.TotalMins = Convert.ToInt32(addExam.totalMins.Text); exam.ExType = "1"; exam.ExaminationId = Convert.ToInt32(addExam.labExamId.Text == "" ? "0" : addExam.labExamId.Text); string topicIds = getRandomTopicIds(xz, xzList); topicIds += getRandomTopicIds(feib, feibList); topicIds += getRandomTopicIds(fub, fubList); int result = examService.addExam(exam, topicIds); if (result > 0) { MessageBox.Show("保存成功"); bodyExam.btnQuery_Click(sender, e); this.Close(); } else { MessageBox.Show("保存失败,请联系管理员"); } } }
private void button2_Click(object sender, EventArgs e) { //必须选中一行 if (pageCtrl.dg.CurrentRow == null) { MessageBox.Show("请选择一条记录"); } else { //获取选中行的信息 填充到对象中 Examination exam = new Examination(); exam.ExamCat = Convert.ToString(pageCtrl.dg.CurrentRow.Cells[2].Value.ToString()); exam.ExamName = pageCtrl.dg.CurrentRow.Cells[1].Value.ToString(); exam.StartTime = pageCtrl.dg.CurrentRow.Cells[3].Value.ToString(); exam.TotalMins = Convert.ToInt32(pageCtrl.dg.CurrentRow.Cells[4].Value.ToString()); exam.ExType = "1"; exam.ExaminationId = Convert.ToInt32(pageCtrl.dg.CurrentRow.Cells[0].Value.ToString()); exam.Num = Convert.ToInt32(pageCtrl.dg.CurrentRow.Cells[6].Value.ToString()); exam.ExType_lx = Convert.ToString(pageCtrl.dg.CurrentRow.Cells[7].Value.ToString()); AddExam addExam = new AddExam(exam); addExam.bodyExam = this; addExam.ShowDialog(); } }
public Boolean ScheduleExamunation(Model.Examination examination) { // TODO: implement return(false); }
private void button7_Click(object sender, EventArgs e) { if (topicType == null) { MessageBox.Show("请选择测试类别!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else if (xz == 0 && feib == 0 && fub == 0) { MessageBox.Show("请选择题目!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { Examination exam = new Examination(); exam.ExamCat = topicType; DateTime dt = DateTime.Now; exam.ExamName = dt.ToString("yyyy-MM-dd HH:mm:ss") + LoginRoler.username + "的自我测试"; exam.ExType = "2"; exam.StartTime = dt.ToString("yyyy-MM-dd HH:mm:ss"); exam.Num = Convert.ToInt32(xz) + Convert.ToInt32(feib) + Convert.ToInt32(fub); string topicIds = getRandomTopicIds(xz, xzList); topicIds += getRandomTopicIds(feib, feibList); topicIds += getRandomTopicIds(fub, fubList); int result = examService.addExam(exam, topicIds); if (result > 0) { mainFrame.panel6.Controls.Clear(); mainFrame.panel6.Controls.AddRange(mainFrame.items.ToArray()); BodySelfTest3 self3 = new BodySelfTest3(); self3.TopLevel = false; self3.selfTest2 = this; self3.examId = exam.ExaminationId; self3.FormBorderStyle = FormBorderStyle.None; self3.Dock = System.Windows.Forms.DockStyle.Fill; mainFrame.panel6.Controls.Add(self3); self3.Show(); } else { MessageBox.Show("选题失败,请联系管理员"); } } }
private void button7_Click(object sender, EventArgs e) { DataTable dt = (DataTable) examDetail.DataSource; string topicIds = ""; foreach (DataRow dr in dt.Rows) { object topicId = dr.ItemArray[0]; topicIds += topicId + ","; } if (topicIds == "") { MessageBox.Show("试卷不能没有题目"); } else { Examination exam = new Examination(); exam.ExamCat = Convert.ToString(addExam.topicCategory.SelectedValue); exam.ExamName = addExam.txtExamName.Text; exam.StartTime = addExam.startTime.Text; exam.TotalMins = Convert.ToInt32(addExam.totalMins.Text); exam.ExType = "1"; exam.ExaminationId = Convert.ToInt32(addExam.labExamId.Text == "" ? "0" : addExam.labExamId.Text); int result = examService.addExam(exam, topicIds); if (result > 0) { MessageBox.Show("保存成功"); bodyExam.btnQuery_Click(sender, e); this.Close(); } else { MessageBox.Show("保存失败,请联系管理员"); } } }
// private int xz; private void button1_Click(object sender, EventArgs e) { object categoryValue = topicCategory.SelectedValue; if ((string)categoryValue == "") { MessageBox.Show("请选择种类!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else if (txtExamName.Text == "") { MessageBox.Show("考试名称不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else if (totalMins.Text == "") { MessageBox.Show("考试时长不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { if (1==2) {//此处为原先代码 string exTypeValue = ""; exTypeValue = Convert.ToString(exType.SelectedValue); if (exTypeValue == "1") { //随机 this.Hide(); AddExam3 addExam3 = new AddExam3(); addExam3.addExam = this; addExam3.bodyExam = this.bodyExam; addExam3.ShowDialog(); } else if (exTypeValue == "2") { //手动 this.Hide(); AddExam2 addExam2 = new AddExam2(); addExam2.addExam = this; addExam2.bodyExam = this.bodyExam; addExam2.ShowDialog(); } } else//修改处 { //先保存试卷基础信息,然后手动或者自动添加试题到试卷上面 Examination exam = new Examination(); exam.ExamCat = Convert.ToString(this.topicCategory.SelectedValue); exam.ExamName = this.txtExamName.Text; exam.StartTime = this.startTime.Text; exam.TotalMins = Convert.ToInt32(this.totalMins.Text); if (examination!=null) { exam.ExaminationId = examination.ExaminationId; } else { exam.ExType_lx = this.exType.Text; exam.ExaminationId = Convert.ToInt32(this.labExamId.Text == "" ? "0" : this.labExamId.Text); } exam.Num = Convert.ToInt32(this.questionsNum.Text); int result = examService.addOnlyExam(exam); if (result > 0) { if (examination == null) { string exTypeValue = Convert.ToString(exType.SelectedValue); if (exTypeValue == "1") { //随机题目保存数据到表ex_examination_detail //获取题目数量 确定随机题目数量 int Num = Convert.ToInt32(this.questionsNum.Text); if (examService.randomTopic(Num, exam.ExaminationId)) { //MessageBox.Show("保存成功"); //bodyExam.btnQuery_Click(sender, e); //this.Close(); } else { //随机选题发生系统问题,请联系管理员. MessageBox.Show("随机选题发生系统问题,请联系管理员"); } } } //刷新数据 bodyExam.btnQueryClick(); this.Hide(); //跳转到 考题列表进行选择 chooseTopics cTopics = chooseTopics.createForm(exam); cTopics.ShowDialog(); } else { MessageBox.Show("保存失败,请联系管理员"); } } } }