51 lines
2.6 KiB
Transact-SQL
51 lines
2.6 KiB
Transact-SQL
update SYS_MENU set IsUsed=0 where menuid='48545C6A-9D10-47F4-810F-DAB0CFCD5BF9';
|
|
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('197F9A9A-480C-4CC3-B6B7-3A7D382DC3EB','LHC System List(Process)','Transfer/LHCSystemList.aspx?Type=0',8,'0','Menu_Transfer',0,1,1)
|
|
go
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('8400F97B-5E26-4D22-BBED-1BBE533A4235','197F9A9A-480C-4CC3-B6B7-3A7D382DC3EB','Ôö¼Ó',1)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('8EB4D935-3ECD-4E4C-AABC-1DA6432C9681','197F9A9A-480C-4CC3-B6B7-3A7D382DC3EB','ÐÞ¸Ä',2)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('C201BD75-5928-4C97-BEB3-219A735A7CF3','197F9A9A-480C-4CC3-B6B7-3A7D382DC3EB','ɾ³ý',3)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('F3E56E50-929D-4B4C-A3F7-87DA87787A8F','197F9A9A-480C-4CC3-B6B7-3A7D382DC3EB','±£´æ',4)
|
|
go
|
|
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('022428DC-FC99-4916-B8AF-6A9DC885DFAF','LHC System List(Non-Process)','Transfer/LHCSystemList.aspx?Type=1',9,'0','Menu_Transfer',0,1,1)
|
|
go
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('489F3579-0ECA-4BC7-9BEA-E8D11B17816A','022428DC-FC99-4916-B8AF-6A9DC885DFAF','Ôö¼Ó',1)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('E6311F1E-1E1D-4CE8-BACB-3C51C1E94BA3','022428DC-FC99-4916-B8AF-6A9DC885DFAF','ÐÞ¸Ä',2)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('A90CE1C1-0776-4BDB-AF5D-B06D05342730','022428DC-FC99-4916-B8AF-6A9DC885DFAF','ɾ³ý',3)
|
|
insert into Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|
values('5EB9D01F-35C0-4463-A847-32ED48B9E29D','022428DC-FC99-4916-B8AF-6A9DC885DFAF','±£´æ',4)
|
|
go
|
|
|
|
CREATE TABLE [dbo].[Transfer_LHCSystemList](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[Type] [nvarchar](50) NULL,
|
|
[SN] [int] NULL,
|
|
[Commissioningsystemcode] [nvarchar](50) NULL,
|
|
[CommissioningCodeDescription] [nvarchar](50) NULL,
|
|
[SubCommissioningsystem] [nvarchar](50) NULL,
|
|
[Turnover_Code] [nvarchar](50) NULL,
|
|
[PlanStartofTestingDate] [datetime] NULL,
|
|
[PlanFinishofTestingDate] [datetime] NULL,
|
|
[Status] [nvarchar](50) NULL,
|
|
[ActualFinishedDate] [datetime] NULL,
|
|
[Describe] [nvarchar](200) NULL,
|
|
CONSTRAINT [PK_Transfer_LHCSystemList] PRIMARY KEY CLUSTERED
|
|
(
|
|
[Id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
|