From 0ea0fc59c2dc8014fdd9d9f332d699b3be2308e6 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期六, 18 六月 2022 14:35:21 +0800
Subject: [PATCH] 往来单位查询接口、新增编辑、删除
---
VueWebApi/Tools/DapperHelper.cs | 41 ++++++++++++++++++++++++++++++++++-------
1 files changed, 34 insertions(+), 7 deletions(-)
diff --git a/VueWebApi/Tools/DapperHelper.cs b/VueWebApi/Tools/DapperHelper.cs
index 4e10084..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())
{
@@ -159,7 +159,7 @@
}
/// <summary>
- /// Dapper鏌ヨ杩斿洖datatable鏁版嵁
+ /// Dapper鏌ヨ杩斿洖datatable鏁版嵁(甯﹀弬鏁�)
/// </summary>
/// <param name="sql"></param>
/// <param name="parm"></param>
@@ -187,6 +187,33 @@
}
/// <summary>
+ /// Dapper鏌ヨ杩斿洖datatable鏁版嵁(涓嶅甫鍙傛暟)
+ /// </summary>
+ /// <param name="sql"></param>
+ /// <returns></returns>
+ public static DataTable selecttable(string sql)
+ {
+ //sql璇彞
+ try
+ {
+ using (IDbConnection conn = sqlConnection())
+ {
+ DataTable table = new DataTable();
+ var data = conn.ExecuteReader(sql);
+ table.Load(data);
+ return table;
+ }
+ }
+ catch (Exception ex)
+ {
+ //鍒涘缓鏃ュ織璁板綍缁勪欢瀹炰緥
+ LogHelper.WriteLog(ex);
+ throw ex;
+ }
+
+ }
+
+ /// <summary>
/// Dapper鏌ヨ杩斿洖鏁版嵁鏉℃暟
/// </summary>
/// <param name="sql"></param>
--
Gitblit v1.9.3