From 4430f49d7a5ce2303633cbeac7ec0c9be05572d1 Mon Sep 17 00:00:00 2001 From: 展杰 <1240968267@qq.com> Date: 星期六, 17 八月 2024 11:24:07 +0800 Subject: [PATCH] 关联条件 物料编号改为物料id --- MES.Service/DB/OracleSQLHelper.cs | 9 +++++---- 1 files changed, 5 insertions(+), 4 deletions(-) diff --git a/MES.Service/DB/OracleSQLHelper.cs b/MES.Service/DB/OracleSQLHelper.cs index 65b0219..163e93f 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,14 +9,14 @@ /// </summary> public class OracleSQLHelper { - public const string ConnectionString = - "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"; - private readonly string _connectionString; + + public readonly string ConnectionString = + AppsettingsUtility.Settings.DataBaseConn; //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.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"; // 杩欓噷鏇挎崲鎴愪綘鐨勫疄闄呰繛鎺ュ瓧绗︿覆 + "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_prd; Password=xmprd"; // 杩欓噷鏇挎崲鎴愪綘鐨勫疄闄呰繛鎺ュ瓧绗︿覆 public OracleSQLHelper() { -- Gitblit v1.9.3