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

#include "stdafx.h"
#include "student.h"

#include "MainFrm.h"
#include "studentDoc.h"
#include "studentView.h"
#include "mylogin.h"
#include "ado.h"

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


/////////////////////////////////////////////////////////////////////////////
// CStudentApp

BEGIN_MESSAGE_MAP(CStudentApp, CWinApp)
	//{{AFX_MSG_MAP(CStudentApp)
	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 file based document commands
	ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew)
	ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen)
	// Standard print setup command
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStudentApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CStudentApp object

CStudentApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CStudentApp initialization

BOOL CStudentApp::InitInstance()
{
	AfxEnableControlContainer();

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

	int MainMenu=IDR_MENU_GLY;

	while(true)
	{
		CMyLogin login;
		login.m_bm = "管理員";
		if(IDOK == login.DoModal())
		{
			CADODatabase ado;
			ado.Open(ADOCONNSTR,"","");

			login.m_name.TrimRight();
			login.m_bm.TrimRight();
			login.m_pass.TrimRight();

			CADORecordset rset(&ado);
			CString Sql = "SELECT * FROM [UserT] WHERE Name='"+login.m_name+"' AND Password='"+login.m_pass+"' AND Class='"+login.m_bm+"'";

			rset.Open(Sql.GetBuffer(100));
			{
				if(	rset.GetRecordCount()>0)
				{
					if(login.m_bm.Compare("管理員")==0)
					{
						MainMenu = IDR_MENU_GLY;
					}
					else if(login.m_bm.Compare("學生工作處") ==0)
					{
						MainMenu = IDR_MENU_XSGZS;
					}
					else if (login.m_bm.Compare("各系") ==0)
					{
						MainMenu = IDR_MENU_GX;
					}
					else if (login.m_bm.Compare("教務科") ==0) 
					{
						MainMenu = IDR_MENU_JWK;
					}
					else if (login.m_bm.Compare("師資科")==0)
					{
						MainMenu = IDR_MENU_SZK;
					}
					else if (login.m_bm.Compare("院長辦公室")==0)
					{
						MainMenu = IDR_MENU_YZBGS;
					}
					else 
					{
						MessageBox(login.m_hWnd,"無些部門","錯誤",NULL);
						continue;
					}

					ado.Close();
					break;
				}
			}
			ado.Close();
			MessageBox(login.m_hWnd,"無些用戶或密碼錯誤。","錯誤",NULL);
		}
		else
		{
			return false;
		}
	}


	// 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(
		MainMenu,
		RUNTIME_CLASS(CStudentDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CStudentView));
	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)
		// No message handlers
	//}}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)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

/////////////////////////////////////////////////////////////////////////////
// CStudentApp message handlers