From 5e10a7ee4a5ef882d6b0d92b19b1a888ffcc6f7f Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 14 四月 2020 11:55:03 +0800
Subject: [PATCH] 2020-04-14

---
 src/templates/zshare/verifycardexcelin/customscript/index.jsx |    9 +++++++--
 1 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/src/templates/zshare/verifycardexcelin/customscript/index.jsx b/src/templates/zshare/verifycardexcelin/customscript/index.jsx
index 51513c3..c1fa819 100644
--- a/src/templates/zshare/verifycardexcelin/customscript/index.jsx
+++ b/src/templates/zshare/verifycardexcelin/customscript/index.jsx
@@ -38,7 +38,8 @@
     }
 
     let _sql = `Declare @${btn.sheet} table (${usefulfields.map(item => item.Column + ' ' + item.type).join(',')},jskey nvarchar(50) )
-      Declare @UserName nvarchar(50),@FullName nvarchar(50)
+      Declare @UserName nvarchar(50),@FullName nvarchar(50),@ErrorCode nvarchar(50), @retmsg nvarchar(4000)
+      Select @ErrorCode='', @retmsg=''
     `
     
     this.setState({
@@ -121,9 +122,13 @@
           return
         }
 
+        let tail = `
+          aaa:
+        `
+
         let param = {
           func: 's_debug_sql',
-          LText: this.state.verifySql + values.sql
+          LText: this.state.verifySql + values.sql + tail
         }
         param.LText = Utils.formatOptions(param.LText)
         param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'

--
Gitblit v1.8.0