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);
}
}
}
public static bool InsertOneCategory(ItemCategoryType cat)
{
IDbCommand cmd = DataFactory.CreateCommand(null);
cmd.CommandText = @"Insert into [Category] (ParentCategoryId, CategoryName, CategorySkuPrefix) values (@ParentCategoryId, @CategoryName, @CategorySkuPrefix)";
DataFactory.AddCommandParam(cmd, "@ParentCategoryId", DbType.Int32, cat.ParentCategoryId);
DataFactory.AddCommandParam(cmd, "@CategoryName", DbType.String, StringUtil.GetSafeString(cat.CategoryName));
DataFactory.AddCommandParam(cmd, "@CategorySkuPrefix", DbType.String, StringUtil.GetSafeString(cat.CategorySkuPrefix));
bool result = DataFactory.ExecuteCommandNonQuery(cmd);
return result;
}
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;
}
public static bool InsertOneCategory(ItemCategoryType cat)
{
IDbCommand cmd = DataFactory.CreateCommand(null);
cmd.CommandText = @"Insert into [Category] (ParentCategoryId, CategoryName, CategorySkuPrefix) values (@ParentCategoryId, @CategoryName, @CategorySkuPrefix)";
DataFactory.AddCommandParam(cmd, "@ParentCategoryId", DbType.Int32, cat.ParentCategoryId);
DataFactory.AddCommandParam(cmd, "@CategoryName", DbType.String, StringUtil.GetSafeString(cat.CategoryName));
DataFactory.AddCommandParam(cmd, "@CategorySkuPrefix", DbType.String, StringUtil.GetSafeString(cat.CategorySkuPrefix));
bool result = DataFactory.ExecuteCommandNonQuery(cmd);
return(result);
}
} // 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 treeViewCategories_DragDrop(object sender, DragEventArgs e)
{
TreeNode oldNode;
if (e.Data.GetDataPresent("System.Windows.Forms.TreeNode", false))
{
Point pt = ((TreeView)sender).PointToClient(new Point(e.X, e.Y));
TreeNode targetNode = ((TreeView)sender).GetNodeAt(pt);
object tag = targetNode.Tag;
if (tag == null || tag.GetType() != typeof(ItemCategoryType))
{
return;
}
ItemCategoryType catInfo = (ItemCategoryType)tag;
oldNode = (TreeNode)e.Data.GetData("System.Windows.Forms.TreeNode");
if (oldNode.Tag == null || oldNode.Tag.GetType() != typeof(ItemCompactInfo))
{
return;
}
ItemCompactInfo itemInfo = (ItemCompactInfo)oldNode.Tag;
if (itemInfo == null)
{
return;
}
InventoryItemType item = ItemDAL.GetItemById(itemInfo.ItemId);
if (item == null)
{
return;
}
if (item.CategoryId == catInfo.CategoryId)
{
return;
}
ItemDAL.ModifyItemCategory(item.ItemId, catInfo.CategoryId);
targetNode.Nodes.Add((TreeNode)oldNode.Clone());
targetNode.Expand();
//Remove Original Node
oldNode.Remove();
}
}
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);
}
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 treeViewAllCategories_AfterSelect(object sender, TreeViewEventArgs e)
{
TreeNode node = this.treeViewAllCategories.SelectedNode;
if (node == null)
{
this.textBoxParentCategory.Text = "无";
return;
}
ItemCategoryType selectedCatType = (ItemCategoryType)node.Tag;
if (selectedCatType == null)
{
this.textBoxParentCategory.Text = "无";
return;
}
this.textBoxParentCategory.Text = selectedCatType.CategoryName;
}
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);
}
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;
}
private InventoryItemType GetItemInfoFromUI(bool isInsert)
{
InventoryItemType item = new InventoryItemType();
TreeNode node = this.treeViewCategories.SelectedNode;
if (node == null)
{
MessageBox.Show("请选择商品类别");
return(null);
}
if (isInsert)
{
if (node.Tag.GetType() != typeof(ItemCategoryType))
{
MessageBox.Show("请选择商品类别");
return(null);
}
ItemCategoryType category = (ItemCategoryType)node.Tag;
if (category == null)
{
MessageBox.Show("请选择商品类别");
return(null);
}
item.CategoryId = category.CategoryId;
if (item.CategoryId <= 0)
{
MessageBox.Show("请选择商品类别");
return(null);
}
}
else
{
// modify
if (node.Tag.GetType() != typeof(ItemCompactInfo))
{
MessageBox.Show("请选择商品");
return(null);
}
}
item.ItemName = this.textBoxItemName.Text;
if (item.ItemName == "")
{
MessageBox.Show("请输入商品名");
return(null);
}
item.ItemSKU = this.textBoxItemSKU.Text;
if (item.ItemSKU == "")
{
MessageBox.Show("请输入商品SKU");
return(null);
}
if (this.textBoxItemImagePath.Text.Trim() == "")
{
if (isInsert)
{
MessageBox.Show("请选择商品图片");
return(null);
}
}
else
{
string imagePath = this.textBoxItemImagePath.Text.Trim();
if (File.Exists(imagePath) == false)
{
MessageBox.Show("商品图片路径错误.");
return(null);
}
//FileStream fs = new FileStream(imagePath, FileMode.Open, FileAccess.Read);
//byte[] buffer = new byte[fs.Length];
//fs.Read(buffer, 0, buffer.Length);
//fs.Close();
//item.ItemImage = buffer;
item.ItemImagePath = imagePath;
}
if (this.textBoxItemStockShreshold.Text == "")
{
MessageBox.Show("商品库存警戒值错误");
return(null);
}
item.ItemStockShresholdNum = Int32.Parse(this.textBoxItemStockShreshold.Text.Trim());
string itemStockStr = this.textBoxItemStock.Text;
if (itemStockStr.Trim() == "")
{
MessageBox.Show("商品库存值错误");
return(null);
}
item.ItemStockNum = StringUtil.GetSafeInt(itemStockStr);
//item.ItemSourcingInfo = this.textBoxItemSourcingInfo.Text;
//item.ItemSourcingURL = this.textBoxSourcingURL.Text;
//string itemCostStr = this.textBoxItemCost.Text.Trim();
//if (itemCostStr == "")
//{
// MessageBox.Show("商品成本值错误");
// return null;
//}
//item.ItemCost = StringUtil.GetSafeDouble(itemCostStr);
string itemWeightStr = this.textBoxItemWeight.Text.Trim();
if (itemWeightStr == "")
{
MessageBox.Show("商品重量值错误");
return(null);
}
item.ItemWeight = StringUtil.GetSafeDouble(itemWeightStr);
item.ItemCustomName = this.textBoxCustomName.Text.Trim();
string itemCustomWeightStr = this.textBoxItemCustomWeight.Text.Trim();
if (itemCustomWeightStr == "")
{
item.ItemCustomWeight = 0.0;
}
else
{
item.ItemCustomWeight = StringUtil.GetSafeDouble(itemCustomWeightStr);
}
string itemCustomCostStr = this.textBoxItemCustomValue.Text.Trim();
if (itemCustomCostStr == "")
{
item.ItemCustomCost = 0.0;
}
else
{
item.ItemCustomCost = StringUtil.GetSafeDouble(itemCustomCostStr);
}
item.ItemAddDateTime = DateTime.Now;
// IsGroupItem
item.IsGroupItem = false;
item.SubItemSKUs = "";
return(item);
}
