public int UpdateExampaper(Cde_SurveyExampaper exampaper)
{
var count = _dataAccess.GetCount <SurveyInfo>("Cde_SurveyInfo.ExampaperId=" + exampaper.ExampaperID);
if (count > 0)
{
//已被调用，不修改原记录
return(AddExampaper(exampaper));
}
else
{
//修改时，把问卷和问题的关联删除，重新添加关联
var sqlwhere = "Cde_SurveyQuestion.ExampaperID=" + exampaper.ExampaperID;
_dataAccess.DeleteEntities <Cde_SurveyQuestion>(sqlwhere);
_dataAccess.UpdateEntity(exampaper);
var questions = new List <Cde_SurveyQuestion>();
for (int index = 0; index < exampaper.Questions.Count; index++)
{
var question = exampaper.Questions[index];
questions.Add(new Cde_SurveyQuestion()
{
ExampaperID = exampaper.ExampaperID,
QuestionID = question.QuestionId,
ShowOrder = index
});
}
_dataAccess.AddEntities(questions);
return(_dataAccess.UpdateEntity(exampaper));
}
}
public bool DeleteExampaper(Cde_SurveyExampaper exampaper)
{
exampaper.IsDelete = 1;
int result = _dataAccess.UpdateEntity(exampaper);
return(result > 0);
}
public ActionResult EditExampaper(int exId, string mode = "add")
{
var exampaper = _exampaperManager.GetFullExampaper(exId);
if (exampaper == null)
{
exampaper = new Cde_SurveyExampaper();
}
ViewBag.mode = mode;
return(View(exampaper));
}
public int AddExampaper(Cde_SurveyExampaper exampaper)
{
_dataAccess.AddEntity(exampaper);
var questions = new List <Cde_SurveyQuestion>();
for (int index = 0; index < exampaper.Questions.Count; index++)
{
var question = exampaper.Questions[index];
questions.Add(new Cde_SurveyQuestion()
{
ExampaperID = exampaper.ExampaperID,
QuestionID = question.QuestionId,
ShowOrder = index
});
}
_dataAccess.AddEntities(questions);
return(exampaper.ExampaperID);
}
