expiredlg.cpp

自己编写的迷你图书馆的完整程序.VC6MFC编写的,Windows界面.数据采用了Sqlserver2000.压缩包中已包括了数据库.先附加数据库再运行.

// ExpireDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "ExpireDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CExpireDlg dialog


CExpireDlg::CExpireDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CExpireDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CExpireDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CExpireDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CExpireDlg)
	DDX_Control(pDX, IDC_DATAGRID1, m_dg);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CExpireDlg, CDialog)
	//{{AFX_MSG_MAP(CExpireDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CExpireDlg message handlers

BOOL CExpireDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
CTime current=CTime::GetCurrentTime();

	CString sql;
	sql.Format("select 借阅记录表.起始日期 as 借出日期,"
		               "借阅记录表.bookID as 书籍编号,"
					   "书籍信息表.书名,"
					   "读者表.readerID as 读者编号,"
					   "读者表.姓名,"
					   "读者表.职务,"
					   "读者表.单位,"
					   "读者表.电话,"
					   "读者表.备注 "
		" from 借阅记录表,书籍信息表,书籍编号表,读者表 "
		" where 借阅记录表.bookID=书籍编号表.bookID "
		" and 借阅记录表.readerID=读者表.readerID "
		" and 书籍编号表.ISBN=书籍信息表.ISBN "
		" and dateadd(day,%d,起始日期)<getdate()"
		,expire);
	_RecordsetPtr m_pRecordset;
	m_pRecordset=g_adoDB.ExecuteQuery(sql);

	m_dg.SetRefDataSource(NULL);   
	m_dg.SetRefDataSource((LPUNKNOWN)m_pRecordset);   
	m_dg.Refresh(); 	
	
	return TRUE;  
}