insert_his_sync_interfaces.sql 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. -- 插入HIS数据同步接口配置到 CB_MapInterface 表
  2. -- 接口码:02010078、02010079、02010080、02010081
  3. -- 1. 执行同步任务接口 (02010078)
  4. SET obj=##class(User.CBMapInterface).%New()
  5. SET obj.Code="02010078"
  6. SET obj.Descripts="HIS数据同步-执行同步任务"
  7. SET obj.ClassName="src.DRG.HISData.Interface"
  8. SET obj.MethodName="ExecuteSyncTask"
  9. SET obj.ServiceType="S"
  10. SET obj.SessionFlag="Y"
  11. SET obj.TokenFlag="N"
  12. SET obj.StartDate=$zd($h,5)
  13. SET obj.Status="Y"
  14. SET sc=obj.%Save()
  15. IF $$$ISERR(sc) { WRITE "保存接口02010078失败:"_$System.Status.GetErrorText(sc,"cn"),! }
  16. ELSE { WRITE "接口02010078已添加",! }
  17. -- 2. 查询同步配置接口 (02010079)
  18. SET obj=##class(User.CBMapInterface).%New()
  19. SET obj.Code="02010079"
  20. SET obj.Descripts="HIS数据同步-查询同步配置"
  21. SET obj.ClassName="src.DRG.HISData.Interface"
  22. SET obj.MethodName="GetSyncConfig"
  23. SET obj.ServiceType="S"
  24. SET obj.SessionFlag="Y"
  25. SET obj.TokenFlag="N"
  26. SET obj.StartDate=$zd($h,5)
  27. SET obj.Status="Y"
  28. SET sc=obj.%Save()
  29. IF $$$ISERR(sc) { WRITE "保存接口02010079失败:"_$System.Status.GetErrorText(sc,"cn"),! }
  30. ELSE { WRITE "接口02010079已添加",! }
  31. -- 3. 保存同步配置接口 (02010080)
  32. SET obj=##class(User.CBMapInterface).%New()
  33. SET obj.Code="02010080"
  34. SET obj.Descripts="HIS数据同步-保存同步配置"
  35. SET obj.ClassName="src.DRG.HISData.Interface"
  36. SET obj.MethodName="SaveSyncConfig"
  37. SET obj.ServiceType="S"
  38. SET obj.SessionFlag="Y"
  39. SET obj.TokenFlag="N"
  40. SET obj.StartDate=$zd($h,5)
  41. SET obj.Status="Y"
  42. SET sc=obj.%Save()
  43. IF $$$ISERR(sc) { WRITE "保存接口02010080失败:"_$System.Status.GetErrorText(sc,"cn"),! }
  44. ELSE { WRITE "接口02010080已添加",! }
  45. -- 4. 查询同步状态接口 (02010081)
  46. SET obj=##class(User.CBMapInterface).%New()
  47. SET obj.Code="02010081"
  48. SET obj.Descripts="HIS数据同步-查询同步状态"
  49. SET obj.ClassName="src.DRG.HISData.Interface"
  50. SET obj.MethodName="GetSyncStatus"
  51. SET obj.ServiceType="S"
  52. SET obj.SessionFlag="Y"
  53. SET obj.TokenFlag="N"
  54. SET obj.StartDate=$zd($h,5)
  55. SET obj.Status="Y"
  56. SET sc=obj.%Save()
  57. IF $$$ISERR(sc) { WRITE "保存接口02010081失败:"_$System.Status.GetErrorText(sc,"cn"),! }
  58. ELSE { WRITE "接口02010081已添加",! }
  59. -- 查询验证
  60. WRITE "=== 已添加的HIS同步接口 ===",!
  61. SET rset=##class(%SQL.Statement).%New()
  62. DO rset.%Prepare("SELECT Code,Descripts,ClassName,MethodName,ServiceType,Status FROM CB_MapInterface WHERE Code IN ('02010078','02010079','02010080','02010081')")
  63. SET rslt=rs.%Execute()
  64. WHILE rslt.%Next() {
  65. WRITE rslt.%GetData(1)_" - "_rslt.%GetData(2)_" ["_rslt.%GetData(4)_"]",!
  66. }