From aa4a9a6f2f40f57fc725ebcd5a6c09d34921f0eb Mon Sep 17 00:00:00 2001 From: 赵文轩 <1652863494@qq.com> Date: 星期五, 07 六月 2024 10:23:06 +0800 Subject: [PATCH] hisAPI配置 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 10 +++++++++- 1 files changed, 9 insertions(+), 1 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java index d525862..401706c 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java @@ -69,6 +69,14 @@ public boolean deletedTbTransitionByCusId(String cusId); + @Delete("DELETE FROM tb_transition WHERE tj_num=#{tjNum}") + public boolean deletedTbTransitionByTjNum(String tjNum); + + @Update("UPDATE tb_transition a SET "+ + "a.tj_num=null" + + " WHERE a.tj_num=#{tjNum}") + boolean updateTbTransitionByTjNum(String tjNum); + @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} AND pac_id=#{pacId}") public List<TbTransition> getTbTransitionListByCusIdAndPac(@Param("cusId") String cusId,@Param("pacId") String pacId); @@ -100,7 +108,7 @@ @Update("UPDATE tb_transition a SET \n" + "a.ord_price=a.now_price,\n" + - "a.now_price=a.ord_price*#{discount}," + + "a.now_price=a.ord_price*(#{discount}/10)," + "a.tj_num=#{tjNum}"+ " WHERE a.cus_id=#{cusId} ") boolean updateTbTransitionPriceByCusId(@Param("cusId")String cusId,@Param("discount")BigDecimal discount,@Param("tjNum")String tjNum); -- Gitblit v1.8.0