sublistview.cpp

Visual+C+++课程设计案例精编（附书代码),有通讯录,聊天程序等源吗,对初学者很有帮助.

	
}

void CSubListView::OnMenuitemCaradd() 
{
	operation=1;
	CCarDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDriveradd() 
{
	operation=1;
	CDriverDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDrivermodify() 
{
	operation=2;
	CDriverDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDriverdel() 
{
	operation=3;
	CDriverDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::ListCarDriver()
{
	CListCtrl* pList = &GetListCtrl();

	//清空列表
	pList->DeleteAllItems();
	pList->SetRedraw(FALSE);
	
	_variant_t Holder, strQuery;
    strQuery= "select * from [car-driver]";
	theApp.ADOExecute(theApp.m_pRs, strQuery);
    int iCount = theApp.m_pRs->GetRecordCount();
	if ( 0==iCount ) 
		return;
	theApp.m_pRs->MoveFirst();

	int i=0;
	while(!theApp.m_pRs->adoEOF)
	{
		Holder = theApp.m_pRs->GetCollect("Car_NO");
		if(Holder.vt!=VT_NULL)
			pList->InsertItem(i, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Driver_NO");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,1, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("IsWork");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,2, Holder.iVal==1?"是":"否");		
	

		theApp.m_pRs->MoveNext();
		i++;
	}

	pList->SetRedraw(TRUE);	

}

void CSubListView::SelCarDriver()
{
		CListCtrl* pCtrl = &GetListCtrl();

	selCarDriver.CarNO=pCtrl->GetItemText(nHitItem,0);
	selCarDriver.DriverNO=pCtrl->GetItemText(nHitItem,1);
	selCarDriver.IsWork=pCtrl->GetItemText(nHitItem,2)=="是"?1:0;


}

void CSubListView::OnMenuitemCdadd() 
{
	operation=1;
	CCarDriverDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemCdmodify() 
{	
	operation=2;
	CCarDriverDlg dlg;
	dlg.DoModal();

	

	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemCddel() 
{
	operation=3;
	CCarDriverDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::ListCarFee()
{
	CListCtrl* pList = &GetListCtrl();

	//清空列表
	pList->DeleteAllItems();
	pList->SetRedraw(FALSE);
	
	_variant_t Holder, strQuery;
    strQuery= "select * from [car-fee]";
	theApp.ADOExecute(theApp.m_pRs, strQuery);
    int iCount = theApp.m_pRs->GetRecordCount();
	if ( 0==iCount ) 
		return;
	theApp.m_pRs->MoveFirst();

	int i=0;
	while(!theApp.m_pRs->adoEOF)
	{
		Holder = theApp.m_pRs->GetCollect("Car_NO");
		if(Holder.vt!=VT_NULL)
			pList->InsertItem(i, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Fee_NO");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,1, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("InDate");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,2, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("OutDate");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,3, (char*)(_bstr_t)Holder);

		theApp.m_pRs->MoveNext();
		i++;
	}

	pList->SetRedraw(TRUE);	

}

void CSubListView::ListDriverPunish()
{
	CListCtrl* pList = &GetListCtrl();

	//清空列表
	pList->DeleteAllItems();
	pList->SetRedraw(FALSE);
	
	_variant_t Holder, strQuery;
    strQuery= "select * from [driver-punish]";
	theApp.ADOExecute(theApp.m_pRs, strQuery);
    int iCount = theApp.m_pRs->GetRecordCount();
	if ( 0==iCount ) 
		return;
	theApp.m_pRs->MoveFirst();

	int i=0;
	while(!theApp.m_pRs->adoEOF)
	{
		Holder = theApp.m_pRs->GetCollect("Driver_NO");
		if(Holder.vt!=VT_NULL)
			pList->InsertItem(i, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Punish_NO");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,1, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("HappenAddress");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,2, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("HappenDate");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,3, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("TreatState");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,4, Holder.iVal==1?"是":"否");
		
		Holder = theApp.m_pRs->GetCollect("OtherMessage");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,5, (char*)(_bstr_t)Holder);		
	

		theApp.m_pRs->MoveNext();
		i++;
	}

	pList->SetRedraw(TRUE);

}

void CSubListView::ListDriverAward()
{
	CListCtrl* pList = &GetListCtrl();

	//清空列表
	pList->DeleteAllItems();
	pList->SetRedraw(FALSE);
	
	_variant_t Holder, strQuery;
    strQuery= "select * from [driver-award]";
	theApp.ADOExecute(theApp.m_pRs, strQuery);
    int iCount = theApp.m_pRs->GetRecordCount();
	if ( 0==iCount ) 
		return;
	theApp.m_pRs->MoveFirst();

	int i=0;
	while(!theApp.m_pRs->adoEOF)
	{
		Holder = theApp.m_pRs->GetCollect("Driver_NO");
		if(Holder.vt!=VT_NULL)
			pList->InsertItem(i, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Award_NO");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,1, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Content");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,2, (char*)(_bstr_t)Holder);
		
		Holder = theApp.m_pRs->GetCollect("OtherMessage");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,3, (char*)(_bstr_t)Holder);		
	

		theApp.m_pRs->MoveNext();
		i++;
	}

	pList->SetRedraw(TRUE);


}

void CSubListView::ListPunish()
{
	CListCtrl* pList = &GetListCtrl();

	//清空列表
	pList->DeleteAllItems();
	pList->SetRedraw(FALSE);
	
	_variant_t Holder, strQuery;
    strQuery= "select * from punish";
	theApp.ADOExecute(theApp.m_pRs, strQuery);
    int iCount = theApp.m_pRs->GetRecordCount();
	if ( 0==iCount ) 
		return;
	theApp.m_pRs->MoveFirst();

	int i=0;
	while(!theApp.m_pRs->adoEOF)
	{
		Holder = theApp.m_pRs->GetCollect("Punish_NO");
		if(Holder.vt!=VT_NULL)
			pList->InsertItem(i, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Punish_name");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,1, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Punish_Admin");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,2, (char*)(_bstr_t)Holder);
		
		Holder = theApp.m_pRs->GetCollect("Punish_Money");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,3, (char*)(_bstr_t)Holder);

		
		Holder = theApp.m_pRs->GetCollect("Punish_Point");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,4, (char*)(_bstr_t)Holder);
		Holder = theApp.m_pRs->GetCollect("Punish_Book");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,5, Holder.iVal==1?"是":"否");

		theApp.m_pRs->MoveNext();
		i++;
	}

	pList->SetRedraw(TRUE);	


}

void CSubListView::ListFee()
{
	CListCtrl* pList = &GetListCtrl();

	//清空列表
	pList->DeleteAllItems();
	pList->SetRedraw(FALSE);
	
	_variant_t Holder, strQuery;
    strQuery= "select * from fee";
	theApp.ADOExecute(theApp.m_pRs, strQuery);
    int iCount = theApp.m_pRs->GetRecordCount();
	if ( 0==iCount ) 
		return;
	theApp.m_pRs->MoveFirst();

	int i=0;
	while(!theApp.m_pRs->adoEOF)
	{
		Holder = theApp.m_pRs->GetCollect("Fee_NO");
		if(Holder.vt!=VT_NULL)
			pList->InsertItem(i, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Fee_Name");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,1, (char*)(_bstr_t)Holder);

		Holder = theApp.m_pRs->GetCollect("Fee_Admin");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,2, (char*)(_bstr_t)Holder);
		
		Holder = theApp.m_pRs->GetCollect("Fee_Money");
		if(Holder.vt!=VT_NULL)
			pList->SetItemText(i,3, (char*)(_bstr_t)Holder);


		theApp.m_pRs->MoveNext();
		i++;
	}

	pList->SetRedraw(TRUE);	


}

void CSubListView::SelCarFee()
{
	CListCtrl* pCtrl = &GetListCtrl();

	selCarFee.CarNO=pCtrl->GetItemText(nHitItem,0);
	selCarFee.FeeNO=pCtrl->GetItemText(nHitItem,1);

	CString strDate=pCtrl->GetItemText(nHitItem,2);
	long y,m,d;
	sscanf(strDate.GetBuffer(strDate.GetLength()),"%d-%d-%d",&y,&m,&d);
	if(y<1000)
		y+=2000;
	CTime time1(y,m,d,0,0,0);
	selCarFee.tmBegin=time1;

	strDate=pCtrl->GetItemText(nHitItem,3);
	sscanf(strDate.GetBuffer(strDate.GetLength()),"%d-%d-%d",&y,&m,&d);
	if(y<1000)
		y+=2000;
	CTime time2(y,m,d,0,0,0);
	selDriver.tmBookDate=time2;


}

void CSubListView::OnMenuitemCarfeeadd() 
{
	operation=1;
	CCarFeeDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemCarfeemodify() 
{
	operation=2;
	CCarFeeDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemCarfeedl() 
{
	operation=3;
	CCarFeeDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDriverlawadd() 
{
	operation=1;
	CDriverLawDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDriverlawmodify() 
{
	operation=2;
	CDriverLawDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDriverlawdel() 
{
	operation=3;
	CDriverLawDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here	
}

void CSubListView::SelDriverLaw()
{
	CListCtrl* pCtrl = &GetListCtrl();

	selDriverLaw.DriverNO=pCtrl->GetItemText(nHitItem,0);
	selDriverLaw.LawNO=pCtrl->GetItemText(nHitItem,1);
	selDriverLaw.Address=pCtrl->GetItemText(nHitItem,2);


	CString strDate=pCtrl->GetItemText(nHitItem,3);
	long y,m,d;
	sscanf(strDate.GetBuffer(strDate.GetLength()),"%d-%d-%d",&y,&m,&d);
	if(y<1000)
		y+=2000;
	CTime time(y,m,d,0,0,0);
	selDriverLaw.date=time;

	selDriverLaw.TreatState=pCtrl->GetItemText(nHitItem,4)=="是"?1:0;
	selDriverLaw.Memo=pCtrl->GetItemText(nHitItem,5);

}


void CSubListView::SelDriverAward()
{
	CListCtrl* pCtrl = &GetListCtrl();
	selDriverAward.DriverNO=pCtrl->GetItemText(nHitItem,0);
	selDriverAward.AwardNO=pCtrl->GetItemText(nHitItem,1);
	selDriverAward.Content=pCtrl->GetItemText(nHitItem,2);
	selDriverAward.Memo=pCtrl->GetItemText(nHitItem,3);

}

void CSubListView::OnMenuitemDriverawardadd() 
{
	operation=1;
	CDriverAwardDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDriverawardmodify() 
{
	operation=2;
	CDriverAwardDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemDriverawarddel() 
{
	operation=3;
	CDriverAwardDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::SelFee()
{
	CListCtrl* pCtrl = &GetListCtrl();
	selFee.FeeNO=pCtrl->GetItemText(nHitItem,0);
	selFee.FeeName=pCtrl->GetItemText(nHitItem,1);
	selFee.FeeDepartment=pCtrl->GetItemText(nHitItem,2);
	selFee.FeeMoney=pCtrl->GetItemText(nHitItem,3);

}

void CSubListView::SelLaw()
{
	CListCtrl* pCtrl = &GetListCtrl();
	selLaw.LawNO=pCtrl->GetItemText(nHitItem,0);
	selLaw.LawName=pCtrl->GetItemText(nHitItem,1);
	selLaw.LawDepartment=pCtrl->GetItemText(nHitItem,2);
	selLaw.LawMoney=pCtrl->GetItemText(nHitItem,3);
	selLaw.LawPoint=pCtrl->GetItemText(nHitItem,4);
	selLaw.iIsBook=pCtrl->GetItemText(nHitItem,5)=="是"?1:0;

}

void CSubListView::OnMenuitemFeeadd() 
{
	operation=1;
	CFeeDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemFeemodify() 
{
	operation=2;
	CFeeDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemFeedel() 
{
	operation=3;
	CFeeDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemLawadd() 
{
	operation=1;
	CLawDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemLawmodify() 
{
	operation=2;
	CLawDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}

void CSubListView::OnMenuitemLawdel() 
{
	operation=3;
	CLawDlg dlg;
	dlg.DoModal();
	// TODO: Add your command handler code here
	
}