totalpay.cpp

通过Access数据库实现对个人开支的管理

// TotalPay.cpp : Defines the class behaviors for the application.
//
#include "Splash.h"
#include "resource.h"
#include "stdafx.h"
#include "TotalPay.h"
#include "TotalPayDlg.h"
#include "Add.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CTotalPayApp

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

/////////////////////////////////////////////////////////////////////////////
// CTotalPayApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CTotalPayApp object

CTotalPayApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CTotalPayApp initialization

BOOL CTotalPayApp::InitInstance()
{
	 CCommandLineInfo cmdInfo;
     ParseCommandLine(cmdInfo);
     CSplashWnd::EnableSplashScreen(cmdInfo.m_bShowSplash);

	AfxOleInit();//初始化COM库
	AfxEnableControlContainer();

	//以下是连接access2000数据库。。。
	HRESULT hr;
	try
	{
		hr = m_pConnection.CreateInstance("ADODB.Connection");///创建Connection对象
		if(SUCCEEDED(hr))
		{
			m_pConnection->ConnectionTimeout=3;///设置超时时间为3秒
			hr = m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= totalpay.mdb;","","",adModeUnknown);
			///连接数据库
			///上面一句中连接字串中的Provider是针对ACCESS2000环境的，对于ACCESS97,需要改为:Provider=Microsoft.Jet.OLEDB.3.51;  }
		}
	}
	catch(_com_error e)///捕捉异常
	{
		CString temp;
		temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
		::MessageBox(NULL,temp,"提示信息",NULL);
		return false;
	}

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

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

int CTotalPayApp::ExitInstance() 
{
	// TODO: Add your specialized code here and/or call the base class
	if(m_pConnection->State)
		m_pConnection->Close(); ///如果已经打开了连接则关闭它
	return CWinApp::ExitInstance();

}