modifyloaddlg.cpp

一个C++和SQL的图书管理系统 功能不多 大家可以下来

// ModifyLoadDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CModifyLoadDlg dialog


CModifyLoadDlg::CModifyLoadDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CModifyLoadDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CModifyLoadDlg)
	m_readerid = _T("");
	//}}AFX_DATA_INIT
	m_address =_T("");
	m_age=_T("");
	m_name=_T("");
	m_other=_T("");
	m_phone=_T("");
}


void CModifyLoadDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CModifyLoadDlg)
	DDX_Text(pDX, IDC_READID, m_readerid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CModifyLoadDlg, CDialog)
	//{{AFX_MSG_MAP(CModifyLoadDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CModifyLoadDlg message handlers

void CModifyLoadDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();

	CReaderSet	m_readerSet;
	CString	strsql;
	
	strsql.Format("select * from Reader where CardID = '%s'",m_readerid);
	if(!m_readerSet.Open(AFX_DB_USE_DEFAULT_TYPE,strsql))
	{
		AfxMessageBox("连接数据库错误");
		return;
	}
	if(0 == m_readerSet.GetRecordCount())
	{
		AfxMessageBox("该用户不存在，请重新输入");
		m_readerSet.Close();
		return;
	}
	else
	{
		m_address =m_readerSet.m_Address;
		m_age=m_readerSet.m_Age;
		m_name=m_readerSet.m_Name;
		m_other=m_readerSet.m_Other;
		m_phone=m_readerSet.m_Phone;
		m_readerSet.Close();
		CDialog::OnOK();
	}
}