flightadddlg.cpp

利用odbc编程实现以下功能： 航班

// flightadddlg.cpp : implementation file
//

#include "stdafx.h"
#include "dbexe.h"
#include "flightadddlg.h"
#include "flightset.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// Cflightadddlg dialog


Cflightadddlg::Cflightadddlg(CWnd* pParent /*=NULL*/)
	: CDialog(Cflightadddlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cflightadddlg)
	m_flightnum = _T("");
	m_price =0;
	m_seatnum =0;
	m_fromadd = _T("");
	m_toadd = _T("");
	m_seatavl = 0;
	//}}AFX_DATA_INIT
}


void Cflightadddlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cflightadddlg)
	DDX_Text(pDX, IDC_EDIT1, m_flightnum);
	DDX_Text(pDX, IDC_EDIT2, m_price);
	DDX_Text(pDX, IDC_EDIT3, m_seatnum);
	DDX_Text(pDX, IDC_EDIT4, m_fromadd);
	DDX_Text(pDX, IDC_EDIT5, m_toadd);
	DDX_Text(pDX, IDC_EDIT6, m_seatavl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cflightadddlg, CDialog)
	//{{AFX_MSG_MAP(Cflightadddlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cflightadddlg message handlers

void Cflightadddlg::OnButton1() 
{if(!m_database.IsOpen()){
	m_database.Open(_T("database1"));
}
CString strSQL;
UpdateData(TRUE);
strSQL.Format("insert into flights values(\'%s\',%d,%d,%d,\'%s\',\'%s\')",m_flightnum,m_price,m_seatnum,m_seatavl,m_fromadd,m_toadd);
m_database.ExecuteSQL(strSQL);
m_database.Close();
CDialog::OnOK();
  m_database.Close();
  CDialog::OnCancel();	// TODO: Add your control notification handler code here
	
}

void Cflightadddlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
m_database.Close();
CDialog::OnCancel();
}