SET
NOCOUNT
ON
DECLARE @RetrunValue nvarchar ( 1000 )
DECLARE @ERRORSUM INT
SET @ERRORSUM = 0
SET @RetrunValue = ' 代理注册失败 '
BEGIN TRANSACTION -- 事务开始
UPDATE tb_Gdf_Reg_Center SET BounsMoneyOut = BounsMoneyOut + @Agent_XinYu WHERE Member_Code = @p17
SET @ERRORSUM = @ERRORSUM + @@error
IF @ERRORSUM = 0
BEGIN
SET @RetrunValue = ' 代理注册成功 '
COMMIT TRANSACTION
END
ELSE
BEGIN
SET @RetrunValue = ' 代理注册失败 '
ROLLBACK TRANSACTION
END
DECLARE @RetrunValue nvarchar ( 1000 )
DECLARE @ERRORSUM INT
SET @ERRORSUM = 0
SET @RetrunValue = ' 代理注册失败 '
BEGIN TRANSACTION -- 事务开始
UPDATE tb_Gdf_Reg_Center SET BounsMoneyOut = BounsMoneyOut + @Agent_XinYu WHERE Member_Code = @p17
SET @ERRORSUM = @ERRORSUM + @@error
IF @ERRORSUM = 0
BEGIN
SET @RetrunValue = ' 代理注册成功 '
COMMIT TRANSACTION
END
ELSE
BEGIN
SET @RetrunValue = ' 代理注册失败 '
ROLLBACK TRANSACTION
END