zjh202412030

zjh

2024-12-30 fda54900d884d9b52c6a6072a87f281a22cac528

zjh202412030

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

@@ -71,11 +71,11 @@
    List<TjCustomer> getTjCustomerList(String name);


    @Select("SELECT * FROM tj_customer WHERE cus_idcard = #{cusIdCard}")
    @Select("SELECT * FROM tj_customer WHERE cus_idcard = #{cusIdCard} and deleted=0")
    TjCustomer getTjCustomerByCusIdCard(String cusIdCard);


    @Select("SELECT * FROM tj_customer WHERE cus_idcard = #{cusIdCard}")
    @Select("SELECT * FROM tj_customer WHERE cus_idcard = #{cusIdCard} deleted=0")
    ResultSet getJsonParseCustomerList(String deptId, Integer page, Integer pageSize, String cusName, String tjNumber);

    @Select("SELECT IFNULL(b.cn_name,'无')  FROM (\n" +