lpf
/
SGGL_SHJ
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
SGGL_SHJ/DataBase/菜单初始化脚本/0-2大数据中心（Menu_DigData）.sql

97 lines
6.3 KiB
MySQL
Raw Permalink Normal View History

20220905代码初始化
2022-09-05 16:36:31 +08:00
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_DigData')
--go
--delete from Sys_Menu where MenuType='Menu_DigData'
--go
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('FF0D9166-4509-4411-8039-F035BC251114','<EFBFBD><EFBFBD><EFBFBD>ݲֿ<EFBFBD>','',10,'0','Menu_DigData',1,0,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('0E9C6A47-E410-43C4-95D1-1EC1C01E9967','WBS<EFBFBD><EFBFBD><EFBFBD>ݲֿ<EFBFBD>','DigData/WBSDW.aspx',10,'FF0D9166-4509-4411-8039-F035BC251114','Menu_DigData',1,1,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('92B50285-30BD-4B62-9E23-A0D6B4BA1577','<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD>ݲֿ<EFBFBD>','',20,'FF0D9166-4509-4411-8039-F035BC251114','Menu_DigData',1,0,1)
GO
20220905代码初始化
2022-09-05 16:36:31 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('AA670914-6EAA-4CFA-8BD6-E0648F8FD21C','<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','',10,'92B50285-30BD-4B62-9E23-A0D6B4BA1577','Menu_DigData',1,0,1)
新增公司项目级项目维度数据统计
2023-09-06 16:25:07 +08:00
GO
--<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('E1ABD1B1-1563-433A-972B-555076A96D06','<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','DigData/HSEDataDW.aspx',5,'AA670914-6EAA-4CFA-8BD6-E0648F8FD21C','Menu_DigData',1,1,1)
GO
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
--<EFBFBD><EFBFBD>ȫ<EFBFBD>ճ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
20220905代码初始化
2022-09-05 16:36:31 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('04B182E4-D31E-449F-9803-322F3F380D89','HSE<EFBFBD>ճ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','DigData/DailyProblemAnalysis.aspx',10,'AA670914-6EAA-4CFA-8BD6-E0648F8FD21C','Menu_DigData',1,1,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
--<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
20220905代码初始化
2022-09-05 16:36:31 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('24939ABD-E174-4C3D-8B04-494917B7BE40','HSE<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','DigData/RectifyProblemAnalysis.aspx',20,'AA670914-6EAA-4CFA-8BD6-E0648F8FD21C','Menu_DigData',1,1,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
--<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵͳ<EFBFBD><EFBFBD>
20220905代码初始化
2022-09-05 16:36:31 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('4B2E7EE5-AC7C-4143-B5BC-60080C763A24','HSE<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵͳ<EFBFBD><EFBFBD>','DigData/TrainRecordAnalysis.aspx',30,'AA670914-6EAA-4CFA-8BD6-E0648F8FD21C','Menu_DigData',1,1,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('7EC74F30-B2F7-454E-B0AE-8E993211F763','<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','',20,'92B50285-30BD-4B62-9E23-A0D6B4BA1577','Menu_DigData',1,0,1)
新增公司项目级项目维度数据统计
2023-09-06 16:25:07 +08:00
GO
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('15D01AB6-F959-4ABD-B861-C5C2EE6FA906','<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','DigData/CQMSDataDW.aspx',10,'7EC74F30-B2F7-454E-B0AE-8E993211F763','Menu_DigData',1,1,1)
GO
20220905代码初始化
2022-09-05 16:36:31 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('E7F7BC38-7357-49C0-9242-68289031F618','<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','',30,'92B50285-30BD-4B62-9E23-A0D6B4BA1577','Menu_DigData',1,0,1)
新增公司项目级项目维度数据统计
2023-09-06 16:25:07 +08:00
GO
--<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('44D51E89-267D-4D72-AB6D-1F4CA4E7D19D','<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','DigData/JDGLDataDW.aspx',10,'E7F7BC38-7357-49C0-9242-68289031F618','Menu_DigData',1,1,1)
GO
20220905代码初始化
2022-09-05 16:36:31 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('381A4608-2CDE-42AF-BC4D-FF554785B9F8','<EFBFBD><EFBFBD>ͬ<EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','',40,'92B50285-30BD-4B62-9E23-A0D6B4BA1577','Menu_DigData',1,0,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
新增公司项目级项目维度数据统计
2023-09-06 16:25:07 +08:00
--<EFBFBD><EFBFBD>ͬ<EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('ABC4323E-2F6F-4147-AA7A-8726131D7044','<EFBFBD><EFBFBD>ͬ<EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','DigData/HTGLDataDW.aspx',10,'381A4608-2CDE-42AF-BC4D-FF554785B9F8','Menu_DigData',1,1,1)
GO
20230907
2023-09-07 21:54:58 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('A20E2443-A118-4C67-9084-FFEB685CA539','<EFBFBD>嵥<EFBFBD><EFBFBD>Ŀʹ<EFBFBD><EFBFBD><EFBFBD>ʼ<EFBFBD><EFBFBD>۸<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͼ','',20,'381A4608-2CDE-42AF-BC4D-FF554785B9F8','Menu_DigData',1,1,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('6D1F3A3F-EFD1-420A-87E7-8CFAEF971165','<EFBFBD>չ<EFBFBD>Чͳ<EFBFBD><EFBFBD>','',30,'381A4608-2CDE-42AF-BC4D-FF554785B9F8','Menu_DigData',1,1,1)
GO
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('5BE7F83B-C02D-4481-815F-153279B44C39','<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݿ<EFBFBD>','',50,'92B50285-30BD-4B62-9E23-A0D6B4BA1577','Menu_DigData',1,0,1)
--GO
20220905代码初始化
2022-09-05 16:36:31 +08:00
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('B87413D8-4EFB-42F3-A4F6-9D21C0CD3DFE','<EFBFBD><EFBFBD><EFBFBD>ݷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','',50,'0','Menu_DigData',1,0,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230907
2023-09-07 21:54:58 +08:00
VALUES('CFEF47C0-8EFA-46FF-8648-5B1922519DCC','WBS<EFBFBD><EFBFBD><EFBFBD>ݷ<EFBFBD><EFBFBD><EFBFBD>','DigData/WBSAnalysis.aspx',10,'B87413D8-4EFB-42F3-A4F6-9D21C0CD3DFE','Menu_DigData',1,1,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
20230824 新增大数据中心wbs数据页面等
2023-08-24 09:30:51 +08:00
VALUES('B146FC96-B199-426B-8504-4BE093C0DCB1','<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD>ݻ<EFBFBD><EFBFBD>ܷ<EFBFBD><EFBFBD><EFBFBD>','',20,'B87413D8-4EFB-42F3-A4F6-9D21C0CD3DFE','Menu_DigData',1,0,1)
20220905代码初始化
2022-09-05 16:36:31 +08:00
GO
20230907
2023-09-07 21:54:58 +08:00
--<EFBFBD><EFBFBD>ĿHSE<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('427AB060-2510-4568-B85B-AD6796EBE569','<EFBFBD><EFBFBD>ĿHSE<EFBFBD><EFBFBD><EFBFBD>ݻ<EFBFBD><EFBFBD><EFBFBD>','DigData/HSEDataCollect.aspx',10,'B146FC96-B199-426B-8504-4BE093C0DCB1','Menu_DigData',1,1,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('DD960B76-1F33-468B-9FEF-76328235C079','<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݻ<EFBFBD><EFBFBD><EFBFBD>','',20,'B146FC96-B199-426B-8504-4BE093C0DCB1','Menu_DigData',1,1,1)
GO
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('A705738B-D0A2-41D2-A01A-18774B5AED49','<EFBFBD><EFBFBD>Ŀʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݻ<EFBFBD><EFBFBD><EFBFBD>','',30,'B146FC96-B199-426B-8504-4BE093C0DCB1','Menu_DigData',1,1,1)
GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('AF5C32FD-F0CB-404E-B56D-C4AE79A8A050','<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>Ч<EFBFBD><EFBFBD><EFBFBD><EFBFBD>','',10,'B87413D8-4EFB-42F3-A4F6-9D21C0CD3DFE','Menu_DigData',1,1,1)
--GO
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
--VALUES('0DB6BB5F-B17A-4A38-AABB-278300EA9E39','Ա<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>','',20,'B87413D8-4EFB-42F3-A4F6-9D21C0CD3DFE','Menu_DigData',1,1,1)
--GO