jiance-analysis/DPTools/components/SomethingSetting/dbSettingFrom.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using System.Configuration;
using System.Diagnostics;

namespace Uninpho.Tools.components.SomethingSetting
{
    public partial class dbSettingFrom : DevExpress.XtraEditors.XtraForm
    {
        public dbSettingFrom()
        {
            InitializeComponent();
        }

        private void settingBtn_Click(object sender, EventArgs e)
        {
            SaveAppConfig("dbConnection", "PORT=" + PORT.Text + ";DATABASE=" + DATABASE.Text + ";HOST=" + HOST.Text + ";PASSWORD=" + PASSWORD.Text + ";USER ID=" + USER_ID.Text);
            if (XtraMessageBox.Show("配置更改需要重启软件才能生效，是否立刻重启软件？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            {
                Application.Restart();
                Process.GetCurrentProcess()?.Kill();
            }
        }

        private void dbSettingFrom_Load(object sender, EventArgs e)
        {
            string[] Con = ConfigurationManager.AppSettings["dbConnection"].Split(';');
            HOST.Text = Con[2].Split('=')[1];
            USER_ID.Text = Con[4].Split('=')[1];
            PASSWORD.Text = Con[3].Split('=')[1];
            PORT.Text = Con[0].Split('=')[1];
            DATABASE.Text = Con[1].Split('=')[1];
        }


        /// <summary>
        /// 保存配置文件的设定
        /// </summary>
        /// <param name="Key"></param>
        /// <param name="Value"></param>
        public static void SaveAppConfig(string Key, string Value)
        {
            string strFilePath = System.Windows.Forms.Application.ExecutablePath;
            Configuration objConfig = ConfigurationManager.OpenExeConfiguration(strFilePath);
            bool bolExist = false;
            foreach (string Item in objConfig.AppSettings.Settings.AllKeys)
            {
                if (Item == Key)
                {
                    bolExist = true;
                    break;
                }
            }
            if (bolExist)
            {
                objConfig.AppSettings.Settings.Remove(Key);
            }
            objConfig.AppSettings.Settings.Add(Key, Value);
            objConfig.Save(ConfigurationSaveMode.Modified);
            ConfigurationManager.RefreshSection("appSettings");
        }
    }
}