//加载所有会员 private void LoadMemmberInfoByDelFlag(int p) { MemmberInfoBLL bll = new MemmberInfoBLL(); dgvMemmber.AutoGenerateColumns = false; dgvMemmber.DataSource = bll.GetAllMemmberInfoByDelFlag(p); dgvMemmber.SelectedRows[0].Selected = false; }
//加载会员级别 public void LoadMember(int p) { MemmberInfoBLL bll = new MemmberInfoBLL(); List <MemmberInfo> list = bll.GetAllMemmberInfoByDelFlag(p); list.Insert(0, new MemmberInfo { MemmberId = -1, MemName = "请选择" }); cmbMemmber.DataSource = list; cmbMemmber.DisplayMember = "MemName"; cmbMemmber.ValueMember = "MemmberId"; }
//确定按钮,新增和修改 private void btnOk_Click(object sender, EventArgs e) { MemmberInfo mem = new MemmberInfo(); if (IsCheck()) { mem.MemAddress = txtAddress.Text; mem.MemBirthdaty = Convert.ToDateTime(txtBirs.Text); mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text); mem.MemEndServerTime = dtEndServerTime.Value; mem.MemGender = CheckGender(); mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text); mem.MemMobilePhone = txtMemPhone.Text; mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text); mem.MemName = txtMemName.Text; mem.MemNum = txtMemNum.Text; mem.MemType = Convert.ToInt32(cmbMemType.SelectedIndex); } MemmberInfoBLL bll = new MemmberInfoBLL(); //新增还是修改 if (this.Tp == 1)//新增 { mem.DelFlag = 0; mem.SubTime = System.DateTime.Now; //if (bll.SaveMemmber(mem,this.Tp)) //{ // MessageBox.Show("新增成功"); // this.Close(); //} //else //{ // MessageBox.Show("新增失败"); //} } else if (this.Tp == 2) //修改 { mem.MemmberId = Convert.ToInt32(labId.Text); //if (bll.SaveMemmber(mem, this.Tp)) //{ // MessageBox.Show("修改成功"); // this.Close(); //} //else //{ // MessageBox.Show("修改失败"); //} } string st = bll.SaveMemmber(mem, this.Tp) ? "操作成功" : "操作失败"; MessageBox.Show(st); this.Close(); }
//修改 private void btnUpdateMember_Click(object sender, EventArgs e) { if (dgvMemmber.SelectedRows.Count > 0) { int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value); MemmberInfoBLL bll = new MemmberInfoBLL(); MemmberInfo mem = bll.GetMemmberByMemmberid(id); mem.MemmberId = id; fea.Obj = mem; ShowChangeMemmber(2);//2表示修改 //根据选中行的id去数据库查询是否有这条数据,并以对象的方式返回来 //传对象 } }
private void btnAccounts_Click(object sender, EventArgs e) { OrderInfo order = new OrderInfo(); order.OrderId = Convert.ToInt32(labOrderId.Text); //订单的id order.EndTime = DateTime.Now; //订单中的结束时间 //如果选择会员 if (cmbMemmber.SelectedIndex == 0) { //不是会员 // order.DisCount = 10; } else { //是会员 //会员的余额更新 //如果是会员,那么要获取该会员的余额-当前消费的金额,更新到会员的表中 decimal memYuMoney = Convert.ToDecimal(labyeMoney.Text) - Convert.ToDecimal(lblMoney.Text); int memId = Convert.ToInt32(cmbMemmber.SelectedValue); MemmberInfoBLL bll = new MemmberInfoBLL(); bool memresult = bll.UpdateMoney(memId, memYuMoney); //更新会员的余额 order.OrderMemId = memId; //订单中的会员id order.DisCount = Convert.ToDecimal(lblDis.Text); //这个是订单中的会员折扣 } //更新餐桌的状态=0 //获取餐桌的id,更改餐桌的状态 DeskInfoBLL dkBll = new DeskInfoBLL(); bool result = dkBll.UpdateDeskStateByDeskId(this.Id, 0); //订单的状态=2 //获取订单的id更改订单的状态.更新这个订单最后花费多少钱,结束时间 order.OrderMoney = Convert.ToDecimal(lblMoney.Text);//这个订单花了多少钱 //窗体关闭 OrderInfoBLL obll = new OrderInfoBLL(); bool oresult = obll.UpdateOrderInfoMoney(order); if (result && oresult) { MessageBox.Show("结账成功"); this.Close(); } else { MessageBox.Show("结账失败"); } }
//修改会员 2表示是修改 private void btnUpdateMember_Click(object sender, EventArgs e) { //FrmChangeMemmber fcm = new FrmChangeMemmber(); //fcm.ShowDialog(); if (dgvMemmber.SelectedRows.Count > 0) { int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value); //根据id去数据库查询这条数据是否存在 MemmberInfoBLL bll = new MemmberInfoBLL(); MemmberInfo mem = bll.GetMemmberInfoByMemmberId(id); fea.obj = mem; ShowFrmChangeMemmber(2); } else { MessageBox.Show("请选择要修改的数据"); } }
//删除会员 private void btnDelete_Click(object sender, EventArgs e) { if (dgvMemmber.SelectedRows.Count > 0) { if (DialogResult.OK == MessageBox.Show("是否删除", "删除", MessageBoxButtons.OKCancel)) { string strId = dgvMemmber.SelectedRows[0].Cells[0].Value.ToString(); int memId = Convert.ToInt32(strId); MemmberInfoBLL bll = new MemmberInfoBLL(); string msg = bll.DeleteMemmber(memId) ? "操作成功" : "操作失败"; MessageBox.Show(msg); LoadMemmberInfoByDelFlag(0); } } else { MessageBox.Show("请选中删除的会员"); } }
private void btnOk_Click(object sender, EventArgs e) { //获取会员信息 //不为空 MemmberInfo mem = new MemmberInfo(); if (IsCheck()) { mem.MemAddress = txtAddress.Text; mem.MemBirthdaty = Convert.ToDateTime(txtBirs.Text); //生日最好用控件 mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text); //折扣 mem.MemEndServerTime = dtEndServerTime.Value; mem.MemGender = IsGender(); mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text); mem.MemMobilePhone = txtMemPhone.Text; mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text); mem.MemName = txtMemName.Text; mem.MemNum = txtMemNum.Text; mem.MemType = Convert.ToInt32(cmbMemType.SelectedValue); } else { //MessageBox.Show("不能为空"); return; //没的话,直接确定会生成空值,报错 } MemmberInfoBLL bll = new MemmberInfoBLL(); //新增还是修改 if (this.Tp == 1) { mem.DelFlag = 0; mem.SubTime = System.DateTime.Now; } else if (this.Tp == 2) { mem.MemmberId = Convert.ToInt32(labId.Text); } string st = bll.SaveMemmber(mem, this.Tp) ? "操作成功" : "操作失败"; MessageBox.Show(st); this.Close(); }
//会员是否选中计算花费多少钱 private void cmbMemmber_SelectedIndexChanged(object sender, EventArgs e) { if (cmbMemmber.SelectedIndex != 0) { int memId = Convert.ToInt32(cmbMemmber.SelectedValue); MemmberInfoBLL bll = new MemmberInfoBLL(); MemmberInfo mem = bll.GetMemMoneyAndDisCountAndTypeNameByMemId(memId); labyeMoney.Text = mem.MemMoney.ToString(); //会员的余额 lblDis.Text = mem.MemDiscount.ToString(); //折扣 labTp.Text = mem.MemTpName; lblMoney.Text = (Convert.ToDecimal(labMoney.Text) * mem.MemDiscount / 10).ToString(); } else { labyeMoney.Text = ""; lblDis.Text = ""; labTp.Text = ""; lblMoney.Text = labMoney.Text; } }
//删除 private void btnDelete_Click(object sender, EventArgs e) { //判断是否有选中的行 if (dgvMemmber.SelectedRows.Count > 0) { int id = Convert.ToInt32(dgvMemmber.SelectedRows[0].Cells[0].Value); MemmberInfoBLL bll = new MemmberInfoBLL(); if (bll.DeleteMemmberByMemmberId(id)) { MessageBox.Show("操作成功"); LoadMemmberInfoByDelFlag(0); } else { MessageBox.Show("操作失败"); } } else { MessageBox.Show("请选中要删除的行"); } }
//增加或者是修改 private void btnOk_Click(object sender, EventArgs e) { //判断文本框不能为空 if (IsCheck()) { //判断是新增还是修改 MemmberInfo mem = new MemmberInfo(); //地址没写 mem.MemBirthdaty = Convert.ToDateTime(txtBirs.Text); //生日最好用控件 mem.MemDiscount = Convert.ToDecimal(txtMemDiscount.Text); //折扣 mem.MemEndServerTime = dtEndServerTime.Value; mem.MemGender = IsGender(); mem.MemIntegral = Convert.ToInt32(txtMemIntegral.Text); mem.MemMobilePhone = txtMemPhone.Text; mem.MemMoney = Convert.ToDecimal(txtmemMoney.Text); mem.MemName = txtMemName.Text; mem.MemNum = txtMemNum.Text; mem.MemType = Convert.ToInt32(cmbMemType.SelectedValue); if (this.Tp == 1)//新增 { mem.DelFlag = 0; mem.SubTime = DateTime.Now; } else if (this.Tp == 2)//修改id { mem.MemmberId = Convert.ToInt32(labId.Text); } //调用方法 是新增还是修改 MemmberInfoBLL bll = new MemmberInfoBLL(); string msg = bll.SaveMemmberInfo(mem, this.Tp)?"操作成功":"操作失败"; MessageBox.Show(msg); this.Close(); } }