// Choosedlg.cpp : implementation file
//

#include "stdafx.h"
#include "srh.h"
#include "Choosedlg.h"
//#include"ODBCXUANKE.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CChoosedlg dialog


CChoosedlg::CChoosedlg(CWnd* pParent /*=NULL*/)
	: CDialog(CChoosedlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChoosedlg)
	m_xuehao = _T("");
	m_kechenghao = _T("");
	m_chengji = _T("");
	//}}AFX_DATA_INIT
}


void CChoosedlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChoosedlg)
	DDX_Text(pDX, IDC_EDIT1, m_xuehao);
	DDX_Text(pDX, IDC_EDIT2, m_kechenghao);
	DDX_Text(pDX, IDC_EDIT3, m_chengji);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChoosedlg, CDialog)
	//{{AFX_MSG_MAP(CChoosedlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_CHOOSE_INSERT, OnChooseInsert)
	ON_BN_CLICKED(IDC_CHOOSE_DELETE, OnChooseDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChoosedlg message handlers



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

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

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

void CChoosedlg::OnChooseDelete() 
{
	// 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_xuehao=m_rs.m_column1;
	m_kechenghao=m_rs.m_column2;
	m_chengji=m_rs.m_column3;  
	UpdateData(false);		
	
}