passwordsview.cpp

< Visual C++数据库经典开发实例精解>>的实例源码

// PasswordsView.cpp : implementation of the CPasswordsView class
//

#include "stdafx.h"
#include "Passwords.h"

#include "PasswordsSet.h"
#include "PasswordsDoc.h"
#include "PasswordsView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPasswordsView

IMPLEMENT_DYNCREATE(CPasswordsView, COleDBRecordView)

BEGIN_MESSAGE_MAP(CPasswordsView, COleDBRecordView)
	//{{AFX_MSG_MAP(CPasswordsView)
	ON_BN_CLICKED(IDC_BUTTON_DELETE, OnButtonDelete)
	ON_BN_CLICKED(IDC_BUTTON_INSERT, OnButtonInsert)
	ON_BN_CLICKED(IDC_BUTTON_QUERY, OnButtonQuery)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, COleDBRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, COleDBRecordView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, COleDBRecordView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPasswordsView construction/destruction

CPasswordsView::CPasswordsView()
	: COleDBRecordView(CPasswordsView::IDD)
{
	//{{AFX_DATA_INIT(CPasswordsView)
	m_key = _T("");
	//}}AFX_DATA_INIT
	// TODO: add construction code here

}

CPasswordsView::~CPasswordsView()
{
}

void CPasswordsView::DoDataExchange(CDataExchange* pDX)
{
	COleDBRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPasswordsView)
	DDX_Text(pDX, IDC_EDIT_KEY, m_key);
	DDX_Text(pDX,IDC_EDIT_USERID/*控件ID*/,
				 m_pSet->m_userid/*行集字段*/,
				 15/*字段长度*/);
	DDX_Text(pDX,IDC_EDIT_PASSWORD,m_pSet->m_password,10);

	//}}AFX_DATA_MAP
}

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

	return COleDBRecordView::PreCreateWindow(cs);
}

void CPasswordsView::OnInitialUpdate()
{
	m_pSet = &GetDocument()->m_passwordsSet;
	{
		CWaitCursor wait;
		HRESULT hr = m_pSet->Open();
		if (hr != S_OK)
		{
			AfxMessageBox(_T("Record set failed to open."), MB_OK);
			// Disable the Next and Previous record commands,
			// since attempting to change the current record without an
			// open RecordSet will cause a crash.
			m_bOnFirstRecord = TRUE;
			m_bOnLastRecord = TRUE;
		}				
	}
	COleDBRecordView::OnInitialUpdate();

}

/////////////////////////////////////////////////////////////////////////////
// CPasswordsView printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CPasswordsView diagnostics

#ifdef _DEBUG
void CPasswordsView::AssertValid() const
{
	COleDBRecordView::AssertValid();
}

void CPasswordsView::Dump(CDumpContext& dc) const
{
	COleDBRecordView::Dump(dc);
}

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

/////////////////////////////////////////////////////////////////////////////
// CPasswordsView database support
CRowset* CPasswordsView::OnGetRowset()
{
	return m_pSet;
}


/////////////////////////////////////////////////////////////////////////////
// CPasswordsView message handlers

void CPasswordsView::OnButtonDelete() 
{
	if (MessageBox("删除当前记录？",NULL,MB_YESNO)==IDYES)
	{		
		m_pSet->Delete();//确认删除后，输出当前记录
		if(!OnMove(ID_RECORD_NEXT))//使下一条记录成为当前记录
			if(!OnMove(ID_RECORD_LAST))//若没有下一条记录，则使最后一条记录成为当前记录
			{
				//若没有记录，则设置记录首和记录尾标志				
				m_bOnFirstRecord=true;//该标记为true,则禁止向前移动记录指针
				m_bOnLastRecord=true;//该标记为true,则禁止向后移动记录指针
			}
	}	
}

void CPasswordsView::OnButtonInsert() 
{
	UpdateData(true);//将窗口数据写入行集
	m_pSet->Insert();//使用添加数据创建新记录
	m_pSet->MoveLast();//使新记录成为当前记录	
	if(m_bOnFirstRecord && m_bOnLastRecord)
	{	//若以前没有记录，则设置记录首和记录尾标志
		//以便启用记录导航工具栏按钮和菜单命令
		m_bOnFirstRecord=false;
		m_bOnLastRecord=false;
	}	
}

void CPasswordsView::OnButtonQuery() 
{	UpdateData(true);
	CString oldid;
	oldid=m_pSet->m_userid;
	OnMove(ID_RECORD_FIRST);
	while(m_bOnLastRecord==false)
	{
		if(m_key==m_pSet->m_userid)
		{
			UpdateData(false);
			return;
		}
		OnMove(ID_RECORD_NEXT);
	}
	MessageBox("没有找到符合条件的记录");
	OnMove(ID_RECORD_FIRST);
	while(!m_bOnLastRecord)
	{
		if(oldid==m_pSet->m_userid)
		{
			UpdateData(false);
			return;
		}
		OnMove(ID_RECORD_NEXT);
	}
}