kanum.cpp

基于access数据库的图书馆管理系统

// KANUM.cpp : implementation file
//

#include "stdafx.h"
#include "课程设计.h"
#include "KANUM.h"

#include "Reslut.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKANUM dialog


CKANUM::CKANUM(CWnd* pParent /*=NULL*/)
	: CDialog(CKANUM::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKANUM)
	m_kanum = _T("");
	//}}AFX_DATA_INIT
}


void CKANUM::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKANUM)
	DDX_Text(pDX, IDC_EDIT1, m_kanum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKANUM, CDialog)
	//{{AFX_MSG_MAP(CKANUM)
	ON_BN_CLICKED(IDC_BTN_OK, OnBtnOk)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKANUM message handlers

void CKANUM::OnBtnOk() 
{
	// TODO: Add your control notification handler code here
    CReslut * dlg;
	UpdateData();

	if(WSEEN_Check())
	{
		dlg = (CReslut *)GetParent(); 
		
		dlg->sql_update(m_kanum);
		dlg->DestroyWindow();
		DestroyWindow();
	}

	
}

BOOL CKANUM::WSEEN_Check()
{
    ADOConn m_adoc;
	m_adoc.OnInitDBConnect();
    CString kanum;
	kanum = "'"+m_kanum+"'";
	_bstr_t vSQL;
	vSQL = "select * from 借书卡表  where 卡号 = "+kanum;
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_adoc.GetRecordSet(vSQL);
	
	if (m_pRecordset->adoEOF < 0)
	{
		AfxMessageBox("卡号不存在！");
		m_adoc.ExitConnect();
		return 0;
	}
	else
	{
		CString booknum;      //记录借书数目
        booknum = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("借书数");
		int num;
		num = atoi(booknum);
		if(num > 5)
		{
			AfxMessageBox("对不起，你的书目数已超过5本！");
			m_adoc.ExitConnect();
			return 0;
		}
		
	}
   if(WSEEN_IFANYBOOK_OVERDUE())
	   return 0;
   m_adoc.ExitConnect();
   return 1;
}

BOOL CKANUM::WSEEN_IFANYBOOK_OVERDUE()
{
    ADOConn m_adoc;
	m_adoc.OnInitDBConnect();
    CString kanum;
	kanum = "'"+m_kanum+"'";
	_bstr_t vSQL;
	vSQL = "select * from 馆藏图书信息表  where 借书卡ID = "+kanum;
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_adoc.GetRecordSet(vSQL);
    for (m_pRecordset->MoveFirst();!m_pRecordset->adoEOF;m_pRecordset->MoveNext())
    {
		CString borrowtime;
		borrowtime = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("借出日期");
		
		if(WSEEN_OVERTIME(borrowtime))
		{
		 AfxMessageBox("对不起，你有书过期了！");
		 return 1;
		}
    }

	m_adoc.ExitConnect();
	return 0;
}

BOOL CKANUM::WSEEN_OVERTIME(CString borrowtime)
{
   int dates; 
   CTime tNow;
   COleDateTime cdt;
   cdt.ParseDateTime(borrowtime);
   SYSTEMTIME st;
   cdt.GetAsSystemTime(st);
   CTime ct(st);
  
   tNow = CTime::GetCurrentTime();
   
   dates = (tNow.GetYear()-ct.GetYear())*365+(tNow.GetMonth()-ct.GetMonth())*30+(tNow.GetDay()-ct.GetDay());
   
   if(dates <= 60)
   {
	  return 0;
   }
   else
   { 
	   return 1;
   }
  
   
}