From 0529fdff6aec54e5af03e69af16bfe73139ee46c Mon Sep 17 00:00:00 2001
From: cnf <3200815559@qq.com>
Date: 星期一, 24 三月 2025 17:12:57 +0800
Subject: [PATCH] 控制层修改，之前没办法调getlist
---
MES.Service/DB/OracleSQLHelper.cs | 11 ++++-------
1 files changed, 4 insertions(+), 7 deletions(-)
diff --git a/MES.Service/DB/OracleSQLHelper.cs b/MES.Service/DB/OracleSQLHelper.cs
index 3efbc3f..9a36dba 100644
--- a/MES.Service/DB/OracleSQLHelper.cs
+++ b/MES.Service/DB/OracleSQLHelper.cs
@@ -1,4 +1,5 @@
锘縰sing System.Data;
+using MES.Service.util;
using Oracle.ManagedDataAccess.Client;
namespace MES.Service.DB;
@@ -8,18 +9,14 @@
/// </summary>
public class OracleSQLHelper
{
- public const string ConnectionString =
- "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev";
-
private readonly string _connectionString;
- //public static string connectionString = "Data Source = 192.168.1.19; Persist Security Info=True;User ID = abtdev; Password=abt_dev";
- public string connectionString =
- "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = xm_dev; Password=xmdev"; // 杩欓噷鏇挎崲鎴愪綘鐨勫疄闄呰繛鎺ュ瓧绗︿覆
+ private readonly string ConnectionString =
+ AppsettingsUtility.Settings.DataBaseConn;
public OracleSQLHelper()
{
- _connectionString = connectionString;
+ _connectionString = ConnectionString;
}
public OracleSQLHelper(string connectionString)
--
Gitblit v1.9.3