readerdeletedlg.cpp

图书管理系统源代码 实现最基本功能的操作

// ReaderDeleteDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ReaderDeleteDlg.h"
#include "ReaderTypeSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReaderDeleteDlg dialog


CReaderDeleteDlg::CReaderDeleteDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CReaderDeleteDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReaderDeleteDlg)
	m_strType = _T("");
	m_strCode = _T("");
	//}}AFX_DATA_INIT
}


void CReaderDeleteDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderDeleteDlg)
	DDX_Control(pDX, IDC_LIST1, m_ctrList);
	DDX_Control(pDX, IDC_COMBO_TYPE, m_ctrType);
	DDX_CBString(pDX, IDC_COMBO_TYPE, m_strType);
	DDX_Text(pDX, IDC_EDIT_CODE, m_strCode);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReaderDeleteDlg, CDialog)
	//{{AFX_MSG_MAP(CReaderDeleteDlg)
	ON_BN_CLICKED(IDC_BUTTON_SERACH, OnButtonSerach)
	ON_BN_CLICKED(IDC_BUTTON_DELETE, OnButtonDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReaderDeleteDlg message handlers

BOOL CReaderDeleteDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//设置列表
	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);	
	//添加读者类型数据
	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
}

void CReaderDeleteDlg::OnButtonSerach() 
{
	// TODO: Add your control notification handler code here
	m_ctrList.DeleteAllItems();
	m_ctrList.SetRedraw(FALSE);

	UpdateData(TRUE);
	CString strSQL;
	if(m_strCode.IsEmpty()&m_strType.IsEmpty())
	{
		strSQL="select * from readerInfo";
	}
	else if(m_strType.IsEmpty())
	{
		strSQL.Format("select * from readerInfo where code = '%s'",m_strCode);
	}
	else if(m_strCode.IsEmpty())
	{
		strSQL.Format("select * from readerInfo where type = '%s'",m_strType);
	}
	else
	{
		strSQL.Format("select * from readerInfo where code = '%s' and type='%s'",m_strCode,m_strType);
	}

	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}	
	int i=0;
	CString strTime;
	while(!m_recordset.IsEOF())
	{
		m_ctrList.InsertItem(i,m_recordset.m_code);
		m_ctrList.SetItemText(i,1,m_recordset.m_name);
		m_ctrList.SetItemText(i,2,m_recordset.m_sex);
		m_ctrList.SetItemText(i,3,m_recordset.m_type);
		strTime.Format("%d-%d-%d",m_recordset.m_reg_date.GetYear(),m_recordset.m_reg_date.GetMonth(),m_recordset.m_reg_date.GetDay());
		m_ctrList.SetItemText(i,4,strTime);
		m_ctrList.SetItemText(i,5,m_recordset.m_dept);
		m_ctrList.SetItemText(i,6,m_recordset.m_phone);
		m_ctrList.SetItemText(i,6,m_recordset.m_address);
		m_ctrList.SetItemText(i,6,m_recordset.m_brief);
		i++;
		m_recordset.MoveNext();
	}
	m_recordset.Close();
	m_ctrList.SetRedraw(TRUE);	
}

void CReaderDeleteDlg::OnButtonDelete() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	int i=m_ctrList.GetSelectionMark();
	if(0>i)
	{
		AfxMessageBox("请选择列表中的读者进行注销操作！");
		return;
	}
	CString strSQL;
	strSQL.Format("select * from readerInfo where code = '%s' ",m_ctrList.GetItemText(i,0));
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		AfxMessageBox("打开数据库失败!");
		return ;
	}
	m_recordset.Delete();
	m_recordset.Close();
	//更新界面显示
	m_ctrList.DeleteItem(i);
	UpdateData(FALSE);
}