通用酒店客房管理系統(tǒng)數(shù)據(jù)庫設(shè)計說明書-資料下載頁
2024-12-15 18:19本頁面
【導(dǎo)讀】通用酒店客房管理系統(tǒng)。本說明書是在《酒店客房管理系統(tǒng)需求規(guī)格說明書》的基礎(chǔ)上，對系統(tǒng)。的概念結(jié)構(gòu)模型進行分析，進而進行數(shù)據(jù)庫設(shè)計，為建立數(shù)據(jù)庫提供依據(jù)。同時，本說明書也是項目完成后驗收的重要依據(jù)。酒店行業(yè)的激烈競爭使得爭取客源、提高酒店入住率、制定正確營銷策。略已經(jīng)成為一項重要的任務(wù)，而借助于當(dāng)前蓬勃發(fā)展的IT工具來拓展銷售。能力，創(chuàng)造客觀的經(jīng)濟效益已經(jīng)成為許多酒店的首選。作為一種有效的統(tǒng)計。分析手段，計算機管理系統(tǒng)發(fā)揮其強大的優(yōu)勢，在數(shù)據(jù)保存、數(shù)據(jù)交換方面。的快速可靠，是手工操作所不能完成的。酒店的管理效率，減免手工處理的繁瑣與誤差，及時、準(zhǔn)確地反映酒店的工。作情況、經(jīng)營情況，從而提高酒店的服務(wù)質(zhì)量，獲得更好的經(jīng)濟效益；實現(xiàn)。軟件工程導(dǎo)論（第4版）張海藩清華大學(xué)出版社。SQLServer2021教程龔波等北京希望電子出版社。實用軟件工程鄭人杰、殷人昆等清華大學(xué)出版社。入住客房信息產(chǎn)生。ReserveRoomInfo預(yù)訂客房信息表。RoomPrice客房單價decimal精度為10，小數(shù)位數(shù)為2
【正文】 decimal(10,2) SELECT @other=0 聲明游標(biāo) declare mycur2 cursor for select TotalAccount from V_CommodityConsume where RegisterNo=@RegisterNo open mycur2 fetch next from mycur2 into @modity WHILE (@@FETCH_STATUS=0) BEGIN SELECT @other=@other+@modity fetch next from mycur2 into @modity END close mycur2 deallocate mycur2 減去已退單的商品消費 declare @alter decimal(10,2) 聲明游標(biāo) declare mycur3 cursor for select TotalAccount from V_AlterBill where RegisterNo=@RegisterNo open mycur3 fetch next from mycur3 into @alter WHILE (@@FETCH_STATUS=0) BEGIN SELECT @other=@other+@alter fetch next from mycur3 into @alter END close mycur3 deallocate mycur3 update PayBill set OtherIne=@other where RegisterNo=@RegisterNo 計算 消費總金額 update PayBill set TotalAccount=@room+@other where RegisterNo=@RegisterNo 查詢預(yù)付金額 declare @prepayment decimal(10,2) SELECT @prepayment=Prepayment FROM RegisterInfo WHERE RegisterNo=@RegisterNo update PayBill set Prepayment=isnull(@prepayment,0) where RegisterNo=@RegisterNo 計算應(yīng)付金額 update PayBill set Account=TotalAccountPrepayment where RegisterNo=@RegisterNo COMMIT GO 統(tǒng)計日營業(yè)狀況 （ P_DayStatistics）： CREATE procedure P_DayStatistics AS BEGIN TRAN declare @date datetime declare mycur cursor for select str(YEAR(PayTime),4)+39。39。+str(MONTH(PayTime),2)+39。39。+str(DAY(PayTime),2) from V_PayBill where IsPaid=39。是 39。 open mycur fetch next from mycur into @date WHILE (@@FETCH_STATUS=0) BEGIN IF NOT EXISTS(SELECT * FROM DayBusiness WHERE Date=@date) insert into DayBusiness(Date) values(@date) 根據(jù)指定日期統(tǒng)計日營業(yè)額（已結(jié)帳的） declare @guestamount int,@roomine decimal(10,2),@otherine decimal(10,2),@day decimal(10,2) SELECT @guestamount=SUM(GuestAmount),@roomine=SUM(RoomIne),@otherine=SUM(OtherIne),@day=SUM(TotalAccount) FROM V_PayBill WHERE IsPaid=39。是 39。 and PayTime between @date and DATEADD(dd,1,@date) update DayBusiness set GuestAmount=@guestamount,RoomIne=@roomine,OtherIne=@otherincome,DayIne=@day where Date=@date fetch next from mycur into @date END close mycur deallocate mycur COMMIT GO 保存客史資料 （ P_GuestHistoryInfo）： CREATE procedure P_GuestHistoryInfo @RegisterNo varchar(10),@Name varchar(20),@ArriveTime datetime AS BEGIN TRAN declare @identityno varchar(20) SELECT @identityno=IdentityNo FROM GuestInfo WHERE RegisterNo=@RegisterNo and Name=@Name 若登記資料時沒填身份證號 IF @identityno=null BEGIN insert into GuestHistoryInfo select Name,Sex,Nationality,IdentityNo,WorkPlace,Phone,Address,@ArriveTime,getdate(),Remark from GuestInfo where RegisterNo=@RegisterNo and Name=@Name END ELSE BEGIN 若存在該賓客的歷史資料 ,則更新記錄 IF EXISTS(SELECT * FROM GuestHistoryInfo WHERE IdentityNo=@identityno) BEGIN update GuestHistoryInfo set RecentArriveTime=@ArriveTime,RecentLeaveTime=getdate() where IdentityNo=@identityno END ELSE 若不存在該賓客的歷史資料 ,則插入該賓客的信息 insert into GuestHistoryInfo select Name,Sex,Nationality,IdentityNo,WorkPlace,Phone,Address,@ArriveTime,getdate(),Remark from GuestInfo where RegisterNo=@RegisterNo and Name=@Name END COMMIT GO
試題試卷相關(guān)推薦
鄂ICP備17016276號-1