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>
/// 添加一个中间表的数据
/// </summary>
/// <param name="rod"></param>
/// <returns></returns>
public int AddROrderDesk(R_Order_Desk rod)
{
string sql = "insert into R_Order_Desk (OrderId,DeskId) values(@OrderId,@DeskId)";
return SqliteHelper.ExecuteNonQuery(sql, new SQLiteParameter("@OrderId", rod.OrderId), new SQLiteParameter("@DeskId", rod.DeskId));
}
/// <summary>
/// 添加一个中间表的数据
/// </summary>
/// <param name="rod"></param>
/// <returns></returns>
///
public bool AddROrderDesk(R_Order_Desk rod)
{
return dal.AddROrderDesk(rod) > 0;
}