public int AddSurveyExampaper(ResSurveyExampaper exampaper)
{
//先保存问卷表，获取问卷的Id
int id = _dataAccess.AddEntity(exampaper);
foreach (var question in exampaper.Questions)
{
question.ExampaperID = id;
question.TenantId = exampaper.TenantId;
question.userID = exampaper.UserID;
}
AddQuestions(exampaper.Questions);
return(id);
}
public bool UpdateExampaper(ResSurveyExampaper info)
{
//先删除该问卷下的所有问题
var deleteWhere = "Res_SurveyQuestion.ExampaperID=" + info.ExampaperID;
var optionDeleteWhere = "Res_SurveyQuestionAnswer.QuestionID IN (" +
info.Questions.Select(p => p.QuestionID).GetString() + ")";
_dataAccess.DeleteEntities <ResSurveyQuestion>(deleteWhere);
_dataAccess.DeleteEntities <ResSurveyQuestionAnswer>(optionDeleteWhere);
foreach (var question in info.Questions)
{
question.ExampaperID = info.ExampaperID;
question.TenantId = info.TenantId;
question.userID = info.UserID;
}
AddQuestions(info.Questions);
return(_dataAccess.UpdateEntity(info) > 0);
}
public bool DeleteExampaper(ResSurveyExampaper info)
{
info.Status = 1;
return(_dataAccess.UpdateEntity(info) > 0);
}
