Òä·çµÄ²©¿Í

--select top 1 * from Zz_zkhjhqd
--select * from AccountBase
begin TRANSACTION
begin try
declare @xiayou uniqueidentifier
declare @shangyou uniqueidentifier
declare @xiayoun nvarchar(100)
declare @shangyoun nvarchar(100)
declare @own uniqueidentifier
declare @ownunit uniqueidentifier
select @xiayou=b.zz_accountid,@shangyou=b.Zz_accountid1,@own=a.OwningUser,@ownunit=a.OwningBusinessUnit from Zz_zjxndxyBase a
join Zz_zjxndxyExtensionBase b on a.Zz_zjxndxyId=b.Zz_zjxndxyId
where a.Zz_zjxndxyId='05b18390-5ddd-de11-935f-001018261d7e'

if(not exists(select a.Zz_zkhjhqdId from Zz_zkhjhqdBase a join Zz_zkhjhqdExtensionBase b on a.Zz_zkhjhqdId=b.Zz_zkhjhqdId where Zz_accountid1=@xiayou and zz_accountid2=@shangyou and OwningUser=@own and a.DeletionStateCode=0))
begin
 print 'ûÓÐ'
 declare @id uniqueidentifier
 select @id=NEWID()
 select @xiayoun=Name from AccountBase where AccountId=@xiayou
 select @shangyoun=Name from AccountBase where AccountId=@shangyou

 INSERT INTO [KYGF_MSCRM].[dbo].[Zz_zkhjhqdBase]
      ([Zz_zkhjhqdId]
      ,[CreatedOn]
      ,[CreatedBy]
      ,[ModifiedOn]
      ,[ModifiedBy]
      ,[OwningUser]
      ,[OwningBusinessUnit]
      ,[statecode]
      ,[statuscode]
      ,[DeletionStateCode]
      ,[ImportSequenceNumber]
      ,[OverriddenCreatedOn]
      ,[TimeZoneRuleVersionNumber]
      ,[UTCConversionTimeZoneCode])

 select @id,[CreatedOn]
      ,[CreatedBy]
      ,[ModifiedOn]
      ,[ModifiedBy]
      ,[OwningUser]
      ,[OwningBusinessUnit]
      ,0 as [statecode]
      ,1 as [statuscode]
      ,[DeletionStateCode]
      ,[ImportSequenceNumber]
      ,[OverriddenCreatedOn]
      ,[TimeZoneRuleVersionNumber]
      ,[UTCConversionTimeZoneCode]
 from Zz_zjxndxyBase where Zz_zjxndxyId='05b18390-5ddd-de11-935f-001018261d7e'

 INSERT INTO [KYGF_MSCRM].[dbo].[Zz_zkhjhqdExtensionBase]
      ([Zz_zkhjhqdId]
      ,[Zz_name]
      ,[Zz_accountid1]
      ,[zz_accountid2])
   VALUES(@id,@xiayoun+' FROM'+@shangyoun,@xiayou,@shangyou)
     
 update AccountExtensionBase set zz_sfsyej=1 where AccountId=@xiayou
end
--select @xiayoun,@shangyoun
COMMIT TRANSACTION
end try
begin catch
ROLLBACK TRANSACTION
print 'error'
SELECT
        ERROR_NUMBER() AS ErrorNumber,
        ERROR_MESSAGE() AS ErrorMessage;
end catch