From a239a07d5ba48791a20af5d1b4473c61c62eb95e Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 09 七月 2024 16:04:46 +0800
Subject: [PATCH] 1
---
WFormSynchronizeData_SMR/WFormSynchronizeData_SMR/DBHelper.cs | 29 ++++++++++++++++++++---------
1 files changed, 20 insertions(+), 9 deletions(-)
diff --git a/WFormSynchronizeData_SMR/WFormSynchronizeData_SMR/DBHelper.cs b/WFormSynchronizeData_SMR/WFormSynchronizeData_SMR/DBHelper.cs
index 3aa34de..2d787e8 100644
--- a/WFormSynchronizeData_SMR/WFormSynchronizeData_SMR/DBHelper.cs
+++ b/WFormSynchronizeData_SMR/WFormSynchronizeData_SMR/DBHelper.cs
@@ -1,5 +1,6 @@
锘縰sing System;
using System.Collections.Generic;
+using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
@@ -38,15 +39,25 @@
}
public DBHelper()
{
- //sServer = "47.96.97.237,15127";
- //sDataBase = "HX_LMESsys";
- //sUser = "HX_USER";
- //sPassword = "lc@841022";
- //鏂帿灏�
- sServer = "10.11.18.195";
- sDataBase = "HX_LMESsys_test";
- sUser = "HX_USER";
- sPassword = "lc@841022";
+ sServer = GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "Config/SQLAPI.config", "sServer"); //"10.11.18.195";
+ sDataBase = GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "Config/SQLAPI.config", "sDataBase"); //"HX_LMESsys_test";
+ sUser = GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "Config/SQLAPI.config", "sUser"); //"HX_USER";
+ sPassword = GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "Config/SQLAPI.config", "sPassword");// "lc@841022";
+ }
+
+ public static String GetConfigKey(String configPath, String key)
+ {
+ Configuration ConfigurationInstance = ConfigurationManager.OpenMappedExeConfiguration(new ExeConfigurationFileMap()
+ {
+ ExeConfigFilename = configPath
+ }, ConfigurationUserLevel.None);
+
+
+ if (ConfigurationInstance.AppSettings.Settings[key] != null)
+ return ConfigurationInstance.AppSettings.Settings[key].Value;
+ else
+
+ return string.Empty;
}
private bool CnOpen()//OPEN鏁版嵁搴撹繛鎺�
--
Gitblit v1.9.1