khxxcxdlg.cpp

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

// KHXXCXdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "KHXXCXdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKHXXCXdlg dialog


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


void CKHXXCXdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKHXXCXdlg)
	DDX_Control(pDX, IDC_CKLIST, m_ckList);
	DDX_Control(pDX, IDC_COMBO1, m_ckcom);
	DDX_Text(pDX, IDC_EDIT1, m_findstr);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CKHXXCXdlg message handlers

void CKHXXCXdlg::OnFindbtn() 
{
	UpdateData(TRUE);
    m_ckcom.GetLBText(m_ckcom.GetCurSel(),m_kcstr);
	if(m_ck.IsOpen())m_ck.Close();
	m_ck.Open();
	if(m_kcstr=="姓名查询")
	{
		m_ck.m_strFilter.Format("[姓名] LIKE '%%"+m_findstr+"%%'");
		m_ckList.DeleteAllItems();
	}
	else if(m_kcstr=="身份证号")
	{
		m_ck.m_strFilter.Format("[身份证号] LIKE '%%"+m_findstr+"%%'");
		m_ckList.DeleteAllItems();
	}
	else if(m_kcstr=="航班编号")
	{
		m_ck.m_strFilter.Format("[航班编号] LIKE '%%"+m_findstr+"%%'");
		m_ckList.DeleteAllItems();
	}
	m_ck.Requery();
	if(m_ck.IsEOF())
	{
		m_ck.Close();
		MessageBox("没有该乘客!");
		return ;
	}
	else
	{
		this->Show();
	}
}

BOOL CKHXXCXdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CCK_Recordset m_ck(&theApp.m_DB );
	m_ckcom.SetCurSel(0);

	m_ckList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	unsigned i=0;
	CODBCFieldInfo Info;
	m_ck.Open();
	for(i=0;i<m_ck.m_nFields;i++)
	{
		m_ck.GetODBCFieldInfo(i,Info);
		m_ckList.InsertColumn(i,Info.m_strName,LVCFMT_LEFT,80);
	}
	m_ck.Close();
	if(m_ck.IsOpen())m_ck.Close();
	m_F=TRUE;
	m_ckCount=this->Show();
	m_F=FALSE;
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

int CKHXXCXdlg::Show()
{
	int i=0;
	if(m_F==TRUE)
		m_ck.Open();
	m_ck.MoveFirst();
	do
	{
		m_ckList.InsertItem(i,m_ck.m_column1);
		m_ckList.SetItemText(i,1,m_ck.m_column2);
		m_ckList.SetItemText(i,2,m_ck.m_column3);
		m_ckList.SetItemText(i,3,m_ck.m_column4);
		m_ckList.SetItemText(i,4,m_ck.m_column5);
		m_ckList.SetItemText(i,5,m_ck.m_column6);
		m_ckList.SetItemText(i,6,m_ck.m_column7);
		m_ckList.SetItemText(i,7,m_ck.m_column8);
		m_ck.MoveNext();
		i++;
	}while(!m_ck.IsEOF());
	m_ck.Close();
	return i;
}