countclassavgdlg.cpp

课程设计的简单Access学生数据库系统

// CountClassAvgDlg.cpp : implementation file
//

#include "stdafx.h"
#include "sm.h"
#include "CountClassAvgDlg.h"
#include "ClassAvgScoreList.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCountClassAvgDlg dialog


//##ModelId=40A481F602FD
CCountClassAvgDlg::CCountClassAvgDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCountClassAvgDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCountClassAvgDlg)
	m_AvgSubject = _T("");
	//}}AFX_DATA_INIT
}


//##ModelId=40A481F6033D
void CCountClassAvgDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCountClassAvgDlg)
	DDX_Control(pDX, IDC_SUBJECT_COMBO, m_Subject);
	DDX_Control(pDX, IDC_LIST2, m_List);
	DDX_Control(pDX, IDC_DTPICKER1, m_Begin);
	DDX_Control(pDX, IDC_DTPICKER2, m_End);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCountClassAvgDlg, CDialog)
	//{{AFX_MSG_MAP(CCountClassAvgDlg)
	ON_BN_CLICKED(ID_COUNT, OnCount)
	ON_WM_DESTROY()
	ON_WM_CANCELMODE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCountClassAvgDlg message handlers

//##ModelId=40A481F6034D
void CCountClassAvgDlg::OnCount() 
{
	COleDateTime bt(m_Begin.GetYear().intVal, m_Begin.GetMonth().intVal, m_Begin.GetDay().intVal, 0, 0, 0);
	COleDateTime et(m_End.GetYear().intVal, m_End.GetMonth().intVal, m_End.GetDay().intVal, 23, 59, 59);
	pList->Load(bt.Format("%Y-%m-%d %H:%M:%S"), et.Format("%Y-%m-%d %H:%M:%S"), m_Subject.GetItemData(m_Subject.GetCurSel()) );
	
}

//##ModelId=40A481F6035C
void CCountClassAvgDlg::OnAvgSubjectButton() 
{
	// TODO: Add your control notification handler code here
	
}

//##ModelId=40A481F6035E
BOOL CCountClassAvgDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	LoadSubject();

	pList = new ClassAvgScoreList(&m_List);
	pList->Init();

	CTime t = CTime::GetCurrentTime();
	CTimeSpan cts(60, 0, 0, 0);
	m_End.SetYear(COleVariant((short)t.GetYear()));
	m_End.SetMonth(COleVariant((short)t.GetMonth()));
	m_End.SetDay(COleVariant((short)t.GetDay()));
	t -= cts;
	m_Begin.SetYear(COleVariant((short)t.GetYear()));
	m_Begin.SetMonth(COleVariant((short)t.GetMonth()));
	m_Begin.SetDay(COleVariant((short)t.GetDay()));
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

//##ModelId=40A481F6036C
void CCountClassAvgDlg::OnDestroy() 
{
	CDialog::OnDestroy();
	delete pList;
	
	// TODO: Add your message handler code here
	
}

//##ModelId=40A481F6036E
void CCountClassAvgDlg::OnCancelMode() 
{
	CDialog::OnCancelMode();
	
	// TODO: Add your message handler code here
	
}

//##ModelId=40A481F602EF
void CCountClassAvgDlg::LoadSubject()
{
	m_Subject.AddString("全部科目");
	m_Subject.SetItemData(0, 0);
	CDaoTableDef TD(&theDatabase);
	TD.Open("subject");
	CDaoRecordset RS;
	RS.Open(&TD);
	int i=1;
	while(!RS.IsEOF())
	{
		m_Subject.AddString(V_BSTRT(&RS.GetFieldValue("subject")));
		m_Subject.SetItemData(i++, RS.GetFieldValue("id").lVal);
		RS.MoveNext();
	}
	RS.Close();
	TD.Close();
	m_Subject.AddString("总平均成绩");
	m_Subject.SetItemData(i, -2);
	m_Subject.SetCurSel(0);
}