public static Questionary GetFile(string cate)
{
Questionary qn = new Questionary();
//XmlDocument doc = new XmlDocument();
//doc.Load(GeneralConfig.AppDataPath + "Questionaries\\" + cate + ".xml");
//Question q;
//Answer a;
//foreach (XmlNode qNode in doc.DocumentElement.SelectSingleNode("Questions").SelectNodes("Question"))
//{
// q = new Question(qNode.Attributes["name"].Value,
// qNode.SelectSingleNode("Title").FirstChild.Value,
// qNode.SelectSingleNode("RequestTitle").FirstChild.Value,
// (QuestionMode)Convert.ToInt16(qNode.Attributes["mode"].Value));
// foreach (XmlNode aNode in qNode.SelectSingleNode("Answers").SelectNodes("Answer"))
// {
// a = new Answer(aNode.SelectSingleNode("Title").FirstChild.Value,
// aNode.SelectSingleNode("Data").FirstChild.Value);
// q.Answers.Add(a);
// }
// qn.questions.Add(q);
//}
return qn;
}
public static ArrayList List()
{
/*QuestionaryList*/
//CategoryId,Title,TemplateGuid,TemplateTitle, Created, Updated
ArrayList list = new ArrayList();
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "QuestionaryList");
while (reader.Read())
{
Questionary qn = new Questionary();
qn.category = reader.GetString(0);
qn.title = reader.IsDBNull(1) ? "" : reader.GetString(1);
qn.templateId = reader.GetString(2);
qn.templateTitle = reader.GetString(3);
qn.created = reader.GetDateTime(4);
qn.updated = reader.GetDateTime(5);
list.Add(qn);
}
reader.Close();
}
catch
{
//throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return list;
}
public static Questionary Get(string cate)
{
/*
QuestionaryGet
@cateId varchar(30)
*/
//Title,TemplateGuid, Created, Updated
Questionary qn = null;
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "QuestionaryGet",
new SqlParameter[] { Database.MakeInParam("@cateId", SqlDbType.VarChar, 30, cate) });
if (reader.Read())
{
qn = new Questionary();
qn.category = cate;
qn.title = reader.IsDBNull(0) ? "" : reader.GetString(0);
qn.templateId = reader.GetString(1);
qn.created=reader.GetDateTime(2);
qn.updated=reader.GetDateTime(3);
}
reader.Close();
}
catch
{
//
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return qn;
}
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();
}
}
}
/// <summary>
/// �����ʾ������Ϣ
/// </summary>
private void SaveQuestionary()
{
Response.Clear();
if (Request.Form["cateId"] != null && Request.Form["tempId"] != null)
{
Questionary qn = new Questionary(Request.Form["cateId"].Trim());
qn.TemplateId = Request.Form["tempId"].Trim();
if (qn.Save())
{
Response.Write(qn.Category);
}
}
Response.End();
}
public static void WriteQuestionary(Questionary qn)
{
QuestionaryWriter writer = new QuestionaryWriter(qn);
writer.Write();
}
public QuestionaryWriter(Questionary qn)
{
questionary = qn;
}
