protected override void OnInit(EventArgs e) { base.OnInit(e); if (Request.QueryString.ToString().Trim().Length == 6) { QueryAreaCode = Request.QueryString.ToString().Trim(); QueryAreaName = Dictionary.GetDictionaryName(DictionaryType.A, QueryAreaCode); } try { string[] args = Request.CurrentExecutionFilePath.Split('/'); CurrentCategoryCode = args[args.Length - 1].Split('.')[0]; CurrentCategory = Category.Get(CurrentCategoryCode); } catch { // } if (CurrentCategory == null) { Response.Redirect("/MarketingService/allCategories.aspx"); Response.End(); } }
private void SaveCategory() { Response.Clear(); if (Request.Form["cateId"] != null && Request.Form["parentId"] != null && Request.Form["cateName"] != null && Request.Form["catePrice"] != null && Request.Form["cateRelated"] != null && Request.Form["cateDesc"] != null) { try { string cateId = Request.Form["cateId"].Trim(); string parentId = Request.Form["parentId"].Trim(); string cateName = Request.Form["cateName"].Trim(); short catePrice = Convert.ToInt16(Request.Form["catePrice"]); string cateRelated = Request.Form["cateRelated"].Trim(); string cateDesc = Request.Form["cateDesc"].Trim(); Category cat = new Category(parentId, cateName, cateDesc, cateRelated); cat.Price = catePrice; Response.Write(cat.Save(cateId)); } catch { // } } Response.End(); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); if (Request["id"] != null) { CurrentCategory = Category.Get(Request["id"].Trim()); } if (CurrentCategory == null) { CurrentCategory = new Category(); } if (IsPost) { switch (AjaxAction) { case "CategoryPage.save": SaveCategory(); break; } } }
/// <summary> /// ��ȡ�����б��ÿ�а���[Id],Title,[Description] /// </summary> /// <param name="ids"></param> /// <returns></returns> public static ArrayList ListByIdStringAndKeywords(string ids,string key) { /* CategoryListByIdStringAndKeywords @ids varchar(5000), @key varchar(50) */ //[Id],Title,[Description] ArrayList list = new ArrayList(); SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "CategoryListByIdStringAndKeywords", new SqlParameter[] { Database.MakeInParam("@ids", SqlDbType.VarChar, 5000, ids), Database.MakeInParam("@key", SqlDbType.VarChar, 50, key) }); while (reader.Read()) { Category cat = new Category(); cat.id = reader.GetString(0); cat.title = reader.GetString(1); cat.description = reader.GetString(2); list.Add(cat); } reader.Close(); } catch { //throw e; } finally { if (reader != null) { reader.Close(); } } return list; }
/// <summary> /// �����б� /// </summary> /// <param name="parentId"></param> /// <returns></returns> public static ArrayList List(string parentId) { /*CategoryList @pid varchar(50)='100'*/ //[Id], Title, Related,Price, Leads, Suppliers, Enable ArrayList list = new ArrayList(); if (parentId==null) { parentId = ""; } SqlParameter[] prams ={ Database.MakeInParam("@pid",SqlDbType.VarChar,50,parentId) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "CategoryList", prams); while (reader.Read()) { Category cat = new Category(); cat.id = reader.GetString(0); cat.title = reader.GetString(1); cat.relatedCategories = reader.GetString(2); cat.price = reader.GetInt16(3); cat.leads = reader.GetInt32(4); cat.suppliers = reader.GetInt32(5); cat.enable = reader.GetString(6) == "1"; list.Add(cat); } reader.Close(); } catch(Exception e) { throw e; } finally { if (reader != null) { reader.Close(); } } return list; }
/// <summary> /// ��ȡ���� /// </summary> /// <param name="id"></param> /// <returns></returns> public static Category Get(string id) { /* CategoryGet @id varchar(50) */ //Title, [Description], Related,Price, Leads, Suppliers, Enable Category cate = null; SqlParameter[] prams ={ Database.MakeInParam("@id",SqlDbType.VarChar,50,id) }; SqlDataReader reader = null; try { reader = Database.ExecuteReader(CommandType.StoredProcedure, "CategoryGet", prams); if (reader.Read()) { cate = new Category(); cate.id = id; cate.title = reader.GetString(0); cate.description = reader.GetString(1); cate.relatedCategories = reader.GetString(2); cate.price = reader.GetInt16(3); cate.leads = reader.GetInt32(4); cate.suppliers = reader.GetInt32(5); cate.enable = reader.GetString(6) == "1"; } reader.Close(); } catch { //throw; } finally { if (reader != null) { reader.Close(); } } return cate; }