web

ouyangqing

2021-01-26 04f7ee68b9d79c499ab70d9d4bd721c6f4f224fe

web

 WebAPI/Dapper/SqlPools.cs

@@ -18,12 +18,11 @@
        /// </summary>
        private void SecConnStr()
        {
            sqlDic.Add("YqnConn", "Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;User ID=HX_USER;Password=lc@841022;Integrated Security=True");
            //ConnectionStringSettingsCollection seetings = ConfigurationManager.ConnectionStrings;//获取配置文件connectionstring所有节点
            //for (int i = 0; i < seetings.Count; i++)
            //{
            //    sqlDic.Add(seetings[i].Name, seetings[i].ConnectionString);//存入字典
            //}
            ConnectionStringSettingsCollection seetings = ConfigurationManager.ConnectionStrings;//获取配置文件connectionstring所有节点
            for (int i = 0; i < seetings.Count; i++)
            {
                sqlDic.Add(seetings[i].Name, seetings[i].ConnectionString);//存入字典
            }
        }
        /// <summary>
        /// sqlhelper实例化

 WebAPI/Web.config

@@ -11,7 +11,7 @@
      
  </configSections>
    <connectionStrings>
        <add name="YqnConn" connectionString="Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;UserId=HX_USER,Password=lc@841022;Integrated Security=True" />
        <add name="YqnConn" connectionString="Data Source=192.168.0.175;Initial Catalog=HX_LimsSys_Test;UserId=HX_USER,Password=lc@841022;Integrated Security=True" />
    </connectionStrings>
    
  <appSettings>