dbo.RMB_ZHelperPersonOrg

1   create   procedure RMB_ZHelperPersonOrg (@SlotNumber int ) AS begin declare @Sourcedata QBM_YDataForDelta , @CountDeltaQantity int , @CountDeltaOrigin
2 int declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select
3 UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount
4 = 0 begin goto EndLabel end  insert into @SourceData( IsUpcommingContent, XOriginAfter , Element, AssignedElement, XOriginBefore ) select 0, 0 , hpo.uid_person
5, hpo.uid_Org, 1 from @DBQueueCurrent x join HelperPersonOrg hpo on hpo.UID_Person = x.uid_parameter  join BaseTree b on hpo.uid_org = b.uid_org where 
6b.uid_OrgRoot like '____[^V]%' if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\Person\FromOrg') > ' ' begin insert into @SourceData( IsUpcommingContent
7, XOriginBefore, XOriginAfter , Element, AssignedElement ) select 1, 0, 1 , p.uid_person, p.uid_org from person p join @DBQueueCurrent x on uid_person=
8 x.uid_parameter where p.uid_org > ' ' end exec QBM_PDBQueueCalculateDelta @SourceData, @DeltaQuantity = 0, @DeltaDelete = 1, @DeltaInsert = 1, @DeltaOrigin
9 = 0, @CountDeltaQantity = @CountDeltaQantity output , @CountDeltaOrigin = @CountDeltaOrigin output , @UseIsInEffect = 0 , @SlotNumber = @SlotNumber , 
10@DBQueueCurrentExtern = @DBQueueCurrent if @CountDeltaQantity > 0 begin exec QBM_PMNTableDelete 'HelperPersonOrg', 'UID_Person', 'UID_Org' exec QBM_PMNTableInsert
11 'HelperPersonOrg', 'UID_Person', 'UID_Org' end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel:
12 return end 
13