From c4962d4a0cb4089bcffda90b07da34d666e4bbc2 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期五, 19 七月 2024 18:14:53 +0800
Subject: [PATCH] 查询签名图片字段
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java | 30 ++++++++++++++++++++++++++++++
1 files changed, 30 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 4210147..f244232 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
@@ -127,6 +127,27 @@
boolean saveTjOrderDetailsByCusId(@Param("cusId")String cusId,@Param("orderId")String orderId,@Param("userName")String userName,@Param("userId") String userId);
+ @Insert("\tINSERT INTO tj_order_detail(\n" +
+// "\torder_detail_id,\n" +
+ " order_id,\n" +
+ " pro_id,\n" +
+ " pro_result,\n" +
+ " tj_status,\n" +
+ " create_time,\n" +
+ " create_by,\n" +
+ " is_sampling,\n" +
+ " create_id,\n" +
+ " pro_type) \n" +
+ " \n" +
+ " SELECT #{orderId},a.pro_id,IFNULL(b.pro_default,''),'1',SYSDATE(),#{userName},b.is_sampling,#{userId},IFNULL(a.pac_id,0) FROM tb_transition a LEFT JOIN tj_project b ON a.pro_id=b.pro_id WHERE a.cus_id=#{cusId} \n" +
+ "\t\t\n" +
+ "\tUNION\n" +
+ " \n" +
+ "\tSELECT #{orderId},a.parent_pro_id,IFNULL(b.pro_default,''),'0',SYSDATE(),#{userName},b.is_sampling,#{userId},IFNULL(a.pac_id,0) FROM tb_transition a LEFT JOIN tj_project b ON a.parent_pro_id=b.pro_id WHERE a.cus_id=#{cusId} GROUP BY a.parent_pro_id")
+ boolean saveJSYTjOrderDetailsByCusId(@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" +
@@ -164,4 +185,13 @@
@Select("call pro_lis_sqdbgd(1,#{tjnumber,mode=IN})")
// @Select("select * from test_detail")
List<TjOrderDetail> addHuaYanTable(@Param("tjnumber") String tjnumber);
+
+ @Select("call pro_checkhyAndcg(1,#{tjnumber,mode=IN})")
+ List<TjOrderDetail> addHuaYanAndCgTable(String tjnumber);
+
+
+ @Delete("delete\n" +
+ " from tj_order_detail\n" +
+ " where jxbz = #{jxbz}")
+ void deleteTjOrderDetailByjxbz(String jxbz);
}
--
Gitblit v1.8.0