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

#include "stdafx.h"
#include "XieyuyingDB.h"
#include "XieyuyingDBDlg.h"
#include "LoginDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CXieyuyingDBApp

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

/////////////////////////////////////////////////////////////////////////////
// CXieyuyingDBApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CXieyuyingDBApp object

CXieyuyingDBApp theApp;
CDatabase db;

/////////////////////////////////////////////////////////////////////////////
// CXieyuyingDBApp initialization

BOOL CXieyuyingDBApp::InitInstance()
{
	AfxEnableControlContainer();
    CXieyuyingDBApp::SetDialogBkColor(RGB(5,90,5),RGB(199,255,199));
	// 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

	// 顯示登錄對話框
	CLoginDlg LoginDlg;
	if(LoginDlg.DoModal()!=IDOK) return FALSE;
	// 顯示主對話框
	CXieyuyingDBDlg 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 CXieyuyingDBApp::ExitInstance() 
{
	if(db.IsOpen()) db.Close();// 關閉數據庫
	return CWinApp::ExitInstance();
}

// 全局函數，將時間串轉換為CTime型變量
CTime StrToTime(CString str)
{// 時間串格式 "%Y-%m-%d %H:%M:%S",如"1999-01-01 11:11:11"
	int nYear,nMonth,nDay,nHour,nMinute,nSecond;
	sscanf(str.Left(4), "%d", &nYear); // 得到年
	sscanf(str.Mid(5,2), "%d", &nMonth); // 得到月
	sscanf(str.Mid(8,2), "%d", &nDay); // 得到日
	sscanf(str.Mid(11,2), "%d", &nHour); // 得到時
	sscanf(str.Mid(14,2), "%d", &nMinute); // 得到分
	sscanf(str.Mid(17,2), "%d", &nSecond); // 得到分
	// 構造CTime變量
	CTime result(nYear,nMonth,nDay,nHour,nMinute,nSecond);
	return result;
}