From fc8c8d714687a22f711d642d192bd4149f3b7e88 Mon Sep 17 00:00:00 2001
From: king <18310653075@163.com>
Date: 星期一, 22 四月 2024 11:15:14 +0800
Subject: [PATCH] 2024-04-22
---
src/menu/datasource/verifycard/index.jsx | 6 ++++--
1 files changed, 4 insertions(+), 2 deletions(-)
diff --git a/src/menu/datasource/verifycard/index.jsx b/src/menu/datasource/verifycard/index.jsx
index d083aa3..b31ecfd 100644
--- a/src/menu/datasource/verifycard/index.jsx
+++ b/src/menu/datasource/verifycard/index.jsx
@@ -989,7 +989,7 @@
insert into #${setting.tableName || 'tb'}
(${n.join(',')})
select ${n.join(',')}
- from ${setting.dataresource ? `(${setting.dataresource}) tb` : setting.tableName || 'tb'}
+ from ${setting.dataresource ? `(${setting.dataresource.replace(/\n/g, ' ')}) tb` : setting.tableName || 'tb'}
order by @orderBy@
declare @mk_total int
@@ -1003,7 +1003,9 @@
delete #${setting.tableName || 'tb'} where sort_id > @pageIndex@*@pageSize@
if @pageIndex_top > 0
- delete #${setting.tableName || 'tb'} where sort_id <= @pageIndex_top`
+ delete #${setting.tableName || 'tb'} where sort_id <= @pageIndex_top
+
+ drop table #${setting.tableName || 'tb'}`
document.body.appendChild(oInput)
oInput.select()
--
Gitblit v1.8.0