| | |
|---|
| | | @Select("SELECT * FROM `tj_project` where pro_parent_id=0 and pro_status=0 and LOCATE( '体检',pro_name) and deleted=0") |
|---|
| | | List<TjProject> getDxTjProjectList(); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM `tj_project` where pro_parent_id=0 and pro_status=0 and deleted=0") |
|---|
| | | List<TjProject> getOpenDxTjProjectList(); |
|---|
| | | // @Select("SELECT * FROM `tj_project` where pro_parent_id=0 and pro_status=0 and deleted=0") |
|---|
| | | List<TjProject> getOpenDxTjProjectList(String nr); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("SELECT a.*,GROUP_CONCAT(b.pro_name ORDER BY b.pro_name) AS all_son_pro_name FROM\n" + |
|---|
