From 5944c2832820a8bfa86e3efb5085f5a2463897f9 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期二, 22 九月 2020 09:14:49 +0800
Subject: [PATCH] 2020-09-22
---
src/utils/utils-datamanage.js | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/src/utils/utils-datamanage.js b/src/utils/utils-datamanage.js
index ebfef57..15e098a 100644
--- a/src/utils/utils-datamanage.js
+++ b/src/utils/utils-datamanage.js
@@ -187,7 +187,7 @@
/**
* @description 鑾峰彇绯荤粺瀛樺偍杩囩▼ sPC_Get_TableData 鍚堣鍊肩殑鍙傛暟
*/
- static getStatQueryDataParams (setting, statFields, search, orderBy, pageIndex, pageSize, menuType, dataManager) {
+ static getStatQueryDataParams (setting, statFields, search, orderBy, BID, menuType, dataManager) {
let param = {
func: 'sPC_Get_TableData',
obj_name: 'data',
@@ -243,7 +243,7 @@
})
}
- let LText = ` select ${statFields.map(col => `sum(${col.field}) as ${col.field}`).join(',')} from ${_dataresource} ${_search} `
+ let LText = ` select ${statFields.map(col => `isnull(sum(${col.field}),0) as ${col.field}`).join(',')} from ${_dataresource} ${_search} `
if (_customScript) {
LText = `${LText}
@@ -269,6 +269,10 @@
param.open_key = Utils.encryptOpenKey(param.secretkey, param.timestamp)
}
+ if (BID) {
+ param.BID = BID
+ }
+
// 鏁版嵁绠＄悊鏉冮檺
if (dataManager) {
param.dataM = 'Y'
--
Gitblit v1.8.0