hbgldlg.cpp

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

// Hbgldlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "Hbgldlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CHbgldlg dialog


CHbgldlg::CHbgldlg(CWnd* pParent /*=NULL*/)
	: CDialog(CHbgldlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CHbgldlg)
	m_hbnum = _T("");
	m_hbname = _T("");
	m_hbzdz = _T("");
	m_hbqsd = _T("");
	m_qssj = _T("");
	m_hbddsj = _T("");
	m_hbydc = 0;
	m_hbedc = 0;
	m_hbsdc = 0;
	m_zw1 = 0;
	m_zw2 = 0;
	m_zw3 = 0;
	m_riqi = _T("");
	//}}AFX_DATA_INIT
}


void CHbgldlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CHbgldlg)
	DDX_Text(pDX, IDC_EDIT1, m_hbnum);
	DDX_Text(pDX, IDC_EDIT3, m_hbname);
	DDX_Text(pDX, IDC_EDIT2, m_hbzdz);
	DDX_Text(pDX, IDC_EDIT4, m_hbqsd);
	DDX_Text(pDX, IDC_EDIT5, m_qssj);
	DDX_Text(pDX, IDC_EDIT7, m_hbddsj);
	DDX_Text(pDX, IDC_EDIT6, m_hbydc);
	DDX_Text(pDX, IDC_EDIT9, m_hbedc);
	DDX_Text(pDX, IDC_EDIT8, m_hbsdc);
	DDX_Text(pDX, IDC_EDIT10, m_zw1);
	DDX_Text(pDX, IDC_EDIT11, m_zw2);
	DDX_Text(pDX, IDC_EDIT12, m_zw3);
	DDX_Text(pDX, IDC_EDIT13, m_riqi);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CHbgldlg, CDialog)
	//{{AFX_MSG_MAP(CHbgldlg)
	ON_BN_CLICKED(IDC_Findbtn, OnFindbtn)
	ON_BN_CLICKED(IDC_Addbtn, OnAddbtn)
	ON_BN_CLICKED(IDC_Editbtn, OnEditbtn)
	ON_BN_CLICKED(IDC_Delbtn, OnDelbtn)
	ON_BN_CLICKED(IDC_Clear, OnClear)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CHbgldlg message handlers

void CHbgldlg::OnFindbtn() 
{
    	UpdateData(TRUE);
	    //打开表 
		if(m_hbgl.IsOpen())m_hbgl.Close();
		m_hbgl.Open();

		if(m_hbnum=="") 
		{
			MessageBox("请输入航班编号!");
			return ;
		}
		m_hbgl.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");

        m_hbgl.Requery();
		if(m_hbgl.IsEOF())
		{
			m_hbgl.Close();
			MessageBox("没有该航班!");
			OnClear(); 
			return ;
		}
		m_hbname=m_hbgl.m_column2;
		m_hbqsd=m_hbgl.m_column3;
		m_qssj=m_hbgl.m_column4;
		m_hbzdz=m_hbgl.m_column5;
		m_hbddsj=m_hbgl.m_column6;
        m_hbydc=m_hbgl.m_column7;
		m_zw1=m_hbgl.m_column9;
		m_hbedc=m_hbgl.m_column11;
		m_zw2=m_hbgl.m_column13;
		m_hbsdc=m_hbgl.m_column15;
		m_zw3=m_hbgl.m_column17;
		m_riqi=m_hbgl.m_column22;
		m_hbgl.Close();
    	UpdateData(FALSE);    
}

int CHbgldlg::Show()
{
	m_hbgl.Open();
	int i=0;
	m_hbgl.MoveFirst();
	do
	{
		m_hbgl.MoveNext();
		i++;
	}while(!m_hbgl.IsEOF());

	if(m_hbgl.IsOpen())m_hbgl.Close();
	m_hbCount=i;
	return i;
}
void CHbgldlg::OnAddbtn() //增加
{	
	UpdateData(TRUE);
	if(m_hbnum==""||m_hbname==""||m_hbqsd==""||m_qssj==""||m_hbzdz==""||m_hbddsj==""||m_hbydc==0||m_zw1==0||m_hbedc==0||m_zw2==0||m_hbsdc==0||m_zw3==0||m_riqi=="")
	{
		MessageBox("请检查你的输入项!");
		return ;
	}
		if(m_hbgl.IsOpen())m_hbgl.Close();
		m_hbgl.Open();
		m_hbgl.Requery();
		m_hbgl.AddNew();
		m_hbgl.m_column1=m_hbnum;
		m_hbgl.m_column2=m_hbname;
		m_hbgl.m_column3=m_hbqsd;
		m_hbgl.m_column4=m_qssj;
		m_hbgl.m_column5=m_hbzdz;
		m_hbgl.m_column6=m_hbddsj;
        m_hbgl.m_column7=m_hbydc;
		m_hbgl.m_column9=m_zw1;
		m_hbgl.m_column11=m_hbedc;
		m_hbgl.m_column13=m_zw2;
		m_hbgl.m_column15=m_hbsdc;
		m_hbgl.m_column17=m_zw3;
        m_hbgl.m_column22=m_riqi;
		m_hbgl.Update();
		m_hbgl.Close();
        m_hbCount++;
		MessageBox("成功插入!");
           OnClear() ;
		UpdateData(FALSE);
}
void CHbgldlg::OnEditbtn() //修改
{
	UpdateData(TRUE);
	if(m_hbnum==""||m_hbname==""||m_hbqsd==""||m_qssj==""||m_hbzdz==""||m_hbddsj==""||
		m_hbydc==0||m_zw1==0||m_hbedc==0||m_zw2==0||m_hbsdc==0||m_zw3==0||m_riqi=="")
	{
		MessageBox("请检查你的输入项!");
		return ;
	}
		if(m_hbgl.IsOpen())m_hbgl.Close();
		m_hbgl.Open();
		m_hbgl.Requery();
		m_hbgl.Edit();
		m_hbgl.m_column2=m_hbname;
		m_hbgl.m_column3=m_hbqsd;
		m_hbgl.m_column4=m_qssj;
		m_hbgl.m_column5=m_hbzdz;
		m_hbgl.m_column6=m_hbddsj;
        m_hbgl.m_column7=m_hbydc;
		m_hbgl.m_column11=m_hbedc;
		m_hbgl.m_column15=m_hbsdc;
		m_hbgl.m_column9=m_zw1;
		m_hbgl.m_column13=m_zw2;
		m_hbgl.m_column17=m_zw3;
        m_hbgl.m_column22=m_riqi;
		m_hbgl.Update();
		m_hbgl.Close();
		MessageBox("修改成功!");
		OnClear() ;
		UpdateData(FALSE);	
}
void CHbgldlg::OnDelbtn() 
{
	UpdateData(TRUE);
	if(m_hbgl.IsOpen())
		   m_hbgl.Close();
	   m_hbgl.Open();
	 if(m_hbnum=="") 
	 {
			MessageBox("请输入航班编号!");
			return ;
	 }
	 do
	 {
	    if(m_hbgl.m_column1== m_hbnum)
		{
	      m_hbgl.Delete();
		  m_hbCount--;	
		  m_hbgl.Requery();
		 break;
		}
		else
			m_hbgl.MoveNext();

	 }while(!m_hbgl.IsEOF());
	if(m_hbgl.IsEOF()&&m_hbCount==0)
	{
			MessageBox("没有该航班!");
			return ;
	}
	m_hbgl.Close();
	MessageBox("删除成功！");
	OnClear() ;
	UpdateData(FALSE);
}


BOOL CHbgldlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	Changban_Recordset m_hbgl(&theApp.m_DB);
	this->Show();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}


void CHbgldlg::OnClear() 
{

	   UpdateData(TRUE);
	    m_hbnum="";
		m_hbname="";
		m_hbqsd="";
		m_qssj="";
		m_hbzdz="";
		m_hbddsj="";
        m_hbydc=0;
		m_zw1=0;
		m_hbedc=0;
		m_zw2=0;
		m_hbsdc=0;
		m_zw3=0;
		m_riqi="";
		UpdateData(FALSE);
}

HBRUSH CHbgldlg::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;
}