?? 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();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -