researchborroweddlg.cpp

一个完整的MFC系统

// ResearchBorrowedDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ResearchBorrowedDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CResearchBorrowedDlg dialog


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


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


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

/////////////////////////////////////////////////////////////////////////////
// CResearchBorrowedDlg message handlers

BOOL CResearchBorrowedDlg::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,80);
	m_ctrlist.SetColumnWidth(1,120);
	m_ctrlist.SetColumnWidth(2,80);
	m_ctrlist.SetColumnWidth(3,80);
	m_ctrlist.SetColumnWidth(4,80);
	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 CResearchBorrowedDlg::OnButtonCheck() 
{
    UpdateData();
    CString strSQL;
    if(m_strproofID.IsEmpty())
	    strSQL="select * from borrowinfo";
    else
	    strSQL.Format("select * from borrowinfo where Proof_ID='%s'",m_strproofID);
	RefreshData(strSQL);
}
void CResearchBorrowedDlg::RefreshData(CString str)
{
	//清空列表
	m_ctrlist.DeleteAllItems();
	m_ctrlist.SetRedraw(FALSE);
	UpdateData(TRUE);
	if(!m_borrowset.Open(AFX_DB_USE_DEFAULT_TYPE,str))
	{
		MessageBox("数据库打开错误!","数据库错误",MB_OK);
		return;
	}
	int i=0;
	CString strTime,strSQL1;
	//在列表中显示图书信息
	while(!m_borrowset.IsEOF())
	{
		m_ctrlist.InsertItem(i,m_borrowset.m_Book_ID);
		strSQL1.Format("select * from bookinfo where Book_ID='%s'",m_borrowset.m_Book_ID);
	    if(!m_bookset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL1))
		{
		    MessageBox("数据库打开错误!","数据库错误",MB_OK);
		    return;
		}
		m_ctrlist.SetItemText(i,1,m_bookset.m_Book_Name);
		m_bookset.Close();
		strTime.Format("%d-%d-%d",m_borrowset.m_BorrowOut_Date.GetYear(),m_borrowset.m_BorrowOut_Date.GetMonth(),m_borrowset.m_BorrowOut_Date.GetDay());
		m_ctrlist.SetItemText(i,2,strTime);
		strTime.Format("%d-%d-%d",m_borrowset.m_Return_Date.GetYear(),m_borrowset.m_Return_Date.GetMonth(),m_borrowset.m_Return_Date.GetDay());
		m_ctrlist.SetItemText(i,3,strTime);
		m_ctrlist.SetItemText(i,4,m_borrowset.m_User_Name);
		i++;
		m_borrowset.MoveNext();
	}
	m_borrowset.Close();
	m_ctrlist.SetRedraw(TRUE);
}

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