trigger.txt

通过网关发手机短信

ALTER TRIGGER [insertSmS] ON [dbo].[T_SMSReceiveLog] 
FOR INSERT
AS

declare @SendStr varchar(8000), @SendCardNo varchar (30) ,@code varchar(30)

select @SendCardNo=S_SendCardNo ,@code  = S_Content from inserted

select @SendStr= cast (QStr  as varchar(5000)) from T_SMOrder where code=@code


select @SendStr= ' declare @SendStr varchar(100)  ' 
          +  replace(@SendStr,':cardcode',''''+@SendCardNo+'''')

select @SendStr=@SendStr + ' insert T_SMSSendList( S_ReceiveCardNo ,S_SendContent )  '
          + ' select ' +'''' + @SendCardNo + '''' + ',@Sendstr '

exec  (@SendStr)