modifybookinfodlg.cpp

mysql+visual C++编写的mini图书馆数据库管理系统

// ModifyBookInfoDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ModifyBookInfoDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CModifyBookInfoDlg dialog


CModifyBookInfoDlg::CModifyBookInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CModifyBookInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CModifyBookInfoDlg)
	m_BookAuthor = _T("");
	m_BookDate = 0;
	m_BookKind = _T("");
	m_BookNum = _T("");
	m_BookPress = _T("");
	m_BookTitle = _T("");
	m_bookNumOld = _T("");
	m_BookTotal = 0;
	m_BookPrice = 0.0;
	//}}AFX_DATA_INIT
}


void CModifyBookInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModifyBookInfoDlg)
	DDX_Text(pDX, IDC_BOOK_AUTHOR, m_BookAuthor);
	DDX_DateTimeCtrl(pDX, IDC_BOOK_DATE, m_BookDate);
	DDX_Text(pDX, IDC_BOOK_KIND, m_BookKind);
	DDX_Text(pDX, IDC_BOOK_NUM, m_BookNum);
	DDX_Text(pDX, IDC_BOOK_PRESS, m_BookPress);
	DDX_Text(pDX, IDC_BOOK_TITLE, m_BookTitle);
	DDX_Text(pDX, IDC_BOOKNUM_OLD, m_bookNumOld);
	DDX_Text(pDX, IDC_BOOK_TOTAL, m_BookTotal);
	DDX_Text(pDX, IDC_BOOK_PRICE, m_BookPrice);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CModifyBookInfoDlg, CDialog)
	//{{AFX_MSG_MAP(CModifyBookInfoDlg)
	ON_BN_CLICKED(IDC_SURE, OnSure)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CModifyBookInfoDlg message handlers

void CModifyBookInfoDlg::OnSure() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(!m_bookSet.IsOpen()){
		m_bookSet.Open();
	}
	m_bookSet.m_strFilter.Format("ISBN='%s'",m_bookNumOld);
	m_bookSet.Requery();
	if(!m_bookSet.IsEOF())
	{
		m_BookNum=m_bookSet.m_ISBN;
		m_BookKind=m_bookSet.m_kind;
		m_BookTitle=m_bookSet.m_title;
		m_BookPress=m_bookSet.m_press;
		m_BookAuthor=m_bookSet.m_authors;
		m_BookDate=m_bookSet.m_pub_date;
		m_BookPrice=m_bookSet.m_price;
		m_BookTotal=m_bookSet.m_total_num;
		UpdateData(FALSE);
	}
	else
	{
		AfxMessageBox("对不起，您输入的书号不存在!");
        CDialog::OnOK();
	}	
}

void CModifyBookInfoDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	m_bookSet.Edit();
	m_bookSet.m_ISBN=m_BookNum;
	m_bookSet.m_kind=m_BookKind;
	m_bookSet.m_title=m_BookTitle;
	m_bookSet.m_press=m_BookPress;
	m_bookSet.m_authors=m_BookAuthor;
	m_bookSet.m_pub_date=m_BookDate;
	m_bookSet.m_price=m_BookPrice;
	m_bookSet.m_total_num=m_BookTotal;
	m_bookSet.m_stock_num=m_BookTotal;
	m_bookSet.Update();
	AfxMessageBox("修改图书信息成功!");
	CDialog::OnOK();	
}