qurclerkdlg.cpp

来自「实现建议的图书馆管理系统 数据库为acce」· C++ 代码 · 共 155 行

// QurClerkDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "QurClerkDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQurClerkDlg dialog


CQurClerkDlg::CQurClerkDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQurClerkDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQurClerkDlg)
	m_Name = _T("");
	m_ClerkID = _T("");
	m_Officer = _T("");
	m_QurID = _T("");
	m_QurName = _T("");
	//}}AFX_DATA_INIT
}


void CQurClerkDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQurClerkDlg)
	DDX_Text(pDX, IDC_NAME, m_Name);
	DDX_Text(pDX, IDC_CLERKID, m_ClerkID);
	DDX_Text(pDX, IDC_OFFICER, m_Officer);
	DDX_Text(pDX, IDC_QURID, m_QurID);
	DDX_Text(pDX, IDC_QURNAME, m_QurName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQurClerkDlg, CDialog)
	//{{AFX_MSG_MAP(CQurClerkDlg)
	ON_BN_CLICKED(IDC_BUTTON_NEXT, OnButtonNext)
	ON_BN_CLICKED(IDC_BUTTON_PRE, OnButtonPre)
	ON_BN_CLICKED(IDC_BUTTON_QURID, OnButtonQurid)
	ON_BN_CLICKED(IDC_BUTTON_QURNAME, OnButtonQurname)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQurClerkDlg message handlers

void CQurClerkDlg::OnButtonNext() 
{
	// TODO: Add your control notification handler code here
	if(!clkSet.IsEOF())
	{
		clkSet.MoveNext();
		DisplayRecord();

	}
}

void CQurClerkDlg::OnButtonPre() 
{
	// TODO: Add your control notification handler code here
	if(!clkSet.IsBOF())
	{
		clkSet.MovePrev();
		DisplayRecord();
	}
}

void CQurClerkDlg::OnButtonQurid() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(clkSet.IsOpen())
	{
		clkSet.Close();
	}
	CString sqlStr;
	sqlStr="SELECT * FROM CLERK WHERE CLERK_ID='";
	sqlStr+=m_QurID;
	sqlStr+="'";
	if(!clkSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("clerk表打开失败!");
	}
	if(clkSet.IsEOF()&&clkSet.IsBOF())
	{
		AfxMessageBox("不存在该职员!");
	}
	DisplayRecord();
	
}

void CQurClerkDlg::OnButtonQurname() 
{
	// TODO: Add your control notification handler code here

	UpdateData(true);
	if(clkSet.IsOpen())
	{
		clkSet.Close();
	}
	clkSet.m_strFilter="[NAME] like '%";
	clkSet.m_strFilter+=m_QurName;
	clkSet.m_strFilter+="%'";
	MessageBox(clkSet.m_strFilter);
    if(!clkSet.Open())
	{
		AfxMessageBox("clerk表打开失败!");
	}
	if(clkSet.IsBOF()&&clkSet.IsEOF())
	{
		AfxMessageBox("没有相应职员!");

	}
	DisplayRecord();

}

bool CQurClerkDlg::DisplayRecord()
{
	if(clkSet.IsEOF()&&clkSet.IsBOF())
	{
		m_ClerkID="";
		m_Name="";
		m_Officer="";
	}
	else
	{
		if(clkSet.IsBOF())
		{
			clkSet.MoveNext();
		}
		else
		{
			if(clkSet.IsEOF())
			{
				clkSet.MovePrev();
			}
		}
	}
	m_ClerkID=clkSet.m_CLERK_ID;
	m_Name=clkSet.m_NAME;
	m_Officer=clkSet.m_OFFICIER;
	UpdateData(false);
	return true;
}