餐飲管理數(shù)據(jù)庫課程設(shè)計(編輯修改稿)
2025-05-09 04:50 本頁面
【文章內(nèi)容簡介】 @Customerno varchar(10), @odertime datetime, @Foodtableno varchar(10)as insert into Oder values(@oderno,@Customerno,@odertime,@Foodtableno)exec 預(yù)定 39。O_00539。,39。C_03539。,39。201261639。,39。TB_839。查詢預(yù)訂drop proc 查詢預(yù)訂create proc 查詢預(yù)訂 @Customerno varchar(10), @Oderno varchar(10) outputas if exists(select* from oder where customerno=@Customerno) begin print 39。已預(yù)訂39。 select @Oderno=oderno from oder where customerno=@Customerno print 39。預(yù)定號為：39。+@Oderno end else print 39。未預(yù)定39。declare @Oderno varchar(10)exec 查詢預(yù)訂 39。C_00239。, @Oderno outputdeclare @Oderno varchar(10)exec 查詢預(yù)訂 39。C_03539。, @Oderno output開臺信息drop proc 開臺create proc 開臺 @Menuno varchar(10),@Foodtableno varchar(10),@customerno varchar(10), @Oderno varchar(10),@workerno varchar(10),@Customertime datetimeas insert into Menus values(@Menuno,@Foodtableno,@customerno,@Oderno,@workerno,@Customertime) update Foodtable set Foodtablestate=39。占39。 where Foodtableno = @Foodtablenoexec 開臺 39。M_01039。,39。TB_839。,39。C_03539。,39。O_00539。,39。W_00239。,39。201261139。插入菜單修改桌臺狀態(tài)顧客點餐drop proc 點菜create proc 點菜 @Menuno varchar(10) ,@Dishno varchar(20),@Dishname varchar(10) ,@Amount int as insert into menus_dish values(@Menuno,@Dishno,@Dishname,@Amount)點菜exec 點菜 39。M_01039。,39。D1039。,39。蒜泥黃瓜39。,2exec 點菜 39。M_01039。,39。D2339。,39。麻婆豆腐39。,1exec 點菜 39。M_01039。,39。D1139。,39。西芹杏仁39。,1exec 點菜 39。M_01039。,39。D3939。,39。樟茶鴨子39。,1exec 點菜 39。M_01039。,39。D5739。,39。小炒臘肉39。,2exec 點菜 39。M_01039。,39。D7239。,39。小炒河蝦39。,1計算總消費額drop proc 消費總額create proc 消費總額 @customerno varchar(10), @Saleroom float outputas select @Saleroom=SUM(Dishprice*Amount) from menus_dish,Dish,Menus where Customerno=@customerno and = and = 測驗 declare @Saleroom float, @customerno varchar(10) = 39。c_03539。出入顧客的編號，計算本次消費信息 exec 消費總額 @customerno , @Saleroom outputselect Customername, @Saleroom 總費用from Customerwhere Customerno = @customern查詢客戶點菜信息drop proc 查詢客戶點菜create proc 查詢客戶點菜 @customerno varchar(10)as select ,Amount from Dish,menus_dish,menus where =@customerno and = and = 測驗exec 查詢客戶點菜 39。c_03539。exec 查詢客戶點菜 39。c_00139。菜品的刪除drop proc 修改菜單create proc 修改菜單 @Menuno varchar(10), @Dishname varchar(20)as delete from menus_dish where Menuno=@Menuno and Dishname= @Dishname測驗 exec 修改菜單 39。M_01039。,39。小炒臘肉39。 發(fā)票信息drop proc 發(fā)票信息create proc 發(fā)票信息 @customerno varchar(10), @Actuallypay1 float, @Menuno varchar(10) output, @Actuallypay2 float output, @customername varchar(10) output, @Saleroom float output, @after_discount float output, @Billtime datetime outputas select @Saleroom=SUM(Dishprice*Amount)本次消費總額 from menus_dish,Dish,Menus where Customerno=@customerno and = and =
公司管理相關(guān)推薦
鄂ICP備17016276號-1