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