// Teacherdlg.cpp : implementation file
//

#include "stdafx.h"
#include "srh.h"
#include "Teacherdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTeacherdlg dialog


CTeacherdlg::CTeacherdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTeacherdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTeacherdlg)
	m_jiaoshixingming = _T("");
	m_jiaoshihao = 0;
	m_suoshoukehao = 0;
	//}}AFX_DATA_INIT
}


void CTeacherdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTeacherdlg)
	DDX_Control(pDX, IDC_LIST1, m_tlistctrl);
	DDX_Text(pDX, IDC_EDIT2, m_jiaoshixingming);
	DDX_Text(pDX, IDC_EDIT1, m_jiaoshihao);
	DDX_Text(pDX, IDC_EDIT3, m_suoshoukehao);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTeacherdlg, CDialog)
	//{{AFX_MSG_MAP(CTeacherdlg)

	ON_BN_CLICKED(IDC_TEACHER_INSERT, OnTeacherInsert)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_TEACHER_DELETE, OnTeacherDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTeacherdlg message handlers



void CTeacherdlg::OnTeacherInsert() 
{
	// TODO: Add your control notification handler code here
	try
	{
		m_rs.AddNew();
		UpdateData(true);
			
m_rs.m_column1=m_jiaoshihao;
m_rs.m_column2=m_jiaoshixingming;
	m_rs.m_column3=m_suoshoukehao;


		m_rs.Update();
	}
	catch(CDBException *e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		m_rs.MoveFirst();
	m_jiaoshihao=m_rs.m_column1;
     m_jiaoshixingming=m_rs.m_column2;
	m_suoshoukehao=m_rs.m_column3;
		UpdateData(false);
	}			

}

void CTeacherdlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	m_rs.MovePrev();
if(m_rs.IsBOF())
m_rs.MoveFirst();
	m_rs.m_column1=m_jiaoshihao;
m_rs.m_column2=m_jiaoshixingming;
	m_rs.m_column3=m_suoshoukehao;
UpdateData(false);	
}

void CTeacherdlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
	m_rs.MoveNext();
if(m_rs.IsBOF())
m_rs.MoveLast();
	m_rs.m_column1=m_jiaoshihao;
m_rs.m_column2=m_jiaoshixingming;
	m_rs.m_column3=m_suoshoukehao;

UpdateData(false);		
}

void CTeacherdlg::OnTeacherDelete() 
{
	// TODO: Add your control notification handler code here
	if(m_rs.IsBOF()||m_rs.IsEOF())
 return;
	try{
	m_rs.Delete();
	}catch(CDBException *e){
	AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
	e->Delete();
	return;}
	m_rs.MoveFirst();
	m_jiaoshihao=m_rs.m_column1;
    m_jiaoshixingming=m_rs.m_column2;
	m_suoshoukehao=m_rs.m_column3;
	UpdateData(false);
}