USE [MyHotel]
GO
/****** 对象: View [dbo].[客房入住报表视图] 脚本日期: 02/16/2007 13:19:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[客房入住报表视图]
AS
SELECT dbo.客房入住单.入住编号, dbo.客房入住单.房号, dbo.酒店房间.类别,
dbo.客房入住单.客人姓名, dbo.客房入住单.客人性别, dbo.客房入住单.住宿人数,
dbo.客房入住单.入住日期, dbo.客房入住单.离开日期, dbo.客房入住单.预收押金,
dbo.客房入住单.折扣价格, dbo.客房入住单.证件名称, dbo.客房入住单.证件号码,
dbo.客房入住单.证件地址, dbo.客房入住单.联系电话, dbo.客房入住单.操作人员,
dbo.客房入住单.说明
FROM dbo.客房入住单 INNER JOIN
dbo.酒店房间 ON dbo.客房入住单.房号 = dbo.酒店房间.房号
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
Begin PaneConfigurations =
Begin PaneConfiguration = 0
NumPanes = 4
Configuration = "(H (1[40] 4[20] 2[20] 3) )"
End
Begin PaneConfiguration = 1
NumPanes = 3
Configuration = "(H (1 [50] 4 [25] 3))"
End
Begin PaneConfiguration = 2
NumPanes = 3
Configuration = "(H (1 [50] 2 [25] 3))"
End
Begin PaneConfiguration = 3
NumPanes = 3
Configuration = "(H (4 [30] 2 [40] 3))"
End
Begin PaneConfiguration = 4
NumPanes = 2
Configuration = "(H (1 [56] 3))"
End
Begin PaneConfiguration = 5
NumPanes = 2
Configuration = "(H (2 [66] 3))"
End
Begin PaneConfiguration = 6
NumPanes = 2
Configuration = "(H (4 [50] 3))"
End
Begin PaneConfiguration = 7
NumPanes = 1
Configuration = "(V (3))"
End
Begin PaneConfiguration = 8
NumPanes = 3
Configuration = "(H (1[56] 4[18] 2) )"
End
Begin PaneConfiguration = 9
NumPanes = 2
Configuration = "(H (1 [75] 4))"
End
Begin PaneConfiguration = 10
NumPanes = 2
Configuration = "(H (1[66] 2) )"
End
Begin PaneConfiguration = 11
NumPanes = 2
Configuration = "(H (4 [60] 2))"
End
Begin PaneConfiguration = 12
NumPanes = 1
Configuration = "(H (1) )"
End
Begin PaneConfiguration = 13
NumPanes = 1
Configuration = "(V (4))"
End
Begin PaneConfiguration = 14
NumPanes = 1
Configuration = "(V (2))"
End
ActivePaneConfig = 0
End
Begin DiagramPane =
Begin Origin =
Top = 0
Left = 0
End
Begin Tables =
Begin Table = "客房入住单"
Begin Extent =
Top = 6
Left = 38
Bottom = 243
Right = 173
End
DisplayFlags = 280
TopColumn = 2
End
Begin Table = "酒店房间"
Begin Extent =
Top = 6
Left = 211
Bottom = 116
Right = 352
End
DisplayFlags = 280
TopColumn = 0
End
End
End
Begin SQLPane =
End
Begin DataPane =
Begin ParameterDefaults = ""
End
End
Begin CriteriaPane =
Begin ColumnWidths = 11
Column = 1440
Alias = 900
Table = 1170
Output = 720
Append = 1400
NewValue = 1170
SortType = 1350
SortOrder = 1410
GroupBy = 1350
Filter = 1350
Or = 1350
Or = 1350
Or = 1350
End
End
End
' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'客房入住报表视图'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'VIEW', @level1name=N'客房入住报表视图'
VB SQL 酒店管理系统 数据库(Database)
需积分: 13 64 浏览量
2012-12-07
20:39:23
上传
评论 2
收藏 608KB ZIP 举报
酒店管理系统设计与实现之Database.zip （19个子文件） 
酒店管理系统设计与实现之Database 
MyHotel.mdf 2.5MB 餐费入帐数据表.sql 2KB 消费品分类查询视图.sql 7KB 客房预约单数据表.sql 3KB 操作用户数据表.sql 5KB 店内消费报表视图.sql 7KB 消费物品数据表.sql 1KB 酒店信息数据表.sql 2KB 结帐汇总报表视图.sql 7KB 旅客餐费报表视图.sql 7KB MyHotel数据库.sql 4KB 消费入帐数据表.sql 2KB 客房结帐单数据表.sql 2KB MyHotel_log.ldf 2MB 客房入住报表视图.sql 8KB 客房入住单数据表.sql 2KB 话费入帐数据表.sql 2KB 酒店房间数据表.sql 1KB 旅客话费报表视图.sql 7KB资源评论
