From 12560372988b49cc9465e92c32d852db2d0e8612 Mon Sep 17 00:00:00 2001
From: fs-danaus <danaus314@qq.com>
Date: 星期一, 14 十一月 2022 11:42:30 +0800
Subject: [PATCH] 处理保存时脚本顺序，先主表后从表
---
src/com/yc/service/grid/GridServiceImpl.java | 32 ++++++++++++++------------------
1 files changed, 14 insertions(+), 18 deletions(-)
diff --git a/src/com/yc/service/grid/GridServiceImpl.java b/src/com/yc/service/grid/GridServiceImpl.java
index 4021f2e..9fc5c58 100644
--- a/src/com/yc/service/grid/GridServiceImpl.java
+++ b/src/com/yc/service/grid/GridServiceImpl.java
@@ -502,40 +502,36 @@
return info;
}
- int in = parameterObject.getInsertsql().size();
- int up = parameterObject.getUpdatesql().size();
+
+ int in = parameterObject.getDetailSql().size();
+ int up = parameterObject.getHeadSql().size();
int de = parameterObject.getDel().size();
int to = parameterObject.getTotalProc().size();
String[] list = new String[in + up + de];
- String[] toBeStored = parameterObject.getInsertsql().toArray(new String[in]);
- String[] toBeStored1 = parameterObject.getUpdatesql().toArray(new String[up]);
+ String[] toBeStored = parameterObject.getHeadSql().toArray(new String[in]);
+ String[] toBeStored1 = parameterObject.getDetailSql().toArray(new String[up]);
String[] toBeStored_p = parameterObject.getTotalProc().toArray(new String[to]);
String[] toBeStored2 = parameterObject.getDel().toArray(new String[de]);
- // 1-------鏂板鏁版嵁
- if (in > 0) {
- System.arraycopy(toBeStored, 0, list, 0, in);
+ // 1-------琛ㄥご鏁版嵁
+ if (up > 0) {
+ System.arraycopy(toBeStored, 0, list, 0, up);
}
- // 2----------鏇存柊鏁版嵁
- if (up > 0) {
- System.arraycopy(toBeStored1, 0, list, in, up);
+ // 2----------琛ㄤ綋鏁版嵁
+ if (in > 0) {
+ System.arraycopy(toBeStored1, 0, list, up, in);
}
// 3----------鍒犻櫎鏁版嵁
if (de > 0) {
- System.arraycopy(toBeStored2, 0, list, in + up, de);
+ System.arraycopy(toBeStored2, 0, list, up + in, de);
}
- int[] count = null;
- // if(list.length>0)
- // this.jdbcTemplate.batchUpdate(list);//鎵归噺鏇存柊鏁版嵁
- //
// 鎻愪氦鏁版嵁
- for (String str : list)
+ for (String str : list) {
sql.append(str).append(" \n");
-
+ }
// 鏈夊垹闄ゅ浘鐗囩殑鍦ㄨ繖閲屾墽琛�
if (picList.size() > 0) {
-
for (PicEntity picEntity : picList) {
String uuid = null;
String[] splt = null;
--
Gitblit v1.8.0