overdlg.cpp

学校图书馆信息化计划核心----图书管理系统vc版V2.0

// OverDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "OverDlg.h"
#include "BookLoanSet.h"
#include "ReadSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// COverDlg dialog

CReadSet  readerset0;
COverDlg::COverDlg(CWnd* pParent /*=NULL*/)
	: CDialog(COverDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(COverDlg)
	m_money = 0.0;
	//}}AFX_DATA_INIT
}


void COverDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(COverDlg)
	DDX_Text(pDX, IDC_MONEY, m_money);
	DDX_Control(pDX, IDC_MSFLEXGRID1, m_grid);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// COverDlg message handlers

BOOL COverDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	int overdaynum=0;
	m_grid.SetCols(5);
	m_grid.SetRows(6);
	m_grid.SetRow(0);
	m_grid.SetCol(0);
	m_grid.SetText("序号");
	m_grid.SetCol(1);
	m_grid.SetText("过期书名");
	m_grid.SetCol(2);
	m_grid.SetText("过期书目号");
    m_grid.SetCol(3);
	m_grid.SetText("应还日期");
	m_grid.SetCol(4);
	m_grid.SetText("过期天数");
    CBookLoanSet m_bookloanset;
	m_bookloanset.m_strFilter="ReaderId_loan='"+readerid+"'";
	m_bookloanset.Open();
	int overnumber=0;
	time_t now;
    now = time(0);
    struct tm *pnow;
    pnow = localtime(&now);	
	CString str;
	while(!m_bookloanset.IsEOF())
	{
		if(m_bookloanset.m_Backdate<now)
		{
			COleDateTime time1(pnow->tm_year+1900,pnow->tm_mon+1,pnow->tm_mday,pnow->tm_hour,pnow->tm_min,pnow->tm_sec);
			COleDateTime time2(m_bookloanset.m_Backdate.GetYear(),m_bookloanset.m_Backdate.GetMonth(),m_bookloanset.m_Backdate.GetDay(),m_bookloanset.m_Backdate.GetHour(),m_bookloanset.m_Backdate.GetMinute(),m_bookloanset.m_Backdate.GetSecond());
			COleDateTimeSpan diff;
			diff=time1-time2;
			int t=diff.GetTotalDays();
			overdaynum+=t;
			overnumber++;
			m_grid.SetRow(overnumber);
			m_grid.SetCol(0);
            str.Format("%d",overnumber);
			m_grid.SetText(str);
			m_grid.SetCol(1);
			m_grid.SetText(m_bookloanset.m_Bookname_loan);
			m_grid.SetCol(2);
			m_grid.SetText(m_bookloanset.m_Bookid_loan);
			m_grid.SetCol(3);
			str.Format(_T("%02d:%02d:%02d"),m_bookloanset.m_Backdate.GetYear(),m_bookloanset.m_Backdate.GetMonth(),m_bookloanset.m_Backdate.GetDay());
			m_grid.SetText(str);
			str.Format("%d",t);
			m_grid.SetCol(4);
			m_grid.SetText(str);
		}
		m_bookloanset.MoveNext();
         
	}
	m_bookloanset.Close();
	m_money=(double)overdaynum/10;
	UpdateData(false);
	if(type==2)
	{
    readerset0.m_strFilter="ReaderId='"+readerid+"'";
	readerset0.Open();
	readerset0.Edit();
	readerset0.m_Readerstatus=1;
	readerset0.Update();
	readerset0.Requery();
	readerset0.Close();
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}