query-warning-rule-count.js 3.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109
  1. #!/usr/bin/env node
  2. /**
  3. * 查询 BS_DRGWarningRule 表记录数
  4. */
  5. const axios = require('axios');
  6. // 配置参数
  7. const config = {
  8. host: 'localhost',
  9. port: '52773',
  10. namespace: 'DRG',
  11. username: '_SYSTEM',
  12. password: 'pryk@2020',
  13. baseURL: 'http://172.16.2.15:52773',
  14. endpoint: '/csp/drg/sysInternalMutiple'
  15. };
  16. // 创建axios实例
  17. const irisClient = axios.create({
  18. baseURL: config.baseURL,
  19. timeout: 30000,
  20. auth: {
  21. username: config.username,
  22. password: config.password
  23. },
  24. headers: {
  25. 'Content-Type': 'application/json',
  26. 'Accept': 'application/json'
  27. }
  28. });
  29. async function queryWarningRuleCount() {
  30. console.log('='.repeat(60));
  31. console.log('查询 BS_DRGWarningRule 表记录数');
  32. console.log('='.repeat(60));
  33. console.log();
  34. console.log('服务器配置:');
  35. console.log(` 地址: ${config.baseURL}`);
  36. console.log(` 命名空间: ${config.namespace}`);
  37. console.log(` 接口端点: ${config.endpoint}`);
  38. console.log();
  39. // 调用查询预警规则接口 (02010101)
  40. console.log('调用接口 02010101 - 查询预警规则...');
  41. try {
  42. const requestData = {
  43. code: '02010101',
  44. params: [{}],
  45. session: [{
  46. userID: '158',
  47. userCode: 'admin',
  48. userName: 'admin',
  49. locID: '2300',
  50. locDesc: '信息中心',
  51. groupID: '3',
  52. groupDesc: '医院维护员',
  53. hospID: '25',
  54. hospCode: 'H03',
  55. hospDesc: '合肥普瑞眼科医院'
  56. }]
  57. };
  58. const response = await irisClient.post(config.endpoint, requestData);
  59. const data = response.data;
  60. console.log(`接口调用成功!`);
  61. console.log(` 错误码: ${data.errorCode}`);
  62. console.log(` 错误信息: ${data.errorMessage || '无'}`);
  63. console.log();
  64. if (data.errorCode === '0' && data.result) {
  65. const result = data.result;
  66. console.log('✅ 查询结果:');
  67. console.log(` BS_DRGWarningRule 表总记录数: ${result.total || 0}`);
  68. console.log();
  69. if (result.rows && result.rows.length > 0) {
  70. console.log(` 返回记录数: ${result.rows.length}`);
  71. console.log();
  72. console.log('预警规则列表:');
  73. result.rows.forEach((rule, index) => {
  74. console.log(` ${index + 1}. ID:${rule.id} | 编码:${rule.ruleCode} | 名称:${rule.ruleName} | 类型:${rule.ruleType} | 启用:${rule.isActive}`);
  75. });
  76. } else {
  77. console.log(' 暂无预警规则数据');
  78. }
  79. } else {
  80. console.log('⚠️ 接口返回错误:', data.errorMessage);
  81. }
  82. } catch (error) {
  83. console.log(`❌ 接口调用失败: ${error.message}`);
  84. if (error.response) {
  85. console.log(` 响应状态: ${error.response.status}`);
  86. console.log(` 响应数据: ${JSON.stringify(error.response.data, null, 2)}`);
  87. }
  88. }
  89. console.log();
  90. console.log('='.repeat(60));
  91. console.log('查询完成');
  92. console.log('='.repeat(60));
  93. }
  94. // 运行查询
  95. queryWarningRuleCount().catch(console.error);