readermodidlg.cpp

自己编写的迷你图书馆的完整程序.VC6MFC编写的,Windows界面.数据采用了Sqlserver2000.压缩包中已包括了数据库.先附加数据库再运行.

// ReaderModiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "ReaderModiDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReaderModiDlg dialog


CReaderModiDlg::CReaderModiDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CReaderModiDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReaderModiDlg)
	m_depart = _T("");
	m_duty = _T("");
	m_age = 0;
	m_cert = _T("");
	m_name = _T("");
	m_remark = _T("");
	m_tel = _T("");
	m_sex = -1;
	//}}AFX_DATA_INIT
}


void CReaderModiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderModiDlg)
	DDX_CBString(pDX, IDC_CMB_DEPART, m_depart);
	DDV_MaxChars(pDX, m_depart, 20);
	DDX_CBString(pDX, IDC_CMB_DUTY, m_duty);
	DDV_MaxChars(pDX, m_duty, 20);
	DDX_Text(pDX, IDC_EDIT_AGE, m_age);
	DDV_MinMaxInt(pDX, m_age, 1, 99);
	DDX_Text(pDX, IDC_EDIT_CERT, m_cert);
	DDV_MaxChars(pDX, m_cert, 20);
	DDX_Text(pDX, IDC_EDIT_NAME, m_name);
	DDV_MaxChars(pDX, m_name, 10);
	DDX_Text(pDX, IDC_EDIT_REMARK, m_remark);
	DDV_MaxChars(pDX, m_remark, 100);
	DDX_Text(pDX, IDC_EDIT_TEL, m_tel);
	DDV_MaxChars(pDX, m_tel, 20);
	DDX_Radio(pDX, IDC_RADIO1, m_sex);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReaderModiDlg, CDialog)
	//{{AFX_MSG_MAP(CReaderModiDlg)
	ON_BN_CLICKED(IDC_BTN_MODI, OnBtnModi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReaderModiDlg message handlers

void CReaderModiDlg::OnBtnModi() 
{
	if(!UpdateData()) return;
	if(m_name.IsEmpty())
	{
		MessageBox("请输入读者姓名!","错误");
		return;
	}
	if(m_cert.IsEmpty())
	{
		MessageBox("请输入证件号!","错误");
		return;
	}

	CString sql,cert;
	sql.Format("Select 证件号 from 读者表 where 证件号='%s' and readerID!=%d",m_cert,atoi(rid));
	g_adoDB.ExecuteQueryValue(sql,cert);
	if(!cert.IsEmpty())
	{
		MessageBox("该证件号已经存在!","错误");//证件号必须唯一
		return;
	}

	sql.Format("Update 读者表 set 姓名='%s',性别='%s',年龄=%d,职务='%s',单位='%s',电话='%s',证件号='%s',备注='%s' "
		" where readerID=%d "
		,m_name,(m_sex==0)?"男":"女",m_age,m_duty,m_depart,m_tel,m_cert,m_remark,atoi(rid));
	g_adoDB.Execute(sql);

	OnCancel();		
}