/// <summary> /// 修改题目 /// </summary> /// <param name="entity"></param> /// <returns></returns> public static int UpdateQustion(QusetionView entity) { DataCommand cmd = new DataCommand("MockTest.UpdateQustion"); cmd.SetParameter(entity); int result = cmd.ExecuteNonQuery(); return(result); }
/// <summary> /// 新增题目 /// </summary> /// <param name="entity"></param> /// <returns></returns> public static int InsertQustion(QusetionView entity) { DataCommand cmd = new DataCommand("MockTest.InsertQustion"); cmd.SetParameter(entity); int result = cmd.ExecuteScalar <int>(); return(result); }
public void ImportQusetion(DataTable data, List <DocumentValid> documentList, List <DocumentValid> userTagList, string userid) { List <QusetionView> list = new List <QusetionView>(); foreach (System.Data.DataRow item in data.Rows) { var row = item.ItemArray; //查询关联文档 判断关联文档与序号是否存在 QusetionView qusetion = new QusetionView { //关联文档标题 document_name = row[1] + "", //题目序号 order_num = int.Parse(row[2] + ""), //题目文本内容 content = row[3] + "" }; //文档id qusetion.document_id = documentList.Where(_ => _.name.Equals(qusetion.document_name)).FirstOrDefault().id; var usertagname = row[0] + ""; var userTagid = userTagList.Where(_ => _.name.Equals(usertagname)).FirstOrDefault().user_tag; qusetion.user_tag = userTagid; //题型 switch (int.Parse(row[4] + "")) { case 1: qusetion.mode = Question_Mode.Single; break; case 2: qusetion.mode = Question_Mode.Multiple; break; case 3: qusetion.mode = Question_Mode.Judge; break; default: break; } qusetion.answer_analysis = string.IsNullOrEmpty(row[5] + "") ? "" :row[5] + ""; //IP限制 qusetion.is_ip_restrict = string.IsNullOrEmpty(row[6] + "") ? 0 : int.Parse(row[6] + ""); //用户限制 qusetion.is_user_restrict = string.IsNullOrEmpty(row[7] + "") ? 0 : int.Parse(row[7] + ""); //正确答案 string is_rightStr = row[8] + ""; List <AnswerView> answerList = new List <AnswerView>(); AddAnswer(row, answerList, is_rightStr); qusetion.AnswerList = answerList; list.Add(qusetion); } InsertQusetion(list, userid); }
/// <summary> /// 修改题目 /// </summary> /// <param name="entity"></param> public string UpdateQustion(QusetionView entity) { if (entity.id > 0) { entity.update_time = DateTime.Now; List <DocumentValid> document = new List <DocumentValid>(); var msg = DocumentValidMsg(entity.document_name, entity.order_num + "", document); if (!string.IsNullOrEmpty(msg) && (document.Count == 0 || document.FirstOrDefault().QuestionId != entity.qusetionId)) { return(msg); } entity.document_id = document.FirstOrDefault().id; MockTestDA.UpdateQustion(entity); foreach (var item in entity.AnswerList) { MockTestDA.UpdateAnswer(item); } } return(string.Empty); }
public ActionResult SaveQusetion(QusetionView data) { data.update_user = CurrUser.UserID; data.id = data.qusetionId; var result = MockTestBasisService.UpdateQustion(data); if (string.IsNullOrEmpty(result)) { return(Json(new AjaxResult() { Data = data, Success = true, Message = "保存成功!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new AjaxResult() { Data = data, Success = false, Message = result }, JsonRequestBehavior.AllowGet)); } }