private void ok_Button_Click(object sender, EventArgs e) { ZIKU.DataBase.Category category = ZIKU.DataBase.Category.getInstance(switchPCID); string oSub = ""; //旧的子分类 foreach (string subID in category.C_ID.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category sub = ZIKU.DataBase.Category.getInstance(subID); if (sub != null) { ZIKU.DataBase.Category.writeCategory(sub.id, sub.name, "1", "");//将子分类改成父分类,并记录ID oSub += ";" + sub.id + ";"; } } ZIKU.DataBase.Category P = ZIKU.DataBase.Category.getInstance(selectPCID); SQLite.ExecuteNonQuery("UPDATE Category SET C_ID = '" + P.C_ID + ";" + switchPCID + "' WHERE id = " + selectPCID, ZIKU.DataBase.Config.Instance.Path); SQLite.ExecuteNonQuery("UPDATE Category SET C_ID = '" + selectPCID + "',type = '2' WHERE id = " + switchPCID, ZIKU.DataBase.Config.Instance.Path); string pCsort = ""; foreach (ListViewItem li in oListView1.Items) { pCsort += ";" + li.Tag.ToString(); } ZIKU.DataBase.Config.updatePCsort(pCsort + oSub); this.Close(); }
/// <summary> /// 设置界面的项目信息 /// </summary> /// <param name="itemID">项目的ID</param> private void setInfo(string itemID) { if (itemID != null) { ZIKU.DataBase.Item item = ZIKU.DataBase.Item.getInstance(itemID); if (item != null) { introduceBox.Text = item.intro + "\r\n\r\n" + item.introduce; iCategory.Text = ""; foreach (string cID in item.C_ID.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category category = ZIKU.DataBase.Category.getInstance(cID); if (category != null) { iCategory.Text += category.name + "\r\n"; } } } } else { introduceBox.Text = ""; iCategory.Text = ""; } }
private void pCategoryListView_SelectedIndexChanged(object sender, EventArgs e) { subCategoryListView.SaveSort(); if (pCategoryListView.SelectedItems.Count > 0) { pCid = pCategoryListView.SelectedItems[0].Tag.ToString(); ZIKU.DataBase.Category category = ZIKU.DataBase.Category.getInstance(pCid); if (category.type != "2") { subCategoryListView.Enabled = true; subCategoryListView.clearItemSaveSort(); subCategoryListView.BeginUpdate(); foreach (string subID in category.C_ID.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category subCategory = ZIKU.DataBase.Category.getInstance(subID); if (subCategory != null) { ListViewItem li = new ListViewItem(); li.Tag = subCategory.id; li.Text = subCategory.name; subCategoryListView.Items.Add(li); } } subCategoryListView.EndUpdate(); } } else { pCid = null; subCategoryListView.clearItemSaveSort(); subCategoryListView.Enabled = false; } }
public override void Execute(string id) { SearchFormOle.Instance.nowSeMode = ItemNameMode.Instance; ZIKU.DataBase.Category category = ZIKU.DataBase.Category.getInstance(id); List <string> sql = new List <string>(); foreach (string itemID in category.I_ID.Split(new char[] { Convert.ToChar(";") }, StringSplitOptions.RemoveEmptyEntries)) { sql.Add("SELECT * FROM Item WHERE id = " + itemID); } SearchFormOle.Instance.RestItemBox(SQLite.ExecuteDataTable(sql, ZIKU.DataBase.Config.Instance.Path)); }
/// <summary> /// 刷新父分类列表 /// </summary> private void Refresh_CategoryList() { pCategoryListView.clearItemSaveSort(); subCategoryListView.clearItemSaveSort(); subCategoryListView.Enabled = false; pCid = null; foreach (string Cid in ZIKU.DataBase.Config.Instance.pCsort.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category category = ZIKU.DataBase.Category.getInstance(Cid); if (category != null) { ListViewItem li = new ListViewItem(); li.Tag = category.id; li.Text = category.name; pCategoryListView.Items.Add(li); } } }
public SwitchPtoS(string pID) { InitializeComponent(); switchPCID = pID; foreach (string pc in Tools.SplitString(ZIKU.DataBase.Config.Instance.pCsort)) { if (pc != pID) { ZIKU.DataBase.Category cc = ZIKU.DataBase.Category.getInstance(pc); if (cc != null) { ListViewItem li = new ListViewItem(); li.Tag = pc; li.Text = cc.name; oListView1.Items.Add(li); } } } }
/// <summary> /// 刷新分类树 /// </summary> /// <param name="categoryID">项目的归属项目</param> private void refreshCategoryListBox(string categoryID = "") { categoryBox.Nodes.Clear(); //搜索所有的父分类 foreach (string pID in ZIKU.DataBase.Config.Instance.pCsort.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category c = ZIKU.DataBase.Category.getInstance(pID); if (c != null) { TreeNode node = new TreeNode(); node.ExpandAll(); node.Tag = c.id; node.Text = c.name; categoryBox.Nodes.Add(node); //判定是否勾选该分类 if (OLEREO.Library.Tools.AddValue(categoryID, c.id) == null) { node.Checked = true; } foreach (string subid in c.C_ID.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries)) { ZIKU.DataBase.Category subC = ZIKU.DataBase.Category.getInstance(subid); if (subC != null) { TreeNode node2 = new TreeNode(); node2.Tag = subC.id; node2.Text = subC.name; node.Nodes.Add(node2); if (Tools.AddValue(categoryID, subC.id) == null) { node2.Checked = true; } } } } } }