book_manage.cpp

图书管理系统 语言：C,SQL 功能：实现图书管理的数字化

// Book_manage.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "Book_manage.h"

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

/////////////////////////////////////////////////////////////////////////////
// Book_manage dialog


Book_manage::Book_manage(CWnd* pParent /*=NULL*/)
	: CDialog(Book_manage::IDD, pParent)
{
	//{{AFX_DATA_INIT(Book_manage)
	m_bid_temp = _T("");
	m_bid = _T("");
	m_bname = _T("");
	m_bauthor = _T("");
	m_btran = _T("");
	m_bpublisher = _T("");
	m_b_total_count = 0;
	m_b_left_count = 0;
	m_b_borrowed_count = 0;
	m_bprice = 0.0;
	//}}AFX_DATA_INIT
}


void Book_manage::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Book_manage)
	DDX_Text(pDX, IDC_EDIT1, m_bid_temp);
	DDX_Text(pDX, IDC_EDIT2, m_bid);
	DDX_Text(pDX, IDC_EDIT3, m_bname);
	DDX_Text(pDX, IDC_EDIT4, m_bauthor);
	DDX_Text(pDX, IDC_EDIT5, m_btran);
	DDX_Text(pDX, IDC_EDIT6, m_bpublisher);
	DDX_Text(pDX, IDC_EDIT8, m_b_total_count);
	DDX_Text(pDX, IDC_EDIT10, m_b_left_count);
	DDX_Text(pDX, IDC_EDIT9, m_b_borrowed_count);
	DDX_Text(pDX, IDC_EDIT7, m_bprice);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Book_manage, CDialog)
	//{{AFX_MSG_MAP(Book_manage)
	ON_BN_CLICKED(IDC_Search, OnSearch)
	ON_BN_CLICKED(IDC_Add, OnAdd)
	ON_BN_CLICKED(IDC_Delete, OnDelete)
	ON_BN_CLICKED(IDC_Update, OnUpdate)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Book_manage message handlers

void Book_manage::OnSearch() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_bid_temp.IsEmpty())
	{
	   MessageBox("请输入一个编号");
	   return;
	}
	//查找
    CString str="ISBN='"+m_bid_temp+"'";
	book_set.m_strFilter=str;
	book_set.Open();       //打开数据集合
	int recount=book_set.GetRecordCount();
	if(recount==0)
	{
		MessageBox("无此图书记录!");
		book_set.m_strFilter="";	
	}
	else
	{
		m_bid=book_set.m_ISBN;
	    m_bname=book_set.m_Bname;
        m_bauthor=book_set.m_Bauthor;
		m_btran=book_set.m_Btran;
	    m_bpublisher=book_set.m_Bpublisher;
		m_bprice=book_set.m_Bprice;
		m_b_total_count=book_set.m_B_total_count;
		m_b_borrowed_count=book_set.m_B_borrow_count;
		m_b_left_count=book_set.m_B_left_count;
	}
	UpdateData(FALSE);//显示
	book_set.Close();
	
}

void Book_manage::OnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_bid.IsEmpty()||m_bname.IsEmpty()||m_bauthor.IsEmpty()||m_bpublisher.IsEmpty()
		||m_bprice==0||m_b_total_count==0)
	{
	   MessageBox("请输入准确信息");
	   return;
	}
	
	CString str="ISBN='"+m_bid+"'";
	book_set.m_strFilter=str;
	book_set.Open();
	int recount=0;
	recount=book_set.GetRecordCount();//
	if(recount==0)
	{	
		book_set.AddNew();//使数据集对象处于增加状态
	    book_set.m_ISBN=m_bid;
	    book_set.m_Bname=m_bname;
	    book_set.m_Bauthor=m_bauthor;
	    book_set.m_Bpublisher=m_bpublisher;
		book_set.m_Bprice=m_bprice;
		book_set.m_B_total_count=m_b_total_count;
		book_set.m_B_borrow_count=m_b_borrowed_count;
		
    	
    	book_set.Update();//增加和更新都要执行一个此操作
        book_set.MoveFirst();
    	book_set.Requery();
    	MessageBox("图书信息添加成功!");
		book_set.m_strFilter="";//	
	}
	else
	{
		MessageBox("该图书编号已经存在!");
	}
	UpdateData(FALSE);
	book_set.Close();
	
}

void Book_manage::OnDelete() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_bid.IsEmpty())
	{
	   MessageBox("请输入要删除的图书编号!");
	   return;
	}
	book_set.Open();	
	book_set.Delete();
    book_set.MoveFirst();//?
    book_set.Requery();//?
	m_bid="";
	m_bname="";
    m_bauthor="";
	m_btran="";
	m_bpublisher="";
    m_bprice=0;//INT型置0
	m_b_total_count=0;
	m_b_borrowed_count=0;

	MessageBox("删除成功");
	UpdateData(FALSE);
	book_set.Close();
	
}

void Book_manage::OnUpdate() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_bid.IsEmpty())
	{
	   MessageBox("请输入信息!");
	   return;
	}

	book_set.Open();
	book_set.Edit();//处于更新状态
	book_set.m_ISBN=m_bid;
	book_set.m_Bname=m_bname;
	book_set.m_Bauthor=m_bauthor;
	book_set.m_Btran=m_btran;
	book_set.m_Bpublisher=m_bpublisher;
	book_set.m_Bprice=m_bprice;
	book_set.m_B_total_count=m_b_total_count;
	book_set.m_B_borrow_count=m_b_borrowed_count;
	
    book_set.Update();
    book_set.MoveFirst();
    book_set.Requery();
	MessageBox("更新成功");
	UpdateData(FALSE);
	book_set.Close();
}