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