From 73a6057fdbbd5f632e84ef85c799579ecacc0119 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期六, 18 六月 2022 23:08:19 +0800
Subject: [PATCH] 设备清单控制器接口定义
---
VueWebApi/Tools/DapperHelper.cs | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/VueWebApi/Tools/DapperHelper.cs b/VueWebApi/Tools/DapperHelper.cs
index 2d4cf04..f88e91a 100644
--- a/VueWebApi/Tools/DapperHelper.cs
+++ b/VueWebApi/Tools/DapperHelper.cs
@@ -126,11 +126,11 @@
{
try
{
- int skip = 1;
- if (pageIndex > 0)
- {
- skip = (pageIndex - 1) * pageSize + 1;
- }
+ //int skip = 1;
+ //if (pageIndex > 0)
+ //{
+ // skip = (pageIndex - 1) * pageSize + 1;
+ //}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT COUNT(1) FROM ({0}) AS Result;", sql);
@@ -138,7 +138,7 @@
FROM(SELECT *,ROW_NUMBER() OVER(ORDER BY {1} {2}) AS RowNum
FROM ({0}) AS Temp) AS Result
WHERE RowNum >= {3} AND RowNum <= {4}
- ORDER BY {1} {2}", sql, orderBy, sort, skip, pageIndex * pageSize);
+ ORDER BY {1} {2}", sql, orderBy, sort, pageIndex, pageSize); //skip, pageIndex * pageSize
using (IDbConnection conn = sqlConnection())
{
--
Gitblit v1.9.3