myrecord.cpp

这是一个学生管理系统 包含学生基本信息 选课信息 宿舍信息 教师信息 课程信息 班机信息 教师信息等录入 查询 修改删除等强大功能

// MyRecord.cpp : implementation file
//

#include "stdafx.h"
#include "Student.h"
#include "MyRecord.h"

#include <CTime>

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

/////////////////////////////////////////////////////////////////////////////
// CMyRecord

IMPLEMENT_DYNAMIC(CMyRecord, CRecordset)

CMyRecord::CMyRecord(CDatabase* pdb)
: CRecordset(pdb)
{
	m_nDefaultType = snapshot;
}


/////////////////////////////////////////////////////////////////////////////
// CMyRecord diagnostics

#ifdef _DEBUG
void CMyRecord::AssertValid() const
{
	CRecordset::AssertValid();
}

void CMyRecord::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG

BOOL CMyRecord::OpenTable(CString tSQL, CString tTableName)
{
	CString strText;
	BOOL Success;
	
	try
	{
		Success=Open(AFX_DB_USE_DEFAULT_TYPE,tSQL);
	}
	catch(CDBException *)
	{
		strText.Format("访问%s信息出错！",tTableName);
		::AfxMessageBox(strText,MB_OK,NULL);
		Success=FALSE;
	}
	catch(CMemoryException *)
	{
		::AfxMessageBox("内存出错！",MB_OK,NULL);
		Success=FALSE;
	}
	return Success;
}

BOOL CMyRecord::IsDate(int y,int m,int d,int z)
{
	if(z == 1)
	{
		if(m == 1 || m == 3 || m == 5 || m == 7 || m == 8 || m == 10)
		{
			if(d<25)   d+=7;
			else {m++;   d=(d+7)%31;}
		}
		else if(m == 12)
		{
			if(d<25)   d+=7;
			else {y++;   m=1;   d=(d+7)%31;}
		}
		else if(m == 4 || m == 6 || m == 9 || m == 11)
		{
			if(d<24)   d+=7;
			else {m++;   d=(d+7)%30;}
		}
		else if(m == 2)
		{
			if(d<22)   d+=7;
			else if((y%4 == 0 && y%100 != 0) || y%400 == 0)
			{
				if(d == 22)   d=29;
				else {m=3;  d=(d+7)%29;}
			}
			else {m=3;  d=(d+7)%28;}
		}
	}
	if(z == 2)
	{
		if(m == 1 || m == 3 || m == 5 || m == 7 || m == 8 || m == 10)
		{
			if(d<18)   d+=14;
			else {m++;   d=(d+14)%31;}
		}
		else if(m == 12)
		{
			if(d<18)   d+=14;
			else {y++;   m=1;   d=(d+14)%31;}
		}
		else if(m == 4 || m == 6 || m == 9 || m == 11)
		{
			if(d<17)   d+=14;
			else {m++;   d=(d+14)%30;}
		}
		else if(m == 2)
		{
			if(d<15)   d+=14;
			else if((y%4 == 0 && y%100 != 0) || y%400 == 0)
			{
				if(d == 15)   d=29;
				else {m=3;  d=(d+14)%29;}
			}
			else {m=3;  d=(d+14)%28;}
		}
	}
	CTime time;
	int year=time.GetYear();
	int month=time.GetMonth();
	int day=time.GetDay();
	if((year < y) || (year == y && month < m) || (year == y && month == m && day<=d))
		return true;
	return false;
}