acslogdlg.cpp

vc数据库编程程序

// AcsLogDlg.cpp : implementation file
//

#include "stdafx.h"
#include "MySqlPlus.h"
#include "AcsLogDlg.h"
#include "common.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAcsLogDlg dialog
extern CMySqlPlusApp theApp;


CAcsLogDlg::CAcsLogDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAcsLogDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAcsLogDlg)
	m_filename = _T("");
	//}}AFX_DATA_INIT
}


void CAcsLogDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAcsLogDlg)
	DDX_Text(pDX, IDC_FILENAME, m_filename);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAcsLogDlg, CDialog)
	//{{AFX_MSG_MAP(CAcsLogDlg)
	ON_BN_CLICKED(IDOK, OnLogin)
	ON_BN_CLICKED(IDC_BUTTON1, OnOpenFile)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAcsLogDlg message handlers

void CAcsLogDlg::OnLogin() 
{
	HRESULT hr;
    _ConnectionPtr m_pConnTemp = theApp.m_pConnection;

	UpdateData();
	CString strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + m_filename;
	try
	{
		hr = m_pConnTemp.CreateInstance("ADODB.Connection");

		if(SUCCEEDED(hr))
		{
			hr=m_pConnTemp->Open((_bstr_t)strConnection,"","",-1);
			OnOK();
		}
	}
	catch(_com_error e)
	{
		CCommon common;
		AfxMessageBox(common.DisplayAdoError(m_pConnTemp));
	}  


	if (m_pConnTemp != NULL)
	{
		if (m_pConnTemp->State)
		{
			
			if (theApp.m_pConnection != NULL)
			{
				if (theApp.m_pConnection->State)
				{
					theApp.m_pConnection->Close ();
				}
			}
			theApp.m_pConnection = m_pConnTemp;
		}
	}
}

void CAcsLogDlg::OnOpenFile() 
{
	CFileDialog fileDlg(TRUE, "mdb", "*.mdb", NULL, "Access Files(*.mdb)", NULL);
	if (fileDlg.DoModal ()==IDOK)
	{
		m_filename = fileDlg.GetPathName();
		UpdateData (false);
	}
}