From d866e43afbe901bfc640776e02f767b9045acbc2 Mon Sep 17 00:00:00 2001 From: 赵文轩 <1652863494@qq.com> Date: 星期三, 12 六月 2024 09:04:56 +0800 Subject: [PATCH] Merge branch 'master' of http://101.42.27.146:5001/r/ltkj_peis --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TestMapper.java | 41 +++++++++++++++++++++++++++++++++++++---- 1 files changed, 37 insertions(+), 4 deletions(-) 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 02a1fa5..5d45f06 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 @@ -30,7 +30,7 @@ @Select("SELECT * FROM histjv_Ltkj_middle_head") public List<LtkjMiddleHead> getMiddleHead(); - @DataSource(value = DataSourceType.SLAVE_LIS) + @DataSource(value = DataSourceType.SLAVE_HIS) @Select("SELECT * FROM histjv_Ltkj_middle_head where fead_id=#{partId}") public LtkjMiddleHead getMiddleHeadByPartId(String partId); @@ -41,10 +41,10 @@ @Select("SELECT * FROM histjv_LTKJVTJPAT") public List<LtkjTjPat> getTjPat(); - @DataSource(value = DataSourceType.SLAVE_PACS) + @DataSource(value = DataSourceType.SLAVE_HIS) @Select({"<script> select isnull(fcard_no,'涓嶈') xh,fcard_iD pacCode,pat_name pacName,\n" + " (case when patsex_id='0' then '鐢�' when patsex_id='1' then '濂�' else '鏈煡' end )+';'+brnl detail,\n" + - " pat_id price , mobile pacRemark" + + " pat_id price , mobile+tjbz pacRemark" + " from histjv_ltkjvtjpat where 1=1 "+ " <when test='pacCode!=null'>" + " AND fcard_no like '%'+#{pacCode}+'%'" + @@ -55,6 +55,7 @@ " <when test='pacRemark!=null'>" + " AND mobile = #{pacRemark}" + "</when>" + + " order by fcard_iD desc"+ "</script>"}) public List<Map<String,Object>> newGetTjPat(@Param("pacCode")String pacCode, @Param("pacName")String pacName, @@ -81,6 +82,16 @@ @Param("orderId")String orderId, @Param("tjnum")String tjnum, @Param("dockerId")String dockerId); + + @DataSource(value = DataSourceType.MASTER) + @Select("call tj_jc_update_detatil(#{cardId,mode=IN},#{orderId,mode=IN},#{tjnum,mode=IN},#{dockerId,mode=IN})") + public void updateDetailByTjJcCall(@Param("cardId") String cardId, + @Param("orderId")String orderId, + @Param("tjnum")String tjnum, + @Param("dockerId")String dockerId); + + + @DataSource(value = DataSourceType.SLAVE_HIS) @Select("SELECT * FROM histjv_exam_jcbgd") @@ -157,7 +168,7 @@ - @DataSource(value = DataSourceType.SLAVE_PACS) + @DataSource(value = DataSourceType.SLAVE_LIS) @Select({"<script> select *"+ " from histjv_Ltkj_hyxm where 1=1 "+ " <when test='pacCode!=null'>" + @@ -174,4 +185,26 @@ @Param("pacName")String pacName, @Param("pacRemark")String pacRemark); + @Select("SELECT * FROM histjv_ltkj_userinfo") + @DataSource(value = DataSourceType.SLAVE_HIS) + public List<LtkjHisUser> getLtkjHisUser(); + + + @DataSource(value = DataSourceType.SLAVE_PACS) + @Select({"<script> select bgid xh,patname pacName ,rptid pacCode,patage+patagename+'['+sex+']'+patbirth detail,djrq+jcxm pacRemark,lxhd price \n" + + "\tfrom V_HIS_PACS_SQ\n" + + "\twhere 1=1 " + + " <when test='patname!=null'>" + + " AND patname=#{patname}" + + "</when>"+ + " <when test='sex!=null'>" + + " AND sex=#{sex} "+ + "</when>"+ + " <when test='nn!=null'>" + + " AND patage+patagename=#{nn}" + + "</when>"+ + "</script>"}) + public List<Map<String,Object>> getTjYxjcList(@Param("patname")String patname, + @Param("sex")String sex, + @Param("nn")String nn); } -- Gitblit v1.8.0