酒店管理系統(tǒng)數(shù)據(jù)庫課程設(shè)計(編輯修改稿)
2025-05-06 08:04 本頁面
【文章內(nèi)容簡介】 ype_id 證件號類型,cust_name 姓名,sex 性別,phone 聯(lián)系電話from customer運行exec pro_insert_cust 39。36020319930727401839。,39。139。,39。李昂39。,39。139。,39。1829611581539。輸入訂單信息（訂單編號，客人證件號，入住日期，預(yù)計離開日期）create procedure pro_insert_order @order_id char(10),@cust_id char(20),@enter_date datetime, @plan_leave_date datetime asinsert into order_log(order_id,cust_id,enter_date,plan_leave_date) values(@order_id,@cust_id,@enter_date,@plan_leave_date)。select order_id 訂單編號,cust_id 客人證件號,plan_enter_date 預(yù)計入住日期,enter_date 入住日期,plan_leave_date 預(yù)計離開日期,leave_date 結(jié)賬離開日期,order_money 應(yīng)付金額 from order_log運行exec pro_insert_order 39。0339。,39。36020319930727401839。,39。20137139。,39。201371039。輸入開房信息(訂單號,房號)create procedure pro_insert_book_room @order_id char(10),@room_id char(10) asinsert into book_room values(@order_id,@room_id)。select order_id 訂單編號,room_id 房號 from book_roomwhere order_id=@order_id運行exec pro_insert_book_room 39。0339。,39。10139。（2）退房結(jié)賬輸入房號把房間狀態(tài)改成空閑create procedure pro_change_rstate_into_free @room_id char(10) asupdate roomset rstate=39。空閑39。where room_id=@room_id。select room_id 房號,rstate 房狀態(tài) from room where room_id=@room_id運行exec pro_change_rstate_into_free 39。10139。退房結(jié)賬時輸入訂單號，輸出應(yīng)結(jié)賬金額并自動把訂單中的“結(jié)賬離開日期”改為當(dāng)前日期create procedure pro_quit_getmoney @order_id char(10) as begin declare @enter_date datetime,@order_money int,@sum int declare getCur cursor for select enter_date,order_money from order_log where order_id=@order_id。 open getCur fetch getCur into @enter_date,@order_money begin update order_log set leave_date=getdate() where order_id=@order_id。 select @sum=(day(getdate())day(@enter_date))*@order_money。 endclose getCurdeallocate getCurend運行exec pro_quit_getmoney 39。0139。（3）房狀態(tài)查看輸入房號查詢房信息create procedure pro_room_info @room_id char(10) asselect room_id 房號,rtype_id 房類型號,rprice 價格,rdeposit 押金,rstate 房狀態(tài) from roomwhere room_id=@room_id運行exec pro_room_info 39。10139。 預(yù)訂管理功能設(shè)計（1）預(yù)定房間輸入房號查詢房狀態(tài)create procedure pro_rstate 12@room_id char(10) asselect room_id 房號,rstate 房狀態(tài) from roomwhere room_id=@room_id運行exec pro_rstate 39。10139。輸入房號把房間狀態(tài)改成預(yù)訂create procedure pro_change_rstate_into_subscribe @room_id char(10) asupdate roomset rstate=39。預(yù)訂39。where room_id=@room_id。select room_id 房號,rstate 房狀態(tài) from roomwhere room_id=@room_id運行exec pro_change_rstate_into_subscribe 101輸入顧客信息（證件號碼，證件類型號，姓名，性別，聯(lián)系電話）create procedure pro_insert_cust12 @cust_id char(20),@ptype_id char(10),@cust_name char(10), @sex char(1),@phone char(10) asinsert into customer values(@cust_id,@ptype_id,@cust_name,@sex,@phone)。select cust_id 證件號碼,ptype_id 證件號類型,cust_name 姓名,sex 性別,phone 聯(lián)系電話from customer運行exec pro_insert_cust 39。36020320130727401839。,39。0139。,39。王小39。,39。139。,39。1234567890039。輸入訂單信息（訂單編號，客人證件號，預(yù)計入住日期）進行預(yù)訂create procedure pro_subscribe @order_id char(10),@cust_id char(20),@plan_enter_date datetime asinsert into order_log(order_id,cust_id,plan_enter_date) values(@order_id,@cust_id,@plan_enter_date)。select order_id 訂單編號,cust_id 客人證件號,plan_enter_date 預(yù)計入住日期,enter_date 入住日期, plan_leave_date 預(yù)計離開日期,leave_date 結(jié)賬離開日期,order_money
公司管理相關(guān)推薦
鄂ICP備17016276號-1