From 1a1c8e71fcd14858f595029f089b2d4a00202b32 Mon Sep 17 00:00:00 2001
From: ogi <Administrator@S-OGI-PC>
Date: Fri, 05 Dec 2025 09:24:16 +0900
Subject: [PATCH] プロジェクトファイルを追加。

---
 Document/Sql/Import HotelPms.sql |  155 +++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 155 insertions(+), 0 deletions(-)

diff --git a/Document/Sql/Import HotelPms.sql b/Document/Sql/Import HotelPms.sql
new file mode 100644
index 0000000..a152e10
--- /dev/null
+++ b/Document/Sql/Import HotelPms.sql
@@ -0,0 +1,155 @@
+USE [HotelPms]
+GO
+
+--�����^�C�v
+INSERT INTO [dbo].[M_RoomType]
+           ([ID]
+           ,[Name]
+           ,[ShortName]
+           ,[Kind]
+           ,[SortID]
+           ,[Visible]
+           ,[TypeListVisible]
+           ,[TypeListAlertCount]
+           ,[TypeListAlertColor]
+           ,[WebType]
+           ,[SendRate]
+           ,[SendLimit]
+           ,[Memo]
+           ,[UpdateDate]
+           ,[UpdateLoginID]
+           ,[UpdatePcName]
+           ,[UpdateID])
+SELECT [RoomTypeNo]
+      ,[RoomTypeName]
+      ,[RoomTypeShortName]
+      ,case when [RoomKind] = 5 then 3 else [RoomKind] - 1 end
+      ,[RoomTypeDispNo]
+      ,[RoomTypeDispFlg]
+      ,[TypeListDispFlg]
+      ,[TypeListRemainCount]
+      ,[TypeListRemainColor]
+      ,[NetGroupCode]
+      ,[SendRate]
+      ,[SendLimit]
+      ,[Memo]
+      ,[UpdateDate]
+      ,[UpdatePerson]
+	  ,''
+	  ,0
+  FROM [BHotelHW].[dbo].[M_RoomType]
+
+
+  INSERT INTO [dbo].[M_Room]
+           ([ID]
+           ,[TypeID]
+           ,[SortID]
+           ,[Floor]
+           ,[Name]
+           ,[Capacity]
+           ,[PBXID]
+           ,[RfgID]
+           ,[PTVID]
+           ,[Visible]
+           ,[OpeFlg]
+           ,[SignID]
+           ,[GradeID]
+           ,[BuildingID]
+           ,[HallType1]
+           ,[HallType2]
+           ,[Memo]
+           ,[UpdateDate]
+           ,[UpdateLoginID]
+           ,[UpdatePcName]
+           ,[UpdateID])
+SELECT [RoomNo]
+      ,[RoomTypeNo]
+	  ,[DispSort]
+	  ,[Floor]
+      ,[RoomName]
+      ,[Capacity]
+      ,[PBXNo]
+      ,[RefrigeratorNo]
+      ,[PTVNo]
+	  ,[RoomDispFlg]
+      ,[OpeFlg]     
+      ,[SignCode]
+	  ,[GradeNo]
+	  ,[BuildingNo]
+      ,[HallType]
+      ,[HallType2]
+      ,[Memo]
+      ,[UpdateDate]
+      ,[UpdatePerson]
+      ,''
+	  ,0
+  FROM [BHotelHW].[dbo].[M_Room]
+  go
+
+
+  INSERT INTO [dbo].[M_RoomViewLayout]
+           ([TabID]
+           ,[Row]
+           ,[Col]
+           ,[RoomID]
+           ,[DisplayName]
+           ,[RowHeight]
+           ,[ColWidth]
+           ,[BackColor]
+           ,[ForeColor]
+           ,[Floor]
+           ,[FontName]
+           ,[FontSize]
+           ,[FontBold]
+           ,[FontItalic]
+           ,[FontUnderline]
+           ,[TextAlign]
+           ,[UpdateDate]
+           ,[UpdateLoginID]
+           ,[UpdatePcName]
+           ,[UpdateID])
+		   select 
+		   [TabNo]
+      ,[Row]
+      ,[Col]
+      ,[RoomNo]
+      ,[DisplayName]
+      ,[RowHeight]
+      ,[ColWidth]
+      ,[BackColor]
+      ,[ForeColor]      
+      ,[Floor]
+      ,[FontName]
+      ,[FontSize]
+      ,[FontBold]
+      ,[FontItalic]
+      ,[FontUnderline]
+      ,[TextAlign]
+      ,[UpdateDate]
+      ,[UpdatePerson]
+      ,''
+	  ,0
+  FROM [BHotelHW].[dbo].[M_GuestRoomDisplay]
+  GO
+
+  --�����A�J���}�A#�J�n
+
+  update [M_RoomViewLayout] set ForeColor = '#FFFFFF' where ForeColor='16777215'
+  update [M_RoomViewLayout] set BackColor = '#FFFFFF' where BackColor='16777215'
+
+  update [M_RoomViewLayout] set ForeColor = '#FFFF00' where ForeColor='16776960'
+  update [M_RoomViewLayout] set BackColor = '#FFFF00' where BackColor='16776960'
+
+    update [M_RoomViewLayout] set ForeColor = '#00FF00' where ForeColor='65280'
+  update [M_RoomViewLayout] set BackColor = '#00FF00' where BackColor='65280'
+
+  INSERT INTO [dbo].[M_RoomViewTab]
+           ([ID]
+           ,[Name]
+           ,[UpdateDate]
+           ,[UpdateLoginID]
+           ,[UpdatePcName]
+           ,[UpdateID])
+select TabNo,TabName,UpdateDate,UpdatePerson,'',0
+	FROM [BHotelHW].[dbo].M_GuestRoomTab
+GO
\ No newline at end of file

--
Gitblit v1.10.0