check.cpp

一个实现ADO数据库病人信息核对系统的程序

// Check.cpp : implementation file
//

#include "stdafx.h"
#include "login.h"
#include "Check.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCheck dialog


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


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


BEGIN_MESSAGE_MAP(CCheck, CDialog)
	//{{AFX_MSG_MAP(CCheck)
	ON_BN_CLICKED(IDC_inquiry, Oninquiry)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()
extern CLoginApp theApp;
/////////////////////////////////////////////////////////////////////////////
// CCheck message handlers
BOOL CCheck::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_List.InsertColumn(0,"预约号",LVCFMT_LEFT,60);
	m_List.InsertColumn(1,"姓名",LVCFMT_LEFT,80);
	m_List.InsertColumn(2,"预约时间",LVCFMT_LEFT,100);
    m_List.InsertColumn(3,"收费",LVCFMT_LEFT,60);
	

	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCheck::Oninquiry() 
{
    int nItem;
	_variant_t vUsername,vCharge,vID,vOld;
	try
	{
		m_pRecordset.CreateInstance("ADODB.Recordset");
		m_pRecordset->Open("SELECT * FROM users",_variant_t((IDispatch*)theApp.m_pConnection1,true),
			         adOpenStatic,adLockOptimistic,adCmdText);
		while(!m_pRecordset->adoEOF)
		{
			vID = m_pRecordset->GetCollect("预约号");
			vUsername = m_pRecordset->GetCollect("姓名");
			vOld = m_pRecordset->GetCollect("预约时间");
			vCharge = m_pRecordset->GetCollect("收费");
			nItem=m_List.InsertItem(0xffff,(_bstr_t)vID);
			m_List.SetItem(nItem,1,1,(_bstr_t)vUsername,NULL,0,0,0);
			m_List.SetItem(nItem,2,1,(_bstr_t)vOld,NULL,0,0,0);
			m_List.SetItem(nItem,3,1,(_bstr_t)vCharge,NULL,0,0,0);

			m_pRecordset->MoveNext();
		}
	}
	catch(_com_error e)///捕捉异常
	{
		AfxMessageBox("读取数据库失败!");///显示错误信息
	}
	}