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