medicament.cpp

VC平台下开发的门诊信息管理系统 数据库ACCEES

// Medicament.cpp : implementation file
//

#include "stdafx.h"
#include "Hospital.h"
#include "Medicament.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMedicament dialog


CMedicament::CMedicament(CWnd* pParent /*=NULL*/)
	: CDialog(CMedicament::IDD, pParent)
{
	//{{AFX_DATA_INIT(CMedicament)
	m_sCode = _T("");
	m_sDosage = _T("");
	m_sFactory = _T("");
	m_sForm = _T("");
	m_sName = _T("");
	m_sPrice = _T("");
	m_sType = _T("");
	m_sUnit = _T("");
	m_sUse = _T("");
	//}}AFX_DATA_INIT
}


void CMedicament::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMedicament)
	DDX_Text(pDX, IDC_CODE, m_sCode);
	DDX_Text(pDX, IDC_DOSAGE, m_sDosage);
	DDX_Text(pDX, IDC_FACTORY, m_sFactory);
	DDX_Text(pDX, IDC_FORM, m_sForm);
	DDX_Text(pDX, IDC_NAME, m_sName);
	DDX_Text(pDX, IDC_PRICE, m_sPrice);
	DDX_CBString(pDX, IDC_TYPE, m_sType);
	DDX_CBString(pDX, IDC_UNIT, m_sUnit);
	DDX_Text(pDX, IDC_USE, m_sUse);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CMedicament message handlers

void CMedicament::OnOK() 
{
	// 更新数据
	UpdateData(TRUE);

	// 打开就诊信息表
	try
	{
		// 构造SQL查询语句
		CString strSQL = "SELECT * FROM 药剂信息";

		// 用构造的SQL语句打开记录集
		m_pRecordSet->Open(dbOpenDynaset, strSQL);
	}
	catch (CDaoException *e)
	{   
		AfxMessageBox(e->m_pErrorInfo->m_strDescription, MB_ICONEXCLAMATION);
		delete m_pRecordSet;
		e->Delete();
		return;
	}

	try
	{
		// 滚动到最后一条记录
		if (m_pRecordSet->IsEOF() == FALSE)
			m_pRecordSet->MoveLast();

		// 准备添加新记录
		m_pRecordSet->AddNew();
	}
	catch (CDaoException* e)
	{
		AfxMessageBox(e->m_pErrorInfo->m_strDescription, MB_ICONEXCLAMATION);
		e->Delete();
		return;
	}

	// 得到并插入字段名
	CDaoFieldInfo m_fieldinfo;

	// 将对话框内容填写到数据库各字段
	for (int i = 1; i < m_pRecordSet->GetFieldCount(); i++)
	{    
		// 获取各字段信息
		m_pRecordSet->GetFieldInfo(i, m_fieldinfo);
		
		// 设置字段内容
		switch (i)
		{
		case 1:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sType);
			break;
		case 2:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sName);
			break;
		case 3:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sCode);
			break;
		case 4:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sFactory);
			break;
		case 5:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sPrice);
			break;
		case 6:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sForm);
			break;
		case 7:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sUse);
			break;
		case 8:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sDosage);
			break;
		case 9:
			m_pRecordSet->SetFieldValue((LPCTSTR)m_fieldinfo.m_strName, (LPCTSTR)m_sUnit);
			break;
		}		
	}
	
	// 更新数据
	if (m_pRecordSet->CanUpdate() == TRUE)
		m_pRecordSet->Update();

	// 刷新
	if (m_pRecordSet->CanRestart() == TRUE)
		m_pRecordSet->Requery();
	
	// 关闭记录集
	m_pRecordSet->Close();

	CDialog::OnOK();
}