prodlg.cpp

车行管理系统

		MessageBox("记录集打开错误");
		return 0;
	}
	//	SetWindowRedraw(TRUE);
	m_ListCtrl.LockWindowUpdate();
	m_ListCtrl.DeleteAllItems();
	
	//k_db.Requery();
	int i=0;
	
	double ali=0;
	double ainval=0;
	double curli=0;
	
	double aout=0.0;
	double apre=0.0;
	double asui=0.0;
	if(!m_db.IsBOF ())m_db.MoveFirst ();
	while(!m_db.IsEOF() )
	{
		CString s;
		CTime ctime;
		s.Format ("%d",i+1 );
		m_ListCtrl.InsertItem (i,s,0);
		m_ListCtrl.SetItemData (i,(DWORD)m_db.m_ID );
		m_ListCtrl.SetItemText (i,0,s );
		s.Format ("%s",m_db.m_column1 );
		m_ListCtrl.SetItemText(i,1,s);
		s.Format ("%s",m_db.m_column2 );
		m_ListCtrl.SetItemText(i,2,s);
		ctime=m_db.m_column3;
		if(m_db.m_salled==0)s="//";
		else s.Format ("%d-%02d-%02d %02d:%02d:%02d",ctime.GetYear (),ctime.GetMonth (),ctime.GetDay (),ctime.GetHour (),ctime.GetMinute (),ctime.GetSecond ());
		m_ListCtrl.SetItemText (i,3,s);
		
		
		if(m_db.m_salled==0)s="//";
		else s.Format ("%0.2f",m_db.m_column4);
		aout+=m_db.m_column4;
		m_ListCtrl.SetItemText(i,4,s);
		
		if(m_db.m_salled==0)s="//";
		else s.Format ("%0.2f",m_db.m_column5);
		apre+=m_db.m_column5;
		m_ListCtrl.SetItemText(i,5,s);
		if(m_db.m_salled==0)s="//";
		else s.Format ("%0.2f",m_db.m_column6);
		asui+=m_db.m_column6;
		m_ListCtrl.SetItemText(i,6,s);
		
		
		if(m_db.m_salled==1)
		{
			
			curli=m_db.m_column4-(m_db.m_invalm +m_db.m_column5 +m_db.m_column6);
			s.Format ("%0.2f",curli);
		}
		else 
		{
			curli=0;
			s="//";
		}
		
		m_ListCtrl.SetItemText(i,7,s);
		
		ali+=curli;
		ainval+=m_db.m_invalm ;
		
		
		
		
		
		
		ctime=m_db.m_column7;
		s.Format ("%d-%02d-%02d",ctime.GetYear (),ctime.GetMonth (),ctime.GetDay ());
		m_ListCtrl.SetItemText (i,8,s);
		
		if(m_db.m_column8 .GetLength ())
			m_ListCtrl.SetItemText (i,9,m_db.m_column8 );	


		if(m_db.m_edittime !=0)
		s.Format ("%02d-%02d-%02d %02d:%02d:%02d:",m_db.m_edittime.GetYear (),m_db.m_edittime .GetMonth (),m_db.m_edittime.GetDay () ,m_db.m_edittime .GetHour (),m_db.m_edittime .GetMinute  (),m_db.m_edittime .GetSecond  ());
		else s="//";
		m_ListCtrl.SetItemText(i,10,s);

		
		i++;
		if(!m_db.IsEOF() )m_db.MoveNext ();
	}
	m_ListCtrl.UnlockWindowUpdate ();
	m_ListCtrl.EnsureVisible (cursel,TRUE);
	
	if(m_db.m_strFilter .GetLength ()==0)m_afilt="全部记录";
	else if(strstr(m_db.m_strFilter ,"like"))m_afilt.Format ("包函关键字\"%s\"的记录",m_filt);
	else if(strstr(m_db.m_strFilter ,"已出售"))m_afilt.Format ("%s 记录",m_cinout);
	else 
	{
		m_afilt.Format ("从%d-%d-%d到%d-%d-%d的%s记录",m_timefrom.GetYear (),m_timefrom.GetMonth (),m_timefrom.GetDay (),m_timeto.GetYear (),m_timeto.GetMonth (),m_timeto.GetDay (),m_cinout);
	}
	m_attot.Format ("以%s排序,共%d台",strsort,i);
	
	
	m_aout.Format ("总出售:%0.2f",aout);
	m_apre.Format ("总配送:%0.2f",apre);
	m_asui.Format ("总税费:%0.2f",asui);
	m_ainval.Format ("总入库:%0.2f",ainval);
	m_ali.Format ("Ax:%0.2f",ali);
	//	MessageBox(	m_db.m_strFilter);
	
	UpdateData(FALSE);
	
	return i;
	
}

void CProDlg::OnSell() 
{
	// TODO: Add your control notification handler code here

	POSITION pos;
	pos=m_ListCtrl.GetFirstSelectedItemPosition ();
	if(pos==NULL)
	{

		MessageBox("请选择要销售车辆.");
		return;
	}
	CSellDlg test;
	int idx=m_ListCtrl.GetNextSelectedItem (pos);
	test.sid =m_ListCtrl.GetItemData (idx);
	test.DoModal();

	m_db.Requery();
	show(strsort);
	delete test;
	

	
	
	
}


void CProDlg::OnKillfocusList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	//MessageBox("LoveZ3");
	
		cursel=m_ListCtrl.GetSelectionMark();
		
		
	
	*pResult = 0;
}

void CProDlg::OnSetfocusList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	
//	m_ListCtrl.EnsureVisible (cursel,TRUE);
	
	*pResult = 0;
}

void CProDlg::OnButton1() 
{

//	UpdateData();
	show(strsort);
	
	

}

	

void CProDlg::OnColumnclickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	//MessageBox("LOVEZ3");
//	while(0);
	switch(pNMListView->iSubItem)
	{
	
	case 1:strsort="车型 ASC";break;
		case 2:strsort="发动机号 ASC";break;
			case 3:strsort="出售日期 DESC";break;
				case 4:strsort="售价 DESC";break;
					case 5:strsort="配送 DESC";break;
						case 6:strsort="税费 DESC";break;
							case 8:strsort="入库时间 DESC";break;
								case 9:strsort="备注 DESC";break;
							default:return;

	}
	show(strsort);


	
	*pResult = 0;
}

void CProDlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	if(m_filt.GetLength ())m_db.m_strFilter="车型 like '%"+m_filt+"%' or 发动机号 like '%"+m_filt+"%' or 备注 like '%"+m_filt+"%'";
	else m_db.m_strFilter="";
	m_db.Requery();
	show(strsort);
	//m_db.m_strFilter="";
	
}

void CProDlg::OnButton3() 
{
	
	UpdateData();
	
	CString inout;
	int sel=m_inout.GetCurSel ();
	switch(sel)
	{
	case 0:inout="出售日期";break;
	case 1:inout="入库时间";break;
	case 2:
		m_db.m_strFilter .Format ("已出售=1");
	//	MessageBox(	m_db.m_strFilter);
		m_db.Requery();
		show(strsort);
		return;
		break;
	case 3:
		m_db.m_strFilter .Format("已出售=0");
	//	MessageBox(	m_db.m_strFilter);
		m_db.Requery();
		show(strsort);
		return;
		break;
	case 4:
		m_db.m_strFilter ="";
		m_db.Requery ();
		show(strsort);
		return;
		break;
	default:return;
	}
	if(m_timefrom<=m_timeto)
	{
		m_db.m_strFilter.Format ("%s>#%d-%d-%d# and %s<=#%d-%d-%d %d:%d:%d#",inout,m_timefrom.GetYear (),m_timefrom.GetMonth (),m_timefrom.GetDay (),inout,m_timeto.GetYear (),m_timeto.GetMonth (),m_timeto.GetDay (),m_timeto.GetHour (),m_timeto.GetMinute (),m_timeto.GetSecond ());
		m_db.Requery ();
		
		show(strsort);
	}
	else MessageBox("时间设置错误.");
}


void CProDlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	//MessageBox("LOveZ3");
	
	NMLISTVIEW* pNMListView=(NMLISTVIEW*)pNMHDR;
	int nItem=pNMListView->iItem;
	if((nItem>=0)&&(nItem<m_ListCtrl.GetItemCount()))//选中某一行
	{
		
		int nItem=-1;
		nItem=m_ListCtrl.GetNextItem(nItem,LVNI_SELECTED);
		CInfoDlg test;
		test.sid =m_ListCtrl.GetItemData (nItem);
		test.DoModal();
		show(strsort);
		delete test;
		/*CString str;
		str=m_ListCtrl.GetItemText(nItem,2 );
		MessageBox(str);//用来显示读取的内容，用于测试*/

	}
	*pResult = 0;
}

void CProDlg::OnRep() 
{
	// TODO: Add your control notification handler code here

	ReportDlg test;
	test.plist=&m_ListCtrl;
	test.m_title =m_afilt;
	test.tot1.Format ("%s  %s",m_afilt,m_attot);
	test.tot2.Format ("[%s %s %s] [%s %s]",m_aout,m_apre,m_asui,m_ainval,m_ali);
	test.DoModal();
	/*
	CString str;
	str.Format ("%d",test.plist ->GetItemCount ());
	//str=test.plist->GetItemText (2,7);
	MessageBox(str);
	*/
	

	
}

BOOL CProDlg::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	if(pMsg->message==WM_HOTKEY)
	//MessageBox("LOVEZ3");
	show(strsort);
	return CDialog::PreTranslateMessage(pMsg);
}

void CProDlg::Onbackup() 
{
	// TODO: Add your control notification handler code here
	CString basefile,fileto;
	SYSTEMTIME stime;
	GetLocalTime(&stime);
	basefile="wj.mdb";
	fileto.Format ("backup\\%02d%02d%02d%02d%02d%02d.mdb.wjbak",stime.wYear ,stime.wMonth ,stime.wDay ,stime.wHour ,stime.wMinute ,stime.wSecond);

	if(CopyFile(basefile,fileto,FALSE))MessageBox("备份成功!");
	else MessageBox("备份失败");
	
}

void CAboutDlg::OnButton11() 
{
	// TODO: Add your control notification handler code here
	MessageBox("LoveZ3","LoveZ3");
	
}

void CProDlg::OnUser() 
{
	// TODO: Add your control notification handler code here

CUserDlg test;
test.DoModal();
	
}

void CProDlg::OnSetfocusFilter() 
{
	// TODO: Add your control notification handler code here

	//m_bfilt.SetFocus ();
	
	

	
}

void CProDlg::OnButton26() 
{
	// TODO: Add your control notification handler code here

	CResysDlg test;
	test.DoModal();
}