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