From 2dadcbe39d6211bb08139cd600d6b8c9ca92d508 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 28 二月 2024 20:44:30 +0800 Subject: [PATCH] 2024-02-28 --- src/utils/utils.js | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index 414255a..cc96970 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -690,7 +690,7 @@ } else if (item.type === 'range') { let val = item.value.split(',') - searchText.push('(' + item.key + ' >= ' + (val[0] || -999999) + ' AND ' + item.key + ' <= ' + (val[1] || 999999) + ')') + searchText.push('(' + item.key + ' >= ' + (val[0] || -999999) + ' AND ' + item.key + ' < ' + (val[1] || 999999) + ')') } else { searchText.push('(' + item.key + ' ' + item.match + ' \'' + item.value + '\')') } @@ -1156,7 +1156,7 @@ end ${unique.verifyType.indexOf('temp') === -1 ? `Set @tbid='' - Select top 1 @tbid=${_afields.join('+\' \'+')} from #${sheet} a Inner join ${sheet} b on ${_fields_} + Select top 1 @tbid=${_afields.join('+\' \'+')} from #${sheet} a Inner join ${database}${sheet} b on ${_fields_} If @tbid!='' Begin @@ -1376,7 +1376,7 @@ end ${unique.verifyType.indexOf('temp') === -1 ? `Set @tbid='' - Select top 1 @tbid=${_afields.join('+\' \'+')} from #${sheet} a Inner join ${sheet} b on ${_fields_} + Select top 1 @tbid=${_afields.join('+\' \'+')} from #${sheet} a Inner join ${database}${sheet} b on ${_fields_} If @tbid!='' Begin -- Gitblit v1.8.0