//开台
public void Pay(ref string ZhangDanId, string desk)
{
if (ZhangDanId == string.Empty)
{
try
{
dbh.DBOpen();
//获取桌台编号
string sql = "select id from desk where name='" + desk + "'";
SqlCommand comm = new SqlCommand(sql, dbh.Conn);
string deskid = comm.ExecuteScalar().ToString();
//新建订单
ZhangDanId = string.Format("{0:yyMMddHHmmss}", DateTime.Now);
sql = "insert ZhangDan select '" + ZhangDanId + "','" + deskid + "',null,getdate(),'0','0',1,'0','0' select top 1 id from zhangdan order by id desc";
comm = new SqlCommand(sql, dbh.Conn);
comm.ExecuteNonQuery();
//修改桌台状态
sql = "update desk set zhuangtai=1,dingdanid='" + ZhangDanId + "' where id='" + deskid + "'";
comm = new SqlCommand(sql, dbh.Conn);
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
text = ex.Message;
ShowMessage();
return;
}
finally
{
dbh.DBClose();
}
}
AddFood frm = new AddFood();
frm.ZhangDanId = ZhangDanId;
frm.Show();
this.Close();
}
//点餐
public static void OpenAddFood()
{
AddFood frm = new AddFood();
frm.Show();
}
