localinfo.cpp

各个银行

// LOCALINFO.cpp : implementation file
//

#include "stdafx.h"
#include "BankSystem.h"
#include "LOCALINFO.h"
#include "ADOConn.h"
#include "BankSystemDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// LOCALINFO dialog


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


void LOCALINFO::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(LOCALINFO)
	DDX_Control(pDX, IDC_LIST1, m_localcard);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// LOCALINFO message handlers

BOOL LOCALINFO::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
m_localcard.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
m_localcard.InsertColumn(0,_T("卡号"),LVCFMT_LEFT,120);
m_localcard.InsertColumn(2,_T("余额"),LVCFMT_LEFT,100);
m_localcard.InsertColumn(3,_T("利率"),LVCFMT_LEFT,80);

	ADOConn Conn;
Conn.OnInitADOConn();
_RecordsetPtr pRst;
_bstr_t sql;
sql="select * from cardInfo where cardId='"+theApp.CARDID+"'";
pRst=Conn.GetRecordset(sql);
if(pRst->adoEOF)
AfxMessageBox("无此卡");
else
{
	CString  strid,strbla,strcurr;
    _variant_t v;
    v=pRst->GetCollect("yearCurr");
    strcurr.Format("%f",v.dblVal);
  v=pRst->GetCollect("cardId");
  strid=v.bstrVal;
  v=pRst->GetCollect("balance");
  strbla.Format("%f",v.dblVal);
  m_localcard.InsertItem(0,strid);
  m_localcard.SetItemText(0,1,strbla);
  m_localcard.SetItemText(0,2,strcurr);
}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}