material_mis.cpp

支持ACCESS数据库的数据的查询、打印、统计等

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

#include "stdafx.h"
#include "Material_MIS.h"


#include "Material_MISDoc.h"
#include "Material_MISView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISApp

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

/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CMaterial_MISApp object

CMaterial_MISApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISApp initialization

 BOOL CMaterial_MISApp::InitInstance()
 {
 	AfxEnableControlContainer();
     
 	Enable3dControls();	// Call this when linking to MFC statically
    	
 	// Init Login Count
 	m_iLoginCount = 0;
 	
 /*	// 创建ADO连接对象
 	if( FAILED(::CoInitialize(NULL)) ) 
 	{
 	    AfxMessageBox("ADO Init failed");
 		return false;
	}
 	try
 	{
 		ADOConn.CreateInstance(__uuidof(Connection));
 			ADOConn->Open("DSN=x11.dbf;","","", adConnectUnspecified);
 	}
 	// 捕捉例外
 	catch(_com_error &e)
	{
 		CString err;
 		err.Format("%s", (char*)(e.Description()) );
		AfxMessageBox(err);
 	}
 	catch(...)
 	{
 		AfxMessageBox("Unknown Error...");
 	}
 	
 	// 初始化ADO记录集
 	m_pADOSet.CreateInstance(__uuidof(Recordset));*/
 		
 	// 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.
 
 	// 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.
 
	// 弹出登录对话框
 	CLoginDLG dlg;
 	if ( IDOK!=dlg.DoModal() ) return false;
 
 	CSingleDocTemplate* pDocTemplate;
 	pDocTemplate = new CSingleDocTemplate(
 		IDR_MAINFRAME,
 		RUNTIME_CLASS(CMaterial_MISDoc),
 		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
 		RUNTIME_CLASS(CMaterial_MISView));
 	AddDocTemplate(pDocTemplate);
     m_nCmdShow = SW_SHOWMAXIMIZED;//Max window when show
	
 	// 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_SHOW);
 	m_pMainWnd->SetWindowText(_T("Paint 查询系统"));
 	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 CMaterial_MISApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CMaterial_MISApp message handlers


bool CMaterial_MISApp::ADOExecute(_RecordsetPtr &ADOSet, _variant_t &strSQL)
{
	if ( ADOSet->State == adStateOpen)	ADOSet->Close();
	try
	{
       	ADOSet->Open(strSQL, ADOConn.GetInterfacePtr(), adOpenStatic, adLockOptimistic, adCmdUnknown);
	    return true;
	}
	catch(_com_error &e)
	{
       CString err;
	   err.Format("ADO Error: %s",(char*)e.Description());
	   AfxMessageBox(err);
	   return false;
	}
}
int CMaterial_MISApp::ExitInstance() 
{
	// TODO: Add your specialized code here and/or call the base class
	
/*	//释放ADO连接对象 
	if( adStateOpen == ADOConn->State )	ADOConn->Close();
	ADOConn.Release();
    
	// 释放ADO记录集
	if(adStateOpen==m_pADOSet->State)	m_pADOSet->Close();
	m_pADOSet.Release();
*/	
	return CWinApp::ExitInstance();
}