//双击左侧菜单添加消费项目 private void dgvProduct_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { R_OrderInfo_Product rop = new R_OrderInfo_Product(); //获取当前选中的菜的id string strId = dgvProduct.SelectedRows[0].Cells[0].Value.ToString(); rop.ProId = Convert.ToInt32(strId); //获取点菜的数量 rop.UnitCount = string.IsNullOrEmpty(txtCount.Text) || txtCount.Text == "1" ? 1 : Convert.ToInt32(txtCount.Text);//判断是否能转换成功===我省略了. //订单的id rop.OrderId = this.ordId; //把这些数据全部插入到订单和菜单的中间表去. //其他的数据 rop.DelFlag = 0; rop.State = 0; rop.SubTime = DateTime.Now; R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); //如果菜添加成功了,就要在窗体的右侧显示点的什么菜 if (bll.AddOrderProduct(rop)) { //刷新右侧的菜单 //添加菜成功后要刷新--窗体加载的时候要刷新. 主界面还要查询 LoadOrderProduct(); txtCount.Text = ""; } else { MessageBox.Show("对不起点菜失败"); } }
//点菜 private void dgvProduct_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dgvProduct.SelectedRows.Count > 0) { //首先获取该餐桌的订单id //int id = this.ID; //获取点菜的菜的id int proId = Convert.ToInt32(dgvProduct.SelectedRows[0].Cells[0].Value); //插入到订单和菜单的中间表 //数量 int count = string.IsNullOrEmpty(txtCount.Text) || txtCount.Text == "1" ? 1 : Convert.ToInt32(txtCount.Text); R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); R_OrderInfo_Product roip = new R_OrderInfo_Product(); roip.OrderId = this.ID; roip.DelFlag = 0; roip.ProId = proId; roip.State = 0; roip.SubTime = System.DateTime.Now; roip.UnitCount = count; // bll.AddR_OrderInfo_Product(roip); if (bll.AddR_OrderInfo_Product(roip)) { LoadROrderProduct(); txtCount.Text = ""; } else { MessageBox.Show("点菜失败"); } } }
private void LoadROrderProduct() { R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); //计算总金额还有总数量 R_OrderInfo_Product r = bll.GetMoneyAndCount(this.ID); label1.Text = "亲,您共消费了" + r.MONEY.ToString() + "元";//总金额 }
private void LoadAllOrderProducts(int orderId) { var bll = new R_OrderInfo_ProductBLL(); dgvAllPro.AutoGenerateColumns = false; dgvAllPro.DataSource = bll.GetR_OrderInfo_ProductByOrderId(orderId); dgvAllPro.SelectedRows[0].Selected = false; }
//加载点的菜 private void LoadROrderProduct() { R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); dgvROrderProduct.AutoGenerateColumns = false; dgvROrderProduct.DataSource = bll.GetROrderInfoProduct(this.ID); //dgvROrderProduct.SelectedRows[0].Selected = false; //计算总金额还有总数量 R_OrderInfo_Product r = bll.GetMoneyAndCount(this.ID); labSumMoney.Text = r.MONEY.ToString(); //总金额 labCount.Text = r.CT.ToString(); //总数量 }
//显示用户点的什么菜 private void LoadOrderProduct() { R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); dgvROrderProduct.AutoGenerateColumns = false; //禁止自动生成列 dgvROrderProduct.DataSource = bll.GetProduct(this.ordId); dgvROrderProduct.SelectedRows[0].Selected = false; //默认不选中 //不为空 R_OrderInfo_Product rop = bll.GetCountAndMoney(this.ordId); labSumMoney.Text = rop.MONEY.ToString(); //总金额 labCount.Text = rop.CT.ToString(); //点了多少个菜 }
private void btnDeleteRorderPro_Click(object sender, EventArgs e) { if (dgvROrderProduct.SelectedRows.Count > 0) { var id = Convert.ToInt32(dgvROrderProduct.SelectedRows[0].Cells[0].Value); var bll = new R_OrderInfo_ProductBLL(); var msg = bll.DeleteROrderProductById(id) ? "退菜成功" : "退菜失败"; MessageBox.Show(msg); LoadROrderInfoProductByOrderId(Convert.ToInt32(labOrderId.Text)); } else { MessageBox.Show("请选择要退的菜"); } }
private void LoadROrderInfoProductByOrderId(int id) { dgvROrderProduct.AutoGenerateColumns = false; var bll = new R_OrderInfo_ProductBLL(); dgvROrderProduct.DataSource = bll.GetR_OrderInfo_ProductByOrderId(id); if (dgvROrderProduct.SelectedRows.Count > 0) { dgvROrderProduct.SelectedRows[0].Selected = false; } //这里不用判断是否点了菜 var rop = bll.GetAllMoneyAndCount(id); labSumMoney.Text = rop.MONEY.ToString(); labCount.Text = rop.CT.ToString(); }
//退菜 private void btnDeleteRorderPro_Click(object sender, EventArgs e) { //获取当前选中的id if (dgvROrderProduct.SelectedRows.Count > 0) { //获取当前选中的id int id = Convert.ToInt32(dgvROrderProduct.SelectedRows[0].Cells[0].Value); R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); if (bll.UpdateROrderProduct(id)) { MessageBox.Show("退菜成功"); LoadROrderProduct();//刷新 } else { MessageBox.Show("退菜失败"); } } }
//退菜 private void btnDeleteRorderPro_Click(object sender, EventArgs e) { //获取当前选中的id int id = Convert.ToInt32(dgvROrderProduct.SelectedRows[0].Cells[0].Value); R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); if (bll.UpdateROrderProduct(id)) { MessageBox.Show("退菜成功"); LoadROrderProduct();//刷新 R_OrderInfo_Product r = bll.GetMoneyAndCount(this.ID); labSumMoney.Text = r.MONEY.ToString(); //总金额 labCount.Text = r.CT.ToString(); //总数量 } else { MessageBox.Show("退菜失败"); } }
//退菜 private void btnDeleteRorderPro_Click(object sender, EventArgs e) { //获取选中菜的id if (dgvROrderProduct.SelectedRows.Count > 0) { if (DialogResult.OK == MessageBox.Show("是否删除", "删除", MessageBoxButtons.OKCancel)) { //获取当前选中要退菜的id int id = Convert.ToInt32(dgvROrderProduct.SelectedRows[0].Cells[0].Value); R_OrderInfo_ProductBLL bll = new R_OrderInfo_ProductBLL(); string msg = bll.DeleteROrderInfoProduct(id)?"退菜成功":"退菜失败"; //删除选中的菜 MessageBox.Show(msg); LoadOrderProduct(); //刷新 } } else { MessageBox.Show("请选中要删除的行"); } }
private void dgvProduct_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dgvProduct.SelectedRows.Count > 0) { //OrderId,ProId,DelFlag,SubTime,State,UnitCount var rop = new R_OrderInfo_Product(); rop.OrderId = Convert.ToInt32(labOrderId.Text); rop.ProId = Convert.ToInt32(dgvProduct.SelectedRows[0].Cells[0].Value); rop.DelFlag = 0; rop.SubTime = DateTime.Now; rop.State = 0; if (txtCount.Text != "") { try { rop.UnitCount = Convert.ToInt32(txtCount.Text) > 1 ? Convert.ToInt32(txtCount.Text) : 1; } catch { MessageBox.Show("消费数量输入错误"); return; } } else { rop.UnitCount = 1; } var bll = new R_OrderInfo_ProductBLL(); bll.AddROrderInfoProduct(rop); LoadROrderInfoProductByOrderId(Convert.ToInt32(rop.OrderId)); } else { MessageBox.Show("未选中行"); } }