prooflostdlg.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// ProofLostDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LibDBS.h"
#include "ProofLostDlg.h"
#include "PersonInfoDlg.h"
#include "ProofSet.h"
#include "CheckProofDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CProofLostDlg dialog


CProofLostDlg::CProofLostDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CProofLostDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CProofLostDlg)
	m_strProofID = _T("");
	//}}AFX_DATA_INIT
}


void CProofLostDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProofLostDlg)
	DDX_Text(pDX, IDC_EDIT_PROOF_NO, m_strProofID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProofLostDlg, CDialog)
	//{{AFX_MSG_MAP(CProofLostDlg)
	ON_BN_CLICKED(IDC_BUTTON_SHOW, OnButtonShow)
	ON_BN_CLICKED(IDC_BUTTON_LOST, OnButtonLost)
	ON_BN_CLICKED(IDC_BUTTON_BACK, OnButtonBack)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProofLostDlg message handlers

void CProofLostDlg::OnButtonShow() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strProofID=="")
	{
		MessageBox("请填写借阅证号码!");
		return;
	}
	CPersonInfoDlg m_dlg;
	m_dlg.m_strProofID=m_strProofID;
	m_dlg.DoModal();	
}

void CProofLostDlg::OnButtonLost() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strProofID=="")
	{
		MessageBox("请填写借阅证号码!");
		return;
	}
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("不能打开数据库","借阅证挂失");
			return;
		}
	}
	CProofSet *m_pset=new CProofSet(&m_database);
	CString strSQL;
	strSQL.Format("select * from Proof_Info where Proof_ID='%s'",m_strProofID);
	m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if(m_pset->GetRecordCount()==0)
	{
		MessageBox("数据库中没有该人的信息","借阅证挂失");
		m_pset->Close();
		m_database.Close();
		return;
	}
	//挂失，删除该借阅证的记录信息
	m_pset->Delete();
	m_pset->Close();
	m_database.Close();
	int iResult;
	iResult=MessageBox("挂失成功,是否查阅，进行确认","借阅证挂失",MB_YESNO|MB_ICONQUESTION);
	if(iResult==IDYES)
	{
		CCheckProofDlg m_dlg;
		m_dlg.m_strProofID=m_strProofID;
		m_dlg.DoModal();
	}	
}

void CProofLostDlg::OnButtonBack() 
{
	// TODO: Add your control notification handler code here
	
	if(m_database.IsOpen())
		m_database.Close();
	OnOK();
}

void CProofLostDlg::OnClose() 
{
	OnButtonBack();
}