nin_dialog.cpp

对医院的药品进行管理

// nin_dialog.cpp : implementation file
//

#include "stdafx.h"
#include "医药管理系统.h"
#include "nin_dialog.h"

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

/////////////////////////////////////////////////////////////////////////////
// nin_dialog dialog


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


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


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

/////////////////////////////////////////////////////////////////////////////
// nin_dialog message handlers

BOOL nin_dialog::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	::CoInitialize(NULL); 
	UpdateData(true);
	////////////////////////////////////////////////////////////////////////

	// TODO: Add extra initialization here
	m_Grid.SetExtendedStyle(LVS_EX_FLATSB
		|LVS_EX_FULLROWSELECT
		|LVS_EX_HEADERDRAGDROP
		|LVS_EX_ONECLICKACTIVATE
		|LVS_EX_GRIDLINES);
	m_Grid.ModifyStyle(0L,LVS_REPORT);
	m_Grid.ModifyStyle(0L,LVS_SINGLESEL);
	m_Grid.ModifyStyle(0L,LVS_SHOWSELALWAYS);
	m_Grid.ModifyStyle(0L,LVS_NOSORTHEADER);
	m_Grid.SetExtendedStyle(LVS_EX_GRIDLINES);

	m_Grid.InsertColumn(0,"药品代号",LVCFMT_LEFT,95,0);
	m_Grid.InsertColumn(1,"药品名",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(2,"药品类型",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(3,"药品价格",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(4,"药品数量",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(5,"生产时间",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(6,"有效时间",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(7,"药品出厂厂址",LVCFMT_LEFT,115,0);

/////////////////////////////////////////////////////////////////////////////
	CString strname;//sql语句
	try
	{
		strname.Format("Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=YPGl;Initial Catalog=YPGL");
		m_pConnection.CreateInstance("ADODB.Connection");
		_bstr_t strConnect=strname;
		m_pConnection->Open(strConnect,"","",0);//链接数据库
		_bstr_t bstrSQL = "select * from Medicine_info order by 药品代号 desc";
		m_pRecordset.CreateInstance(__uuidof(Recordset));
		m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
		while(!m_pRecordset->adoEOF)
		{
			CString Medicine_num=(char*)(_bstr_t)m_pRecordset->GetCollect("药品代号");
			CString Medicine_name=(char*)(_bstr_t)m_pRecordset->GetCollect("药品名");
			CString Medicine_class=(char*)(_bstr_t)m_pRecordset->GetCollect("药品类型");
			CString Medicine_value=(char*)(_bstr_t)m_pRecordset->GetCollect("药品价格");
			CString Medicine_amount=(char*)(_bstr_t)m_pRecordset->GetCollect("药品数量");
			CString Medicine_makeTime=(char*)(_bstr_t)m_pRecordset->GetCollect("生产时间");
			CString Medicine_effectTime=(char*)(_bstr_t)m_pRecordset->GetCollect("有效时间");
			CString Medicine_address=(char*)(_bstr_t)m_pRecordset->GetCollect("药品出厂厂址");
		
			m_Grid.InsertItem(0,"");
			m_Grid.SetItemText(0,0,Medicine_num);
			m_Grid.SetItemText(0,1,Medicine_name);
			m_Grid.SetItemText(0,2,Medicine_class);
			m_Grid.SetItemText(0,3,Medicine_value);
			m_Grid.SetItemText(0,4,Medicine_amount);
			m_Grid.SetItemText(0,5,Medicine_makeTime);
			m_Grid.SetItemText(0,6,Medicine_effectTime);
			m_Grid.SetItemText(0,7,Medicine_address);
	
			m_pRecordset->MoveNext();
		}
		if(m_pRecordset!=NULL)
			m_pRecordset->Close();
		m_pConnection->Close();
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());//e.Description()
	}

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