routquerydlg.cpp

用VC实现的一个简单的旅行预订系统

// RoutQueryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TRS.h"
#include "RoutQueryDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRoutQueryDlg dialog


CRoutQueryDlg::CRoutQueryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRoutQueryDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRoutQueryDlg)
	m_strCustName = _T("");
	//}}AFX_DATA_INIT
}


void CRoutQueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRoutQueryDlg)
	DDX_Control(pDX, IDC_LIST_ROUT_QUERY, m_listRoutQuery);
	DDX_Text(pDX, IDC_EDIT_ROUTQ_CUST_NAME, m_strCustName);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRoutQueryDlg, CDialog)
	//{{AFX_MSG_MAP(CRoutQueryDlg)
	ON_BN_CLICKED(IDC_BTN_ROUT_QUERY, OnBtnRoutQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRoutQueryDlg message handlers

void CRoutQueryDlg::OnBtnRoutQuery() 
{
	// TODO: Add your control notification handler code here
	CString fromCity,arivCity;
	UpdateData();
	if(m_strCustName.IsEmpty())
	{
		MessageBox("客户名不能为空！",MB_OK);
		return;
	}
	m_listRoutQuery.DeleteAllItems();
	CRecordset rs(&(((CTRSApp*)AfxGetApp())->db));
	rs.Open(CRecordset::forwardOnly,"select FromCity,ArivCity from\
		FLIGHTS,RESERVATIONS where FLIGHTS.flightNum=RESERVATIONS.flightNum\
		and custName='"+m_strCustName+"'");
	int i=0;
	while( !rs.IsEOF() )
	{
		rs.GetFieldValue("FromCity",fromCity);
		m_listRoutQuery.InsertItem(i,fromCity);

		rs.GetFieldValue("ArivCity",arivCity);
		m_listRoutQuery.SetItemText(i,1,arivCity);
		
		rs.MoveNext();
		i++;
	}
	rs.Close();
}



BOOL CRoutQueryDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_listRoutQuery.InsertColumn(0,"出发站");
	m_listRoutQuery.InsertColumn(1,"到达站");
	RECT rect;
	m_listRoutQuery.GetWindowRect(&rect);
	int rectWidth = rect.right - rect.left;

	m_listRoutQuery.SetColumnWidth(0,rectWidth/2);
	m_listRoutQuery.SetColumnWidth(1,rectWidth/2);
	m_listRoutQuery .SetExtendedStyle(LVS_EX_FULLROWSELECT);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}