//添加和修改
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;
}
