From 1e4a2c74f6782a1f1e3d745830948f3255871f61 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 30 十一月 2021 21:08:49 +0800
Subject: [PATCH] 2021-11-30

---
 src/tabviews/zshare/topSearch/index.jsx |   43 +++++++++++++++++++++++++++++++++++++++----
 1 files changed, 39 insertions(+), 4 deletions(-)

diff --git a/src/tabviews/zshare/topSearch/index.jsx b/src/tabviews/zshare/topSearch/index.jsx
index 4a2ad50..cbb6432 100644
--- a/src/tabviews/zshare/topSearch/index.jsx
+++ b/src/tabviews/zshare/topSearch/index.jsx
@@ -520,9 +520,16 @@
       this.props.form.validateFields((err, values) => {
         if (err) return
   
-        let searches = this.getFieldsValues(values)
+        let { searches, error } = this.getFieldsValues(values)
   
-        if (this.state.hasReqFields) {
+        if (error) {
+          notification.warning({
+            top: 92,
+            message: error,
+            duration: 3
+          })
+          return
+        } else if (this.state.hasReqFields) {
           let requireFields = searches.filter(item => item.required && item.value === '')
           if (requireFields.length > 0) {
             let labels = requireFields.map(item => item.label)
@@ -580,6 +587,7 @@
 
     // 鑾峰彇鎼滅储鏉′欢鍊�
     let search = []
+    let error = null
     searchlist.forEach(item => {
       if (item.type === 'group') {
         search.push({
@@ -601,10 +609,37 @@
         })
       } else {
         let type = item.type
+        let val = values[item.field] !== undefined ? values[item.field] : ''
+
         if (type === 'multiselect' || (type === 'checkcard' && item.multiple === 'true')) {
           type = 'multi'
+        } else if (type === 'text' && !error) {
+          if (/'/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鑻辨枃鐘舵�佺殑鍗曞紩鍙枫�俙
+          } else if (/(^|\s)select\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梥elect銆俙
+          } else if (/\sfrom(\s|\()/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梖rom銆俙
+          } else if (/(^|\s)insert\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梚nsert銆俙
+          } else if (/(^|\s)delete\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梔elete銆俙
+          } else if (/(^|\s)update\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梪pdate銆俙
+          } else if (/(^|\s)where\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梬here銆俙
+          } else if (/(^|\s)drop\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梔rop銆俙
+          } else if (/(^|\s)exec\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梕xec銆俙
+          } else if (/(^|\s)truncate\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梩runcate銆俙
+          } else if (/(^|\s)while\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梬hile銆俙
+          } else if (/(^|\s)for\s/ig.test(val)) {
+            error = `鎼滅储鏉′欢${item.label}涓紝涓嶅彲浣跨敤鍏抽敭瀛梖or銆俙
+          }
         }
-        let val = values[item.field] !== undefined ? values[item.field] : ''
 
         if (typeof(val) === 'string') {
           val = val.replace(/(^\s*|\s*$)/ig, '')
@@ -622,7 +657,7 @@
       }
     })
 
-    return search
+    return {searches: search, error}
   }
 
   handleOk = (values) => {

--
Gitblit v1.8.0