readerattention.cpp

图书管理系统 带源码 文档

// ReaderAttention.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ReaderAttention.h"
#include "Book.h"

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

////////////////////////////////////////////////////////////////////////////
// CReaderAttention dialog


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


void CReaderAttention::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReaderAttention)
	DDX_Control(pDX, IDC_DATACOMBO1, m_datacombo);
	DDX_Control(pDX, IDC_ADODC2, m_adodc2);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CReaderAttention message handlers

BEGIN_EVENTSINK_MAP(CReaderAttention, CDialog)
    //{{AFX_EVENTSINK_MAP(CReaderAttention)
	ON_EVENT(CReaderAttention, IDC_DATACOMBO1, 1 /* Change */, OnChangeDatacombo1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CReaderAttention::OnChangeDatacombo1() 
{
	// TODO: Add your control notification handler code here
	
	CString vType;
	CString vSql;
	vType = m_datacombo.GetBoundText();
	if (vType!="")
	{
		vSql = "SELECT DISTINCT BName AS 书名, Type AS 类型, Author AS 作者,ComeInDate As 入库时间 FROM Book WHERE Type='"
			+ vType +"'";
		vSql = vSql + " And ComeInDate>'" + str + "'";
	}
	m_adodc2.SetRecordSource(vSql);
	m_adodc2.Refresh();
	//m_datagrid.SetRefDataSource(NULL);
}

BOOL CReaderAttention::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_datacombo.SetBoundText("社会科学");

	CTime t1,t2;
	t1=CTime::GetCurrentTime();
	CTimeSpan time(30,0,0,0);
	t2 = t1-time;
	str.Format("%d-%02d-%02d",t2.GetYear(),t2.GetMonth(), t2.GetDay());

	CString vSql;
	vSql = "SELECT DISTINCT BName AS 书名, Type AS 类型, Author AS 作者,ComeInDate As 入库时间 FROM Book WHERE Type='社会科学'";
	vSql = vSql + " And ComeInDate>'" + str + "'";
	m_adodc2.SetRecordSource(vSql);
	m_adodc2.Refresh();
	//m_datacombo.SetAppearance(10);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}