/*
 USE [We_AppDb_V2.2_Dev]; 
 DECLARE @NO NVARCHAR(50);	SET @NO='JY2001000010027';
 
 UPDATE [dbo].[Train_Camps] SET [CampState]=2,[StartDate]=NULL WHERE [Id]=@NO
 UPDATE [dbo].[Train_CampGroups] SET [CampGroupState]=1,[RunningInfo]=NULL,[StartDate]=NULL,[EngDate]=NULL,[RoundIndex]=1 WHERE [CampNo]=@NO
 UPDATE [dbo].[Train_CampGroupScores] SET [SystemScore]=0,[CorrectionScore]=0,[SpecialistScore]=0,[AudienceScore]=0,[ReferenceScore]=0,[FinalTotalScore]=0,[BehaviorTagScoreInfo]='' WHERE [CampNo]=@NO
 UPDATE  [dbo].[Train_CampGroupLogs] SET LogState=1  WHERE LogType=2 AND (LogState=2 OR LogState=3 OR LogState=4  OR LogState=5) AND [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupScores] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupLogs] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupPortraits] WHERE [CampNo]=@NO
 DELETE  [dbo].[Train_CampGroupRoles] WHERE [GroupNo] like @NO+'%'
 
 

 USE [We_AppDb_V2.2_Dev]; 
 DECLARE @NO NVARCHAR(50);	SET @NO='JY2001000010075——';

 DELETE  [dbo].[Train_CampGroupScores] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupLogs] WHERE [CampNo]=@NO 
 DELETE  [dbo].[Train_CampGroupPortraits] WHERE [CampNo]=@NO
 DELETE  [dbo].[Train_CampGroupRoles] WHERE [GroupNo] like @NO+'%'
 --DELETE  [dbo].[Train_CampHelps] WHERE [CampNo]=@NO 
  --DELETE  [dbo].[Train_CampGroups] WHERE [CampNo]=@NO 
  --DELETE  [dbo].[Train_Camps] WHERE [Id]=@NO 

 */

/*
USE [We_AppDb_V2.2_Dev]; 
--关联学员提示信息(HD大面积停电)
DECLARE @CampNO NVARCHAR(50);	SET @CampNO='JY2001000010027';
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011001', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011002', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011003', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011004', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011005', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011006', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011007', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011008', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011009', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011010', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011011', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011012', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011013', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011014', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011015', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011016', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011017', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011018', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011019', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011020', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011021', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011022', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011023', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011024', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011025', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011026', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011027', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011028', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011029', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011030', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011031', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011032', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011033', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011034', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011035', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011036', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011037', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011038', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011039', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011040', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011041', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011042', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011043', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011044', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011045', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011046', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011047', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011048', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011049', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011050', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011051', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011052', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011053', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011054', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011055', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011056', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011057', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011058', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011059', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011060', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011061', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011062', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011063', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011064', @CampNO, N'2024-06-26', 3);
INSERT INTO [dbo].[Train_CampHelps] ([HelpNo],[CampNo],[CreationTime],[CreatorUserId]) VALUES (N'JY2012000011065', @CampNO, N'2024-06-26', 3);

*/