roomdlg.cpp

本人自己做的简单的宿舍管理系统！！添加删除

#include "stdafx.h"
#include "RM.h"
#include "Roomdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRoomdlg dialog


CRoomdlg::CRoomdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRoomdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRoomdlg)
	m_nm1 = _T("");
	m_nm2 = _T("");
	m_nm3 = _T("");
	m_nm4 = _T("");
	m_master = _T("");
	m_roomid = _T("");
	//}}AFX_DATA_INIT
}


void CRoomdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRoomdlg)
	DDX_Text(pDX, IDC_EDIT2, m_nm1);
	DDX_Text(pDX, IDC_EDIT3, m_nm2);
	DDX_Text(pDX, IDC_EDIT4, m_nm3);
	DDX_Text(pDX, IDC_EDIT5, m_nm4);
	DDX_Text(pDX, IDC_EDIT6, m_master);
	DDX_Text(pDX, IDC_EDIT1, m_roomid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRoomdlg, CDialog)
	//{{AFX_MSG_MAP(CRoomdlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
//	ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
//	ON_BN_CLICKED(IDC_BUTTON6, OnButton6)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRoomdlg message handlers

void CRoomdlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	CString sadd;
	if(m_roomid==""||m_nm1==""||m_nm2==""||m_nm3==""||m_nm4==""||m_master=="")
	{
		AfxMessageBox("信息没填完整 !");
		return ;
	}
	m_room.m_strFilter="roomid = '"+m_roomid+"'";
	if(!m_room.IsOpen())
	{
		m_room.Open();
	}
	else
		m_room.Requery();
	if(!m_room.IsEOF())
	{
		AfxMessageBox("该房间号已经存在！");
		return;
	}
	m_room.AddNew();
	m_room.m_roomid=m_roomid;
	m_room.m_name1=m_nm1;
	m_room.m_name2=m_nm2;
	m_room.m_name3=m_nm3;
	m_room.m_name4=m_nm4;
	m_room.m_master=m_master;
	m_room.Update();
	m_room.Close();
//	CDialog::OnOK();
	AfxMessageBox("添加成功！");
}

void CRoomdlg::OnButton1() 
{
	UpdateData();
	// TODO: Add your control notification handler code here
	m_room.m_strFilter="roomid = '"+m_roomid+"'";
	if(!m_room.IsOpen())
	{
		m_room.Open();
	}
	else
		m_room.Requery();
	if(m_room.IsEOF())
	{
		m_room.m_strFilter="master = '"+m_master+"'";
			if(!m_room.IsOpen())
			{
				m_room.Open();
			}	
			else
				m_room.Requery();
			if(m_room.IsEOF())
			{
				AfxMessageBox("查找内容不存在！！");
				return;
			}
	}
	m_roomid=m_room.m_roomid;
	m_nm1=m_room.m_name1;
	m_nm2=m_room.m_name2;
	m_nm3=m_room.m_name3;
	m_nm4=m_room.m_name4;
	m_master=m_room.m_master;
	UpdateData(false);
	m_room.Close();
}

void CRoomdlg::OnButton3() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_room.m_strFilter="roomid = '"+m_roomid+"'";
	if(!m_room.IsOpen())
	{
		m_room.Open();
	}
	else
		m_room.Requery();
	if(m_room.IsEOF())
	{
		AfxMessageBox("要修改的宿舍号不存在！");
		return;
	}
	if(m_nm1==""||m_nm2==""||m_nm3==""||m_nm4==""||m_master=="")
	{
		AfxMessageBox("信息没填完整 !");
		return ;
	}
	m_room.Edit();
	m_room.m_name1=m_nm1;
	m_room.m_name2=m_nm2;
	m_room.m_name3=m_nm3;
	m_room.m_name4=m_nm4;
	m_room.m_master=m_master;
	m_room.Update();
	m_room.Close();
	UpdateData(false);
	AfxMessageBox("修改成功！");
	CDialog::OnInitDialog();

}

void CRoomdlg::OnButton4() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	m_room.m_strFilter="roomid = '"+m_roomid+"'";
	if(!m_room.IsOpen())
	{
		m_room.Open();
	}
	else
		m_room.Requery();
	if(m_room.IsEOF())
	{
		AfxMessageBox("要删除的宿舍号不存在！");
		return;
	}
	if(AfxMessageBox(_T("确定要删除该宿舍信息吗？" ),MB_YESNO)==IDNO)
		return;
	m_room.Delete();
	UpdateData(false);
	AfxMessageBox("删除成功！");

}



void CRoomdlg::OnButton6() 
{


}