spjzdlg.cpp

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

// spjzdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HKGL.h"
#include "spjzdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cspjzdlg dialog


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

void Cspjzdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cspjzdlg)
	DDX_Control(pDX, IDC_COMBO4, m_com3);
	DDX_Control(pDX, IDC_LIST2, m_hbcxList);
	DDX_Control(pDX, IDC_LIST1, m_spjzList);
	DDX_Control(pDX, IDC_COMBO1, m_com1);
	DDX_Control(pDX, IDC_COMBO2, m_com2);
	DDX_Text(pDX, IDC_EDIT1, m_find);
	DDX_Text(pDX, IDC_EDIT2, m_lrzcx);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(Cspjzdlg, CDialog)
	//{{AFX_MSG_MAP(Cspjzdlg)
	ON_BN_CLICKED(IDC_Findbtn, OnFindbtn)
	ON_BN_CLICKED(IDC_JZ, OnJz)
	ON_WM_TIMER()
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cspjzdlg message handlers

BOOL Cspjzdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CLilv_Recordset m_lr(&theApp.m_DB );
	Changban_Recordset m_hb(&theApp.m_DB );
	m_com1.SetCurSel(0);
	m_com2.SetCurSel(1);
	m_com3.SetCurSel(0);


	m_hbcxList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_spjzList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

	UpdateData(TRUE);
	int i=0;
	CODBCFieldInfo Info;
	m_lr.Open();
	for(i=0;i<m_lr.m_nFields;i++)
	{
		m_lr.GetODBCFieldInfo(i,Info);
		m_spjzList.InsertColumn(i,Info.m_strName,LVCFMT_LEFT,80);

	}
	m_lr.Close();

	m_hbcxList.InsertColumn(0,"航班编号",LVCFMT_LEFT,80);
   	m_hbcxList.InsertColumn(1,"航班名称",LVCFMT_LEFT,80);
	m_hbcxList.InsertColumn(2,"一等仓利润",LVCFMT_LEFT,100);
   	m_hbcxList.InsertColumn(3,"二等仓利润",LVCFMT_LEFT,100);
	m_hbcxList.InsertColumn(4,"三等仓利润",LVCFMT_LEFT,100);
   	m_hbcxList.InsertColumn(5,"开资",LVCFMT_LEFT,80);
	m_hbcxList.InsertColumn(6,"总利润",LVCFMT_LEFT,80);
   	m_hbcxList.InsertColumn(7,"日期",LVCFMT_LEFT,60);

	m_Fspjz=TRUE;
	this->Show();
	this->Show2();
	m_Fspjz=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 Cspjzdlg::Show()
{
	int i=0;
	if(m_Fspjz==TRUE)
		m_lr.Open();
	m_lr.MoveFirst();
	do
	{
		m_spjzList.InsertItem(i,m_lr.m_column1 );
		m_spjzList.SetItemText(i,1,m_lr.m_column2 );
		CString s;
		s.Format("%d",m_lr.m_column3 );
		m_spjzList.SetItemText(i,2,s);
		s.Format("%d",m_lr.m_column4 );
		m_spjzList.SetItemText(i,3,s );
		m_spjzList.SetItemText(i,4,m_lr.m_column5 );

		i++;
		m_lr.MoveNext();
	}while(!m_lr.IsEOF());
	m_lr.Close();
	return i;
}

int Cspjzdlg::Show2()
{
	int i=0;
	if(m_Fspjz==TRUE)m_hb.Open();
	m_hb.MoveFirst();
	do
	{
		m_hbcxList.InsertItem(i,m_hb.m_column1 );
		m_hbcxList.SetItemText(i,1,m_hb.m_column2 );
		CString s;
		s.Format("%d",m_hb.m_column10 );
		m_hbcxList.SetItemText(i,2,s );

		s.Format("%d",m_hb.m_column14);
		m_hbcxList.SetItemText(i,3,s );

		s.Format("%d",m_hb.m_column18 );
		m_hbcxList.SetItemText(i,4,s );

		s.Format("%d",m_hb.m_column20 );
		m_hbcxList.SetItemText(i,5,s );

		s.Format("%d",m_hb.m_column21);
		m_hbcxList.SetItemText(i,6,s );
    	m_hbcxList.SetItemText(i,7,m_hb.m_column22 );
		i++;
		m_hb.MoveNext();
	}while(!m_hb.IsEOF());
	m_hb.Close();
	return i;
}

void Cspjzdlg::OnFindbtn() 
{
	UpdateData(TRUE);
	m_com1.GetLBText(m_com1.GetCurSel(),m_comstr1);
	m_com2.GetLBText(m_com2.GetCurSel(),m_comstr2);
	find2();	
	find1();
}

void Cspjzdlg::OnJz() 
{
	UpdateData(TRUE);
	m_com3.GetLBText(m_com3.GetCurSel(),m_comstr3);
	if(m_lr.IsOpen())m_lr.Close();
	m_lr.Open();
	if(m_comstr3=="<=")
	{
		m_lr.m_strFilter.Format("[利润]<=%d",m_lrzcx);
		m_spjzList.DeleteAllItems();
	}
	else if(m_comstr3==">=")
	{
		m_lr.m_strFilter.Format("[利润]>=%d",m_lrzcx);
		m_spjzList.DeleteAllItems();
	}
	else
	{
		m_lr.m_strFilter.Format("[利润]=%d",m_lrzcx);
		m_spjzList.DeleteAllItems();
	}

	m_lr.Requery();
	if(m_lr.IsEOF())
	{
		m_lr.Close();
		MessageBox("找不到你要的信息!");
		return ;
	}
	else
		this->Show();	
}

void Cspjzdlg::find1()
{

	UpdateData(TRUE);
	if(m_hb.IsOpen())m_hb.Close();
	m_hb.Open();

	if(m_comstr1=="编号查询")
	{
		m_hb.m_strFilter.Format("[航班编号] LIKE '%%"+ m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}
	else if(m_comstr1=="名称查询")
	{
		m_hb.m_strFilter.Format("[航班姓名] LIKE '%%"+ m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}
	else if(m_comstr1=="终点站查询")
	{
		m_hb.m_strFilter.Format("[目的地] LIKE '%%"+ m_find+"%%'");
		m_hbcxList.DeleteAllItems();
	}

	else
	{
		m_hb.m_strFilter.Format("[时间]='"+ m_comstr2+"'");
		m_hbcxList.DeleteAllItems();
	}
	m_hb.Requery();
	if(m_hb.IsEOF())
	{
		m_hb.Close();
		AfxMessageBox("没有该时间航班!");
		return ;
	}
    else
		this->Show2();

	UpdateData(FALSE);
}

void Cspjzdlg::find2()
{
		m_spjzList.DeleteAllItems();
	if(m_lr.IsOpen())m_lr.Close();
	m_lr.Open();

	if(m_comstr1=="编号查询")
	{
		m_lr.m_strFilter.Format("[航班编号] LIKE '%%"+ m_find+"%%'");
		m_spjzList.DeleteAllItems();
	}
//	else if(m_comstr1=="名称查询")
//	{
//		m_lr.m_strFilter.Format("[航班姓名] LIKE '%%"+ m_find+"%%'");
//		m_spjzList.DeleteAllItems();
//	}
	else if(m_comstr1=="终点站查询")
	{
		m_lr.m_strFilter.Format("[目的地] LIKE '%%"+ m_find+"%%'");
		m_spjzList.DeleteAllItems();
	}

	else if(m_comstr1=="时间查询")
	{
		m_lr.m_strFilter.Format("[时间]='"+ m_comstr2+"'");
		m_spjzList.DeleteAllItems();
	}
	m_lr.Requery();
	if(m_lr.IsEOF())
	{
		m_lr.Close();
		//AfxMessageBox("没有该时间航班!");
		return ;
	}
    else
		this->Show();
}

void Cspjzdlg::OnTimer(UINT nIDEvent) 
{

	CTime t=CTime::GetCurrentTime();
	time=t.GetHour ();
	//PDjiezhang();///////////////////////////////////////////////?????????????????????
	////////////////////////////
	CString s;
	m_com1.GetLBText(m_com1.GetCurSel(),s);

	if(s=="时间查询")
	{
	    GetDlgItem(IDC_EDIT1)->EnableWindow(FALSE);
		m_com2.EnableWindow(TRUE);
	}
	else
	{
	    GetDlgItem(IDC_EDIT1)->EnableWindow(TRUE);
		m_com2.EnableWindow(FALSE);
	}
	CDialog::OnTimer(nIDEvent);
}

BOOL Cspjzdlg::PDjiezhang()
{
	UpdateData(TRUE);
	f1=FALSE;
	if(m_hb.IsOpen())m_hb.Close();
		m_hb.Open();
		m_hb.MoveFirst();
		do
		{	
			if(m_lr.IsOpen())m_lr.Close();	
			m_lr.Open();
			BOOL f=FALSE;
		    m_lr.MoveFirst();
			do
			{
				if(m_hb.m_column1==m_lr.m_column1 && m_hb.m_column22=="今天      ")
				{
					f=TRUE;	 	
					if(m_lr.m_column5!="已结")
					{
					//m_lr.Requery();
					m_lr.Edit();
					m_lr.m_column3=m_hb.m_column20;
					m_lr.m_column4+=m_hb.m_column21;
					m_lr.m_column5="已结";
					m_lr.Update();
					}
					//m_hb.Requery();
					m_hb.Edit();
					m_hb.m_column8=0;
					m_hb.m_column9=150;
					m_hb.m_column10=0;
					m_hb.m_column12=0;
					m_hb.m_column13=150;
					m_hb.m_column14=0;
					m_hb.m_column15=0;
					m_hb.m_column16=200;
					m_hb.m_column17=0;
					m_hb.m_column18=0;
					m_hb.m_column19=0;
					m_hb.m_column21=0;
					m_hb.Update();
				
				}
				m_lr.MoveNext();
			}while(!m_lr.IsEOF());
			m_lr.Close();
			if(f==FALSE &&  m_hb.m_column22=="今天      ")
			{
				if(m_lr.IsOpen())m_lr.Close();
				m_lr.Open();
				m_lr.Requery();
				m_lr.AddNew();
				m_lr.m_column1=m_hb.m_column1;
				m_lr.m_column2=m_hb.m_column22;
				m_lr.m_column3=m_hb.m_column20;
				m_lr.m_column4=m_hb.m_column21;
				m_lr.m_column5="已结";
				m_lr.Update();
				m_lr.Close();
					m_hb.Requery();
					m_hb.Edit();
					m_hb.m_column8=0;
					m_hb.m_column9=150;
					m_hb.m_column10=0;
					m_hb.m_column12=0;
					m_hb.m_column13=150;
					m_hb.m_column14=0;
					m_hb.m_column15=0;
					m_hb.m_column16=200;
					m_hb.m_column17=0;
					m_hb.m_column18=0;
					m_hb.m_column19=0;
					m_hb.m_column21=0;
					m_hb.Update();
			}
			m_hb.MoveNext();
		}while(!m_hb.IsEOF());
		m_hb.Close();
		if(m_lr.IsOpen())m_lr.Close();
		m_lr.Open();
		m_lr.MoveFirst();
		do
		{
		m_lr.Edit();
		m_lr.m_column5 ="否";
		m_lr.Update();
		m_lr.MoveNext();
		}while(!m_lr.IsEOF());
		m_lr.Close();
///////////////////////////////////////////////////////////////////
	/*	if(m_hb.IsOpen())m_hb.Close();
		m_hb.Open();
		m_hb.MoveFirst();
		do
		{

			if(m_hb.m_column22=="今天      ")
			{
				MessageBox("");
				m_hb.Edit();
				m_hb.m_column22="后天";
				m_hb.Update();
			}
			else if(m_hb.m_column22=="明天      ")
			{
				m_hb.Edit();
				m_hb.m_column22="今天";
				m_hb.Update();
			}
			else if(m_hb.m_column22=="后天      ")
			{
				m_hb.Edit();
				m_hb.m_column22="明天";
				m_hb.Update();
			}
			m_hb.MoveNext();
		}while(!m_hb.IsEOF());
		m_hb.Close();*/
		/////////////////////////////////////////////////////////////
		UpdateData(FALSE);
	return TRUE;
}
void Cspjzdlg::OnButton1() 
{
	UpdateData(TRUE);
	m_hbcxList.DeleteAllItems();
    m_spjzList.DeleteAllItems();
	PDjiezhang();
	if(m_hb.IsOpen())m_hb.Close();
	m_hb.Open();
	if(m_lr.IsOpen )m_lr.Close();
	m_lr.Open();
 	Show();	
	Show2();
	UpdateData(FALSE);
	
}
BOOL Cspjzdlg::PDjiezhang1()
{
	UpdateData(TRUE);
	f1=FALSE;
	if(time>=23)
	{
		if(m_hb.IsOpen())m_hb.Close();
		m_hb.Open();
		m_hb.MoveFirst();
		do
		{	
			if(m_lr.IsOpen())m_lr.Close();	
			m_lr.Open();
			BOOL f=FALSE;
		    m_lr.MoveFirst();
			do
			{
				if(m_hb.m_column1==m_lr.m_column1  && m_hb.m_column22=="今天      ")
				{
					f=TRUE;	 	
					if(m_lr.m_column5!="已结")
					{
					//m_lr.Requery();
					m_lr.Edit();
					m_lr.m_column3=m_hb.m_column20;
					m_lr.m_column4+=m_hb.m_column21;
					m_lr.m_column5="已结";
					m_lr.Update();
					}
					//m_hb.Requery();
					m_hb.Edit();
					m_hb.m_column8=0;
					m_hb.m_column9=150;
					m_hb.m_column10=0;
					m_hb.m_column12=0;
					m_hb.m_column13=150;
					m_hb.m_column14=0;
					m_hb.m_column15=0;
					m_hb.m_column16=200;
					m_hb.m_column17=0;
					m_hb.m_column18=0;
					m_hb.m_column19=0;
					m_hb.m_column21=0;
					m_hb.Update();
				}
				m_lr.MoveNext();
			}while(!m_lr.IsEOF());
			m_lr.Close();
			if(f==FALSE &&  m_hb.m_column22=="今天      ")
			{
				if(m_lr.IsOpen())m_lr.Close();
				m_lr.Open();
				m_lr.Requery();
				m_lr.AddNew();
				m_lr.m_column1=m_hb.m_column1;
				m_lr.m_column2=m_hb.m_column22;
				m_lr.m_column3=m_hb.m_column20;
				m_lr.m_column4=m_hb.m_column21;
				m_lr.m_column5="已结";
				m_lr.Update();
				m_lr.Close();
					m_hb.Requery();
					m_hb.Edit();
					m_hb.m_column8=0;
					m_hb.m_column9=150;
					m_hb.m_column10=0;
					m_hb.m_column12=0;
					m_hb.m_column13=150;
					m_hb.m_column14=0;
					m_hb.m_column15=0;
					m_hb.m_column16=200;
					m_hb.m_column17=0;
					m_hb.m_column18=0;
					m_hb.m_column19=0;
					m_hb.m_column21=0;
					m_hb.Update();
			}
			m_hb.MoveNext();
		}while(!m_hb.IsEOF());
		m_hb.Close();
		
	}
	if(time>=23)time=0;
	if(time>=0&& time<1)
	{
		if(m_lr.IsOpen())m_lr.Close();
		m_lr.Open();
		m_lr.MoveFirst();
		do
		{
		m_lr.Edit();
		m_lr.m_column5 ="否";
		m_lr.Update();
		m_lr.MoveNext();
		}while(!m_lr.IsEOF());
		m_lr.Close();


		if(m_hb.IsOpen())m_hb.Close();
		m_hb.Open();
		m_hb.MoveFirst();
		do
		{

			if(m_hb.m_column22=="今天      ")
			{
				m_hb.Edit();
				m_hb.m_column22=="后天";
				m_hb.Update();
			}
			else if(m_hb.m_column22=="明天      ")
			{
				m_hb.Edit();
				m_hb.m_column22=="今天";
				m_hb.Update();
			}
			else if(m_hb.m_column22=="后天      ")
			{
				m_hb.Edit();
				m_hb.m_column22=="明天";
				m_hb.Update();
			}
			m_hb.MoveNext();
		}while(!m_hb.IsEOF());
		m_hb.Close();

	}
		UpdateData(FALSE);
	return TRUE;
}