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