deletedlg.cpp

这是一个简单的体检管理系统

// DeleteDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HealManage.h"
#include "DeleteDlg.h"
#include "TiJSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDeleteDlg dialog


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


void CDeleteDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDeleteDlg)
	DDX_Control(pDX, IDC_KSH, m_cksh);
	DDX_Text(pDX, IDC_KSH, m_ksh);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDeleteDlg, CDialog)
	//{{AFX_MSG_MAP(CDeleteDlg)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDeleteDlg message handlers

void CDeleteDlg::OnDelete() 
{
	// TODO: Add your control notification handler code here
	CString m_strSQL;
	CTiJSet m_recordset;
	UpdateData(TRUE);
	if(m_ksh.IsEmpty())
	{
		AfxMessageBox("请输入要删除的考生的考号!");
		m_cksh.SetFocus();
		return;
	}
	m_strSQL.Format("select * from tjk where ksh='%s'",m_ksh);
	if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,m_strSQL))
	{
		MessageBox("打开数据库失败","连接失败",MB_OK);
		return;
	}
	if(m_recordset.GetRecordCount()==0)
	{
		AfxMessageBox("该学生还没有体检信息,请重新输入!");
		return;
	}
	else
	{
		if (MessageBox("是否删除该记录?","请确认", MB_YESNO) == IDYES)
		{
			m_recordset.Close();
            m_strSQL.Format("select * from tjk where ksh='%s'",m_ksh);
		    if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,m_strSQL))
			{
		        MessageBox("打开数据库失败","连接失败",MB_OK);
		        return;
			}
		    m_recordset.Delete();
		    m_recordset.Close();
		    AfxMessageBox("成功删除该学生的体检信息!");
			CDialog::OnOK();
		}
	}
}