researchpunishdlg.cpp

一个图书管理系统

// ResearchPunishDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ResearchPunishDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CResearchPunishDlg dialog


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


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


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

/////////////////////////////////////////////////////////////////////////////
// CResearchPunishDlg message handlers

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

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