/// <summary> /// 提交全部问卷(更新总分数,批改状态和问卷完成状态) /// </summary> /// <param name="businessPersonnelVguid"></param> /// <param name="businessQuestionVguid"></param> /// <returns></returns> public U_ExerciseResult SubmitAllQuestion(string businessPersonnelVguid, string businessQuestionVguid) { using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance()) { //bool isExistShortAnswer = IsExistShortMsg(businessQuestionVguid); U_ExerciseResult exerciseResult = new U_ExerciseResult(); int isParticipateStatus = 1;//本套问卷总分 Guid personVguid = Guid.Parse(businessPersonnelVguid); Guid questionVguid = Guid.Parse(businessQuestionVguid); var questionAnswerModel = dbMsSql.Queryable <Business_Questionnaire_Answer>().Where(i => i.Business_PersonnelVguid == personVguid && i.QuestionnaireVguid == questionVguid).SingleOrDefault(); //是否参与回答问卷 var questionAnswerDetailList = dbMsSql.Queryable <Business_Questionnaire_AnswerDetail>().Where(i => i.QuestionnaireAnswerVguid == questionAnswerModel.Vguid).ToList(); foreach (var item in questionAnswerDetailList) { if (!string.IsNullOrEmpty(item.Answer)) { isParticipateStatus = 2; break; } } var model = new { ParticipateStatus = isParticipateStatus, Status = 2, ChangeDate = DateTime.Now }; exerciseResult.isComplete = dbMsSql.Update <Business_Questionnaire_Answer>(model, i => i.Vguid == questionAnswerModel.Vguid); //存入操作日志表 string logData = JsonHelper.ModelToJson(questionAnswerModel); _ll.SaveLog(4, 34, businessPersonnelVguid, "(用户:" + businessPersonnelVguid + "提交了" + businessQuestionVguid + "套题信息)", logData); return(exerciseResult); } }
/// <summary> /// 提交全部习题(更新总分数,批改状态和习题完成状态) /// </summary> /// <param name="businessPersonnelVguid"></param> /// <param name="businessExercisesVguid"></param> /// <returns></returns> public U_ExerciseResult SubmitAllExercise(string businessPersonnelVguid, string businessExercisesVguid) { using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance()) { bool isExistShortAnswer = IsExistShortMsg(businessExercisesVguid); U_ExerciseResult exerciseResult = new U_ExerciseResult(); int score = 0; //本套习题总分 Guid personVguid = Guid.Parse(businessPersonnelVguid); Guid exerciseVguid = Guid.Parse(businessExercisesVguid); var exerciseAnswerModel = dbMsSql.Queryable <Business_ExercisesAnswer_Information>().Where(i => i.BusinessPersonnelVguid == personVguid && i.BusinessExercisesVguid == exerciseVguid).SingleOrDefault(); exerciseAnswerModel.SolveNumber = exerciseAnswerModel.SolveNumber ?? 0; exerciseAnswerModel.SolveNumber++; var exerciseAnswerDetailList = dbMsSql.Queryable <Business_ExercisesAnswerDetail_Information>().Where(i => i.BusinessAnswerExercisesVguid == exerciseAnswerModel.Vguid).ToList(); foreach (var item in exerciseAnswerDetailList) { score += item.Score; } if (!isExistShortAnswer) { var model = new { TotalScore = score, Marking = 2, Status = 2, SolveNumber = exerciseAnswerModel.SolveNumber, ChangeDate = DateTime.Now }; exerciseResult.isComplete = dbMsSql.Update <Business_ExercisesAnswer_Information>(model, i => i.Vguid == exerciseAnswerModel.Vguid); exerciseResult.score = score; } else { var model = new { TotalScore = score, Marking = 1, Status = 2, SolveNumber = exerciseAnswerModel.SolveNumber, ChangeDate = DateTime.Now }; exerciseResult.isComplete = dbMsSql.Update <Business_ExercisesAnswer_Information>(model, i => i.Vguid == exerciseAnswerModel.Vguid); exerciseResult.score = -1; } //存入操作日志表 string logData = JsonHelper.ModelToJson(exerciseAnswerModel); _ll.SaveLog(4, 34, businessPersonnelVguid, "(用户:" + businessPersonnelVguid + "提交了" + businessExercisesVguid + "套题信息)", logData); return(exerciseResult); } }
public JsonResult SubmitAllQuestion(string businessPersonnelVguid, string businessQuestionVguid) { var model = new ActionResultModel <String>(); U_ExerciseResult questionResult = new U_ExerciseResult(); //bool isExistShortMsg = false; //isExistShortMsg = _wl.IsExistShortMsg(businessExercisesVguid); //if (!isExistShortMsg) //{ questionResult = _wl.SubmitAllQuestion(businessPersonnelVguid, businessQuestionVguid); model.isSuccess = questionResult.isComplete; if (model.isSuccess) { model.respnseInfo = "1"; } //} //else //{ // model.isSuccess = true; // model.respnseInfo = "-1";//存在简答题,提示答题已完成 //} return(Json(model, JsonRequestBehavior.AllowGet)); }