From 0011ec870d3d1fe9d77a4941358c84acf8632e5e Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 18 五月 2022 22:51:51 +0800 Subject: [PATCH] 2022-05-18 --- src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx | 14 +++++++++++--- 1 files changed, 11 insertions(+), 3 deletions(-) diff --git a/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx b/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx index 1389b88..90f73ad 100644 --- a/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx +++ b/src/templates/sharecomponent/actioncomponent/verifyexcelin/customscript/index.jsx @@ -12,7 +12,6 @@ class CustomForm extends Component { static propTpyes = { - dict: PropTypes.object, // 瀛楀吀椤� btn: PropTypes.object, // 鎸夐挳淇℃伅 scripts: PropTypes.array, // 鑷畾涔夎剼鏈垪琛� usefulfields: PropTypes.any, // 鍙敤瀛楁 @@ -44,7 +43,13 @@ fields.push('jskey') - let _sql = `Declare @${btn.sheet} table (${columns.map(item => item.Column + ' ' + item.type).join(',')},jskey nvarchar(50) ) + let _dec = columns.map(item => item.Column + ' ' + item.type).join(',') + + if (_dec) { + _dec += ',' + } + + let _sql = `Declare @${btn.sheet} table (${_dec}jskey nvarchar(50) ) Declare @UserName nvarchar(50),@FullName nvarchar(50),@RoleID nvarchar(512),@mk_departmentcode nvarchar(50),@mk_organization nvarchar(50),@login_city nvarchar(50),@ErrorCode nvarchar(50), @retmsg nvarchar(4000),@tbid Nvarchar(512) Select @ErrorCode='', @retmsg='' ` @@ -315,6 +320,9 @@ <Select.Option key="default" value={'default'}> 榛樿sql </Select.Option> + <Select.Option key="debugger" value={`z_debug: select @ErrorCode='E',@retmsg='娴嬭瘯鏂偣' goto aaa`}> + 娴嬭瘯鏂偣 + </Select.Option> {systemScripts.map((option, i) => <Select.Option key={i} value={option.value}> {option.name} @@ -338,7 +346,7 @@ rules: [ { required: true, - message: this.props.dict['form.required.input'] + 'sql!' + message: '璇疯緭鍏ql!' } ] })(<CodeMirror />)} -- Gitblit v1.8.0