adminreturndlg.cpp

同学编写的图书馆管理系统（数据库原理大作业）

// AdminReturnDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LIBRARY.h"
#include "AdminReturnDlg.h"
#include "BorrowRS.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAdminReturnDlg dialog


CAdminReturnDlg::CAdminReturnDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAdminReturnDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAdminReturnDlg)
	m_strKey = _T("");
	m_strOrder = _T("");
	m_strTime1 = COleDateTime::GetCurrentTime();
	m_strTime2 = COleDateTime::GetCurrentTime();
	m_strOldTime = 0;
	m_strNewTime = 0;
	m_OldTime = 0;
	m_NewTime = 0;
	//}}AFX_DATA_INIT
}


void CAdminReturnDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAdminReturnDlg)
	DDX_Control(pDX, IDC_LIST_RESULT, m_listResult);
	DDX_Control(pDX, IDC_LIST_DETAIL, m_listDetail);
	DDX_CBString(pDX, IDC_SELKEY, m_strKey);
	DDX_CBString(pDX, IDC_SELORDER, m_strOrder);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_OldTime);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER2, m_NewTime);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAdminReturnDlg, CDialog)
	//{{AFX_MSG_MAP(CAdminReturnDlg)
	ON_LBN_SELCHANGE(IDC_LIST_RESULT, OnSelchangeListResult)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAdminReturnDlg message handlers


void CAdminReturnDlg::OnOK() 
{
	// TODO: Add extra validation here
	CString kw,odby;
	UpdateData();
	m_listResult.ResetContent();
	if (! m_borrowSet.IsOpen())
		m_borrowSet.Open();
	
	if (m_strKey=="借书证号") kw="cno";
	else if (m_strKey=="书号") kw="bno";
	else kw="borrow_date";
	if (m_strOrder=="降序") odby="desc";
	else odby="asc";
	CTime mytime=CTime::GetCurrentTime();
	CTimeSpan span(45,0,0,0);
	mytime=mytime-span;
	CString strTime=mytime.Format("%Y-%m-%d %H:%M:%S"); 
	CString strTime2=m_OldTime.Format("%Y-%m-%d %H:%M:%S"); 
	CString strTime3=m_NewTime.Format("%Y-%m-%d %H:%M:%S"); 
//	AfxMessageBox(strTime2+" "+strTime3);

//	AfxMessageBox(strTime);
	m_borrowSet.m_strFilter.Format("borrow_date < '%s' and return_date is null and borrow_date >= '%s' and borrow_date <= '%s'",strTime,strTime2,strTime3);
//	m_borrowSet.m_strFilter.Format("return_date is null");
	m_borrowSet.m_strSort=kw+" "+odby;
	m_borrowSet.Requery();
	
	if (m_borrowSet.IsEOF())
	{
		AfxMessageBox("该时间段内出借的所有图书都已经在到期之前归还。");
		return;
	}
	
	while(! m_borrowSet.IsEOF())
	{
		CString strTime=m_borrowSet.m_borrow_date.Format("%Y-%m-%d %H:%M:%S"); 
		CString str="借书时间:  "+strTime+"         书号:  "+m_borrowSet.m_bno + "         借书证号:  "+m_borrowSet.m_cno;
		m_listResult.AddString(str);
		m_borrowSet.MoveNext();
	}
	
//	CDialog::OnOK();
}

void CAdminReturnDlg::OnSelchangeListResult() 
{
	// TODO: Add your control notification handler code here
	CString Title[9];
	Title[0]="图书编号：        ";
	Title[1]="类别：              ";
	Title[2]="书名：              ";
	Title[3]="出版社：           ";
	Title[4]="出版年份：        ";
	Title[5]="作者：              ";
	Title[6]="价格：              ";
	Title[7]="总藏书量：        ";
	Title[8]="现藏数量：        ";
	m_listDetail.ResetContent();
	int curSel;
	CString strDetail;
	CString strline;
	curSel=m_listResult.GetCurSel();
	m_borrowSet.SetAbsolutePosition(curSel+1);
	for (unsigned int i=0;i<m_bookSet.m_nFields;i++)
	{
		CString bookNumm=m_borrowSet.m_bno;
		if (!m_bookSet.IsOpen())
			m_bookSet.Open();
		bookNumm=m_borrowSet.m_bno;
		m_bookSet.m_strFilter.Format("bno= '%s'",bookNumm);
		m_bookSet.Requery();
		m_bookSet.GetFieldValue(i,strDetail);
		strline.Empty();
		strline+=Title[i];
		strline+=strDetail;
		m_listDetail.AddString(strline);
	}	
}