recordmgrdlg.cpp

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

// RecordMgrDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "RecordMgrDlg.h"
#include "RecordAddDlg.h"
#include "Columns.h"
#include "Column.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRecordMgrDlg dialog


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


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


BEGIN_MESSAGE_MAP(CRecordMgrDlg, CDialog)
	//{{AFX_MSG_MAP(CRecordMgrDlg)
	ON_BN_CLICKED(IDC_BTN_ADD, OnBtnAdd)
	ON_BN_CLICKED(IDC_BTN_DEL, OnBtnDel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRecordMgrDlg message handlers

void CRecordMgrDlg::OnBtnAdd() 
{
	CRecordAddDlg dlg;
	dlg.DoModal();
	m_ad.Refresh();
}

void CRecordMgrDlg::OnBtnDel() 
{
	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();
	
	if(MessageBox("确定要删除这条借阅记录吗","提示",MB_OKCANCEL)!=IDOK) return;
	CString sql;
	sql.Format("delete from 借阅记录表 where recordId=%d",atoi(strID));
	g_adoDB.Execute(sql);

	m_ad.Refresh();	
}