dlgaddflight.cpp

1.解压后在sql2000中建立数据库flight,然后用本文件中的flight文件进行还原 2.数据库连接是用ADO实现的,如果更改连接,打开后对两个程序的ADOConn.cpp进行修改就行(t

// DlgAddFlight.cpp : implementation file
//

#include "stdafx.h"
#include "AirServer.h"
#include "DlgAddFlight.h"
#include "AdoConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgAddFlight dialog


CDlgAddFlight::CDlgAddFlight(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgAddFlight::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgAddFlight)
	m_id = _T("");
	m_start = _T("");
	m_stime = _T("");
	m_etime = _T("");
	m_end = _T("");
	m_price = _T("");
	m_tNum = _T("");
	m_sNum = _T("");
	m_jNum = _T("");
	//}}AFX_DATA_INIT
}


void CDlgAddFlight::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgAddFlight)
	DDX_Text(pDX, IDC_EDIT1, m_id);
	DDX_Text(pDX, IDC_EDIT2, m_start);
	DDX_Text(pDX, IDC_EDIT4, m_stime);
	DDX_Text(pDX, IDC_EDIT5, m_etime);
	DDX_Text(pDX, IDC_EDIT3, m_end);
	DDX_Text(pDX, IDC_EDIT6, m_price);
	DDX_Text(pDX, IDC_EDIT7, m_tNum);
	DDX_Text(pDX, IDC_EDIT8, m_sNum);
	DDX_Text(pDX, IDC_EDIT9, m_jNum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgAddFlight, CDialog)
	//{{AFX_MSG_MAP(CDlgAddFlight)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgAddFlight message handlers

void CDlgAddFlight::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData();
	ADOConn adoConn;
	adoConn.OnInitADOConn();
	_bstr_t vsql;
	CString strSql;
	if(m_id!="" && m_end!="" && m_etime!="" && m_jNum!="" && m_price!="" && m_sNum!=""
		&& m_start!="" && m_stime!="" && m_tNum!="")
		strSql.Format("insert into flights values('%s','%s','%s','1899-12-30 %s','1899-12-30 %s','%s',%s,%s,%s)",m_id,m_start,m_end,m_stime,m_etime,m_price,m_tNum,m_sNum,m_jNum);
	else
	{
		AfxMessageBox("请把信息输入完整!");
		return;
	}
	vsql=(_bstr_t)strSql;
	try{
		adoConn.ExecuteSQL(vsql);
	}catch(_com_error e){
		AfxMessageBox(e.Description());
	}
	adoConn.ExitConnect();
	MessageBox("增加航班成功!");
	CDialog::OnOK();
}