From 3d757498c352c7a3fed8c5418eef518356fc92ba Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期一, 09 五月 2022 10:54:27 +0800
Subject: [PATCH] 优化编译错误
---
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