526互联

安康市医院

发布时间 2023-07-06 17:23:04作者: 张Blog

安康市医院数据同步

实施文档

配置service.xml

路径 \META-INF\xfire\services.xml

<!--安康市医院数据同步-->
<service xmlns="http://xfire.codehaus.org/config/1.0">
  <name>ExtSyncToHIPService </name>
  <namespace>http://www.hjsj.com/HrService</namespace>
  <serviceClass>com.hjsj.hrms.service.ankanghospital.ExtSyncToHIPService</serviceClass>
</service>
<!--安康市医院数据同步结束-->

image-20221215184157158

新增外部系统位置

image-20221215184303879

方案禁用pass

触发器调用接口demo,监控usra04表,@responsetext为请求返回值,不宜过长

CREATE TRIGGER trigger_senget
    ON [dbo].[usra04]
    AFTER UPDATE, DELETE, INSERT
    AS
BEGIN

    DECLARE @serviceurl AS VARCHAR(1000)
    SET @serviceurl =
            'https://demo-api.apipost.cn/api/demo/news_list?mobile=18289454846' -- api接口
    DECLARE @data VARCHAR(MAX);
--set @data='{"orderNo":"GJF0220402286","businessMan":"11096周涛"}'   --入参
    DECLARE @object AS INT
    DECLARE @responsetext AS VARCHAR(8000);
    EXEC sp_oacreate 'WinHttp.WinHttpRequest.5.1', @object OUT;
    EXEC sp_oamethod @object, 'open', NULL, 'GET', @serviceurl, 'false'
    EXEC sp_oamethod @object, 'setRequestHeader', NULL, 'Content-Type', 'application/json;charset=UTF-8'
    EXEC sp_oamethod @object, 'send', NULL, @data --发送数据
    EXEC sp_oamethod @object, 'responseText', @responsetext OUTPUT
--    EXEC sp_oageterrorinfo @object --异常输出
--    INSERT INTO t_senget_rtn VALUES (GETDATE(), @responsetext);
    EXEC sp_oadestroy @object
END;

触发器调用接口需要管理员权限开启以下设置

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ole Automation Procedures';
GO