From e771ba19739b537526ddb9a6fb2499b58a45a8ab Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期二, 07 七月 2020 11:47:56 +0800 Subject: [PATCH] 2020-07-07 --- src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx | 9 ++++++--- 1 files changed, 6 insertions(+), 3 deletions(-) diff --git a/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx b/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx index 01ddd1f..5a50093 100644 --- a/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx +++ b/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx @@ -38,7 +38,7 @@ } let _sql = `Declare @${btn.sheet} table (${usefulfields.map(item => item.Column + ' ' + item.type).join(',')},jskey nvarchar(50) ) - Declare @UserName nvarchar(50),@FullName nvarchar(50),@ErrorCode nvarchar(50), @retmsg nvarchar(4000) + Declare @UserName nvarchar(50),@FullName nvarchar(50),@ErrorCode nvarchar(50), @retmsg nvarchar(4000),@tbid Nvarchar(512) Select @ErrorCode='', @retmsg='' ` @@ -125,6 +125,9 @@ func: 's_debug_sql', LText: this.state.verifySql + _initsql + values.sql + tail } + + param.LText = param.LText.replace(/@\$|\$@/ig, '') + param.LText = Utils.formatOptions(param.LText) param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000' param.secretkey = Utils.encrypt(param.LText, param.timestamp) @@ -174,7 +177,7 @@ fields = fields + ',' } - _value = `Insert into ${btn.sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid,@username,@fullname,@BID From @${btn.sheet}` + _value = `Insert into ${btn.sheet} (${fields}createuserid,createuser,createstaff,bid)\nSelect ${fields}@userid@,@username,@fullname,@BID@ From @${btn.sheet}` } else { _value = value } @@ -238,7 +241,7 @@ </Tooltip> }> {getFieldDecorator('position', { - initialValue: 'back' + initialValue: 'front' })( <Radio.Group> <Radio value="init">鍒濆鍖�</Radio> -- Gitblit v1.8.0