newbooksdlg.cpp

一个图书管理系统

// NewBooksDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "NewBooksDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CNewBooksDlg dialog


CNewBooksDlg::CNewBooksDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CNewBooksDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CNewBooksDlg)
	m_strbookname = _T("");
	m_strbookID = _T("");
	m_strpress = _T("");
	m_strwriter = _T("");
	m_fprice = 0.0f;
	m_ltotal = 0;
	//}}AFX_DATA_INIT
}


void CNewBooksDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CNewBooksDlg)
	DDX_Control(pDX, IDC_LIST_RESULT, m_ctrlist);
	DDX_Text(pDX, IDC_EDIT_BOOK_NAME, m_strbookname);
	DDX_Text(pDX, IDC_EDIT_BOOK_NO, m_strbookID);
	DDX_Text(pDX, IDC_EDIT_PRESS, m_strpress);
	DDX_Text(pDX, IDC_EDIT_WRITER, m_strwriter);
	DDX_Text(pDX, IDC_EDIT_PRICE, m_fprice);
	DDX_Text(pDX, IDC_EDIT_TOTAL, m_ltotal);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CNewBooksDlg, CDialog)
	//{{AFX_MSG_MAP(CNewBooksDlg)
	ON_BN_CLICKED(IDC_BUTTON_IN, OnButtonIn)
	ON_BN_CLICKED(IDC_BUTTON_DEL, OnButtonDel)
	ON_BN_CLICKED(IDC_BUTTON_CHECK_ALL, OnButtonCheckAll)
	ON_NOTIFY(NM_CLICK, IDC_LIST_RESULT, OnClickListResult)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CNewBooksDlg message handlers



void CNewBooksDlg::OnButtonIn() 
{

	
	UpdateData();
//判断必填数据是否全部输入
if(m_strbookID.IsEmpty())
{
	AfxMessageBox("请输入图书编号!");
	return;
}
if(m_strbookname.IsEmpty())
{
	AfxMessageBox("请输入图书名字!");
	return;
}


CString strSQL;
CTime current=CTime::GetCurrentTime();

strSQL.Format("select * from bookinfo where Book_ID='%s'",m_strbookID);

if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
{
	MessageBox("打开数据库失败!","数据库错误",MB_OK);
	return;
}
//检索图书编号是否存在
if(m_recordset.GetRecordCount()!=0)
{
	AfxMessageBox("该图书编号已存在，请重新输入!");
	m_recordset.Close();
	return;
}
m_recordset.Close();
if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE))
{
	MessageBox("打开数据库失败!","数据库错误",MB_OK);
	return;
}


//添加图书记录
m_recordset.AddNew();
m_recordset.m_Book_ID=m_strbookID;
m_recordset.m_Book_Name=m_strbookname;
m_recordset.m_Writer=m_strwriter;
m_recordset.m_Press=m_strpress;
m_recordset.m_Price=m_fprice;
m_recordset.m_Total_Amount=m_ltotal;
m_recordset.m_Into_Date=current;
m_recordset.Update();
m_recordset.Close();
//更新列表

CString strTime;

CString str2;
char buf1[20];
itoa(m_ltotal,buf1,10);

str2.Format("%f",m_fprice);
m_ctrlist.InsertItem(0,m_strbookID);
m_ctrlist.SetItemText(0,1,m_strbookname);
m_ctrlist.SetItemText(0,2,m_strwriter);
m_ctrlist.SetItemText(0,3,m_strpress);
m_ctrlist.SetItemText(0,4,str2);
m_ctrlist.SetItemText(0,5,buf1);
strTime.Format("%d-%d-%d",current.GetYear(),current.GetMonth(),current.GetDay());
m_ctrlist.SetItemText(0,6,strTime);
//更新界面显示
m_strbookID=_T("");
m_strbookname=_T("");
m_strwriter=_T("");
m_strpress=_T("");
m_fprice=NULL;
m_ltotal=NULL;
UpdateData(FALSE);

}

void CNewBooksDlg::OnButtonDel() 
{
	int i=m_ctrlist.GetSelectionMark();
	//判断用户是否选择了记录
	if(i<0)
	{
		AfxMessageBox("请选择一条记录进行删除!");
		return;
	}
	CString strSQL;
	strSQL.Format("select * from bookinfo where Book_ID='%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_strbookID=_T("");
	m_strbookname=_T("");
	m_strwriter=_T("");
	m_strpress=_T("");
	m_fprice=NULL;
	m_ltotal=NULL;
	UpdateData(FALSE);
}
//显示全部图书信息
void CNewBooksDlg::OnButtonCheckAll() 
{
    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,str1;
	while(!m_recordset.IsEOF())
	{
		m_ctrlist.InsertItem(i,m_recordset.m_Book_ID);
		m_ctrlist.SetItemText(i,1,m_recordset.m_Book_Name);
		m_ctrlist.SetItemText(i,2,m_recordset.m_Writer);
		m_ctrlist.SetItemText(i,3,m_recordset.m_Press);
		str1.Format("%f",m_recordset.m_Price);
		m_ctrlist.SetItemText(i,4,str1);
		str1.Format("%d",m_recordset.m_Total_Amount);
		m_ctrlist.SetItemText(i,5,str1);
		strTime.Format("%d-%d-%d",m_recordset.m_Into_Date.GetYear(),m_recordset.m_Into_Date.GetMonth(),m_recordset.m_Into_Date.GetDay());
		m_ctrlist.SetItemText(i,6,strTime);
		i++;
		m_recordset.MoveNext();
	}
	m_recordset.Close();
	m_ctrlist.SetRedraw(TRUE);


}

BOOL CNewBooksDlg::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.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.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CNewBooksDlg::OnClickListResult(NMHDR* pNMHDR, LRESULT* pResult) 
{
    int i=m_ctrlist.GetSelectionMark();
	CString str1;
	m_strbookID=m_ctrlist.GetItemText(i,0);
	m_strbookname=m_ctrlist.GetItemText(i,1);
	m_strwriter=m_ctrlist.GetItemText(i,2);
	m_strpress=m_ctrlist.GetItemText(i,3);
	str1=m_ctrlist.GetItemText(i,4);
//	m_fprice=atof(str1);
	sscanf(str1,"%lf",&m_fprice);
	str1=m_ctrlist.GetItemText(i,5);
	m_ltotal=atoi(str1);
	UpdateData(FALSE);
	*pResult = 0;
}