From 166ff0158bf60a2554047fcd32721ed7ea968874 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期三, 13 八月 2025 18:05:39 +0800
Subject: [PATCH] 产测配件绑定代码提交
---
StandardPda/MES.Service/DB/OracleSQLHelper.cs | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/DB/OracleSQLHelper.cs b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
index ae4fccc..fea808c 100644
--- a/StandardPda/MES.Service/DB/OracleSQLHelper.cs
+++ b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
@@ -246,5 +246,19 @@
connection.Dispose();
}
}
+ public object ExecuteScalarWithTransaction(OracleConnection conn, OracleTransaction tran, string sql, params OracleParameter[] parameters)
+ {
+ using (var cmd = conn.CreateCommand())
+ {
+ cmd.Transaction = tran;
+ cmd.CommandText = sql;
+ if (parameters != null)
+ {
+ cmd.Parameters.AddRange(parameters);
+ }
+ return cmd.ExecuteScalar();
+ }
+ }
+
}
\ No newline at end of file
--
Gitblit v1.9.3