»ùÓÚMYSQLµÄÒ½Ôº×ÛºÏÐÅÏ¢¹ÜÀíϵͳÉè¼Æ±¨¸æ

m_AdoConn.ExitConnect(); MessageBox(CString(\ɾ³ý³É¹¦.\ m_grid.DeleteAllItems();//ɾ³ýgridÖÐÔ­À´µÄÊý¾Ý CString str; str=\ AddToGrid(str);//ÖØбéÀú } }

void CPatientDlg::OnBnClickedClear() { // TODO: ÔÚ´ËÌí¼Ó¿Ø¼þ֪ͨ´¦Àí³ÌÐò´úÂë m_age = _T(\ m_no = _T(\ m_idcard = _T(\ m_name = _T(\ m_nation = _T(\ m_native = _T(\ m_allergy = _T(\ m_phone = _T(\ m_sex = _T(\ UpdateData(false); }

void CPatientDlg::OnBnClickedSelect() { // TODO: ÔÚ´ËÌí¼Ó¿Ø¼þ֪ͨ´¦Àí³ÌÐò´úÂë m_grid.DeleteAllItems(); UpdateData(true); CString str1,str2; int num1; num1=m_combo.GetCurSel(); if(0==num1) { GetDlgItem(IDC_EDIT_CONTENT)->GetWindowText(str1); str2=CString(\from patient where \

patientno like

37

AddToGrid(str2);// ±éÀú¹¦ÄÜÐÅÏ¢¼Ç¼ } if(1==num1) { GetDlgItem(IDC_EDIT_CONTENT)->GetWindowText(str1); str2=CString(\ AddToGrid(str2);// ±éÀú¹¦ÄÜÐÅÏ¢¼Ç¼ } if(2==num1) { GetDlgItem(IDC_EDIT_CONTENT)->GetWindowText(str1); str2=CString(\ AddToGrid(str2);// ±éÀú¹¦ÄÜÐÅÏ¢¼Ç¼ } if(3==num1) { GetDlgItem(IDC_EDIT_CONTENT)->GetWindowText(str1); str2=\ AddToGrid(str2);// ±éÀú¹¦ÄÜÐÅÏ¢¼Ç¼ } }

void CPatientDlg::OnNMClickListPatient(NMHDR *pNMHDR, LRESULT *pResult) { LPNMITEMACTIVATE pNMItemActivate = reinterpret_cast(pNMHDR); // TODO: ÔÚ´ËÌí¼Ó¿Ø¼þ֪ͨ´¦Àí³ÌÐò´úÂë int nItem=0; POSITION pos = m_grid.GetFirstSelectedItemPosition(); if (pos == NULL) TRACE0(\ else { while (pos) { nItem = m_grid.GetNextSelectedItem(pos);//ÕÒµ½±»Ñ¡ÖеÄÐкŠTRACE1(\ } //¶ÁÈ¡±»Ñ¡ÖÐÐеÄÊý¾Ý m_no=m_grid.GetItemText(nItem,0); m_name=m_grid.GetItemText(nItem,1);

38

m_sex=m_grid.GetItemText(nItem,2); m_age=m_grid.GetItemText(nItem,3); m_native=m_grid.GetItemText(nItem,4); m_nation=m_grid.GetItemText(nItem,5); m_allergy=m_grid.GetItemText(nItem,6); m_idcard=m_grid.GetItemText(nItem,7); m_phone=m_grid.GetItemText(nItem,8); UpdateData(FALSE);//¸üжԻ°¿ò } *pResult = 0; }

// EmployeeDlg.cpp : ʵÏÖÎļþ //ÈËÔ±¹ÜÀí£ºÎâæÃ

#include \#include \

#include \#include \#include \

// CEmployeeDlg ¶Ô»°¿ò

IMPLEMENT_DYNAMIC(CEmployeeDlg, CDialogEx)

CEmployeeDlg::CEmployeeDlg(CWnd* pParent /*=NULL*/) : CDialogEx(CEmployeeDlg::IDD, pParent) { m_age = _T(\ m_content = _T(\ m_idcard = _T(\ m_name = _T(\ m_nation = _T(\ m_native = _T(\ m_number = _T(\ m_office = _T(\ m_phone = _T(\ m_position = _T(\ m_sex = _T(\}

39

CEmployeeDlg::~CEmployeeDlg() { }

void CEmployeeDlg::DoDataExchange(CDataExchange* pDX) { CDialogEx::DoDataExchange(pDX); DDX_Text(pDX, IDC_EDIT_AGE, m_age); DDX_Text(pDX, IDC_EDIT_CONTENT, m_content); DDX_Text(pDX, IDC_EDIT_IDCARD, m_idcard); DDX_Text(pDX, IDC_EDIT_NAME, m_name); DDX_Text(pDX, IDC_EDIT_NATION, m_nation); DDX_Text(pDX, IDC_EDIT_NATIVE, m_native); DDX_Text(pDX, IDC_EDIT_NUMBER, m_number); DDX_Text(pDX, IDC_EDIT_OFFICE, m_office); DDX_Text(pDX, IDC_EDIT_PHONE, m_phone); DDX_Text(pDX, IDC_EDIT_POSITION, m_position); DDX_Text(pDX, IDC_EDIT_SEX, m_sex); DDX_Control(pDX, IDC_LIST_EMPLOYEE, m_grid); DDX_Control(pDX, IDC_COMBO1, m_combo); }

BEGIN_MESSAGE_MAP(CEmployeeDlg, CDialogEx) ON_BN_CLICKED(IDOK, &CEmployeeDlg::OnBnClickedOk) ON_BN_CLICKED(IDC_CHANGE, &CEmployeeDlg::OnBnClickedChange) ON_BN_CLICKED(IDC_DELETE, &CEmployeeDlg::OnBnClickedDelete) ON_BN_CLICKED(IDC_CLEAR, &CEmployeeDlg::OnBnClickedClear) ON_BN_CLICKED(IDC_SELECT, &CEmployeeDlg::OnBnClickedSelect) ON_NOTIFY(NM_CLICK, IDC_LIST_EMPLOYEE, &CEmployeeDlg::OnNMClickListEmployee) END_MESSAGE_MAP()

// CEmployeeDlg ÏûÏ¢´¦Àí³ÌÐò

BOOL CEmployeeDlg::OnInitDialog() { CDialogEx::OnInitDialog(); // TODO: ÔÚ´ËÌí¼Ó¶îÍâµÄ³õʼ»¯ m_grid.SetExtendedStyle(LVS_EX_FLATSB |LVS_EX_FULLROWSELECT

40