From 2bccb9ec7bdefe23292a22bc153463cfa1479a49 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 21 六月 2024 16:25:42 +0800
Subject: [PATCH] 2024-06-21
---
src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx | 20 +++++++++++++++++---
1 files changed, 17 insertions(+), 3 deletions(-)
diff --git a/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx b/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx
index 59cfe17..f0d8651 100644
--- a/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx
+++ b/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx
@@ -232,11 +232,25 @@
let _value = ''
if (value === 'default') {
- let fields = usefulfields.filter(item => item.import !== 'false')
- fields = fields.map(col => col.Column).join(',')
+ let fields = []
+ let decls = []
+ usefulfields.forEach(col => {
+ if (col.import === 'false') return
+
+ if (col.type === 'date') {
+ decls.push(`${col.Column} Nvarchar(50)`)
+ } else {
+ decls.push(`${col.Column} ${col.type}`)
+ }
+ fields.push(col.Column)
+ })
+
+ decls = decls.join(',')
+ fields = fields.join(',')
if (fields) {
fields = fields + ','
+ decls = decls + ','
}
let database = btn.sheet.match(/(.*)\.(.*)\.|@db@/ig) || ''
@@ -244,7 +258,7 @@
database = database ? (database[0] || '') : ''
- _value = `Insert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From #${sheet}`
+ _value = `/* create table #${sheet} (${decls}jskey nvarchar(50),BID nvarchar(50) ) */\nInsert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From #${sheet}`
} else if (value === 'flowSql') {
let sheet = btn.sheet.replace(/(.*)\.(.*)\.|@db@/ig, '')
--
Gitblit v1.8.0