bussettingview.cpp

汽车站售票管理系统,源代码完整无错

// BussettingView.cpp : implementation file
//

#include "stdafx.h"
#include "StationManage.h"
#include "BussettingView.h"
#include "BustypeSet.h"
#include "DriverSet.h"
#include "RouteSet.h"
#include "SeattypeSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBussettingView

IMPLEMENT_DYNCREATE(CBussettingView, CRecordView)

CBussettingView::CBussettingView()
	: CRecordView(CBussettingView::IDD)
{
	//{{AFX_DATA_INIT(CBussettingView)
	m_pSet = NULL;
	m_busno = _T("");
	m_seattotal = 0;
	//}}AFX_DATA_INIT
}

CBussettingView::~CBussettingView()
{
	if (!((CStationManageApp*)AfxGetApp())->m_bussettingcontrol)
	{
		((CStationManageApp*)AfxGetApp())->m_bussetting=0;
	}
	if (m_pSet)
		delete m_pSet;
}

void CBussettingView::DoDataExchange(CDataExchange* pDX)
{
	CRecordView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBussettingView)
	DDX_Control(pDX, IDC_SEATTYPE, m_seattype);
	DDX_Control(pDX, IDC_ROUTEID, m_routeid);
	DDX_Control(pDX, IDC_DRIVER, m_driver);
	DDX_Control(pDX, IDC_COMPANY, m_company);
	DDX_Control(pDX, IDC_BUSTYPE, m_bustype);
	DDX_Control(pDX, IDC_LIST, m_list);
	DDX_Text(pDX, IDC_BUSNO, m_busno);
	DDX_Text(pDX, IDC_SEATTOTAL, m_seattotal);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBussettingView, CRecordView)
	//{{AFX_MSG_MAP(CBussettingView)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_CHANGE, OnChange)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_SAVE, OnSave)
	ON_BN_CLICKED(IDC_RETURN, OnReturn)
	ON_BN_CLICKED(IDC_REFURBISH, OnRefurbish)
	ON_NOTIFY(NM_CLICK, IDC_LIST, OnClickList)
	ON_CBN_CLOSEUP(IDC_BUSTYPE, OnCloseupBustype)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBussettingView diagnostics

#ifdef _DEBUG
void CBussettingView::AssertValid() const
{
	CRecordView::AssertValid();
}

void CBussettingView::Dump(CDumpContext& dc) const
{
	CRecordView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CBussettingView message handlers

CRecordset* CBussettingView::OnGetRecordset()
{
	if (m_pSet != NULL)
		return m_pSet;

	m_pSet = new CBusset(NULL);
	m_pSet->Open();

	return m_pSet;
}

CBusset* CBussettingView::GetRecordset()
{
	CBusset* pData = (CBusset*) OnGetRecordset();
	ASSERT(pData == NULL || pData->IsKindOf(RUNTIME_CLASS(CBusset)));
	return pData;
}

void CBussettingView::OnInitialUpdate()
{
	BeginWaitCursor();
	GetRecordset();
	CRecordView::OnInitialUpdate();
	GetDocument()->SetTitle("车辆设置");
	GetParent()->SetWindowText("车辆设置");
	EndWaitCursor();
	EnableView(TRUE);
	RECT rectlist;
	m_list.GetWindowRect(&rectlist);
	int listwidth=rectlist.right-rectlist.left;
	DWORD dwExtendedStyle=LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE | LVS_EX_FULLROWSELECT;
	m_list.SetExtendedStyle(dwExtendedStyle);
	m_list.InsertColumn(0,"车牌",LVCFMT_LEFT,listwidth/7);
	m_list.InsertColumn(1,"车型",LVCFMT_LEFT,listwidth/7);
	m_list.InsertColumn(2,"座位",LVCFMT_LEFT,listwidth/7);	
	m_list.InsertColumn(3,"座位类型",LVCFMT_LEFT,listwidth/7);
	m_list.InsertColumn(4,"司机",LVCFMT_LEFT,listwidth/7-5);
	m_list.InsertColumn(5,"公司",LVCFMT_LEFT,listwidth/7-5);
	m_list.InsertColumn(6,"路线",LVCFMT_LEFT,listwidth/7-5);
	Showlist();
	curiItem = -1;
	operation = 0;
	m_list.SetItemState(0,LVIS_SELECTED,LVIS_SELECTED);
	m_busno = m_list.GetItemText(0,0);
	m_bustype.SelectString(0,m_list.GetItemText(0,1));
	m_seattotal=atoi(m_list.GetItemText(0,2));

	m_driver.SelectString(0,m_list.GetItemText(0,4));
	m_company.SelectString(0,m_list.GetItemText(0,5));
	m_pSet->MoveFirst();
	CString idinfo;
	idinfo.Format("%d",m_pSet->m_route_id);
	m_routeid.SelectString(0,idinfo);
	UpdateData(FALSE);
	CBustypeSet bustypeset;
	bustypeset.Open();
	while (!bustypeset.IsEOF())
	{
		bustypeset.m_bustype.TrimRight();
		m_bustype.AddString(bustypeset.m_bustype);
		bustypeset.MoveNext();
	}
	bustypeset.Close();
	CDriverSet driverset;
	driverset.Open();
	while (!driverset.IsEOF())
	{
		driverset.m_drivername.TrimRight();
		m_driver.AddString(driverset.m_drivername);
		driverset.MoveNext();
	}
	driverset.Close();
	m_pSet->MoveFirst();
	while (!m_pSet->IsEOF())
	{
		m_pSet->m_company.TrimRight();
		m_company.AddString(m_pSet->m_company);
		m_pSet->MoveNext();
	}
	CRouteSet routeset;
	routeset.Open();
	routeset.MoveFirst();
	while(!routeset.IsEOF())
	{
		CString info;
		info.Format("%d",routeset.m_route_id);
		m_routeid.AddString(info);
		routeset.MoveNext();
	}
	routeset.Close();
	CSeattypeSet seattypeset;
	seattypeset.Open();
	seattypeset.MoveFirst();
	while (!seattypeset.IsEOF())
	{
		seattypeset.m_type.TrimRight();
		m_seattype.AddString(seattypeset.m_type);
		seattypeset.MoveNext();
	}
	seattypeset.Close();

}

void CBussettingView::OnClickList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;  
	curiItem = pNMListView->iItem;
	if(curiItem != -1)   
	{   
		EnableView(true);
		operation=0;     //0确认不可用,1可增加数据,2为可修改数据
		Getvalue();
	}
	UpdateData(FALSE);
	*pResult = 0;
}

void CBussettingView::EnableView(bool b)
{
	GetDlgItem(IDC_ADD)->EnableWindow(b);
	GetDlgItem(IDC_CHANGE)->EnableWindow(b);
	GetDlgItem(IDC_DELETE)->EnableWindow(b);
	GetDlgItem(IDC_SAVE)->EnableWindow(!b);
	GetDlgItem(IDC_RETURN)->EnableWindow(!b);
	GetDlgItem(IDC_BUSNO)->EnableWindow(!b);
	GetDlgItem(IDC_BUSTYPE)->EnableWindow(!b);
	GetDlgItem(IDC_SEATTYPE)->EnableWindow(!b);
	GetDlgItem(IDC_DRIVER)->EnableWindow(!b);
	GetDlgItem(IDC_COMPANY)->EnableWindow(!b);
	GetDlgItem(IDC_ROUTEID)->EnableWindow(!b);
	UpdateData(FALSE);
}

void CBussettingView::Showlist()
{
	CBustypeSet bustypeset;	
	CDriverSet driverset;
	CRouteSet routeset;
	if (m_pSet->IsOpen())
	{
		m_pSet->Close();
	}	
	m_pSet->Open();
	m_list.DeleteAllItems();
	m_pSet->MoveFirst();
	if (!m_pSet->IsEOF())
	{
		while(!m_pSet->IsEOF())
			m_pSet->MoveNext();
		int cout=m_pSet->GetRecordCount();
		m_pSet->MoveFirst();
		while(!m_pSet->IsEOF())
		{	
			CString strValue;
			int nCount=m_list.GetItemCount();
			m_list.InsertItem(nCount,strValue);
			m_pSet->m_busnumber.TrimRight();
			m_list.SetItemText(nCount,0,m_pSet->m_busnumber);
			bustypeset.Open();
			bustypeset.MoveFirst();
			while(!bustypeset.IsEOF())
			{
				if (bustypeset.m_bustype_id == m_pSet->m_bustype)
				{
					bustypeset.m_bustype.TrimRight();
					break;
				}
				bustypeset.MoveNext();
			}
			m_list.SetItemText(nCount,1,bustypeset.m_bustype);			
			strValue.Format("%d",bustypeset.m_seat_total);			
			m_list.SetItemText(nCount,2,strValue);
			bustypeset.Close();

			CSeattypeSet seattypeset;
			seattypeset.Open();
			seattypeset.MoveFirst();
			while (!seattypeset.IsEOF())
			{
				if (seattypeset.m_type_id == m_pSet->m_seattype)
				{
					seattypeset.m_type.TrimRight();
					break;
				}
				seattypeset.MoveNext();
			}
			m_list.SetItemText(nCount,3,seattypeset.m_type);
			seattypeset.Close();
			driverset.Open();
			driverset.MoveFirst();
			while(!driverset.IsEOF())
			{
				if (driverset.m_driverid == m_pSet->m_driverid)
				{
					driverset.m_drivername.TrimRight();
					break;
				}
				driverset.MoveNext();
			}
			m_list.SetItemText(nCount,4,driverset.m_drivername);
			driverset.Close();
			m_pSet->m_company.TrimRight();
			m_list.SetItemText(nCount,5,m_pSet->m_company);

			routeset.Open();
			routeset.MoveFirst();
			while(!routeset.IsEOF())
			{
				if (routeset.m_route_id == m_pSet->m_route_id)
				{
					routeset.m_route.TrimRight();
					break;
				}
				routeset.MoveNext();
			}
			m_list.SetItemText(nCount,6,routeset.m_route);
			routeset.Close();
			m_pSet->MoveNext();
		}
	}
}

void CBussettingView::Getvalue()
{
	m_busno = m_list.GetItemText(curiItem,0);
	m_bustype.SelectString(0,m_list.GetItemText(curiItem,1));
	m_seattotal=atoi(m_list.GetItemText(curiItem,2));
	m_seattype.SelectString(0,m_list.GetItemText(curiItem,3));
	m_driver.SelectString(0,m_list.GetItemText(curiItem,4));
	m_company.SelectString(0,m_list.GetItemText(curiItem,5));
	m_pSet->MoveFirst();
	m_pSet->Move(curiItem);
	CString idinfo;
	idinfo.Format("%d",m_pSet->m_route_id);
	m_routeid.SelectString(0,idinfo);
}

void CBussettingView::OnAdd() 
{
	// TODO: Add your control notification handler code here
	EnableView(false);
	m_busno.Empty();
	m_seattotal=0;	
	UpdateData(FALSE);
	operation = 1;
	curiItem=m_list.GetItemCount();
}

void CBussettingView::OnChange() 
{
	// TODO: Add your control notification handler code here
	if (curiItem==m_list.GetItemCount()||curiItem==-1)
	{
		MessageBox("请选择您要修改的行！","警告",MB_OK|MB_ICONEXCLAMATION);
		return;
	}
	EnableView(FALSE);
	operation = 2;
}

void CBussettingView::OnDelete() 
{
	// TODO: Add your control notification handler code here
	if (curiItem==m_list.GetItemCount()||curiItem==-1)
	{
		MessageBox("请选择您要删除的行！","警告",MB_OK|MB_ICONEXCLAMATION);
		return;
	}
	if (IDOK==MessageBox("确认删除？","提示",MB_OKCANCEL|MB_ICONQUESTION))
	{
		if (!m_pSet->IsOpen())
		{
			m_pSet->Open();
		}
		m_pSet->MoveFirst();
		m_pSet->Move(curiItem);
		m_pSet->Delete();
		m_pSet->Requery();		
		m_list.DeleteItem(curiItem);
		curiItem=0;
		Getvalue();
		MessageBox("该数据已经删除！","删除成功",MB_OK|MB_ICONINFORMATION);
		UpdateData(FALSE);
	}
}

void CBussettingView::OnSave() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if (m_busno == "")
	{
		AfxMessageBox("车牌号不能为空！");
		return;
	}
	CBustypeSet bustypeset;
	CString str;
	CDriverSet driverset;
	CSeattypeSet seattypeset;
	if (operation==0)
	{
		return;
	}
	if (operation==1)
	{
		if (!m_pSet->IsOpen())
		{
			m_pSet->Open();
		}
		int idtemp;
		m_pSet->MoveLast();
		idtemp=m_pSet->m_busID;
		m_pSet->AddNew();   //在表的末尾添加新记录
		m_pSet->m_busID=idtemp+1;
		m_pSet->m_busnumber=m_busno;
		
		bustypeset.Open();
		bustypeset.MoveFirst();
		while (!bustypeset.IsEOF())
		{
			bustypeset.m_bustype.TrimRight();
			
			m_bustype.GetWindowText(str);
			if (bustypeset.m_bustype == str)
			{
				break;
			}
			bustypeset.MoveNext();
		}
		m_pSet->m_bustype=bustypeset.m_bustype_id;
		bustypeset.Close();
		seattypeset.Open();
		seattypeset.MoveFirst();
		while(!seattypeset.IsEOF())
		{
			seattypeset.m_type.TrimRight();
			m_seattype.GetWindowText(str);
			if (seattypeset.m_type == str)
			{
				break;
			}
			seattypeset.MoveNext();
		}
		m_pSet->m_seattype = seattypeset.m_type_id;
		seattypeset.Close();

		driverset.Open();
		driverset.MoveFirst();
		while (!driverset.IsEOF())
		{
			driverset.m_drivername.TrimRight();
			m_driver.GetWindowText(str);
			if (driverset.m_drivername == str)
			{
				break;
			}
			driverset.MoveNext();
		}
		m_pSet->m_driverid=driverset.m_driverid;
		driverset.Close();
		m_company.GetWindowText(str);
		if (m_company.FindString(0,str) == -1)
		{
			m_company.AddString(str);
		}	
		m_pSet->m_company=str;
		int routeidtemp;
		m_routeid.GetWindowText(str);
		routeidtemp=atoi(str);
		m_pSet->m_route_id=routeidtemp;
		m_pSet->Update();
		m_pSet->Requery();
		Showlist();
		m_pSet->MoveFirst();
		while (!m_pSet->IsEOF())
		{
			m_pSet->MoveNext();
		}
		curiItem=m_pSet->GetRecordCount()-1;
		EnableView(true);
		operation=0;
		MessageBox("增加成功！","增加成功",MB_OK|MB_ICONINFORMATION);		
		return;
	}
	else
	{
		if (!m_pSet->IsOpen())
		{
			m_pSet->Open();
		}
		m_pSet->Edit();   
		m_pSet->m_busnumber=m_busno;
		
		bustypeset.Open();
		bustypeset.MoveFirst();
		while (!bustypeset.IsEOF())
		{
			bustypeset.m_bustype.TrimRight();
			
			m_bustype.GetWindowText(str);
			if (bustypeset.m_bustype == str)
			{
				break;
			}
			bustypeset.MoveNext();
		}
		m_pSet->m_bustype=bustypeset.m_bustype_id;
		bustypeset.Close();
		seattypeset.Open();
		seattypeset.MoveFirst();
		while(!seattypeset.IsEOF())
		{
			seattypeset.m_type.TrimRight();
			m_seattype.GetWindowText(str);
			if (seattypeset.m_type == str)
			{
				break;
			}
			seattypeset.MoveNext();
		}
		m_pSet->m_seattype = seattypeset.m_type_id;
		seattypeset.Close();
		
		driverset.Open();
		driverset.MoveFirst();
		while (!driverset.IsEOF())
		{
			driverset.m_drivername.TrimRight();
			m_driver.GetWindowText(str);
			if (driverset.m_drivername == str)
			{
				break;
			}
			driverset.MoveNext();
		}
		m_pSet->m_driverid=driverset.m_driverid;
		driverset.Close();
		m_company.GetWindowText(str);
		if (m_company.FindString(0,str) == -1)
		{
			m_company.AddString(str);
		}	
		m_pSet->m_company=str;
		int routeidtemp;
		m_routeid.GetWindowText(str);
		routeidtemp=atoi(str);
		m_pSet->m_route_id=routeidtemp;
		m_pSet->Update();
		m_pSet->Requery();
		Showlist();
		m_pSet->MoveFirst();
		while (!m_pSet->IsEOF())
		{
			m_pSet->MoveNext();
		}
		EnableView(true);
		operation=0;
		MessageBox("修改成功！","修改成功",MB_OK|MB_ICONINFORMATION);		
		return;
	}
	EnableView(TRUE);
}

void CBussettingView::OnReturn() 
{
	// TODO: Add your control notification handler code here
	EnableView(TRUE);
}

void CBussettingView::OnRefurbish() 
{
	// TODO: Add your control notification handler code here
	EnableView(TRUE);
	Showlist();
}


void CBussettingView::OnCloseupBustype() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CBustypeSet bustypeset;
	CString str;
	bustypeset.Open();
	bustypeset.MoveFirst();
	while (!bustypeset.IsEOF())
	{
		bustypeset.m_bustype.TrimRight();
		
		m_bustype.GetWindowText(str);
		if (bustypeset.m_bustype == str)
		{
			break;
		}
		bustypeset.MoveNext();
	}
	m_seattotal=bustypeset.m_seat_total;
	UpdateData(FALSE);
}