readernewdlg.cpp

图书管理系统的源码。很好用的源码

// ReaderNewDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ReaderNewDlg.h"
#include "readertypeset.h"
#include "readerInfoset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReaderNewDlg dialog


CReaderNewDlg::CReaderNewDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CReaderNewDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReaderNewDlg)
	m_strSex = _T("");
	m_strType = _T("");
	m_tmDate = CTime::GetCurrentTime();;
	m_strAddress = _T("");
	m_strBrief = _T("");
	m_strCode = _T("");
	m_strDept = _T("");
	m_strName = _T("");
	m_strPhone = _T("");
	//}}AFX_DATA_INIT
}


void CReaderNewDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderNewDlg)
	DDX_Control(pDX, IDC_COMBO_TYPE, m_ctrType);
	DDX_CBString(pDX, IDC_COMBO_SEX, m_strSex);
	DDX_CBString(pDX, IDC_COMBO_TYPE, m_strType);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_tmDate);
	DDX_Text(pDX, IDC_EDIT_ADDRESS, m_strAddress);
	DDX_Text(pDX, IDC_EDIT_BRIESF, m_strBrief);
	DDX_Text(pDX, IDC_EDIT_CODE, m_strCode);
	DDX_Text(pDX, IDC_EDIT_DEPT, m_strDept);
	DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
	DDX_Text(pDX, IDC_EDIT_PHONE, m_strPhone);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CReaderNewDlg message handlers

void CReaderNewDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	//检查输入数据
	if(m_strCode.IsEmpty())
	{
		AfxMessageBox("请输入读者编号！");
		return;
	}
	if(m_strName.IsEmpty())
	{
		AfxMessageBox("请输入读者姓名！");
		return;
	}
	if(m_strType.IsEmpty())
	{
		AfxMessageBox("请输入读者类别！");
		return;
	}
	//保存读者信息到数据库中
	CString strSQL;
	strSQL.Format("select * from readerInfo where code = '%s'",m_strCode);
	CReaderInfoSet  rs;
	if(!rs.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	if(rs.GetRecordCount()!=0)
	{
		rs.Close();
		AfxMessageBox("该编号已经存在，请重新输入！");
		return;
	}
	rs.Close();
	if(!rs.Open(AFX_DB_USE_DEFAULT_TYPE))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	//添加读者记录
	rs.AddNew();
	rs.m_address = m_strAddress;
	rs.m_brief = m_strBrief;
	rs.m_code = m_strCode;
	rs.m_dept = m_strDept;
	rs.m_name = m_strName;
	rs.m_phone = m_strPhone;
	rs.m_reg_date = m_tmDate;
	rs.m_sex = m_strSex;
	rs.m_type = m_strType;
	rs.Update();
	rs.Close();
	if(IDOK==AfxMessageBox("读者登记成功！是否登记下一个读者？",MB_OKCANCEL))
		return;
	CDialog::OnOK();
}

BOOL CReaderNewDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	CReaderTypeSet recordset ;
	CString strSQL;
	UpdateData(TRUE);
	strSQL="select * from readerType";
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return FALSE;
	}	

	while(!recordset.IsEOF())
	{
		m_ctrType.AddString(recordset.m_type);
		recordset.MoveNext();
	}
	recordset.Close();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}