From 790dfe8172be5027940a04594224531d15143389 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期四, 12 十二月 2019 19:30:30 +0800
Subject: [PATCH] 2019-12-12
---
src/utils/utils.js | 38 +++++++++++++++++++++++++++++---------
1 files changed, 29 insertions(+), 9 deletions(-)
diff --git a/src/utils/utils.js b/src/utils/utils.js
index dd60cbb..1102b7c 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -302,7 +302,7 @@
* @return {String} name 瀛樺偍杩囩▼鍚嶇О
*/
static dropfunc (name) {
- return `IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('${name}') AND type in (N'P', N'PC')) DROP PROCEDURE ${name}`
+ return `IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('${name}') AND type in (N'P', N'PC')) mdrpk PROCEDURE ${name}`
}
/**
@@ -310,9 +310,31 @@
* @return {String}
*/
static getfunc (param) {
- param = {
- name: 'ls'
+ let form = ''
+ if (param.fields && param.fields.length > 0) {
+ let _fields = []
+ param.fields.forEach(item => {
+ if (item.field) {
+ _fields.push(item.field)
+ }
+ })
+
+ let field1 = _fields.join(',')
+ let field2 = _fields.join(',@')
+ let field3 = _fields.map(cell => {
+ return cell + '=@' + cell
+ })
+
+ field2 = field2 ? '@' + field2 : ''
+ field3 = field3.join(',')
+
+ form = `
+ insert into ${param.name} (${field1}) select ${field2},@UserID
+
+ update ${param.name} set ${field3},modifydate=getdate(),modifyuserid=@UserID
+ `
}
+
let Ltext = `create proc ${param.name}
(
@BID nvarchar(50)='',
@@ -344,11 +366,7 @@
declare @UserName nvarchar(50),@FullName nvarchar(50)
select @UserName=UserName,@FullName=FullName from SUsers where UID=@UserID
-
- insert into 琛ㄥ悕 (琛ㄥ崟瀛楁) select 瀵瑰簲鍏ュ弬锛屽垱寤轰汉
-
- update 琛ㄥ悕 set 琛ㄥ崟瀛楁=瀵瑰簲鍏ュ弬,modifydate=getdate(),modifyuserid=@UserID
-
+ ${form}
if 1=2
begin
set @ErrorCode='E'
@@ -388,6 +406,8 @@
ROLLBACK TRAN
END`
- return Ltext.replace(/\n\s{4}/ig, '\'char(13)\'')
+ Ltext = Ltext.replace(/\n\s{4}/ig, 'mchr13k')
+ console.log(Ltext)
+ return Ltext
}
}
\ No newline at end of file
--
Gitblit v1.8.0