56 lines
3.0 KiB
Transact-SQL
56 lines
3.0 KiB
Transact-SQL
select * from SitePerson_Person where ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b'
|
|
and UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'
|
|
|
|
select * from base_project where projectname like '%ɽ¶«±õÖÝ%'
|
|
select * from Base_Unit where UnitName like '%Ê®ËÄ%'
|
|
|
|
delete from QualityAudit_PersonQuality where PersonId in
|
|
(select PersonId from SitePerson_Person
|
|
where ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b' and UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'
|
|
and IdentityCard not in (select IdentityCard from Project_ProjectUser as p
|
|
left join Sys_User as u on p.UserId=u.UserId
|
|
where p.ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b'
|
|
and p.UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'))
|
|
go
|
|
delete from EduTrain_TrainRecordDetail where PersonId in
|
|
(select PersonId from SitePerson_Person
|
|
where ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b' and UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'
|
|
and IdentityCard not in (select IdentityCard from Project_ProjectUser as p
|
|
left join Sys_User as u on p.UserId=u.UserId
|
|
where p.ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b'
|
|
and p.UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'))
|
|
go
|
|
delete from EduTrain_TrainRecord
|
|
where (select COUNT(*) from EduTrain_TrainRecordDetail where TrainingId =EduTrain_TrainRecord.TrainingId) =0
|
|
and ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b' and UnitIds like '%1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9%'
|
|
go
|
|
|
|
delete from SitePerson_Checking where PersonId in
|
|
(select PersonId from SitePerson_Person
|
|
where ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b' and UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'
|
|
and IdentityCard not in (select IdentityCard from Project_ProjectUser as p
|
|
left join Sys_User as u on p.UserId=u.UserId
|
|
where p.ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b'
|
|
and p.UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'))
|
|
go
|
|
delete from SitePerson_PersonInOut where PersonId in
|
|
(select PersonId from SitePerson_Person
|
|
where ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b' and UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'
|
|
and IdentityCard not in (select IdentityCard from Project_ProjectUser as p
|
|
left join Sys_User as u on p.UserId=u.UserId
|
|
where p.ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b'
|
|
and p.UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'))
|
|
go
|
|
delete from SitePerson_Person
|
|
where ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b' and UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'
|
|
and IdentityCard not in (select IdentityCard from Project_ProjectUser as p
|
|
left join Sys_User as u on p.UserId=u.UserId
|
|
where p.ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b'
|
|
and p.UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9')
|
|
|
|
delete from SitePerson_Person_Bak
|
|
where ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b' and UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9'
|
|
and IdentityCard not in (select IdentityCard from Project_ProjectUser as p
|
|
left join Sys_User as u on p.UserId=u.UserId
|
|
where p.ProjectId='7d4cce15-bc9b-4ed4-8b59-2edc8488528b'
|
|
and p.UnitId='1c1cc3ba-8654-4bac-b7e7-b45f4eec0dc9') |