/// <summary>
/// 修改问题。如果问题被问卷引用，则不对原问题修改，直接新增一个问题，否则直接修改
/// </summary>
/// <param name="question"></param>
/// <returns></returns>
public bool UpdateQuestion(Models.Cde.Cde_IndexQuestion question)
{
int usecount =
(int)
_dataAccess.ExecuteScalar(@"SELECT count(1) FROM Cde_SurveyQuestion sq JOIN Cde_SurveyExampaper se ON sq.ExampaperID=se.ExampaperID
WHERE se.IsDelete=0 AND se.TenantId=1" + question.TenantId);
if (usecount > 0)
{
AddQuestion(question);
}
else
{
//直接修改
var sqlwhere = "Cde_IndexQuestionAnswer.QuestionId=" + question.QuestionId;
_dataAccess.DeleteEntities <Cde_IndexQuestionAnswer>(sqlwhere);
_dataAccess.UpdateEntity(question);
foreach (var answer in question.Answers)
{
answer.QuestionId = question.QuestionId;
}
_dataAccess.AddEntities(question.Answers);
}
return(true);
}
public int AddQuestion(Models.Cde.Cde_IndexQuestion question)
{
_dataAccess.AddEntity(question);
if (question.Answers.Count > 0)
{
foreach (var answer in question.Answers)
{
answer.QuestionId = question.QuestionId;
}
_dataAccess.AddEntities(question.Answers);
}
return(question.QuestionId);
}
public bool DeleteQuestion(Models.Cde.Cde_IndexQuestion question)
{
//question.IsDelete = 1;
return(_dataAccess.UpdateField("Cde_IndexQuestion", "IsDelete", "1", "QuestionId=" + question.QuestionId) > 0);
//_dataAccess.UpdateEntity(question) > 0;
}
