From 072de941dc14eca12ffa90f2630bbbaeca542f98 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 14 四月 2025 17:19:50 +0800
Subject: [PATCH] Merge branch 'positec' into dms
---
src/utils/utils-custom.js | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 54 insertions(+), 2 deletions(-)
diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js
index 5c4b811..d51b230 100644
--- a/src/utils/utils-custom.js
+++ b/src/utils/utils-custom.js
@@ -2474,8 +2474,9 @@
let filterSql = (sl) => {
if (!sl) return
+ let _sl = sl.replace(/\/\*[^*/]+\*\//g, '')
let cutreg = /[\u4E00-\u9FA5銆傦紒锛屻�乚+/ig
- let tbs = sl.match(cutreg)
+ let tbs = _sl.match(cutreg)
if (!tbs) return
@@ -2790,11 +2791,32 @@
}
}
+ let getuuid = () => {
+ let uuid = []
+ let _options = '0123456789abcdefghigklmnopqrstuv'
+ for (let i = 0; i < 19; i++) {
+ uuid.push(_options.substr(Math.floor(Math.random() * 0x20), 1))
+ }
+ return uuid.join('')
+ }
+
let filterSql = (sl) => {
if (!sl) return
+ let arr = []
+
+ sl = sl.replace(/\/\*[^*/]+\*\//g, (word) => {
+ let uuid = getuuid()
+ arr.push({id: `/*${uuid}*/`, value: word})
+ return `/*${uuid}*/`
+ })
+
regs.forEach(item => {
sl = sl.replace(item.reg, item.value)
+ })
+
+ arr.forEach(item => {
+ sl = sl.replace(item.id, item.value)
})
return sl
@@ -3933,6 +3955,30 @@
// 鍞竴鎬ч獙璇侊紝蹇呴』瀛樺湪琛ㄥ崟锛堣〃鍗曞瓨鍦ㄦ椂锛屼富閿潎涓哄崟鍊硷級,蹇呴』濉啓鏁版嵁婧愶紝澶氳鎷兼帴鏃朵笉鍙敤
if (formdata && verify.uniques && verify.uniques.length > 0 && btn.Ot !== 'requiredOnce') {
+ let nFields = []
+ let dataFields = []
+ formdata.forEach(form => {
+ let _key = form.key.toLowerCase()
+ if (form.type === 'number' || form.type === 'rate') {
+ nFields.push(_key)
+ } else if (form.type === 'date') {
+ dataFields.push(_key)
+ }
+ })
+ if (columns && columns.length > 0 && btn.Ot !== 'notRequired') {
+ columns.forEach(col => {
+ let _key = col.field.toLowerCase()
+ if (col.type === 'number') {
+ if (!nFields.includes(_key)) {
+ nFields.push(_key)
+ }
+ } else if (/^date/ig.test(col.datatype)) {
+ if (!dataFields.includes(_key)) {
+ dataFields.push(_key)
+ }
+ }
+ })
+ }
verify.uniques.forEach(item => {
let _fieldValue = [] // 琛ㄥ崟閿�煎field=value
let _value = [] // 琛ㄥ崟鍊硷紝鐢ㄤ簬閿欒鎻愮ず
@@ -3958,7 +4004,13 @@
_val2 = `' + ${BID} + '`
} else {
// _val2 = `@mk_${_key}_mk@`
- _val2 = `' + @${_field} + '`
+ if (nFields.includes(_key)) {
+ _val2 = `' + cast (@${_field} as nvarchar(50)) + '`
+ } else if (dataFields.includes(_key)) {
+ _val2 = `' + CONVERT(nvarchar(50), @${_field}, 23) + '`
+ } else {
+ _val2 = `' + @${_field} + '`
+ }
}
_value.push(`${_labels[index] || ''}锛�${_val2}`)
--
Gitblit v1.8.0