public void update_tree()//Обновление дерева объектов { TreeNode node = new TreeNode(); TreeNode sub_node = new TreeNode(); TreeNode typeNode = new TreeNode("Tovary"); treeView1.Nodes.Clear(); foreach (string type in lists.GetTypes()) { CCategorizedList cat_list = lists.GetCatList(type); List <string> subtypes = cat_list.GetTypes(); foreach (string subtype in subtypes) { TreeNode subtypeNode = new TreeNode(subtype); List <CItem> items = cat_list.GetByType(subtype); foreach (CItem item in items) { TreeNode itemNode = new TreeNode(item.ToString()); itemNode.Text = item.Get()["name"]; subtypeNode.Nodes.Add(itemNode); } typeNode.Nodes.Add(subtypeNode); } } treeView1.Nodes.Add(typeNode); }
private void button2_Click(object sender, EventArgs e) //Изменение товара { Dictionary <string, string> param = new Dictionary <string, string>(); //Спсок полей редактируемого обьекта TreeNode s_node = treeView1.SelectedNode; if (s_node != null) { param["name"] = s_node.Text.ToString(); foreach (string type in lists.GetTypes()) { CCategorizedList cat_list = lists.GetCatList(type); List <string> subtypes = cat_list.GetTypes(); foreach (string subtype in subtypes) { TreeNode subtypeNode = new TreeNode(subtype); List <CItem> items = cat_list.GetByType(subtype); foreach (CItem item in items) { var t = item.Get(); if (t.ContainsValue(param["name"])) { lists.Remove(item); new_frm.main_frm = this; new_frm.edit_item(t); } } } } update_tree(); update_data(); } }
private void saveToolStripMenuItem_Click(object sender, EventArgs e)//Сохранение списка объектв { Dictionary <string, string> param = new Dictionary <string, string>(); SaveFileDialog save = new SaveFileDialog(); save.InitialDirectory = "c:\\"; save.ShowDialog(); string file_name = save.FileName; try { SQLiteConnection m_dbConnection; m_dbConnection = new SQLiteConnection("Data Source=" + file_name + ";Version=3;"); m_dbConnection.Open(); foreach (string type in lists.GetTypes()) { CCategorizedList cat_list = lists.GetCatList(type); List <string> subtypes = cat_list.GetTypes(); foreach (string subtype in subtypes) { TreeNode subtypeNode = new TreeNode(subtype); List <CItem> items = cat_list.GetByType(subtype); foreach (CItem item in items) { if (item.Get()["parent_type"].CompareTo("Writings") == 0) { string sql = "UPDATE Table1 SET parent_type = " + item.Get()["parent_type"] + "name = " + item.Get()["name"] + "price = " + item.Get()["price"] + "type = " + item.Get()["type"] + "type = " + item.Get()["color"] + "WHERE strih_kod = " + item.Get()["strih_code"]; } else { string sql = "UPDATE Table1 SET paret = " + item.Get()["parent_type"] + "name = " + item.Get()["name"] + "price = " + item.Get()["price"] + "type = " + item.Get()["type"] + "page_count = " + item.Get()["page_count"] + "WHERE strih_kod = " + item.Get()["strih_code"]; } } } } m_dbConnection.Close(); } catch { MessageBox.Show("Uncorrect data", "ERROR!!!", MessageBoxButtons.OK); } }