tpcxdlg.cpp

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

// tpcxdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "tpcxdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Ctpcxdlg dialog


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


void Ctpcxdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Ctpcxdlg)
	DDX_Control(pDX, IDC_LIST1, m_tpcxList);
	DDX_Control(pDX, IDC_COMBO2, m_com2);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	DDX_Text(pDX, IDC_EDIT6, m_find);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Ctpcxdlg, CDialog)
	//{{AFX_MSG_MAP(Ctpcxdlg)
	ON_BN_CLICKED(IDC_Findbtn, OnFindbtn)
	ON_WM_TIMER()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Ctpcxdlg message handlers

void Ctpcxdlg::OnFindbtn() 
{
	UpdateData(TRUE);

	m_com1.GetLBText(m_com1.GetCurSel(),m_comstr1);
	m_com2.GetLBText(m_com2.GetCurSel(),m_comstr2);

	if(m_tp.IsOpen())m_tp.Close();
	m_tp.Open();

	if(m_comstr1=="编号查询")
	{
		m_tp.m_strFilter.Format("[航班编号] LIKE '%%"+m_find+"%%'");
		m_tpcxList.DeleteAllItems();
	}
	else if(m_comstr1=="时间查询")
	{
		m_tp.m_strFilter.Format("[退票时间]='"+m_comstr2+"'");
		m_tpcxList.DeleteAllItems();
	}
	m_tp.Requery();
	if(m_tp.IsEOF())
	{
		m_tp.Close();
		MessageBox("没有该时间航班退票座位!");
		return ;
	}
	else
		this->Show();
	UpdateData(FALSE);
}
BOOL Ctpcxdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CTP_Recordset m_tp(&theApp.m_DB );
	m_com1.SetCurSel(0);
	m_com2.SetCurSel(1);

	m_tpcxList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

	int i=0;
	CODBCFieldInfo Info;
	m_tp.Open();
	for(i=0;i<m_tp.m_nFields;i++)
	{
		m_tp.GetODBCFieldInfo(i,Info);
		m_tpcxList.InsertColumn(i,Info.m_strName,LVCFMT_LEFT,110);
	}
	m_tp.Close();
	if(m_tp.IsOpen())m_tp.Close();
	m_Ftpcx=TRUE;
	this->Show();
	m_Ftpcx=FALSE;
	SetTimer(1,2,NULL);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void Ctpcxdlg::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);
}
int Ctpcxdlg::Show()
{
	if(m_Ftpcx==TRUE)
		m_tp.Open();
	m_tp.MoveFirst();
	int i=0;
	do
	{
		CString s;
        m_tpcxList.InsertItem(i,m_tp.m_column1 );
		m_tpcxList.SetItemText(i,1,m_tp.m_column2 );
		s.Format("%d",m_tp.m_column3);
		m_tpcxList.SetItemText(i,2,s );
		m_tpcxList.SetItemText(i,3,m_tp.m_column4 );
		i++;
		m_tp.MoveNext();
	}while(!m_tp.IsEOF());
	m_tp.Close();
	return i;

}