private void panel3_VisibleChanged(object sender, EventArgs e) { List <ProductTypeMDL> list = ProductTypeBLL.selectProductType(); dataGridView1.DataSource = list; List <ProductsMDL> list_cm = ProductsBLL.selectProducts(0, ""); dataGridView2.AutoGenerateColumns = false; dataGridView2.DataSource = list_cm; dataGridView2.Columns[3].Visible = false; dataGridView2.Columns[4].Visible = false; dataGridView2.Columns[5].Visible = false; dataGridView2.Columns[6].Visible = false; dataGridView2.Columns[7].Visible = false; List <ProductTypeMDL> list1 = ProductTypeBLL.selectProductType(); list1.Insert(0, (new ProductTypeMDL { PTID = 0, PTName = "全部" })); comboBox2.DisplayMember = "PTName"; comboBox2.ValueMember = "PTID"; comboBox2.DataSource = list1; }
private void 定套餐_Load(object sender, EventArgs e) { //查询所有商品 List <ProductsMDL> list_cm = ProductsBLL.selectProduct(""); dataGridView2.AutoGenerateColumns = false; dataGridView2.DataSource = list_cm; dataGridView2.Columns[2].Visible = false; dataGridView2.Columns[3].Visible = false; dataGridView2.Columns[4].Visible = false; List <ProductTypeMDL> list_PR = ProductTypeBLL.selectProductType(); foreach (var item in list_PR) { TreeNode tr = new TreeNode(); tr.Text = item.PTName; tr.Tag = item.PTID; List <ProductsMDL> list_P = ProductsBLL.selectProducts(item.PTID, ""); foreach (ProductsMDL item_P in list_P) { TreeNode tr_P = new TreeNode(); tr_P.Text = item_P.ProductName; tr_P.Tag = item_P.ProductID; tr_P.Name = item_P.ProductPrice.ToString(); tr.Nodes.Add(tr_P); } treeView1.Nodes.Add(tr); } }
private void FrmAddConsumer_Load(object sender, EventArgs e) { lbl_CBID.Text = TablesBLL.GetCBID(TableID); lbl_TBID.Text = TableName; //查询所有商品 List <ProductsMDL> list_cm = ProductsBLL.selectProduct(""); dataGridView2.AutoGenerateColumns = false; dataGridView2.DataSource = list_cm; dataGridView2.Columns[2].Visible = false; dataGridView2.Columns[3].Visible = false; dataGridView2.Columns[4].Visible = false; //查询菜单 List <ConsumerDetails> list = ConsumerDetailsBLL.GetCD(TableID); foreach (ConsumerDetails item in list) { ListViewItem lvi = new ListViewItem(item.ProductName); lvi.SubItems.Add(item.ProductPrice.ToString()); lvi.SubItems.Add(item.CDAmount.ToString()); lvi.SubItems.Add(item.CBJE.ToString()); lvi.SubItems.Add(item.CBDate); lvi.Tag = item.ProductID; listView1.Items.Add(lvi); } foreach (ConsumerDetails item in list) { price += item.CBJE; } label10.Text = price.ToString(); //加载treeview数据 List <ProductTypeMDL> list_PR = ProductTypeBLL.selectProductType(); foreach (var item in list_PR) { TreeNode tr = new TreeNode(); tr.Text = item.PTName; tr.Tag = item.PTID; List <ProductsMDL> list_P = ProductsBLL.selectProducts(item.PTID, ""); foreach (ProductsMDL item_P in list_P) { TreeNode tr_P = new TreeNode(); tr_P.Text = item_P.ProductName; tr_P.Tag = item_P.ProductID; tr_P.Name = item_P.ProductPrice.ToString(); tr.Nodes.Add(tr_P); } treeView1.Nodes.Add(tr); } label9.Text = listView1.Items.Count.ToString(); label11.Text = dataGridView2.SelectedRows[0].Cells[0].Value.ToString(); }
private void button11_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count <= 0) { new Warning("请选择一行数据进行删除", 图标.Erro).Show(); return; } //删除 DialogResult d = MessageBox.Show("是否确认删除", "温馨提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d == DialogResult.Yes) { List <ProductsMDL> listP = ProductsBLL.selectProducts(Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value), ""); if (listP.Count > 0) { new Warning("请先移除此类型下的商品", 图标.Erro).Show(); return; } ProductTypeMDL p = new ProductTypeMDL(); p.PTID = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value); if (ProductTypeBLL.DeleteProductType(p) > 0) { new Warning("删除成功", 图标.Yes).Show(); List <ProductTypeMDL> list = ProductTypeBLL.selectProductType(); dataGridView1.DataSource = list; List <ProductTypeMDL> list1 = ProductTypeBLL.selectProductType(); list1.Insert(0, (new ProductTypeMDL { PTID = 0, PTName = "全部" })); comboBox2.DisplayMember = "PTName"; comboBox2.ValueMember = "PTID"; comboBox2.DataSource = list1; } else { MessageBox.Show("删除失败"); } } }
private void button13_Click(object sender, EventArgs e) { //1,修改 2,删除 Product.type = 1; new FrmEditPT().ShowDialog(); List <ProductTypeMDL> list = ProductTypeBLL.selectProductType(); dataGridView1.DataSource = list; List <ProductTypeMDL> list1 = ProductTypeBLL.selectProductType(); list1.Insert(0, (new ProductTypeMDL { PTID = 0, PTName = "全部" })); comboBox2.DisplayMember = "PTName"; comboBox2.ValueMember = "PTID"; comboBox2.DataSource = list1; }
private void button12_Click(object sender, EventArgs e) { Product.type = 2; Product.ID = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); Product.name = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); new FrmEditPT().ShowDialog(); List <ProductTypeMDL> list = ProductTypeBLL.selectProductType(); dataGridView1.DataSource = list; List <ProductTypeMDL> list1 = ProductTypeBLL.selectProductType(); list1.Insert(0, (new ProductTypeMDL { PTID = 0, PTName = "全部" })); comboBox2.DisplayMember = "PTName"; comboBox2.ValueMember = "PTID"; comboBox2.DataSource = list1; }
private void FrmEditProduct_Load(object sender, EventArgs e) { //高级绑定 List <ProductTypeMDL> list1 = ProductTypeBLL.selectProductType(); comboBox1.DisplayMember = "PTName"; comboBox1.ValueMember = "PTID"; comboBox1.DataSource = list1; OpenType = EditProduct.OpenType; if (OpenType == 1) { this.Text = "增加商品"; label7.Text = "增加商品"; } else { this.Text = "修改商品信息"; label7.Text = "修改商品信息"; comboBox1.SelectedValue = EditProduct.ShopType; textBox1.Text = EditProduct.ShopName; textBox2.Text = EditProduct.ShopJP; textBox3.Text = EditProduct.ShopPrice.ToString(); textBox4.Text = EditProduct.ProductJs; if (EditProduct.ShopPIC == "") { pictureBox1.Image = Image.FromFile(path); return; } path = EditProduct.ShopPIC; try { pictureBox1.Image = Image.FromFile(path); } catch (Exception) { pictureBox1.Image = Image.FromFile("add.jpg"); } } }