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