readersearch.cpp

图书管理系统可以添加

// ReaderSearch.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CReaderSearch dialog


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


void CReaderSearch::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderSearch)
	DDX_Control(pDX, IDC_LIST1, m_strList);
	DDX_Text(pDX, IDC_EDIT_CODE, m_readerID);
	DDV_MaxChars(pDX, m_readerID, 10);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReaderSearch, CDialog)
	//{{AFX_MSG_MAP(CReaderSearch)
	ON_BN_CLICKED(IDOK, OnSearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReaderSearch message handlers

void CReaderSearch::OnSearch() 
{
	// TODO: Add your control notification handler code here
	m_strList.DeleteAllItems();
	m_strList.SetRedraw(FALSE);

	UpdateData(true);
	CString str;
	if(m_readerID.IsEmpty())
	{
		str.Format("select * from READER");
	}
	else
	{
		str.Format("select * from Reader where CardID='%s'",m_readerID);
	}

	CReaderSet	*m_reSet;
	m_reSet= new CReaderSet(&m_readerDB);

	if( !m_reSet->Open(AFX_DB_USE_DEFAULT_TYPE,str))
	{
		MessageBox("数据库打开失败","数据库错误",MB_OK);
		return;
	}

	int i=0;
	CString strtime;
	while(!m_reSet->IsEOF())
	{
		m_strList.InsertItem(i,m_reSet->m_CardID);
		m_strList.SetItemText(i,1,m_reSet->m_Name);
		m_strList.SetItemText(i,2,m_reSet->m_Sex);
		m_strList.SetItemText(i,3,m_reSet->m_Age);
		m_strList.SetItemText(i,4,m_reSet->m_Phone);
		strtime = m_reSet->m_RegTime.Format("%Y-%m-%d");
		m_strList.SetItemText(i,5,strtime);
		m_strList.SetItemText(i,6,m_reSet->m_Address);
		m_strList.SetItemText(i,7,m_reSet->m_Other);
		i++;
		m_reSet->MoveNext();
	}
	m_reSet->Close();
	m_strList.SetRedraw(true);
}

BOOL CReaderSearch::OnInitDialog()
{
	CDialog::OnInitDialog();
	//设置列表
	m_strList.InsertColumn(0,"读者卡号");
	m_strList.InsertColumn(1,"读者姓名");
	m_strList.InsertColumn(2,"读者性别");
	m_strList.InsertColumn(3,"读者年龄");
	m_strList.InsertColumn(4,"联系方式");
	m_strList.InsertColumn(5,"登记时间");
	m_strList.InsertColumn(6,"读者单位");
	m_strList.InsertColumn(7,"备注");
	
	m_strList.SetColumnWidth(0,100);
	m_strList.SetColumnWidth(1,60);
	m_strList.SetColumnWidth(2,60);
	m_strList.SetColumnWidth(3,60);
	m_strList.SetColumnWidth(4,100);
	m_strList.SetColumnWidth(5,100);
	m_strList.SetColumnWidth(6,150);
	m_strList.SetColumnWidth(7,150);
	m_strList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	
	return TRUE;
}