From f22bb55c4ff50a8a63c795487b057c0cebdae649 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 12 十二月 2019 09:19:58 +0800
Subject: [PATCH] 2019-12-12

---
 src/tabviews/commontable/index.jsx |   13 +++++++++----
 1 files changed, 9 insertions(+), 4 deletions(-)

diff --git a/src/tabviews/commontable/index.jsx b/src/tabviews/commontable/index.jsx
index 41ca634..31a4806 100644
--- a/src/tabviews/commontable/index.jsx
+++ b/src/tabviews/commontable/index.jsx
@@ -127,7 +127,7 @@
         columns: _columns,
         arr_field: _arrField.join(','),
         search: _search ? 'where (' + _search + ')' : '',
-        orderColumn: config.setting.orderColumn,
+        // orderColumn: config.setting.orderColumn,
         loading: true
       }, () => {
         this.improveSearch()
@@ -255,16 +255,19 @@
 
   async loadmaindata () {
     const { arr_field, pageIndex, pageSize, orderColumn, orderType, search, setting } = this.state
+    console.log(setting)
     // 鑾峰彇鍒楄〃鏁版嵁
     let param = {
-      func: 'sPC_Get_TableData',
+      func: setting.innerFunc || 'sPC_Get_TableData',
       obj_name: 'data',
       arr_field: arr_field
     }
 
-    let LText = `select top ${pageSize} ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${orderColumn} ${orderType}) as rows from ${setting.dataresource} ${search}) tmptable where rows > ${pageSize * (pageIndex - 1)} order by tmptable.rows`
-    let DateCount = `select count(1) as total from ${setting.dataresource} ${search}`
+    let orderBy = orderColumn ? (orderColumn + ' ' + orderType) : setting.order
 
+    let LText = `select top ${pageSize} ${arr_field} from (select ${arr_field} ,ROW_NUMBER() over(order by ${orderBy}) as rows from ${setting.dataresource} ${search}) tmptable where rows > ${pageSize * (pageIndex - 1)} order by tmptable.rows`
+    let DateCount = `select count(1) as total from ${setting.dataresource} ${search}`
+    console.log(LText)
     param.LText = Utils.formatOptions(LText)
     param.timestamp = moment().format('YYYY-MM-DD HH:mm:ss') + '.000'
     param.secretkey = Utils.encrypt(param.LText, param.timestamp)
@@ -359,6 +362,8 @@
   UNSAFE_componentWillMount () {
     // 缁勪欢鍔犺浇鏃讹紝鑾峰彇鑿滃崟鏁版嵁
     this.loadconfig()
+
+    console.log(Utils.getfunc())
   }
 
   shouldComponentUpdate (nextProps, nextState) {

--
Gitblit v1.8.0