hbcxdlg.cpp

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

// Hbcxdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "Hbcxdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CHbcxdlg dialog


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


void CHbcxdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CHbcxdlg)
	DDX_Control(pDX, IDC_COMBO2, m_com2);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	DDX_Control(pDX, IDC_LIST1, m_hbList);
	DDX_Text(pDX, IDC_EDIT1, m_chaxun);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CHbcxdlg, CDialog)
	//{{AFX_MSG_MAP(CHbcxdlg)
	ON_BN_CLICKED(IDC_BTNFIND, OnBtnfind)
	ON_WM_TIMER()
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	ON_COMMAND(IDSTR_HBCX, OnHbcx)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CHbcxdlg message handlers

BOOL CHbcxdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
    m_com2.EnableWindow(FALSE);
	m_hbList.DeleteAllItems();
	m_com1.SetCurSel(0);
	m_com2.SetCurSel(0);

	Changban_Recordset m_hb(&theApp.m_DB);
	unsigned i=0;
	CODBCFieldInfo Info;
	m_hb.Open();
	m_hbList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	for(i=0;i<m_hb.m_nFields;i++)
	{
		m_hb.GetODBCFieldInfo(i,Info);
		m_hbList.InsertColumn(i,Info.m_strName,LVCFMT_LEFT,110);
	}
	m_hb.Close();
	if(m_hb.IsOpen())m_hb.Close();
	
	 f=TRUE;
     m_hbCount=this->Show();
	 f=FALSE;
      SetTimer(1,2,NULL);
	 return TRUE; 
}
int CHbcxdlg::Show()
{   
	if(f==TRUE)
	m_hb.Open();
	int i=0;
	m_hb.MoveFirst();
	do
	{
		m_hbList.InsertItem(i,m_hb.m_column1 );
		m_hbList.SetItemText(i,1,m_hb.m_column2 );
		m_hbList.SetItemText(i,2,m_hb.m_column3 );
		m_hbList.SetItemText(i,3,m_hb.m_column4 );
		m_hbList.SetItemText(i,4,m_hb.m_column5 );
		m_hbList.SetItemText(i,5,m_hb.m_column6 );
		CString s;
		s.Format("%d",m_hb.m_column7 );
		m_hbList.SetItemText(i,6,s );
		s.Format("%d",m_hb.m_column8 );
		m_hbList.SetItemText(i,7,s );
		s.Format("%d",m_hb.m_column9 );
		m_hbList.SetItemText(i,8,s );
		s.Format("%d",m_hb.m_column10 );
		m_hbList.SetItemText(i,9,s );
		s.Format("%d",m_hb.m_column11 );
		m_hbList.SetItemText(i,10,s );
		s.Format("%d",m_hb.m_column12 );
		m_hbList.SetItemText(i,11,s );
		s.Format("%d",m_hb.m_column13 );
		m_hbList.SetItemText(i,12,s );
		s.Format("%d",m_hb.m_column14 );
		m_hbList.SetItemText(i,13,s );
		s.Format("%d",m_hb.m_column15 );
		m_hbList.SetItemText(i,14,s);
		s.Format("%d",m_hb.m_column16 );
		m_hbList.SetItemText(i,15,s );
		s.Format("%d",m_hb.m_column17 );
		m_hbList.SetItemText(i,16,s );
		s.Format("%d",m_hb.m_column18 );
		m_hbList.SetItemText(i,17,s );
		s.Format("%d",m_hb.m_column19 );
		m_hbList.SetItemText(i,18,s );
		s.Format("%d",m_hb.m_column20 );
		m_hbList.SetItemText(i,19,s );
		s.Format("%d",m_hb.m_column21 );
		m_hbList.SetItemText(i,20,s );
        m_hbList.SetItemText(i,21,m_hb.m_column22 );
		m_hb.MoveNext();
		i++;
	}while (!m_hb.IsEOF());
	m_hb.Close();
   return i;
}

void CHbcxdlg::OnBtnfind() 
{
	UpdateData(TRUE);
    m_com1.GetLBText(m_com1.GetCurSel(),m_Getcom1str);
	m_com2.GetLBText(m_com2.GetCurSel(),m_Getcom2str);


	//打开表 
		if(m_hb.IsOpen())m_hb.Close();
		m_hb.Open();
		
	if(m_Getcom1str=="时间查询")
	{
		m_hb.m_strFilter.Format("[时间]='"+ m_Getcom2str+"'");
		m_hbList.DeleteAllItems();
	}
	else if(m_Getcom1str=="编号查询")
	{
		m_hb.m_strFilter.Format("[航班编号] LIKE '%%"+ m_chaxun+"%%'");
		m_hbList.DeleteAllItems();
	}
	else if(m_Getcom1str=="终点站查询")
	{
		m_hb.m_strFilter.Format("[目的地] LIKE '%%"+ m_chaxun+"%%'");
		m_hbList.DeleteAllItems();
	}
	m_hb.Requery();
	if(m_hb.IsEOF())
	{
		m_hb.Close();
		AfxMessageBox("没有该时间航班!");
		return ;
	}
    else
		this->Show();
}
void CHbcxdlg::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);
}

void CHbcxdlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{

	
	*pResult = 0;
}


void CHbcxdlg::OnHbcx() 
{


}

HBRUSH CHbcxdlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
   //   if (nCtlColor==CTLCOLOR_EDIT )
   //   pDC->SetTextColor(RGB(0,255,255));
//	  pDC->SetBkColor(RGB(0,0,60));	
	// TODO: Return a different brush if the default is not desired
	return hbr;
}