protected void btnSave_Click(object sender, EventArgs e) { Maticsoft.Model.Shop.Gift.GiftsCategory model = new Maticsoft.Model.Shop.Gift.GiftsCategory { Name = this.txtName.Text, Description = this.txtDescription.Text }; if (!string.IsNullOrWhiteSpace(this.DropParentId.SelectedValue.Trim())) { model.ParentCategoryId = new int?(int.Parse(this.DropParentId.SelectedValue)); } else { model.ParentCategoryId = 0; } model.Depth = 0; model.Path = ""; if (this.bll.AddCategory(model)) { this.btnSave.Enabled = false; this.btnCancle.Enabled = false; MessageBox.ShowSuccessTip(this, "添加成功,正在跳转...", "CategoryList.aspx"); } else { this.btnSave.Enabled = false; this.btnCancle.Enabled = false; MessageBox.ShowFailTip(this, "添加失败!"); } }
public List<Maticsoft.Model.Shop.Gift.GiftsCategory> DataTableToList(DataTable dt) { List<Maticsoft.Model.Shop.Gift.GiftsCategory> list = new List<Maticsoft.Model.Shop.Gift.GiftsCategory>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.Shop.Gift.GiftsCategory item = new Maticsoft.Model.Shop.Gift.GiftsCategory(); if ((dt.Rows[i]["CategoryID"] != null) && (dt.Rows[i]["CategoryID"].ToString() != "")) { item.CategoryID = int.Parse(dt.Rows[i]["CategoryID"].ToString()); } if ((dt.Rows[i]["ParentCategoryId"] != null) && (dt.Rows[i]["ParentCategoryId"].ToString() != "")) { item.ParentCategoryId = new int?(int.Parse(dt.Rows[i]["ParentCategoryId"].ToString())); } if ((dt.Rows[i]["Name"] != null) && (dt.Rows[i]["Name"].ToString() != "")) { item.Name = dt.Rows[i]["Name"].ToString(); } if ((dt.Rows[i]["Depth"] != null) && (dt.Rows[i]["Depth"].ToString() != "")) { item.Depth = int.Parse(dt.Rows[i]["Depth"].ToString()); } if ((dt.Rows[i]["Path"] != null) && (dt.Rows[i]["Path"].ToString() != "")) { item.Path = dt.Rows[i]["Path"].ToString(); } if ((dt.Rows[i]["DisplaySequence"] != null) && (dt.Rows[i]["DisplaySequence"].ToString() != "")) { item.DisplaySequence = int.Parse(dt.Rows[i]["DisplaySequence"].ToString()); } if ((dt.Rows[i]["Description"] != null) && (dt.Rows[i]["Description"].ToString() != "")) { item.Description = dt.Rows[i]["Description"].ToString(); } if ((dt.Rows[i]["Theme"] != null) && (dt.Rows[i]["Theme"].ToString() != "")) { item.Theme = dt.Rows[i]["Theme"].ToString(); } if ((dt.Rows[i]["HasChildren"] != null) && (dt.Rows[i]["HasChildren"].ToString() != "")) { if ((dt.Rows[i]["HasChildren"].ToString() == "1") || (dt.Rows[i]["HasChildren"].ToString().ToLower() == "true")) { item.HasChildren = true; } else { item.HasChildren = false; } } list.Add(item); } } return list; }
public Maticsoft.Model.Shop.Gift.GiftsCategory GetModel(int CategoryID) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 CategoryID,ParentCategoryId,Name,Depth,Path,DisplaySequence,Description,Theme,HasChildren from Shop_GiftsCategory "); builder.Append(" where CategoryID=@CategoryID"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@CategoryID", SqlDbType.Int, 4) }; cmdParms[0].Value = CategoryID; Maticsoft.Model.Shop.Gift.GiftsCategory category = new Maticsoft.Model.Shop.Gift.GiftsCategory(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["CategoryID"] != null) && (set.Tables[0].Rows[0]["CategoryID"].ToString() != "")) { category.CategoryID = int.Parse(set.Tables[0].Rows[0]["CategoryID"].ToString()); } if ((set.Tables[0].Rows[0]["ParentCategoryId"] != null) && (set.Tables[0].Rows[0]["ParentCategoryId"].ToString() != "")) { category.ParentCategoryId = new int?(int.Parse(set.Tables[0].Rows[0]["ParentCategoryId"].ToString())); } if ((set.Tables[0].Rows[0]["Name"] != null) && (set.Tables[0].Rows[0]["Name"].ToString() != "")) { category.Name = set.Tables[0].Rows[0]["Name"].ToString(); } if ((set.Tables[0].Rows[0]["Depth"] != null) && (set.Tables[0].Rows[0]["Depth"].ToString() != "")) { category.Depth = int.Parse(set.Tables[0].Rows[0]["Depth"].ToString()); } if ((set.Tables[0].Rows[0]["Path"] != null) && (set.Tables[0].Rows[0]["Path"].ToString() != "")) { category.Path = set.Tables[0].Rows[0]["Path"].ToString(); } if ((set.Tables[0].Rows[0]["DisplaySequence"] != null) && (set.Tables[0].Rows[0]["DisplaySequence"].ToString() != "")) { category.DisplaySequence = int.Parse(set.Tables[0].Rows[0]["DisplaySequence"].ToString()); } if ((set.Tables[0].Rows[0]["Description"] != null) && (set.Tables[0].Rows[0]["Description"].ToString() != "")) { category.Description = set.Tables[0].Rows[0]["Description"].ToString(); } if ((set.Tables[0].Rows[0]["Theme"] != null) && (set.Tables[0].Rows[0]["Theme"].ToString() != "")) { category.Theme = set.Tables[0].Rows[0]["Theme"].ToString(); } if ((set.Tables[0].Rows[0]["HasChildren"] != null) && (set.Tables[0].Rows[0]["HasChildren"].ToString() != "")) { if ((set.Tables[0].Rows[0]["HasChildren"].ToString() == "1") || (set.Tables[0].Rows[0]["HasChildren"].ToString().ToLower() == "true")) { category.HasChildren = true; return category; } category.HasChildren = false; } return category; }