?? peccancydlg.cpp
字號(hào):
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("確定要?jiǎng)h除該記錄嗎？", "提示信息", 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("確實(shí)需要?jiǎng)h除該圖像嗎?",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("請(qǐng)輸入車牌號(hào)碼!");
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\\數(shù)據(jù)庫(kù)沒圖像.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\\數(shù)據(jù)庫(kù)沒圖像.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("這已經(jīng)是第一張圖像了!");
m_ImageData.MoveNext();
}
}
else
{
flag = 0;
char strdirectoury[50];
CString str;
GetCurrentDirectory(50,strdirectoury);
str.Format("%s",strdirectoury);
str+="\\res\\數(shù)據(jù)庫(kù)沒圖像.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("這已經(jīng)是最后一張圖像了!");
m_ImageData.MovePrev();
}
}
else
{
flag = 0;
char strdirectoury[50];
CString str;
GetCurrentDirectory(50,strdirectoury);
str.Format("%s",strdirectoury);
str+="\\res\\數(shù)據(jù)庫(kù)沒圖像.bmp";
m_Image=str;
OnPaint();
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -