readermgrdlg.cpp

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

// ReaderMgrDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "ReaderMgrDlg.h"
#include "ReaderAddDlg.h"
#include "ReaderModiDlg.h"
#include "Columns.h"
#include "Column.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReaderMgrDlg dialog


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


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


BEGIN_MESSAGE_MAP(CReaderMgrDlg, CDialog)
	//{{AFX_MSG_MAP(CReaderMgrDlg)
	ON_BN_CLICKED(IDC_BTN_USER_ADD, OnBtnUserAdd)
	ON_BN_CLICKED(IDC_BTN_USER_DEL, OnBtnUserDel)
	ON_BN_CLICKED(IDC_BTN_USER_MODI, OnBtnUserModi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReaderMgrDlg message handlers

void CReaderMgrDlg::OnBtnUserAdd() 
{
	CReaderAddDlg dlg;
	dlg.DoModal();
	m_ad.Refresh();	
}

void CReaderMgrDlg::OnBtnUserDel() 
{
	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 sql,prompt;
	prompt.Format("确定要删除读者: %s 吗?",strName);
	if(MessageBox(prompt,"提示",MB_OKCANCEL)!=IDOK) return;
	sql.Format("delete from 读者表 where readerId=%d",atoi(strID));
	g_adoDB.Execute(sql);

	m_ad.Refresh();
}

void CReaderMgrDlg::OnBtnUserModi() 
{
	CReaderModiDlg dlg;

	CColumns columns;
	columns=m_dg.GetColumns();

	VARIANT index;
	CColumn column;
	index.vt=VT_INT;
	index.lVal=0;
	column=columns.GetItem(index);
	dlg.rid=column.GetText();//读者编号(ID)

	index.lVal=1;
	column=columns.GetItem(index);
	dlg.m_name=column.GetText();//读者姓名
	
	index.lVal=2;
	column=columns.GetItem(index);
	dlg.m_sex=(column.GetText()=="男")?0:1;//性别

	index.lVal=3;
	column=columns.GetItem(index);
	dlg.m_age=atoi(column.GetText());//年龄
	
	index.lVal=4;
	column=columns.GetItem(index);
	dlg.m_duty=column.GetText();//职务
	
	index.lVal=5;
	column=columns.GetItem(index);
	dlg.m_depart=column.GetText();//科室
	
	index.lVal=6;
	column=columns.GetItem(index);
	dlg.m_tel=column.GetText();//电话

	index.lVal=7;
	column=columns.GetItem(index);
	dlg.m_cert=column.GetText();//证件号

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

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