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