// 040410201lei.cpp : Defines the class behaviors for the application.
//

#include "stdafx.h"
#include "040410201lei.h"
#include "040410201leiDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMy040410201leiApp

BEGIN_MESSAGE_MAP(CMy040410201leiApp, CWinApp)
	//{{AFX_MSG_MAP(CMy040410201leiApp)
		// 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()

/////////////////////////////////////////////////////////////////////////////
// CMy040410201leiApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CMy040410201leiApp object



/////////////////////////////////////////////////////////////////////////////
// CMy040410201leiApp initialization

BOOL CMy040410201leiApp::InitInstance()
{
	AfxEnableControlContainer();
	if( FAILED(::CoInitialize(NULL)) ) 
	{
	    AfxMessageBox("ADO Init failed");
		return false;
	}
	try/*在主文件的初始函數中對數據源及數據庫進行連接*/
	{
		ADOConn.CreateInstance(__uuidof(Connection));
		ADOConn->Open("DSN=040410201;Provider=MSDASQL","","", adConnectUnspecified);
	}/*連接數據庫，其中DSN為數據源名稱，兩個引號內的為數據庫的帳號和密碼*/
	// Catch Exceptions
	catch(_com_error &e)
	{
		CString err;
		err.Format("%s", (char*)(e.Description()) );
		AfxMessageBox(err);
	}
	catch(...)
	{
		AfxMessageBox("Unknown Error...");
	}
	/*以上為對數據庫的連接*/
	// Init ADO RecordSet
	m_pADOSet.CreateInstance(__uuidof(Recordset));
	// 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

	CMy040410201leiDlg 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;
}

bool CMy040410201leiApp::ADOExecute(_RecordsetPtr &ADOSet, _variant_t &strSQL)
{
if ( ADOSet->State == adStateOpen)	ADOSet->Close();
	try
	{
       	ADOSet->Open(strSQL, ADOConn.GetInterfacePtr(), adOpenStatic, adLockOptimistic, adCmdUnknown);
	    return true;
	}
	catch(_com_error &e)
	{
       CString err;
	   err.Format("ADO Error: %s",(char*)e.Description());
	   AfxMessageBox(err);
	   return false;
	}
}