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