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