//开台 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(); }