readerdropdlg.cpp

图书管理系统可以添加

// ReaderDropDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CReaderDropDlg dialog


CReaderDropDlg::CReaderDropDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CReaderDropDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReaderDropDlg)
	m_ReaderID = _T("");
	//}}AFX_DATA_INIT
}


void CReaderDropDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderDropDlg)
	DDX_Control(pDX, IDC_LIST1, m_ctrList);
	DDX_Text(pDX, IDC_EDIT_CODE, m_ReaderID);
	DDV_MaxChars(pDX, m_ReaderID, 10);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReaderDropDlg, CDialog)
	//{{AFX_MSG_MAP(CReaderDropDlg)
	ON_BN_CLICKED(IDC_SEARCH, OnSearch)
	ON_BN_CLICKED(IDOK, OnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReaderDropDlg message handlers

BOOL CReaderDropDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_ReaderSet = new CReaderSet(&m_ReaderDB);
	//设置列表
	m_ctrList.InsertColumn(0,"读者编号");
	m_ctrList.InsertColumn(1,"读者姓名");
	m_ctrList.InsertColumn(2,"读者性别");
	m_ctrList.InsertColumn(3,"读者类别");
	m_ctrList.InsertColumn(4,"登记日期");
	m_ctrList.InsertColumn(5,"所属部门");
	m_ctrList.InsertColumn(6,"联系电话");
	m_ctrList.InsertColumn(7,"地址");
	m_ctrList.InsertColumn(8,"备注说明");
	
	m_ctrList.SetColumnWidth(0,60);
	m_ctrList.SetColumnWidth(1,120);
	m_ctrList.SetColumnWidth(2,80);
	m_ctrList.SetColumnWidth(3,80);
	m_ctrList.SetColumnWidth(4,80);
	m_ctrList.SetColumnWidth(5,80);
	m_ctrList.SetColumnWidth(6,80);
	m_ctrList.SetColumnWidth(7,100);
	m_ctrList.SetColumnWidth(8,100);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	

	return TRUE;
}

void CReaderDropDlg::OnSearch() 
{
	// TODO: Add your control notification handler code here
	m_ctrList.DeleteAllItems();
	m_ctrList.SetRedraw(false);

	UpdateData(true);
	CString strSQL;

	if(m_ReaderID.IsEmpty())
	{
		strSQL.Format("select * from Reader");
	}
	else
	{
		strSQL.Format("select * from Reader where CardId='%s'",m_ReaderID);
	}


	if( !m_ReaderSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("数据库连接错误","数据库错误",MB_OK);
		return;
	}
	int i=0;
	CString strtime;
	while(!m_ReaderSet->IsEOF())
	{
		m_ctrList.InsertItem(i,m_ReaderSet->m_CardID);
		m_ctrList.SetItemText(i,1,m_ReaderSet->m_Name);
		m_ctrList.SetItemText(i,2,m_ReaderSet->m_Sex);
		m_ctrList.SetItemText(i,3,m_ReaderSet->m_Age);
		m_ctrList.SetItemText(i,4,m_ReaderSet->m_Phone);
		strtime = m_ReaderSet->m_RegTime.Format("%Y-%m-%d");
		m_ctrList.SetItemText(i,5,strtime);
		m_ctrList.SetItemText(i,6,m_ReaderSet->m_Address);
		m_ctrList.SetItemText(i,7,m_ReaderSet->m_Other);
		i++;
		m_ReaderSet->MoveNext();
	}
	m_ReaderSet->Close();
	m_ctrList.SetRedraw(true);
}

void CReaderDropDlg::OnDelete() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	int i = m_ctrList.GetSelectionMark();

	if(0 > i)
	{
		AfxMessageBox("打开数据库失败");
		return;
	}
	CString	strsql;
	strsql.Format("select * from Reader where CardID='%s'",m_ctrList.GetItemText(i,0));

	if( !m_ReaderSet->Open(AFX_DB_USE_DEFAULT_TYPE,strsql))
	{
		MessageBox("数据库连接错误","数据库错误",MB_OK);
		return;
	}
	
	if(IDOK==AfxMessageBox("确定要删除该读者吗？",MB_OKCANCEL))
	{
		m_ReaderSet->Delete();
		m_ctrList.DeleteItem(i);
		return;
	}

	m_ReaderSet->Close();
	UpdateData(false);
}