GG_DPS/DBClass/ConntionConfig.cs

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

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

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using Microsoft.Win32;


namespace DBClass
{
    /// <summary>
    /// SQL数据库服务器配置检测类
    /// </summary>
    public class ConntionConfig
    {

        private static string dbProviderName;
        private static string dbConnectionString;
        public static   string Tips = "Automation电子拣货系统";
        public static string Xtcscd;    //系统变量传递
        public static string Xtcsvalue;//系统变量值传递
        /// <summary>
        /// 检查配置信息
        /// </summary>
        /// <returns>完整有效返回true,无效则启动配置界面</returns>
        public static bool CheckConntionConfig()
        {
            if (CheckedConnection())
            {
                return true;
            }
            else
            {
               return CheckedConfig();
            }
        }

        /// <summary>
        /// 验证配置信息的数据库连接
        /// </summary>
        /// <returns>数据库是否连接成功的bool型</returns>
        public static bool CheckedConnection()
        {
            //////Object dbProviderObject = Registry.GetValue("HKEY_LOCAL_MACHINE\\SOFTWARE\\\\ZJWmsDb", "dbProviderName", "");
            //////Object dbConnectionObject = Registry.GetValue("HKEY_LOCAL_MACHINE\\SOFTWARE\\\\ZJWmsDb", "dbConnectionString", "");
            //////if (dbProviderObject != null && dbConnectionObject != null)
            //////{
            //////    dbProviderName = dbProviderObject.ToString();
            //////    dbConnectionString = dbConnectionObject.ToString();
            //////    //dbProviderName = DESEncrypt.Decrypt(dbProviderName);
            //////    //dbConnectionString = DESEncrypt.Decrypt(dbConnectionString);
            //////    return TestConntion();
            //////}
            //////else
            //////{
            //////    return false;
            //////}
            string conn =  ConfigurationManager.ConnectionStrings["SQLConnString"].ConnectionString;
            dbProviderName = ConfigurationManager.ConnectionStrings["dbProviderName"].ConnectionString;