From a27f32ecbfc7390ceb9e3a8d8651c57ada88bfa0 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期五, 19 十二月 2025 20:51:42 +0800
Subject: [PATCH] Merge branch 'master' of http://43.142.96.171:8080/r/~tjx/XB_MES_API
---
StandardPda/MES.Service/DB/OracleSQLHelper.cs | 32 ++++++++++++++++++++++++--------
1 files changed, 24 insertions(+), 8 deletions(-)
diff --git a/StandardPda/MES.Service/DB/OracleSQLHelper.cs b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
index 8d3d63e..c02aeb3 100644
--- a/StandardPda/MES.Service/DB/OracleSQLHelper.cs
+++ b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
@@ -66,7 +66,9 @@
}
}
- public int ExecuteNonQueryWithTransaction(string sql, OracleParameter[] parameters, OracleConnection connection, OracleTransaction transaction)
+ public int ExecuteNonQueryWithTransaction(string sql,
+ OracleParameter[] parameters, OracleConnection connection,
+ OracleTransaction transaction)
{
using (var cmd = new OracleCommand(sql, connection))
{
@@ -113,6 +115,23 @@
{
using (var command = new OracleCommand(query, connection))
{
+ connection.Open();
+ return command.ExecuteScalar();
+ }
+ }
+ }
+
+ // 鎵ц鏌ヨ骞惰繑鍥炲崟涓��(甯﹀弬鏁�)
+ public object ExecuteScalar(string sql, CommandType commandType, OracleParameter[] parameters)
+ {
+ using (var connection = new OracleConnection(_connectionString))
+ {
+ using (var command = new OracleCommand(sql, connection))
+ {
+ command.CommandType = commandType;
+ if (parameters != null)
+ command.Parameters.AddRange(parameters);
+
connection.Open();
return command.ExecuteScalar();
}
@@ -258,19 +277,16 @@
connection.Dispose();
}
}
- public object ExecuteScalarWithTransaction(OracleConnection conn, OracleTransaction tran, string sql, params OracleParameter[] parameters)
+
+ 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);
- }
+ if (parameters != null) cmd.Parameters.AddRange(parameters);
return cmd.ExecuteScalar();
}
}
-
-
}
\ No newline at end of file
--
Gitblit v1.9.3