From 2c0e07ad097eb692c9909efdc614cc40b8653de2 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 01 四月 2020 14:13:36 +0800
Subject: [PATCH] 2020-04-01
---
src/templates/zshare/createinterface/index.jsx | 18 ++++++++++++------
1 files changed, 12 insertions(+), 6 deletions(-)
diff --git a/src/templates/zshare/createinterface/index.jsx b/src/templates/zshare/createinterface/index.jsx
index 5d0e55b..83fc27c 100644
--- a/src/templates/zshare/createinterface/index.jsx
+++ b/src/templates/zshare/createinterface/index.jsx
@@ -704,10 +704,12 @@
let _fieldValue = [] // 琛ㄥ崟閿�煎field=value
let _value = [] // 琛ㄥ崟鍊硷紝鐢ㄤ簬閿欒鎻愮ず
let _labels = item.fieldlabel.split(',') // 琛ㄥ崟鎻愮ず鏂囧瓧
+ let arr = [] // 楠岃瘉涓婚敭
item.field.split(',').forEach((_field, index) => {
_fieldValue.push(`${_field}=@${_field}@`)
_value.push(`${_labels[index] || ''}锛�'+@${_field}@+'`)
+ arr.push(_field.toLowerCase())
})
let _verifyType = ''
@@ -715,8 +717,12 @@
_verifyType = ' and deleted=0'
}
+ if (!arr.includes(primaryKey.toLowerCase())) {
+ _fieldValue.push(`${primaryKey} !=@${primaryKey}@`)
+ }
+
_sql += `select @tbid='', @ErrorCode='',@retmsg=''
- select @tbid='X' from ${btn.sql} where ${_fieldValue.join(' and ')} and ${primaryKey} !=@${primaryKey}@${_verifyType}
+ select @tbid='X' from ${btn.sql} where ${_fieldValue.join(' and ')}${_verifyType}
If @tbid!=''
Begin
select @ErrorCode='${item.errorCode}',@retmsg='${_value.join(', ')} 宸插瓨鍦�'
@@ -820,8 +826,8 @@
receiptKeys.push(item.key.toLowerCase())
})
- if (!receiptKeys.includes(primaryKey)) {
- receiptKeys.push(primaryKey)
+ if (!receiptKeys.includes(primaryKey.toLowerCase())) {
+ receiptKeys.push(primaryKey.toLowerCase())
}
if (!receiptKeys.includes('bid') && BID) {
@@ -842,8 +848,8 @@
values.push('@' + item.key + '@')
})
- if (!keys.includes(primaryKey)) {
- keys.push(primaryKey)
+ if (!keys.includes(primaryKey.toLowerCase())) {
+ keys.push(primaryKey.toLowerCase())
values.push(`@${primaryKey}@`)
}
@@ -947,7 +953,7 @@
_sql += `
aaa: select @ErrorCode as ErrorCode,@retmsg as retmsg,'${_ltext}' as Ltext`
- console.log(_sql)
+
return _sql
}
--
Gitblit v1.8.0