zjh 2024/02/19--1

zjh

2024-02-19 6b354729688853e3cf4b083530bc466ed0836fb1

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

@@ -134,4 +134,11 @@

    @Select("SELECT * FROM `tj_project` where pro_parent_id=#{proId}")
    List<TjProject> getAllChildListById(String proId);

    @Select("SELECT * FROM `tj_project` where pro_parent_id=0 and pro_status=0")
    List<TjProject> getTjProjectList();


    @Select("SELECT * FROM `tj_project` where pro_parent_id=0 and pro_status=0 and LOCATE( '体检',pro_name) ")
    List<TjProject> getDxTjProjectList();
}