From 888095418c902cc94693cba8b45f31bb79cdf818 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期五, 28 二月 2020 01:31:46 +0800
Subject: [PATCH] 2020-02-28
---
src/utils/utils.js | 30 ++++++++++++++++++++++++------
1 files changed, 24 insertions(+), 6 deletions(-)
diff --git a/src/utils/utils.js b/src/utils/utils.js
index 2fa05f9..a5aa2dd 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -1029,8 +1029,14 @@
static getTableFunc (param, menu, config) {
let form = ''
let formParam = ''
+ let _vars = ['bid', 'pageindex', 'pagesize', 'ordercol', 'ordertype', 'exceltype', 'septmenuno', 'lang', 'debug', 'loginuid', 'sessionuid', 'userid', 'errorcode', 'retmsg']
let _columns = []
let primaryKey = config.setting.primaryKey || 'ID'
+
+ if (!_vars.includes(primaryKey.toLowerCase())) {
+ _vars.push(primaryKey.toLowerCase())
+ formParam = `mchr13k@${primaryKey} nvarchar(50)='',`
+ }
if (config.search && config.search.length > 0) {
let _fields = new Map()
@@ -1051,7 +1057,11 @@
}
_fields.set(cell, true)
- formParam = formParam + `mchr13k@${_f} ${type},`
+
+ if (!_vars.includes(_f.toLowerCase())) {
+ _vars.push(_f.toLowerCase())
+ formParam = formParam + `mchr13k@${_f} ${type},`
+ }
})
}
})
@@ -1073,8 +1083,7 @@
let Ltext = `create proc ${param.innerFunc}
( /*${menu.MenuName}*/
- @BID nvarchar(50)='',
- @${primaryKey} nvarchar(50)='',${formParam}
+ @BID nvarchar(50)='',${formParam}
@PageIndex nvarchar(50)='',
@PageSize nvarchar(50)='',
@OrderCol nvarchar(50)='',
@@ -1159,8 +1168,14 @@
static getfunc (param, btn, menu, config) {
let form = ''
let formParam = ''
+ let _vars = ['bid', 'septmenuno', 'lang', 'debug', 'loginuid', 'sessionuid', 'userid', 'errorcode', 'retmsg']
let columns = config.columns
let primaryKey = config.setting.primaryKey || 'ID'
+
+ if (!_vars.includes(primaryKey.toLowerCase())) {
+ _vars.push(primaryKey.toLowerCase())
+ formParam = `mchr13k@${primaryKey} nvarchar(50)='',`
+ }
if (param.fields && param.fields.length > 0) {
let _fields = []
@@ -1174,7 +1189,11 @@
} else {
type = 'nvarchar(50)=\'\''
}
- formParam = formParam + `mchr13k@${item.field} ${type},`
+
+ if (!_vars.includes(item.field.toLowerCase())) {
+ _vars.push(item.field.toLowerCase())
+ formParam = formParam + `mchr13k@${item.field} ${type},`
+ }
_fields.push(item.field)
}
@@ -1223,8 +1242,7 @@
let Ltext = `create proc ${param.funcName}
( /*${menu.MenuName} ${btn.label}*/
- @BID nvarchar(50)='',
- @${primaryKey} nvarchar(50)='',${formParam}
+ @BID nvarchar(50)='',${formParam}
@sEPTMenuNo nvarchar(50)='${param.menuNo}',
@lang nvarchar(50)='',
@debug nvarchar(50)='',
--
Gitblit v1.8.0