protected void Page_Load(object sender, EventArgs e) { SurveyId = RequestData.Get <string>("id") + ""; switch (this.RequestAction) { case RequestActionEnum.Update: DoSave(); break; case RequestActionEnum.Delete: ent = this.GetTargetData <SurveyQuestion>(); ent.DoDelete(); return; default: if (RequestActionString == "GetId") { QuestionItem qItem = new QuestionItem(); qItem.SubItemId = Guid.NewGuid().ToString(); qItem.DoCreate(); this.PageState.Add("SubItemId", qItem.Id + "|" + qItem.SubItemId); } else if (RequestActionString == "Close") { DoClose(); } else { DoSelect(); } break; } }
/// <summary> /// 删除操作 /// </summary> private void DoClose() { string Id = RequestData.Get("Id") + ""; if (!string.IsNullOrEmpty(Id)) { SurveyQuestion Ent = SurveyQuestion.Find(Id); if (string.IsNullOrEmpty(Ent.SurveyTitile) && Ent.State == "0") { string SQL = @"delete from FL_Culture..QuestionItem where SurveyId='{0}' delete from FL_Culture..QuestionAnswerItem where SurveyId='{0}' delete from FL_Culture..SurveyFinallyUsr where SurveyId='{0}' delete from FL_Culture..SurveyedObj where SurveyId='{0}' delete from FL_Culture..SurveyReaderObj where SurveyId='{0}' "; SQL = string.Format(SQL, Id); DataHelper.ExecSql(SQL); Ent.DoDelete(); } } }
/// <summary> /// 删除操作 /// </summary> private void DoClose() { if (!string.IsNullOrEmpty(SurveyId)) { SurveyQuestion Ent = SurveyQuestion.Find(SurveyId); if (string.IsNullOrEmpty(Ent.SurveyTitile)) { string SQL = @"delete from FL_Culture..QuestionAnswerItem where Id in ( select id from FL_Culture..QuestionAnswerItem As A where not exists ( select * from FL_Culture..QuestionItem As B where B.SubItemId=A.QuestionItemId ) ) and SurveyId='{0}' "; SQL += " delete from FL_Culture..QuestionItem where SurveyId='{0}' "; SQL = string.Format(SQL, SurveyId); DataHelper.ExecSql(SQL); Ent.DoDelete(); } } }