fou_dialog.cpp

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

// fou_dialog.cpp : implementation file
//

#include "stdafx.h"
#include "医药管理系统.h"
#include "fou_dialog.h"
#include "ele_dialog.h"
#include "twel_dialog.h"
#include "thir_dialog.h"

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

/////////////////////////////////////////////////////////////////////////////
// fou_dialog dialog


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


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


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

/////////////////////////////////////////////////////////////////////////////
// fou_dialog message handlers

BOOL fou_dialog::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_Grid.InsertColumn(0,"工作员代号",LVCFMT_LEFT,95,0);
	m_Grid.InsertColumn(1,"工作员姓名",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(2,"工作员性别",LVCFMT_LEFT,95,2);
	m_Grid.InsertColumn(3,"工作员年龄",LVCFMT_LEFT,95,3);
	m_Grid.InsertColumn(4,"从何年开始工作",LVCFMT_LEFT,125,4);
	m_Grid.InsertColumn(5,"工作类型",LVCFMT_LEFT,95,5);
	m_Grid.InsertColumn(6,"联系方式",LVCFMT_LEFT,105,6);
    // 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 fou_dialog::OnButton1() 
{
	// TODO: Add your control notification handler code here
   ele_dialog dlg;
   dlg.DoModal();
}

void fou_dialog::OnButton2() 
{
	// TODO: Add your control notification handler code here
	twel_dialog dlg;
	dlg.DoModal();
}

void fou_dialog::OnOK() 
{
	// TODO: Add extra validation here
		CDialog::OnOK();
}

void fou_dialog::OnButton4() 
{
	// TODO: Add your control notification handler code here
	
	 ::CoInitialize(NULL); 
 UpdateData(true);

	    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.DeleteAllItems();

/*	m_Grid.InsertColumn(0,"工作员代号",LVCFMT_LEFT,95,0);
	m_Grid.InsertColumn(1,"工作员姓名",LVCFMT_LEFT,95,1);
	m_Grid.InsertColumn(2,"工作员性别",LVCFMT_LEFT,95,2);
	m_Grid.InsertColumn(3,"工作员年龄",LVCFMT_LEFT,95,3);
	m_Grid.InsertColumn(4,"从何年开始工作",LVCFMT_LEFT,125,4);
	m_Grid.InsertColumn(5,"工作类型",LVCFMT_LEFT,95,5);
	m_Grid.InsertColumn(6,"联系方式",LVCFMT_LEFT,105,6);*/
  // for(int i=1;i<8;i++)
  // m_Grid.DeleteColumn(i);
   // m_Grid.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());
	}
	_bstr_t bstrSQL = "select * from Jober_info order by 工作员代号 desc";
	m_pRecordset.CreateInstance(__uuidof(Recordset));
	m_pRecordset->Open(bstrSQL,m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	while(!m_pRecordset->adoEOF)
	{
		m_Grid.InsertItem(0,"");
		m_Grid.SetItemText(0,0,(char*)(_bstr_t)m_pRecordset->GetCollect("工作员代号"));
		m_Grid.SetItemText(0,1,(char*)(_bstr_t)m_pRecordset->GetCollect("工作员姓名"));
		m_Grid.SetItemText(0,2,(char*)(_bstr_t)m_pRecordset->GetCollect("工作员性别"));
		m_Grid.SetItemText(0,3,(char*)(_bstr_t)m_pRecordset->GetCollect("工作员年龄"));
		m_Grid.SetItemText(0,4,(char*)(_bstr_t)m_pRecordset->GetCollect("从何年开始工作"));
		m_Grid.SetItemText(0,5,(char*)(_bstr_t)m_pRecordset->GetCollect("工作类型"));
		m_Grid.SetItemText(0,6,(char*)(_bstr_t)m_pRecordset->GetCollect("联系方式"));
		m_pRecordset->MoveNext();
	}
	if(m_pRecordset!=NULL)
		m_pRecordset->Close();
	m_pConnection->Close();
}

void fou_dialog::OnButton3() 
{
	// TODO: Add your control notification handler code here
   thir_dialog dlg;
   dlg.DoModal();
}