User/Forms/frmDataConnection.cs

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

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

using System;
using System.Windows.Forms;
using Microsoft.VisualBasic;
using Common;

/// <summary>
/// 数据库连接
/// </summary>
/// <remarks></remarks>
namespace User
{
    partial class frmDataConnection
    {
        public frmDataConnection()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 初始化数据连接
        /// </summary>
        /// <remarks></remarks>
        public static void IniDataConnection()
        {
            string value = Common.DBConnString.ConnType;
            if (value.ToLower() == "SQL".ToLower())
            {        
                DataBase.Provider = DataBase.DataProvider.SqlClient;
                DataBase.Conn = DataBase.DBProviderFactory.CreateConnection();
                DataBase.Conn.ConnectionString = Common.DBConnString.SQLstr;;
                LoginInfo.ConnString = Common.DBConnString.SQLstr; ;
            }
            else if (value.ToLower() == "Access".ToLower())
            {
                DataBase.Provider = DataBase.DataProvider.AccessClient;
                DataBase.Conn = DataBase.DBProviderFactory.CreateConnection();
                DataBase.Conn.ConnectionString = Common.DBConnString.Accstr; 
                LoginInfo.ConnString = Common.DBConnString.SQLstr; 
            }
        }
        /// <summary>
        /// 测试连接
        /// </summary>
        /// <returns></returns>
        /// <remarks></remarks>
        public static ExecResult TestDataConnection()
        {
            try
            {
                DataBase.Conn.Open();
                DataBase.Conn.Close();
                return ExecResult.Succeed;
            }
            catch (Exception)
            {
                return ExecResult.Fail;
            }
        }
        /// <summary>
        /// 显示设置
        /// </summary>