/// <summary> /// update Order Info /// </summary> /// <param name="order"></param> /// <returns></returns> public int UpdateOrderInfoMoney(OrderInfo order) { string sql = "update OrderInfo set OrderState=2, OrderMemId=@OrderMemId,EndTime=@EndTime,OrderMoney=@OrderMoney,DisCount=@Discount where OrderId=@OrderId"; SQLiteParameter[] ps ={ new SQLiteParameter("@OrderMemId",order.OrderMemId), new SQLiteParameter("@EndTime",order.EndTime), new SQLiteParameter("@OrderMoney",order.OrderMoney), new SQLiteParameter("@DisCount",order.DisCount), new SQLiteParameter("@OrderId",order.OrderId) }; return SqliteHelper.ExecuteNonQuery(sql, ps); }
/// <summary> /// 添加一个订单 /// </summary> /// <param name="order"></param> /// <returns></returns> public object AddOrderInfo(OrderInfo order) { string sql = "insert into OrderInfo(SubTime,Remark,OrderState,DelFlag,SubBy,OrderMoney) values(@SubTime,@Remark,@OrderState,@DelFlag,@SubBy,@OrderMoney);select last_insert_rowId()"; SQLiteParameter[] ps = { new SQLiteParameter("@SubTime",order.SubTime), new SQLiteParameter("@Remark",order.Remark), new SQLiteParameter("@OrderState",order.OrderState), new SQLiteParameter("@DelFlag",order.DelFlag), new SQLiteParameter("@SubBy",order.SubBy), new SQLiteParameter("@OrderMoney",order.OrderMoney) }; return SqliteHelper.ExecuteSclar(sql, ps); }
private void btnOK_Click(object sender, EventArgs e) { //change desk state DeskInfoBLL dkBll = new DeskInfoBLL(); bool dkFlag = dkBll.UpdateDeskStateByDeskId(this.ID, 1); //add an order OrderInfoBLL orBll = new OrderInfoBLL(); OrderInfo or = new OrderInfo(); or.SubTime = System.DateTime.Now; or.OrderMoney = 0; or.DelFlag = 0; or.OrderState = 1; or.Remark = txtPersonCount.Text + txtDescription.Text; or.SubBy = 1; int orderId = orBll.AddOrderInfo(or); //add R_Order_Desk R_Order_DeskBLL rodBll = new R_Order_DeskBLL(); R_Order_Desk rod = new R_Order_Desk(); rod.DeskId = this.ID; rod.OrderId = orderId; bool rodFlag = rodBll.AddROrderDesk(rod); if(dkFlag && rodFlag) { MessageBox.Show("开单成功"); if(ckbMeal.Checked) { MyEventArgs mea = new MyEventArgs(); //deskName mea.Name = labDeskName.Text; //Order Id mea.Temp = orderId; FrmAddMoney 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 { MessageBox.Show("开单失败"); } }
/// <summary> /// update Order Info /// </summary> /// <param name="order"></param> /// <returns></returns> /// public bool UpdateOrderInfoMoney(OrderInfo order) { return dal.UpdateOrderInfoMoney(order) > 0; }
/// <summary> /// 添加一个订单 /// </summary> /// <param name="order"></param> /// <returns></returns> /// public int AddOrderInfo(OrderInfo order) { return Convert.ToInt32(dal.AddOrderInfo(order)); }
//Pay the bill private void btnAccounts_Click(object sender, EventArgs e) { MemberInfo mem = cmbMemmber.SelectedItem as MemberInfo; if(string.IsNullOrEmpty(txtMoney.Text)) { MessageBox.Show("请输入钱"); return; } if(Convert.ToDecimal(txtMoney.Text) < Convert.ToDecimal(lblMoney.Text)) { MessageBox.Show("就这点钱? 搞笑呢"); return; } OrderInfo order = new OrderInfo(); //deskState in DeskInfo table DeskInfoBLL bll = new DeskInfoBLL(); bool deskFlag = bll.UpdateDeskStateByDeskId(this.deskId, 0); //non-member if(cmbMemmber.SelectedIndex != 0) { order.OrderMemId = mem.MemmberId; order.DisCount = Convert.ToDecimal(mem.MemDiscount); //after pay in member money decimal money = mem.MemMoney - Convert.ToDecimal(lblMoney.Text); MemberInfoBLL mbll = new MemberInfoBLL(); //if(money < 0) //{ //} //Member money in MemmberInfo table bool memFlag = mbll.UpdateMoneyByMemId(mem.MemmberId, money); } order.EndTime = System.DateTime.Now; order.OrderId = Convert.ToInt32(labOrderId.Text); order.OrderMoney = Convert.ToDecimal(lblMoney.Text); OrderInfoBLL obll = new OrderInfoBLL(); bool orderFlag = obll.UpdateOrderInfoMoney(order); lblSpareMoney.Text = (Convert.ToDecimal(txtMoney.Text) - Convert.ToDecimal(lblMoney.Text)).ToString(); if(deskFlag && orderFlag) { MessageBox.Show("结账成功"); } else { MessageBox.Show("失败"); } }