ygcx.cpp

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

// Ygcx.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "Ygcx.h"

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

/////////////////////////////////////////////////////////////////////////////
// CYgcx dialog


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


void CYgcx::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CYgcx)
	DDX_Control(pDX, IDC_LIST1, m_ygList);
	DDX_Control(pDX, IDC_COMBO2, m_ygcom2);
	DDX_Control(pDX, IDC_COMBO1, m_ygcom1);
	DDX_Text(pDX, IDC_EDIT1, m_find);
	DDX_Text(pDX, IDC_EDIT2, m_ygyx);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CYgcx, CDialog)
	//{{AFX_MSG_MAP(CYgcx)
	ON_BN_CLICKED(IDC_ygfindbtn, Onygfindbtn)
	ON_WM_TIMER()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CYgcx message handlers

void CYgcx::Onygfindbtn() 
{
	UpdateData(TRUE);
	m_ygcom1.GetLBText(m_ygcom1.GetCurSel(),m_ygcom1str);
	m_ygcom2.GetLBText(m_ygcom2.GetCurSel(),m_ygcom2str);
	if(m_yg.IsOpen())m_yg.Close();
	m_yg.Open();
	if(m_ygcom1str=="员工编号")
	{
		m_yg.m_strFilter.Format("[编号] LIKE '%%"+m_find+"%%'");
		m_ygList.DeleteAllItems();
	}
	else if(m_ygcom1str=="姓名查询")
	{
		m_yg.m_strFilter.Format("[姓名] LIKE '%%"+m_find+"%%'");
		m_ygList.DeleteAllItems();
	}
	else if(m_ygcom1str=="身份证号")
	{
		m_yg.m_strFilter.Format("[身份证号] LIKE '%%"+m_find+"%%'");
		m_ygList.DeleteAllItems();
	}
	else if(m_ygcom1str=="月薪查询")
	{
		if(m_ygcom2str=="<=")
		{
		m_yg.m_strFilter.Format("[月薪] <=%d" ,m_ygyx);
		m_ygList.DeleteAllItems();
		}
		else if(m_ygcom2str==">=")
		{
		m_yg.m_strFilter.Format("[月薪]>=%d", m_ygyx);
		m_ygList.DeleteAllItems();
		}
		else
		{
		 m_yg.m_strFilter.Format("[月薪]=%d" , m_ygyx);
		 m_ygList.DeleteAllItems();
		}

	}
	m_yg.Requery();
	if(m_yg.IsEOF())
	{
		m_yg.Close();
		MessageBox("没有该员工!");
		return ;
	}
	else
	{
		this->Show();
	}
	
}

int CYgcx::Show()
{
	if(m_Fyg==TRUE)
	m_yg.Open();
	int i=0;
	m_yg.MoveFirst();
	do
	{
		m_ygList.InsertItem(i,m_yg.m_column1);
		m_ygList.SetItemText(i,1,m_yg.m_column2);
		m_ygList.SetItemText(i,2,m_yg.m_column3);
		m_ygList.SetItemText(i,3,m_yg.m_column4);
		m_ygList.SetItemText(i,4,m_yg.m_column5);
		m_ygList.SetItemText(i,5,m_yg.m_column6);
		CString s;
		s.Format("%d",m_yg.m_column7);
		m_ygList.SetItemText(i,6,s);
		m_ygList.SetItemText(i,7,m_yg.m_column8);
		i++;
		m_yg.MoveNext();

	}while(!m_yg.IsEOF());

	m_yg.Close();

	return i;
}

BOOL CYgcx::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CYG_Recordset m_yg(&theApp.m_DB );
	m_ygcom1.SetCurSel(0);
	m_ygcom2.SetCurSel(0);
	
	m_ygList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	int i=0;
	CODBCFieldInfo Info;
	m_yg.Open();
	for(i=0;i<m_yg.m_nFields;i++)
	{
		m_yg.GetODBCFieldInfo(i,Info);
		m_ygList.InsertColumn(i,Info.m_strName,LVCFMT_LEFT,100);
	}
	m_yg.Close;
	m_Fyg=TRUE;
	this->Show();
	m_Fyg=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 CYgcx::OnTimer(UINT nIDEvent) 
{

	CString s;
	m_ygcom1.GetLBText(m_ygcom1.GetCurSel(),s);

	if(s=="月薪查询")
	{
        GetDlgItem(IDC_EDIT1)->EnableWindow(FALSE);
		m_ygcom2.EnableWindow(TRUE);
		GetDlgItem(IDC_EDIT2)->EnableWindow(TRUE);
	}
	else
	{
        GetDlgItem(IDC_EDIT1)->EnableWindow(TRUE);
		m_ygcom2.EnableWindow(FALSE);
		GetDlgItem(IDC_EDIT2)->EnableWindow(FALSE);
	}
	CDialog::OnTimer(nIDEvent);
}