newreaderdlg.cpp

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

// NewReaderDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CNewReaderDlg dialog


CNewReaderDlg::CNewReaderDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CNewReaderDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CNewReaderDlg)
	m_address = _T("");
	m_age = _T("");
	m_ReaderID = _T("");
	m_name = _T("");
	m_other = _T("");
	m_phone = _T("");
	m_registerTime = _T("");
	m_sex = _T("");
	//}}AFX_DATA_INIT
}


void CNewReaderDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNewReaderDlg)
	DDX_Text(pDX, IDC_READER_ADDRESS, m_address);
	DDX_Text(pDX, IDC_READER_AGE, m_age);
	DDX_Text(pDX, IDC_READER_ID, m_ReaderID);
	DDX_Text(pDX, IDC_READER_NAME, m_name);
	DDX_Text(pDX, IDC_READER_OTHER, m_other);
	DDX_Text(pDX, IDC_READER_PHONE, m_phone);
	DDX_Text(pDX, IDC_READER_REGISTER, m_registerTime);
	DDX_CBString(pDX, IDC_READER_SEX, m_sex);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CNewReaderDlg message handlers

void CNewReaderDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	CReaderSet	*m_ReaderSet;
	m_ReaderSet = new CReaderSet(&m_ReaderDB);
	CString strSQL;

	if(m_ReaderID.IsEmpty())
	{
		AfxMessageBox("请输入读者卡号！");
		return;
	}
	if(m_name.IsEmpty())
	{
		AfxMessageBox("请输入读者姓名！");
		return;
	}

	strSQL.Format("select * from Reader where CardID = '%s'",m_ReaderID);
	if(!m_ReaderSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}

	if(m_ReaderSet->GetRecordCount()!=0)
	{
		m_ReaderSet->Close();
		AfxMessageBox("该编号已经存在，请重新输入！");
		return;
	}
	m_ReaderSet->Close();
	

	if(!m_ReaderSet->Open(AFX_DB_USE_DEFAULT_TYPE))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	else
	{
		m_ReaderSet->AddNew();
		m_ReaderSet->m_Address = m_address;
		m_ReaderSet->m_Age = m_age;
		m_ReaderSet->m_CardID = m_ReaderID;
		m_ReaderSet->m_Name = m_name;
		m_ReaderSet->m_Phone = m_phone;
		m_ReaderSet->m_RegTime = tt;
		m_ReaderSet->m_Sex = m_sex;
		m_ReaderSet->m_Other = m_other;
		m_ReaderSet->m_BorrowNum = 0;
		m_ReaderSet->Update();
		m_ReaderSet->Close();
	}
	if(IDOK==AfxMessageBox("读者登记成功！",MB_OKCANCEL))
	{	
		CDialog::OnOK();
		return;
	}
}

BOOL CNewReaderDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	tt = CTime::GetCurrentTime();
	m_registerTime = tt.Format("%Y-%m-%d");
	CReaderSet	m_ReaderSet;

	CString strSQL;
	strSQL="select * from Reader";

	if(!m_ReaderSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return FALSE;
	}
	if(m_ReaderSet.GetRecordCount() == 0)
	{
		CTime time= CTime::GetCurrentTime();
		CString ID="000000";
		ID = time.Format("%Y")+ID ;
		m_ReaderID = ID;
		m_ReaderSet.Close();
	}
	else
	{
		m_ReaderSet.MoveLast();
		m_ReaderID.Format("%d",atoi(m_ReaderSet.m_CardID) +1);
		m_ReaderSet.Close();
	}
	UpdateData(false);
	return TRUE;
}