personinfodlg.cpp

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

// PersonInfoDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CPersonInfoDlg dialog


CPersonInfoDlg::CPersonInfoDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPersonInfoDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPersonInfoDlg)
	m_lAmount = 0;
	m_strAddress = _T("");
	m_strDate = _T("");
	m_strID = _T("");
	m_strName = _T("");
	m_strPhone = _T("");
	m_strProofID = _T("");
	m_strSex = _T("");
	//}}AFX_DATA_INIT
}


void CPersonInfoDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPersonInfoDlg)
	DDX_Text(pDX, IDC_EDIT_AMOUNT, m_lAmount);
	DDX_Text(pDX, IDC_STATIC_ADDRESS, m_strAddress);
	DDX_Text(pDX, IDC_STATIC_BIRTH_DATE, m_strDate);
	DDX_Text(pDX, IDC_STATIC_ID_NUMBER, m_strID);
	DDX_Text(pDX, IDC_STATIC_NAME, m_strName);
	DDX_Text(pDX, IDC_STATIC_PHONE, m_strPhone);
	DDX_Text(pDX, IDC_STATIC_PROOF_NO, m_strProofID);
	DDX_Text(pDX, IDC_STATIC_SEX, m_strSex);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPersonInfoDlg, CDialog)
	//{{AFX_MSG_MAP(CPersonInfoDlg)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPersonInfoDlg message handlers

BOOL CPersonInfoDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	if(!m_database.IsOpen())
	{
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("数据库打开出错!");
			return FALSE;
		}
	}

	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("数据库中没有这个人的信息！","查询挂失人信息",MB_ICONERROR);
		m_database.Close();
		OnOK();
	}
	//显示挂失人信息
	m_strName=m_pset->m_Name;
	m_strSex=m_pset->m_Sex;
	m_strDate=m_pset->m_Birth_Time.Format("%y-%m-%d");
	m_strAddress=m_pset->m_Address;
	m_strID=m_pset->m_ID_Number;
	m_strPhone=m_pset->m_Tel_Number;
	m_lAmount=m_pset->m_Now_Borrow_Amount;
	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CPersonInfoDlg::OnClose() 
{
	if(m_database.IsOpen())
		m_database.Close();
	OnOK();
}