finddlg.cpp

一个用ODBC访问Access的实例

// FindDlg.cpp : implementation file
//

#include "stdafx.h"
#include "vocabulory.h"
#include "FindDlg.h"
#include "Alert1.h"
#include "Alert2.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFindDlg dialog


CFindDlg::CFindDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CFindDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFindDlg)
	m_Eword = _T("");
	m_Cword = _T("");
	m_Addition = _T("");
	//}}AFX_DATA_INIT
}


void CFindDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFindDlg)
	DDX_Text(pDX, IDC_EDIT1, m_Eword);
	DDX_Text(pDX, IDC_EDIT2, m_Cword);
	DDX_Text(pDX, IDC_EDIT3, m_Addition);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFindDlg, CDialog)
	//{{AFX_MSG_MAP(CFindDlg)
	ON_BN_CLICKED(IDC_FIND, OnFind)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFindDlg message handlers

void CFindDlg::OnFind() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(wordset.IsOpen())
	{
		wordset.Close();
	}
	CString sqlStr;
	sqlStr="SELECT * FROM VOCABULORY WHERE 英文='";
	sqlStr+=m_Eword;
	sqlStr+="'";
	if(!wordset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("单词表打开失败!");
	}
	if(wordset.IsEOF()&&wordset.IsBOF())
	{
		AfxMessageBox("不存在该单词!");
	}
	DisplayRecord();
}

bool CFindDlg::DisplayRecord()
{
	if(wordset.IsEOF()&&wordset.IsBOF())
	{
		m_Eword="";
		m_Cword="";
		m_Addition="";
		return true;
	}
	else
	{
		if(wordset.IsBOF())
		{
			wordset.MoveNext();
		}
		else if(wordset.IsEOF())
		{
			wordset.MovePrev();
		}
	}
	m_Eword = wordset.m_Eword;
	m_Cword = wordset.m_Cword;
	m_Addition = wordset.m_Addition;
	UpdateData(false);
	return true;	
}

void CFindDlg::OnDelete() 
{
	CAlert2 dlg;
	if(dlg.DoModal()==IDOK)
	{
		wordset.Delete();
		wordset.Requery();
		MessageBox("该词已删除!");
		m_Eword = "";
		m_Cword = "";
		m_Addition = "";
		UpdateData(false);
	}
}

void CFindDlg::OnEdit() 
{
	CAlert1 dlg;
	if(dlg.DoModal()==IDOK)
	{
		UpdateData(true);
		wordset.Edit();
		wordset.m_Eword = m_Eword;
		wordset.m_Cword = m_Cword;
		wordset.m_Addition = m_Addition;
		if(wordset.Update())
		{
			wordset.Requery();
			MessageBox("修改成功!");
		}
	}
}

void CFindDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	if(wordset.IsOpen())
	{
		wordset.Close();
	}
	CDialog::OnCancel();
}