readeradddlg.cpp

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

// ReaderAddDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "ReaderAddDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReaderAddDlg dialog


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


void CReaderAddDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderAddDlg)
	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_CBString(pDX, IDC_CMB_DUTY, m_duty);
	DDV_MaxChars(pDX, m_duty, 20);
	DDX_CBString(pDX, IDC_CMB_DEPART, m_depart);
	DDV_MaxChars(pDX, m_depart, 20);
	DDX_Radio(pDX, IDC_RADIO1, m_sex);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReaderAddDlg, CDialog)
	//{{AFX_MSG_MAP(CReaderAddDlg)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReaderAddDlg message handlers

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

	CString sql,name;
	sql.Format("Select 姓名 from 读者表 where 姓名='%s'",m_name);
	g_adoDB.ExecuteQueryValue(sql,name);//查询该读者姓名是否已经存在
	if(!name.IsEmpty())	//如果已经存在
	{
		if(MessageBox("该姓名已经存在,确定是重名的新读者吗?","消息",MB_OKCANCEL)!=IDOK)
			return;
	}

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

	CString strID;
	g_adoDB.ExecuteQueryValue("Select max(readerID) from 读者表",strID);
	int newID=atoi(strID)+1;

	sql.Format("Insert into 读者表 values(%d,'%s','%s',%d,'%s','%s','%s','%s','%s')"
		,newID,m_name,(m_sex==0)?"男":"女",m_age,m_duty,m_depart,m_tel,m_cert,m_remark);
	g_adoDB.Execute(sql);
	
	OnCancel();		
}