editscoredlg.cpp

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

// EditScoreDlg.cpp : implementation file
//

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

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

double newcredit;
/////////////////////////////////////////////////////////////////////////////
// CEditScoreDlg dialog


CEditScoreDlg::CEditScoreDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CEditScoreDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEditScoreDlg)
	m_strEditScoreID = _T("");
	m_editScoreNewScore = 0;
	m_strEditScoreSubject = _T("");
	//}}AFX_DATA_INIT
}


void CEditScoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEditScoreDlg)
	DDX_Text(pDX, IDC_EDIT_SCORE_ID, m_strEditScoreID);
	DDX_Text(pDX, IDC_EDIT_SCORE_NEWSCORE, m_editScoreNewScore);
	DDX_Text(pDX, IDC_EDIT_SCORE_SUBJECT, m_strEditScoreSubject);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CEditScoreDlg message handlers

void CEditScoreDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	int error=0;
	CString message("找不到");
	try{
		if (m_strEditScoreID==""||m_strEditScoreSubject=="")
		{
			throw error;
		}

		CBookEnterOneDlg transCredit;
		if (!m_scoresSet.IsOpen()){
			m_scoresSet.Open();
		}
		//指定查询学号和科目的条件
		m_scoresSet.m_strFilter.Format("ID='%s' and subject='%s'",m_strEditScoreID,m_strEditScoreSubject);
		m_scoresSet.Requery();
		if (m_scoresSet.IsEOF()){
			message+=m_strEditScoreID;
			message+="的";
			message+=m_strEditScoreSubject;
			message+="的记录";
			AfxMessageBox(message);

		}
		else if(!m_scoresSet.IsEOF()){
			//开始修改记录
			m_scoresSet.Edit();
			m_scoresSet.m_score=m_editScoreNewScore;
			double temp;
			temp=transCredit.creditFunc(m_editScoreNewScore);
			//temp=transToCredit(m_editScoreNewScore);
			CString s;
			s.Format("%.1lf",temp);
			m_scoresSet.m_credit=s;
			m_scoresSet.Update();
			m_scoresSet.Requery();
			AfxMessageBox("修改成功!");
			CDialog::OnOK();
		}

	}
	catch(int)
	{
		AfxMessageBox("请按要求输入数据!");
	}
}