From 05af9bff8288d3052fff67a6e6d63857110fee37 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期一, 26 五月 2025 14:54:06 +0800 Subject: [PATCH] zjh20250526 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java | 4 ++-- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java | 4 ++-- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 2 +- 3 files changed, 5 insertions(+), 5 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java index 133d549..669af6e 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcbgdMapper.java @@ -21,7 +21,7 @@ //@DataSource(value = DataSourceType.MASTER) public interface LtkjExamJcbgdMapper extends BaseMapper<LtkjExamJcbgd> { - @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tmh} and lx='1' ") + @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tmh} and lx=0 ") void deletedLtkjJcbgdByTjhAndTmh(String tmh); @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id =#{cardId} AND a.type='妫�鏌�' GROUP BY a.sqdh") @@ -34,7 +34,7 @@ List<LtkjExamJcbgd> getJianJcBaoGaoDanByTjh(String cardId); - @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tjh} and tmh=#{tmh} ") + @Delete("DELETE FROM ltkj_exam_jcbgd WHERE tjh=#{tjh} and tmh=#{tmh} and lx=1 ") void deletedLtkjJcbgdByTjhandtmh(@Param("tjh") String tjh, @Param("tmh") String tmh); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java index 9d01532..4ff5870 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java @@ -25,7 +25,7 @@ @Select ("SELECT * FROM ltkj_exam_jcsqd a WHERE a.tjh=#{tjh} AND a.tmh=#{tmh} ") LtkjExamJcsqd getLtkjJcsqdByTjhAndTmh(@Param("tjh") String tjh,@Param("tmh") String tmh); - @Delete ("DELETE FROM ltkj_exam_jcsqd WHERE tjh=#{tjh} and lx='1' ") + @Delete ("DELETE FROM ltkj_exam_jcsqd WHERE tjh=#{tjh} and lx=0 ") void deletedLtkjJcsqdByTjhAndTmh(@Param("tjh")String tjh); @Select("SELECT * FROM ltkj_exam_jcsqd a WHERE a.tjh=#{tjh}") @@ -66,7 +66,7 @@ - @Delete ("DELETE FROM ltkj_exam_jcsqd WHERE tjh=#{tjh} and tmh=#{tmh}") + @Delete ("DELETE FROM ltkj_exam_jcsqd WHERE tjh=#{tjh} and tmh=#{tmh} and lx=1") void deletedLtkjJcsqdByTjhandtmh(@Param("tjh") String tjh,@Param("tmh") String tmh); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java index 727060a..b9f19a9 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java @@ -349,7 +349,7 @@ "FROM\n" + " vi_his_patientresult a JOIN vi_his_patientinfo b ON b.SAMPLEID=a.SAMPLEID\n" + "WHERE b.PATIENTTYPE=3 AND\n" + - " a.SAMPLEID = #{tmh}") + " a.SAMPLEID = #{tmh} ORDER BY a.PRINTORDER") List<LtkjHybgd> getCcXZxYyLtkjHybgdByLisVi(String tmh); -- Gitblit v1.8.0