关于安装程序修改IP的问题

通过app.config文件进行配置

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <connectionStrings>
        <add name="ConnectionString" connectionString="server=172.18.8.251;database=OsCalibration;uid=sa;pwd=Rigol1998;" providerName="System.Data.SqlClient"/>        
    </connectionStrings>
    <appSettings>
        <add key="ConnectionString" value="server=172.18.8.251;database=OsCalibration;uid=Sa;pwd=Rigol1998;"/>
        <add key="Version" value="00.01.00.00"/>
        <add key="UpdateTime" value="2021-03-22"/>
    </appSettings>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2"/>
    </startup>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Ivi.Visa" publicKeyToken="a128c98f1d7717c1" culture="neutral"/>
        <bindingRedirect oldVersion="0.0.0.0-5.8.0.0" newVersion="5.8.0.0"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>

sqlsugar类

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using SqlSugar;
using System.Windows.Forms;
using System.Data;
using OscopeCalibration.DataBase;
/*****************************************************************************************************************
                                        普源精电科技有限公司版权所有(2020-)
******************************************************************************************************************
类名:      SqlSugarHelper
功能描述： 用于连接数据库并实现数据库表的增删改查
作 者：    sn03506 Albert Zhao
版 本：    00.01.00.00
创建日期： 2021/3/16 15:40:53
迭代想法：
修改历史： 
<作者>               <修改时间>               <版本>                    <修改描述>
*****************************************************************************************************************/
namespace OscopeCalibration_2._0.DataBase {
    public class SqlSugarHelper {
        //连接信息
        private string _connectionString;
        public string ConnectionStringHelper {
            get { return _connectionString; }
            set { _connectionString = ConfigurationManager.AppSettings["ConnectionString"]; }
        }
        public SqlSugarClient db { get; set; }
        //构造函数，创建数据库连接对象
        public SqlSugarHelper() {
            try {
                db = new SqlSugarClient(new ConnectionConfig() {
                    ConnectionString = ConfigurationManager.AppSettings["ConnectionString"],
                    DbType = SqlSugar.DbType.SqlServer,
                    IsAutoCloseConnection = false
                });
                db.Ado.CommandTimeOut = 20;//超时20s
            }
            catch (Exception ex) {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 查询表
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <returns></returns>
        public DataTable GetQuery<T>() {
            var dt = db.Queryable<T>().ToDataTable();
            return dt;
        }
        /// <summary>
        /// 根据DataTable更新表
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="tableName"></param>
        /// <param name="keyValue"></param>
        /// <returns></returns>
        public int UpdateTableByDataTable(DataTable dt,string tableName,string keyValue) {
            List<Dictionary<string, object>> dc = db.Utilities.DataTableToDictionaryList(dt);
            var update = db.Updateable(dc).AS(tableName).WhereColumns(keyValue).ExecuteCommand();
            return update;
        }
        /// <summary>
        /// 根据具体选中项目筛选出对应的校准表
        /// </summary>
        /// <param name="calibraItem"></param>
        /// <returns></returns>
        public DataTable GetSpecificCalibrationItems(string calibraItem) {
            DataTable dataTable;
            if (db.Queryable<SpecificCalibrationItems>().Where(it => it.CalibraItem == calibraItem).Any()) {
                dataTable = db.Queryable<SpecificCalibrationItems>().Where(it => it.CalibraItem == calibraItem).ToDataTable();
            }
            else {
                dataTable = null;
            }
            return dataTable;
        }
    }
}

生成Debug工程，只需要修改
OscopeCalibration.exe.config中的ip即可，修改app.config的IP无效。