/// <summary>
/// 連接Access資料庫
/// </summary>
/// <returns></returns>
private DaoErrMsg ConnectAccess()
{
DaoErrMsg Err = new DaoErrMsg();
if (m_SQL != null)
{
//表示已開啟過;//
return(Err);
}
m_SQL = CreateDbCom(DaoConfigFile.Instance.FileDatabase);
Err = m_SQL.Connect();
if (Err.isError)
{
System.Diagnostics.Debug.WriteLine(Err.ErrorMsg);
m_SQL = null;
return(Err);
}
DatabaseConnectedChange?.Invoke(true);
return(Err);
}
/// <summary>
/// 關閉資料庫連接
/// </summary>
internal void CloseDatabase()
{
if (m_SQL == null)
{
return;
}
m_SQL.Close();
m_SQL = null;
DatabaseConnectedChange?.Invoke(false);
}
/// <summary>
/// 連接MSSQL資料庫
/// </summary>
/// <returns></returns>
private DaoErrMsg ConnectMSSQL(string ServerPath, string DbName, string DbID, string DbPW)
{
DaoErrMsg Err = new DaoErrMsg();
if (m_MSSQL != null)
{
//表示已開啟過;//
return(Err);
}
//建立資料庫連接字串
////注意：SQLExpress版本要寫成：「.\sqlexpress」
//string strServerPath = Properties.Settings.Default.DB_SERVER_NAME;
////strServerPath = @"KEYNES-PC\EXPRESS";
//string strDbName = Properties.Settings.Default.DB_NAME;
//string strDbID = Properties.Settings.Default.DB_ID;
//string strDbPW = Properties.Settings.Default.DB_PW;
string strConnection = string.Format(@"server={0};database={1};uid={2};pwd={3}",
ServerPath,
DbName,
DbID,
DbPW);
m_MSSQL = new DaoDbCommon(strConnection, new SqlConnection());
Err = m_MSSQL.Connect();
if (Err.isError)
{
System.Diagnostics.Debug.WriteLine(Err.ErrorMsg);
m_MSSQL = null;
return(Err);
}
DatabaseConnectedChange?.Invoke(true);
return(Err);
}
