ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
@@ -169,6 +169,12 @@ "WHERE a.deleted=0 AND b.org_type=3 AND c.need_report='Y' AND a.tj_number=#{tjnumber}") // AND c.need_report='Y' guo List<TjOrderRemark> notHuaYanData(String tjnumber); @Select("SELECT a.* FROM tj_order_remark a LEFT JOIN sys_dept b ON b.dept_id=a.dept_id LEFT JOIN tj_project c ON c.pro_id=a.pro_id\n" + "\n" + "WHERE a.deleted=0 AND b.org_type = 2 AND c.need_report='Y' AND a.tj_number=#{tjnumber}") // AND c.need_report='Y' guo List<TjOrderRemark> pacsJianChaData(String tjnumber); @Select("call tj_check_yclist(0,#{tjnumber,mode=IN})") ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java
@@ -68,4 +68,6 @@ List<TjOrderRemark> notHuaYanData(String tjnumber); List<TjOrderRemark> getzongjianyishengchakanyichangxiangmu(String tjNumber); List<TjOrderRemark> pacsJianChaData(String tjnumber); } ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java
@@ -123,4 +123,9 @@ return mapper.getzongjianyishengchakanyichangxiangmu(tjNumber); } @Override public List<TjOrderRemark> pacsJianChaData(String tjnumber) { return mapper.pacsJianChaData(tjnumber); } }