newbookdlg.cpp

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

// NewBookDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "NewBookDlg.h"
#include "BookTypeSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CNewBookDlg dialog


CNewBookDlg::CNewBookDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CNewBookDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CNewBookDlg)
	m_strBookType = _T("");
	m_strBookCode = _T("");
	m_strBookName = _T("");
	m_strPrice = _T("");
	m_strPress = _T("");
	m_strWriter = _T("");
	m_strBrief = _T("");
	//}}AFX_DATA_INIT
}


void CNewBookDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNewBookDlg)
	DDX_Control(pDX, IDC_COMBO_BOOKTYPE, m_ctrBookType);
	DDX_Control(pDX, IDC_LIST1, m_ctrList);
	DDX_CBString(pDX, IDC_COMBO_BOOKTYPE, m_strBookType);
	DDX_Text(pDX, IDC_EDIT_BOOK_CODE, m_strBookCode);
	DDX_Text(pDX, IDC_EDIT_BOOK_NAME, m_strBookName);
	DDX_Text(pDX, IDC_EDIT_BOOK_PRICE, m_strPrice);
	DDX_Text(pDX, IDC_EDIT_PRESS, m_strPress);
	DDX_Text(pDX, IDC_EDIT_WRITER, m_strWriter);
	DDX_Text(pDX, IDC_EDIT_BRIEF, m_strBrief);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CNewBookDlg, CDialog)
	//{{AFX_MSG_MAP(CNewBookDlg)
	ON_BN_CLICKED(IDC_BUTTON_NEW, OnButtonNew)
	ON_BN_CLICKED(IDC_BUTTON_ALL, OnButtonAll)
	ON_BN_CLICKED(IDC_BUTTON_DELETE, OnButtonDelete)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNewBookDlg message handlers

BOOL CNewBookDlg::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.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,80);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	
	//初始化图书类型
	CBookTypeSet recordset ;
	if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,"select * from bookType"))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return FALSE;
	}	
	while(!recordset.IsEOF())
	{
		m_ctrBookType.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 CNewBookDlg::OnButtonNew() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strBookCode.IsEmpty())
	{
		AfxMessageBox("请输入图书编号！");
		return;
	}
	if(m_strBookType.IsEmpty())
	{
		AfxMessageBox("请输入图书类型！");
		return;
	}
	if(m_strBookName.IsEmpty())
	{
		AfxMessageBox("请输入图书名称！");
		return;
	}
	CString strSQL;
	CTime current=CTime::GetCurrentTime();
	strSQL.Format("select * from bookInfo where code = '%s'",m_strBookCode);
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	if(m_recordset.GetRecordCount()!=0)
	{
		m_recordset.Close();
		AfxMessageBox("该图书编号已经存在，请重新输入！");
		return;
	}
	m_recordset.Close();
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	//添加图书记录
	m_recordset.AddNew();
	m_recordset.m_code			=	m_strBookCode		;
	m_recordset.m_name 			=	m_strBookName		;
	m_recordset.m_type			=   m_strBookType		;
	m_recordset.m_in_date       =	current	;
	m_recordset.m_price			=	m_strPrice  	;
	m_recordset.m_press			=	m_strPress  	;
	m_recordset.m_writer		=	m_strWriter  	;
	m_recordset.m_brief			=	m_strBrief  	;
	m_recordset.m_isBorrow      =   FALSE;
	m_recordset.Update();
	m_recordset.Close();

	//更新列表
	CString strTime;
	m_ctrList.InsertItem(0,m_strBookCode);
	m_ctrList.SetItemText(0,1,m_strBookName);
	m_ctrList.SetItemText(0,2,m_strBookType);
	m_ctrList.SetItemText(0,3,m_strWriter);
	m_ctrList.SetItemText(0,4,m_strPress);
	m_ctrList.SetItemText(0,5,m_strPrice);
	strTime.Format("%d-%d-%d",current.GetYear(),current.GetMonth(),current.GetDay());
	m_ctrList.SetItemText(0,6,strTime);
	m_ctrList.SetItemText(0,7,m_strBrief);	
	//更新界面显示
	m_strBookType = _T("");
	m_strBookCode = _T("");
	m_strBookName = _T("");
	m_strPrice = _T("");
	m_strPress = _T("");
	m_strWriter = _T("");
	m_strBrief = _T("");
	UpdateData(FALSE);

}

void CNewBookDlg::OnButtonAll() 
{
	// TODO: Add your control notification handler code here
	m_ctrList.DeleteAllItems();
	m_ctrList.SetRedraw(FALSE);
	UpdateData(TRUE);
	CString strSQL;
	strSQL.Format( "select * from bookInfo ");
	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_type);
		m_ctrList.SetItemText(i,3,m_recordset.m_writer);
		m_ctrList.SetItemText(i,4,m_recordset.m_press);
		m_ctrList.SetItemText(i,5,m_recordset.m_price);
		strTime.Format("%d-%d-%d",m_recordset.m_in_date.GetYear(),m_recordset.m_in_date.GetMonth(),m_recordset.m_in_date.GetDay());
		m_ctrList.SetItemText(i,6,strTime);
		m_ctrList.SetItemText(i,7,m_recordset.m_brief);	
		i++;
		m_recordset.MoveNext();
	}
	m_recordset.Close();
	m_ctrList.SetRedraw(TRUE);	
}

void CNewBookDlg::OnButtonDelete() 
{
	// TODO: Add your control notification handler code here
	int i = m_ctrList.GetSelectionMark();
	if(0>i)
	{
		AfxMessageBox("请选择一条记录进行删除！");
		return;
	}
	CString strSQL;
	strSQL.Format("select * from bookInfo 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);
	//更新界面显示
	m_strBookType = _T("");
	m_strBookCode = _T("");
	m_strBookName = _T("");
	m_strPrice = _T("");
	m_strPress = _T("");
	m_strWriter = _T("");
	m_strBrief = _T("");
	UpdateData(FALSE);
}

void CNewBookDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int i = m_ctrList.GetSelectionMark();
	m_strBookType = m_ctrList.GetItemText(i,2);
	m_strBookCode = m_ctrList.GetItemText(i,0);
	m_strBookName = m_ctrList.GetItemText(i,1);
	m_strPrice = m_ctrList.GetItemText(i,5);
	m_strPress = m_ctrList.GetItemText(i,4);
	m_strWriter = m_ctrList.GetItemText(i,3);
	m_strBrief = m_ctrList.GetItemText(i,7);
	UpdateData(FALSE);
	*pResult = 0;
}