khxxgldlg.cpp

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

// KHXXGLdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "KHXXGLdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CKHXXGLdlg dialog


CKHXXGLdlg::CKHXXGLdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CKHXXGLdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKHXXGLdlg)
	m_hbnum = _T("");
	m_ckname = _T("");
	m_ckid = _T("");
	m_ckzh = _T("");
	m_ckqsd = _T("");
	m_ckqssj = _T("");
	m_ckmdd = _T("");
	m_ckddsj = _T("");
	//}}AFX_DATA_INIT
}


void CKHXXGLdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CKHXXGLdlg)
	DDX_Text(pDX, IDC_EDIT1, m_hbnum);
	DDX_Text(pDX, IDC_EDIT3, m_ckname);
	DDX_Text(pDX, IDC_EDIT4, m_ckid);
	DDX_Text(pDX, IDC_EDIT10, m_ckzh);
	DDX_Text(pDX, IDC_EDIT2, m_ckqsd);
	DDX_Text(pDX, IDC_EDIT7, m_ckqssj);
	DDX_Text(pDX, IDC_EDIT5, m_ckmdd);
	DDX_Text(pDX, IDC_EDIT8, m_ckddsj);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKHXXGLdlg, CDialog)
	//{{AFX_MSG_MAP(CKHXXGLdlg)
	ON_BN_CLICKED(IDC_Ckfindbtn, OnCkfindbtn)
	ON_BN_CLICKED(IDC_ckaddbtn, Onckaddbtn)
	ON_BN_CLICKED(IDC_Ckxiugaibtn, OnCkxiugaibtn)
	ON_BN_CLICKED(IDC_Ckdelbtn, OnCkdelbtn)
	ON_BN_CLICKED(IDC_Ckclearbtn, OnCkclearbtn)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKHXXGLdlg message handlers

void CKHXXGLdlg::OnCkfindbtn() 
{
	UpdateData(TRUE);
	    //打开表 
		if(m_ck.IsOpen())m_ck.Close();
		m_ck.Open();

		if(m_hbnum=="") 
		{
			MessageBox("请输入航班编号!");
			return ;
		}
		m_ck.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
        m_ck.Requery();
		if(m_ck.IsEOF())
		{
			MessageBox("没有该航班!");
			m_ck.Close();
			OnCkclearbtn() ;
			return ;
		}
		m_hbnum=m_ck.m_column1;
		m_ckid=m_ck.m_column2;
		m_ckname=m_ck.m_column3;
		m_ckzh=m_ck.m_column4;
		m_ckqsd=m_ck.m_column5;
		m_ckqssj=m_ck.m_column6;
        m_ckmdd=m_ck.m_column7;
		m_ckddsj=m_ck.m_column8;
		m_ck.Close();
    	UpdateData(FALSE);   
	
}

void CKHXXGLdlg::Onckaddbtn() 
{
     UpdateData(TRUE);
	if(m_hbnum==""||m_ckid==""||m_ckname==""||m_ckzh==""||m_ckqsd==""||m_ckqssj=="" 
		||m_ckmdd==""||m_ckddsj=="")
	{
		MessageBox("请检查你的输入项!");
		return ;
	}
		if(m_ck.IsOpen())m_ck.Close();
		m_ck.Open();
		m_ck.Requery();
		m_ck.AddNew();
		m_ck.m_column1=m_hbnum;
		m_ck.m_column2=m_ckid;
		m_ck.m_column3=m_ckname;
		m_ck.m_column4=m_ckzh;
		m_ck.m_column5=m_ckqsd;
		m_ck.m_column6=m_ckqssj;
        m_ck.m_column7=m_ckmdd;
		m_ck.m_column8=m_ckddsj;
		m_ck.Update();
		m_ck.Close();
        m_ckCount++;
		MessageBox("成功插入!");
		OnCkclearbtn() ;
		UpdateData(FALSE);
}

void CKHXXGLdlg::OnCkxiugaibtn() 
{
    UpdateData(TRUE);
	if(m_hbnum==""||m_ckid==""||m_ckname==""||m_ckzh==""||m_ckqsd==""||m_ckqssj=="" 
		||m_ckmdd==""||m_ckddsj=="")
	{
		MessageBox("请检查你的输入项!");
		return ;
	}
		if(m_ck.IsOpen())m_ck.Close();
		m_ck.Open();
		m_ck.Requery();
		m_ck.Edit();
		//m_ck.m_column1=m_hbnum;
		m_ck.m_column2=m_ckid;
		m_ck.m_column3=m_ckname;
		m_ck.m_column4=m_ckzh;
		m_ck.m_column5=m_ckqsd;
		m_ck.m_column6=m_ckqssj;
        m_ck.m_column7=m_ckmdd;
		m_ck.m_column8=m_ckddsj;
		m_ck.Update();
		m_ck.Close();
		MessageBox("修改成功!");
		OnCkclearbtn() ;
		UpdateData(FALSE);
}

void CKHXXGLdlg::OnCkdelbtn() 
{
	UpdateData(TRUE);
	if(m_ck.IsOpen())
		   m_ck.Close();
	   m_ck.Open();
	 if(m_hbnum=="") 
	 {
			MessageBox("请输入航班编号!");
			return ;
	 }
	 do
	 {
	    if(m_ck.m_column1== m_hbnum)
		{
	      m_ck.Delete();
		  m_ckCount--;	
		  m_ck.Requery();
		 break;
		}
		else
			m_ck.MoveNext();

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

void CKHXXGLdlg::OnCkclearbtn() 
{
	UpdateData(TRUE);
		m_hbnum="";
		m_ckid="";
		m_ckname="";
		m_ckzh="";
		m_ckqsd="";
		m_ckqssj="";
        m_ckmdd="";
		m_ckddsj="";
	UpdateData(FALSE);
}

BOOL CKHXXGLdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CCK_Recordset m_ck(&theApp.m_DB);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

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

	if(m_ck.IsOpen())m_ck.Close();
	m_ckCount=i;
	return i;
	
}

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