zjh20250715-2

zjh

23 小时以前 62eb109ad2041c38df8f48d41b95a85d2dc44cb7

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java

@@ -26,7 +26,7 @@
    @Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND deleted='0'")
    List<TjOrderRemark> getTjOrderRemarkListByTjNum(String tjNumber);

    @Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND pro_id=#{proParentId} AND deleted='0'")
    @Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND pro_id=#{proParentId} AND deleted=0 ")
    TjOrderRemark getTjOrderRemarkByTjNumAndProParentId(@Param("tjNumber") String tjNumber, @Param("proParentId") String proParentId);

    @Select("SELECT COUNT(*) a FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type IN (0,3) AND deleted=0")