升级到管家婆7.1客户管理关联交易记录丢失脚本]

crm8

declare @TempInterId varchar(30)
declare @TempSalesRegId varchar(30)
declare @TempSalesRegCreatorId varchar(30)
declare @TempSalesRegCreatorDate datetime
declare tb cursor local  STATIC
for
select TypeID,BuyerTypeID,CreatorTypeID,CreateDate from CRM_SalesRegister

open tb
fetch tb into @TempSalesRegId,@TempInterId,@TempSalesRegCreatorId,@TempSalesRegCreatorDate
while @@fetch_status = 0
begin
         
     if not exists(select ID from CRM_CoObject where ObjectA='SalesRegister' and ObjectB='Interunit' and  [email=ObjectATypeID=@TempSalesRegId]ObjectATypeID=@TempSalesRegId[/email] and [email=ObjectBTypeID=@TempInterId]ObjectBTypeID=@TempInterId[/email])
     begin
   
         INSERT INTO CRM_CoObject (CreateDate,ModifyDate,CreatorTypeID,ObjectA,ObjectATypeID,ObjectB,ObjectBTypeID,Relation,[Description],ClickCount)
       VALUES (@TempSalesRegCreatorDate,@TempSalesRegCreatorDate,@TempSalesRegCreatorId,'SalesRegister',@TempSalesRegId,'Interunit',@TempInterId,0,'',0)
  INSERT INTO CRM_CoObject (CreateDate,ModifyDate,CreatorTypeID,ObjectA,ObjectATypeID,ObjectB,ObjectBTypeID,Relation,[Description],ClickCount)
      VALUES (@TempSalesRegCreatorDate,@TempSalesRegCreatorDate,@TempSalesRegCreatorId,'Interunit',@TempInterId,'SalesRegister',@TempSalesRegId,0,'',0)
     end

       fetch tb into @TempSalesRegId,@TempInterId,@TempSalesRegCreatorId,@TempSalesRegCreatorDate
end
close tb
deallocate tb