researchreaderdlg.cpp

一个完整的MFC系统

// ResearchReaderDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ResearchReaderDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CResearchReaderDlg dialog


CResearchReaderDlg::CResearchReaderDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CResearchReaderDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CResearchReaderDlg)
	m_strproofID = _T("");
	//}}AFX_DATA_INIT
}


void CResearchReaderDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CResearchReaderDlg)
	DDX_Control(pDX, IDC_LIST_SHOW, m_ctrlist);
	DDX_Text(pDX, IDC_EDIT_PROOF_ID, m_strproofID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CResearchReaderDlg, CDialog)
	//{{AFX_MSG_MAP(CResearchReaderDlg)
	ON_BN_CLICKED(IDC_BUTTON_CHECK, OnButtonCheck)
	ON_BN_CLICKED(IDC_BUTTON_CHECK_ALL, OnButtonCheckAll)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CResearchReaderDlg message handlers

BOOL CResearchReaderDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
    //初始化列表里的各列名
	m_ctrlist.InsertColumn(0,"借阅证号");
    m_ctrlist.InsertColumn(1,"姓名");
	m_ctrlist.InsertColumn(2,"身份证号");
	m_ctrlist.InsertColumn(3,"借书数量");
	m_ctrlist.InsertColumn(4,"是否止借");
	m_ctrlist.SetColumnWidth(0,120);
	m_ctrlist.SetColumnWidth(1,120);
	m_ctrlist.SetColumnWidth(2,120);
	m_ctrlist.SetColumnWidth(3,120);
	m_ctrlist.SetColumnWidth(4,120);
	m_ctrlist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CResearchReaderDlg::RefreshData(CString str)
{
		//清空列表
	m_ctrlist.DeleteAllItems();
	m_ctrlist.SetRedraw(FALSE);
	UpdateData(TRUE);
	if(!m_readerset.Open(AFX_DB_USE_DEFAULT_TYPE,str))
	{
		MessageBox("数据库打开错误!","数据库错误",MB_OK);
		return;
	}
	int i=0;
	CString strcount;
	//在列表中显示图书信息
	while(!m_readerset.IsEOF())
	{
		m_ctrlist.InsertItem(i,m_readerset.m_Proof_ID);
		m_ctrlist.SetItemText(i,1,m_readerset.m_Name);
		m_ctrlist.SetItemText(i,2,m_readerset.m_ID_number);
		strcount.Format("%d",m_readerset.m_Borrow_Amount);
		m_ctrlist.SetItemText(i,3,strcount);
		m_ctrlist.SetItemText(i,4,m_readerset.m_Flag);
		i++;
		m_readerset.MoveNext();
	}
	m_readerset.Close();
	m_ctrlist.SetRedraw(TRUE);
}

void CResearchReaderDlg::OnButtonCheck() 
{
    UpdateData();
    CString strSQL;
    if(m_strproofID.IsEmpty())
	{
		MessageBox("数据库打开失败!","数据库错误",MB_OK);
		return;
	}
    else
	    strSQL.Format("select * from readerinfo where Proof_ID='%s'",m_strproofID);
    RefreshData(strSQL);	
}

void CResearchReaderDlg::OnButtonCheckAll() 
{
    CString strSQL;
	strSQL="select * from readerinfo";
	//更新列表显示
	RefreshData(strSQL);	
}