private void buttonDeleteCategory_Click(object sender, EventArgs e)
{
TreeNode treeNode = this.treeViewAllCategories.SelectedNode;
if (treeNode != null)
{
int categoryId = -1;
if (treeNode.Tag != null)
{
ItemCategoryType categoryType = (ItemCategoryType)treeNode.Tag;
if (categoryType != null)
{
categoryId = categoryType.CategoryId;
}
}
bool result = ItemCategoryDAL.DeleteOneCategory(categoryId);
if (result)
{
// Remove from category tree.
this.treeViewAllCategories.Nodes.Remove(treeNode);
MessageBox.Show("删除类别成功！\r\n注意其子类别已经一并被删除!", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("删除类别失败", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void LoadAllCategories()
{
DataTable dtCategories = ItemCategoryDAL.GetAllCategories();
if (dtCategories.Rows.Count == 0)
{
return;
}
this.treeViewAllCategories.Nodes.Clear();
foreach (DataRow dr in dtCategories.Rows)
{
int catId = StringUtil.GetSafeInt(dr["CategoryId"]);
int parentCatId = StringUtil.GetSafeInt(dr["ParentCategoryId"]);
string catName = StringUtil.GetSafeString(dr["CategoryName"]);
string catSkuPrefix = StringUtil.GetSafeString(dr["CategorySkuPrefix"]);
ItemCategoryType catType = new ItemCategoryType();
catType.CategoryId = catId;
catType.ParentCategoryId = parentCatId;
catType.CategoryName = catName;
catType.CategorySkuPrefix = catSkuPrefix;
TreeNode newNode = new TreeNode();
newNode.Tag = catType;
newNode.Text = catName;
newNode.Name = catId.ToString();
if (parentCatId == -1)
{
this.treeViewAllCategories.Nodes.Add(newNode);
}
else
{
TreeNode[] parentNodes = this.treeViewAllCategories.Nodes.Find(parentCatId.ToString(), true);
if (parentNodes.Length == 1)
{
parentNodes[0].Nodes.Add(newNode);
}
}
int catSkuPrefixVal = -1;
if (Int32.TryParse(catSkuPrefix, out catSkuPrefixVal) && catSkuPrefixVal > maxSkuPrefix)
{
maxSkuPrefix = catSkuPrefixVal;
}
}
this.treeViewAllCategories.ExpandAll();
return;
}
} // class ItemCompactInfo
private void LoadAllCategories()
{
DataTable dtCategories = ItemCategoryDAL.GetAllCategories();
if (dtCategories.Rows.Count == 0)
{
return;
}
this.treeViewItems.Nodes.Clear();
for (int itNum = 0; itNum < 2; ++itNum)
{
foreach (DataRow dr in dtCategories.Rows)
{
int catId = (int)dr["CategoryId"];
int parentCatId = (int)dr["ParentCategoryId"];
string catName = dr["CategoryName"].ToString();
ItemCategoryType catType = new ItemCategoryType();
catType.CategoryId = catId;
catType.ParentCategoryId = parentCatId;
catType.CategoryName = catName;
TreeNode newNode = new TreeNode();
newNode.Tag = catType;
newNode.Text = catName;
newNode.Name = catId.ToString();
if (parentCatId == -1 && itNum == 0)
{
this.treeViewItems.Nodes.Add(newNode);
}
else if (parentCatId != -1 && itNum == 1)
{
TreeNode[] parentNodes = this.treeViewItems.Nodes.Find(parentCatId.ToString(), true);
if (parentNodes.Length == 1)
{
parentNodes[0].Nodes.Add(newNode);
}
}
}
}
this.treeViewItems.ExpandAll();
return;
}
private void buttonAddNewCategory_Click(object sender, EventArgs e)
{
int parentCategoryId = -1;
if (this.textBoxParentCategory.Text == "无" || this.textBoxParentCategory.Text.Trim() == "")
{
parentCategoryId = -1;
}
else
{
TreeNode treeNode = this.treeViewAllCategories.SelectedNode;
if (treeNode != null)
{
if (treeNode.Tag != null)
{
ItemCategoryType parentCatType = (ItemCategoryType)treeNode.Tag;
if (parentCatType != null)
{
parentCategoryId = parentCatType.CategoryId;
}
}
}
}
string categoryName = this.textBoxCategoryName.Text;
if (categoryName == "")
{
MessageBox.Show("请输入类别名称");
return;
}
ItemCategoryType newCategory = new ItemCategoryType();
newCategory.ParentCategoryId = parentCategoryId;
newCategory.CategoryName = categoryName;
newCategory.CategorySkuPrefix = string.Format("{0}", maxSkuPrefix + 1);
ItemCategoryDAL.InsertOneCategory(newCategory);
LoadAllCategories();
MessageBox.Show("添加新类别成功！", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
