biztalk rosettanet 自定义 pip code

USE [BTARNDATA]
GO
/****** Object:  StoredProcedure [dbo].[proc_GetActivityStatus]    Script Date: 09/16/2015 16:16:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[proc_GetActivityStatus]
(
 @PIPCode varchar(10),
 @PIPVersion varchar(20),
 @PIPInstanceID nvarchar(255),
 @SourcePartnerName nvarchar(255),
 @DestinationPartnerName nvarchar(255),
 @IsInitiatorActivity bit
)
AS

IF (@DestinationPartnerName = 'SEAGATE-AMK' and @PIPCode = 'SG_3B2')
BEGIN
 SET @PIPCode = '3B2'
END

IF (@DestinationPartnerName = 'SEAGATE-US' and @PIPCode = 'SG_3B2')
BEGIN
 SET @PIPCode = '3B2'
END

IF (@DestinationPartnerName = 'SEAGATE-USML' and @PIPCode = 'SG_3B2')
BEGIN
 SET @PIPCode = '3B2'
END

IF (@DestinationPartnerName = 'SEAGATE-AMK' and @PIPCode = 'SG_4B2')
BEGIN
 SET @PIPCode = '4B2'
END

IF (@DestinationPartnerName = 'SEAGATE-US' and @PIPCode = 'SG_4B2')
BEGIN
 SET @PIPCode = '4B2'
END

IF (@DestinationPartnerName = 'SEAGATE-USML' and @PIPCode = 'SG_4B2')
BEGIN
 SET @PIPCode = '4B2'
END


 DECLARE @sourcePartnerKey int 
 DECLARE @destinationPartnerKey int
 DECLARE @ActivityID nvarchar(255)
 SET @sourcePartnerKey = '-1'
 SET @destinationPartnerKey = '-1'
 SELECT @sourcePartnerKey = PartnerKey FROM PartnerLookup WHERE PartnerName=@SourcePartnerName
 SELECT @destinationPartnerKey = PartnerKey FROM PartnerLookup WHERE PartnerName=@DestinationPartnerName
 SELECT TOP 1 CurrentStatus
  FROM ActivityTracking tblAT
  WHERE tblAT.PIPCode = @PIPCode AND
   tblAT.PIPVersion = @PIPVersion AND
   tblAT.PIPInstanceID = @PIPInstanceID AND
   tblAT.SourcePartnerKey = @sourcePartnerKey AND
   tblAT.DestinationPartnerKey = @destinationPartnerKey AND
   tblAT.IsInitiatorActivity = @IsInitiatorActivity
USE [BTARNDATA]
GO
/****** Object:  StoredP