/// <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();
}
