From dfb7b774d9934f4f5b3edf1a39bf73be9c90c55d Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 13 十一月 2020 15:44:57 +0800
Subject: [PATCH] 移出数据表
---
src/menu/actioncomponent/verifyexcelin/customscript/index.jsx | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx b/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx
index 9b8ecee..108bc1d 100644
--- a/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx
+++ b/src/menu/actioncomponent/verifyexcelin/customscript/index.jsx
@@ -154,7 +154,7 @@
param.LText = param.LText.replace(/@\$|\$@/ig, '')
param.LText = Utils.formatOptions(param.LText)
- param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'
+ param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss')
param.secretkey = Utils.encrypt(param.LText, param.timestamp)
this.setState({loading: true})
@@ -202,7 +202,10 @@
fields = fields + ','
}
- _value = `Insert into ${btn.sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From @${btn.sheet}`
+ let database = btn.sheet.match(/(.*)\.(.*)\./ig) || ''
+ let sheet = btn.sheet.replace(/(.*)\.(.*)\./ig, '')
+
+ _value = `Insert into ${database}${sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From @${sheet}`
} else {
_value = value
}
--
Gitblit v1.8.0