// DbConnectDlg.cpp : implementation file
//

#include "stdafx.h"
#include "electicketcardsys.h"
#include "DbConnectDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

extern CElecTicketCardSysApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CDbConnectDlg dialog


CDbConnectDlg::CDbConnectDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDbConnectDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDbConnectDlg)
	m_strDbName = _T("");
	m_strDbPsw = _T("");
	//}}AFX_DATA_INIT
}


void CDbConnectDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDbConnectDlg)
	DDX_Text(pDX, IDC_EDIT_DBNAME, m_strDbName);
	DDX_Text(pDX, IDC_EDIT_DBPSW, m_strDbPsw);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDbConnectDlg, CDialog)
	//{{AFX_MSG_MAP(CDbConnectDlg)
	ON_BN_CLICKED(IDC_BTN_DBNAME_BROWSE, OnDbNameBrowse)
	ON_BN_CLICKED(IDOK, OnConnectDb)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDbConnectDlg message handlers

//§功能：瀏覽數據庫文件路徑*** §約束：無
void CDbConnectDlg::OnDbNameBrowse() 
{
	CString strFilter("Access數據庫文件(*.mdb)|*.mdb|");
	CFileDialog flDlg(TRUE,NULL,NULL,OFN_HIDEREADONLY|OFN_OVERWRITEPROMPT,strFilter,NULL);

	flDlg.m_ofn.lpstrTitle = "打開Access數據庫文件";

	if(flDlg.DoModal() == IDOK)
	{
		m_strDbName = flDlg.GetPathName();
		UpdateData(FALSE);
	}
}

//§功能：連接數據庫*** §約束：無
void CDbConnectDlg::OnConnectDb() 
{
	UpdateData(TRUE);

	if (m_strDbName.IsEmpty())
	{
		MessageBox(_T("數據庫文件名稱不能為空，請重新輸入"),"輸入錯誤", MB_ICONWARNING|MB_OK);
		return;
	}
	theApp.m_strDbName = m_strDbName;
	theApp.m_strDbPsw = m_strDbPsw;

	if (!m_pDatabase)
	{
		MessageBox(_T("數據庫連接對象不存在"),"錯誤提示", MB_ICONWARNING|MB_OK);
		OnOK();
	}

	CString strConnect;
	strConnect = ";PWD="+m_strDbPsw;
	try
	{		
		if(m_pDatabase->IsOpen())
			m_pDatabase->Close();
		m_pDatabase->Open(theApp.m_strDbName,false,false,strConnect);
		OnOK();		
	}
	catch(CDaoException* e)
	{
		MessageBox(e->m_pErrorInfo->m_strDescription,_T("連接數據庫失敗"),MB_ICONWARNING);
		e->Delete();
	}
}