From 3fbed744dae198ae9743f21a611e9e1ff096e0be Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 23 一月 2024 10:36:33 +0800
Subject: [PATCH] zjh 2024/01/23--1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java
index 9c13671..acae5da 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java
@@ -126,6 +126,22 @@
boolean saveTjOrderDetailsByCusId(@Param("cusId")String cusId,@Param("orderId")String orderId,@Param("userName")String userName,@Param("userId") String userId);
+ @Insert("INSERT INTO tj_pure_tone_test (\n" +
+ " tj_num,\n" +
+ "\tcus_id,\n" +
+ "\tcus_name,\n" +
+ "\tpro_id,\n" +
+ "\tpro_name,\n" +
+ "\tcreate_by,\n" +
+ "\tcreate_time,\n" +
+ "\tcreate_id\n" +
+ ")\n" +
+ "SELECT #{tjNum},b.cus_id,b.cus_name,'1633660948860522619','绾煶鍚槇'," +
+ "#{userName},SYSDATE(),#{userId} FROM tb_transition a LEFT JOIN tj_customer b " +
+ "ON a.cus_id=b.cus_idcard WHERE a.cus_id=#{cusId} AND a.parent_pro_id IN('1633660948860522619') GROUP BY a.cus_id")
+ boolean saveTjPureToneTesByCusId(String cusId,String tjNum,String userName, String userId);
+
+
@Update("UPDATE tj_order_detail a SET\n" +
"a.flowing_water_id=#{ls} ,\n" +
"a.update_time=SYSDATE(),\n" +
--
Gitblit v1.8.0