public JsonResult SubmitAnswer(SubmitAnswerParameter parameter) { UserAnswerService service = new UserAnswerService(); var model = service.SubmitAnswer(parameter); return(Json(model)); }
//用户选择时保存答案的接口 public SubmitResponseModel SubmitAnswer(SubmitAnswerParameter parameter) { SubmitResponseModel model = new SubmitResponseModel(); try { var userScore = DataHelp.GetUserScore(parameter.UserId); if (userScore.IsSubmit != "1") { if (DataHelp.SubmitAnswer(parameter)) { var questionList = DataHelp.GetQuestionList(); int sum = 0; foreach (var answer in parameter.UserAnswerList) { var userAnswer = questionList.Where(x => x.Id == answer.QuestionId).FirstOrDefault(); if (userAnswer != null) { if (userAnswer.Answer == answer.Answer) { if (userAnswer.Multi == "1") { sum++; } else { sum = sum + 2; } } } } if (DataHelp.SubmitScore(parameter.UserId, sum)) { model.Score = sum.ToString(); model.Status = "1"; } else { model.Status = "0"; } } } else { model.Score = userScore.Score.ToString(); model.Status = "1"; } } catch { model.Status = "0"; } return(model); }
public static bool SubmitAnswer(SubmitAnswerParameter parameter) { StringBuilder sql = new StringBuilder(); foreach (var answer in parameter.UserAnswerList) { sql.Append(string.Format(@"INSERT INTO [WaterSupplySecurity].[dbo].[UserAnswer]([UserId],[QuestionId],[Answer]) VALUES({0},{1},'{2}');", parameter.UserId, answer.QuestionId, answer.Answer)); } int reuslt = DataAcccessHelper.Execute(sql.ToString()); if (reuslt > 0) { return(true); } return(false); }