一个存储过程里调用另一个存储过程产生不执行问题

ldl999 2004-09-07 03:02:44

现在想这样当在E_xiaoYuan_Member不存在相关记录时并且If @msg like @ContrlConfirmCode and @tem = 0 and not exists(select * from E_XiaoYuan_Member where Tel = @UserMobile )
goto Senddz

Senddz: 这是另一个存储过程
现在设置@ContrlConfirmCode = 1
当@msg = '1'并且E_XiaoYuan_Member 里不存在where Tel = @UserMobile 的记录时，我要调用这个
存储过程，就是说，当满足产生 '欢迎您加入E动校园,您的ID号为'+@EId+',回复或发送:学校中文全称#入学年份到'+ @SpecCode + @AddOperCode +'加入您的学校.'
select @SpecCode = @SpecCode + @AddOperCode
的条件时，同时调用此存储过程（即他们的条件是一样的），现在按照我如下的写法，不能走到goto Senddz 这去，请各位大哥帮忙看看，我已忙了一天，也没找出原因，实在惭愧
If @OperCode = @RegOperCode
Begin
If not exists(select * from E_XiaoYuan_Member where Tel = @UserMobile and InServ = 0 )
Begin
If not exists(select * from E_XiaoYuan_Confirm where Tel = @UserMobile and ServCode = ltrim(rtrim(@p_servicecode)) and Flag = 0 )
Begin
select @msg = 'E动校园,E动的心,回复'+@ConfirmCode+'或发送'+@ConfirmCode+'到'+ @SpecCode + @RegOperCode + '加入E动校园,5元/月,发送0000到'+ @SpecCode +@RegOperCode +'取消.'+@CustomNum
insert into E_XiaoYuan_Confirm values(@UserMobile,ltrim(rtrim(@p_servicecode)),getdate(),0)
select @SpecCode = @SpecCode + @RegOperCode
goto SendSmg
print '1--'
End
Else If @msg like @ContrlConfirmCode and @tem = 0

Begin
--注册E动校园包月
If not exists(select * from E_XiaoYuan_Member where Tel = @UserMobile )
Begin
set rowcount 1
select @EId = EId,@tem=Seq from E_XiaoYuan_ID where Used = 0
set rowcount 0
update E_XiaoYuan_ID set Tel = @UserMobile,Time = getdate(),Used = 1 where EId = @EId and Seq = @tem
insert into E_XiaoYuan_Member values(@UserMobile,@EId,getdate(),0,0,'','')
print '2--'
End
Else
Begin
update E_XiaoYuan_Member set InServ = 0,InRece = 0 where Tel = @UserMobile
print '3--'
End
select @EId = EId from E_XiaoYuan_Member where Tel = @UserMobile
update E_XiaoYuan_Confirm set Flag = 1 where Tel = @UserMobile and ServCode = ltrim(rtrim(@p_servicecode)) and Flag = 0
insert into E_XiaoYuan_Bag values(@UserMobile,@EId,ltrim(rtrim(@p_servicecode)),getdate(),'20200101 12:00:00')

select @msg = '欢迎您加入E动校园,您的ID号为'+@EId+',回复或发送:学校中文全称#入学年份到'+ @SpecCode + @AddOperCode +'加入您的学校.'
select @SpecCode = @SpecCode + @AddOperCode
print '4--'

exec xp_easysendonemessage @SpecCode,@TargetMobile,@msg,@p_servicecode ,'0',@FeeMobile,@LinkId
If @msg like @ContrlConfirmCode and @tem = 0 and not exists(select * from E_XiaoYuan_Member where Tel = @UserMobile )
goto Senddz

End
Else
Begin
select @msg = '您的输入有误!回复'+@ConfirmCode+'或发送短信内容'+@ConfirmCode+'到'+ @SpecCode + @RegOperCode + '进入E动校园'+@CustomNum
select @SpecCode = @SpecCode + @RegOperCode
print '5--'
goto SendSmg
End
End
Else
Begin
select @EId = EId from E_XiaoYuan_Member where Tel = @UserMobile
select @msg = '您已加入E动校园!您的ID号为'+@EId+',回复或发送:学校中文全称#入学年份到'+ @SpecCode + @AddOperCode +'走进您的E动校园.'
select @SpecCode = @SpecCode + @AddOperCode
print '6--'
goto SendSmg
End

End
........................................
SendDz:
exec xp_tndz_service @SpecCode,@TargetMobile,@msg,@p_servicecode ,'0',@FeeMobile,@LinkId

...全文