From 524a0867c6e8343607d343a4f708498c21baf9d4 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期五, 28 二月 2025 15:25:34 +0800
Subject: [PATCH] 修改药品处方从表里拿处方类型以及sqlserver连接去除ssl
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
index e9e0070..ac7f7f5 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
@@ -234,9 +234,9 @@
@Select("SELECT \n" +
- " '1' AS xh, " +
+ " ROW_NUMBER() OVER (ORDER BY d.djd_num) AS xh, " +
" REPLACE(d.dept_name, '闂ㄨ瘖', '') AS ksmc,\n" +
- " d.official_web AS ksdz,\n" +
+ " ifnull(d.official_web,'') AS ksdz,\n" +
" e.tjxm,\n" +
" e.tjjg\n" +
"FROM sys_dept d\n" +
--
Gitblit v1.8.0