| | |
|---|
| | | "\tLEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" + |
|---|
| | | "\tLEFT JOIN sys_user us ON us.user_id = re.doctor_name \n" + |
|---|
| | | "WHERE\n" + |
|---|
| | | "\tre.type != 2 \n" +//and pro.need_report='Y' |
|---|
| | | "\tAND re.tj_number =#{tjNumber}") |
|---|
| | | "re.type != 2 \n" +//and pro.need_report='Y' |
|---|
| | | "AND re.tj_number =#{tjNumber} and re.dept_id !=532 and pro.pro_name not like '%费%'") |
|---|
| | | List<CsProVo> cSWebGetProByTjNumAndOrderId(String tjNumber); |
|---|
| | | |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | @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); |
|---|
| | | } |
|---|
