deletesballscoresdlg.cpp

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

// DeleteSbAllScoresDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CDeleteSbAllScoresDlg dialog


CDeleteSbAllScoresDlg::CDeleteSbAllScoresDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDeleteSbAllScoresDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDeleteSbAllScoresDlg)
	m_deleteSbAllScoresID = _T("");
	//}}AFX_DATA_INIT
}


void CDeleteSbAllScoresDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDeleteSbAllScoresDlg)
	DDX_Text(pDX, IDC_DELETE_SB_ALL_SCORES_ID, m_deleteSbAllScoresID);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDeleteSbAllScoresDlg message handlers

void CDeleteSbAllScoresDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	CString id="ID";
	DeleteAll(id,m_deleteSbAllScoresID);
}

void CDeleteSbAllScoresDlg::DeleteAll(const CString & id, const CString & condition)
{
	if (!m_scoresSet.IsOpen()){
		m_scoresSet.Open();
	}
	try{
		int error=0;
		if(condition=="")
			throw error;
		//查询
		m_scoresSet.m_strFilter.Format("%s='%s'",id,condition);
		m_scoresSet.Requery();
		if (m_scoresSet.IsEOF()){
			AfxMessageBox("没有记录!");
		}
		else{
			while(!m_scoresSet.IsEOF()){
				m_scoresSet.Delete();
				m_scoresSet.m_strFilter.Format("%s='%s'",id,condition);
				m_scoresSet.Requery();
			}
			AfxMessageBox("完成清除!");
		}
		CDialog::OnOK();
	}
	catch(int)
	{
		AfxMessageBox("请输入学号!");
	}
	
}