From c2773a079c44f9a7022fb6f839d33371e4802cfe Mon Sep 17 00:00:00 2001
From: java110 <928255095@qq.com>
Date: 星期二, 15 三月 2022 09:13:24 +0800
Subject: [PATCH] 优化b_id 为空问题
---
service-order/src/main/java/com/java110/order/smo/impl/AsynNotifySubServiceImpl.java | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/service-order/src/main/java/com/java110/order/smo/impl/AsynNotifySubServiceImpl.java b/service-order/src/main/java/com/java110/order/smo/impl/AsynNotifySubServiceImpl.java
index 1a8973e..22630f5 100644
--- a/service-order/src/main/java/com/java110/order/smo/impl/AsynNotifySubServiceImpl.java
+++ b/service-order/src/main/java/com/java110/order/smo/impl/AsynNotifySubServiceImpl.java
@@ -204,14 +204,19 @@
private JSONArray generateBusinessInsertInsertSql(OrderItemDto orderItemDto, BusinessTableHisDto businessTableHisDto) {
JSONArray params = new JSONArray();
JSONObject param = null;
+ JSONObject updateParam = null;
String sql = "";
+ String updateSql = "";
String logText = orderItemDto.getLogText();
JSONObject logTextObj = JSONObject.parseObject(logText);
JSONArray afterValues = logTextObj.getJSONArray("afterValue");
for (int afterValueIndex = 0; afterValueIndex < afterValues.size(); afterValueIndex++) {
sql = "insert into " + businessTableHisDto.getActionObjHis() + " ";
+ updateSql = "update " + businessTableHisDto.getActionObj() +" set b_id='"+orderItemDto.getbId()+"' where 1=1 ";
+
param = new JSONObject();
+ updateParam = new JSONObject();
JSONObject keyValue = afterValues.getJSONObject(afterValueIndex);
if (keyValue.isEmpty()) {
continue;
@@ -224,6 +229,8 @@
}
keySql += (key + ",");
valueSql += (keyValue.getString(key) + ",");
+
+ updateSql += (" and "+key +"=" + keyValue.getString(key));
}
keySql += "operate,b_id";
valueSql += "'ADD','" + orderItemDto.getbId() + "'";
@@ -235,7 +242,9 @@
}
sql = sql + keySql + ") " + valueSql + ") ";
param.put("fallBackSql", sql);
+ updateParam.put("fallBackSql", updateSql);
params.add(param);
+ params.add(updateParam);
}
return params;
--
Gitblit v1.8.0