/// <summary>
/// 获取用户答案
/// </summary>
/// <param name="answerDetailList"></param>
/// <returns></returns>
public bool SaveUserAnswer(U_ExercisesAnswerDetail answerDetailModel)
{
bool result = false;//保存结果标识
//习题人员与答案主表
Business_ExercisesAnswer_Information mainExerciseAnswerModel = new Business_ExercisesAnswer_Information();
mainExerciseAnswerModel.BusinessExercisesVguid = answerDetailModel.BusinessExercisesVguid; //习题主信息Vguid
mainExerciseAnswerModel.BusinessPersonnelVguid = answerDetailModel.BusinessPersonnelVguid; //做题人Vguid
mainExerciseAnswerModel.Marking = 1; //未阅卷
mainExerciseAnswerModel.Status = 1; //未完成
//mainExerciseAnswerModel.CreatedDate = DateTime.Now;
//mainExerciseAnswerModel.ChangeDate = DateTime.Now;
//习题人员与答案附表
Business_ExercisesAnswerDetail_Information detailAnswerModel = new Business_ExercisesAnswerDetail_Information();
detailAnswerModel.Answer = answerDetailModel.Answer;
detailAnswerModel.Score = CheckAnswer(answerDetailModel.BusinessExercisesDetailVguid.ToString(), answerDetailModel.Answer); //计算题目得分
detailAnswerModel.BusinessExercisesDetailVguid = answerDetailModel.BusinessExercisesDetailVguid; //具体习题Vguid
//detailAnswerModel.BusinessAnswerExercisesVguid = answerDetailModel.BusinessAnswerExercisesVguid;
//detailAnswerModel.CreatedDate = DateTime.Now;
//detailAnswerModel.ChangeDate = DateTime.Now;
result = _ws.SaveUserAnswer(mainExerciseAnswerModel, detailAnswerModel);
LogHelper.WriteLog(JsonHelper.ModelToJson <Business_ExercisesAnswerDetail_Information>(detailAnswerModel));
return(result);
}
/// <summary>
/// 获取用户答案
/// </summary>
/// <param name="mainExerciseAnswerModel"></param>
/// <param name="detailAnswerModel"></param>
/// <returns></returns>
public bool SaveUserAnswer(Business_ExercisesAnswer_Information mainExerciseAnswerModel, Business_ExercisesAnswerDetail_Information detailAnswerModel)
{
using (SqlSugarClient dbMsSql = SugarDao_MsSql.GetInstance())
{
bool result = false;
bool mainEdit = false; //习题人员与答案主表中是否存在
bool detailEdit = false; //习题人员与答案附表中是否存在
try
{
dbMsSql.BeginTran();
mainEdit = dbMsSql.Queryable <Business_ExercisesAnswer_Information>().Any(i => i.BusinessPersonnelVguid == mainExerciseAnswerModel.BusinessPersonnelVguid && i.BusinessExercisesVguid == mainExerciseAnswerModel.BusinessExercisesVguid);
if (!mainEdit) //新增
{
mainExerciseAnswerModel.Vguid = Guid.NewGuid();
mainExerciseAnswerModel.CreatedDate = DateTime.Now;
mainExerciseAnswerModel.ChangeDate = DateTime.Now;
result = dbMsSql.Insert(mainExerciseAnswerModel, false) != DBNull.Value;
//存入操作日志表
string logData = JsonHelper.ModelToJson(mainExerciseAnswerModel);
_ll.SaveLog(1, 34, mainExerciseAnswerModel.BusinessPersonnelVguid.ToString(), "用户" + mainExerciseAnswerModel.BusinessPersonnelVguid + " " + mainExerciseAnswerModel.BusinessExercisesVguid + "套题的答题情况", logData);
}
else
{
mainExerciseAnswerModel = dbMsSql.Queryable <Business_ExercisesAnswer_Information>().Where(i => i.BusinessPersonnelVguid == mainExerciseAnswerModel.BusinessPersonnelVguid && i.BusinessExercisesVguid == mainExerciseAnswerModel.BusinessExercisesVguid).SingleOrDefault();
result = dbMsSql.Update <Business_ExercisesAnswer_Information>(new { ChangeDate = DateTime.Now }, i => i.BusinessPersonnelVguid == mainExerciseAnswerModel.BusinessPersonnelVguid && i.BusinessExercisesVguid == mainExerciseAnswerModel.BusinessExercisesVguid);
//存入操作日志表
string logData = JsonHelper.ModelToJson(mainExerciseAnswerModel);
_ll.SaveLog(4, 34, mainExerciseAnswerModel.BusinessPersonnelVguid.ToString(), "用户" + mainExerciseAnswerModel.BusinessPersonnelVguid + " " + mainExerciseAnswerModel.BusinessExercisesVguid + "套题的答题情况", logData);
}
detailEdit = dbMsSql.Queryable <Business_ExercisesAnswerDetail_Information>().Any(i => i.BusinessAnswerExercisesVguid == mainExerciseAnswerModel.Vguid && i.BusinessExercisesDetailVguid == detailAnswerModel.BusinessExercisesDetailVguid);
if (result) //主表插入成功
{
Business_ExercisesAnswerDetail_Information newDeatailAnswerModel = new Business_ExercisesAnswerDetail_Information();
if (detailEdit) //编辑
{
newDeatailAnswerModel = dbMsSql.Queryable <Business_ExercisesAnswerDetail_Information>().Where(i => i.BusinessAnswerExercisesVguid == mainExerciseAnswerModel.Vguid && i.BusinessExercisesDetailVguid == detailAnswerModel.BusinessExercisesDetailVguid).SingleOrDefault();
var model = new
{
Answer = detailAnswerModel.Answer,
Score = detailAnswerModel.Score,
ChangeDate = DateTime.Now
};
result = dbMsSql.Update <Business_ExercisesAnswerDetail_Information>(model, i => i.Vguid == newDeatailAnswerModel.Vguid);
//存入操作日志表
string logData = JsonHelper.ModelToJson(detailAnswerModel);
_ll.SaveLog(4, 34, "", detailAnswerModel.BusinessExercisesDetailVguid + "道题的答题情况", logData);
}
else //新增
{
detailAnswerModel.BusinessAnswerExercisesVguid = mainExerciseAnswerModel.Vguid;
//关联”习题人员与答案信息“主表
detailAnswerModel.Vguid = Guid.NewGuid();
detailAnswerModel.CreatedDate = DateTime.Now;
detailAnswerModel.ChangeDate = DateTime.Now;
result = dbMsSql.Insert(detailAnswerModel, false) != DBNull.Value;
//存入操作日志表
string logData = JsonHelper.ModelToJson(detailAnswerModel);
_ll.SaveLog(1, 34, "", detailAnswerModel.BusinessExercisesDetailVguid + "道题的答题情况", logData);
}
}
dbMsSql.CommitTran();
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
dbMsSql.RollbackTran();
}
return(result);
}
}
