private void WriteAnswers(Question qu)
{
//foreach (Answer a in qu.Answers)
//{
// wr.WriteStartElement("Answer");
// wr.WriteStartAttribute("withInput");
// wr.WriteValue(a.WithInput);
// wr.WriteEndAttribute();
// wr.WriteStartAttribute("excludes");
// wr.WriteValue(a.Excludes);
// wr.WriteEndAttribute();
// wr.WriteStartElement("Title");
// wr.WriteCData(a.Title);
// wr.WriteEndElement();
// wr.WriteStartElement("Data");
// wr.WriteCData(a.Data);
// wr.WriteEndElement();
// wr.WriteEndElement();
//}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (IsPost)
{
switch (AjaxAction)
{
case "QuestionaryPage.save":
SaveQuestionary();
return;
case "QuestionaryPage.saveQuestion":
SaveQuestion();
return;
case "QuestionaryPage.saveAnswer":
SaveAnswer();
return;
case "QuestionaryPage.getQuestion":
GetQuestion();
return;
case "QuestionaryPage.getAnswer":
GetAnswer();
return;
case "QuestionaryPage.delQuestion":
DeleteQuestion();
return;
case "QuestionaryPage.delAnswer":
DeleteAnswer();
return;
}
}
else
{
if (Request["cateId"] != null)
{
CategoryId = Request["cateId"].Trim();
CurrentQuestionary = Questionary.Get(CategoryId);
}
if (CurrentQuestionary == null)
{
CurrentQuestionary = new Questionary(CategoryId);
}
if (Request["qid"] != null)
{
try
{
QuestionId = Convert.ToInt32(Request["qid"]);
CurrentQuestion = Question.Get(QuestionId);
}
catch
{
//
}
}
if (CurrentQuestion == null)
{
CurrentQuestion = new Question();
}
}
}
private void SaveQuestion()
{
Response.Clear();
if (Request.Form["qCateId"] != null &&
Request.Form["qSort"] != null &&
Request.Form["qTitle"] != null &&
Request.Form["qRequireTitle"] != null &&
Request.Form["qRemark"] != null &&
Request.Form["qMode"] != null &&
Request.Form["qDecoration"] != null)
{
try
{
int qid = 0;
if (Request.Form["qId"] != null)
{
qid = Convert.ToInt32(Request.Form["qId"]);
}
Question q = new Question();
q.SortNum = Convert.ToInt16(Request.Form["qSort"]);
q.CategoryId = Request.Form["qCateId"].Trim();
q.Title = Request.Form["qTitle"].Trim();
q.RequestTitle = Request.Form["qRequireTitle"].Trim();
q.Remark = Request.Form["qRemark"].Trim();
q.VariableName = Request.Form["qName"].Trim();
q.Mode = (QuestionMode)(Convert.ToInt16(Request.Form["qMode"].Trim()));
q.Required = Request.Form["qIsRequired"] != null;
q.AllowSearch = Request.Form["qAllowSrh"] != null;
q.Enable = Request.Form["qEnable"] != null;
q.Decoration = (QuestionDecoration)(Convert.ToInt16(Request.Form["qDecoration"]));
qid = q.Save(qid);
Response.Write(qid);
}
catch (Exception e)
{
Response.Write(e.ToString());
}
}
Response.End();
}
public static ArrayList List(string cateId,bool onlyEnabled)
{
/*
QuestionList
* @cateId varchar(30)
*/
//[Id],CategoryId, Title, RequestTitle, Mode, VariableName, Required, AllowSearch, SortNum,Enable,Decoration,Remark
ArrayList list = new ArrayList();
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "QuestionList",
new SqlParameter[] { Database.MakeInParam("@cateId", SqlDbType.Int, cateId), Database.MakeInParam("@enabled", SqlDbType.Bit, onlyEnabled) });
while (reader.Read())
{
Question q = new Question();
q.id = reader.GetInt32(0);
q.categoryId = reader.GetString(1);
q.title = reader.GetString(2);
q.requestTitle = reader.GetString(3);
q.mode = (QuestionMode)(reader.GetInt16(4));
q.variableName = reader.GetString(5);
q.required = reader.GetString(6) == "1";
q.allowSearch = reader.GetString(7) == "1";
q.sortNum = reader.GetInt16(8);
q.enable = reader.GetString(9) == "1";
q.decoration = (QuestionDecoration)(reader.GetInt16(10));
q.remark = reader.GetString(11);
list.Add(q);
}
reader.Close();
}
catch
{
//throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return list;
}
public static Question Get(int qid)
{
/*
QuestionGet
* @id int
*/
//CategoryId, Title, RequestTitle,Remark, Mode, VariableName, Required, AllowSearch, SortNum,Enable,Decoration
Question q = null;
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "QuestionGet",
new SqlParameter[] {Database.MakeInParam("@id",SqlDbType.Int,qid) });
if (reader.Read())
{
q = new Question();
q.id = qid;
q.categoryId = reader.GetString(0);
q.title = reader.GetString(1);
q.requestTitle = reader.GetString(2);
q.remark = reader.GetString(3);
q.mode = (QuestionMode)(reader.GetInt16(4));
q.variableName = reader.GetString(5);
q.required = reader.GetString(6) == "1";
q.allowSearch = reader.GetString(7) == "1";
q.sortNum = reader.GetInt16(8);
q.enable = reader.GetString(9) == "1";
q.decoration = (QuestionDecoration)(reader.GetInt16(10));
}
reader.Close();
}
catch
{
//
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return q;
}
