finddlg.cpp

模拟一个简单的医院系统

// finddlg.cpp : implementation file
//

#include "stdafx.h"
#include "数据库.h"
#include "finddlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cfinddlg dialog


Cfinddlg::Cfinddlg(CWnd* pParent /*=NULL*/)
	: CDialog(Cfinddlg::IDD, pParent)
{
m_table1=NULL;
m_database1=NULL;	
}


void Cfinddlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cfinddlg)
	DDX_Control(pDX, IDC_win, m_win);
	DDX_Control(pDX, IDC_findpill, m_com);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cfinddlg, CDialog)
	//{{AFX_MSG_MAP(Cfinddlg)
	ON_BN_CLICKED(IDC_enterfind, Onenterfind)
	ON_BN_CLICKED(IDC_deletepill1, Ondeletepill)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cfinddlg message handlers

void Cfinddlg::Onenterfind() 
{
	try{
		m_db1.Open(filepath);
	}
	catch(CDaoException *e)
	{
		e->Delete();
		return;
}

m_table1=new CDaoTableDef(&m_db1);
try{
		m_table1->Open("药品");
	}
	catch(CDaoException *e)
	{
		//DisplayDaoException(e);
		//MessageBox(e);
		e->Delete();
		return;
}
m_database1=new CDaoRecordset (&m_db1);
try{
	m_database1->Open(m_table1,dbOpenDynaset );
	}
	catch(CDaoException *e)
	{
		e->Delete();
		return;
}

	m_database1->MoveFirst();
try
{
while(!m_database1->IsEOF())
{
COleVariant temp;
CString str;

m_database1->GetFieldValue(0,temp);
const VARIANT *variant=LPCVARIANT(temp);
if(variant->vt & VT_BYREF)
return;
if(variant->vt==VT_BSTR)
{
	 str=V_BSTRT(&temp);	 
}
string1=str;
m_com.AddString(string1);
m_database1->MoveNext();

}


}
catch(CDaoException *e)
	{
		e->Delete();
		return;	
}
	
}

void Cfinddlg::Ondeletepill() 
{
UpdateData();
COleVariant temp;
CString str;

try
{
const VARIANT *variant=LPCVARIANT(temp);

m_database1->MoveFirst();
CString choosetext;
int couter=m_com.GetCurSel();
m_com.GetLBText(couter,choosetext);
while(!m_database1->IsEOF())
{

m_database1->GetFieldValue(0,temp);
if(variant->vt & VT_BYREF)
return;
if(variant->vt==VT_BSTR)
{
	 str=V_BSTRT(&temp);	 
}
string1=str;
m_database1->GetFieldValue(1,temp);
str.Format(":         %.2f元",V_R8(&temp));
if(string1==choosetext)
{
string1+=str;
m_win.SetWindowText(string1);
UpdateData(false);
break;
}
m_database1->MoveNext();
}
}
catch(CDaoException *e)
	{
		e->Delete();
		return;	
}
//////////////////////
try
{	
	m_database1->MoveFirst();

while(!m_database1->IsEOF())
{
COleVariant temp;
CString str;

m_database1->GetFieldValue(0,temp);
const VARIANT *variant=LPCVARIANT(temp);
if(variant->vt & VT_BYREF)
return;
if(variant->vt==VT_BSTR)
{
	 str=V_BSTRT(&temp);	 
}
string1=str;
m_com.AddString(string1);
m_database1->MoveNext();

}
//UpdateData(false);
//Invalidate(false);
//////////////////////////////////
}
catch(CDaoException *e)
	{
		e->Delete();
		return;	
}

}

void Cfinddlg::OnOK() 
{
	// TODO: Add extra validation here
	m_database1->Close();
m_table1->Close();
m_db1.Close();

if(m_database1!=NULL)
delete m_database1;
if(m_table1!=NULL)
delete m_table1;	
	CDialog::OnOK();
}

BOOL Cfinddlg::OnInitDialog() 
{

GetModuleFileName(NULL,filepath.GetBufferSetLength(MAX_PATH+1),MAX_PATH);
filepath.ReleaseBuffer();
int np;
np=filepath.ReverseFind('\\');
filepath=filepath.Left(np);
filepath+="\\数据库.mdb";
UpdateData(false);
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}