spcxdlg.cpp

航空管理系统 用vc6.0开发环境 odbc连接

// spcxdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "spcxdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cspcxdlg dialog


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


void Cspcxdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cspcxdlg)
	DDX_Control(pDX, IDC_COMBO3, m_com2);
	DDX_Control(pDX, IDC_COMBO2, m_com1);
	DDX_Control(pDX, IDC_LIST1, m_hbcxList);
	DDX_Text(pDX, IDC_EDIT6, m_find);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cspcxdlg, CDialog)
	//{{AFX_MSG_MAP(Cspcxdlg)
	ON_BN_CLICKED(IDC_BTNFIND, OnBtnfind)
	ON_WM_TIMER()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cspcxdlg message handlers

void Cspcxdlg::OnBtnfind() 
{

	UpdateData(TRUE);
	m_com1.GetLBText(m_com1.GetCurSel(),m_comstr1);
	m_com2.GetLBText(m_com2.GetCurSel(),m_comstr2);
	
	if(m_hbcx.IsOpen())m_hbcx.Close();
	m_hbcx.Open();

	if(m_comstr1=="时间查询")
	{
		m_hbcx.m_strFilter.Format("[时间] ='"+m_comstr2+"'");
		m_hbcxList.DeleteAllItems();
	}
	else if(m_comstr1=="编号查询")
	{
		m_hbcx.m_strFilter.Format("[航班编号] Like '%%"+ m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}
	else if(m_comstr1=="终点站查询")
	{
		m_hbcx.m_strFilter.Format("[目的地] Like '%%" + m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}
	
	m_hbcx.Requery();
	if(m_hbcx.IsEOF())
	{
		m_hbcx.Close();
		AfxMessageBox("没有该时间航班!");
		return ; 
	}
    else
		this->Show();
}

BOOL Cspcxdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	Changban_Recordset m_hbcx(&theApp.m_DB );

	m_com1.SetCurSel(0);
	m_com2.SetCurSel(1);
	UpdateData(TRUE);
	m_hbcxList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_hbcxList.InsertColumn(0,"航班编号",LVCFMT_LEFT,80);
   	m_hbcxList.InsertColumn(1,"起始地",LVCFMT_LEFT,70);
	m_hbcxList.InsertColumn(2,"起飞时间",LVCFMT_LEFT,80);
   	m_hbcxList.InsertColumn(3,"目的地",LVCFMT_LEFT,70);
	m_hbcxList.InsertColumn(4,"到达时间",LVCFMT_LEFT,80);
   	m_hbcxList.InsertColumn(5,"一仓余票",LVCFMT_LEFT,80);
	m_hbcxList.InsertColumn(6,"二仓余票",LVCFMT_LEFT,80);
   	m_hbcxList.InsertColumn(7,"三仓余票",LVCFMT_LEFT,80);
   	m_hbcxList.InsertColumn(8,"日期",LVCFMT_LEFT,60);
	m_Fspcx=TRUE;

	this->Show();
	m_Fspcx=FALSE;
	SetTimer(1,2,NULL);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
int Cspcxdlg::Show()
{
	int i=0;
	if(m_Fspcx==TRUE)
		m_hbcx.Open();

	m_hbcx.MoveFirst();
	do
	{
		CString s;
		m_hbcxList.InsertItem(i,m_hbcx.m_column1 );
		m_hbcxList.SetItemText(i,1,m_hbcx.m_column3 );
		m_hbcxList.SetItemText(i,2,m_hbcx.m_column4 );
		m_hbcxList.SetItemText(i,3,m_hbcx.m_column5);
		m_hbcxList.SetItemText(i,4,m_hbcx.m_column6);
		s.Format("%d",m_hbcx.m_column9);
		m_hbcxList.SetItemText(i,5,s);
		s.Format("%d",m_hbcx.m_column13);
		m_hbcxList.SetItemText(i,6,s);
		s.Format("%d",m_hbcx.m_column17);
		m_hbcxList.SetItemText(i,7,s);
		m_hbcxList.SetItemText(i,8,m_hbcx.m_column22);
		i++;

		m_hbcx.MoveNext();
	}while(!m_hbcx.IsEOF());

	m_hbcx.Close();
	return i;
}

void Cspcxdlg::OnTimer(UINT nIDEvent) 
{
	CString s;
	m_com1.GetLBText(m_com1.GetCurSel(),s);
	if(s=="时间查询")
	{
        GetDlgItem(IDC_EDIT6)->EnableWindow(FALSE);
		m_com2.EnableWindow(TRUE);
	}
	else
	{
        GetDlgItem(IDC_EDIT6)->EnableWindow(TRUE);
		m_com2.EnableWindow(FALSE);
	}
	CDialog::OnTimer(nIDEvent);
}