From 8b477267727b0fe9ca60c98be57ae5a387a6a272 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期四, 31 十月 2024 11:45:01 +0800 Subject: [PATCH] zjh20241031 --- ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java | 4 ++++ ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java | 12 ++++++++++++ ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java | 2 ++ ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java | 5 +++++ 4 files changed, 23 insertions(+), 0 deletions(-) diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java index 0eb3160..42e9a63 100644 --- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java +++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java @@ -1830,6 +1830,7 @@ } } } + remarkService.updateRemark(tjNumber); asyncService.tjGoutAsync(domainVos, sysUser, list); TjCustomer customer = tjCustomerService.selectTjCustomerByCusId(tjOrder.getUserId()); @@ -1866,6 +1867,7 @@ }*/ return AjaxResult.success("绛剧鎴愬姛锛�"); } else { + remarkService.updateRemark(tjNumber); return getAjaxResult(tjNumber); } } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java index 0ef8cbd..b96b163 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java @@ -143,4 +143,16 @@ @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); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java index 444e9a7..898c6c0 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java @@ -59,4 +59,8 @@ void updateTjOrderRemark(String tjnumber,String proId); void deleteTjOrderDetailByjxbz(String bldh); + + + //淇敼鎸囧畾椤圭洰(蹇冪數鍥剧瓑)鐘舵�� + boolean updateRemark(String tjNum); } diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java index 4095a2b..3f982b5 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java @@ -107,4 +107,9 @@ mapper.deleteTjOrderDetailByjxbz(bldh); } + @Override + public boolean updateRemark(String tjNum) { + return mapper.updateRemark(tjNum); + } + } -- Gitblit v1.8.0