/// <summary>
/// 获取[结业考试]题目信息
/// </summary>
/// <param name="iTrainingId"></param>
/// <param name="strVerson"></param>
/// <returns></returns>
private List<Course_UnitTest> GetExamCourseUnitTest(int iTrainingId = 0, string strVerson = "")
{
var List_Course_UnitTest = new List<Course_UnitTest>();
var unitTestBll = new Course_UnitTestBLL();
var strOrderBy = "CreateDate";
var stbSqlWhere = new StringBuilder();
if (!string.IsNullOrEmpty(strVerson))
{
stbSqlWhere.AppendFormat(" TrainingId = {0} AND Verson = '{1}'", iTrainingId, strVerson);
}
else
{
stbSqlWhere.AppendFormat(" Display = 1 AND Delflag = 0 AND TrainingId = {0}", iTrainingId);
}
List_Course_UnitTest = unitTestBll.GetList(stbSqlWhere.ToString(), strOrderBy);
ViewBag.List_Course_UnitTest = List_Course_UnitTest;
ViewBag.ExamRecordCount = List_Course_UnitTest.Count;
ViewBag.ExamTrainingId = List_Course_UnitTest == null || List_Course_UnitTest.Count <= 0 ? 0 : List_Course_UnitTest[0].TrainingId;
return List_Course_UnitTest;
}
/// <summary>
/// 提交答案到用户答案表
/// </summary>
/// <param name="listResultOther"></param>
/// <param name="iId">总分表的Id</param>
/// <returns></returns>
private bool SaveMember_CourseContentTestAnswer(List<Member_CourseContentTestAnswerOther> listResultOther, int iId)
{
var unitTestBll = new Course_UnitTestBLL();
var TestAnswerBll = new Member_CourseContentTestAnswerBLL();
int iAccountId = 0;
bool bolRes = false;
iAccountId = Code.SiteCache.Instance.LoginInfo.UserId;
foreach (var item in listResultOther)
{
var Model_Answer = new Member_CourseContentTestAnswer();
//获取该题目的正确答案
var Model_Test = unitTestBll.GetModel(item.Id, string.Empty);
double dblGetCreTmp = 0;
double.TryParse(item.Credits, out dblGetCreTmp);
Model_Answer.AnswerResult = iId;
Model_Answer.Question = item.Id;
Model_Answer.Answer = item.Answer;
Model_Answer.Result = Model_Test.QTtype == 4 ? true : Model_Test.Answer == item.Answer;//比对正确答案 若是问答题,直接设置为True
Model_Answer.AccountId = iAccountId;
Model_Answer.Delflag = false;
Model_Answer.CreateDate = DateTime.Now;
//将数据插入到学员答题内容表,用户的[结业考试]答案保存
bolRes = TestAnswerBll.Add(Model_Answer);
}
return bolRes;
}
public ActionResult ExamQuesModel(int Id)
{
Course_UnitTest model = new Course_UnitTestBLL().GetModel(Id,"Display = 1 and Delflag = 0");
return Json(new { Data = model }, JsonRequestBehavior.AllowGet);
}
public ActionResult ExemExeclTemp(int TrainingId)
{
Course_UnitTestBLL course_UnitTestBLL = new Course_UnitTestBLL();
string msg = "";
HttpPostedFileBase excel = Request.Files[0];
string fileName = Server.MapPath(Code.UploadCore.UploadAttach(excel, ref msg));
int GroupId = Code.SiteCache.Instance.GroupId;
int OrganId = Code.SiteCache.Instance.ManageOrganId;
DataTable dt = ReadExcel(fileName);
if (dt.Columns[0].ColumnName.ToString() != "类型" || dt.Columns[1].ColumnName.ToString() != "题目内容" || dt.Columns[2].ColumnName.ToString() != "答案内容" || dt.Columns[3].ColumnName.ToString() != "正确答案序号" || dt.Columns[4].ColumnName.ToString() != "权重")
{
return Content("no:导入的格式不正确!");
}
else
{
List<Course_UnitTest> list = new List<Course_UnitTest>();
if (dt.Rows.Count == 0)
{
return Content("no:无导入数据!");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
for (int k = 0; k < dt.Columns.Count; k++)
{
if (string.IsNullOrEmpty(dt.Rows[i][k].ToString()))
{
return Content("no:导入的数据有空值!");
}
}
Course_UnitTest model = new Course_UnitTest();
model.TrainingId = TrainingId;
model.Verson = "-1";
if (dt.Rows[i][2].ToString().Trim().IndexOf(',') > 0)
{
string[] Questions = dt.Rows[i][2].ToString().Trim().Split(',');
model.Question = "[";
for (int c = 0; c < Questions.Length; c++)
{
model.Question += "{Id:" + (c + 1) + ",Content:'" + Questions[c] + "'},";
}
model.Question = model.Question.TrimEnd(',') + "]";
}
else
{
model.Question = dt.Rows[i][2].ToString().Trim();
}
model.Answer = dt.Rows[i][3].ToString().Trim();
switch (dt.Rows[i][0].ToString().Trim())
{
case "单选题":
model.QTtype = 1;
break;
case "多选题":
model.QTtype = 2;
break;
case "判断题":
model.QTtype = 3;
model.Question = "[{Id:1,Content:'1'},{Id:2,Content:'0'}]";
break;
case "问答题":
model.QTtype = 4;
model.Question = "";
model.Answer = "";
break;
default:
break;
}
model.Content = dt.Rows[i][1].ToString().Trim();
if (Regex.IsMatch(dt.Rows[i][4].ToString(), @"^[+-]?\d*[.]?\d*$"))
{
model.Credit = Convert.ToDouble(dt.Rows[i][4]);
}
else
{
return Content("no:权重必须是数字类型!");
}
if (dt.Rows[i][4].ToString().Length > 2)
{
return Content("no:权重数字长度不能超过五位数!");
}
if (dt.Rows[i][4].ToString() == "0")
{
return Content("no:第" + (i + 1) + "行的权重不能为0!");
}
model.Display = true;
model.Delflag = false;
model.CreateDate = DateTime.Now;
list.Add(model);
}
catch (Exception ex)
{
return Content("no:" + ex);
}
}
int count = course_UnitTestBLL.AddExem(list);
if (count > 0)
{
return Content("yes:成功导入" + list.Count + "行数据");
}
else
{
return Content("no:导入失败");
}
}
}
}
public ActionResult DeleteUnitTest(int id)
{
Course_UnitTestBLL bll = new Course_UnitTestBLL();
if (bll.Delete(id))
{
return Json(new { Result = true, Msg = "删除成功!" }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { Result = false, Msg = "删除失败!" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult EditUnitTest(Course_Test model)
{
Course_UnitTestBLL bll = new Course_UnitTestBLL();
if (bll.UpdateCourseTest(model))
{
return Json(new { Result = true, Msg = "修改成功!" }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { Result = false, Msg = "修改失败!" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult CourseActivityExamQues(int TrainingId, int UnitContent)
{
//ViewBag.Title = "添加结业考试试题";
Course_DetailBLL bll = new Course_DetailBLL();
Course_UnitTestBLL bll_UnitTest = new Course_UnitTestBLL();
//指定课程的课程ID
ViewBag.TrainingId = TrainingId;
//指定活动单元的ID
ViewBag.UnitContent = UnitContent;
//获取指定课程ID对应的课程单元信息
ViewBag.TrainingInfo = bll.GetTrainingInfoById(Convert.ToInt32(TrainingId));
//获取指定课程ID对应的课程试题信息
ViewBag.ExamQuesInfo = bll_UnitTest.GetExamQuesInfo(Convert.ToInt32(TrainingId));
return View();
}
public ActionResult CourseActivityExamEdit(int TrainingId, int UnitId)
{
//ViewBag.Title = "结业考试编辑";
Course_DetailBLL bll_CourseDetail = new Course_DetailBLL();
Course_UnitContentBLL bll = new Course_UnitContentBLL();
Course_UnitTestBLL bll_UnitTest = new Course_UnitTestBLL();
//指定课程的课程ID
ViewBag.TrainingId = TrainingId;
//获取指定课程ID对应的课程单元信息
ViewBag.TrainingInfo = bll_CourseDetail.GetTrainingInfoById(Convert.ToInt32(TrainingId));
//获取结业考试Model
ViewBag.ActivityExamModel = bll.GetModel(Convert.ToInt32(UnitId), "Delflag = 0");
//指定课程是否已经添加试题
ViewBag.IsExistsExamQues = bll_UnitTest.IsExistsExamQues(Convert.ToInt32(TrainingId));
return View();
}
public ActionResult AddEaxmQues(Course_UnitTest model)
{
Course_UnitTestBLL bll = new Course_UnitTestBLL();
if (bll.Add(model))
{
return Json(new { Result = true, Msg = "新增成功!" }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { Result = false, Msg = "新增失败!" }, JsonRequestBehavior.AllowGet);
}
}
public ActionResult SetExamVerson(int TrainingId)
{
Course_UnitTestBLL bll = new Course_UnitTestBLL();
if (bll.SetVerson(TrainingId))
{
return Json(new { Result = true, Msg = "您已经完成结业试题制作!" }, JsonRequestBehavior.AllowGet);
}
else
{
return Json(new { Result = false, Msg = "结业试题制作失败!" }, JsonRequestBehavior.AllowGet);
}
}
/// <summary>
/// 获取[结业考试]题目信息
/// </summary>
/// <returns></returns>
private List<Course_UnitTest> GetExamCourseUnitTest(int iTrainingId = 0)
{
var List_Course_UnitTest = new List<Course_UnitTest>();
var unitTestBll = new Course_UnitTestBLL();
var strOrderBy = "CreateDate";
var stbSqlWhere = new StringBuilder();
stbSqlWhere.AppendFormat("Display = 1 AND Delflag = 0 AND TrainingId={0}", iTrainingId);
List_Course_UnitTest = unitTestBll.GetList(stbSqlWhere.ToString(), strOrderBy);
ViewBag.List_Course_UnitTest = List_Course_UnitTest;
ViewBag.ExamRecordCount = List_Course_UnitTest.Count;
ViewBag.ExamTrainingId = List_Course_UnitTest == null || List_Course_UnitTest.Count <= 0 ? 0 : List_Course_UnitTest[0].TrainingId;
return List_Course_UnitTest;
}