protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (Request["class"] != null) { templateClasses = Template.ConvertClassFromString(Request["class"]); } if (Request["type"] != null) { templateType = Template.ConvertTypeFromString(Request["type"]); } if (Request["guid"] != null) { templateGuid = Request["guid"].Trim(); } switch (templateClasses) { case TemplateClasses.C: PageTitle = "Categoryģ���б�"; break; case TemplateClasses.L: PageTitle = "Libraryģ���б�"; break; case TemplateClasses.S: PageTitle = "Supplierģ���б�"; break; default: PageTitle = "ģ���б�"; break; } if (templateGuid.Length == 32) { currentTemplate = Template.Get(templateGuid); } if (IsPost) { switch (AjaxAction) { case "TemplatePage.save": SaveTemplate(); break; case "TemplateList.delTemp": DeleteTemplate(); break; case "TemplateList.setDefault": SetDefaultTemplate(); break; } } }
/// <summary> /// ��ȡģ���б� /// </summary> /// <param name="tempClass">����</param> /// <param name="tempType">����</param> /// <returns></returns> public static ArrayList List(char tempClass,char tempType) { /* TemplateList @class char(1)='0', @type char(1)='0' */ //Guid, Title, Class, Type, IsDefault ArrayList list = new ArrayList(); SqlParameter[] prams ={ Database.MakeInParam("@class",SqlDbType.Char,1,tempClass), Database.MakeInParam("@type",SqlDbType.Char,1,tempType) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "TemplateList", prams); while (reader.Read()) { Template temp = new Template(); temp.guid = reader.GetString(0); temp.title = reader.GetString(1); temp.classes = ConvertClassFromString(reader.GetString(2)); temp.type = ConvertTypeFromString(reader.GetString(3)); temp.isDefault = reader.GetString(4) == "1"; list.Add(temp); } reader.Close(); } catch { // } finally { if (reader != null) { reader.Close(); } } return list; }
/// <summary> /// ����ģ�� /// </summary> private void SaveTemplate() { string _guid = ""; string _title = ""; TemplateClasses _class = TemplateClasses.U; TemplateType _type = TemplateType.U; string _content = ""; bool _default = false; if (Request.Form["tempGuid"] != null) { _guid = Request.Form["tempGuid"].Trim(); } if (Request.Form["tempTitle"] != null) { _title = Request.Form["tempTitle"].Trim(); } if (Request.Form["tempClass"] != null) { _class = Template.ConvertClassFromString(Request.Form["tempClass"]); } if (Request.Form["tempType"] != null) { _type = Template.ConvertTypeFromString(Request.Form["tempType"]); } if (Request.Form["tempContent"] != null) { _content = Request.Form["tempContent"].Trim(); } if (Request.Form["isDefault"] != null) { _default = true; } Response.Clear(); if (String.IsNullOrEmpty(_title) || _class == TemplateClasses.U || _type == TemplateType.U || String.IsNullOrEmpty(_content)) { Response.Write("0"); } else { Template temp = new Template(_class, _type, _title, _content); temp.IsDefault = _default; if (String.IsNullOrEmpty(_guid)) { Response.Write(temp.Save()); } else { Response.Write(temp.Save(_guid)); } } Response.End(); }
/// <summary> /// ��ȡģ�� /// </summary> /// <param name="guid"></param> /// <returns>Template</returns> public static Template Get(string guid) { /*TemplateGet @guid char(32) */ //Title, Class, Type, IsDefault Template temp = null; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "TemplateGet", new SqlParameter[] { Database.MakeInParam("@guid", SqlDbType.Char, 32, guid) }); if (reader.Read()) { temp = new Template(); temp.guid = guid; temp.title = reader.GetString(0); temp.classes = ConvertClassFromString(reader.GetString(1)); temp.type = ConvertTypeFromString(reader.GetString(2)); temp.isDefault = reader.GetString(3)=="1"; temp.GetContentFromFile(); } reader.Close(); } catch { // } finally { if (reader != null) { reader.Close(); } } return temp; }