overinfo.cpp

本源码为图书管理系统

// overinfo.cpp : implementation file
//

#include "stdafx.h"
#include "TSG.h"
#include "overinfo.h"
#include "overtime.h"
#include "borrowadd.h"
#include "borrowinfo.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// overinfo dialog


overinfo::overinfo(CWnd* pParent /*=NULL*/)
	: CDialog(overinfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(overinfo)
	m_year = 0;
	m_month = 0;
	m_day = 0;
	//}}AFX_DATA_INIT
}


void overinfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(overinfo)
	DDX_Control(pDX, IDC_LIST1, m_book3);
	DDX_Text(pDX, IDC_EDIT1, m_year);
	DDX_Text(pDX, IDC_EDIT2, m_month);
	DDX_Text(pDX, IDC_EDIT3, m_day);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(overinfo, CDialog)
	//{{AFX_MSG_MAP(overinfo)
	ON_BN_CLICKED(IDC_FIND, OnFind)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// overinfo message handlers

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


	// TODO: Add extra initialization here
	
	m_book3.InsertColumn(0,"学号");
	m_book3.InsertColumn(1,"书号");
    m_book3.InsertColumn(2,"超期天数");
   
	RECT rectbasic;
	m_book3.GetWindowRect(&rectbasic);
	int widbasic = rectbasic.right - rectbasic.left;
	m_book3.SetColumnWidth(0,widbasic/3);
	m_book3.SetColumnWidth(1,widbasic/3);
	m_book3.SetColumnWidth(2,widbasic/3);
	m_book3.SetExtendedStyle(LVS_EX_FULLROWSELECT);

	p_query.Format("select*from overinfo");
	RefreshData();
	return true;

}

void overinfo::RefreshData()
{
	if(!m_database.IsOpen()){
		m_database.Open(_T("TSG"));
	}
	m_book3.DeleteAllItems();
	overtime m_basicset(&m_database);
	CString strSQL;
	strSQL.Format("select * from overinfo");
	m_basicset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	CDBVariant varValue;
	if(m_basicset.GetRecordCount()!=0) m_basicset.MoveFirst();
	char buf[20];
	int i=0;
	while(!m_basicset.IsEOF())
	{
		int temp=0;
		m_basicset.GetFieldValue(temp,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_book3.InsertItem(i,buf);
		temp++;
		m_basicset.GetFieldValue(temp,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_book3.SetItemText(i,1,buf);
		temp++;
		m_basicset.GetFieldValue(temp,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_book3.SetItemText(i,2,buf);
		m_basicset.MoveNext();
		i++;
	}
	
	
}

void overinfo::OnFind() 
{ 
    borrowadd bb;
	int n,y,r,xxx,yyy,zzz;
    struct tm *newtime ;
	time_t long_time;
	time(&long_time);
	newtime=localtime(&long_time);
    xxx=newtime->tm_year-100;
    yyy=newtime->tm_mon+1;
	zzz=newtime->tm_mday;

	if(!m_database.IsOpen()){
		m_database.Open(_T("TSG"));
	}
	
	borrowinfo m_basicset(&m_database);
	CString strSQL;
	strSQL.Format("select * from borrowinfo");
	m_basicset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	CDBVariant varValue;
	if(m_basicset.GetRecordCount()!=0) m_basicset.MoveFirst();
	int i=0;
    CString strSQL2;
	strSQL2.Format("delete * from overinfo");
    m_database.ExecuteSQL(strSQL2);
	while(!m_basicset.IsEOF())
	{   UpdateData();
		CString strSQL1;
        
		m_basicset.GetFieldValue(4,varValue);
		n=varValue.m_pdate->year;
		y=varValue.m_pdate->month;
		r=varValue.m_pdate->day;
        int aa=bb.overtime(m_year,m_month,m_day,n,y,r);
		if(aa>0)
		{   
			m_basicset.GetFieldValue(1,varValue);
            int cc=varValue.m_lVal;
            m_basicset.GetFieldValue(2,varValue);
            int dd=varValue.m_lVal;
            strSQL1.Format("insert into overinfo values(%d,%d,%d)",cc,dd,aa);
			m_database.ExecuteSQL(strSQL1);
		}
        m_basicset.MoveNext();
		i++;

	}
	RefreshData();
	
}