From 3ca91a731665962918a026f521c556f4745ebf35 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期一, 16 十一月 2020 19:20:19 +0800 Subject: [PATCH] 2020-11-16 --- 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