From ca3737b6e1b379bd2a68c8b2d97996c5a03eb96a Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期一, 31 三月 2025 16:45:47 +0800 Subject: [PATCH] 2025-03-31 --- src/utils/utils-custom.js | 55 +++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 45 insertions(+), 10 deletions(-) diff --git a/src/utils/utils-custom.js b/src/utils/utils-custom.js index dc7f0de..93edd21 100644 --- a/src/utils/utils-custom.js +++ b/src/utils/utils-custom.js @@ -1983,15 +1983,20 @@ if (cell.OpenType === 'form' && cell.formType === 'count_line') return - if (cell.intertype === 'system') { - // if (cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) { - // errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`}) - // } - } else if (cell.intertype === 'custom' || cell.intertype === 'outer') { - if (cell.callbackType === 'script' && (!cell.verify || !cell.verify.cbScripts || cell.verify.cbScripts.filter(item => item.status !== 'false').length === 0)) { - errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鑷畾涔夎剼鏈洖璋冿紝鍥炶皟鑴氭湰涓嶅彲涓虹┖锛乣}) - // } else if (cell.procMode === 'system' && cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) { - // errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`}) + // if (cell.intertype === 'system') { + // // if (cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) { + // // errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`}) + // // } + // } else if (cell.intertype === 'custom' || cell.intertype === 'outer') { + // if (cell.callbackType === 'script' && (!cell.verify || !cell.verify.cbScripts || cell.verify.cbScripts.filter(item => item.status !== 'false').length === 0)) { + // errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鑷畾涔夎剼鏈洖璋冿紝鍥炶皟鑴氭湰涓嶅彲涓虹┖锛乣}) + // // } else if (cell.procMode === 'system' && cell.Ot === 'notRequired' && cell.verify && cell.verify.voucher && cell.verify.voucher.enabled) { + // // errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鍒涘缓鍑瘉鍑芥暟锛岄渶瑕侀�夋嫨琛岋紒`}) + // } + // } + if ((cell.intertype === 'custom' || cell.intertype === 'outer') && cell.callbackType === 'script') { + if (!cell.verify || !cell.verify.cbScripts) { + errors.push({ level: 0, detail: `鎸夐挳鈥�${cell.label}鈥濅娇鐢ㄤ簡鑷畾涔夎剼鏈洖璋冿紝璇疯缃獙璇佷俊鎭紒`}) } } } else if (cell.OpenType === 'funcbutton') { @@ -3928,6 +3933,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 = [] // 琛ㄥ崟鍊硷紝鐢ㄤ簬閿欒鎻愮ず @@ -3953,7 +3982,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