deletesbscoredlg.cpp

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

// DeleteSbScoreDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CDeleteSbScoreDlg dialog


CDeleteSbScoreDlg::CDeleteSbScoreDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDeleteSbScoreDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDeleteSbScoreDlg)
	m_deleteSbID = _T("");
	m_deleteSbSubject = _T("");
	//}}AFX_DATA_INIT
}


void CDeleteSbScoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDeleteSbScoreDlg)
	DDX_Text(pDX, IDC_DELETE_SB_ID, m_deleteSbID);
	DDX_Text(pDX, IDC_DELETE_SB_SUBJECT, m_deleteSbSubject);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDeleteSbScoreDlg message handlers

void CDeleteSbScoreDlg::OnOK() 
{
	// TODO: Add extra validation here
	if (!m_scoresSet.IsOpen())
	{
		m_scoresSet.Open();
	}
	int error=0;
	UpdateData();
	try{
		if(m_deleteSbSubject==""||m_deleteSbID=="")
			throw error;
		//查询
		m_scoresSet.m_strFilter.Format("ID='%s' and subject='%s'",m_deleteSbID,m_deleteSbSubject);
		m_scoresSet.Requery();
		if (m_scoresSet.IsEOF())
		{
			AfxMessageBox("此记录不存在!");
		}
		else{
			m_scoresSet.Delete();//删除记录
			AfxMessageBox("删除成功!");
			CDialog::OnOK();
		}
	}
	catch(int )
	{
		AfxMessageBox("请按要求输入数据!");
	}
}