From 98958cdd70d3a63a562e9238ddecb9c6c6865e95 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期五, 12 十二月 2025 21:02:14 +0800
Subject: [PATCH] 添加接口，查询栈板码是否入库，返回消息，是否允许解绑
---
StandardPda/MES.Service/DB/OracleSQLHelper.cs | 17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/DB/OracleSQLHelper.cs b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
index 9b5b9dd..c02aeb3 100644
--- a/StandardPda/MES.Service/DB/OracleSQLHelper.cs
+++ b/StandardPda/MES.Service/DB/OracleSQLHelper.cs
@@ -121,6 +121,23 @@
}
}
+ // 鎵ц鏌ヨ骞惰繑鍥炲崟涓��(甯﹀弬鏁�)
+ 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();
+ }
+ }
+ }
+
// 鎵ц瀛樺偍杩囩▼
//OracleParameter[] parameters = new OracleParameter[]
--
Gitblit v1.9.3