/// <summary> /// 查询集合 /// </summary> /// <returns></returns> public IList<ExamQuestion> GetList(String exam_sequence) { string sql = "SELECT sequence,exam_sequence,questionType,answer,question,option1,option2,option3,option4,option5,option6,option7,option8 FROM tb_exam_question WHERE exam_sequence=@exam_sequence"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@exam_sequence", exam_sequence); MySqlDataReader reader = command.ExecuteReader(); IList<ExamQuestion> list = new List<ExamQuestion>(); ExamQuestion examQuestion = null; while (reader.Read()) { examQuestion = new ExamQuestion(); examQuestion.sequence = reader["sequence"] == DBNull.Value ? null : reader["sequence"].ToString(); examQuestion.exam_sequence = reader["exam_sequence"] == DBNull.Value ? null : reader["exam_sequence"].ToString(); examQuestion.questionType = reader["questionType"] == DBNull.Value ? null : reader["questionType"].ToString(); examQuestion.answer = reader["answer"] == DBNull.Value ? null : reader["answer"].ToString(); examQuestion.question = reader["question"] == DBNull.Value ? null : reader["question"].ToString(); examQuestion.option1 = reader["option1"] == DBNull.Value ? null : reader["option1"].ToString(); examQuestion.option2 = reader["option2"] == DBNull.Value ? null : reader["option2"].ToString(); examQuestion.option3 = reader["option3"] == DBNull.Value ? null : reader["option3"].ToString(); examQuestion.option4 = reader["option4"] == DBNull.Value ? null : reader["option4"].ToString(); examQuestion.option5 = reader["option5"] == DBNull.Value ? null : reader["option5"].ToString(); examQuestion.option6 = reader["option6"] == DBNull.Value ? null : reader["option6"].ToString(); examQuestion.option7 = reader["option7"] == DBNull.Value ? null : reader["option7"].ToString(); examQuestion.option8 = reader["option8"] == DBNull.Value ? null : reader["option8"].ToString(); list.Add(examQuestion); } mycn.Close(); return list; } }
public const string mysqlConnection = DBConstant.mysqlConnection;//"User Id=root;Host=115.29.229.134;Database=chinaunion;password=c513324665;charset=utf8"; /// <summary> /// 添加数据 /// </summary> /// <returns></returns> public int Add(ExamQuestion entity) { string sql = "INSERT INTO tb_exam_question (exam_sequence,questionType,answer,question,option1,option2,option3,option4,option5,option6,option7,option8)"; sql = sql + " VALUE (@exam_sequence,@questionType,@answer,@question,@option1,@option2,@option3,@option4,@option5,@option6,@option7,@option8)"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@exam_sequence", entity.exam_sequence); command.Parameters.AddWithValue("@questionType", entity.questionType); command.Parameters.AddWithValue("@answer", entity.answer); command.Parameters.AddWithValue("@question", entity.question); command.Parameters.AddWithValue("@option1", entity.option1); command.Parameters.AddWithValue("@option2", entity.option2); command.Parameters.AddWithValue("@option3", entity.option3); command.Parameters.AddWithValue("@option4", entity.option4); command.Parameters.AddWithValue("@option5", entity.option5); command.Parameters.AddWithValue("@option6", entity.option6); command.Parameters.AddWithValue("@option7", entity.option7); command.Parameters.AddWithValue("@option8", entity.option8); int i = command.ExecuteNonQuery(); mycn.Close(); mycn.Dispose(); return i; } }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(this.txtExamName.Text.Trim())) { MessageBox.Show("名称不能为空"); txtExamName.Focus(); return; } if (this.dtEndDate.Value.CompareTo(this.dtStartDate.Value) <= 0) { MessageBox.Show("有效期结束时间必须大于开始时间"); return; } this.Cursor = Cursors.WaitCursor; Exam exam = new Exam(); if (rdoExam.Checked) { exam.type = "Exam"; } if (rdoSurvey.Checked) { exam.type = "Survey"; } if (String.IsNullOrEmpty(exam.type)) { MessageBox.Show("请选择试题类型"); return; } exam.subject = this.txtExamName.Text; //exam.type = "Exam"; exam.validateStartTime = this.dtStartDate.Value.ToString("yyyy-MM-dd"); exam.validateEndTime = this.dtEndDate.Value.ToString("yyyy-MM-dd"); exam.creatTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); exam.isValidate = "Y"; exam.agentType = this.cboAgentType.Text; ExamDao examDao = new ExamDao(); examDao.Add(exam); exam = examDao.GetByName(exam.subject); if (exam != null) { ExamQuestionDao examQuestionDao = new ExamQuestionDao(); for (int i = 0; i < this.dgExamSingleChoice.RowCount; i++) { ExamQuestion examQuestion = new ExamQuestion(); examQuestion.question = dgExamSingleChoice[0, i].Value.ToString(); examQuestion.answer = dgExamSingleChoice[1, i].Value.ToString(); examQuestion.option1 = dgExamSingleChoice[2, i].Value.ToString(); examQuestion.option2 = dgExamSingleChoice[3, i].Value.ToString(); examQuestion.option3 = dgExamSingleChoice[4, i].Value.ToString(); examQuestion.option4 = dgExamSingleChoice[5, i].Value.ToString(); examQuestion.option5 = dgExamSingleChoice[6, i].Value.ToString(); examQuestion.option6 = dgExamSingleChoice[7, i].Value.ToString(); examQuestion.option7 = dgExamSingleChoice[8, i].Value.ToString(); // examQuestion.option8 = dgExamSingleChoice[9, i].Value.ToString(); examQuestion.questionType = "Single"; examQuestion.exam_sequence = exam.sequence; examQuestionDao.Add(examQuestion); } for (int i = 0; i < this.dgExamMultiChoice.RowCount; i++) { ExamQuestion examQuestion = new ExamQuestion(); examQuestion.question = dgExamMultiChoice[0, i].Value.ToString(); examQuestion.answer = dgExamMultiChoice[1, i].Value.ToString(); examQuestion.option1 = dgExamMultiChoice[2, i].Value.ToString(); examQuestion.option2 = dgExamMultiChoice[3, i].Value.ToString(); examQuestion.option3 = dgExamMultiChoice[4, i].Value.ToString(); examQuestion.option4 = dgExamMultiChoice[5, i].Value.ToString(); examQuestion.option5 = dgExamMultiChoice[6, i].Value.ToString(); examQuestion.option6 = dgExamMultiChoice[7, i].Value.ToString(); examQuestion.option7 = dgExamMultiChoice[8, i].Value.ToString(); // examQuestion.option8 = dgExamMultiChoice[9, i].Value.ToString(); examQuestion.questionType = "Multi"; examQuestion.exam_sequence = exam.sequence; examQuestionDao.Add(examQuestion); } for (int i = 0; i < this.dgExamJugement.RowCount; i++) { ExamQuestion examQuestion = new ExamQuestion(); examQuestion.question = dgExamJugement[0, i].Value.ToString(); examQuestion.answer = dgExamJugement[1, i].Value.ToString(); examQuestion.exam_sequence = exam.sequence; examQuestion.questionType = "Jugement"; examQuestionDao.Add(examQuestion); } ExamReceiverDao examReceiverDao = new ChinaUnion_DataAccess.ExamReceiverDao(); examReceiverDao.Delete(exam.sequence); for (int i = 0; i < lstAgentType.Items.Count; i++) { if (lstAgentType.GetItemChecked(i)) { ExamReceiver examReceiver = new ExamReceiver(); examReceiver.examSequence = exam.sequence; examReceiver.receiver = lstAgentType.Items[i].ToString(); examReceiver.type = "渠道类型"; examReceiverDao.Add(examReceiver); } } for (int i = 0; i < lstGroup.Items.Count; i++) { if (lstGroup.GetItemChecked(i)) { ExamReceiver examReceiver = new ExamReceiver(); examReceiver.examSequence = exam.sequence; examReceiver.receiver = lstGroup.Items[i].ToString(); examReceiver.type = "自定义组"; examReceiverDao.Add(examReceiver); } } } MessageBox.Show("操作完毕"); this.Cursor = Cursors.Default; }
/// <summary> /// 查询集合 /// </summary> /// <returns></returns> public IList<ExamQuestion> GetUserExamQuestion(String exam_sequence, String userId) { string sql = "SELECT t1.sequence,t1.exam_sequence,t1.questionType,t1.answer as standardAnswer,t2.answer as userAnswer,question,option1,option2,option3,option4,option5,option6,option7,option8 FROM tb_exam_question t1 left join tb_agent_exam_score t2 "; sql = sql + " on t1.sequence = t2.question_sequence and t1.exam_sequence=t2.exam_sequence where t1.exam_sequence=@exam_sequence and t2.userId = @userId"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@exam_sequence", exam_sequence); command.Parameters.AddWithValue("@userId", userId); MySqlDataReader reader = command.ExecuteReader(); IList<ExamQuestion> list = new List<ExamQuestion>(); ExamQuestion examQuestion = null; while (reader.Read()) { examQuestion = new ExamQuestion(); examQuestion.sequence = reader["sequence"] == DBNull.Value ? null : reader["sequence"].ToString(); examQuestion.exam_sequence = reader["exam_sequence"] == DBNull.Value ? null : reader["exam_sequence"].ToString(); examQuestion.questionType = reader["questionType"] == DBNull.Value ? null : reader["questionType"].ToString(); examQuestion.answer = reader["userAnswer"] == DBNull.Value ? null : reader["userAnswer"].ToString(); examQuestion.standardAnswer = reader["standardAnswer"] == DBNull.Value ? null : reader["standardAnswer"].ToString(); examQuestion.question = reader["question"] == DBNull.Value ? null : reader["question"].ToString(); examQuestion.option1 = reader["option1"] == DBNull.Value ? null : reader["option1"].ToString(); examQuestion.option2 = reader["option2"] == DBNull.Value ? null : reader["option2"].ToString(); examQuestion.option3 = reader["option3"] == DBNull.Value ? null : reader["option3"].ToString(); examQuestion.option4 = reader["option4"] == DBNull.Value ? null : reader["option4"].ToString(); examQuestion.option5 = reader["option5"] == DBNull.Value ? null : reader["option5"].ToString(); examQuestion.option6 = reader["option6"] == DBNull.Value ? null : reader["option6"].ToString(); examQuestion.option7 = reader["option7"] == DBNull.Value ? null : reader["option7"].ToString(); examQuestion.option8 = reader["option8"] == DBNull.Value ? null : reader["option8"].ToString(); list.Add(examQuestion); } mycn.Close(); return list; } }