public static void UpdateOrderStatus(string _orderNo, string _productNo, byte _orderStatus) { if (!OrderInfoBLL.OrderAlreadyExsit(_orderNo)) { OrderInfoBLL.OrderInfoUpdate(_orderNo, _productNo, _orderStatus); } }
public static void RemoveOrder(string _orderNo, string _productNo) { if (!OrderInfoBLL.OrderAlreadyExsit(_orderNo)) { OrderInfoBLL.OrderInfoDelete(_orderNo, _productNo); } }
public CDMarzoAutoShopMethods() { customerinfobll = new CustomerInfoDAL(); itembll = new ItemDAL(); orderinfobll = new OrderInfoDAL(); salesbll = new SalesDAL(); }
public JsonResult Order_TD(string str) { BLL.OrderInfoBLL _BLL = new OrderInfoBLL(); retValue ret = new retValue(); JObject o = null; PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel; int userid = userModel._ID; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string ids = o["ID"]._ToStrTrim(); int Month = o["Month"]._ToInt32(); int OrderNum = o["OrderNum"]._ToInt32(); int Group_Type = o["Group_Type"]._ToInt32(); //1全退,2部分退 if (Group_Type == 1) { Month = 0; OrderNum = 0; } ret = _BLL.TD(ids.Remove(ids.Length - 1), userid, Group_Type, Month, OrderNum); } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
public ActionResult OrderInfos(int page, int limit, string test1, string test2, string Province, string CompanyCity, string CompanyUnderCity, string CompanyUnderArea, string OrderNo, string UnitName, string BKDH, string OrderState, string CostState) { PageModel ret = new PageModel(); BLL.OrderInfoBLL _BLL = new OrderInfoBLL(); PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel; string OrgID = ""; if (Province._ToInt32() > 0) { OrgID = Province; } if (CompanyCity._ToInt32() > 0) { OrgID = CompanyCity; } if (CompanyUnderCity._ToInt32() > 0) { OrgID = CompanyUnderCity; } if (CompanyUnderArea._ToInt32() > 0) { OrgID = CompanyUnderArea; } PageModel pg = _BLL.GetOrderInfo(0, BKDH, OrderNo, UnitName, test1, test2, userModel.OrgID._ToStr(), OrgID, OrderState, CostState, limit, page); var js = JsonConvert.SerializeObject(pg); return(Content(js)); }
private void btn_AddOrder_Click(object sender, EventArgs e) { if ((this.txtAddOrderNo.Text.Trim().Length > 0) && (this.txtAddProdNo.Text.Trim().Length > 0) && (RegularHelper.isNumericString(this.txtAddOrderCount.Text.Trim()))) { DialogResult diaresult = SpMessageBox.Show("确定要补充该订单吗?", "订单补充", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (diaresult == DialogResult.OK) { if (OrderInfoBLL.OrderAlreadyExsit(this.txtAddOrderNo.Text.Trim())) { if (OrderInfo.UpdateOrderCount(this.txtAddOrderNo.Text.Trim(), this.txtAddProdNo.Text.Trim(), int.Parse(this.txtAddOrderCount.Text.Trim()))) { SpMessageBox.Show("该订单数量补充完成", "订单补充"); } } else { SpMessageBox.Show("该订单号不存在,请检查该订单号是否生效", "订单补充"); } SystemLogs.WriteSystemLog(Login.UserName, "add order count:" + this.txtAddOrderCount.Text.Trim() + " for order " + this.txtAddOrderNo.Text.Trim() + " at " + Login.CurrentProductionLine, DateTime.Now); } } else { SpMessageBox.Show("请检查订单号,产品号,和订单数量的输入", "订单补充"); } }
public JsonResult Order_Deletes(string str) { BLL.OrderInfoBLL _BLL = new OrderInfoBLL(); retValue ret = new retValue(); string content = string.Empty; DataTable dt = str.ToTable(); string ids = ""; string costs = ""; foreach (DataRow item in dt.Rows) { if (!string.IsNullOrEmpty(item["ID"]._ToStrTrim())) { ids += item["ID"]._ToStrTrim() + ","; costs += item["CostID"]._ToStrTrim() + ","; } } ret = _BLL.DeleteByPK(ids.Remove(ids.Length - 1)); if (ret.result) { CostBLL costBLL = new CostBLL(); costBLL.DeleteByPK(costs); } content = ret.toJson(); var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
//增加消费 private void button2_Click(object sender, EventArgs e) { // ListView lv = (ListView)tabMain.SelectedTab.Controls[0]; //房间对象 RoomInfo room = (RoomInfo)(tabMain.SelectedTab.Tag); if (lv.SelectedItems.Count <= 0) { msg.MsgDivShow("请选择要增加消费的餐桌", 1); return; } DeskInfo desk = (lv.SelectedItems[0].Tag as DeskInfo); if (desk.DeskState == 0)//因为只允许单选,所以是tiems[0]; { msg.MsgDivShow("您选择的开单后的餐桌", 1); return; } //根据餐桌的id查询对应餐桌订单的id OrderInfoBLL obll = new OrderInfoBLL(); object objOrderId = obll.GetOrderIdByDeskId(desk.DeskId); FrmAddConsumption fac = FrmAddConsumption.Single(desk.DeskName, Convert.ToInt32(objOrderId)); fac.FormClosed += f_FormClosed; fac.Show(); }
//顾客结账了 private void button3_Click(object sender, EventArgs e) { ListView lv = (ListView)tabMain.SelectedTab.Controls[0]; //房间对象 RoomInfo room = (RoomInfo)(tabMain.SelectedTab.Tag); if (lv.SelectedItems.Count <= 0) { msg.MsgDivShow("请选择要结账的餐桌", 1); return; } DeskInfo desk = (lv.SelectedItems[0].Tag as DeskInfo); //因为只允许单选,所以是tiems[0]; if (desk.DeskState == 0) //0如果是空闲的餐桌 { msg.MsgDivShow("请选择正在就餐的餐桌", 1); return; } OrderInfoBLL obll = new OrderInfoBLL(); object objOrderId = obll.GetOrderIdByDeskId(desk.DeskId); FrmGuestPay fgp = FrmGuestPay.Single(Convert.ToInt32(objOrderId), desk.DeskName, desk.DeskId); fgp.FormClosed += f_FormClosed; fgp.Show(); }
//确定开单 private void btnOK_Click(object sender, EventArgs e) { //开单用了三张表 //先改变餐桌的状态,需要餐桌的id DeskInfoBLL dkBll = new DeskInfoBLL(); bool dkFlag = dkBll.UpdateDeskStateByDeskId(this.ID, 1); //添加一个订单 OrderInfo order = new OrderInfo(); order.DelFlag = 0; order.OrderState = 1; order.Remark = txtPersonCount.Text + "," + txtDescription.Text; order.SubBy = 1; order.SubTime = System.DateTime.Now; OrderInfoBLL orderBll = new OrderInfoBLL(); //插入一条数据返回该数据的主键id int orderId = orderBll.AddOrderInfo(order); //再把订单的id和餐桌的id存到中间表中 ROrderDeskBLL rodBll = new ROrderDeskBLL(); ROrderDesk rod = new ROrderDesk(); rod.DeskId = this.ID; //餐桌的id rod.OrderId = orderId; //订单的id bool rodFlag = rodBll.AddROrderDesk(rod); if (dkFlag && rodFlag) { MessageBox.Show("开单成功"); this.Close(); } else { MessageBox.Show("开单失败"); } }
public static bool UpdateOrderCount(string _orderNo, string _productNo, int _updatedOrderCount) { int originalOrderCount = OrderInfoBLL.GetOrderCountByOrderNo(_orderNo); return(OrderInfoBLL.OrderInfoUpdate(_orderNo, _productNo, _updatedOrderCount + originalOrderCount) && ProductionLineInfoBLL.UpdateOrderNoForProductionLine(_orderNo, _productNo, _updatedOrderCount + originalOrderCount)); }
public void SetText(object sender, EventArgs e) { //餐桌编号 var mea = e as MyEventArgs; var dk = mea.Obj as DeskInfo; labDeskName.Text = dk.DeskName; _dkId = dk.DeskId; //订单号 -> 根据DeskId查询OrderId var orderBLL = new OrderInfoBLL(); var orderId = orderBLL.GetOrderIdByDeskId(dk.DeskId); labOrderId.Text = orderId.ToString(); //消费总金额 -> 通过OrderId查询 var money = orderBLL.GetMoneyByOrderId(orderId); if (money != -1) { labMoney.Text = money.ToString(); lblMoney.Text = money.ToString(); } else { MessageBox.Show("查询订单消费失败"); } }
private void FrmAddConsumption_FormClosing(object sender, FormClosingEventArgs e) { //更新总价 if (!string.IsNullOrEmpty(labSumMoney.Text)) { OrderInfoBLL obll = new OrderInfoBLL(); obll.UpdateOrderMoneyAndBeginTimeByOrderId(Convert.ToInt32(labOrderId.Text), Convert.ToDouble(labSumMoney.Text)); //不用提示吧? } }
private void btnOK_Click(object sender, EventArgs e) { //餐桌的状态 var bllBk = new DeskInfoBLL(); var dkFlag = bllBk.UpdateDeskStateByDeskId(_id, 1); //添加一个订单 var odrBll = new OrderInfoBLL(); var odr = new OrderInfo(); odr.BeginTime = System.DateTime.Now; odr.SubTime = System.DateTime.Now; odr.DelFlag = 0; odr.OrderMoney = 0; odr.OrderState = 1; odr.Remark = txtPersonCount.Text + txtDescription.Text; odr.SubBy = 1; int orderId = odrBll.AddOrderInfo(odr); //添加一个中间表 var rodBll = new R_Order_DeskBLL(); var rod = new R_Order_Desk(); rod.DeskId = _id; rod.OrderId = orderId; var rodFlag = rodBll.AddROrderDesk(rod); if (dkFlag && rodFlag) { MessageBox.Show("开单成功"); if (ckbMeal.Checked) { var mea = new MyEventArgs(); mea.Name = labDeskName.Text; //餐桌编号 mea.Temp = orderId; //订单Id //窗体传值 var fam = new FrmAddMoney(); this.evtFrmMoney += new EventHandler(fam.SetText); if (this.evtFrmMoney != null) { this.evtFrmMoney(this, mea); fam.FormClosed += new FormClosedEventHandler(fam_FormClosed); fam.ShowDialog(); } } else { this.Close(); } } else { MessageBox.Show("开单失败"); } }
public frmOrderDish(ListView hallView, ListViewItem tableItem) { InitializeComponent(); this.hallView = hallView; this.tableItem = tableItem; this.Text = "厅包:" + this.hallView.Tag + "餐桌:" + tableItem.Text + "-" + this.Text; this.diBll = new DishInfoBLL(); this.dtiBll = new DishTypeInfoBLL(); this.odiBll = new OrderDetailInfoBLL(); this.odBll = new OrderInfoBLL(); }
public static void CheckOrderExsit(string _orderNo, string _productNo, int _orderCount) { if (!OrderInfoBLL.OrderAlreadyExsit(_orderNo)) { OrderInfoBLL.OrderInfoInsert(_orderNo, _productNo, _orderCount); } else { OrderInfoBLL.OrderInfoUpdate(_orderNo, _productNo, _orderCount); } }
private FrmGuestPay(int orderId, string deskName, int deskId) { InitializeComponent(); labDeskName.Text = deskName; labOrderId.Text = orderId.ToString(); labdkId.Text = deskId.ToString(); OrderInfoBLL obll = new OrderInfoBLL(); object objMoney = obll.GetMoneyByOrderId(orderId); labMoney.Text = objMoney.ToString(); //显示消费金额 lblMoney.Text = objMoney.ToString(); //结账金额 }
//增加消费 private void button2_Click(object sender, EventArgs e) { TabPage tp = tcin.TabPages[tcin.SelectedIndex]; //获取当前选中房间的名字 RoomInfo room = tp.Tag as RoomInfo; FrmEventArgs fea = new FrmEventArgs(); fea.Money = Convert.ToDecimal(room.RoomMinimunConsume); fea.Name = room.RoomName; //string roomName = room.RoomName; //最低消费 //获取当前选项卡中的listview控件 ListView lv = tp.Controls[0] as ListView; //判断是否有选中的餐桌 if (lv.SelectedItems.Count > 0) { //获取当前选中的餐桌 DeskInfo dk = lv.SelectedItems[0].Tag as DeskInfo; if (dk.DeskState == 1) { //fea.obj = dk; fea.Name = dk.DeskName;//餐桌的编号 //订单的id,根据餐桌的id查找订单的id OrderInfoBLL obll = new OrderInfoBLL(); int orderId = obll.GetOrderIdByDeskId(dk.DeskId); fea.Temp = orderId; FrmAddMoney fam = new FrmAddMoney(); this.evtAddMoney += new EventHandler(fam.SetText);//注册事件 if (this.evtAddMoney != null) { this.evtAddMoney(this, fea); } fam.FormClosed += new FormClosedEventHandler(fbi_FormClosed); fam.ShowDialog(); } else { MessageBox.Show("请选择开单的餐桌"); } } else { MessageBox.Show("没选中"); } }
/// <summary> /// 获取订单列表 /// </summary> /// <param name="pageindex"></param> /// <param name="pagesize"></param> /// <param name="starttime"></param> /// <param name="endtime"></param> /// <param name="status"></param> /// <param name="appname"></param> /// <param name="username"></param> /// <returns></returns> public dynamic GetList(int pageindex, int pagesize, string starttime, string endtime, int status, string appname, string username) { try { OrderInfoBLL orderInfoBLL = new OrderInfoBLL(); //throw new Exception("错误"); return(orderInfoBLL.GetPageList(pageindex, pagesize, starttime, endtime, status, appname, username)); } catch (ErrorMsgException ex) { return(new { status = 1, message = ex.Message }); } }
public ActionResult Order_getCounts(string str) { retValue ret = new retValue(); PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel; int userid = userModel._ID; BLL.OrderInfoBLL _BLL = new OrderInfoBLL(); JObject o = null; if (!string.IsNullOrEmpty(str)) { o = JObject.Parse(str); string test1 = o["test1"]._ToStrTrim(); string test2 = o["test2"]._ToStrTrim(); string Province = o["Province"]._ToStrTrim(); string CompanyCity = o["CompanyCity"]._ToStrTrim(); string CompanyUnderCity = o["CompanyUnderCity"]._ToStrTrim(); string CompanyUnderArea = o["CompanyUnderArea"]._ToStrTrim(); string OrderNo = o["OrderNo"]._ToStrTrim(); string UnitName = o["UnitName"]._ToStrTrim(); string BKDH = o["BKDH"]._ToStrTrim(); string OrderState = o["OrderState"]._ToStrTrim(); string CostState = o["CostState"]._ToStrTrim(); string OrgID = ""; if (Province._ToInt32() > 0) { OrgID = Province; } if (CompanyCity._ToInt32() > 0) { OrgID = CompanyCity; } if (CompanyUnderCity._ToInt32() > 0) { OrgID = CompanyUnderCity; } if (CompanyUnderArea._ToInt32() > 0) { OrgID = CompanyUnderArea; } PageModel pg = _BLL.GetCount(0, BKDH, OrderNo, UnitName, test1, test2, userModel.OrgID._ToStr(), OrgID, OrderState, CostState); ret.result = true; ret.data = pg.msg; } var js = JsonConvert.SerializeObject(ret); return(Json(js, JsonRequestBehavior.AllowGet)); }
private void FrmAddMoney_FormClosing(object sender, FormClosingEventArgs e) { if (labSumMoney.Text != "" && !string.IsNullOrEmpty(labSumMoney.Text)) { var bll = new OrderInfoBLL(); var id = Convert.ToInt32(labOrderId.Text); var money = Convert.ToInt32(labSumMoney.Text); if (bll.UpdateMoneyByOrderId(id, money) == false) { MessageBox.Show("保存订单总消费失败"); } } }
private int Id;//存餐桌的id public void SetTxt(object sender, EventArgs e) { FrmEventArgs fea = e as FrmEventArgs; this.Id = fea.DkIdZ; //获取餐桌的id labDeskName.Text = fea.Name; //餐桌的编号 labOrderId.Text = fea.Temp.ToString(); //订单的id //根据订单的id查询这个订单消费了多少钱 OrderInfoBLL bll = new OrderInfoBLL(); labMoney.Text = bll.GetOrderMoney(fea.Temp).ToString(); lblMoney.Text = labMoney.Text;//结账金额和消费金额一样------坑 }
//确定开单 private void btnOK_Click(object sender, EventArgs e) { //餐桌的id,改变餐桌的状态 DeskInfoBLL dkBll = new DeskInfoBLL(); bool dkResult = dkBll.UpdateDeskStateByDeskId(this.Id, 1);//餐桌开单了 //添加一个订单,需要备注,订单的状态,提交人,提交时间,删除标识 OrderInfo order = new OrderInfo(); order.Remark = txtPersonCount.Text + txtDescription.Text;//人数和描述(备注)直接存到备注信息里 order.SubBy = 1; order.SubTime = DateTime.Now; order.DelFlag = 0; order.OrderState = 1; //标识的是这个订单正在使用 OrderInfoBLL odBll = new OrderInfoBLL(); int orderId = odBll.GetOrderIdInsertOrderInfo(order); //插入一个订单的同时获取该订单的id //向中间表(订单和餐桌)插入 订单的id还有餐桌的id ROrderDeskBLL roddkBll = new ROrderDeskBLL(); ROrderDesk rod = new ROrderDesk(); rod.DeskId = this.Id; //餐桌id rod.OrderId = orderId; //订单id bool RoDResult = roddkBll.AddROrderDesk(rod); if (dkResult && RoDResult) { MessageBox.Show("开单成功"); this.Close(); } else { MessageBox.Show("开单失败"); } if (ckbMeal.Checked) { FrmAddMoney fam = new FrmAddMoney(); this.evt += new EventHandler(fam.SetTxt); FrmEventArgs fea = new FrmEventArgs(); fea.Name = labDeskName.Text; //餐桌的编号 fea.Temp = orderId; //订单的id if (this.evt != null) { this.evt(this, fea); } //增加消费的窗体关闭后,当前的开单窗体关闭 fam.FormClosed += new FormClosedEventHandler(fam_FormClosed); fam.ShowDialog(); } }
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("结账失败"); } }
private bool TryUpdateOrderInfo() { OrderInfoBLL orderBll = new OrderInfoBLL(); OrderInfo order = orderBll.get(this.orderId); order.EndTime = DateTime.Now; order.OrderMoney = Convert.ToDouble(lblCheckMoney.Text); order.OrderState = (int)OrderStatus.Checked; if (cmbMember.SelectedIndex != 0) { MemberInfo member = (MemberInfo)cmbMember.SelectedItem; order.OrderMemberId = member.MemberId; order.DisCount = member.MemDiscount; } return(orderBll.update(order)); }
/// <summary> /// 构造函数 /// </summary> public DiagnosisPayController() { orderInfoBLL = new OrderInfoBLL(); orderfeedetailBLL = new OrderfeedetailBLL(); reginfoBLL = new ReginfoBLL(); feeinfoBLL = new FeeinfoBLL(); feeInfodetailBLL = new FeeInfodetailBLL(); ptInfoBLL = new PtInfoBLL(); sysDeptBLL = new SysDeptBLL(); sysUserinfoBLL = new SysUserinfoBLL(); feeTrialBLL = new FeeTrialBLL(); commKeyBLL = new CommKeyBLL(); commFeeBLL = new CommFeeBLL(); commMedBLL = new CommMedBLL(); commYbCodeBLL = new CommYbCodeBLL(); }
private void FrmAddMoney_FormClosing(object sender, FormClosingEventArgs e) { if (DialogResult.OK == MessageBox.Show("确定关闭吗?", "提示订单提交", MessageBoxButtons.OKCancel)) { if (!string.IsNullOrEmpty(labSumMoney.Text)) { OrderInfoBLL bll = new OrderInfoBLL(); if (bll.UpdateOrderMoney(this.ordId, Convert.ToDecimal(labSumMoney.Text))) { MessageBox.Show("订单提交成功"); } else { MessageBox.Show("订单提交失败"); } } } }
public void ExportOrder(string starttime, string endtime, int status, string appname, string username) { OrderInfoBLL orderInfoBLL = new OrderInfoBLL(); List <OrderInfo> exportList = orderInfoBLL.ExportList(starttime, endtime, status, appname, username); StringBuilder sb = new StringBuilder(); sb.AppendLine("AppId\t" + "应用名称\t" + "任务类型\t" + "用户名\t" + "IDFA\t" + "IP地址\t" + "任务开始时间\t" + "任务完成时间\t" + "状态\t" + "订单创建时间\t"); foreach (OrderInfo item in exportList) { sb.AppendLine(item.TaskInfo.AppId + "\t" + item.TaskInfo.App.Name + "\t" + item.TaskInfo.Type.ToString() + "\t" + item.Account.UserName + "\t" + item.IDFA + "\t" + item.IPAddress + "\t" + (item.StartTime == null ? "" : item.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss")) + "\t" + (item.EndTime == null ? "" : item.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss")) + "\t" + item.Status.ToString() + "\t" + item.CreateTime.ToString("yyyy-MM-dd HH:mm:ss") + "\t"); } System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312"); System.Web.HttpContext.Current.Response.AddHeader ("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("订单记录明细" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls")); System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel"; System.Web.HttpContext.Current.Response.Write(sb.ToString()); System.Web.HttpContext.Current.Response.Flush(); System.Web.HttpContext.Current.Response.End(); }
//结账按钮 private void button3_Click(object sender, EventArgs e) { TabPage tp = tcInFo.SelectedTab; //获取当前餐桌所在的房间的选项卡 RoomInfo r = tp.Tag as RoomInfo; //从tag中获取房间的对象==坑---名字,最低消费 ListView lv = tp.Controls[0] as ListView; //获取listview if (lv.SelectedItems.Count > 0) { ListViewItem lvt = lv.SelectedItems[0]; //获取当前listview中选中的项 DeskInfo dk = lvt.Tag as DeskInfo; //可以获取该选中的餐桌的编号还有id if (dk.DeskState == 1) { FrmBalance fb = new FrmBalance(); this.evtBalance += new EventHandler(fb.SetTxt);//传值 //获取要传递的参数后 显示开单的窗体 FrmEventArgs fea = new FrmEventArgs(); fea.Name = dk.DeskName; //餐桌的编号 fea.DkIdZ = dk.DeskId; //餐桌的id //这里必须要获取该餐桌的订单id===============坑 OrderInfoBLL obll = new OrderInfoBLL(); int orderId = obll.GetOrderIdByDeskId(dk.DeskId); //获取订单的id(当前餐桌) fea.Temp = orderId; //订单id传到消费窗体中 if (this.evtBalance != null) { this.evtBalance(this, fea); } //此窗体关闭后 一定要进行刷新. fb.FormClosed += new FormClosedEventHandler(fbl_FormClosed);//调用上面的方法 fb.ShowDialog(); } else { MessageBox.Show("请选择已经开单的餐桌"); } } else { MessageBox.Show("请看好目标后再下手"); } }
private void btnOk_Click(object sender, EventArgs e) { //顾客开单 //更新餐桌状态 DeskInfoBLL dbll = new DeskInfoBLL(); int deksId = Convert.ToInt32(labId.Text); bool isDesk = dbll.UpdateDeskInfoStateByDeskId(deksId, 1);//1标识正在使用 //生成订单 OrderInfoBLL obll = new OrderInfoBLL(); OrderInfo order = new OrderInfo(); order.BeginTime = DateTime.Now; order.DelFlag = 0; order.DisCount = 0; order.OrderMoney = 0; order.OrderState = 1;//表示已经开单 order.Remark = txtPersonCount.Text + "个人" + txtDescription.Text; order.SubBy = 1; order.SubTime = System.DateTime.Now; object obj = obll.AddOrderInfo(order);//返回的是刚刚插入的订单的主键id; //向中间表插入一条数据 R_Order_DeskBLL rodbll = new R_Order_DeskBLL(); R_Order_Desk rod = new R_Order_Desk(); rod.DeskId = deksId; rod.OrderId = Convert.ToInt32(obj); ordId = Convert.ToInt32(obj); bool isRod = rodbll.AddR_Order_Desk(rod); if (!isDesk || !isRod) { md.MsgDivShow("开单失败,请联系管理员", 1); return; } md.MsgDivShow("开单成功", 1, Bind); // md.MsgDivShow("开单成功",1,Bind); }