newbookdlg.cpp

图书管理系统可以添加

// NewBookDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "NewBookDlg.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_author = _T("");
	m_bookid = _T("");
	m_name = _T("");
	m_price = _T("");
	m_publisher = _T("");
	//}}AFX_DATA_INIT
}


void CNewBookDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNewBookDlg)
	DDX_Control(pDX, IDC_LIST1, m_ctrList);
	DDX_Text(pDX, IDC_BOOK_AUTHOR, m_author);
	DDX_Text(pDX, IDC_BOOK_ID, m_bookid);
	DDV_MaxChars(pDX, m_bookid, 5);
	DDX_Text(pDX, IDC_BOOK_NAME, m_name);
	DDX_Text(pDX, IDC_BOOK_PRICE, m_price);
	DDX_Text(pDX, IDC_PUBLISHER, m_publisher);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CNewBookDlg, CDialog)
//{{AFX_MSG_MAP(CNewBookDlg)
ON_BN_CLICKED(IDOK, OnNewBook)
	ON_BN_CLICKED(IDOK2, OnBookDelete)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDOK3, OnShowALL)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

void CNewBookDlg::OnNewBook() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_bookid.IsEmpty())
	{
		AfxMessageBox("请输入图书编号");
		return;
	}
	
	if(m_name.IsEmpty())
	{
		AfxMessageBox("请输入图书名称");
		return;
	}
	
	CString strsql;
	CTime m_loaddata=CTime::GetCurrentTime();
	m_bookSet = new CBookSet(&m_DB);
	strsql.Format("select * from Book where BookID='%s'",m_bookid);
	
	if(!m_bookSet->Open(AFX_DB_USE_DEFAULT_TYPE,strsql))
	{
		MessageBox("连接数据库出错","数据库错误",MB_OK);
		return;
	}
	if(0 != m_bookSet->GetRecordCount())
	{
		m_bookSet->Close();
		AfxMessageBox("该图书号已经存在请重新输入");
		return;
	}
	
	m_bookSet->Close();
	if(!m_bookSet->Open(AFX_DB_USE_DEFAULT_TYPE))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	m_bookSet->AddNew();
	
	m_bookSet->m_BookID		=	m_bookid;
	m_bookSet->m_BookName	=	m_name;
	m_bookSet->m_Auther		=	m_author;
	m_bookSet->m_Price		=	m_price;
	m_bookSet->m_Publisher	=	m_publisher;
	m_bookSet->m_LoadInData =	m_loaddata;
	m_bookSet->m_IsBorrow	=	FALSE;
	if(m_bookSet->CanUpdate())
	{
		m_bookSet->Update();
	}
	m_bookSet->Close();

	CString time;
	m_ctrList.InsertItem(0,m_bookid);
	m_ctrList.SetItemText(0,1,m_name);
	m_ctrList.SetItemText(0,2,m_author);
	m_ctrList.SetItemText(0,3,m_price);
	m_ctrList.SetItemText(0,4,m_publisher);
	time=m_loaddata.Format("%Y-%m-%d");
	m_ctrList.SetItemText(0,5,time);
		  
	//更新界面显示
	m_bookid = _T("");
	m_name = _T("");
	m_author = _T("");
	m_price = _T("");
	m_publisher = _T("");

	UpdateData(FALSE);
}



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.SetColumnWidth(0,80);
	m_ctrList.SetColumnWidth(1,100);
	m_ctrList.SetColumnWidth(2,80);
	m_ctrList.SetColumnWidth(3,60);
	m_ctrList.SetColumnWidth(4,100);
	m_ctrList.SetColumnWidth(5,100);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	return TRUE;
}

void CNewBookDlg::OnBookDelete() 
{
	// TODO: Add your control notification handler code here
	int i = m_ctrList.GetSelectionMark();
	if(0 > i)
	{
		AfxMessageBox("请选择一条记录进行删除");
		return;
	}

	CString strSQL;
	m_bookSet = new CBookSet(&m_DB);
	strSQL.Format("select * from Book where BookID = '%s' ",m_ctrList.GetItemText(i,0));
	if(!m_bookSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		AfxMessageBox("打开数据库失败!");
		return ;
	}

	if(IDOK==AfxMessageBox("确定要删除该图书记录吗？",MB_OKCANCEL))
	{
		m_bookSet->Delete();
		m_ctrList.DeleteItem(i);
	}
	m_bookSet->Close();

	//更新界面显示
	m_bookid = _T("");
	m_name = _T("");
	m_author = _T("");
	m_price = _T("");
	m_publisher = _T("");
	UpdateData(FALSE);
}

void CNewBookDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int i = m_ctrList.GetSelectionMark();
	m_author = m_ctrList.GetItemText(i,2);
	m_bookid = m_ctrList.GetItemText(i,0);
	m_name = m_ctrList.GetItemText(i,1);
	m_publisher = m_ctrList.GetItemText(i,4);
	m_price = m_ctrList.GetItemText(i,3);
	UpdateData(FALSE);
	*pResult = 0;
}

void CNewBookDlg::OnShowALL() 
{
	// TODO: Add your control notification handler code here
	m_ctrList.DeleteAllItems();
	m_ctrList.SetRedraw(FALSE);
	UpdateData(TRUE);

	CString strSQL;
	m_bookSet = new CBookSet(&m_DB);

	strSQL.Format( "select * from Book ");
	m_bookSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(!m_bookSet->IsOpen())
	{
		AfxMessageBox("打开数据库失败!");
		return ;
	}	

	int i=0;

	CString time;
	while(!m_bookSet->IsEOF())
	{
		m_ctrList.InsertItem(0,m_bookSet->m_BookID);
		m_ctrList.SetItemText(0,1,m_bookSet->m_BookName);
		m_ctrList.SetItemText(0,2,m_bookSet->m_Auther);
		m_ctrList.SetItemText(0,3,m_bookSet->m_Price);
		m_ctrList.SetItemText(0,4,m_bookSet->m_Publisher);
		time=m_bookSet->m_LoadInData.Format("%Y-%m-%d");
		m_ctrList.SetItemText(0,5,time);
		i++;
		m_bookSet->MoveNext();
	}
	m_bookSet->Close();
	m_ctrList.SetRedraw(TRUE);	
}