bookmgrdlg.cpp

自己编写的迷你图书馆的完整程序.VC6MFC编写的,Windows界面.数据采用了Sqlserver2000.压缩包中已包括了数据库.先附加数据库再运行.

// BookMgrDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "BookMgrDlg.h"
#include "BookAddDlg.h"
#include "BookModiDlg.h"
#include "Columns.h"
#include "Column.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookMgrDlg dialog


CBookMgrDlg::CBookMgrDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBookMgrDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBookMgrDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CBookMgrDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBookMgrDlg)
	DDX_Control(pDX, IDC_ADODC1, m_ad);
	DDX_Control(pDX, IDC_DATAGRID1, m_dg);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBookMgrDlg, CDialog)
	//{{AFX_MSG_MAP(CBookMgrDlg)
	ON_BN_CLICKED(IDC_BTN_BOOK_ADD, OnBtnBookAdd)
	ON_BN_CLICKED(IDC_BTN_BOOK_DEL, OnBtnBookDel)
	ON_BN_CLICKED(IDC_BTN_BOOK_MODI, OnBtnBookModi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBookMgrDlg message handlers

void CBookMgrDlg::OnBtnBookAdd() 
{
	CBookAddDlg dlg;
	dlg.DoModal();
	m_ad.Refresh();
}

void CBookMgrDlg::OnBtnBookDel() 
{
	CColumns columns;
	columns=m_dg.GetColumns();
	CColumn column;

	VARIANT index;
	index.vt=VT_INT;
	
	index.lVal=0;
	column=columns.GetItem(index);
	CString strID;
	strID=column.GetText();

	index.lVal=1;
	column=columns.GetItem(index);
	CString strName;
	strName=column.GetText();

	CString prompt;
	prompt.Format("确定要删除:<< %s >>吗?",strName);
	if(MessageBox(prompt,"提示",MB_OKCANCEL)!=IDOK)
		return;

	CString sql;
	sql.Format("delete from 书籍编号表 where ISBN='%s'",strID);
	g_adoDB.Execute(sql);//先删除书籍表中记录

	sql.Format("delete from 书籍信息表 where ISBN='%s'",strID);
	g_adoDB.Execute(sql);//删除书籍信息表中记录

	m_ad.Refresh();
}

void CBookMgrDlg::OnBtnBookModi() 
{
	CBookModiDlg dlg;
	
	CColumns columns;
	columns=m_dg.GetColumns();
	CColumn column;

	VARIANT index;
	index.vt=VT_INT;
	
	index.lVal=0;
	column=columns.GetItem(index);
	dlg.strISBN=column.GetText();//ISBN
	
	index.lVal=1;
	column=columns.GetItem(index);
	dlg.m_name=column.GetText();//书名

	index.lVal=4;
	column=columns.GetItem(index);
	dlg.m_author=column.GetText();//作者

	index.lVal=5;
	column=columns.GetItem(index);
	dlg.m_pub=column.GetText();//出版社

	index.lVal=6;
	column=columns.GetItem(index);
	dlg.m_ver=column.GetText();//版本

	index.lVal=7;
	column=columns.GetItem(index);
	dlg.m_price=atof(column.GetText());//价格

	index.lVal=12;
	column=columns.GetItem(index);
	dlg.strProv=column.GetText();//供应商名称

	index.lVal=13;
	column=columns.GetItem(index);
	dlg.m_remark=column.GetText();//备注

	dlg.DoModal();
	m_ad.Refresh();
}