//添加和修改 private void btnOk_Click(object sender, EventArgs e) { //先判断不能为空 if (IsCheck()) { //判断是新增还是修改 DeskInfo dk = new DeskInfo(); dk.DeskName = txtDeskName.Text; dk.DeskRegion = txtDeskRegion.Text; dk.DeskRemark = txtDeskRemark.Text; dk.RoomId = Convert.ToInt32(cmdRoom.SelectedValue); if (this.Tp == 3)//添加 { dk.DelFlag = 0; dk.DeskState = 0; dk.SubBy = 1; dk.SubTime = DateTime.Now; } else if (this.Tp == 4)//修改 { dk.DeskId = Convert.ToInt32(labId.Text); } DeskInfoBLL bll = new DeskInfoBLL(); string msg = bll.SaveDeskinfo(dk, this.Tp)?"操作成功":"操作失败"; MessageBox.Show(msg); this.Close(); } }
public void SetText(object sender, EventArgs e) { FrmEventArgs fea = e as FrmEventArgs; this.Temp = fea.Temp; //标识 LoadRoomType(); //加载房间类型 if (fea.Temp == 3) //新增 { foreach (Control item in this.Controls) { if (item is TextBox) { TextBox tb = item as TextBox; tb.Text = ""; } } } else if (fea.Temp == 4) //修改 { DeskInfo dk = fea.obj as DeskInfo; txtDeskName.Text = dk.DeskName; txtDeskRegion.Text = dk.DeskRegion; txtDeskRemark.Text = dk.DeskRemark; labId.Text = dk.DeskId.ToString(); cmdRoom.SelectedValue = dk.RoomId; } //清空文本框 //加载房间类型 }
//事件赋值 public void SetTxt(object sender, EventArgs e) { LoadRoomNameAndRoomId(0); //清空当前窗体的所有的文本框内容 foreach (Control item in this.Controls) { if (item is TextBox) { TextBox tb = item as TextBox; tb.Text = ""; } } FrmEventArgs fea = e as FrmEventArgs; this.Tp = fea.Temp; //标识存起来 if (this.Tp == 4) //修改 { DeskInfo dk = fea.Obj as DeskInfo; txtDeskName.Text = dk.DeskName; txtDeskRegion.Text = dk.DeskRegion; txtDeskRemark.Text = dk.DeskRemark; labId.Text = dk.DeskId.ToString(); //把id存起来 cmdRoom.SelectedValue = dk.RoomId; //把房间的id绑定到下拉框,下拉框就会显示对象的名字 } }
private int AddOrUpdate(DeskInfo dk, string sql, int temp) { SqlParameter[] ps = { new SqlParameter("@RoomId", dk.RoomId), new SqlParameter("@DeskName", dk.DeskName), new SqlParameter("@DeskRemark", dk.DeskRemark), new SqlParameter("@DeskRegion", dk.DeskRegion) }; List <SqlParameter> list = new List <SqlParameter>(); list.AddRange(ps); if (temp == 1)//新增 { list.Add(new SqlParameter("@DelFlag", dk.DelFlag)); list.Add(new SqlParameter("@SubTime", dk.SubTime)); list.Add(new SqlParameter("@SubBy", dk.SubBy)); list.Add(new SqlParameter("@DeskState", dk.DeskState)); } else if (temp == 2)//修改 { list.Add(new SqlParameter("@DeskId", dk.DeskId)); } return(SqlHelper.ExecuteNonQuery(sql, list.ToArray())); }
private void btnAddConsumption_Click(object sender, EventArgs e) { if (tabMain.TabCount <= 0) { md.MsgDivShow("sorry啊,店内装修,暂不营业", 1); return; } ListView lv = (ListView)tabMain.SelectedTab.Controls[0]; if (lv.SelectedItems.Count <= 0) { md.MsgDivShow("亲,请先选择餐桌哦", 1); return; } RoomInfo room = (RoomInfo)tabMain.SelectedTab.Tag; DeskInfo desk = (DeskInfo)lv.SelectedItems[0].Tag; if (desk.DeskState == 0) { md.MsgDivShow("亲,请选择开单后的餐桌哦", 1); return; } int orderID = new R_Order_DeskBLL().GetAliveOrderIdByDeskId((int)desk.DeskId); FrmAddConsumption fac = FrmAddConsumption.Single(orderID, desk.DeskName); //主窗体要刷新!因为如果不刷新,之前选中的状态还会存在,虽然你看不见。 //测试方法: //正常情况:选中餐桌→增加消费→关闭增加消费窗体→选中餐桌→增加消费 //bug情况:关闭增加消费窗体→增加消费(不用选中餐桌就能增加消费了) fac.FormClosed += fb_FormClosed; fac.Show(); }
//增加修改 private int AddAndUpdate(DeskInfo dk, string sql, int tp) { List <SQLiteParameter> list = new List <SQLiteParameter>(); SQLiteParameter[] param = { new SQLiteParameter("@RoomId", dk.RoomId), new SQLiteParameter("@DeskName", dk.DeskName), new SQLiteParameter("@DeskRemark", dk.DeskRemark), new SQLiteParameter("@DeskRegion", dk.DeskRegion) }; list.AddRange(param); if (tp == 3) { list.Add(new SQLiteParameter("@DelFlag", dk.DelFlag)); list.Add(new SQLiteParameter("@SubTime", dk.SubTime)); list.Add(new SQLiteParameter("@SubBy", dk.SubBy)); list.Add(new SQLiteParameter("@DeskState", dk.DeskState)); } else if (tp == 4) { list.Add(new SQLiteParameter("@DeskId", dk.DeskId)); } return(SqliteHelper.ExecuteNonquery(sql, list.ToArray())); }
//新增 public int AddDeskInfo(DeskInfo dk) { //DeskId RoomId DeskName DeskRemark DeskRegion DeskState DelFlag SubTime SubBy string sql = "insert into DeskInfo(RoomId, DeskName, DeskRemark, DeskRegion, DeskState ,DelFlag ,SubTime, SubBy) values(@RoomId, @DeskName, @DeskRemark, @DeskRegion, @DeskState ,@DelFlag ,@SubTime, @SubBy)"; return(AddAndUpdate(dk, sql, 1)); }
private void ShowFrmDeskAddOrModify(int temp, DeskInfo desk) { FrmDeskAddOrModify frm = FrmDeskAddOrModify.Single(temp, desk); frm.FormClosed += frm_FormClosed; frm.Show(); }
//增加消费 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(); }
public RestaurantInfo() { for (int i = 0; i < m_Desks.Length; i++) { m_Desks[i] = new DeskInfo(); } }
//顾客开单 private void button1_Click(object sender, EventArgs e) { //显示开单窗体 // TabPage tp=tabMain.SelectedTab;//.Control[0]; // ListView lv=(ListView)tp.Controls[0]; ListView lv = (ListView)(tabMain.SelectedTab.Controls[0]); //房间的对象 RoomInfo room = (RoomInfo)tabMain.SelectedTab.Tag; //餐桌的对象 if (lv.SelectedItems.Count <= 0)//没选中餐桌 { md.MsgDivShow("请选中要点餐的餐桌", 1); return; } DeskInfo dk = (lv.SelectedItems[0].Tag as DeskInfo); if (dk.DeskState == 1) { md.MsgDivShow("请选择其余没在就餐的餐桌", 1); return; } FrmBilling fbi = FrmBilling.Single(dk.DeskId, dk.DeskName, room); fbi.FormClosed += new FormClosedEventHandler(fbi_FormClosed); fbi.Show();//显示开单窗体 }
//增加消费 private void btnAddConsumption_Click(object sender, EventArgs e) { // ListView lv = (ListView)(tabMain.SelectedTab.Controls[0]); //房间的对象 RoomInfo room = (RoomInfo)(tabMain.SelectedTab.Tag); //餐桌的对象 if (lv.SelectedItems.Count <= 0)//没选中餐桌 { md.MsgDivShow("请选中要增加消费的餐桌", 1); return; } DeskInfo dk = (lv.SelectedItems[0].Tag as DeskInfo); if (dk.DeskState == 0) { md.MsgDivShow("请选择开单后的餐桌进行增加消费", 1); return; } //根据餐桌的id查询该餐桌对应的订单的id OrderInfoBll orderBll = new OrderInfoBll(); object objOrderId = orderBll.GetOrderIdByDeskId(dk.DeskId); FrmAddConsumption fac = FrmAddConsumption.Single(dk.DeskName, Convert.ToInt32(objOrderId)); //增加消费之后=======刷新 fac.FormClosed += new FormClosedEventHandler(fbi_FormClosed); //!!!!!!!!!必须刷新 fac.Show(); //显示增加消费的窗体 }
public int AddAndUpdate(DeskInfo desk, string sql, int temp) { SQLiteParameter[] param = { new SQLiteParameter("@RoomId", desk.RoomId), new SQLiteParameter("@DeskName", desk.DeskName), new SQLiteParameter("@DeskRegion", desk.DeskRegion), new SQLiteParameter("@DeskRemark", desk.DeskRemark) }; List <SQLiteParameter> list = new List <SQLiteParameter>(); list.AddRange(param); if (temp == 1) { list.Add(new SQLiteParameter("@DeskState", desk.DeskState)); list.Add(new SQLiteParameter("@DelFlag", desk.DelFlag)); list.Add(new SQLiteParameter("@Subtime", desk.SubTime)); list.Add(new SQLiteParameter("@SubBy", desk.SubBy)); } else if (temp == 2) { list.Add(new SQLiteParameter("@DeskId", desk.DeskId)); } return(SqliteHelper.ExecuteNonQuery(sql, list.ToArray())); }
private void btnOk_Click(object sender, EventArgs e) { if (CheckEmpty()) { DeskInfoBLL dkBll = new DeskInfoBLL(); DeskInfo dk = new DeskInfo(); dk.DeskName = txtDeskName.Text; dk.DeskRegion = txtDeskRegion.Text; //描述信息 dk.DeskRemark = txtDeskRemark.Text; //备注 dk.RoomId = Convert.ToInt32(cmbRoom.SelectedValue); //房间的id if (Temp == 1) //新增 { dk.DelFlag = 0; dk.DeskState = 0;//空闲===1===就餐 dk.SubBy = 1; dk.SubTime = System.DateTime.Now; } else if (Temp == 2)//修改操作 { dk.DeskId = Convert.ToInt32(labId.Text); } md.MsgDivShow(dkBll.AddOrUpdateDeskInfo(dk, Temp) ? "操作成功" : "操作失败", 1, Bind); } }
public void SetDeskText(object sender, EventArgs e) { //获取传过来的值 //清空所有文本框 FrmEventArgs feas = e as FrmEventArgs; this.Tp = feas.Temp; LoadRoomType(); if (feas.Temp == 1) { foreach (Control item in this.Controls) { if (item is TextBox) { TextBox tb = item as TextBox; tb.Text = ""; } } } else if (this.Tp == 2) { DeskInfo desk = feas.obj as DeskInfo; labId.Text = desk.DeskId.ToString(); txtDeskName.Text = desk.DeskName; txtDeskRegion.Text = desk.DeskRegion; txtDeskRemark.Text = desk.DeskRemark; cmdRoom.SelectedValue = desk.RoomId; } }
private void btnDDesk_Click(object sender, EventArgs e) { //判断是否选择了删除的对象 if (dgvDesk.SelectedRows.Count <= 0) { md1.MsgDivShow("请选择要注销的餐桌", 1); return; } //提示用户是否真的删除 if (MessageBox.Show("亲,真的要注销这个餐桌吗?", "注销提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { //删除 DeskInfoBLL dBll = new DeskInfoBLL(); DeskInfo d = (DeskInfo)dgvDesk.SelectedRows[0].DataBoundItem; string msg = dBll.SoftDelete((int)d.DeskId) > 0 ? "操作成功" : "操作失败"; md1.MsgDivShow(msg, 1); //刷新 LoadDeskByDelFlag(0); LoadDeskEvent(GetTabPage()); return; } //提示取消删除 md1.MsgDivShow("您已经取消了注销", 1); }
private void button1_Click(object sender, EventArgs e) { if (CheckEmpty()) { DeskInfo desk = new DeskInfo(); desk.DeskName = txtName.Text; desk.DeskRegion = txtRegion.Text; desk.DeskRemark = txtRemark.Text; desk.RoomId = Convert.ToInt32(cmbRoom.SelectedValue);//房间的id if (Temp == 1) { desk.DeskState = 0; desk.SubBy = 1; desk.SubTime = DateTime.Now; desk.DelFlag = 0; } else if (Temp == 2) { desk.DeskId = Convert.ToInt32(labId.Text); } string strMsg = bll.AddOrUpdateDeskInfo(desk, Temp) ? "操作成功" : "操作失败"; msg.MsgDivShow(strMsg, 1, Bind); } }
//顾客结账了 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 btnGuestPay_Click(object sender, EventArgs e) { //结账条件检查 if (tabMain.TabCount <= 0) { md.MsgDivShow("sorry啊,店内装修,暂不营业", 1); return; } ListView lv = (ListView)tabMain.SelectedTab.Controls[0]; if (lv.SelectedItems.Count <= 0) { md.MsgDivShow("亲,请先选择要结账的餐桌哦", 1); return; } RoomInfo room = (RoomInfo)tabMain.SelectedTab.Tag; DeskInfo desk = (DeskInfo)lv.SelectedItems[0].Tag; if (desk.DeskState == 0) { md.MsgDivShow("亲,请选择正在就餐的餐桌哦", 1); return; } //弹出结账窗体 int deskId = (int)desk.DeskId; string deskNum = desk.DeskName; int orderId = new R_Order_DeskBLL().GetAliveOrderIdByDeskId((int)desk.DeskId); FrmGuestPay fcp = FrmGuestPay.Single(deskId, deskNum, orderId); //刷新主窗体 fcp.FormClosed += fb_FormClosed; fcp.Show(); }
/// <summary> /// 开单的三件事情 /// </summary> /// <param name="insertOrder">插入的order,注意该order对象没有id</param> /// <param name="desk">state:0--->空闲;1--->就餐</param> /// <returns>返回orderId</returns> public int AddOrderAddOrder_DeskUpdateDesk(OrderInfo insertOrder, DeskInfo desk) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString)) { con.Open(); SqlTransaction tx = con.BeginTransaction(); try { //修改deskinfo的state为1 new DeskInfoDAL().UpdateDeskInfoStateByDeskIdAndState(con, tx, (int)desk.DeskId, 1); //插入新的order,并将得到的id传给下面的R_Order_Desk int orderId = add(con, tx, insertOrder); //插入order_desk R_Order_Desk od = new R_Order_Desk(); od.OrderId = orderId; od.DeskId = desk.DeskId; new R_Order_DeskDAL().add(con, tx, od); tx.Commit(); return(orderId); } catch { tx.Rollback(); return(0); } } }
private FrmDeskAddOrModify(HandleStatus status, DeskInfo oldDesk) : this() { this.status = status; this.oldDesk = oldDesk; }
//上帝结账 private void btnGuestPay_Click(object sender, EventArgs e) { ListView lv = (ListView)(tabMain.SelectedTab.Controls[0]); //房间的对象 RoomInfo room = (RoomInfo)(tabMain.SelectedTab.Tag); //餐桌的对象 if (lv.SelectedItems.Count <= 0)//没选中餐桌 { md.MsgDivShow("请选中要结账的餐桌", 1); return; } DeskInfo dk = (lv.SelectedItems[0].Tag as DeskInfo); if (dk.DeskState == 0)//没有选中就餐的餐桌 { md.MsgDivShow("请选择就餐的餐桌进行结账", 1); return; } //结账了--显示窗体 //获取订单的id OrderInfoBll orderBll = new OrderInfoBll(); object objOrderId = orderBll.GetOrderIdByDeskId(dk.DeskId); FrmGuestPay fgp = FrmGuestPay.Single(Convert.ToInt32(objOrderId), dk.DeskId, dk.DeskName); fgp.FormClosed += new FormClosedEventHandler(fbi_FormClosed); //刷新 fgp.Show(); //结账的窗体就显示出来 }
private void btnOk_Click(object sender, EventArgs e) { if (CheckEmpty()) { DeskInfo desk = new DeskInfo(); //desk.RoomId = Convert.ToInt32(cmdRoom.Text); desk.DeskName = txtDeskName.Text; desk.DeskRegion = txtDeskRegion.Text; desk.DeskRemark = txtDeskRemark.Text; if (this.Tp == 1) { desk.DelFlag = 0; desk.DeskState = 0; desk.SubTime = System.DateTime.Now; desk.SubBy = 1; desk.RoomId = Convert.ToInt32(cmdRoom.SelectedIndex); } else if (this.Tp == 2) { desk.DeskId = Convert.ToInt32(labId.Text); //desk.RoomId = Convert.ToInt32(cmdRoom.SelectedIndex); } DeskInfoBLL bll = new DeskInfoBLL(); string msg = bll.SaveDesk(desk, this.Tp) ? "操作成功": "操作失败"; MessageBox.Show(msg); this.Close(); } }
public static FrmBilling Single(RoomInfo oldRoom, DeskInfo oldDesk) { if (instance == null || instance.IsDisposed) { instance = new FrmBilling(oldRoom, oldDesk); } return(instance); }
private void AddOrUdDeak(DeskInfo dk, int temp) { this.Hide(); FrmDeakAddOrModify fdam = FrmDeakAddOrModify.Single(dk, temp); fdam.FormClosed += new FormClosedEventHandler(fdam_FormClose); fdam.Show(); }
private void ShowFrmDeskAddOrModify(HandleStatus status, DeskInfo desk) { this.Hide(); FrmDeskAddOrModify fdaom = FrmDeskAddOrModify.Single(status, desk); fdaom.FormClosed += fraom_FormClosed; fdaom.Show(); }
public static FrmDeskAddOrModify Single(int temp, DeskInfo desk) { if (_instance == null || _instance.IsDisposed) { _instance = new FrmDeskAddOrModify(desk); Temp = temp; } return(_instance); }
public static FrmDeakAddOrModify Single(DeskInfo dk, int temp) { if (instance == null || instance.IsDisposed) { instance = new FrmDeakAddOrModify(dk); Temp = temp; } return(instance); }
private void btnUDesk_Click(object sender, EventArgs e) { if (dgvDesk.SelectedRows.Count <= 0) { md1.MsgDivShow("选中要修改的行", 1); } DeskInfo dk = (DeskInfo)dgvDesk.SelectedRows[0].DataBoundItem; AddOrUdDeak(dk, 2); }
public void SetText(object sender, EventArgs e) { MyEventArgs mea = e as MyEventArgs; DeskInfo desk = mea.Obj as DeskInfo; labDeskName.Text = desk.DeskName; labLittleMoney.Text = mea.Money.ToString(); labRoomType.Text = mea.Name; this.ID = desk.DeskId; }