// Myhotel.cpp : Defines the class behaviors for the application.
//

#include "stdafx.h"
#include "Myhotel.h"
#include "MyhotelDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMyhotelApp

BEGIN_MESSAGE_MAP(CMyhotelApp, CWinApp)
	//{{AFX_MSG_MAP(CMyhotelApp)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG
	ON_COMMAND(ID_HELP, CWinApp::OnHelp)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMyhotelApp construction

CMyhotelApp::CMyhotelApp()
{
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CMyhotelApp object

CMyhotelApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CMyhotelApp initialization

BOOL CMyhotelApp::InitInstance()
{
	try//連接數據庫
	{
     CString strConnect;
	 strConnect.Format("DSN=myhotel;");
	 if(!m_DB.OpenEx(strConnect,CDatabase::useCursorLib))
     {
     AfxMessageBox("Unable to Connect to the Specified Data Source");
     return FALSE ;
     }
	}
   catch(CDBException *pE)//拋出異常
    {
        pE->ReportError();
        pE->Delete();
        return FALSE;
    }

	AfxEnableControlContainer();
SetDialogBkColor (RGB (140, 180, 220), RGB (225, 71, 6,));
	// Standard initialization
	// If you are not using these features and wish to reduce the size
	//  of your final executable, you should remove from the following
	//  the specific initialization routines you do not need.

#ifdef _AFXDLL
	Enable3dControls();			// Call this when using MFC in a shared DLL
#else
	Enable3dControlsStatic();	// Call this when linking to MFC statically
#endif

		// ------------------------------------------------------------------------------------------------
	// 初始化COM,創建ADO連接等操作
	AfxOleInit();
	m_pConnection.CreateInstance(__uuidof(Connection));

	// 在ADO操作中建議語句中要常用try...catch()來捕獲錯誤信息，
	// 
	try                 
	{	
		// 打開本地數據庫
		m_pConnection->Open("Provider=MSDASQL.1;Persist Security Info=False;Data Source=myhotel","","",adModeUnknown);
		
	}
	catch(_com_error e)//拋出可能發生的異常
	{
		AfxMessageBox("數據庫連接失敗，確認數據庫配置正確!");
		return FALSE;
	} 
	// ---------------------------------------------------------------------------------------------------


	CMyhotelDlg dlg;
	m_pMainWnd = &dlg;
	int nResponse = dlg.DoModal();
	if (nResponse == IDOK)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with OK
	}
	else if (nResponse == IDCANCEL)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with Cancel
	}

	// Since the dialog has been closed, return FALSE so that we exit the
	//  application, rather than start the application's message pump.
	return FALSE;
}