22,209
社区成员
发帖
与我相关
我的任务
分享
--P_PM_WorkFlow_FlowDo '王磊',''
ALTER PROCEDURE [dbo].[P_PM_WorkFlow_FlowDo] (@FInstID varchar(50),@FActID varchar(50)) AS
begin
declare @ServiceUrl as varchar(8000)
declare @UrlAddress varchar(500)
declare @FMobileServiceIP varchar(100)
declare @FMobileServicePort int
select @FMobileServiceIP=FMobileServiceIP,@FMobileServicePort=FMobileServicePort from T_CL_GlobalSet
set @UrlAddress = 'http://***.6*2.197.129:50000'+'/FaceView.asmx/'
declare @FunName varchar(50)
set @FunName = 'GetLoginResult'
declare @P1 varchar(50),@P2 varchar(50),@P3 varchar(50)
set @P1 = 'username'
set @P2 = 'password'
set @P3 = 'devicetoken'
set @ServiceUrl = @UrlAddress + @FunName + '?' + @P1 + '=' + @FInstID +'&' + @P2 + '=' + @FActID +'&' + @P3 + '='
Declare @Object as Int
Declare @ResponseText as Varchar(8000)
Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',@ServiceUrl,'false'
EXEC sp_OAMethod @Object, 'setRequestHeader', NULL,'Content-Type', 'application/x-www-form-urlencoded';
Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
Select @ResponseText
Exec sp_OADestroy @Object
end