flightdlg.cpp

利用odbc编程实现以下功能： 航班

// flightdlg.cpp : implementation file
//

#include "stdafx.h"
#include "dbexe.h"
#include "flightdlg.h"
#include "flightset.h"
#include "flightadddlg.h"
#include "reservedlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// Cflightdlg dialog


Cflightdlg::Cflightdlg(CWnd* pParent /*=NULL*/)
	: CDialog(Cflightdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cflightdlg)
	m_field = _T("");
	m_relation = _T("");
	m_content = _T("");
	//}}AFX_DATA_INIT
}


void Cflightdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cflightdlg)
	DDX_Control(pDX, IDC_LIST1, m_basic);
	DDX_CBString(pDX, IDC_COMBO1, m_field);
	DDX_CBString(pDX, IDC_COMBO2, m_relation);
	DDX_CBString(pDX, IDC_COMBO3, m_content);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cflightdlg, CDialog)
	//{{AFX_MSG_MAP(Cflightdlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_UPDATA, OnUpdata)
	ON_BN_CLICKED(IDC_SELECT, OnSelect)
	ON_BN_CLICKED(IDC_RESERVE, OnReserve)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cflightdlg message handlers
 
BOOL Cflightdlg::OnInitDialog(void){
	CDialog::OnInitDialog();
	m_basic.InsertColumn(0,"航班号");
    m_basic.InsertColumn(1,"价格");
	m_basic.InsertColumn(2,"总座位数");
	m_basic.InsertColumn(3,"剩余座位数");
	m_basic.InsertColumn(4,"始发点");
	m_basic.InsertColumn(5,"终点");
	RECT rectbasic;
	m_basic.GetWindowRect(&rectbasic);
	int widbasic=rectbasic.right-rectbasic.left;
	m_basic.SetColumnWidth(0,widbasic/8);
	m_basic.SetColumnWidth(1,widbasic/8);
	m_basic.SetColumnWidth(2,widbasic/8);
	m_basic.SetColumnWidth(3,widbasic/8);
	m_basic.SetColumnWidth(4,widbasic/8);
	m_basic.SetColumnWidth(5,widbasic/8);
	m_basic.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	p_query.Format("select* from flights");
	RefreshData();
	return true;
}

void Cflightdlg::RefreshData()
{
if(!m_database.IsOpen()){
		m_database.Open(_T("database1"));
}
m_basic.DeleteAllItems();
Cflightset m_basicset(&m_database);
CString strsql;
m_basicset.Open(AFX_DB_USE_DEFAULT_TYPE,p_query);
CDBVariant varValue;
if(m_basicset.GetRecordCount()!=0)
  m_basicset.MoveFirst();
else MessageBox("没有您需要的内容");
    char buf[20];
    int i=0;
	while(!m_basicset.IsEOF())
	{int temp=0;
		m_basicset.GetFieldValue(temp,varValue);
		m_basic.InsertItem(i,varValue.m_pstring->GetBuffer(1));//插入元组
		m_basicset.GetFieldValue(1,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_basic.SetItemText(i,1,buf);
		m_basicset.GetFieldValue(2,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_basic.SetItemText(i,2,buf);
		m_basicset.GetFieldValue(3,varValue);
		sprintf(buf,"%d",varValue.m_lVal); m_basic.SetItemText(i,3,buf);
		m_basicset.GetFieldValue(4,varValue);
		m_basic.SetItemText(i,4,varValue.m_pstring->GetBuffer(1));
		m_basicset.GetFieldValue(5,varValue);
		m_basic.SetItemText(i,5,varValue.m_pstring->GetBuffer(1));
		m_basicset.MoveNext();
		i++;
	}
}


void Cflightdlg::OnButton1() 
{
        int i=m_basic.GetHotItem();
		CString strSQL;
		if(i==-1){
			MessageBox("please choose a record first!");
		}
		else{
			CString keyid=m_basic.GetItemText(i,0);
			strSQL.Format("delete from flights where flightnum='"+keyid+"'");//删除元组
			m_database.ExecuteSQL(strSQL);
			m_database.Close();
			RefreshData();
		}// TODO: Add your control notification handler code here
	
}

void Cflightdlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int i=m_basic.GetSelectionMark();
	CString strSQL;
	if(i==-1){
		MessageBox("please choose a record first!");
	}
	else{
		flight_id=m_basic.GetItemText(i,0);
		m_basic.SetHotItem(i);
//		RefreshData();
	}	
//	*pResult = 0;
}

void Cflightdlg::OnButton2() 
{   m_database.Close();
	Cflightadddlg m_flightadd;
	m_flightadd.updateflag=0;
	m_flightadd.DoModal();
	RefreshData();
	// TODO: Add your control notification handler code here
	
}

void Cflightdlg::OnUpdata() 
{
	// TODO: Add your control notification handler code here
	int i=m_basic.GetHotItem();
	if(i==-1){
			MessageBox("please choose a record first!");
		}
	else{
	CString strSQL;
	Cflightadddlg m_flightadd;
    m_flightadd.m_flightnum=m_basic.GetItemText(i,0);
	m_flightadd.m_price=atoi(m_basic.GetItemText(i,1));
	m_flightadd.m_seatnum=atoi(m_basic.GetItemText(i,2));
    m_flightadd.m_seatavl=atoi(m_basic.GetItemText(i,3));
	m_flightadd.m_fromadd=m_basic.GetItemText(i,4);
    m_flightadd.m_toadd=m_basic.GetItemText(i,5);
	m_flightadd.updateflag=1;
    strSQL.Format("delete from flights where flightnum='"+m_flightadd.m_flightnum+"'");
    m_database.ExecuteSQL(strSQL);
    m_flightadd.DoModal();
	Sleep(500);
	RefreshData();
	}
}

void Cflightdlg::OnSelect() 
{
	// TODO: Add your control notification handler code here
    UpdateData(TRUE);
	CString m_realfield;
	if(!m_field.Compare("航班号")){
		m_realfield.Format("flightnum");
		p_query.Format("select * from flights where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	if(!m_field.Compare("价格")){
		m_realfield.Format("price");
		p_query.Format("select * from flights where %s%s%d",m_realfield,m_relation,atoi(m_content));
	}
	if(!m_field.Compare("总座位数")){
		
		m_realfield.Format("numseats");
		p_query.Format("select * from flights where %s%s%d",m_realfield,m_relation,atoi(m_content));
	}
	if(!m_field.Compare("剩余座位数")){
		
		m_realfield.Format("numavail");
		p_query.Format("select * from flights where %s%s%d",m_realfield,m_relation,atoi(m_content));
	}
	if(!m_field.Compare("始发站")){
		
		m_realfield.Format("fromcity");
		p_query.Format("select * from flights where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	if(!m_field.Compare("终点")){
		
		m_realfield.Format("arivcity");
		p_query.Format("select * from flights where %s%s'%s'",m_realfield,m_relation,m_content);
	}
	RefreshData();
}

void Cflightdlg::OnReserve() 
{
	Creservedlg m_reserve;
	int i=m_basic.GetHotItem();
	if(i==-1){
			MessageBox("please choose a record first!");
		}
	else{
	m_reserve.customname=customname;
	m_reserve.reservetype=1;
	m_reserve.reservekey=m_basic.GetItemText(i,0);
	CString strsql;
	strsql.Format("delete from flights where flightnum='"+m_reserve.reservekey+"'");
	if(!m_database.IsOpen()){
		m_database.Open(_T("database1"));
	}
	m_database.ExecuteSQL(strsql);
	int newnumavail=atoi(m_basic.GetItemText(i,3))-1;
	strsql.Format("insert into flights values(\'%s\',%d,%d,%d,\'%s\',\'%s\')",m_basic.GetItemText(i,0),atoi(m_basic.GetItemText(i,1)),atoi(m_basic.GetItemText(i,2)),newnumavail,m_basic.GetItemText(i,4),m_basic.GetItemText(i,5));
	m_database.ExecuteSQL(strsql);
	RefreshData();
	m_reserve.insert();
	MessageBox("您已经预定了一班飞机,若想取消您的预定内容,请到预定信息栏中取消");
	}
}

void Cflightdlg::unreserve()
{
if(!m_database.IsOpen()){
		m_database.Open(_T("database1"));
	}
//strsql.Format("update cars set numavail=%d where location='"+key+"'",numavail+1);
Cflightset m_basicset(&m_database);
CString strsql;
p_query.Format("select * from flights where flightnum='"+key+"'");
m_basicset.Open(AFX_DB_USE_DEFAULT_TYPE,p_query);
CDBVariant varValue;
m_basicset.MoveFirst();
         int temp=0;
		m_basicset.GetFieldValue(temp,varValue);
	    CString flightnum=varValue.m_pstring->GetBuffer(1);//
		m_basicset.GetFieldValue(1,varValue);
		int price=varValue.m_lVal;
		m_basicset.GetFieldValue(2,varValue);
		int seatnum=varValue.m_lVal;
		m_basicset.GetFieldValue(3,varValue);
		int numavail=varValue.m_lVal+1;
		m_basicset.GetFieldValue(4,varValue);
	    CString fromaddr=varValue.m_pstring->GetBuffer(1);
		m_basicset.GetFieldValue(5,varValue);
	    CString arivaddr=varValue.m_pstring->GetBuffer(1);
		
strsql.Format("delete from flights where flightnum='%s'",key);
m_database.ExecuteSQL(strsql);
strsql.Format("insert into flights values(\'%s\',%d,%d,%d,\'%s\',\'%s\')",flightnum,price,seatnum,numavail,fromaddr,arivaddr);
m_database.ExecuteSQL(strsql);
}

void Cflightdlg::OnButton3() 
{
CDialog::OnCancel();	// TODO: Add your control notification handler code here
	
}