Conris.Utility/DbHelperSQL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.Common;
using System.Collections.Generic;
 

namespace Conris.Utility
{
    public class DbHelperSQL
    {

        private static string connectionString = getConnectionString();

       

        public DbHelperSQL() {
         
        }
        private static string getConnectionString()
        {
            string connectionString = "";
            ConnectionStringSettings setting = ConfigurationManager.ConnectionStrings["114ConnectionString"];
          if (setting != null)
          {
             connectionString = setting.ConnectionString;
          }
          else
          {
              connectionString = ConfigHelper.GetConfigString("114ConnectionString");
          } 
                
          
            return connectionString;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public static bool IsConnection(string sqlconnectionString)
        {
            using (SqlConnection connection = new SqlConnection(sqlconnectionString))
            {
                try
                {
                    
                    connection.Open();
                }
                catch (SqlException ex)
                {
                    Log4netHelper.ErrorByName("DbHelperSQL->IsConnection", ex.Message);
                    return false;
                }               
                if (connection.State == ConnectionState.Open)
                {
                    return true;