| | |
|---|
| | | |
|---|
| | | @Delete("DELETE FROM tj_order_remark WHERE jxbz=#{bldh}") |
|---|
| | | void deleteTjOrderDetailByjxbz(String bldh); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update("UPDATE tj_order_remark rem\n" + |
|---|
| | | "JOIN tj_project a ON a.pro_id=rem.pro_id\n" + |
|---|
| | | " SET rem.type = 1,\n" + |
|---|
| | | " rem.update_time = SYSDATE() \n" + |
|---|
| | | "WHERE\n" + |
|---|
| | | " rem.pro_id = a.pro_id \n" + |
|---|
| | | " AND rem.tj_number = #{tjNum} \n" + |
|---|
| | | " AND (a.pro_name LIKE '%心电图%' OR a.pro_name LIKE '%妇查%' OR a.pro_name LIKE '%hpv%' OR a.pro_name LIKE '%tct%' OR a.pro_name LIKE '%妇科五联检%'\n" + |
|---|
| | | " OR a.pro_name LIKE '%电子阴道镜检查%' OR a.pro_name LIKE '%C14%' OR a.pro_name LIKE '%心理检测%' OR a.pro_name LIKE '%肺功能检查%' OR a.pro_name LIKE '%静脉%');") |
|---|
| | | boolean updateRemark(String tjNum); |
|---|
| | | } |
|---|
