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