finedlg.cpp

此源程序是图书馆管理系统

// FineDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "FineDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFineDlg dialog


CFineDlg::CFineDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CFineDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFineDlg)
	m_ReaderId = _T("");
	m_ReaderName = _T("");
	m_Count = 0;
	m_Days = 0;
	m_Date = 0;
	//}}AFX_DATA_INIT
}


void CFineDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFineDlg)
	DDX_Text(pDX, IDC_EDIT1, m_ReaderId);
	DDX_Text(pDX, IDC_EDIT2, m_ReaderName);
	DDX_Text(pDX, IDC_EDIT3, m_Count);
	DDX_Text(pDX, IDC_EDIT4, m_Days);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_Date);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFineDlg, CDialog)
	//{{AFX_MSG_MAP(CFineDlg)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFineDlg message handlers

void CFineDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
    CString sqlStr;
	sqlStr="SELECT * FROM FINE WHERE READER_ID='";
	sqlStr+=m_ReaderId;
	sqlStr+="'";
	MessageBox(sqlStr);
	if(!fnSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("fine表打开失败");
	}
	if(!fnSet.IsEOF())
	{
		m_Count=fnSet.m_AMOUNT;
		m_Days=fnSet.m_DAYS;
		m_Date=fnSet.m_FINE_DATE;
		fnSet.Delete();
		fnSet.Requery();
	}

	else
	{
		MessageBox("该用户没有欠款!");
	}
	fnSet.Close();

	sqlStr="SELECT * FROM READER WHERE READER_ID='";
	sqlStr+=m_ReaderId;
	sqlStr+="'";
	MessageBox(sqlStr);
	if(!rdSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("reader表打开失败!");
	}
	if(!rdSet.IsEOF())
	{
		m_ReaderName=rdSet.m_NAME;
		rdSet.Edit();
		rdSet.m_FLAG_BORROW="Y";
		rdSet.Update();
		rdSet.Requery();
		MessageBox("修改reader表成功");
	}
	rdSet.Close();
	UpdateData(false);
	MessageBox("罚款过程结束!");

}

void CFineDlg::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
    if(fnSet.IsOpen())
	{
		fnSet.Close();
	}
	if(rdSet.IsOpen())
	{
		rdSet.Close();
	}
	CDialog::OnClose();
}