public void CategoryMoveSort(Categories cate1, Categories cate2) { string UpdSql = @"Update Category SET Sort = @Sort WHERE Id = @Id"; using (MySqlConnection conn = dbHelper.GetConnection()) { conn.Open(); using (DbTransaction transaction = conn.BeginTransaction()) { dbHelper.ExecuteNonQuery(transaction, UpdSql, new MySqlParameter[]{ new MySqlParameter("@Id",cate1.Id), new MySqlParameter("@Sort",cate2.Sort) } ); dbHelper.ExecuteNonQuery(transaction, UpdSql, new MySqlParameter[]{ new MySqlParameter("@Id",cate2.Id), new MySqlParameter("@Sort",cate1.Sort) } ); transaction.Commit(); } } }
public void CategoryMoveSort(Categories cate1, Categories cate2) { productDao.CategoryMoveSort(cate1, cate2); FireEditCategoryEvent(cate1); }
public void InsertOrUpdateCategory(Categories item) { productDao.InsertOrUpdateCategory(item); FireEditCategoryEvent(item); }
private void CateTreeView_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { MoveUpMenuItem.Enabled = true; MoveDownMenuItem.Enabled = true; NewChildMenuItem.Enabled = true; DeleMenuItem.Enabled = true; selectedNode = e.Node; selectedCategory = (Categories)selectedNode.Tag; if (e.Button == MouseButtons.Right) { if (selectedNode.PrevNode == null) { MoveUpMenuItem.Enabled = false; } if (selectedNode.NextNode == null) { MoveDownMenuItem.Enabled = false; } if (selectedNode.Level > 1) { NewChildMenuItem.Enabled = false; } if (selectedNode.GetNodeCount(true) > 0) { DeleMenuItem.Enabled = false; } CateTreeView.SelectedNode = selectedNode; CateTreeView.ContextMenuStrip.Show(); } if (e.Button == MouseButtons.Left) { this.CategoryGroup.Visible = false; } }
private void NewTopButton_Click(object sender, EventArgs e) { this.CategoryGroup.Visible = true; this.CategoryGroup.Text = "新增顶级分类"; Categories cate = new Categories(); cate.ParentId = 0; cate.Level = 1; this.CategoryName.Tag = cate; this.CategoryName.Text = string.Empty; }
private void NewChildMenuItem_Click(object sender, EventArgs e) { this.CategoryGroup.Visible = true; Categories parent = (Categories)selectedNode.Tag; this.CategoryGroup.Text = "【" + parent.Name + "】新增子分类"; Categories cate = new Categories(); cate.ParentId = parent.Id; cate.Level = parent.Level + 1; this.CategoryName.Tag = cate; this.CategoryName.Text = string.Empty; }
protected void LoadUpdatedProduct(Product obj) { if (obj == null) { return; } this.PName.Text = obj.Name; this.ProductModel.Text = obj.Model; this.Weight.Text = obj.Weight; this.ProductPrice.Text = obj.Price.ToString("###0.00"); this.Psize.Text = obj.Size; this.Minimum.Text = obj.Minimum.ToString(); this.Packing.Text = obj.Packing; AliHelperUtils.LoadAppDicComboBoxValue(this.ProductStatus, obj.Status); LoadPriceCateComboBoxValue(this.PriceCate, obj.PriceCate); this.selectedCategory = new Categories(); this.selectedCategory.Id = obj.CategoryId; SetProductImages(obj); this.webBrowser1.Document.InvokeScript("SetData", new object[] { HttpUtility.HtmlDecode(obj.Description) }); }
private void NewItemForm_Load(object sender, EventArgs e) { this.ProductStatus.DisplayMember = "Label"; this.ProductStatus.ValueMember = "Key"; this.ProductStatus.DataSource = manager.GetAppDicOptions(Constants.ProductStatus); this.PriceCate.DisplayMember = "CateName"; this.PriceCate.ValueMember = "Id"; this.Minimum.Text = "100"; QueryObject<PriceCate> query = new QueryObject<PriceCate>(); query.IsExport = true; this.PriceCate.DataSource = manager.GetPriceCates(query).Result; this.selectedCategory = DataCache.Instance.SelectedCategory; LoadUpdatedProduct(UpdatedProduct); LoadCategoryTreeView(); }
private void CategoryTreeBox_SelectedNodeChanged(object sender, EventArgs e) { selectedCategory = (Categories)this.CategoryTreeBox.SelectedNode.Tag; }
private List<Categories> DataTableToCategoris(DataTable dt) { List<Categories> list = new List<Categories>(); foreach (DataRow row in dt.Rows) { Categories kw = new Categories(); kw.Id = Convert.ToInt32(row["Id"]); kw.Name = (string)row["Name"]; kw.Sort = Convert.ToInt32(row["Sort"]); kw.ChildrenCount = Convert.ToInt32(row["ChildrenCount"]); kw.Level = Convert.ToInt32(row["Level"]); kw.ParentId = Convert.ToInt32(row["ParentId"]); list.Add(kw); } return list; }
public void InsertOrUpdateCategory(Categories item) { string InsSql = @"INSERT INTO Category(Name, Sort, ChildrenCount, Level,ParentId)" + "values(@Name, @Sort, @ChildrenCount, @Level,@ParentId)"; string UpdSql = @"Update Category SET Name = @Name, Sort = @Sort, ChildrenCount = @ChildrenCount, " + "Level = @Level, ParentId = @ParentId WHERE Id = @Id"; MySqlParameter[] parameter = new MySqlParameter[] { new MySqlParameter("@Id",item.Id), new MySqlParameter("@Name",item.Name), new MySqlParameter("@Sort",item.Sort), new MySqlParameter("@ChildrenCount",item.ChildrenCount), new MySqlParameter("@Level",item.Level), new MySqlParameter("@ParentId",item.ParentId) }; if (item.Id == 0) { dbHelper.ExecuteNonQuery(InsSql, parameter); } else { dbHelper.ExecuteNonQuery(UpdSql, parameter); } }