| | |
| | | |
| | | @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=3 AND c.need_report='Y' AND a.tj_number=#{tjnumber}") |
| | | "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})") |
| | | List<TjOrderRemark> getzongjianyishengchakanyichangxiangmu(String tjNumber); |