scoretotaldlg.cpp

高校管理系统--包括了成绩管理,学籍管理,教师信息管理等多个模块

// ScoreTotalDlg.cpp : implementation file
//

#include "stdafx.h"
#include "school.h"
#include "ScoreTotalDlg.h"
#include "classset.h"
#include "examtimeset.h"
#include "examtypeset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CScoreTotalDlg dialog


CScoreTotalDlg::CScoreTotalDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CScoreTotalDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CScoreTotalDlg)
	m_strClass = _T("");
	m_strTime = _T("");
	m_strType = _T("");
	//}}AFX_DATA_INIT
}


void CScoreTotalDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CScoreTotalDlg)
	DDX_Control(pDX, IDC_LIST2, m_ctrList);
	DDX_Control(pDX, IDC_COMBO_TYPE, m_ctrType);
	DDX_Control(pDX, IDC_COMBO_TIME, m_ctrTime);
	DDX_Control(pDX, IDC_COMBO_CLASS, m_ctrClass);
	DDX_CBString(pDX, IDC_COMBO_CLASS, m_strClass);
	DDX_CBString(pDX, IDC_COMBO_TIME, m_strTime);
	DDX_CBString(pDX, IDC_COMBO_TYPE, m_strType);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CScoreTotalDlg, CDialog)
	//{{AFX_MSG_MAP(CScoreTotalDlg)
	ON_BN_CLICKED(IDC_BUTTON_STAT, OnButtonStat)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CScoreTotalDlg message handlers

BOOL CScoreTotalDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	CString strSQL;
	//初始化班级
	CClassSet ClassSet ;
	strSQL="select * from class";
	if(!ClassSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		AfxMessageBox("打开数据库失败!");
	}	
	while(!ClassSet.IsEOF())
	{
		m_ctrClass.AddString(ClassSet.m_code);
		ClassSet.MoveNext();
	}
	ClassSet.Close();
	//初始化时间段
	CExamtimeSet TimeSet ;
	strSQL="select * from examtime";
	if(!TimeSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		AfxMessageBox("打开数据库失败!");
	}	
	while(!TimeSet.IsEOF())
	{
		m_ctrTime.AddString(TimeSet.m_time);
		TimeSet.MoveNext();
	}
	TimeSet.Close();
	//初始化考试类型
	CExamtypeSet TypeSet ;
	strSQL="select * from examtype";
	if(!TypeSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		AfxMessageBox("打开数据库失败!");
	}	
	while(!TypeSet.IsEOF())
	{
		m_ctrType.AddString(TypeSet.m_name);
		TypeSet.MoveNext();
	}
	TypeSet.Close();

	//初始化成绩列表
	m_ctrList.InsertColumn(0,"学号");
	m_ctrList.InsertColumn(1,"姓名");
	m_ctrList.InsertColumn(2,"班级");
	m_ctrList.InsertColumn(3,"总成绩");
	m_ctrList.InsertColumn(4,"平均分");
	m_ctrList.InsertColumn(5,"名次");

	m_ctrList.SetColumnWidth(0,80);
	m_ctrList.SetColumnWidth(1,80);
	m_ctrList.SetColumnWidth(2,80);
	m_ctrList.SetColumnWidth(3,80);
	m_ctrList.SetColumnWidth(4,80);
	m_ctrList.SetColumnWidth(5,80);


	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CScoreTotalDlg::OnButtonStat() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_strClass.IsEmpty())
	{
		AfxMessageBox("请选择班级");
		return;
	}
	if(m_strTime.IsEmpty())
	{
		AfxMessageBox("请选择考试时间段");
		return;
	}
	if(m_strType.IsEmpty())
	{
		AfxMessageBox("请选择考试类型");
		return;
	}

	m_ctrList.DeleteAllItems();
	m_ctrList.SetRedraw(FALSE);

	CString strSQL;
	CString strValue="0";
	CString strTemp;
	CDatabase db;
	db.Open(_T("school"));
	CRecordset rs1(&db);
	CRecordset rs2(&db);
	strSQL.Format("select code, \
		avg(score) as average,\
		sum(score) as total from score \
		where class = '%s' and time = '%s' \
		and type = '%s' group by code order by sum(score) desc"
		,m_strClass,m_strTime,m_strType);
	
	if(!rs1.Open(CRecordset::forwardOnly,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}
	int i=0;
	rs1.m_strSort = "total";
	char buffer[20];
	while(!rs1.IsEOF())
	{
		//学号
		rs1.GetFieldValue("code",strValue);
		m_ctrList.InsertItem(i,strValue);
		//姓名
		strTemp.Format("select name from student where code = '%s'",strValue);
		if(!rs2.Open(CRecordset::forwardOnly,strTemp))
		{
			MessageBox("打开数据库失败!","数据库错误",MB_OK);
			rs1.Close();
			return ;
		}
		rs2.GetFieldValue("name",strValue);
		rs2.Close();
		m_ctrList.SetItemText(i,1,strValue);
		//班级
		m_ctrList.SetItemText(i,2,m_strClass);
		//总成绩
		rs1.GetFieldValue("total",strValue);
		m_ctrList.SetItemText(i,3,strValue);
		//平均成绩
		rs1.GetFieldValue("average",strValue);
		m_ctrList.SetItemText(i,4,strValue);
		//名次
		itoa(i+1,buffer,10);
		m_ctrList.SetItemText(i,5,buffer);

		i++;
		rs1.MoveNext();
	}
	rs1.Close();	
	m_ctrList.SetRedraw(TRUE);	
}