e1102view.cpp

一个vc6.0的通讯录代码范例,适合新手入门

// E1102View.cpp : implementation of the CE1102View class
//

#include "stdafx.h"
#include "E1102.h"

#include "E1102Doc.h"
#include "E1102View.h"

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

/////////////////////////////////////////////////////////////////////////////
// CE1102View

IMPLEMENT_DYNCREATE(CE1102View, CView)

BEGIN_MESSAGE_MAP(CE1102View, CView)
	//{{AFX_MSG_MAP(CE1102View)
	ON_COMMAND(ID_RECORD_ADD, OnRecordAdd)
	ON_COMMAND(ID_RECORD_COUNT, OnRecordCount)
	ON_COMMAND(ID_RECORD_DELETE, OnRecordDelete)
	ON_COMMAND(ID_RECORD_EDIT, OnRecordEdit)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CE1102View construction/destruction

CE1102View::CE1102View()
{
	// TODO: add construction code here

}

CE1102View::~CE1102View()
{
}

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

	return CView::PreCreateWindow(cs);
}

/////////////////////////////////////////////////////////////////////////////
// CE1102View drawing

void CE1102View::OnDraw(CDC* pDC)
{
	CE1102Doc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
	// TODO: add draw code for native data here
	CString s1,s2,s3,s4,str;
	int pos = 0;
	COleVariant var;
	CDaoRecordset rs(&(pDoc->m_DB));
	rs.Open(AFX_DAO_USE_DEFAULT_TYPE, "SELECT * FROM 联系人", 0);
	while(!rs.IsEOF())
	{
		pos += 50;
		rs.GetFieldValue("姓名", var);
		s1 = var.pbVal;
		rs.GetFieldValue("性别", var);
		s2 = var.pbVal;
		rs.GetFieldValue("生日", var);
		s3 = var.pbVal;
		rs.GetFieldValue("手机号", var);
		s4 = var.pbVal;
		str = "记录："+s1+"   "+s2+"   "+s3+"   "+s4;
		pDC->TextOut(50, pos, str);
		rs.MoveNext();
	}
	rs.Close();	
}

/////////////////////////////////////////////////////////////////////////////
// CE1102View printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CE1102View diagnostics

#ifdef _DEBUG
void CE1102View::AssertValid() const
{
	CView::AssertValid();
}

void CE1102View::Dump(CDumpContext& dc) const
{
	CView::Dump(dc);
}

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

/////////////////////////////////////////////////////////////////////////////
// CE1102View message handlers

void CE1102View::OnRecordAdd() 
{
	CDaoRecordset rs(&(GetDocument()->m_DB));
	rs.Open(AFX_DAO_USE_DEFAULT_TYPE, "SELECT * FROM 联系人", 0);
	rs.AddNew();
	rs.SetFieldValue("姓名", "丽莎");
	rs.SetFieldValue("性别", "女");
	rs.SetFieldValue("生日", "1999-01-01");
	rs.SetFieldValue("手机号", "13366465598");
	rs.Update();
	rs.Close();
	Invalidate();
}

void CE1102View::OnRecordCount() 
{
	CDaoTableDef td(&(GetDocument()->m_DB));
	td.Open("联系人");
	int count = td.GetRecordCount();
	td.Close();
	CString str;
	str.Format("%d", count);
	AfxMessageBox(str);
}

void CE1102View::OnRecordDelete() 
{
	CDaoRecordset rs(&(GetDocument()->m_DB));
	rs.Open(AFX_DAO_USE_DEFAULT_TYPE, "SELECT * FROM 联系人 WHERE 姓名='玛丽'", 0);	
	rs.Delete();		
	rs.Close();
	Invalidate();
}

void CE1102View::OnRecordEdit() 
{
	CDaoRecordset rs(&(GetDocument()->m_DB));
	rs.Open(AFX_DAO_USE_DEFAULT_TYPE, "SELECT * FROM 联系人 WHERE 姓名='丽莎'", 0);	
	rs.Edit();
	rs.SetFieldValue("姓名", "丽莎2");
	rs.Update();		
	rs.Close();
	Invalidate();
}