hbcxdlg1.cpp

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

// hbcxdlg1.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "hbcxdlg1.h"

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

/////////////////////////////////////////////////////////////////////////////
// Chbcxdlg1 dialog


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


void Chbcxdlg1::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Chbcxdlg1)
	DDX_Control(pDX, IDC_LIST1, m_hbcxList);
	DDX_Control(pDX, IDC_COMBO2, m_com2);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	DDX_Text(pDX, IDC_EDIT1, m_find);
	//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(Chbcxdlg1, CDialog)
	//{{AFX_MSG_MAP(Chbcxdlg1)
	ON_BN_CLICKED(IDC_BTNFIND, OnBtnfind)
	ON_WM_TIMER()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Chbcxdlg1 message handlers

void Chbcxdlg1::OnBtnfind() 
{
	UpdateData(TRUE);
    m_com1.GetLBText(m_com1.GetCurSel(),m_comstr1);
	m_com2.GetLBText(m_com2.GetCurSel(),m_comstr2);
	if(m_hb.IsOpen())m_hb.Close();
	m_hb.Open();
	if(m_comstr1=="时间查询")
	{
		m_hb.m_strFilter.Format("[时间]='"+ m_comstr2+"'");
		m_hbcxList.DeleteAllItems();
	}
	else if(m_comstr1=="编号查询")
	{
		m_hb.m_strFilter.Format("[航班编号] LIKE '%%"+ m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}
	else if(m_comstr1=="名称查询")
	{
		m_hb.m_strFilter.Format("[航班姓名] LIKE '%%"+ m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}
	else if(m_comstr1=="终点站查询")
	{
		m_hb.m_strFilter.Format("[目的地] LIKE '%%"+ m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}
	m_hb.Requery();
	if(m_hb.IsEOF())
	{
		m_hb.Close();
		AfxMessageBox("没有该时间航班!");
		return ;
	}
    else
		this->Show();
}
BOOL Chbcxdlg1::OnInitDialog() 
{	

		CDialog::OnInitDialog();
		Changban_Recordset m_hb(&theApp.m_DB );
		m_com1.SetCurSel(0);
		m_com2.SetCurSel(1);
		m_hbcxList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	  
		UpdateData(TRUE);
    	m_hbcxList.InsertColumn(0,"航班编号",LVCFMT_LEFT,80);
		m_hbcxList.InsertColumn(1,"航班名称",LVCFMT_LEFT,80);
   	    m_hbcxList.InsertColumn(2,"起始地",LVCFMT_LEFT,70);
    	m_hbcxList.InsertColumn(3,"起飞时间",LVCFMT_LEFT,80);
   	    m_hbcxList.InsertColumn(4,"目的地",LVCFMT_LEFT,70);
	    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,80);
     	m_hbcxList.InsertColumn(9,"日期",LVCFMT_LEFT,80);
		m_Fhbcx=TRUE;
		this->Show();
		m_Fhbcx=FALSE;
		SetTimer(1,2,NULL);
		return TRUE;
}

int Chbcxdlg1::Show()
{

	int i=0;
	if(m_Fhbcx==TRUE)m_hb.Open();
	m_hb.MoveFirst();
	do
	{

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

		i++;
		m_hb.MoveNext();

	}while(!m_hb.IsEOF());
	return i;
}

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