zjh 2023/10/25--1

zjh

2023-10-25 8c4968ea3bd61c154c71d40f43a2cc22760fef49

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

@@ -66,4 +66,12 @@

    @Select("SELECT * FROM tj_standard  WHERE  pro_id=#{proId} AND deleted='0'")
    public List<TjStandard> getTjStandardListByProId(String proId);


    @Select("select * from tj_standard \n" +
            "where IF(NULL is NULL, 0 = 0, tj_sex =#{tjSex})\n" +
            "AND IF(NULL is NULL, 0 = 0, tj_type=#{tjType})\n" +
            "AND stan_id in \n" +
            "(SELECT stan_id FROM tj_standard  WHERE  pro_id=#{proId} AND deleted='0')")
    public TjStandard getListBySexAndType(Long tjSex,int tjType,String proId);
}