dbstatdlg.cpp

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

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

#include "stdafx.h"
#include "myBook.h"
#include "DBStatDlg.h"
#include ".\dbstatdlg.h"


// CDBStatDlg 对话框

IMPLEMENT_DYNAMIC(CDBStatDlg, CDialog)
CDBStatDlg::CDBStatDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDBStatDlg::IDD, pParent)
	, m_strReaderCount(_T(""))
	, m_strBookCount(_T(""))
	, m_strAdminCount(_T(""))
	, m_strLendCount(_T(""))
{
}

CDBStatDlg::~CDBStatDlg()
{
}

void CDBStatDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_READER_COUNT, m_strReaderCount);
	DDX_Text(pDX, IDC_EDIT_BOOK_COUNT, m_strBookCount);
	DDX_Text(pDX, IDC_EDIT_ADMIN_COUNT, m_strAdminCount);
	DDX_Text(pDX, IDC_EDIT_LEND_COUNT, m_strLendCount);
}


BEGIN_MESSAGE_MAP(CDBStatDlg, CDialog)
END_MESSAGE_MAP()


// CDBStatDlg 消息处理程序

BOOL CDBStatDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	CString strSQL;
	strSQL = _T("SELECT count(my_book.BookID) FROM my_book UNION ALL SELECT count(my_reader.ReaderID) FROM my_reader UNION ALL SELECT count(my_Administer.Account) FROM my_Administer UNION ALL SELECT count(my_recorder.RecorderBookID) FROM my_recorder");
	try
	{
		CDatabase db;
		db.OpenEx(_T("DSN=myLib;UID=sa;PWD='';"), CDatabase::noOdbcDialog);
		CRecordset rset(&db);
		rset.Open(CRecordset::dynaset,strSQL);
		if ( ! rset.IsEOF() )
		{
			rset.GetFieldValue((short)0, m_strBookCount);
			rset.MoveNext();
		}
		if ( ! rset.IsEOF() )
		{
			rset.GetFieldValue((short)0, m_strReaderCount);
			rset.MoveNext();
		}
		if ( ! rset.IsEOF() )
		{
			rset.GetFieldValue((short)0, m_strAdminCount);
			rset.MoveNext();
		}
		if ( ! rset.IsEOF() )
		{
			rset.GetFieldValue((short)0, m_strLendCount);
		}
		rset.Close();
		db.Close();
	}
	catch ( CDBException *e )
	{
		e->ReportError();
		e->Delete();
	}
	UpdateData( FALSE );
	return TRUE;
}