酒店管理系統(tǒng)數(shù)據(jù)庫課程設計-文庫吧資料
2025-04-15 08:04本頁面
【正文】 ave_date=plan_leave_date,enter_date=enter_date,order_money=order_moneywhere order_id=order_idselect order_id 訂單編號,cust_id 客人證件號,plan_enter_date 預計入住日期,enter_date 入住日期,plan_leave_date 預計離開日期,leave_date 結(jié)賬離開日期,order_money 應付金額 from order_logwhere order_id=order_id運行exec pro_subscribe_to_live 39。 運行exec pro_subscribe_to_enter 101輸入房號把房間狀態(tài)改成入住create procedure pro_change_rstate_into_live1 room_id char(10) asupdate room set rstate=39。elseprint39。（2）預定入住輸入訂單編號,查詢此訂單的信息(看是否為已預訂)create procedure pro_subscribe_to_enter order_id char(10) asif exists(select* from order_log where order_id=order_id)print39。,39。select order_id 訂單編號,room_id 房號 from book_roomwhere order_id=order_id運行exec pro_insert_book_room 39。201362939。36020320130727401839。0239。select order_id 訂單編號,cust_id 客人證件號,plan_enter_date 預計入住日期,enter_date 入住日期, plan_leave_date 預計離開日期,leave_date 結(jié)賬離開日期,order_money 應付金額 from order_logwhere order_id=order_id。1234567890039。139。王小39。0139。36020320130727401839。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)。預訂39。10139。10139。0139。 select sum=(day(getdate())day(enter_date))*order_money。退房結(jié)賬時輸入訂單號，輸出應結(jié)賬金額并自動把訂單中的“結(jié)賬離開日期”改為當前日期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。select room_id 房號,rstate 房狀態(tài) from room where room_id=room_id運行exec pro_change_rstate_into_free 39?？臻e39。10139。0339。輸入開房信息(訂單號,房號)create procedure pro_insert_book_room order_id char(10),room_id char(10) asinsert into book_room values(order_id,room_id)。,39。,39。,39。select order_id 訂單編號,cust_id 客人證件號,plan_enter_date 預計入住日期,enter_date 入住日期,plan_leave_date 預計離開日期,leave_date 結(jié)賬離開日期,order_money 應付金額 from order_log運行exec pro_insert_order 39。1829611581539。139。李昂39。139。36020319930727401839。where room_id=room_idselect room_id 房號,rstate 房狀態(tài) from room where room_id=room_id運行exec pro_change_rstate_into_live 101輸入顧客信息（證件號碼，證件類型號，姓名，性別，聯(lián)系電話）create procedure pro_insert_cust 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)。運行exec pro_rstate1 空閑輸入房號把房間狀態(tài)改成入住create procedure pro_change_rstate_into_live room_id char(10) asupdate roomset rstate=39。創(chuàng)建訂房表：create table book_room(order_id char(10),room_id char(10),foreign key(order_id) references order_log(order_id),foreign key(room_id) references room(room_id) )。創(chuàng)建客人信息表：create table customer(cust_id char(20) primary key,ptype_id char(10),cust_name char(10),sex char(1),phone char(10),foreign key(ptype_id)references paper_type(ptype_id))。創(chuàng)建房間信息表：create table room(room_id char(10) primary key,rtype_id char(10),rprice int,rdeposit int,rstate cha
公司管理相關(guān)推薦
鄂ICP備17016276號-1