odbcview.cpp

利用MFC编写的一个小小的数据库系统

// ODBCView.cpp : implementation of the CODBCView class
//

#include "stdafx.h"
#include "ODBC.h"
#include <cstring>

#include "ODBCSet.h"
#include "ODBCDoc.h"
#include "ODBCView.h"
#include "MOVETOdlg.h"
#include "FINDRECORDdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CODBCView

IMPLEMENT_DYNCREATE(CODBCView, CRecordView)

BEGIN_MESSAGE_MAP(CODBCView, CRecordView)
	//{{AFX_MSG_MAP(CODBCView)
	ON_COMMAND(ID_DELETE_RECORD, OnDeleteRecord)
	ON_COMMAND(ID_DELFIELD_RECORD, OnDelfieldRecord)
	ON_COMMAND(ID_UPDATE_RECORD, OnUpdateRecord)
	ON_COMMAND(ID_ADD_BUTTON, OnAddButton)
	ON_COMMAND(ID_COUNT_RECORD, OnCountRecord)
	ON_COMMAND(ID_FIND_RECORD, OnFindRecord)
	ON_COMMAND(ID_SORT_RECORD, OnSortRecord)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CRecordView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CODBCView construction/destruction

CODBCView::CODBCView()
	: CRecordView(CODBCView::IDD)
{
	//{{AFX_DATA_INIT(CODBCView)
	m_pSet = NULL;
	//}}AFX_DATA_INIT
	// TODO: add construction code here

}

CODBCView::~CODBCView()
{
}

void CODBCView::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CODBCView)
	DDX_FieldText(pDX, IDC_BOOKID_EDIT, m_pSet->m_column1, m_pSet);
	DDX_FieldText(pDX, IDC_AUTOR_EDIT, m_pSet->m_column2, m_pSet);
	DDX_FieldText(pDX, IDC_PRESS_EDIT, m_pSet->m_column3, m_pSet);
	DDX_FieldText(pDX, IDC_PRICE_EDIT, m_pSet->m_column4, m_pSet);
	//}}AFX_DATA_MAP
}

BOOL CODBCView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CRecordView::PreCreateWindow(cs);
}

void CODBCView::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_oDBCSet;
	CRecordView::OnInitialUpdate();
	GetParentFrame()->RecalcLayout();
	ResizeParentToFit();

}

/////////////////////////////////////////////////////////////////////////////
// CODBCView printing

BOOL CODBCView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}

void CODBCView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add extra initialization before printing
}

void CODBCView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add cleanup after printing
}

/////////////////////////////////////////////////////////////////////////////
// CODBCView diagnostics

#ifdef _DEBUG
void CODBCView::AssertValid() const
{
	CRecordView::AssertValid();
}

void CODBCView::Dump(CDumpContext& dc) const
{
	CRecordView::Dump(dc);
}

CODBCDoc* CODBCView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CODBCDoc)));
	return (CODBCDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CODBCView database support
CRecordset* CODBCView::OnGetRecordset()
{
	return m_pSet;
}


/////////////////////////////////////////////////////////////////////////////
// CODBCView message handlers

void CODBCView::OnDeleteRecord() 
{
	// TODO: Add your command handler code here
	m_pSet->Open();
	if(!m_pSet->IsBOF())
 	     m_pSet->Delete();
	m_pSet->MoveNext();
	UpdateData(FALSE);
	
}

void CODBCView::OnDelfieldRecord() 
{
	// TODO: Add your command handler code here
	m_pSet->SetFieldNull(NULL);
	UpdateData(FALSE);
}

void CODBCView::OnUpdateRecord() 
{
	// TODO: Add your command handler code here
	m_pSet->Edit();
	UpdateData(TRUE);
}

void CODBCView::OnAddButton() 
{
	// TODO: Add your command handler code here
	long m_NewID;
	m_NewID=m_pSet->GetMaxID()+1;
	m_pSet->AddNew();       //增加数据
	m_pSet->m___ID=m_NewID; //设置编号
	m_pSet->Update();       
	m_pSet->Requery();  //刷新数据库
	m_pSet->MoveLast();
	UpdateData(FALSE);

}

void CODBCView::OnCountRecord() 
{
	// TODO: Add your command handler code here
	UpdateData(TRUE);
	CMOVETOdlg MoveTOdlg;
	MoveTOdlg.DoModal();
    m_pSet->SetAbsolutePosition(MoveTOdlg.m_moveto);
	UpdateData(FALSE);
}

void CODBCView::OnFindRecord() 
{
	// TODO: Add your command handler code here
	UpdateData(TRUE);
	CString col="出版社";
	CFINDRECORDdlg FindRecorddlg;
	FindRecorddlg.DoModal();
	m_pSet->Close();
	m_pSet->m_strFilter=col+"='"+FindRecorddlg.m_search+"'";//按字段进行查询
	m_pSet->Open();
	UpdateData(FALSE);
}

void CODBCView::OnSortRecord() 
{
	// TODO: Add your command handler code here
	UpdateData(TRUE);
	CFINDRECORDdlg FindRecorddlg;
	FindRecorddlg.DoModal();
	m_pSet->Close();
	m_pSet->m_strSort=FindRecorddlg.m_search;
	m_pSet->Open();
	UpdateData(FALSE);	
}