spdjdlg.cpp

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

// spdjdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "spdjdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cspdjdlg dialog


Cspdjdlg::Cspdjdlg(CWnd* pParent /*=NULL*/)
	: CDialog(Cspdjdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cspdjdlg)
	m_spfind = _T("");
	m_hbnum = _T("");
	m_ckname = _T("");
	m_ckid = _T("");
	m_dpzs = 0;
	m_spdj = 0;
	m_spysje = 0;
	m_spdjrtn = 2;
	m_hbyps = 0;
	m_zuohao1 = _T("");
	m_zuohao2 = _T("");
	//}}AFX_DATA_INIT
}


void Cspdjdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cspdjdlg)
	DDX_Control(pDX, IDC_COMBO1, m_dpshijian);
	DDX_Control(pDX, IDC_COMBO3, m_com2);
	DDX_Control(pDX, IDC_COMBO2, m_com1);
	DDX_Control(pDX, IDC_spdjList, m_spList);
	DDX_Text(pDX, IDC_EDIT6, m_spfind);
	DDX_Text(pDX, IDC_EDIT2, m_hbnum);
	DDX_Text(pDX, IDC_EDIT3, m_ckname);
	DDX_Text(pDX, IDC_EDIT4, m_ckid);
	DDX_Text(pDX, IDC_EDIT5, m_dpzs);
	DDX_Text(pDX, IDC_EDIT7, m_spdj);
	DDX_Text(pDX, IDC_EDIT8, m_spysje);
	DDX_Radio(pDX, IDC_RADIO1, m_spdjrtn);
	DDX_Text(pDX, IDC_EDIT12, m_hbyps);
	DDX_Text(pDX, IDC_EDIT10, m_zuohao1);
	DDX_Text(pDX, IDC_EDIT11, m_zuohao2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cspdjdlg, CDialog)
	//{{AFX_MSG_MAP(Cspdjdlg)
	ON_BN_CLICKED(IDC_BTNFIND, OnBtnfind)
	ON_WM_TIMER()
	ON_BN_CLICKED(IDC_dingpiaobtn, Ondingpiaobtn)
	ON_BN_CLICKED(IDC_dpjisuanbtn, Ondpjisuanbtn)
	ON_BN_CLICKED(IDC_Clearbtn, OnClearbtn)
	ON_BN_CLICKED(IDC_yupiaobtn, Onyupiaobtn)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cspdjdlg message handlers

void Cspdjdlg::OnBtnfind() 
{

	UpdateData(TRUE);

	m_com1.GetLBText(m_com1.GetCurSel(),m_strcm1);
	m_com2.GetLBText(m_com2.GetCurSel(),m_cm2);
	if(m_spHb.IsOpen())m_spHb.Close();
	m_spHb.Open();


	if(m_strcm1=="终点站查询")
	{
		m_spHb.m_strFilter.Format("[目的地] LIKE '%%"+ m_spfind+"%%'");
		m_spList.DeleteAllItems();
	}
	else if(m_strcm1=="时间查询")
	{
		m_spHb.m_strFilter.Format("[时间] = '"+ m_cm2+"'");
		m_spList.DeleteAllItems();
	}
	else if(m_strcm1=="编号查询")
	{
		m_spHb.m_strFilter.Format("[航班编号]  LIKE '%%"+ m_spfind+"%%'");
		m_spList.DeleteAllItems();
	}

	m_spHb.Requery();
	if(m_spHb.IsEOF())
	{
		m_spHb.Close();
		AfxMessageBox("没有该时间航班!");
		return ;
	}
	else
	{
		this->Show();
	}
}

BOOL Cspdjdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CCK_Recordset m_spCk(&theApp.m_DB );
	Changban_Recordset m_spHb(&theApp.m_DB);
	m_com1.SetCurSel(0);
	m_com2.SetCurSel(1);
	m_dpshijian.SetCurSel(1);
	m_spList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	UpdateData(TRUE);
	m_spList.InsertColumn(0,"航班编号",LVCFMT_LEFT,80);
   	m_spList.InsertColumn(1,"起始地",LVCFMT_LEFT,70);
	m_spList.InsertColumn(2,"起飞时间",LVCFMT_LEFT,80);
   	m_spList.InsertColumn(3,"目的地",LVCFMT_LEFT,70);
	m_spList.InsertColumn(4,"到达时间",LVCFMT_LEFT,80);
   	m_spList.InsertColumn(5,"一仓余票",LVCFMT_LEFT,80);
	m_spList.InsertColumn(6,"二仓余票",LVCFMT_LEFT,80);
   	m_spList.InsertColumn(7,"三仓余票",LVCFMT_LEFT,80);
   	m_spList.InsertColumn(8,"日期",LVCFMT_LEFT,60);
	m_Fsp=TRUE;
	this->Show();
	m_Fsp=FALSE;
	SetTimer(1,2,NULL);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

int Cspdjdlg::Show()
{

	int i=0;
	if(m_Fsp==TRUE)
		m_spHb.Open();
	m_spHb.MoveFirst();
	do
	{
		CString s;
		m_spList.InsertItem(i,m_spHb.m_column1 );
		m_spList.SetItemText(i,1,m_spHb.m_column3 );
		m_spList.SetItemText(i,2,m_spHb.m_column4 );
		m_spList.SetItemText(i,3,m_spHb.m_column5);
		m_spList.SetItemText(i,4,m_spHb.m_column6);
		s.Format("%d",m_spHb.m_column9);
		m_spList.SetItemText(i,5,s);
		s.Format("%d",m_spHb.m_column13);
		m_spList.SetItemText(i,6,s);
		s.Format("%d",m_spHb.m_column17);
		m_spList.SetItemText(i,7,s);
		m_spList.SetItemText(i,8,m_spHb.m_column22);
		i++;
		m_spHb.MoveNext();
	}while(!m_spHb.IsEOF());
	m_spHb.Close();
     
	return i;
}

void Cspdjdlg::OnTimer(UINT nIDEvent) 
{

	CString s;
	m_com1.GetLBText(m_com1.GetCurSel(),s);
	if(s=="时间查询")
	{
        GetDlgItem(IDC_EDIT6)->EnableWindow(FALSE);
		m_com2.EnableWindow(TRUE);//GetDlgItem(IDC_COMBO2)->EnableWindow(TRUE);
	}
	else
	{
		m_com2.EnableWindow(FALSE);
        GetDlgItem(IDC_EDIT6)->EnableWindow(TRUE);
	}
	
	CDialog::OnTimer(nIDEvent);
}

void Cspdjdlg::Ondingpiaobtn() 
{

	UpdateData(TRUE);
	m_dpshijian.GetLBText(m_dpshijian.GetCurSel(),m_dpgetshijianstr);
	if(m_hbnum==""||m_ckname==""||m_ckid==""||m_dpzs==0)
	{
		MessageBox("请检查你的输入项!");
		return ;
	}
	if(m_spHb.IsOpen())m_spHb.Close();
	m_spHb.Open ();
	m_spHb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"' and [时间]='"+m_dpgetshijianstr+"'");
	m_spHb.Requery();
	
	////////
 	if(m_spHb.IsEOF())
	{
			MessageBox("没有该航班!");
			m_spHb.Close();
			Clear();
			return ;
	}
	else
	{
	 	if(m_spdjrtn==0)
		{

		if(m_spHb.m_column9==0)
			{
				m_spHb.Close();
				MessageBox("该仓一满!");
				return ;
			}
			else if(m_dpzs>m_spHb.m_column9)
			{
				m_spHb.Close();
				MessageBox("定票过多超出!");
				return ;
			}
			else
			{
				m_spHb.Edit();
				CString s;
				s.Format("%d",m_spHb.m_column8+1);
				m_zuohao1=s;
				s.Format("%d",m_spHb.m_column8+m_dpzs);
				m_zuohao2=s;
				m_spdj=m_spHb.m_column7;
				m_spysje=m_spHb.m_column7*m_dpzs;
				m_spHb.m_column8+=m_dpzs;
				m_spHb.m_column9-=m_dpzs;
				m_hbyps=m_spHb.m_column9;

				m_spHb.m_column10+=m_spysje;
				m_spHb.m_column19+=m_spysje;
				m_spHb.m_column21=m_spHb.m_column19-m_spHb.m_column20;

				m_spHb.Update();
				m_spHb.Close();
				if(m_spCk.IsOpen()) m_spCk.Close();
				m_spCk.Open();

            	if(m_spHb.IsOpen())m_spHb.Close();
	            m_spHb.Open ();
				m_spHb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
	            m_spHb.Requery();

				m_spCk.Requery();
				m_spCk.AddNew();
				m_spCk.m_column1=m_spHb.m_column1 ;
				m_spCk.m_column2=m_ckid;
                m_spCk.m_column3=m_ckname;
				m_spCk.m_column4="A"+m_zuohao1+"-"+m_zuohao2;
				m_spCk.m_column5=m_spHb.m_column3;
				m_spCk.m_column6=m_spHb.m_column4;
				m_spCk.m_column7=m_spHb.m_column5;
				m_spCk.m_column8=m_spHb.m_column6;
				m_spCk.m_column9=m_dpgetshijianstr;
				m_spCk.Update();
                m_spCk.Close();

				m_spHb.Close();
				MessageBox("确定!");
             	UpdateData(FALSE);
			}	
		}
		else if(m_spdjrtn==1)
		{
	    	if(m_spHb.m_column13==0)
			{
				m_spHb.Close();
				MessageBox("该仓一满!");
				return ;
			}
			else if(m_dpzs>m_spHb.m_column13)
			{
				m_spHb.Close();
				MessageBox("定票过多超出!");
				return ;
			}
			else
			{
				m_spHb.Edit();
				CString s;
				s.Format("%d",m_spHb.m_column12+1);
				m_zuohao1=s;
				s.Format("%d",m_spHb.m_column12+m_dpzs);
				m_zuohao2=s;
				m_spdj=m_spHb.m_column11;
				m_spysje=m_spHb.m_column11*m_dpzs;
				m_spHb.m_column12+=m_dpzs;
				m_spHb.m_column13-=m_dpzs;
				m_hbyps=m_spHb.m_column13;
				m_spHb.m_column14+=m_spysje;
				m_spHb.m_column19+=m_spysje;
				m_spHb.m_column21=m_spHb.m_column19-m_spHb.m_column20;
				m_spHb.Update();
				m_spHb.Close();
				if(m_spCk.IsOpen()) m_spCk.Close();
				m_spCk.Open();
            	if(m_spHb.IsOpen())m_spHb.Close();
	            m_spHb.Open ();
				m_spHb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
	            m_spHb.Requery();
				m_spCk.Requery();
				m_spCk.AddNew();
				m_spCk.m_column1=m_spHb.m_column1 ;
				m_spCk.m_column2=m_ckid;
                m_spCk.m_column3=m_ckname;
				m_spCk.m_column4="B"+m_zuohao1+"-"+m_zuohao2;
				m_spCk.m_column5=m_spHb.m_column3;
				m_spCk.m_column6=m_spHb.m_column4;
				m_spCk.m_column7=m_spHb.m_column5;
				m_spCk.m_column8=m_spHb.m_column6;
				m_spCk.m_column9=m_dpgetshijianstr;
				m_spCk.Update();
                m_spCk.Close();
				m_spHb.Close();
				MessageBox("确定!");
             	UpdateData(FALSE);
			}
		}
		else if(m_spdjrtn==2)
		{
		if(m_spHb.m_column17==0)
			{
				m_spHb.Close();
				MessageBox("该仓一满!");
				return ;
			}
			else if(m_dpzs>m_spHb.m_column17)
			{
				m_spHb.Close();
				MessageBox("定票过多超出!");
				return ;
			}
			else
			{
				m_spHb.Edit();
				CString s;
				s.Format("%d",m_spHb.m_column16+1);
				m_zuohao1=s;
				s.Format("%d",m_spHb.m_column16+m_dpzs);
				m_zuohao2=s;
				m_spdj=m_spHb.m_column15;
				m_spysje=m_spHb.m_column15*m_dpzs;
				MessageBox("a");
				m_spHb.m_column16+=m_dpzs;
				m_spHb.m_column17-=m_dpzs;
				m_hbyps=m_spHb.m_column17;
				m_spHb.m_column18+=m_spysje;
				m_spHb.m_column19+=m_spysje;
				m_spHb.m_column21=m_spHb.m_column19-m_spHb.m_column20;
				m_spHb.Update();
				m_spHb.Close();
				if(m_spCk.IsOpen()) m_spCk.Close();
				m_spCk.Open();
            	if(m_spHb.IsOpen())m_spHb.Close();
	            m_spHb.Open ();
				m_spHb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
	            m_spHb.Requery();
				m_spCk.Requery();
				m_spCk.AddNew();
				m_spCk.m_column1=m_spHb.m_column1 ;
				m_spCk.m_column2=m_ckid;
                m_spCk.m_column3=m_ckname;
				m_spCk.m_column4="C"+m_zuohao1+"-"+m_zuohao2;
				m_spCk.m_column5=m_spHb.m_column3;
				m_spCk.m_column6=m_spHb.m_column4;
				m_spCk.m_column7=m_spHb.m_column5;
				m_spCk.m_column8=m_spHb.m_column6;
				m_spCk.m_column9=m_dpgetshijianstr;
				m_spCk.Update();
                m_spCk.Close();
				m_spHb.Close();
				MessageBox("确定!");
             	UpdateData(FALSE);
			}
		}
	}
}
void Cspdjdlg::Clear()
{
	UpdateData(TRUE);
       m_hbnum="";
	   m_ckname="";
	   m_ckid="";
	   m_dpzs=0;
	UpdateData(FALSE);
}

void Cspdjdlg::Ondpjisuanbtn() 
{
	UpdateData(TRUE);
	if(m_hbnum==""||m_ckname==""||m_ckid==""||m_dpzs==0)
	{
		MessageBox("请检查你的输入项!");
		return ;
	}
	if(m_spHb.IsOpen())m_spHb.Close();
	m_spHb.Open ();
	m_spHb.m_strFilter.Format("[航班编号]='"+ m_hbnum+"'");
	m_spHb.Requery();

 	if(m_spHb.IsEOF())
	{
			MessageBox("没有该航班!");
			m_spHb.Close();
			Clear();
			return ;
	}
	else
	{
	 	if(m_spdjrtn==0)
		{

		if(m_spHb.m_column9==0)
			{
				m_spHb.Close();
				MessageBox("该仓一满!");
				return ;
			}
			else if(m_dpzs>m_spHb.m_column9)
			{
				m_spHb.Close();
				MessageBox("定票过多超出!");
				return ;
			}
			else
			{
				m_spHb.Edit();
				CString s;
				s.Format("%d",m_spHb.m_column8+1);
				m_zuohao1=s;
				s.Format("%d",m_spHb.m_column8+m_dpzs);
				m_zuohao2=s;
				m_spdj=m_spHb.m_column7;
				m_spysje=m_spHb.m_column7*m_dpzs;
				m_spHb.m_column8+=m_dpzs;
				m_spHb.m_column9-=m_dpzs;
				m_hbyps=m_spHb.m_column9;

				m_spHb.Close();
             	UpdateData(FALSE);
			}	
		}
		else if(m_spdjrtn==1)
		{
		if(m_spHb.m_column13==0)
			{
				m_spHb.Close();
				MessageBox("该仓一满!");
				return ;
			}
			else if(m_dpzs>m_spHb.m_column13)
			{
				m_spHb.Close();
				MessageBox("定票过多超出!");
				return ;
			}
			else
			{
				m_spHb.Edit();
				CString s;
				s.Format("%d",m_spHb.m_column12+1);
				m_zuohao1=s;
				s.Format("%d",m_spHb.m_column12+m_dpzs);
				m_zuohao2=s;
				m_spdj=m_spHb.m_column11;
				m_spysje=m_spHb.m_column11*m_dpzs;
				m_spHb.m_column12+=m_dpzs;
				m_spHb.m_column13-=m_dpzs;
				m_hbyps=m_spHb.m_column13;
				m_spHb.Close();
             	UpdateData(FALSE);
			}
		}
		else if(m_spdjrtn==2)
		{
		if(m_spHb.m_column17==0)
			{
				m_spHb.Close();
				MessageBox("该仓一满!");
				return ;
			}
			else if(m_dpzs>m_spHb.m_column17)
			{
				m_spHb.Close();
				MessageBox("定票过多超出!");
				return ;
			}
			else
			{
				m_spHb.Edit();
				CString s;
				s.Format("%d",m_spHb.m_column16+1);
				m_zuohao1=s;
				s.Format("%d",m_spHb.m_column16+m_dpzs);
				m_zuohao2=s;
				m_spdj=m_spHb.m_column15;
				m_spysje=m_spHb.m_column11*m_dpzs;
				m_spHb.m_column16+=m_dpzs;
				m_spHb.m_column17-=m_dpzs;
				m_hbyps=m_spHb.m_column17;
				m_spHb.Close();
             	UpdateData(FALSE);
			}
		}
	}
}
void Cspdjdlg::OnClearbtn() 
{
	Clear();
}

void Cspdjdlg::Onyupiaobtn() 
{
	Ctuipiaodjdlg dlg;
	dlg.DoModal();
}