proppagetransmitreturndlg.cpp

用Visual c++.net开发的图书管理系统

// PropPageTransmitReturnDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "myBook.h"
#include "PropPageTransmitReturnDlg.h"


// CPropPageTransmitReturnDlg 对话框

IMPLEMENT_DYNAMIC(CPropPageTransmitReturnDlg, CPropertyPage)
CPropPageTransmitReturnDlg::CPropPageTransmitReturnDlg()
	: CPropertyPage(CPropPageTransmitReturnDlg::IDD)
	, m_strBookID(_T(""))
	, m_strReaderID(_T(""))
{
}

CPropPageTransmitReturnDlg::~CPropPageTransmitReturnDlg()
{
}

void CPropPageTransmitReturnDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_BOOK_ID, m_strBookID);
	DDX_Text(pDX, IDC_EDIT_READER_ID, m_strReaderID);
}


BEGIN_MESSAGE_MAP(CPropPageTransmitReturnDlg, CDialog)
	ON_BN_CLICKED(IDC_BUTTON_IN, OnBnClickedButtonIn)
	ON_BN_CLICKED(IDC_BUTTON_LOCK, OnBnClickedButtonLock)
	ON_BN_CLICKED(IDC_BUTTON_RETURN, OnBnClickedButtonReturn)
	ON_BN_CLICKED(IDC_BUTTON_EXIT, OnBnClickedButtonExit)
END_MESSAGE_MAP()


// CPropPageTransmitReturnDlg 消息处理程序

BOOL CPropPageTransmitReturnDlg::OnInitDialog()
{
	CPropertyPage::OnInitDialog();

	CWnd *pCtrl = NULL;
	CWnd *pParent = GetParent();
	ASSERT( pParent != NULL );
	const int CTRLIDARRAY[4] = {
		IDOK,
		IDCANCEL,
		ID_APPLY_NOW,
		IDHELP };
	for (int nIndex = 0; nIndex < sizeof(CTRLIDARRAY)/sizeof(CTRLIDARRAY[0]); ++nIndex)
	{
		pCtrl = pParent->GetDlgItem( CTRLIDARRAY[nIndex] );
		if ( pCtrl != NULL )
		{
			pCtrl->ShowWindow( SW_HIDE );
		}
	}

	return TRUE;
}

void CPropPageTransmitReturnDlg::OnBnClickedButtonIn()
{
	UpdateData( TRUE );

	CString strSQL;
	try
	{
		CDatabase db;
		db.OpenEx(_T("DSN=myLib;UID=sa;PWD='';"), CDatabase::noOdbcDialog);
		CRecordset rset( &db );
		strSQL.Format( _T("SELECT * FROM my_recorder where RecorderBookID='%s' AND RecorderReaderID='%s'"),
			m_strBookID,
			m_strReaderID
		);
		rset.Open(CRecordset::dynaset,strSQL);
		if( rset.GetRecordCount() <= 0 )
		{
			AfxMessageBox( _T("没有该记录") );
			return;
		}
		rset.Close();
		strSQL.Format( _T("DELETE FROM my_recorder where RecorderBookID='%s' AND RecorderReaderID='%s'"),
			m_strBookID,
			m_strReaderID
			);
		db.ExecuteSQL( strSQL );
		db.Close();
	}
	catch ( CDBException *e )
	{
		e->ReportError();
		e->Delete();
		return;
	}
	AfxMessageBox( _T("还书成功") );
}

void CPropPageTransmitReturnDlg::OnBnClickedButtonLock()
{
	// TODO: 在此添加控件通知处理程序代码
}

void CPropPageTransmitReturnDlg::OnBnClickedButtonReturn()
{
	CWnd *pParent = GetParent();
	ASSERT( pParent != NULL );
	static_cast<CPropertySheet*>(pParent)->PressButton( PSBTN_CANCEL );
}

void CPropPageTransmitReturnDlg::OnBnClickedButtonExit()
{
	CWnd *pParent = GetParent();
	ASSERT( pParent != NULL );
	CWnd *pParentParent = pParent->GetParent();
	static_cast<CPropertySheet*>(pParent)->PressButton( PSBTN_CANCEL );
	if (pParentParent != NULL)
	{
		pParentParent->PostMessage( WM_CLOSE, 0, 0L );
	}
}