private void textBox1_TextChanged(object sender, EventArgs e) { string name = textBox1.Text; ProductsModel pm = new ProductsModel(); pm.ProductJP1 = name; for (int i = 0; i < tv.Nodes.Count; i++) { if (tv.Nodes[i].Name.Contains(name)) { tv.Nodes[i].ImageIndex = 1; } } if (tabControl1.TabPages[0].Text == "项目清单") { DataTable dt = ConsumerBillBLL.getTableSS(pm); dataGridView1.DataSource = dt; } if (tabControl1.TabPages[1].Text == "项目列表") { tv.Nodes.Clear(); //列表 DataTable dt2 = ConsumerBillBLL.getTableLB(); for (int i = 0; i < dt2.Rows.Count; i++) { TreeNode root = new TreeNode(dt2.Rows[i]["PTName"].ToString()); root.Name = dt2.Rows[i]["PTName"].ToString(); root.ImageIndex = 1; tv.Nodes.Add(root); ProductTypeModel ptype = new ProductTypeModel(); ptype.PTName1 = dt2.Rows[i]["PTName"].ToString(); DataTable dt3 = ConsumerBillBLL.getTableSSLB(ptype, pm); for (int j = 0; j < dt3.Rows.Count; j++) { TreeNode node = new TreeNode(dt3.Rows[j]["项目名称"].ToString()); node.Name = dt3.Rows[j]["项目名称"].ToString(); root.Nodes.Add(node); } } //tabPage2.Controls.Add(tv2); } }
private void AddForm_Load(object sender, EventArgs e) { //标题 this.Text = "增加消费"; //桌号 lblNo.Text = tables.TableName1; //背景 dataGridView1.BackgroundColor = Color.White; //禁止添加 dataGridView1.AllowUserToAddRows = false; //禁止调整列 dataGridView1.AllowUserToResizeColumns = false; //禁止调整行 dataGridView1.AllowUserToResizeRows = false; //取消头列 dataGridView1.RowHeadersVisible = false; //禁止多选 dataGridView1.MultiSelect = false; //加载数据 DataTable dt = ConsumerBillBLL.getTableZD(); dataGridView1.DataSource = dt; dataGridView1.Columns[0].Visible = false; //禁止编辑 dataGridView1.ReadOnly = true; //选中突出 listView1.FullRowSelect = true; tv = new TreeView(); tv.Dock = DockStyle.Fill; tv.ImageList = imageList1; //列表 DataTable dt2 = ConsumerBillBLL.getTableLB(); for (int i = 0; i < dt2.Rows.Count; i++) { TreeNode root = new TreeNode(dt2.Rows[i]["PTName"].ToString()); root.Name = dt2.Rows[i]["PTName"].ToString(); root.ImageIndex = 0; tv.Nodes.Add(root); ProductTypeModel ptype = new ProductTypeModel(); ptype.PTName1 = dt2.Rows[i]["PTName"].ToString(); DataTable dt3 = ConsumerBillBLL.getTableLB(ptype); for (int j = 0; j < dt3.Rows.Count; j++) { TreeNode node = new TreeNode(dt3.Rows[j]["项目名称"].ToString()); node.Name = dt3.Rows[j]["项目名称"].ToString(); node.ImageIndex = 1; root.Nodes.Add(node); } } tabPage2.Controls.Add(tv); //数量 txtCount.Text = "1"; //加载消费列表 DataTable dt4 = ConsumerDetailsBLL.getTableXF(tables.TableID1); for (int i = 0; i < dt4.Rows.Count; i++) { ListViewItem lvi = new ListViewItem(dt4.Rows[i]["商品编号"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["单价"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["数量"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["金额"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["点单时间"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["项目类别"].ToString()); lvi.SubItems.Add(dt4.Rows[i]["CDID"].ToString()); listView1.Items.Add(lvi); } //金额和数量 getMoneyANDCount(); //最后隐藏 listView1.Columns[6].Width = 0; }