From 1cb5959adf96911101864488a67e8b31b8de658f Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期五, 08 八月 2025 15:31:38 +0800
Subject: [PATCH] 产测中箱码、栈板码绑定sn添加日志表记录
---
StandardPda/MES.Service/DB/OracleSQLHelper.cs | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/DB/OracleSQLHelper.cs b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
index 9a36dba..ae4fccc 100644
--- a/StandardPda/MES.Service/DB/OracleSQLHelper.cs
+++ b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
@@ -228,4 +228,23 @@
// }
// return result;
// }
+ // 鎵撳紑杩炴帴骞跺紑鍚簨鍔�
+ public (OracleConnection, OracleTransaction) BeginTransaction()
+ {
+ var connection = new OracleConnection(_connectionString);
+ connection.Open();
+ var transaction = connection.BeginTransaction();
+ return (connection, transaction);
+ }
+
+ // 鍏抽棴杩炴帴锛堟彁浜ゆ垨鍥炴粴鍚庣敤锛�
+ public void CloseConnection(OracleConnection connection)
+ {
+ if (connection != null && connection.State != ConnectionState.Closed)
+ {
+ connection.Close();
+ connection.Dispose();
+ }
+ }
+
}
\ No newline at end of file
--
Gitblit v1.9.3