mainfrm.cpp

几个老外写的源代码大家块块下载

// MainFrm.cpp : implementation of the CMainFrame class
//

#include "stdafx.h"
#include "SerObjDoc.h"

#include "SerObj.h"

#include "MainFrm.h"
#include "ReportRec.h"
#include "DlgNew.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMainFrame

IMPLEMENT_DYNAMIC(CMainFrame, CMDIFrameWnd)

BEGIN_MESSAGE_MAP(CMainFrame, CMDIFrameWnd)
	//{{AFX_MSG_MAP(CMainFrame)
	ON_WM_CREATE()
	ON_NOTIFY(NM_DBLCLK, IDC_LIST_REPORT, OnDblclkReportList)
	ON_COMMAND(ID_FILE_NEW, OnFileNew)
	ON_COMMAND(ID_EDIT_DELETE, OnEditDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

static UINT indicators[] =
{
	ID_SEPARATOR,           // status line indicator
	ID_INDICATOR_CAPS,
	ID_INDICATOR_NUM,
	ID_INDICATOR_SCRL,
};

/////////////////////////////////////////////////////////////////////////////
// CMainFrame construction/destruction

CMainFrame::CMainFrame()
{
	// TODO: add member initialization code here
	
}

CMainFrame::~CMainFrame()
{
}

int CMainFrame::OnCreate(LPCREATESTRUCT lpCreateStruct)
{
	if (CMDIFrameWnd::OnCreate(lpCreateStruct) == -1)
		return -1;
	
	if (!m_wndToolBar.CreateEx(this, TBSTYLE_FLAT, WS_CHILD | WS_VISIBLE | CBRS_TOP
		| CBRS_GRIPPER | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC) ||
		!m_wndToolBar.LoadToolBar(IDR_MAINFRAME))
	{
		TRACE0("Failed to create toolbar\n");
		return -1;      // fail to create
	}

	if (!m_wndStatusBar.Create(this) ||
		!m_wndStatusBar.SetIndicators(indicators,
		  sizeof(indicators)/sizeof(UINT)))
	{
		TRACE0("Failed to create status bar\n");
		return -1;      // fail to create
	}

	// TODO: Delete these three lines if you don't want the toolbar to
	//  be dockable
	m_wndToolBar.EnableDocking(CBRS_ALIGN_ANY);
	EnableDocking(CBRS_ALIGN_ANY);
	DockControlBar(&m_wndToolBar);


	// Initialize dialog bar m_wndImagesInDB
	if (!m_wndDlgBar.Create(this, CG_IDD_IMAGESINDB,
		CBRS_LEFT | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_HIDE_INPLACE,
		CG_ID_VIEW_IMAGESINDB))
	{
		TRACE0("Failed to create dialog bar m_wndImagesInDB\n");
		return -1;		// fail to create
	}

	m_wndDlgBar.EnableDocking(CBRS_ALIGN_LEFT | CBRS_ALIGN_RIGHT);
	EnableDocking(CBRS_ALIGN_ANY);
	DockControlBar(&m_wndDlgBar);


	CListCtrl*  pList = (CListCtrl*)m_wndDlgBar.GetDlgItem(IDC_LIST_REPORT);
    VERIFY(pList);

    pList->SetExtendedStyle(LVS_EX_FLATSB | LVS_EX_FULLROWSELECT |LVS_EX_GRIDLINES);
    pList->InsertColumn(0,"Reports",LVCFMT_LEFT,200);
    int         nIndex = 0;
 
	
	//** read report list from database
	CRecordset rec(&theApp.m_DB);

    try {
		rec.Open( CRecordset::forwardOnly, "SELECT ReportId FROM Reports", CRecordset::readOnly );
		CString strReportId;
		while (!rec.IsEOF()) {
			rec.GetFieldValue( "ReportId", strReportId );
			pList->InsertItem(nIndex++, strReportId );
			rec.MoveNext();
		}
	}
	catch(CException* pE) {
        pE->ReportError();
        pE->Delete();
        return 0;
    }

    rec.Close();


	return 0;
}


void CMainFrame::OnDblclkReportList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	
	CListCtrl*  pList = (CListCtrl*)m_wndDlgBar.GetDlgItem(IDC_LIST_REPORT);
    VERIFY(pList);

    int nIndex = pList->GetNextItem(-1,LVNI_SELECTED);
    if  (nIndex < 0) return;

    CString strReportId = pList->GetItemText(nIndex,0);
	
	long nDocSize = theApp.m_pDoc->GetDocumentSize( strReportId ); 
//-----------------------------------------------
	
	CReportRec   rec( nDocSize, &theApp.m_DB );
	//rec.m_strFilter.Format("ReportId = '%s'",strReportId);
	CString strSQL;
	strSQL.Format ("SELECT ReportId, DocumentContents, DocSize FROM Reports WHERE ReportId = '%s'", strReportId );
	try {
		
		rec.Open(AFX_DB_USE_DEFAULT_TYPE, strSQL );

		if  (rec.IsEOF())
			AfxMessageBox("Unable to get image from db");
		else {
			//** create the view
			//theApp.OnFileNew(); 
			theApp.m_pDocManager->OnFileNew();
			//** update the title
			((CMDIFrameWnd*) AfxGetMainWnd ())->MDIGetActive()->SetWindowText ( strReportId );
			
			//** Transfer data from data base to document (serialize)
			theApp.m_pDoc->TransDataWithByteArray( rec.m_DocumentContents, FALSE );
		}

	}
 	catch(CException* pE) {
        pE->ReportError();
        pE->Delete();
    }

	*pResult = 0;
}


/////////////////////////////////////////////////////////////////////////////
// CMainFrame diagnostics

#ifdef _DEBUG
void CMainFrame::AssertValid() const
{
	CMDIFrameWnd::AssertValid();
}

void CMainFrame::Dump(CDumpContext& dc) const
{
	CMDIFrameWnd::Dump(dc);
}

#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CMainFrame message handlers

void CMainFrame::OnFileNew() 
{

	//** Add a new record to the database
	CDlgNew dlg;
	if(dlg.DoModal() == IDOK ) {
		
		//** open record set
		CReportRec	rec( 0, &theApp.m_DB);

		CString strSQL;
		strSQL.Format ("SELECT ReportId, DocumentContents, DocSize FROM Reports WHERE ReportId = '%s'", 
						dlg.m_strReportId );

		try {
			//** Open record set, add a blank record
			rec.Open(AFX_DB_USE_DEFAULT_TYPE, strSQL );
			rec.AddNew();

			rec.m_ReportId = dlg.m_strReportId;
			rec.m_DocSize = 0;
			
			rec.Update();
		}
		catch(CException* pE) {
			pE->ReportError();
			pE->Delete();
			return;
		}

		rec.Close();

		//** Add Report to the list
		CListCtrl*  pList = (CListCtrl*)m_wndDlgBar.GetDlgItem(IDC_LIST_REPORT);
	    VERIFY(pList);
		pList->InsertItem(pList->GetItemCount(), dlg.m_strReportId );
	}
}

//** Deletes the selected element from the List and the database
void CMainFrame::OnEditDelete() 
{

	CListCtrl*  pList = (CListCtrl*)m_wndDlgBar.GetDlgItem(IDC_LIST_REPORT);
	VERIFY(pList);

    int nIndex = pList->GetNextItem(-1,LVNI_SELECTED);
    if  (nIndex < 0) return;

  	CString strReportId = pList->GetItemText(nIndex,0);

	//** Delete the record
	CString strSQL;
	strSQL.Format("DELETE FROM REPORTS WHERE ReportId = '%s'", strReportId );
	theApp.m_DB.ExecuteSQL ( strSQL );

	pList->DeleteItem ( nIndex );
}