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();
}
}
}
