dispatchview.cpp

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

	{
		id=m_pDayPlanSet->m_ID;
		sscanf(m_pDayPlanSet->m_plan_date,"%d-%d-%d",&have_year,&have_month,&have_day);
		sscanf(m_pDayPlanSet->m_fc_time,"%d:%d:%d",&have_hour,&have_mintue,&have_second);
		CTime have_datetime(have_year,have_month,have_day,curtime.GetHour(),curtime.GetMinute(),curtime.GetSecond());
		totalDays=((CTimeSpan)(have_datetime-curtime)).GetDays()+1;
		fc_data_distance+=fc_data_d;
	}
	else
	{
		have_year=nYear;
		have_month=nMonth;
		have_day=nDay;
		
	}
	if (!m_pSeatType->IsOpen())
	{
		m_pSeatType->Open();
	}
	if (!m_pBusTypeSet->IsOpen())
	{
		m_pBusTypeSet->Open();
	}
	for(int j=7-totalDays;j>0;j--)
	{		
		while (!m_pRSendInfoSet->IsEOF())
		{
			sscanf(m_pRSendInfoSet->m_start_time,"%d:%d:%d",&nHour_start,&nMintue_start,&nSecond_start);
			sscanf(m_pRSendInfoSet->m_stop_time,"%d:%d:%d",&nHour_stop,&nMintue_stop,&nSecond_stop);
			CTime curdate(have_year,have_month,have_day,nHour_start,nMintue_start,nSecond_start);
			//CTime starttime(0,0,0,nHour_start,nMintue_start,nSecond_start);
			CTime stoptime(have_year,have_month,have_day,nHour_stop,nMintue_stop,nSecond_stop);
			int totalminute=((CTimeSpan)(curdate-stoptime)).GetTotalMinutes();
			CTime priortime(have_year,have_month,have_day,nHour_start,nMintue_start,nSecond_start);
			curdate+=fc_data_distance;
			priortime+=fc_data_distance;
			CTimeSpan fc_distance(0,(int)m_pRSendInfoSet->m_send_frequency/60,(int)m_pRSendInfoSet->m_send_frequency%60,0);
			CString curdatestr=curdate.Format("%Y-%m-%d");
			CString fc_time;		
			if (totalminute<0)
				totalminute+=24*60;	
			if (!m_pDayPlanSet->IsOpen())
				m_pDayPlanSet->Open();
			for (int i=0;i*m_pRSendInfoSet->m_send_frequency<totalminute;i++)
			{			
				if(m_pDayPlanSet->CanUpdate())
				{
					fc_time=priortime.Format("%H:%M:%S");
					m_pDayPlanSet->AddNew();
					id++;
					m_pDayPlanSet->m_ID=id;
					m_pDayPlanSet->SetFieldNull(&(m_pDayPlanSet->m_route_id),FALSE);
					m_pDayPlanSet->m_plan_date=curdatestr;
					m_pDayPlanSet->m_route_id=m_pRSendInfoSet->m_route_id;
					m_pBusSet=m_pBusSet->SearchBusIndex(m_pRSendInfoSet->m_route_id);
					m_pDayPlanSet->m_bus_id=m_pBusSet->m_busID;
					m_pDayPlanSet->m_bus_number=m_pBusSet->m_busnumber;
					m_pDayPlanSet->m_bus_type=m_pBusSet->m_bustype;
					m_pDayPlanSet->m_seat_left=m_pBusTypeSet->SearchByBusType(m_pBusSet->m_bustype)->m_seat_total;
					m_pDayPlanSet->m_fc_time=fc_time;
					m_pDayPlanSet->m_run_state=0;
					m_pDayPlanSet->Update();					
				}
				priortime+=fc_distance;
			}
			m_pRSendInfoSet->MoveNext();			
		}
		fc_data_distance+=fc_data_d;
		m_pRSendInfoSet->MoveFirst();
	}	
	m_pDayPlanSet->m_strSort="ID";
	m_pDayPlanSet->Requery();
}

void CDispatchView::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	CRouteSet* m_pRouteSet=new CRouteSet(NULL);
	CSeattypeSet* m_pSeatTypeSet=new CSeattypeSet(NULL);
	NM_LISTVIEW*   pNMListView  =  (NM_LISTVIEW*)pNMHDR;  
    CurrentItem=pNMListView->iItem;
	int routeid=(atoi)(m_dayplanList.GetItemText(CurrentItem,2));
	m_fctime=m_dayplanList.GetItemText(CurrentItem,7);
	m_fcdate1=m_dayplanList.GetItemText(CurrentItem,1);
	m_left_seat=atoi(m_dayplanList.GetItemText(CurrentItem,6));
	m_price=(float)m_pRouteSet->SearchById(routeid)->m_price;
	m_route=m_pRouteSet->SearchById(routeid)->m_route;
	m_route_id=routeid;
	UpdateData(FALSE);
	*pResult = 0;
}

void CDispatchView::OnBUTTONplan() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CDayPlanSet* m_pdaySet=new CDayPlanSet(NULL);
	CRouteSet* m_routeSet=new CRouteSet(NULL);
	int routeId=1;
	if (m_end=="")
	{
		MessageBox("请输入终点站！","警告",MB_OK|MB_ICONEXCLAMATION);
		return;
	}
	if (!m_routeSet->IsOpen())
	{
		m_routeSet->Open();
	}
	if (!m_pdaySet->IsOpen())
	{
		m_pdaySet->Open();
	}
	CString strSQL;
	strSQL.Format("select * from route where [end]='%s'",m_end);
	CRouteSet rs(m_routeSet->m_pDatabase);
	rs.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	if (rs.GetRecordCount()!=0)
	{
		rs.MoveFirst();
		routeId=rs.m_route_id;		
	}
	CDayPlanSet rs1(m_pdaySet->m_pDatabase);
	strSQL.Format("select * from dayplan where route_id=%d",routeId);
	rs1.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	showList(&rs1,m_dayplanList);
}

void CDispatchView::OnBadd() 
{
	// TODO: Add your control notification handler code here
	GetDlgItem(IDC_EDIT1)->EnableWindow(TRUE);
	GetDlgItem(IDC_BSAVE)->EnableWindow(TRUE);
	GetDlgItem(IDC_BRETURN)->EnableWindow(TRUE);
	GetDlgItem(IDC_FCDATE1)->EnableWindow(TRUE);
	GetDlgItem(IDC_FCTIME)->EnableWindow(TRUE);
	GetDlgItem(IDC_SEATTYPE)->EnableWindow(TRUE);
	GetDlgItem(IDC_LEFTSEAT)->EnableWindow(TRUE);
	GetDlgItem(IDC_PRICE)->EnableWindow(TRUE);
	GetDlgItem(IDC_ROUTE)->EnableWindow(TRUE);
	GetDlgItem(IDC_BDELETE)->EnableWindow(FALSE);
	GetDlgItem(IDC_BMODIFY)->EnableWindow(FALSE);
	OnButtonAdd=1;
	UpdateData();
}

void CDispatchView::OnBdelete() 
{
	// TODO: Add your control notification handler code here
	GetDlgItem(IDC_BADD)->EnableWindow(FALSE);
	GetDlgItem(IDC_BDELETE)->EnableWindow(FALSE);
	GetDlgItem(IDC_BMODIFY)->EnableWindow(FALSE);
	GetDlgItem(IDC_BSAVE)->EnableWindow(TRUE);
	GetDlgItem(IDC_BRETURN)->EnableWindow(TRUE);
	UpdateData();
}

void CDispatchView::OnBmodify() 
{
	// TODO: Add your control notification handler code here
	GetDlgItem(IDC_BSAVE)->EnableWindow(TRUE);
	GetDlgItem(IDC_BRETURN)->EnableWindow(TRUE);
	GetDlgItem(IDC_FCDATE1)->EnableWindow(TRUE);
	GetDlgItem(IDC_FCTIME)->EnableWindow(TRUE);
	GetDlgItem(IDC_SEATTYPE)->EnableWindow(FALSE);
	GetDlgItem(IDC_LEFTSEAT)->EnableWindow(FALSE);
	GetDlgItem(IDC_PRICE)->EnableWindow(FALSE);
	GetDlgItem(IDC_ROUTE)->EnableWindow(FALSE);
	GetDlgItem(IDC_BADD)->EnableWindow(FALSE);
	GetDlgItem(IDC_BDELETE)->EnableWindow(FALSE);
	GetDlgItem(IDC_BMODIFY)->EnableWindow(FALSE);
	OnButtonModify=1;
	UpdateData();
}

void CDispatchView::OnBsave() 
{
	// TODO: Add your control notification handler code here
	CBusset* m_pBusSet=new CBusset(NULL);
	CBustypeSet* m_pBusTypeSet=new CBustypeSet(NULL);
	CString date=m_dayplanList.GetItemText(CurrentItem,1);
	CString time=m_dayplanList.GetItemText(CurrentItem,7);	
	CString strSQL;
	strSQL.Format("select * from dayplan plandate='%s' and fc_time='%s'",date,time);
	// TODO: Add your control notification handler code here
	if (OnButtonModify==1)
	{
		if (m_pSet->IsOpen())
		{
			m_pSet->Close();
		}
		m_pSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if (m_pSet->GetRecordCount()!=0)
		{
			m_pSet->Edit();
			m_pSet->m_plan_date=m_fcdate1;
			m_pSet->m_fc_time=m_fctime;
			m_pSet->Update();
			m_pSet->Requery();
			showList(m_pSet,m_dayplanList);
		}	
		OnButtonModify=0;
	}
	else if (OnButtonAdd==1)
	{
		if (!m_pSet->IsOpen())
		{
			m_pSet->Open();
		}
		m_pSet->MoveLast();
		int id=m_pSet->m_ID;
		m_pSet->AddNew();
		m_pSet->m_ID=id+1;
		m_pSet->SetFieldNull(&(m_pSet->m_route_id),FALSE);
		m_pSet->m_plan_date=m_fcdate1;
		m_pSet->m_route_id=m_route_id;
		m_pBusSet=m_pBusSet->SearchBusIndex(m_route_id);
		m_pSet->m_bus_id=m_pBusSet->m_busID;
		m_pSet->m_bus_number=m_pBusSet->m_busnumber;
		m_pSet->m_bus_type=m_pBusSet->m_bustype;
		m_pSet->m_seat_left=m_pBusTypeSet->SearchByBusType(m_pBusSet->m_bustype)->m_seat_total;
		m_pSet->m_fc_time=m_fctime;
		m_pSet->m_run_state=0;
		m_pSet->Update();
		m_pSet->m_strSort="ID";
		m_pSet->Requery();
		showList(m_pSet,m_dayplanList);
		OnButtonAdd=0;
	}
	else
	{
		if (m_pSet->IsOpen())
		{
			m_pSet->Close();
		}
		m_pSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if (m_pSet->GetRecordCount()!=0)
		{	
			m_pSet->Delete();
			showList(m_pSet,m_dayplanList);
		}
	}
}

void CDispatchView::OnBreturn() 
{
	// TODO: Add your control notification handler code here
	GetDlgItem(IDC_EDIT1)->EnableWindow(FALSE);
	GetDlgItem(IDC_FCDATE1)->EnableWindow(FALSE);
	GetDlgItem(IDC_FCTIME)->EnableWindow(FALSE);
	GetDlgItem(IDC_SEATTYPE)->EnableWindow(FALSE);
	GetDlgItem(IDC_LEFTSEAT)->EnableWindow(FALSE);
	GetDlgItem(IDC_PRICE)->EnableWindow(FALSE);
	GetDlgItem(IDC_ROUTE)->EnableWindow(FALSE);
	GetDlgItem(IDC_BADD)->EnableWindow(TRUE);
	GetDlgItem(IDC_BDELETE)->EnableWindow(TRUE);
	GetDlgItem(IDC_BMODIFY)->EnableWindow(TRUE);
	GetDlgItem(IDC_BRETURN)->EnableWindow(FALSE);
	GetDlgItem(IDC_BSAVE)->EnableWindow(FALSE);
}