From 7a6874905fa9c6cec03040b29c455db7e81fb22e Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 01 十二月 2023 16:04:50 +0800
Subject: [PATCH] 2023-12-01

---
 src/utils/utils.js |   13 +++++++++++--
 1 files changed, 11 insertions(+), 2 deletions(-)

diff --git a/src/utils/utils.js b/src/utils/utils.js
index 438788a..6754540 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -1118,10 +1118,19 @@
 
     let _insert = ''
     if (btn.default !== 'false') {
+      let _fields = []
+      btn.columns.forEach(col => {
+        if (col.import === 'false' || col.import === 'init') return
+
+        _fields.push(col.Column)
+      })
+
+      _fields = _fields.join(',')
+
       _insert = `
       /* 榛樿sql */
-      Insert into ${database}${sheet} (${fields},createuserid,createuser,createstaff,bid) 
-      Select ${fields},'${sessionStorage.getItem('UserID') || ''}',@username,@fullname,'${BID}' From #${sheet}
+      Insert into ${database}${sheet} (${_fields},createuserid,createuser,createstaff,bid) 
+      Select ${_fields},'${sessionStorage.getItem('UserID') || ''}',@username,@fullname,'${BID}' From #${sheet}
       `
     }
 

--
Gitblit v1.8.0