From 350aef928584da9bb91d2de8646ce42e1f5758c1 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 08 七月 2022 15:36:16 +0800
Subject: [PATCH] 生产开报工接口提交
---
VueWebApi/Tools/DapperHelper.cs | 39 ++++++++++++++++++++++++++++++++++++++-
1 files changed, 38 insertions(+), 1 deletions(-)
diff --git a/VueWebApi/Tools/DapperHelper.cs b/VueWebApi/Tools/DapperHelper.cs
index 132be16..8d0203b 100644
--- a/VueWebApi/Tools/DapperHelper.cs
+++ b/VueWebApi/Tools/DapperHelper.cs
@@ -29,8 +29,9 @@
return connection;
}
+
/// <summary>
- /// Dapper鏌ヨ杩斿洖List<T>
+ /// Dapper鏌ヨ杩斿洖List
/// </summary>
/// <typeparam name="T">闇�瑕佽繑鍥炵殑瀵硅薄绫诲瀷</typeparam>
/// <param name="sql">Sql璇彞</param>
@@ -374,6 +375,42 @@
}
}
+ /// <summary>
+ /// 澧炲姞锛屽垹闄わ紝淇敼浣跨敤鐨� 浜嬪姟鏂规硶 Sqllist涓轰緷娆℃墽琛�
+ /// </summary>
+ /// <param name="sqlList"></param>
+ /// <returns></returns>
+ public static int DoTransactionCont(List<object> sqlList)
+ {
+ int result = 0;
+ IDbTransaction tranction = null;
+ using (IDbConnection conn = sqlConnection())
+ {
+ try
+ {
+ tranction = conn.BeginTransaction();
+ for (int i = 0; i < sqlList.Count; i++)
+ {
+ result += conn.Execute(sqlList[i].GetType().GetProperty("str").GetValue(sqlList[i], null).ToString(), sqlList[i].GetType().GetProperty("parm").GetValue(sqlList[i], null), tranction);
+ }
+ tranction.Commit();
+ }
+ catch (Exception ex)
+ {
+ //鍒涘缓鏃ュ織璁板綍缁勪欢瀹炰緥
+ LogHelper.WriteLog(ex);
+ tranction.Rollback();
+ throw ex;
+ }
+ finally
+ {
+ conn.Dispose();
+ conn.Close();
+ }
+ return result;
+ }
+ }
+
/// <summary>
/// Dapper鎻掑叆 杩斿洖鑷涓婚敭Id
--
Gitblit v1.9.3