bookenteronedlg.cpp

学生管理系统 学生管理系统

// BookEnterOneDlg.cpp : implementation file
//

#include "stdafx.h"
#include "学生成绩管理系统.h"
//以下头文件是手工添加的
#include "ScoresRS1.h"
#include "StudentRS.h"
#include "Public.h"
//以上头文件是手工添加的
#include "BookEnterOneDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookEnterOneDlg dialog

CBookEnterOneDlg::CBookEnterOneDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBookEnterOneDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBookEnterOneDlg)
	m_ScoreEnterID = _T("");
	m_ScoreEnterScore = 0;
	m_ScoreEnterSubject = _T("");
	m_strScoreEnterCategory = _T("");
	//}}AFX_DATA_INIT
}


void CBookEnterOneDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBookEnterOneDlg)
	DDX_Text(pDX, IDC_SCORE_ENTER_ID, m_ScoreEnterID);
	DDX_Text(pDX, IDC_SCORE_ENTER_SCORE, m_ScoreEnterScore);
	DDX_Text(pDX, IDC_SCORE_ENTER_SUBJECT, m_ScoreEnterSubject);
	DDX_CBString(pDX, IDC_SCORE_ENTER_CATEGORY, m_strScoreEnterCategory);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CBookEnterOneDlg message handlers
void CBookEnterOneDlg::OnOK() 
{
	// TODO: Add extra validation here
	try{
		UpdateData();
		CString message("学号为");
		int error=0;

		if(!(m_ScoreEnterID!=""&&m_ScoreEnterSubject!=""&&m_strScoreEnterCategory!=""))
			throw error;
		if (!m_scoresSet.IsOpen())
		{
			m_scoresSet.Open();
		}
			
		bool check_id;
		check_id=checkID(m_ScoreEnterID);
		if(check_id==true){
			message+=m_ScoreEnterID;
			message+="的同学的";
			message+=m_ScoreEnterSubject;
			message+="成绩 成功录入。";
			//开始增加记录
			m_scoresSet.AddNew();
			m_scoresSet.m_ID=m_ScoreEnterID;
			m_scoresSet.m_score=m_ScoreEnterScore;
			m_scoresSet.m_subject=m_ScoreEnterSubject;
			TransCategory(m_strScoreEnterCategory);//转换学生的种类
			m_scoresSet.m_category=CPublic::TranslatedCategory;
			double temp;
			temp=creditFunc(m_scoresSet.m_score);
			CString s;
			s.Format("%.1lf",temp);
			m_scoresSet.m_credit=s;
			m_scoresSet.Update();
			m_scoresSet.Requery();
			AfxMessageBox(message);
			CDialog::OnOK();
		}
		else if(check_id==false)
		  AfxMessageBox("此学号不存在!");
	}
	catch(int)
	{
		AfxMessageBox("请输入完整的数据!");
	}
	catch(...)
	{
		AfxMessageBox("这条记录已经添加!");
	}
}


double CBookEnterOneDlg::creditFunc(const long &score)
{
	if (score>=95)
	{
		CPublic::credit=5.0;
	} 
	else if (score>=45&&score<95)
	{
		CPublic::credit=(score-45)*0.1;
	}
	else
		CPublic::credit=0.0;

	return CPublic::credit;
}

bool CBookEnterOneDlg::checkID(const CString &id)//判断录入成绩的对象的ID在数据库中是否存在
{
	if (!m_studentSet.IsOpen())
	{
		m_studentSet.Open();
	}
	//指定查询条件
	m_studentSet.m_strFilter.Format("ID='%s'",id);
	m_studentSet.Requery();
	if (m_studentSet.IsEOF())
	{
		return false;
	}
	else
	   return true;
}

void CBookEnterOneDlg::TransCategory(const CString &category)
{
	if(category=="本科生")
		CPublic::TranslatedCategory="BenKeSheng";
	else if(category=="硕士生")
		CPublic::TranslatedCategory="ShuoShiSheng";
	else if(category=="博士生")
		CPublic::TranslatedCategory="BoShiSheng";
}