// Lessondlg.cpp : implementation file
//

#include "stdafx.h"
#include "srh.h"
#include "Lessondlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLessondlg dialog


CLessondlg::CLessondlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLessondlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLessondlg)
	m_kechengming = _T("");
	m_kechenghao = 0;
	m_jiaoshihao = _T("");
	//}}AFX_DATA_INIT
}


void CLessondlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLessondlg)
	DDX_Text(pDX, IDC_EDIT2, m_kechengming);
	DDX_Text(pDX, IDC_EDIT1, m_kechenghao);
	DDX_Text(pDX, IDC_EDIT3, m_jiaoshihao);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLessondlg, CDialog)
	//{{AFX_MSG_MAP(CLessondlg)
	ON_BN_CLICKED(IDC_LESSON_DELETE, OnLessonDelete)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_LESSON_INSERT, OnLessonInsert)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLessondlg message handlers

void CLessondlg::OnLessonDelete() 
{
	// 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_kechenghao=m_rs.m_column1;
	m_kechengming=m_rs.m_column2;
	m_jiaoshihao=m_rs.m_column3;
UpdateData(false);
}

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




void CLessondlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
	m_rs.MoveNext();
if(m_rs.IsBOF())
m_rs.MoveLast();
	m_kechenghao=m_rs.m_column1;
	m_kechengming=m_rs.m_column2;
	m_jiaoshihao=m_rs.m_column3;
UpdateData(false);
}

void CLessondlg::OnLessonInsert() 
{
	// TODO: Add your control notification handler code here
	try
	{
		m_rs.AddNew();
		UpdateData(true);
		
    m_rs.m_column1=m_kechenghao;
	m_rs.m_column2=m_kechengming;
    m_rs.m_column3=m_jiaoshihao;
		m_rs.Update();
	}
	catch(CDBException *e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		m_rs.MoveFirst();
	
	m_kechenghao=m_rs.m_column1;
	m_kechengming=m_rs.m_column2;
	m_jiaoshihao=m_rs.m_column3;
		UpdateData(false);
	}		


		

}