addnewbook.cpp

实现基本的图书馆管理系统

// AddNewBook.cpp : implementation file
//

#include "stdafx.h"
#include "图书馆管理系统.h"
#include "AddNewBook.h"
#include "ADOConn.h"
#include "AddNewBookEdit.h"
#include "adodc.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAddNewBook dialog


CAddNewBook::CAddNewBook(CWnd* pParent /*=NULL*/)
	: CDialog(CAddNewBook::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddNewBook)
	m_BookID = _T("");
	m_BookName = _T("");
	m_Press = _T("");
	m_Writer = _T("");
	m_Total_Amount = 0;
	m_Now_Amount = 0;
	m_Price = 0.0f;
	m_InlibraryTime = 0;
	//}}AFX_DATA_INIT
}


void CAddNewBook::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddNewBook)
	DDX_Text(pDX, IDC_BOOKID_EDIT, m_BookID);
	DDX_Text(pDX, IDC_BOOKNAME_EDIT, m_BookName);
	DDX_Text(pDX, IDC_PRESS_EDIT, m_Press);
	DDX_Text(pDX, IDC_WRITER_EDIT, m_Writer);
	DDX_Text(pDX, IDC_TOTAL_AMOUNT_EDIT, m_Total_Amount);
	DDX_Text(pDX, IDC_NOW_AMOUNT_EDIT, m_Now_Amount);
	DDX_Text(pDX, IDC_PRICE_EDIT, m_Price);
	DDX_Control(pDX, IDC_DATAGRID1, m_dataGridEm);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_DateTimeCtrl(pDX, IDC_TIME, m_InlibraryTime);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddNewBook, CDialog)
	//{{AFX_MSG_MAP(CAddNewBook)
	ON_BN_CLICKED(IDC_ADDNEW, OnAddnew)
	ON_EN_CHANGE(IDC_PRICE_EDIT, OnChangePriceEdit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddNewBook message handlers

void CAddNewBook::OnAddnew() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CAddNewBookEdit newbookedit;

	if(m_BookName=="")
	{
		MessageBox("请输入书名！");
		return;
	}
	if(m_BookID=="")
	{
		MessageBox("请输入书号！");
		return;
	}
	if(m_Writer=="")
	{
		MessageBox("请输入作者！");
		return;
	}
	if(m_Press=="")
	{
		MessageBox("请输入出版社！");
		return;
	}
	if(m_Price==0.0)
	{
		MessageBox("请输入书价！");
		return;
	}
	if(m_Total_Amount==0)
	{
		MessageBox("请输入总量！");
		return;
	}
	if(m_Now_Amount==0)
	{
		MessageBox("请输入现存量！");
		return;
	}
	//将管理员输入的数据赋值到对象book中，为更新数据库做准备

	newbookedit.SetBookName(m_BookName);
	newbookedit.SetBookID(m_BookID);
	newbookedit.SetWriter(m_Writer);
	newbookedit.SetPress(m_Press);
	newbookedit.SetPrice(m_Price);
	newbookedit.SetInlibraryTime(m_InlibraryTime.Format("%Y-%m-%d"));
	newbookedit.SetTotal_Amount(m_Total_Amount);
	newbookedit.SetNow_Amount(m_Now_Amount);
	
	
	if (newbookedit.HaveName(m_BookName) == 1)
	{
		MessageBox("该书名已经存在，总数将会增加");
		newbookedit.sql_update();
		MessageBox("图书更新成功");
	}
	else
	{
		newbookedit.sql_insert();
		
		MessageBox("入库成功！");
       
	  
	}
	   
	CString  cSource="select  BookID,BookName,writer,Press,Price,"
		             "InlibraryTime,Total_Amount,Now_Amount from Book_Info";
	m_Adodc.SetRecordSource(cSource);
	m_Adodc.Refresh();
	////////////////////////////
	//设置列的宽度
	CColumns allCols;
	CColumn  onecol;
	///获得dataGrid控件的列集对象
    allCols=m_dataGridEm.GetColumns();
	//以序号为参数获得某列对象
    onecol=allCols.GetItem(COleVariant(long(0)));
	//设置属性
	onecol.SetCaption(" 图书号");
	//设置列宽
	onecol.SetWidth (50);

	onecol=allCols.GetItem(COleVariant(long(1)));
	onecol.SetCaption(" 图书名称");
	onecol.SetWidth (110);

    onecol=allCols.GetItem(COleVariant(long(2)));
	onecol.SetCaption(" 作者");
	onecol.SetWidth (80);

    onecol=allCols.GetItem(COleVariant(long(3)));
	onecol.SetCaption(" 出版社");
	onecol.SetWidth (110);

	onecol=allCols.GetItem(COleVariant(long(4)));
	onecol.SetCaption(" 价格");
	onecol.SetWidth (40);

	onecol=allCols.GetItem(COleVariant(long(5)));
	onecol.SetCaption(" 入库时间");
	onecol.SetWidth (100);

	onecol=allCols.GetItem(COleVariant(long(6)));
	onecol.SetCaption("总量");
    onecol.SetWidth (40);

	onecol=allCols.GetItem(COleVariant(long(7)));
	onecol.SetCaption(" 现存量");
	onecol.SetWidth (40);

}

void CAddNewBook::OnChangePriceEdit() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the CDialog::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	
	// TODO: Add your control notification handler code here
	
}

BEGIN_EVENTSINK_MAP(CAddNewBook, CDialog)
    //{{AFX_EVENTSINK_MAP(CAddNewBook)
	ON_EVENT(CAddNewBook, IDC_DATAGRID1, -600 /* Click */, OnClickDatagrid1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CAddNewBook::OnClickDatagrid1() 
{
	// TODO: Add your control notification handler code here
	//CString  strSQL="select BookID,BookName,writer,Press,Price,Total_Amount,Now_Amount from Book_Info";
	

}