peccancydlg.cpp

对列表中的图片的浏览,可以进行上下翻页,可以装载jpg的图片

					str2.Format("AND PeccancyDate+PeccancyTime >= '%s' AND PeccancyDate+PeccancyTime <= '%s'",sfrom2,sto2);
					p_query=str1+str2;
				}
			}	
		} 
	}	
	
   RefreshData();
}

void CPeccancyDlg::OnCancle() 
{
	pmaCom->DisConn();	
	pmaCom->Release();
	CoUninitialize();	
	CDialog::OnOK();	
}

void CPeccancyDlg::RefreshData()
{
    if(!m_database.IsOpen())
	{
		m_database.Open(_T("Police"));
	}

	m_ListQuery.DeleteAllItems();

	CImageData m_ImageData(&m_database);

	if (p_query == "")
	{		
		return;
	}

	m_ImageData.Open(AFX_DB_USE_DEFAULT_TYPE,p_query);

	if(m_ImageData.GetRecordCount() != 0) 
	{
		m_ImageData.MoveFirst();
		int i=0;
		
		while(!m_ImageData.IsEOF())
		{ 
			UpdateData(true);
			CString s;
			s.Format("%d",m_ImageData.m_PeccancySpeed);
			m_ListQuery.InsertItem(i,s,0);
            			
			m_ListQuery.SetItemText(i,1,m_ImageData.m_PeccancyNumber);

			m_ListQuery.SetItemText(i,2,m_ImageData.m_PeccancyDate);
			
			s=m_ImageData.m_PeccancyTime;
			s.Insert(2,':');
			s.Insert(5,':');
			m_ListQuery.SetItemText(i,3,s);
			
			m_ListQuery.SetItemText(i,4,m_ImageData.m_Operator);
			
			s.Format("%d",m_ImageData.m_ID);
			m_ListQuery.SetItemText(i,5,s);	
			i++;
			m_ImageData.MoveNext();
		}
	}
	else
	{	
		return;
	}
    m_ImageData.Close();
}

void CPeccancyDlg::OnDelete() 
{
	CString strSQL;
    CImageData m_ImageData(&m_database);
	strSQL.Format("select * from Image where ID=%d",m_ImageID);
	m_ImageData.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
			
    if (bOnlist == 0)
	{
		
		bOnlist = 1;
	
		int nResponse =	MessageBox("确定要删除该记录吗？", "提示信息", MB_OKCANCEL + MB_ICONQUESTION);
		if (nResponse == IDOK)
		{
			flag=0;

			m_ImageData.Delete();
			m_ImageData.Requery();
			m_ImageData.Close();
			
			RefreshData();

			DeleteFile(m_curImagePath);
			
			char strdirectoury[100];
			CString str;
			GetCurrentDirectory(100,strdirectoury);
			
			str.Format("%s",strdirectoury);
			str+="\\res\\deletefile.bmp";
            m_Image=str;
			OnPaint();
		}
	}
	else
	{
		if(flag == 1)
		{			
			if(AfxMessageBox("确实需要删除该图像吗?",MB_YESNO)==IDYES)
			{ 
				m_ImageData.Delete();
				m_ImageData.Requery();

				RefreshData();

				DeleteFile(m_curImagePath);
				
				char strdirectoury[100];
				CString str;
				GetCurrentDirectory(100,strdirectoury);
				
				
				str.Format("%s",strdirectoury);
				str+="\\res\\deletefile.bmp";
				m_Image=str;
			    OnPaint();

				flag=0;
			}
		}
	}

}

void CPeccancyDlg::OnClickListQuery(NMHDR* pNMHDR, LRESULT* pResult) 
{
	CString strSQL;
	CImageData m_ImageData(&m_database);

	POSITION pos = m_ListQuery.GetFirstSelectedItemPosition();
	if (pos)
	{
		bOnlist = 0;
		int nItem = m_ListQuery.GetNextSelectedItem(pos);
		CString strUserinfo;
		strUserinfo=m_ListQuery.GetItemText(nItem,5);
		long m_id=atol(strUserinfo);
	
		strSQL.Format("select * from Image where ID=%d",m_id);
		m_ImageData.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		m_ImageID=m_ImageData.m_ID;
		m_ImagePath=m_ImageData.m_ImagePath;
		m_Image=m_ImageData.m_ImagePath+m_ImageData.m_ImageName;
        m_curImagePath=m_Image;

		//显示图像
		OnPaint();

		flag = 1;

		m_Car = m_ImageData.m_PeccancyNumber;
		UpdateData(false);
		m_ImageData.Close();		
	}	
	*pResult = 0;
}

void CPeccancyDlg::OnExplain() 
{ 
    CString strSQL;
	CImageData m_ImageData(&m_database);

	strSQL.Format("select * from Image where ID = %d",m_ImageID);
	m_ImageData.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);

	if (bOnlist == 0)
	{
		if (m_Car == "")
		{
			AfxMessageBox("请输入车牌号码!");
			return;
		}
		
		m_ImageData.Edit();
		UpdateData(true);
		m_ImageData.m_PeccancyNumber = m_Car;

		CString m_ImageName = m_ImageData.m_ImageName;
		CString m_Rightstr, m_NewImageName,m_NewImageNamePath;

       	m_Rightstr = m_ImageName.Right(24);
		m_NewImageName = m_Car + m_Rightstr;
	    m_ImageData.m_ImageName = m_NewImageName;
        m_NewImageNamePath = m_ImagePath + m_NewImageName;
		m_curImagePath=m_ImageData.m_ImagePath + m_ImageName;

		m_ImageData.Update();
        m_ImageData.Requery();
		m_ImageData.Close();

		CFile::Rename( m_curImagePath, m_NewImageNamePath );

			
		RefreshData();

        m_Image=m_NewImageNamePath;
		OnPaint();	
	}
	else
	{
		if(flag == 1)
		{
			m_ImageData.Edit();
			UpdateData(true);
			m_ImageData.m_PeccancyNumber = m_Car;

			CString m_ImageName = m_ImageData.m_ImageName;
			CString m_Rightstr, m_NewImageName,m_NewImageNamePath;
			
			m_Rightstr = m_ImageName.Right(24);
			m_NewImageName = m_Car + m_Rightstr;
			m_NewImageNamePath = m_ImageData.m_ImagePath + m_NewImageName;
			m_curImagePath=m_ImageData.m_ImagePath + m_ImageName;
			m_ImageData.m_ImageName = m_NewImageName;

			m_ImageData.Update();
			m_ImageData.Requery();
		//	m_ImageData.Close();
		         	
		/*	m_ImageData.m_ID = m_ImageID;
			
		
			strSQL.Format("delete from Image where ID=%d",m_ImageID);
			m_database.ExecuteSQL(strSQL);

			strSQL.Format("insert into Image values(%d,\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',%d,\'%s\',\'%s\',\'%s\',\'%s\')",m_ImageData.m_ID,m_ImageData.m_ImageName,m_ImageData.m_ImagePath,m_ImageData.m_PeccancyDate,
				m_ImageData.m_PeccancyTime,m_ImageData.m_PeccancyNumber,m_ImageData.m_PeccancySpeed,m_ImageData.m_PeccancyLocation,m_ImageData.m_SendSign,m_ImageData.m_Operator,m_ImageData.m_Note);
			m_database.ExecuteSQL(strSQL);
			m_database.Close();
*/
			CFile::Rename( m_curImagePath, m_NewImageNamePath ); 

			RefreshData();
			m_Image=m_NewImageNamePath;
		    OnPaint();
		}
	}
}


void CPeccancyDlg::OnSend() 
{
   	if (flag == 1)
	{
		pmaCom->SendFile(_bstr_t(m_curImagePath),_bstr_t("bbb"));
		Sleep(200);
	}
	else
	{
		AfxMessageBox("没有选择图像!",MB_OK);
	}
//	Sleep(200);
}
//第一条
void CPeccancyDlg::OnFirst() 
{
	GetDlgItem(IDC_PREV)->EnableWindow(true);
    GetDlgItem(IDC_NEXT)->EnableWindow(true);

	if(m_ImageData.IsOpen())
	{
		m_ImageData.Close();
	}

	CString strSQL;
    strSQL.Format("select * from Image");
	m_ImageData.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);

	if (m_ImageData.GetRecordCount()!=0)
	{
		flag = 1;
        bOnlist = 1;

		m_ImageData.MoveFirst();
		
		m_ImageID = m_ImageData.m_ID;
		m_Image = m_ImageData.m_ImagePath + m_ImageData.m_ImageName;
		m_curImagePath = m_Image;
		
		m_Car = m_ImageData.m_PeccancyNumber;
		UpdateData(false);
		
		OnPaint();
	}
	else
	{
		flag = 0;
		char strdirectoury[50];
		CString str;
		GetCurrentDirectory(50,strdirectoury);
		
		str.Format("%s",strdirectoury);
		str+="\\res\\数据库没图像.bmp";
		m_Image=str;
		OnPaint();	
	}
}
//最后一条
void CPeccancyDlg::OnLast() 
{
	GetDlgItem(IDC_PREV)->EnableWindow(true);
	GetDlgItem(IDC_NEXT)->EnableWindow(true);
		
	if(m_ImageData.IsOpen())
	{
		m_ImageData.Close();
	}
	
    CString strSQL;
    strSQL.Format("select * from Image");
	m_ImageData.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	
	if (m_ImageData.GetRecordCount() != 0)
	{
		flag = 1;
        bOnlist = 1;
		
		m_ImageData.MoveLast();
		
		m_ImageID = m_ImageData.m_ID;
		m_Image = m_ImageData.m_ImagePath + m_ImageData.m_ImageName;
		m_curImagePath = m_Image;
		
		m_Car = m_ImageData.m_PeccancyNumber;
		UpdateData(false);
		
		OnPaint();
	}
	else
	{
		flag = 0;
		char strdirectoury[50];
		CString str;
		GetCurrentDirectory(50,strdirectoury);
		
		str.Format("%s",strdirectoury);
		str+="\\res\\数据库没图像.bmp";
		m_Image=str;
		OnPaint();		
	}
}
//上一条
void CPeccancyDlg::OnPrev() 
{
    if (m_ImageData.GetRecordCount() != 0)
	{
		flag = 1;
		m_ImageData.MovePrev();
		
		if (!m_ImageData.IsBOF())
		{
			bOnlist = 1;
			
			m_ImageID = m_ImageData.m_ID;
			m_Image = m_ImageData.m_ImagePath + m_ImageData.m_ImageName;
			m_curImagePath = m_Image;
			
			m_Car = m_ImageData.m_PeccancyNumber;
			UpdateData(false);

			OnPaint();
		}
		else
		{
			AfxMessageBox("这已经是第一张图像了!");
			m_ImageData.MoveNext();	
		}		
	}
	else
	{
		flag = 0;
		char strdirectoury[50];
		CString str;
		GetCurrentDirectory(50,strdirectoury);
		
		str.Format("%s",strdirectoury);
		str+="\\res\\数据库没图像.bmp";
		m_Image=str;
		OnPaint();		
	}
}
//下一条
void CPeccancyDlg::OnNext() 
{
	if(m_ImageData.GetRecordCount() != 0)
	{
        flag = 1;
		m_ImageData.MoveNext();
			
        if (!m_ImageData.IsEOF())
		{
			bOnlist = 1;

			m_ImageID = m_ImageData.m_ID;
			m_Image = m_ImageData.m_ImagePath + m_ImageData.m_ImageName;
			m_curImagePath = m_Image;
		
		    m_Car = m_ImageData.m_PeccancyNumber;
			UpdateData(false);

            OnPaint();
		}
		else
		{
			AfxMessageBox("这已经是最后一张图像了!");
			m_ImageData.MovePrev();	
		}
	}
	else
	{
		flag = 0;
		char strdirectoury[50];
		CString str;
		GetCurrentDirectory(50,strdirectoury);
		
		str.Format("%s",strdirectoury);
		str+="\\res\\数据库没图像.bmp";
		m_Image=str;
		OnPaint();		
	}
}