From 110b028e0cb54d9f50d57d1e1efd9d9bf9a8388e Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期日, 22 十月 2023 16:05:21 +0800
Subject: [PATCH] 2023-10-22

---
 src/tabviews/custom/components/form/tab-form/index.jsx    |    6 ++++++
 src/menu/datasource/verifycard/utils.jsx                  |    4 +++-
 src/api/index.js                                          |    2 ++
 src/tabviews/custom/components/form/step-form/index.jsx   |    6 ++++++
 src/tabviews/custom/components/form/simple-form/index.jsx |    6 ++++++
 5 files changed, 23 insertions(+), 1 deletions(-)

diff --git a/src/api/index.js b/src/api/index.js
index 13d385b..d602b0a 100644
--- a/src/api/index.js
+++ b/src/api/index.js
@@ -1099,6 +1099,8 @@
         clearTimeout(timer)
         if (/Shared Memory Provider|浼氳瘽澶勪簬缁堟鐘舵�亅褰撳墠鍛戒护鍙戠敓浜嗕弗閲嶉敊璇�/.test(res.message)) {
           res.message = '楠岃瘉澶辫触锛岃妫�鏌QL涓槸鍚﹀瓨鍦ㄦ寰幆銆�'
+        } else if (res.message === 'ROLLBACK TRANSACTION 璇锋眰娌℃湁瀵瑰簲鐨� BEGIN TRANSACTION銆� EXECUTE 鍚庣殑浜嬪姟璁℃暟鎸囩ず BEGIN 鍜� COMMIT 璇彞鐨勬暟鐩笉鍖归厤銆備笂涓�璁℃暟 = 1锛屽綋鍓嶈鏁� = 0銆� ROLLBACK TRANSACTION 璇锋眰娌℃湁瀵瑰簲鐨� BEGIN TRANSACTION銆�') {
+          res.ErrCode = '-2'
         }
         resolve(res)
       }, () => {
diff --git a/src/menu/datasource/verifycard/utils.jsx b/src/menu/datasource/verifycard/utils.jsx
index d2d224a..2a79dee 100644
--- a/src/menu/datasource/verifycard/utils.jsx
+++ b/src/menu/datasource/verifycard/utils.jsx
@@ -133,8 +133,10 @@
     if (_dataresource) {
       if (custompage) {
         _dataresource = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search}`
+      } else if (setting.laypage === 'true' && setting.order) {
+        _dataresource = `/*system_query*/select top 10 ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${setting.order}) as rows from ${_dataresource} ${_search}) tmptable where rows > 0 order by tmptable.rows`
       } else if (setting.order) {
-        _dataresource = `/*system_query*/select${setting.laypage === 'true' ?  ' top 10' : ''} ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${setting.order}) as rows from ${_dataresource} ${_search}) tmptable ${setting.laypage === 'true' ?  'where rows > 0' : ''} order by tmptable.rows`
+        _dataresource = `/*system_query*/select ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${setting.order}) as rows from ${_dataresource} ${_search}) tmptable order by tmptable.rows`
       } else {
         _dataresource = `/*system_query*/select ${arr_field} from ${_dataresource} ${_search}`
       }
diff --git a/src/tabviews/custom/components/form/simple-form/index.jsx b/src/tabviews/custom/components/form/simple-form/index.jsx
index 5b3c32c..4491894 100644
--- a/src/tabviews/custom/components/form/simple-form/index.jsx
+++ b/src/tabviews/custom/components/form/simple-form/index.jsx
@@ -169,6 +169,12 @@
 
     if ((position === 'mainline' || position === 'popclose') && config.setting.supModule && BID) {
       MKEmitter.emit('reloadData', config.setting.supModule, BID)
+    } else if (position === 'grid' && config.wrap.datatype === 'static') {
+      this.setState({
+        data: null
+      }, () => {
+        this.setState({data: {$$empty: true}})
+      })
     } else {
       this.loadData()
     }
diff --git a/src/tabviews/custom/components/form/step-form/index.jsx b/src/tabviews/custom/components/form/step-form/index.jsx
index 895ff53..0ef5907 100644
--- a/src/tabviews/custom/components/form/step-form/index.jsx
+++ b/src/tabviews/custom/components/form/step-form/index.jsx
@@ -218,6 +218,12 @@
 
     if ((position === 'mainline' || position === 'popclose') && config.setting.supModule && BID) {
       MKEmitter.emit('reloadData', config.setting.supModule, BID)
+    } else if (position === 'grid' && config.wrap.datatype === 'static') {
+      this.setState({
+        data: null
+      }, () => {
+        this.setState({data: {$$empty: true}})
+      })
     } else {
       this.loadData()
     }
diff --git a/src/tabviews/custom/components/form/tab-form/index.jsx b/src/tabviews/custom/components/form/tab-form/index.jsx
index 01a21ed..7151d62 100644
--- a/src/tabviews/custom/components/form/tab-form/index.jsx
+++ b/src/tabviews/custom/components/form/tab-form/index.jsx
@@ -184,6 +184,12 @@
 
     if ((position === 'mainline' || position === 'popclose') && config.setting.supModule && BID) {
       MKEmitter.emit('reloadData', config.setting.supModule, BID)
+    } else if (position === 'grid' && config.wrap.datatype === 'static') {
+      this.setState({
+        data: null
+      }, () => {
+        this.setState({data: {$$empty: true}})
+      })
     } else {
       this.loadData()
     }

--
Gitblit v1.8.0