stuallscore.cpp

学生成绩管理系统

// stuallscore.cpp : implementation file
//

#include "stdafx.h"
#include "mystudent.h"
#include "stuallscore.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cstuallscore dialog


Cstuallscore::Cstuallscore(CWnd* pParent /*=NULL*/)
	: CDialog(Cstuallscore::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cstuallscore)
	m_stuname = _T("");
	m_stuno = _T("");
	//}}AFX_DATA_INIT
}


void Cstuallscore::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cstuallscore)
	DDX_Control(pDX, IDC_LIST2, m_list2);
	DDX_Text(pDX, IDC_EDIT1, m_stuname);
	DDX_Text(pDX, IDC_EDIT2, m_stuno);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cstuallscore, CDialog)
	//{{AFX_MSG_MAP(Cstuallscore)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cstuallscore message handlers

//DEL void Cstuallscore::OnClickList2(NMHDR* pNMHDR, LRESULT* pResult) 
//DEL {
//DEL 	// TODO: Add your control notification handler code here
//DEL 	
//DEL 	*pResult = 0;
//DEL }

void Cstuallscore::OnOK() 
{
	// TODO: Add extra validation here
	for(int j=0;j<m_list2.GetItemCount();)
		m_list2.DeleteItem(j);
	UpdateData(true);
	CDatabase m_database;
	Cstudentset student;
	Cscore score;
	Ccourse course;
	if(student.IsOpen())
		student.Close();
	CString sql,str;

	sql.Format("select * from student where stuno='%s' or stuname='%s'",m_stuno,m_stuname);
	student.m_pDatabase=&m_database;
	student.Open(AFX_DB_USE_DEFAULT_TYPE,sql);

	if(student.IsEOF())
	{
		MessageBox("该学生不存在","提示");
		return;
	}
	else
	{
		sql.Format("select * from score where studentno='%s'",student.m_stuno);
		score.m_pDatabase=&m_database;
		score.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
		if(score.IsEOF())
		{
			MessageBox("该学生存在！但暂时没有记录！","提示");
			return;
		}
		else
		{
			
			for(int i=0;i<score.GetRecordCount();i++)
			{
				if(course.IsOpen())
				course.Close();
				sql.Format("select * from course where cname='%s'",score.m_course);
				course.m_pDatabase=&m_database;
				course.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
				int pos=m_list2.InsertItem(i,course.m_cno);
			//	m_list2.SetItemText(pos,1,course.m_cname);
				m_list2.SetItemText(pos,1,score.m_course);
				str.Format("%f",score.m_score);
				m_list2.SetItemText(pos,2,str);
				m_list2.SetItemText(pos,3,score.m_credit);
				score.MoveNext();
			
			}
		}

	}
	

	
//	CDialog::OnOK();
}

BOOL Cstuallscore::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_list2.InsertColumn(0,"课程名");m_list2.SetColumnWidth(0,140);
	m_list2.InsertColumn(1,"课程号");m_list2.SetColumnWidth(1,140);
	m_list2.InsertColumn(2,"成绩");m_list2.SetColumnWidth(2,140);
	m_list2.InsertColumn(3,"学分");m_list2.SetColumnWidth(3,140);
	m_list2.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}