//确定 private void btnOk_Click(object sender, EventArgs e) { //判断所有的数据不能为空 if (CheckEmpty()) { MemberInfo member = new MemberInfo(); member.MemAddress = txtAddress.Text; member.MemBirthday = txtBirstday.Value; //生日 member.MemDiscount = Convert.ToDouble(txtDiscount.Text); //折扣 member.MemEndTime = txtEndTime.Value; //结束时间 //性别:member.MemGender==坑 member.MemGender = CheckGender(); //性别 member.MemIntegral = Convert.ToInt32(txtIntegral.Text); //积分 member.MemMobilePhone = txtPhone.Text; //电话 member.MemMoney = Convert.ToDouble(txtMoney.Text); //金额 member.MemName = txtName.Text; //会员的名字 member.MemNum = txtNum.Text; //编号 member.MemType = Convert.ToInt32(cmbType.SelectedValue); //会员的类型 member.SubTime = System.DateTime.Now; if (Temp == 1) //新增 { member.DelFlag = 0; } else if (Temp == 2) //修改 { member.MemberId = Convert.ToInt32(labId.Text); //会员的id } MemberInfoBl memBll = new MemberInfoBl(); string msg = memBll.AddOrUpdateMemberInfo(member, Temp) ? "操作成功" : "操作失败"; md.MsgDivShow(msg, 1, Bind); } }
private void btndelete_Click(object sender, EventArgs e) { //判断是否选中 if (dgvmember.SelectedRows.Count <= 0) { mds.MsgDivShow("请选中要注销的会员", 1); return; } if (MessageBox.Show("真的要注销吗", "注销会员", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { //在哪里删除的会员 int index = cmbmember.SelectedIndex == 0 ? 1 : 2; MemberInfoBl memBll = new MemberInfoBl(); int memId = ((MemberInfo)dgvmember.SelectedRows[0].DataBoundItem).MemberId; string msg = memBll.SoftDeleteMemberByMemberId(memId, index) ? "操作成功" : "操作失败"; mds.MsgDivShow(msg, 1);//显示消息 //刷新 int delFlag = index == 1 ? 0 : 1; LoadMemberInfoByDelFlag(delFlag);//刷新操作 return; } mds.MsgDivShow("你已经取消了注销"); }
private void LoadMemberInfoByDelFlag(int p) { //查询会员 MemberInfoBl memBll = new MemberInfoBl(); dgvmember.AutoGenerateColumns = false;//禁止自动生成列 dgvmember.DataSource = memBll.GetAllMemberInfoByDelFlag(p); dgvmember.ClearSelection(); }
//模糊查询 private void btnsearch_Click(object sender, EventArgs e) { //if (string.IsNullOrEmpty(txtsearch.Text)) //{ // mds.MsgDivShow("姓名为空,不能查询", 1); // return; //} //按照用户输入的名字模糊查询 MemberInfoBl memBll = new MemberInfoBl(); dgvmember.AutoGenerateColumns = false; dgvmember.DataSource = memBll.GetMenmberInfoByLikeMemName(txtsearch.Text); dgvmember.ClearSelection();//清除选中内容, }
//导出操作 private void btnWrite_Click(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog();//new一个对话框 sfd.Filter = "Excel文件(*.xlsx)|*.xlsx"; sfd.Title = "Excel文件操作"; if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { //文件名=========sfd.FileName //NPOI操作Excel文件 MemberInfoBl bll = new MemberInfoBl(); bll.WriteExcel(sfd.FileName); mds.MsgDivShow("成功了", 1); } }
//结账窗体加载的时候 private void FrmGuestPay_Load(object sender, EventArgs e) { MemberInfoBl memBll = new MemberInfoBl(); //获取所有没被删除的会员 List <MemberInfo> list = memBll.GetAllMemberInfoByDelFlag(0); list.Insert(0, new MemberInfo() { MemName = "请选择", MemberId = -1 }); cmbMember.DataSource = list; cmbMember.DisplayMember = "MemName"; cmbMember.ValueMember = "MemberId"; //显示该订单的菜 Load_Order_ProductByOrdrtId(Convert.ToInt32(labOrderId.Text)); }
//结账 private void btnAccounts_Click(object sender, EventArgs e) { //餐桌状态发生改变 DeskInfoBLL dkbll = new DeskInfoBLL(); bool dkResult = dkbll.UpdateDeskInfoStateByDeskId(Convert.ToInt32(labdkId.Text), 0); //订单状态发生改变 OrderInfoBll orderBll = new OrderInfoBll(); OrderInfo order = new OrderInfo(); order.EndTime = System.DateTime.Now; //当前的时间 order.OrderMoney = Convert.ToDouble(lblMoney.Text); //结账后的金额 order.OrderState = 2; //状态 order.OrderId = Convert.ToInt32(labOrderId.Text); if (cmbMember.SelectedIndex != 0) { //获取选中的会员对象 MemberInfo mem = (MemberInfo)cmbMember.SelectedItem; order.OrderMemberId = mem.MemberId; //会员的id order.DisCount = mem.MemDiscount; //折扣 //根据会员的id更新该会员的金额 MemberInfoBl memBll = new MemberInfoBl(); //得到会员的金额 double money = Convert.ToDouble(labyuMoney.Text) - Convert.ToDouble(lblMoney.Text); //更新会员余额 memBll.UpdateMemberMoneyById(mem.MemberId, money);//==不接收了 } //更新订单中的金额 bool orderResult = orderBll.UpdateOrderInfo(order); //会员结账----更改会员余额 //改变订单对应的订单和菜单的中间表中的菜的状态 R_Order_ProductBll ropBll = new R_Order_ProductBll(); bool ropResult = ropBll.UpdateR_Order_ProductDelFlagByOrderId(Convert.ToInt32(labOrderId.Text)); if (dkResult && orderResult & ropResult) { md.MsgDivShow("顾客结账成功", 1); } else { md.MsgDivShow("结账失败了", 1); } }
private void btnRead_Click(object sender, EventArgs e) { //弹出对话框 让用户选择xlsx文件 OpenFileDialog ofd = new OpenFileDialog(); ofd.Title = "Execl文件操作"; ofd.Filter = "Excel文件(*.xlsx;*xls)|*.xlsx;*.xls"; if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { //获取文件 //读取excel文件 MemberInfoBl mblll = new MemberInfoBl(); mblll.ReadExcel(ofd.FileName); mds.MsgDivShow("成功"); //刷新 LoadMemberInfoByDelFlag(0); } //读取Excel文件 //把Excel文件的数据插入到数据库中 }