zjh20250722

zjh

3 天以前 ad4326adc4ccad14f090fba5acb435deab8260db

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

@@ -436,4 +436,13 @@

    //存储过程专用接口(总检)
    List<List<?>> getEsjCunChuGuoChengCustomerList(Map<String,Object> map);


    @Select("SELECT * FROM tj_order WHERE tj_number = card_id ")
    List<TjOrder> getOrderListBypiliangqiandaofasong();


    @Select("SELECT COUNT(*) FROM tj_order a WHERE a.deleted=0 AND " +
            "(a.firm_id=#{compId} OR a.team_no=#{teamNo}) AND a.pac_id=#{pacId}")
    Integer getTjTeamSelectRecordCount(@Param("teamNo") String teamNo,@Param("compId") String compId,@Param("pacId") String pacId);
}