if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_帐单明细_入住单]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[帐单明细] DROP CONSTRAINT FK_帐单明细_入住单
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_入住单_客房信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[入住单] DROP CONSTRAINT FK_入住单_客房信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_客房信息_客房类型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[客房信息] DROP CONSTRAINT FK_客房信息_客房类型
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_入住单_客房类型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[入住单] DROP CONSTRAINT FK_入住单_客房类型
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_入住单历史_客房类型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[入住单历史] DROP CONSTRAINT FK_入住单历史_客房类型
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_预定单_客房类型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[预定单] DROP CONSTRAINT FK_预定单_客房类型
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_预定单历史_客房类型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[预定单历史] DROP CONSTRAINT FK_预定单历史_客房类型
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_客房信息_楼层信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[客房信息] DROP CONSTRAINT FK_客房信息_楼层信息
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v_客房信息]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[v_客房信息]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AROrder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AROrder]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ARRoomPrice]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ARRoomPrice]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ARType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ARType]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ChangeRoom]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ChangeRoom]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DayBill]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DayBill]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DayBillDesc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DayBillDesc]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FeeCode]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FeeCode]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FeeType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[FeeType]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GARFee]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GARFee]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GOrder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GOrder]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GResRoom]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GResRoom]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GType]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetGlean]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GetGlean]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Glean]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Glean]
GO
if exists (select * from dbo.sysobjects where id = objec�
没有合适的资源?快使用搜索试试~ 我知道了~
基于Delphi开发的酒店管理系统
共93个文件
bmp:19个
dfm:10个
dcu:10个
3星 · 超过75%的资源 需积分: 10 18 下载量 36 浏览量
2010-05-11
13:47:59
上传
评论
收藏 893KB RAR 举报
温馨提示
这是基于Delphi开发的酒店管理系统,可以实现酒店的预定,空房查询,结账等诸多完备功能
资源推荐
资源详情
资源评论
收起资源包目录
jiudianguanlixitong.rar (93个子文件)
Chap06
icon
房态之住房.bmp 2KB
计算.bmp 246B
新增.bmp 246B
删除.bmp 246B
下记录.bmp 246B
尾记录.bmp 246B
房态之自用房.bmp 2KB
hotel.ico 1KB
上记录.bmp 246B
关闭.bmp 246B
取消.bmp 246B
房态之空房.bmp 2KB
搜索.bmp 246B
保存.bmp 246B
查询选择.bmp 246B
房态之将离.bmp 2KB
首记录.bmp 246B
房态之将到.bmp 2KB
修改.bmp 246B
房态之维修房.bmp 2KB
代码
RoomStatusForm.~ddp 51B
ParentForm.~dfm 44KB
hotel.res 1KB
RoomStatus.dfm 145KB
hotel.cfg 434B
MainForm.dcu 7KB
MainForm.~dfm 4KB
ParentForm.pas 7KB
ReservationForm.pas 9KB
Unit1.dcu 4KB
MainForm.~pas 4KB
ResideForm.dfm 19KB
ResideForm.~dfm 17KB
RoomStatusForm.dcu 13KB
ResideForm.pas 11KB
MainForm.pas 4KB
Project1.exe 443KB
RoomTypeForm.dcu 5KB
DebtForm.~ddp 51B
MainForm.dfm 4KB
RoomStatusForm.ddp 51B
MainForm.ddp 51B
ParentForm.ddp 51B
ResideForm.ddp 51B
RoomTypeForm.~pas 1KB
RoomInfoForm.~pas 5KB
RoomInfoForm.~ddp 51B
ReservationForm.ddp 51B
RoomStatusForm.pas 9KB
ParentForm.dcu 10KB
hotel.dpr 619B
DebtForm.pas 3KB
RoomTypeForm.ddp 51B
RoomTypeForm.pas 1KB
ParentForm.~pas 7KB
RoomInfoForm.ddp 51B
ReservationForm.dfm 15KB
DebtForm.dcu 7KB
ParentForm.dfm 44KB
RoomTypeForm.dfm 3KB
DebtForm.dfm 5KB
CheckOutForm.ddp 51B
ReservationForm.~dfm 13KB
RoomStatusForm.dfm 146KB
RoomTypeForm.~ddp 51B
RoomStatusForm.~dfm 146KB
RoomStatusForm.~pas 9KB
CheckOutForm.pas 2KB
hotel.exe 1020KB
DebtForm.~pas 3KB
RoomInfoForm.dfm 6KB
ResideForm.~pas 11KB
ResideForm.dcu 16KB
DebtForm.~dfm 5KB
ParentForm.~ddp 51B
RoomInfoForm.dcu 9KB
MainForm.~ddp 51B
ResideForm.~ddp 51B
ReservationForm.~pas 9KB
RoomInfoForm.~dfm 5KB
RoomTypeForm.~dfm 2KB
RoomInfoForm.pas 5KB
CheckOutForm.dfm 6KB
DebtForm.ddp 51B
ReservationForm.dcu 15KB
hotel.dof 3KB
CheckOutForm.dcu 7KB
ReservationForm.~ddp 51B
建库脚本
hotelbook.bak 1.27MB
酒店管理系统.sql 83KB
酒店管理系统实例程序.sql 23KB
hotelbook_Data.MDF 1.44MB
hotelbook_Log.LDF 1.25MB
共 93 条
- 1
资源评论
- starye92014-06-03这个程序不错的
fcl7632
- 粉丝: 56
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功