联盟同步存储过程修改前后对比

---- 说明：推广同步
---- 输入： 
----	  [Mobile]	手机号
----	  [SynIp]		同步服务器IP
---- 输出：
----	  [1]		同步成功
----	  [0]		同步意外失败
----	  [-1]		未找到发起

Create PROCEDURE dbo.Union_PromotionSynPR
	@Mobile	nvarchar(20),
	@SynIp		nvarchar(20),
	@Message         int output
 AS
	declare @count int
	declare @FileName nvarchar(100),@FileUrl nvarchar(200),@RaiseId int,@Union_Users_id int
	select @count=count(*) from User_Raise_Promotion where Mobile=@Mobile
	if(@count=0)
	begin
		set @Message=-1
	end
	else
	begin
		select top 1 @FileName=FileName,@FileUrl=FileUrl,@RaiseId=id,@Union_Users_id=Union_Users_id from User_Raise_Promotion where Mobile=@Mobile order by ID desc
		begin tran
			Insert into Users_Record_Promotion(RaiseId,Union_Users_id,FileName,FileUrl,Status,RaiseDateTime,SynIP) Values(@RaiseId,@Union_Users_id,@FileName,@FileUrl,1,getdate(),@SynIp)
		if(@@error<>0)
		begin
			rollback tran
			Set @Message = 0
		end
		else
		begin
			commit tran
			Set @Message = 1
		end
		
	end
GO

---- 说明：推广同步
---- 输入： 
----	  [Mobile]	手机号
----	  [SynIp]		同步服务器IP
---- 输出：
----	  [1]		同步成功
----	  [0]		同步意外失败
----	  [-1]		未找到发起

Create PROCEDURE dbo.Union_PromotionSynPR
	@Mobile	nvarchar(20),
	@SynIp		nvarchar(20)
 AS
	declare @count int
	declare @FileName nvarchar(100),@FileUrl nvarchar(200),@RaiseId int,@Union_Users_id int

	IF NOT EXISTS(Select TOP 1 * FROM User_Raise_Promotion where Mobile=@Mobile)
		return -1

	select top 1 @FileName=FileName,@FileUrl=FileUrl,@RaiseId=id,@Union_Users_id=Union_Users_id from User_Raise_Promotion where Mobile=@Mobile order by ID desc

	Insert into Users_Record_Promotion(RaiseId,Union_Users_id,FileName,FileUrl,Status,RaiseDateTime,SynIP) Values(@RaiseId,@Union_Users_id,@FileName,@FileUrl,1,getdate(),@SynIp)
	
	if(@@rowcount=1)
		return 1
	else
		return 0
GO