zjh 2023/09/15--3

zjh

2023-09-15 c8ab77ab79b17056f887ed75102cb9ba037f3190

 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);
}