//确定开单
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("开单失败");
}
}
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("开单失败");
}
}
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);
}