obdc1view.cpp

使用OBDC的数据库小程序～是我学习ＶＣ＋数据库的第一个小程序～对初学者很有用～

// OBDC1View.cpp : implementation of the COBDC1View class
//

#include "stdafx.h"
#include "OBDC1.h"

#include "OBDC1Set.h"
#include "OBDC1Doc.h"
#include "OBDC1View.h"
#include "Delete_Dlg.h"
#include "RecordFine.h"

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

/////////////////////////////////////////////////////////////////////////////
// COBDC1View

IMPLEMENT_DYNCREATE(COBDC1View, CRecordView)

BEGIN_MESSAGE_MAP(COBDC1View, CRecordView)
	//{{AFX_MSG_MAP(COBDC1View)
	ON_COMMAND(ID_RECPRD_APPEND, OnRecprdAppend)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_RECORD_FIND, OnRecordFind)
	//}}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()

/////////////////////////////////////////////////////////////////////////////
// COBDC1View construction/destruction

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

}

COBDC1View::~COBDC1View()
{
}

void COBDC1View::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(COBDC1View)
	DDX_Control(pDX, IDC_WORKPHOTO, m_Workphoto1);
	DDX_Control(pDX, IDC_POSTALCODE, m_Postalcode1);
	DDX_Control(pDX, IDC_BIRTHDAY, m_Birthdate1);
	DDX_Control(pDX, IDC_NAME, m_Name1);
	DDX_Control(pDX, IDC_HOMEPHOTO, m_Homephoto1);
	DDX_Control(pDX, IDC_HOBBILES, m_Hobbiles1);
	DDX_Control(pDX, IDC_ADDRESS, m_Address1);
	DDX_Control(pDX, IDC_BUTTON2, m_Noadd);
	DDX_Control(pDX, IDC_BUTTON1, m_Add);
	DDX_FieldText(pDX, IDC_NAME, m_pSet->m_Name, m_pSet);
	DDX_FieldText(pDX, IDC_BIRTHDAY, m_pSet->m_Birthdate, m_pSet);
	DDX_FieldText(pDX, IDC_HOMEPHOTO, m_pSet->m_Home_photo, m_pSet);
	DDX_FieldText(pDX, IDC_WORKPHOTO, m_pSet->m_Work_photo, m_pSet);
	DDX_FieldText(pDX, IDC_POSTALCODE, m_pSet->m_Postal_Code, m_pSet);
	DDX_FieldText(pDX, IDC_HOBBILES, m_pSet->m_hobbies, m_pSet);
	DDX_FieldText(pDX, IDC_ADDRESS, m_pSet->m_Address, m_pSet);
	//}}AFX_DATA_MAP
}

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

	return CRecordView::PreCreateWindow(cs);
}

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

}

/////////////////////////////////////////////////////////////////////////////
// COBDC1View printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// COBDC1View diagnostics

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

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

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

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


/////////////////////////////////////////////////////////////////////////////
// COBDC1View message handlers



void COBDC1View::OnRecprdAppend() 
{
if(m_pSet->CanAppend()==0)
  MessageBox("不能增加新的记录。","Database Opening Error",MB_OK|MB_ICONERROR);
else
{
m_Add.SetWindowText("添加");
m_Noadd.SetWindowText("取消添加");
m_Add.ShowWindow(SW_SHOW);
m_Noadd.ShowWindow(SW_SHOW);

m_Name1.SetWindowText("");
m_Birthdate1.SetWindowText("");
m_Homephoto1.SetWindowText("");
m_Hobbiles1.SetWindowText("");
m_Address1.SetWindowText("");
m_Postalcode1.SetWindowText("");
m_Workphoto1.SetWindowText("");
}

}

void COBDC1View::OnButton1() 
{
CString cValue;//接收编辑框中的值
/*BOOL lNew=TRUE;//判断是否新记录
m_Name1.GetWindowText(cValue);
m_pSet->MoveFirst();

 while(!m_pSet->IsBOF()^!lNew)
 {
   if(cValue==m_pSet->m_Name)
     lNew=FALSE;
     m_pSet->MoveNext();
 }
*/

m_pSet->AddNew();

m_Name1.GetWindowText(cValue);
m_pSet->m_Name=cValue;
m_Birthdate1.GetWindowText(cValue);
m_pSet->m_Birthdate=cValue;
m_Homephoto1.GetWindowText(cValue);
m_pSet->m_Home_photo=cValue;
m_Hobbiles1.GetWindowText(cValue);
m_pSet->m_hobbies=cValue;
m_Address1.GetWindowText(cValue);
m_pSet->m_Address=cValue;
m_Postalcode1.GetWindowText(cValue);
m_pSet->m_Postal_Code=cValue;
m_Workphoto1.GetWindowText(cValue);
m_pSet->m_Work_photo=cValue;
 
m_pSet->Update();
m_pSet->MoveLast();

m_Add.ShowWindow(SW_HIDE);
m_Noadd.ShowWindow(SW_HIDE);

}

void COBDC1View::OnButton2() 
{
m_Add.ShowWindow(SW_HIDE);
m_Noadd.ShowWindow(SW_HIDE);

m_Name1.SetWindowText(m_pSet->m_Name);
m_Birthdate1.SetWindowText(m_pSet->m_Birthdate);
m_Homephoto1.SetWindowText(m_pSet->m_Home_photo);
m_Hobbiles1.SetWindowText(m_pSet->m_hobbies);
m_Address1.SetWindowText(m_pSet->m_Address);
m_Postalcode1.SetWindowText(m_pSet->m_Postal_Code);
m_Workphoto1.SetWindowText(m_pSet->m_Work_photo);
}


void COBDC1View::OnButton3() 
{
Delete_Dlg deldlg;
 if(deldlg.DoModal()==IDOK)
 {
	 m_pSet->Delete();
     m_pSet->MoveNext();

	 if(m_pSet->IsEOF())
		 m_pSet->MoveLast();
	 if(m_pSet->IsEOF())
		 m_pSet->SetFieldNull(NULL);
	     UpdateData(FALSE);
 }

}



void COBDC1View::OnRecordFind() 
{
	CRecordFine finedlg;
	BOOL lFound=FALSE;
	CDBVariant varBookMark;

    if(finedlg.DoModal()==IDOK)
	{
	   if(m_pSet->CanBookmark())
		   m_pSet->GetBookmark(varBookMark);
	       m_pSet->MoveFirst();
      while(!m_pSet->IsEOF()^lFound)
	  {
	  if(m_pSet->m_Name==finedlg.m_FindName)
		  lFound=TRUE;
	  else
		  m_pSet->MoveNext();

	  }
     
	if(!lFound)
	{
		MessageBox("无此记录","Database Error",MB_OK|MB_ICONERROR);
		if(m_pSet->CanBookmark())
			m_pSet->SetBookmark(varBookMark);
		else
			m_pSet->MoveFirst();
    } 
    else
	{
		m_Name1.SetWindowText(m_pSet->m_Name);
        m_Birthdate1.SetWindowText(m_pSet->m_Birthdate);
        m_Homephoto1.SetWindowText(m_pSet->m_Home_photo);
        m_Hobbiles1.SetWindowText(m_pSet->m_hobbies);
        m_Address1.SetWindowText(m_pSet->m_Address);
        m_Postalcode1.SetWindowText(m_pSet->m_Postal_Code);
        m_Workphoto1.SetWindowText(m_pSet->m_Work_photo);

    }
	}
	
	
}