/// <summary> /// 绑定选择题子项的列表 /// </summary> private void bindGrid(Song.Entities.Questions q) { //最多几项 int maxItem = 8; Song.Entities.QuesAnswer[] ans = Business.Do <IQuestions>().QuestionsAnswer(q, null); List <Song.Entities.QuesAnswer> list = new List <QuesAnswer>(); for (int i = 0; i < maxItem; i++) { if (ans != null && i < ans.Length) { list.Add(ans[i]); } else { Song.Entities.QuesAnswer t = new QuesAnswer(); t.Ans_ID = -1; t.Qus_UID = getUID(); list.Add(t); } } gvAnswer.DataSource = list; gvAnswer.DataKeyNames = new string[] { "Ans_ID" }; gvAnswer.DataBind(); }
//多选题导出 private void buildExcelSql_2(HSSFWorkbook hssfworkbook, Song.Entities.Questions[] ques) { //创建工作簿对象 ISheet sheet = hssfworkbook.CreateSheet("多选题"); //sheet.DefaultColumnWidth = 30; //创建数据行对象 IRow rowHead = sheet.CreateRow(0); //创建表头 rowHead.CreateCell(0).SetCellValue("ID"); rowHead.CreateCell(1).SetCellValue("题干"); rowHead.CreateCell(2).SetCellValue("专业"); rowHead.CreateCell(3).SetCellValue("难度"); rowHead.CreateCell(4).SetCellValue("答案选项1"); rowHead.CreateCell(5).SetCellValue("答案选项2"); rowHead.CreateCell(6).SetCellValue("答案选项3"); rowHead.CreateCell(7).SetCellValue("答案选项4"); rowHead.CreateCell(8).SetCellValue("答案选项5"); rowHead.CreateCell(9).SetCellValue("答案选项6"); rowHead.CreateCell(10).SetCellValue("正确答案"); rowHead.CreateCell(11).SetCellValue("试题讲解"); //生成数据行 ICellStyle style_size = hssfworkbook.CreateCellStyle(); style_size.WrapText = true; int i = 0; foreach (Song.Entities.Questions q in ques) { IRow row = sheet.CreateRow(i + 1); string tmpVal = ""; QuesAnswer[] qas = Business.Do <IQuestions>().QuestionsAnswer(q, null); string ansIndex = ""; for (int j = 0; j < qas.Length; j++) { QuesAnswer c = qas[j]; tmpVal = c.Ans_Context; row.CreateCell(4 + j).SetCellValue(tmpVal); if (c.Ans_IsCorrect) { ansIndex += Convert.ToString(j + 1) + ","; } } if (ansIndex.Length > 0) { if (ansIndex.Substring(ansIndex.Length - 1) == ",") { ansIndex = ansIndex.Substring(0, ansIndex.Length - 1); } } row.CreateCell(0).SetCellValue(q.Qus_ID); row.CreateCell(1).SetCellValue(q.Qus_Title); row.CreateCell(2).SetCellValue(q.Sbj_Name); row.CreateCell(3).SetCellValue((int)q.Qus_Diff); row.CreateCell(10).SetCellValue(ansIndex.ToString()); row.CreateCell(11).SetCellValue(q.Qus_Explain); i++; } }
/// <summary> /// Add QuesAnswer to an outcome /// </summary> /// /// <returns></returns> public void AddQAToACourse(QuesAnswer qa, Course course) { Course newCourse = ReadCourse(course.Id); newCourse.QuesAnswers.Add(qa); _db.Courses.Update(newCourse); _db.SaveChanges(); }
/// <summary> /// IAction method for returning a view of details /// </summary> /// <param name="id">Id for a QuesAnswer</param> /// <returns></returns> public IActionResult Details(int id) { QuesAnswer ques = context.ReadQuesAnswer(id); if (ques == null) { return(RedirectToAction("Index")); } return(View(ques)); }
/// <summary> /// Remove QA from a course /// </summary> /// /// <returns></returns> public void RemoveQAFromACourse(QuesAnswer qa, Course course) { Course newCourse = ReadCourse(course.Id); QuesAnswer QA = newCourse.QuesAnswers.SingleOrDefault(m => m.Id == qa.Id); newCourse.QuesAnswers.Remove(QA); _db.Courses.Update(newCourse); _db.SaveChanges(); }
/// <summary> /// Update a question /// </summary> /// /// <returns></returns> public void UpdateQuestion(int id, QuesAnswer ques) { var oldQuestion = ReadQuesAnswer(id); if (oldQuestion != null) { oldQuestion.Question = ques.Question; oldQuestion.Answer = ques.Answer; oldQuestion.Course = ques.Course; _db.SaveChanges(); } }
public IActionResult Add(AddQuesAnswerViewModel vm) { //Reinitialize the options for the select lists vm.Courses = context.ReadAllCourses().ToList(); vm.LearnOutcomes = context.ReadAllOutcomes().ToList(); //TODO: Fix the value cannot be null problem if (!ModelState.IsValid) { return(View("Add", vm)); } QuesAnswer Qa = new QuesAnswer { Question = vm.Question, Answer = vm.Answer, Course = context.ReadCourse(vm.CourseId), LearnOutcome = context.ReadOutcome(vm.LearnOutcomeId) }; context.createQuesetion(Qa); return(RedirectToAction("Index")); }
/// <summary> /// Create a QuesAnswer /// </summary> /// /// <returns></returns> public QuesAnswer createQuesetion(QuesAnswer Qa) { _db.QuesAnswer.Add(Qa); _db.SaveChanges(); return(Qa); }
/// <summary> /// Add a QuesAnswer /// </summary> /// /// <returns></returns> public QuesAnswer AddQA(QuesAnswer Qa) { throw new NotImplementedException(); }