ten_dialog.cpp

来自「对医院的药品进行管理」· C++ 代码 · 共 236 行

CPP
236 行
字号 
// ten_dialog.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// ten_dialog dialog


ten_dialog::ten_dialog(CWnd* pParent /*=NULL*/)
	: CDialog(ten_dialog::IDD, pParent)
{
	//{{AFX_DATA_INIT(ten_dialog)
	m_MedicineNum = _T("");
	m_MedicineName = _T("");
	m_MedicineClass = _T("");
	m_MedicineValue = _T("");
	m_MedicineAmount = _T("");
	m_MedicineMakeTime = _T("");
	m_MedicineEffectTime = _T("");
	m_MedicineAddress = _T("");
	//}}AFX_DATA_INIT
}


void ten_dialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ten_dialog)
	DDX_Control(pDX, IDC_LIST3, m_Grid2);
	DDX_Control(pDX, IDC_LIST1, m_Grid1);
	DDX_Text(pDX, IDC_EDIT1, m_MedicineNum);
	DDX_Text(pDX, IDC_EDIT2, m_MedicineName);
	DDX_Text(pDX, IDC_EDIT3, m_MedicineClass);
	DDX_Text(pDX, IDC_EDIT4, m_MedicineValue);
	DDX_Text(pDX, IDC_EDIT5, m_MedicineAmount);
	DDX_Text(pDX, IDC_EDIT6, m_MedicineMakeTime);
	DDX_Text(pDX, IDC_EDIT7, m_MedicineEffectTime);
	DDX_Text(pDX, IDC_EDIT8, m_MedicineAddress);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(ten_dialog, CDialog)
	//{{AFX_MSG_MAP(ten_dialog)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// ten_dialog message handlers

BOOL ten_dialog::OnInitDialog() 
{
	CDialog::OnInitDialog();
   ::CoInitialize(NULL); 
 UpdateData(true);

//	    m_Grid.SetExtendedStyle(LVS_EX_FLATSB
//		|LVS_EX_FULLROWSELECT
//		|LVS_EX_HEADERDRAGDROP
//		|LVS_EX_ONECLICKACTIVATE
//		|LVS_EX_GRIDLINES);
 m_Grid2.InsertColumn(0,"药品代号",LVCFMT_LEFT,95,0);
	m_Grid2.InsertColumn(1,"药品名",LVCFMT_LEFT,95,1);
	m_Grid2.InsertColumn(2,"药品类型",LVCFMT_LEFT,95,2);
	m_Grid2.InsertColumn(3,"药品价格",LVCFMT_LEFT,95,3);
	m_Grid2.InsertColumn(4,"药品数量",LVCFMT_LEFT,95,4);
	m_Grid2.InsertColumn(5,"生产时间",LVCFMT_LEFT,95,5);
	m_Grid2.InsertColumn(6,"有效时间",LVCFMT_LEFT,95,6);
	m_Grid2.InsertColumn(7,"药品出产厂址",LVCFMT_LEFT,115,7);
	m_Grid1.ModifyStyle(0L,LVS_REPORT);
	m_Grid1.ModifyStyle(0L,LVS_SINGLESEL);
	m_Grid1.ModifyStyle(0L,LVS_SHOWSELALWAYS);
	m_Grid1.ModifyStyle(0L,LVS_NOSORTHEADER);
    m_Grid1.SetExtendedStyle(LVS_EX_GRIDLINES);

	m_Grid1.InsertColumn(0,"药品代号",LVCFMT_LEFT,95,0);
	m_Grid1.InsertColumn(1,"药品名",LVCFMT_LEFT,95,1);
	m_Grid1.InsertColumn(2,"药品类型",LVCFMT_LEFT,95,2);
	m_Grid1.InsertColumn(3,"药品价格",LVCFMT_LEFT,95,3);
	m_Grid1.InsertColumn(4,"药品数量",LVCFMT_LEFT,95,4);
	m_Grid1.InsertColumn(5,"生产时间",LVCFMT_LEFT,95,5);
	m_Grid1.InsertColumn(6,"有效时间",LVCFMT_LEFT,95,6);
	m_Grid1.InsertColumn(7,"药品出产厂址",LVCFMT_LEFT,95,7);
	CString strname;
	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,"","",adModeUnknown);
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());
	}
	_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)
	{
		m_Grid1.InsertItem(0,"");
		m_Grid1.SetItemText(0,0,(char*)(_bstr_t)m_pRecordset->GetCollect("药品代号"));
		m_Grid1.SetItemText(0,1,(char*)(_bstr_t)m_pRecordset->GetCollect("药品名"));
		m_Grid1.SetItemText(0,2,(char*)(_bstr_t)m_pRecordset->GetCollect("药品类型"));
		m_Grid1.SetItemText(0,3,(char*)(_bstr_t)m_pRecordset->GetCollect("药品价格"));
		m_Grid1.SetItemText(0,4,(char*)(_bstr_t)m_pRecordset->GetCollect("药品数量"));
		m_Grid1.SetItemText(0,5,(char*)(_bstr_t)m_pRecordset->GetCollect("生产时间"));
		m_Grid1.SetItemText(0,6,(char*)(_bstr_t)m_pRecordset->GetCollect("有效时间"));
		m_Grid1.SetItemText(0,7,(char*)(_bstr_t)m_pRecordset->GetCollect("药品出产厂址"));
		m_pRecordset->MoveNext();
	}
	if(m_pRecordset!=NULL)
		m_pRecordset->Close();
	m_pConnection->Close();

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

void ten_dialog::OnButton1() 
{

	// TODO: Add your control notification handler code here
	//CDialog::OnOK();
	::CoInitialize(NULL); 
	_bstr_t bstrSQL;
 UpdateData(true);

	CString strname;
	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,"","",adModeUnknown);
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());
	}
	bstrSQL="update Medicine_info set 药品名='"+m_MedicineName+"',药品类型='"+m_MedicineClass+"',药品价格='"+m_MedicineValue+"',药品数量='"+m_MedicineAmount+"',生产时间='"+m_MedicineMakeTime+"',有效时间='"+m_MedicineEffectTime+"',药品出产厂址='"+m_MedicineAddress+"'where 药品代号='"+m_MedicineNum+"'";
    m_pRecordset.CreateInstance(__uuidof(Recordset));
	m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	AfxMessageBox("修改成功!");
	UpdateData(false);
}

void ten_dialog::OnButton2() 
{
	// TODO: Add your control notification handler code here
	
		::CoInitialize(NULL); 
	_bstr_t bstrSQL;
 UpdateData(true);

//	    m_Grid.SetExtendedStyle(LVS_EX_FLATSB
//		|LVS_EX_FULLROWSELECT
//		|LVS_EX_HEADERDRAGDROP
//		|LVS_EX_ONECLICKACTIVATE
//		|LVS_EX_GRIDLINES);
	m_Grid2.ModifyStyle(0L,LVS_REPORT);
	m_Grid2.ModifyStyle(0L,LVS_SINGLESEL);
	m_Grid2.ModifyStyle(0L,LVS_SHOWSELALWAYS);
	m_Grid2.ModifyStyle(0L,LVS_NOSORTHEADER);
    m_Grid2.SetExtendedStyle(LVS_EX_GRIDLINES);
		m_Grid2.DeleteAllItems();

/*	m_Grid2.InsertColumn(0,"药品代号",LVCFMT_LEFT,95,0);
	m_Grid2.InsertColumn(1,"药品名",LVCFMT_LEFT,95,1);
	m_Grid2.InsertColumn(2,"药品类型",LVCFMT_LEFT,95,2);
	m_Grid2.InsertColumn(3,"药品价格",LVCFMT_LEFT,95,3);
	m_Grid2.InsertColumn(4,"药品数量",LVCFMT_LEFT,95,4);
	m_Grid2.InsertColumn(5,"生产时间",LVCFMT_LEFT,95,5);
	m_Grid2.InsertColumn(6,"有效时间",LVCFMT_LEFT,95,6);
	m_Grid2.InsertColumn(7,"药品出产厂址",LVCFMT_LEFT,115,7);*/
	// for(int i=1;i<8;i++)
//	   m_Grid2.DeleteColumn(i);
   // m_Grid2.DeleteAllItems();
	CString strname;
	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,"","",adModeUnknown);
	}
	catch(_com_error e)
	{
		AfxMessageBox(e.Description());
	}
	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)
	{
		m_Grid2.InsertItem(0,"");
		m_Grid2.SetItemText(0,0,(char*)(_bstr_t)m_pRecordset->GetCollect("药品代号"));
		m_Grid2.SetItemText(0,1,(char*)(_bstr_t)m_pRecordset->GetCollect("药品名"));
		m_Grid2.SetItemText(0,2,(char*)(_bstr_t)m_pRecordset->GetCollect("药品类型"));
		m_Grid2.SetItemText(0,3,(char*)(_bstr_t)m_pRecordset->GetCollect("药品价格"));
		m_Grid2.SetItemText(0,4,(char*)(_bstr_t)m_pRecordset->GetCollect("药品数量"));
		m_Grid2.SetItemText(0,5,(char*)(_bstr_t)m_pRecordset->GetCollect("生产时间"));
		m_Grid2.SetItemText(0,6,(char*)(_bstr_t)m_pRecordset->GetCollect("有效时间"));
		m_Grid2.SetItemText(0,7,(char*)(_bstr_t)m_pRecordset->GetCollect("药品出产厂址"));
		m_pRecordset->MoveNext();
	}
	if(m_pRecordset!=NULL)
		m_pRecordset->Close();
	m_pConnection->Close();
		
 
   UpdateData(false);
}

void ten_dialog::OnButton3() 
{
	// TODO: Add your control notification handler code here
	six_dialog dlg;
	dlg.DoModal();

}

ten_dialog.cpp - 源码说明

本页面展示了「对医院的药品进行管理」中的 ten_dialog.cpp 源码文件，采用 C++ 编程语言编写，共 236 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?