USE [We_AppDb_V2.2_Dev];

DELETE FROM [dbo].[Train_CampRoleGroups] WHERE CreationTime >= '2024-06-13' AND  CreationTime <= '2024-06-20';
DELETE FROM [dbo].[Bs_TrainingGroupRelateRoles] WHERE CreationTime >= '2024-06-13' AND  CreationTime <= '2024-06-15';
DELETE FROM [dbo].[Bs_TrainingRoleGroups] WHERE CreationTime >= '2024-06-13' AND  CreationTime <= '2024-06-15';
DELETE FROM [dbo].[Bs_TrainingRoles] WHERE CreationTime >= '2024-06-13' AND  CreationTime <= '2024-06-15';


INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010111', N'总指挥', N'总指挥', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010112', N'指挥长', N'指挥长', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010113', N'党建部', N'党建部', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010114', N'安监部', N'安监部', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010115', N'调控中心', N'调控中心', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010116', N'大面积停电应急办', N'大面积停电应急办', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010117', N'大面积停电应急办主任', N'大面积停电应急办主任', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010118', N'大面积停电应急领导小组', N'大面积停电应急领导小组', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010119', N'生技部', N'生技部', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010120', N'分部领导', N'分部领导', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010121', N'电网调控组（调控中心）', N'电网调控组（调控中心）', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010122', N'生产技术组（生技部）', N'生产技术组（生技部）', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010123', N'舆情处置组（党建部）', N'舆情处置组（党建部）', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010124', N'综合协调组（安监部）', N'综合协调组（安监部）', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010125', N'相关事发单位', N'相关事发单位', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010126', N'常态化值班员', N'常态化值班员', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);

INSERT INTO [dbo].[Bs_TrainingRoleGroups] ([Id], [RoleGroupName], [Roles], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'HD大面积停电', N'JY2011000010111,JY2011000010112,JY2011000010113,JY2011000010114,JY2011000010115,JY2011000010116,JY2011000010117,JY2011000010118,JY2011000010119,JY2011000010120,JY2011000010121,JY2011000010122,JY2011000010123,JY2011000010124,JY2011000010125,JY2011000010126', N'HD大面积停电', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);

INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010111', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010112', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010113', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010114', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010115', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010116', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010117', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010118', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010119', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010120', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010121', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010122', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010123', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010124', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010125', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010101', N'JY2011000010126', '2024-06-13', 3);



INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010151', N'现场人员', N'现场人员', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010152', N'人身伤亡应急办主任', N'人身伤亡应急办主任', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010153', N'总值班室主任', N'总值班室主任', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010154', N'人身伤亡应急办', N'人身伤亡应急办', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010155', N'副总指挥', N'副总指挥', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010156', N'后勤中心', N'后勤中心', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010157', N'华甸能源', N'华甸能源', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingRoles] ([Id], [RoleName], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2011000010158', N'产业办', N'产业办', '0', NULL, NULL, NULL, NULL, '2024-06-13', 3);

INSERT INTO [dbo].[Bs_TrainingRoleGroups] ([Id], [RoleGroupName], [Roles], [Description], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'HD人身伤亡事件', N'JY1011000010111,JY1011000010112,JY1011000010113,JY1011000010114,JY1011000010119,JY1011000010120,JY2011000010151,JY2011000010152,JY2011000010153,JY2011000010154,JY2011000010155,JY2011000010156,JY2011000010157,JY2011000010158', N'人身伤亡事件', '0',NULL, NULL, NULL, NULL, '2024-06-13', 3);

INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010111', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010112', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010113', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010114', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010119', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010120', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010151', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010152', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010153', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010154', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010155', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010156', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010157', '2024-06-13', 3);
INSERT INTO [dbo].[Bs_TrainingGroupRelateRoles] ([RoleGroupNo], [TrainRoleNo], [CreationTime], [CreatorUserId]) VALUES (N'JY2012000010102', N'JY2011000010158', '2024-06-13', 3);