From 2d3f82c3e07e6acaedbeae8b4ce0849dd588abc6 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期三, 29 七月 2020 10:09:32 +0800
Subject: [PATCH] 2020-07-29
---
src/utils/utils.js | 10 ++++++----
1 files changed, 6 insertions(+), 4 deletions(-)
diff --git a/src/utils/utils.js b/src/utils/utils.js
index c2cc84f..3d0e29e 100644
--- a/src/utils/utils.js
+++ b/src/utils/utils.js
@@ -705,7 +705,7 @@
* @return {String} btn 鎸夐挳
* @return {String} data excel鏁版嵁
*/
- static getExcelInSql (item, data, dict) {
+ static getExcelInSql (item, data, dict, BID) {
let btn = item.verify
let keys = ['delete', 'drop', 'insert', 'truncate', 'update']
let userName = sessionStorage.getItem('User_Name') || ''
@@ -840,9 +840,11 @@
_lineIndex = _lineIndex.substring(_lineIndex.length - 6)
vals.push(`'${upId + _lineIndex}'`)
+ vals.push(`'${BID}'`)
if (lindex < 40) {
convals.push(`'${upId + _lineIndex}' as jskey`)
+ convals.push(`'${BID}' as BID`)
conLtext.push(`Select ${convals.join(',')}`)
}
@@ -923,13 +925,13 @@
_sql = `
/* 绯荤粺鐢熸垚 */
- declare @${item.sheet} table (${declarefields.join(',')},jskey nvarchar(50) )
+ declare @${item.sheet} table (${declarefields.join(',')},jskey nvarchar(50),BID nvarchar(50) )
Declare @UserName nvarchar(50),@FullName nvarchar(50),@ErrorCode nvarchar(50),@retmsg nvarchar(4000),@tbid Nvarchar(512)
Select @ErrorCode='', @retmsg='', @UserName='${userName}', @FullName='${fullName}'
${_initCustomScript}
`
- _sqlInsert = `Insert into @${item.sheet} (${fields},jskey)`
+ _sqlInsert = `Insert into @${item.sheet} (${fields},jskey,BID)`
_sqlBottom = `
/* 榛樿sql */
delete tmp_excel_in where upid=@upid@
@@ -1006,7 +1008,7 @@
let _formFieldValue = {}
let _actionType = null
let appkey = window.GLOB.appkey || ''
- let sessionUid = sessionStorage.getItem('SessionUid') || ''
+ let sessionUid = localStorage.getItem('SessionUid') || ''
if (verify.default !== 'false') { // 鍒ゆ柇鏄惁浣跨敤榛樿sql
_actionType = btn.sqlType
--
Gitblit v1.8.0