ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java
@@ -111,7 +111,7 @@ List<Map<String ,Object >> getCusInfoListByCardAndName(@Param("card") String card,@Param("name") String name); @Select("SELECT IF(b.cus_sex=0,'男','女') xb FROM tj_order a JOIN tj_customer b ON b.cus_id=a.user_id \n" + @Select("SELECT IF(b.cus_sex=0,'0','1') xb FROM tj_order a JOIN tj_customer b ON b.cus_id=a.user_id \n" + "WHERE a.tj_number=#{tjNumber}") String getSexByTjh(String tjNumber); }