search.cpp

一个简单的银行管理程序 VC++实现

// Search.cpp : implementation file
//

#include "stdafx.h"
#include "BankSystem.h"
#include "Search.h"

#include "BankSystemDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSearch dialog


CSearch::CSearch(CWnd* pParent /*=NULL*/)
	: CDialog(CSearch::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearch)
	m_strUser = _T("");
	m_strMoney= _T("");
	//}}AFX_DATA_INIT
}


void CSearch::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearch)
	DDX_Text(pDX, IDC_EDIT1, m_strUser);
	DDX_Text(pDX, IDC_EDIT2, m_strMoney);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearch, CDialog)
	//{{AFX_MSG_MAP(CSearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearch message handlers

void CSearch::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);

	if(m_strUser.IsEmpty())
	{
		AfxMessageBox("账号不能为空!");
		return;
	}
	CBankSystemApp *App = (CBankSystemApp*)AfxGetApp();
	CBankSystemDlg *m_pMain = (CBankSystemDlg*)App->m_pMainWnd;
	m_pCon=m_pMain->m_pConnection;
    CString strSQL;
	strSQL="SELECT * FROM Acount where 账号=";
	strSQL+=m_strUser;
	m_pRec.CreateInstance(__uuidof(Recordset));
	m_pRec->Open(_variant_t(strSQL),m_pCon.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	if(m_pRec->adoEOF)
	{
		AfxMessageBox("账户不存在!");
		m_pRec->Close();
		return;
	}
	m_pRec->Close();

	m_pMain->Check(m_strUser);
	
	m_pRec.CreateInstance(__uuidof(Recordset));
	m_pRec->Open(_variant_t(strSQL),m_pCon.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	m_strMoney=(LPCSTR)_bstr_t(m_pRec->GetCollect("金额"));
    m_strMoney.Delete(m_strMoney.Find(".")+3,m_strMoney.GetLength()-m_strMoney.Find(".")-3);

	UpdateData(false);
	m_pRec->Close();

}