| | |
| | | "WHERE\n" + |
| | | " a.deleted = 0 \n" + |
| | | " AND b.org_type = 1 \n" + |
| | | " AND a.type !=1") |
| | | " AND a.type=0") |
| | | List<String> getDingShiTongBuJianYanTjNum(); |
| | | |
| | | |
| | |
| | | "WHERE\n" + |
| | | " a.deleted = 0 \n" + |
| | | " AND b.org_type = 2 \n" + |
| | | " AND a.type !=1") |
| | | " AND a.type =0") |
| | | List<String> getDingShiTongBuJianChaTjNum(); |
| | | |
| | | |
| | | |
| | | |
| | | void tjQiandaodengji(Map<String,Object> map); |
| | | |
| | | void tjLispacstongbujianyi(Map<String, Object> map); |
| | | |
| | | List<List<?>> getTjBgdyList(Map<String, Object> map); |
| | | |
| | | @Select(" SELECT\n" + |
| | | " DISTINCT a.tj_number \n" + |
| | | "FROM\n" + |
| | | " tj_order_remark a\n" + |
| | | " JOIN sys_dept b ON b.dept_id = a.dept_id \n" + |
| | | "WHERE\n" + |
| | | " a.deleted = 0 \n" + |
| | | " AND b.org_type = 2 \n") |
| | | List<String> getJianChaTjNum(); |
| | | } |