From 2b84af9bed8f4b7da94a4bb85e7223d3b18e4fcb Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期六, 14 十二月 2019 23:03:26 +0800
Subject: [PATCH] 2019-12-14
---
src/utils/utils.js | 23 +++++++++++++++++------
1 files changed, 17 insertions(+), 6 deletions(-)
diff --git a/src/utils/utils.js b/src/utils/utils.js
index d561d04..d76bdcd 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -330,10 +330,22 @@
*/
static getfunc (param) {
let form = ''
+ let formParam = ''
+
if (param.fields && param.fields.length > 0) {
let _fields = []
param.fields.forEach(item => {
if (item.field) {
+ let type = ''
+ if (item.type.match(/date/ig)) {
+ type = 'datetime is null'
+ } else if (item.type === 'number') {
+ type = `decimal(18,${item.decimal})=0`
+ } else {
+ type = 'nvarchar(50)=\'\''
+ }
+ formParam = formParam + `mchr13k@${item.field} ${type},`
+
_fields.push(item.field)
}
})
@@ -348,18 +360,17 @@
field3 = field3.join(',')
form = `
- insert into ${param.name} (${field1}) select ${field2},@UserID
+ insert into ${param.name} (${field1},createuserid) select ${field2},@UserID
update ${param.name} set ${field3},modifydate=getdate(),modifyuserid=@UserID
`
}
- let Ltext = `create proc ${param.name}
+ let Ltext = `create proc ${param.funcName}
(
@BID nvarchar(50)='',
- @ID nvarchar(50)='',
- 琛ㄥ崟浼犲��,鏂囨湰鐢╪varchar(50)='',鏃ユ湡鐢╠atetime is null ,鏁板�肩敤decimal(18,灏忔暟鐐逛綅鏁�)=0,
- @sEPTMenuNo='', --浼犺彍鍗曞弬鏁�
+ @ID nvarchar(50)='',${formParam}
+ @sEPTMenuNo nvarchar(50)='${param.menuNo}',
@lang nvarchar(50)='',
@debug nvarchar(50)='',
@LoginUID nvarchar(50)='',
@@ -425,8 +436,8 @@
ROLLBACK TRAN
END`
- Ltext = Ltext.replace(/\n\s{4}/ig, 'mchr13k')
console.log(Ltext)
+ Ltext = Ltext.replace(/\n\s{4}/ig, 'mchr13k')
return Ltext
}
}
\ No newline at end of file
--
Gitblit v1.8.0