readerdlg.cpp

此源程序是图书馆管理系统

// ReaderDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "ReaderDlg.h"
#include "ReaderSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReaderDlg dialog


CReaderDlg::CReaderDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CReaderDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReaderDlg)
	m_ReaderId = _T("");
	m_ReaderName = _T("");
	m_IdCard = _T("");
	m_MaxBorrow = 0;
	//}}AFX_DATA_INIT
}


void CReaderDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderDlg)
	DDX_Text(pDX, IDC_EDIT1, m_ReaderId);
	DDX_Text(pDX, IDC_EDIT2, m_ReaderName);
	DDX_Text(pDX, IDC_EDIT3, m_IdCard);
	DDX_Text(pDX, IDC_EDIT4, m_MaxBorrow);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReaderDlg, CDialog)
	//{{AFX_MSG_MAP(CReaderDlg)
	ON_BN_CLICKED(IDC_BUTTON_FIRST, OnButtonFirst)
	ON_BN_CLICKED(IDC_BUTTON_NEXT, OnButtonNext)
	ON_BN_CLICKED(IDC_BUTTON_FORWORD, OnButtonForword)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_SAVE, OnSave)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	ON_BN_CLICKED(IDC_LAST, OnLast)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReaderDlg message handlers

void CReaderDlg::OnButtonFirst() 
{
	// TODO: Add your control notification handler code here
	if(!rdSet.IsBOF())
	{
		rdSet.MoveFirst();
		DisplayRecord();
	}

	
}

BOOL CReaderDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	CString mSqlstr;

	mSqlstr="SELECT * FROM READER";
	if(!rdSet.Open(AFX_DB_USE_DEFAULT_TYPE,mSqlstr))
	{
		AfxMessageBox("reader表打开失败!");
	}
	m_bAdd=false;
	m_bEdit=false;
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

bool CReaderDlg::DisplayRecord()
{
	if(rdSet.IsEOF()&rdSet.IsBOF())
	{
		m_IdCard="";
		m_MaxBorrow=0;
		m_ReaderId="";
		m_ReaderName="";
	}
	else
	{
		if(rdSet.IsBOF())
		{
			rdSet.MoveNext();
		}
		else
		{
			if(rdSet.IsEOF())
			{
				rdSet.MovePrev();
			}
		}
	}
	m_IdCard=rdSet.m_IDCARD;
	m_MaxBorrow=rdSet.m_MAXNUM_CAN_BORROW;
	m_ReaderId=rdSet.m_READER_ID;
	m_ReaderName=rdSet.m_NAME;
	UpdateData(false);
	return true;
}

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

void CReaderDlg::OnButtonForword() 
{
	// TODO: Add your control notification handler code here
	if(!rdSet.IsBOF())
	{
		rdSet.MovePrev();
		DisplayRecord();
	}
	
}

void CReaderDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	m_IdCard="";
	m_MaxBorrow=0;
	m_ReaderId="";
	m_ReaderName="";
	UpdateData(false);
	m_bAdd=true;


}

void CReaderDlg::OnSave() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(m_IdCard.IsEmpty()||m_ReaderId.IsEmpty()||m_ReaderName.IsEmpty())
	{
		AfxMessageBox("请输入相应的数据");
	}
	if(m_bAdd)
	{
	    rdSet.AddNew();
	}
    else 
	{
		rdSet.Edit();
	}
	rdSet.m_IDCARD=m_IdCard;
	rdSet.m_MAXNUM_CAN_BORROW=m_MaxBorrow;
	rdSet.m_NAME=m_ReaderName;
	rdSet.m_READER_ID=m_ReaderId;
	rdSet.m_FLAG_BORROW="y";
	rdSet.Update();
	rdSet.Requery();
	DisplayRecord();
	m_bAdd=false;
	m_bEdit=false;
	
}

void CReaderDlg::OnEdit() 
{
	// TODO: Add your control notification handler code here
	m_bEdit=true;
}

void CReaderDlg::OnLast() 
{
	// TODO: Add your control notification handler code here
	if(!rdSet.IsEOF())
	{
		rdSet.MoveLast();
		DisplayRecord();
	}
	
}