/// <summary> /// 导入题目 /// </summary> /// <param name="model"></param> /// <returns></returns> public dynamic ImportQuestion(Question model, int System_Station_ID, int accountID) { string Text = "导入成功"; bool flg = false; if (Orm.Single <W_Question>(x => x.Title == model.Title && x.QuestionStore_ID == model.QuestionStore_ID && x.QuestionType_ID == model.QuestionType_ID && x.System_Station_ID == System_Station_ID) != null) { Text = "题目已存在"; } else { W_Question question = new W_Question(); question.AddPerson = accountID; question.AddTime = DateTime.Now; question.Answer = model.Answer; question.AnswerCount = model.AnswerCount; question.Body = model.Body == null ? "" : model.Body; question.Level = model.Level; question.Mark = model.Mark; question.QuestionStore_ID = model.QuestionStore_ID; question.QuestionType_ID = model.QuestionType_ID; question.Title = model.Title; question.System_Station_ID = System_Station_ID; flg = Orm.Insert <W_Question>(question) > 0; if (!flg) { Text = "导入失败"; } } return(new { Text = Text, Result = flg }); }
/// <summary> /// 修改题目 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateQuestion(W_Question model) { W_Question oldModel = Orm.Single <W_Question>(x => x.ID == model.ID); if (oldModel == null) { throw new ApiException("题目不存在或者已删除"); } if (string.IsNullOrEmpty(model.Title)) { throw new ApiException("题目不能为空"); } if (model.QuestionType_ID != oldModel.QuestionType_ID) { if (SqlMapper.QueryForObject <int>("QuestionHasBeenUsed", new { id = model.ID }) > 0) { throw new ApiException("该题目已被使用,不能修改题型"); } } model.AddPerson = oldModel.AddPerson; model.AddTime = oldModel.AddTime; model.CorrectCount = oldModel.CorrectCount; model.DoCount = oldModel.DoCount; model.EasyWrongAnswer = oldModel.EasyWrongAnswer; model.System_Station_ID = oldModel.System_Station_ID; return(Orm.Update(model) > 0); }
public dynamic UpdateQuestion(W_Question model) { bool flag = false; if (model != null && model.ID > 0) { flag = mapper.UpdateQuestion(model); } return(Success(flag ? "操作成功" : "操作失败")); }
public dynamic AddQuestion(W_Question model) { bool flag = false; if (model != null) { model.System_Station_ID = this.System_Station_ID; model.AddPerson = this.AccountID; model.AddTime = DateTime.Now; flag = mapper.AddQuestion(model); } return(Success(flag ? "操作成功" : "操作失败")); }
/// <summary> /// 禁用题库信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool DisableQuestionStore(W_QuestionStore model) { W_Question questionModel = Orm.Single <W_Question>(x => x.QuestionStore_ID == model.ID); if (questionModel != null) { throw new ApiException("题库里面存在题目,不能禁用"); } W_ExamPaper examModel = Orm.Single <W_ExamPaper>(x => x.QuestionStore_ID == model.ID); if (examModel != null) { throw new ApiException("题库里面存在试卷,不能禁用"); } return(Orm.Update(model) > 0); }
/// <summary> /// 删除题目 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool DeleteQuestion(int id, int stationId) { W_Question model = Orm.Single <W_Question>(x => x.ID == id); if (model == null) { throw new ApiException("该题目不存在或者已删除"); } if (model.System_Station_ID != stationId) { throw new ApiException("该题目不属于当前站点,不能删除"); } if (SqlMapper.QueryForObject <int>("QuestionHasBeenUsed", new { id }) > 0) { throw new ApiException("该题目已被使用,不能删除"); } return(SqlMapper.Delete("DeleteQuestion", new { id }) > 0); }
/// <summary> /// 添加题目 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddQuestion(W_Question model) { if (string.IsNullOrEmpty(model.Title)) { throw new ApiException("题目不能为空"); } W_QuestionStore store = Orm.Single <W_QuestionStore>(x => x.ID == model.QuestionStore_ID); if (store.Valid == 0) { throw new ApiException("选择的题库已被禁用,请重试"); } if (string.IsNullOrEmpty(model.Body)) { model.Body = ""; } return(Orm.Insert(model, true) > 0); }