常州旅游管理系统.cpp

一个好的旅游管理系统,分享一下.不错的啊 .

// 常州旅游管理系统.cpp : Defines the class behaviors for the application.
//

#include "stdafx.h"
#include "常州旅游管理系统.h"
#include "odbcinst.h"
#include "MainFrm.h"
#include "常州旅游管理系统Set.h"
#include "常州旅游管理系统Doc.h"
#include "常州旅游管理系统View.h"

#include "PasswordDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CMyApp

BEGIN_MESSAGE_MAP(CMyApp, CWinApp)
	//{{AFX_MSG_MAP(CMyApp)
	ON_COMMAND(ID_APP_ABOUT, OnAppAbout)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG_MAP
	// Standard print setup command
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMyApp construction

CMyApp::CMyApp()
{
  flagapp=true;
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CMyApp object

CMyApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CMyApp initialization

BOOL CMyApp::InitInstance()
{

AfxEnableControlContainer();
GetCtrlManager().InstallHook();//使所有控件浮动

CString sPath;
GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
sPath.ReleaseBuffer();
int nPos;
nPos=sPath.ReverseFind('\\');
sPath=sPath.Left(nPos);
CString lpszFileName = sPath + "\\test.mdb";
CFileFind  fFind;
if(!fFind.FindFile(lpszFileName))
{
    ::AfxMessageBox("没有找到数据库");
    exit(0);
}
CString szDesc;
szDesc.Format( "DSN=景点管理;Description=test;DESCRIPTION=The DataBase For abc;FIL=MicrosoftAccess;DEFAULTDIR=%s;DBQ=%s;" ,sPath,lpszFileName);
//添加数据源
if(!::SQLConfigDataSource(NULL,ODBC_ADD_DSN, "Microsoft Access Driver (*.mdb)",(LPCSTR)szDesc))
{
    ::AfxMessageBox("32位ODBC数据源配置错误!");
    exit(0);
} 
/*
if(!SQLConfigDataSource(NULL,ODBC_ADD_DSN,
(LPSTR)"SQL Server",
(LPSTR)"DSN=景点管理\0"
"SERVER=localhost\0"//or =127.0.0.1
"DATABASE=test\0"))
{
    ::AfxMessageBox("32位ODBC数据源配置错误!");
    exit(0);
} */

bool passwordflag=false;
CString user,password;
PasswordDlg m_dlg;

m_database=new CDatabase;
m_database->Open("景点管理",FALSE,FALSE,"ODBC;UID=sa;PWD=",TRUE);
CString strSQL="select * from 用户密码表";
m_pSet=new PasswordSet(m_database);
m_pSet->Open(CRecordset::snapshot,strSQL);
for(int i=0;i<3;i++)
{ 
	m_pSet->MoveFirst();//从第一条记录开始
	if(m_dlg.DoModal()==IDOK)//IDOK
	{
		if(m_dlg.m_name.IsEmpty()||(m_dlg.m_password.IsEmpty()))
		{
			AfxMessageBox("请输入您的用户名与密码！");
			continue;
		}
		else
		{    
			while(!m_pSet->IsEOF())
			{ 
				user=m_pSet->m_PASSWORD;//取密码表字段的成员变量值
				user.TrimRight();
				user.TrimLeft();
			
				password=m_pSet->m_NAME;//取密码表字段的成员变量值
				password.TrimRight();
				password.TrimLeft();
		
				if((m_dlg.m_name==user)&&(m_dlg.m_password==password))
				{
					passwordflag=true;
					m_pSet->Close();//关闭数据库
					break;
				}
				else
				{
					m_pSet->MoveNext();//指向下一个记录
				}
			}
			if(!passwordflag)
			{
				AfxMessageBox("登陆出现错误，请检查您的用户名与密码，重新登陆！");
				continue;
			}
			else 				
				break;	
		}		
	}
	else// IDCANCEL
	{	
	AfxMessageBox("系统将以浏览的方式打开");
	passwordflag=true;
	flagapp=false;
//    return FALSE;
	break;
	}	
}
if(!passwordflag)
{
	AfxMessageBox("您登陆错误超过3次，无权再输入！");
	return FALSE;
}


	// 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

	// Change the registry key under which our settings are stored.
	// TODO: You should modify this string to be something appropriate
	// such as the name of your company or organization.
	SetRegistryKey(_T("Local AppWizard-Generated Applications"));

	LoadStdProfileSettings();  // Load standard INI file options (including MRU)

	// Register the application's document templates.  Document templates
	//  serve as the connection between documents, frame windows and views.

	CSingleDocTemplate* pDocTemplate;
	pDocTemplate = new CSingleDocTemplate(
		IDR_MAINFRAME,
		RUNTIME_CLASS(CMyDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CMyView));
	AddDocTemplate(pDocTemplate);

	// Parse command line for standard shell commands, DDE, file open
	CCommandLineInfo cmdInfo;
	ParseCommandLine(cmdInfo);

	// Dispatch commands specified on the command line
	if (!ProcessShellCommand(cmdInfo))
		return FALSE;

	// The one and only window has been initialized, so show and update it.
	m_pMainWnd->ShowWindow(SW_SHOWMAXIMIZED);
	m_pMainWnd->UpdateWindow();
    
	return TRUE;
}


/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

// App command to run the dialog
void CMyApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CMyApp message handlers