--添加菜单  时间：20210707
INSERT [dbo].[sys_menu] ([Id], [Pid], [Pids], [Name], [Code], [Type], [Icon], [Router], [Component], [Permission], [Application], [OpenType], [Visible], [Link], [Redirect], [Weight], [Sort], [Remark], [Status], [CreatedTime], [UpdatedTime], [CreatedUserId], [CreatedUserName], [UpdatedUserId], [UpdatedUserName], [IsDeleted]) VALUES (178075287240773, 0, N'[0],', N'大屏监控', N'main_screen_monitor', 1, N'pie-chart', N'/monitor', N'main/screenMonitor/index', N'', N'busiapp', 0, N'Y', NULL, N'', 2, 100, NULL, 0, CAST(N'2021-07-07T14:50:13.943' AS DateTime), CAST(N'2021-07-07T14:54:25.190' AS DateTime), 142307070910551, N'superAdmin', NULL, NULL, 0)
GO
INSERT [dbo].[sys_menu] ([Id], [Pid], [Pids], [Name], [Code], [Type], [Icon], [Router], [Component], [Permission], [Application], [OpenType], [Visible], [Link], [Redirect], [Weight], [Sort], [Remark], [Status], [CreatedTime], [UpdatedTime], [CreatedUserId], [CreatedUserName], [UpdatedUserId], [UpdatedUserName], [IsDeleted]) VALUES (178079567294533, 0, N'[0],', N'地理信息', N'main_map', 1, N'environment', N'/map', N'main/map/index', N'', N'busiapp', 0, N'Y', NULL, N'', 2, 100, NULL, 0, CAST(N'2021-07-07T15:07:38.880' AS DateTime), NULL, 142307070910551, N'superAdmin', NULL, NULL, 0)
GO



--修改系统配置code前缀  时间：20210712
update [dbo].[sys_config] set code=REPLACE(Code ,'DILON_','')