宾馆酒店管理系统

USE [MyHotelDB] GO /****** 对象: View [dbo].[客房入住报表视图] 脚本日期: 05/05/2007 12:09:00 ******/ 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 = 116 Right = 173 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "酒店房间" Begin Extent = Top = 6 Left = 211 Bottom = 116 Right = 346 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'客房入住报表视图'