insert_his_fee_sync_interface.sql 1.5 KB

123456789101112131415161718192021222324252627282930313233343536
  1. -- 注册 HIS 住院费用明细同步接口 02010068 到 CB_MapInterface
  2. -- 接口码:02010068
  3. -- ClassName : src.DRG.HISData.Interface
  4. -- MethodName: GetInpatientFeeData
  5. -- ServiceType: A(写类)
  6. -- 说明:仅通过 CB_MapInterface 通用路由调用,不修改 src.Rest.DRGHis.cls
  7. -- 清理可能存在的旧数据(避免重复注册)
  8. &sql(DELETE FROM CB_MapInterface WHERE Code = '02010068')
  9. -- 1. 保存HIS住院患者费用明细接口 (02010068)
  10. SET obj=##class(User.CBMapInterface).%New()
  11. SET obj.Code="02010068"
  12. SET obj.Descripts="HIS数据同步-获取住院费用明细"
  13. SET obj.ClassName="src.DRG.HISData.Interface"
  14. SET obj.MethodName="GetInpatientFeeData"
  15. SET obj.ServiceType="A"
  16. SET obj.SessionFlag="Y"
  17. SET obj.TokenFlag="N"
  18. SET obj.StartDate=$zd($h,5)
  19. SET obj.Status="Y"
  20. SET sc=obj.%Save()
  21. IF $$$ISERR(sc) { WRITE "保存接口02010068失败:"_$System.Status.GetErrorText(sc,"cn"),! }
  22. ELSE { WRITE "接口02010068已添加",! }
  23. -- 查询验证
  24. WRITE "=== 已添加的HIS费用明细同步接口 ===",!
  25. SET stmt=##class(%SQL.Statement).%New()
  26. SET prepSC=stmt.%Prepare("SELECT Code,Descripts,ClassName,MethodName,ServiceType,SessionFlag,TokenFlag,Status FROM CB_MapInterface WHERE Code = '02010068'")
  27. IF $$$ISERR(prepSC) { WRITE "SQL准备失败:"_$System.Status.GetErrorText(prepSC,"cn"),! }
  28. ELSE {
  29. SET rslt=stmt.%Execute()
  30. WHILE rslt.%Next() {
  31. WRITE rslt.%Get("Code")_" - "_rslt.%Get("Descripts")_" ["_rslt.%Get("ClassName")_"."_rslt.%Get("MethodName")_"] ServiceType="_rslt.%Get("ServiceType")_" Status="_rslt.%Get("Status"),!
  32. }
  33. }