coursescore.cpp

学生成绩管理系统

// coursescore.cpp : implementation file
//

#include "stdafx.h"
#include "mystudent.h"
#include "coursescore.h"

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

/////////////////////////////////////////////////////////////////////////////
// Ccoursescore dialog


Ccoursescore::Ccoursescore(CWnd* pParent /*=NULL*/)
	: CDialog(Ccoursescore::IDD, pParent)
{
	//{{AFX_DATA_INIT(Ccoursescore)
	m_stuno = _T("");
	m_cno = _T("");
	m_score = 0.0f;
	//}}AFX_DATA_INIT
}


void Ccoursescore::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Ccoursescore)
	DDX_Control(pDX, IDC_COMBO1, m_credit);
	DDX_Text(pDX, IDC_EDIT1, m_stuno);
	DDX_Text(pDX, IDC_EDIT2, m_cno);
	DDX_Text(pDX, IDC_EDIT3, m_score);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Ccoursescore message handlers

BOOL Ccoursescore::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_credit.AddString("0学分");
	m_credit.AddString("1学分");
	m_credit.AddString("2学分");
	m_credit.AddString("3学分");
	m_credit.AddString("4学分");
	m_credit.SetCurSel(0);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


void Ccoursescore::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	CDatabase m_database;//连接数据库
	Cscore score;
	Cstudentset student;
	Ccourse course;
	if(m_stuno.IsEmpty()||m_cno.IsEmpty())
	{
		MessageBox("请输入相应的数据!","提示");
		return;
	}
	CString sql,str_credit;
	sql.Format("select * from student where stuno='%s'",m_stuno);
	student.m_pDatabase=&m_database;
	student.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(student.IsEOF())
	{
		MessageBox("该学生不存在！","提示");
		return;
	}
	sql.Format("select * from course where cname='%s'",m_cno);
	course.m_pDatabase=&m_database;
	course.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(course.IsEOF())
	{
		MessageBox("该门课不存在！","提示");
		return;
	}
	sql.Format("select * from score where studentno='%s' and course='%s'",m_stuno,m_cno);
	score.m_pDatabase=&m_database;
	score.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(!score.IsEOF())//判断是否重复输入
	{
		MessageBox("不能重复输入!" ,"提示");
		return;
	}
	int index=m_credit.GetCurSel();
	m_credit.GetLBText(index,str_credit);
	sql.Format("insert into score values('%s','%s','%f','%s')",
		m_stuno,m_cno,m_score,str_credit);
	m_database.ExecuteSQL(sql);
	MessageBox("保存成功!","提示");
	CDialog::OnOK();
}