From d8c87e31b42617a1222c07addfb5edccff069732 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期六, 23 八月 2025 15:01:13 +0800
Subject: [PATCH] 产测解绑sn代码提交
---
StandardPda/MES.Service/DB/OracleSQLHelper.cs | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/DB/OracleSQLHelper.cs b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
index fea808c..8d3d63e 100644
--- a/StandardPda/MES.Service/DB/OracleSQLHelper.cs
+++ b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
@@ -66,6 +66,18 @@
}
}
+ public int ExecuteNonQueryWithTransaction(string sql, OracleParameter[] parameters, OracleConnection connection, OracleTransaction transaction)
+ {
+ using (var cmd = new OracleCommand(sql, connection))
+ {
+ cmd.Transaction = transaction;
+ if (parameters != null)
+ cmd.Parameters.AddRange(parameters);
+
+ return cmd.ExecuteNonQuery();
+ }
+ }
+
public int ExecuteTransaction(string query1)
{
using (var connection = new OracleConnection(_connectionString))
--
Gitblit v1.9.3