find.cpp

简单的图书图书管理系统 (具有增添 删除 查找 功能) 适合初学者

// find.cpp : implementation file
//

#include "stdafx.h"
#include "MYpro.h"
#include "find.h"
#include "Access1.h"
#include "comdef.h"

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

/////////////////////////////////////////////////////////////////////////////
// find dialog


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


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


BEGIN_MESSAGE_MAP(find, CDialog)
	//{{AFX_MSG_MAP(find)
	ON_BN_CLICKED(IDC_REFRESH, OnRefresh)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// find message handlers


void find::list()
{
    m_list.InsertColumn(0,"职员编号",LVCFMT_LEFT,  100);   
	m_list.InsertColumn(1,"职员姓名",LVCFMT_LEFT,  100); 
	m_list.InsertColumn(2,"职员性别",LVCFMT_LEFT,  100); 
	m_list.InsertColumn(3,"职员职位",LVCFMT_LEFT,  100); 
	m_list.InsertColumn(4,"出生日期",LVCFMT_LEFT,  100); 
	ac=new Access();
}


void find::alist()
{
	CString no,name,sex,job,birth,cmd;  
	_RecordsetPtr _pRecordset;
	cmd="select * from man";
    CoInitialize(NULL);

	try{
	_pRecordset=ac->connect(cmd);
	}
	catch(_com_error e){
			AfxMessageBox(e.ErrorMessage());   
			AfxMessageBox(e.Source());   
			AfxMessageBox(e.Description());
		}
	CoUninitialize();
	while ( !_pRecordset->adoEOF )
    {
		try{ 
	_variant_t vno = _pRecordset->GetCollect(((_variant_t)(long)0));
	no=(LPCTSTR)(_bstr_t)vno;
	_variant_t vname = _pRecordset->GetCollect(((_variant_t)(long)1));
	name=(LPCTSTR)(_bstr_t)vname;
	_variant_t vsex = _pRecordset->GetCollect(((_variant_t)(long)2));
	sex=(LPCTSTR)(_bstr_t)vsex;
    _variant_t vjob = _pRecordset->GetCollect(((_variant_t)(long)3));
	job=(LPCTSTR)(_bstr_t)vjob;
	_variant_t vbirth = _pRecordset->GetCollect(((_variant_t)(long)4));
 	birth=(LPCTSTR)(_bstr_t)vbirth;
     
		}

	catch(_com_error e)
		{
		AfxMessageBox(e.ErrorMessage());   
		AfxMessageBox(e.Source());   
		AfxMessageBox(e.Description());
		return;
		}
	m_list.InsertItem(0,no);
    m_list.SetItemText(0,1,name);
	m_list.SetItemText(0,2,sex);
	m_list.SetItemText(0,3,job);
	m_list.SetItemText(0,4,birth);
	_pRecordset->MoveNext(); 
    }
}

void find::OnRefresh() 
{

	// TODO: Add your control notification handler code here
    clearlist();
	alist();
}
void find::clearlist()
{
     for(int i=0;i<n;i++){
		m_list.DeleteItem(0);
	}
	n=0;
}

BOOL find::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	list();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

//DEL void find::OnDelete() 
//DEL {
//DEL 	// TODO: Add your control notification handler code here
//DEL 	if(isselected==-1) 
//DEL 	{
//DEL 		AfxMessageBox("请先选中用户");
//DEL 		return;
//DEL 	}
//DEL 	char userid[10];
//DEL 	m_list.GetItemText(isselected,0,userid,10);
//DEL 	deluser(userid);
//DEL 	clearedit();
//DEL 	clearlist();
//DEL     alist();
//DEL 	isselected=-1;
//DEL }