?? xiahuaview.cpp
字號(hào):
// xiahuaView.cpp : implementation of the CXiahuaView class
//
#include "stdafx.h"
#include "xiahua.h"
#include "xiahuaDoc.h"
#include "xiahuaView.h"
#include "infodlg.h"
#include "resource.h"
#include "mainfrm.h"
#include "iostream.h"
#include "logindlg.h"
#include "record.h"
#include "modpswd.h"
#include "adduser.h"
#include "deluser.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CXiahuaView
IMPLEMENT_DYNCREATE(CXiahuaView, CListView)
BEGIN_MESSAGE_MAP(CXiahuaView, CListView)
ON_WM_CONTEXTMENU()
//{{AFX_MSG_MAP(CXiahuaView)
ON_NOTIFY_REFLECT(LVN_COLUMNCLICK, OnColumnclick)
ON_COMMAND(ID_RECORD_ADD, OnRecordAdd)
ON_COMMAND(ID_RECORD_DEL, OnRecordDel)
ON_UPDATE_COMMAND_UI(ID_RECORD_DEL, OnUpdateRecordDel)
ON_COMMAND(ID_RECORD_SEARCH, OnRecordSearch)
ON_COMMAND(ID_RECORD_ALL, OnRecordShowAll)
ON_COMMAND(ID_RECORD_EDIT, OnRecordEdit)
ON_NOTIFY_REFLECT(NM_DBLCLK, OnDblclk)
ON_COMMAND(ID_PASSWARD_EDIT, OnPasswardEdit)
ON_COMMAND(ID_RECORD_VIEW, OnRecordView)
ON_COMMAND(ID_USER_ADD, OnUserAdd)
ON_COMMAND(ID_USER_DEL, OnUserDel)
ON_UPDATE_COMMAND_UI(ID_RECORD_EDIT, OnUpdateRecordEdit)
ON_UPDATE_COMMAND_UI(ID_RECORD_VIEW, OnUpdateRecordView)
//}}AFX_MSG_MAP
// Standard printing commands
ON_COMMAND(ID_FILE_PRINT, CListView::OnFilePrint)
ON_COMMAND(ID_FILE_PRINT_DIRECT, CListView::OnFilePrint)
ON_COMMAND(ID_FILE_PRINT_PREVIEW, CListView::OnFilePrintPreview)
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CXiahuaView construction/destruction
CXiahuaView::CXiahuaView()
{
// TODO: add construction code here
}
CXiahuaView::~CXiahuaView()
{
}
BOOL CXiahuaView::PreCreateWindow(CREATESTRUCT& cs)
{
// TODO: Modify the Window class or styles here by modifying
// the CREATESTRUCT cs
return CListView::PreCreateWindow(cs);
}
/////////////////////////////////////////////////////////////////////////////
// CXiahuaView drawing
void CXiahuaView::OnDraw(CDC* pDC)
{
CXiahuaDoc* pDoc = GetDocument();
ASSERT_VALID(pDoc);
// TODO: add draw code for native data here
}
//初始化窗口；
void CXiahuaView::OnInitialUpdate()
{
CListView::OnInitialUpdate();
// TODO: You may populate your ListView with items by directly accessing
CListCtrl &ctl=GetListCtrl();
ctl.ModifyStyle(0,LVS_REPORT|LVS_SINGLESEL);
ctl.SetExtendedStyle(LVS_EX_FLATSB|LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
m_pSet=&GetDocument()->m_dataSet; //初始化m_pSet指針，m_pSet原型為CDataSet* m_pSet
m_pLset=&GetDocument()->m_dataLset; //初始化m_pLset指針，m_pLset原型為CLoginSet* m_pLset
if(m_pSet->IsOpen())
m_pSet->Close();
m_pSet->Open(); //打開數(shù)據(jù)庫
GetDocument()->SetTitle("彩電故障信息共享系統(tǒng)");//設(shè)置標(biāo)題
CString str;
//以下是設(shè)置控件按鈕顯示字符
str.LoadString(IDS_SERIAL);
ctl.InsertColumn(0,str);
/*CDaoFieldInfo fieldInfo;
for(short i=0;i<m_pSet->m_nFields;i++)
{
m_pSet->GetFieldInfo(i,fieldInfo);
ctl.InsertColumn(i+1,fieldInfo.m_strName);
}*/
ctl.InsertColumn(1,"顯象管");
ctl.InsertColumn(2,"機(jī)芯");
ctl.InsertColumn(3,"機(jī)殼");
ctl.InsertColumn(4,"器件");
ctl.InsertColumn(5,"技術(shù)員");
ctl.InsertColumn(6,"時(shí)間");
ctl.InsertColumn(7,"其他");
ctl.InsertColumn(8,"信息名");
ctl.InsertColumn(9,"具體內(nèi)容");
m_bIsAsc=TRUE;
m_bIsShowAll=TRUE;
ShowTableData(); //調(diào)用顯示數(shù)據(jù)函數(shù)，顯示數(shù)據(jù)
}
/////////////////////////////////////////////////////////////////////////////
// CXiahuaView printing
BOOL CXiahuaView::OnPreparePrinting(CPrintInfo* pInfo)
{
// default preparation
return DoPreparePrinting(pInfo);
}
void CXiahuaView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
// TODO: add extra initialization before printing
}
void CXiahuaView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
// TODO: add cleanup after printing
}
/////////////////////////////////////////////////////////////////////////////
// CXiahuaView diagnostics
#ifdef _DEBUG
void CXiahuaView::AssertValid() const
{
CListView::AssertValid();
}
void CXiahuaView::Dump(CDumpContext& dc) const
{
CListView::Dump(dc);
}
CXiahuaDoc* CXiahuaView::GetDocument() // non-debug version is inline
{
ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CXiahuaDoc)));
return (CXiahuaDoc*)m_pDocument;
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CXiahuaView message handlers
//顯示表格數(shù)據(jù)；
void CXiahuaView::ShowTableData()
{
CListCtrl &ctl=GetListCtrl();
ctl.DeleteAllItems(); //刪除所有已顯示內(nèi)容
m_pSet->MoveFirst(); //將m_pSet指針指向首條記錄
int i=0;
int ColWidth[10]={0};
while(!m_pSet->IsEOF()) //如果沒有到達(dá)數(shù)據(jù)末尾，則顯示數(shù)據(jù)
{
LV_ITEM lvItem;
lvItem.mask = LVIF_TEXT;
lvItem.iItem = i;
lvItem.iSubItem=0;
CString str;
str.Format("%d",i+1); //序號(hào)列
lvItem.pszText=(LPTSTR)(LPCTSTR)str;
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[0])
ColWidth[0]=ctl.GetStringWidth(lvItem.pszText);
ctl.InsertItem(&lvItem);
//以下顯示各條內(nèi)容
lvItem.iSubItem = 1;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_crt);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[1])
ColWidth[1]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=2;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_clips);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[2])
ColWidth[2]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=3;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_case);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[3])
ColWidth[3]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=4;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_device);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[4])
ColWidth[4]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=5;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_workor);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[5])
ColWidth[5]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=6;
//CString stTmp =m_pSet->m_date.Format("%Y-%m-%d");// %H:%M:%S
//strcpy(lvItem.pszText,(LPSTR)(LPCSTR)stTmp);
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_date);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[6])
ColWidth[6]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=7;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_other);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[7])
ColWidth[7]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=8;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_info);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[8])
ColWidth[8]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
lvItem.iSubItem=9;
lvItem.pszText=(LPTSTR)(LPCTSTR)(m_pSet->m_content);
if(ctl.GetStringWidth(lvItem.pszText)>ColWidth[9])
ColWidth[9]=ctl.GetStringWidth(lvItem.pszText);
ctl.SetItem(&lvItem);
i++;
m_pSet->MoveNext(); //將m_pSet指針指向下條記錄
}
//設(shè)置各數(shù)據(jù)項(xiàng)的顯示寬度
for(int j=0;j<8;j++)
{
ctl.SetColumnWidth(j,ColWidth[j]+30);
}
ctl.SetColumnWidth(8,100);
ctl.SetColumnWidth(9,100);
m_pSet->MoveFirst(); //將m_pSet指針再指向首條記錄，便于下次操作
}
//當(dāng)單擊上方時(shí)，按所列的數(shù)據(jù)進(jìn)行排序
void CXiahuaView::Sort(BOOL isAsc)
{
CDaoFieldInfo fieldInfo;
m_pSet->GetFieldInfo(0,fieldInfo);
if(isAsc)
{
//AfxMessageBox(fieldInfo.m_strName,MB_ICONEXCLAMATION);
m_pSet->m_strSort=fieldInfo.m_strName+" ASC";
m_bIsAsc=TRUE;
}
else
{
m_pSet->m_strSort=fieldInfo.m_strName+" DESC";
m_bIsAsc=FALSE;
}
m_pSet->Requery();
}
//響應(yīng)單擊事件；
void CXiahuaView::OnColumnclick(NMHDR* pNMHDR, LRESULT* pResult)
{
NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
// TODO: Add your control notification handler code here
Sort(!m_bIsAsc);
ShowTableData();
*pResult = 0;
}
//增加數(shù)據(jù)函數(shù)；
void CXiahuaView::OnRecordAdd()
{
// TODO: Add your command handler code here
if(memberright()==0)
return;
else
{
CInfoDlg addDlg;
if(addDlg.DoModal()==IDOK)
{
CString crt;
crt=addDlg.m_strCrt;
if(addDlg.m_strInfo.IsEmpty())
{
AfxMessageBox(_T("為保證數(shù)據(jù)的有效性,\n請(qǐng)確定您已輸入有效信息"),MB_ICONEXCLAMATION);
OnRecordAdd();
addDlg.m_strCrt=crt;
}
else
{
addDlg.m_strCrt.TrimLeft(" ");
addDlg.m_strCrt.TrimRight(" ");
addDlg.m_strCase.TrimLeft(" ");
addDlg.m_strCase.TrimRight(" ");
addDlg.m_strInfo.TrimLeft(" ");
addDlg.m_strInfo.TrimRight(" ");
addDlg.m_strDate.TrimLeft(" ");
addDlg.m_strDate.TrimRight(" ");
addDlg.m_strDevice.TrimLeft(" ");
addDlg.m_strDevice.TrimRight(" ");
addDlg.m_strClips.TrimLeft(" ");
addDlg.m_strClips.TrimRight(" ");
addDlg.m_strContent.TrimLeft(" ");
addDlg.m_strContent.TrimRight(" ");
addDlg.m_strOther.TrimLeft(" ");
addDlg.m_strOther.TrimRight(" ");
addDlg.m_strWorkor.TrimLeft(" ");
addDlg.m_strWorkor.TrimRight(" ");
m_pSet->AddNew();
m_pSet->m_crt=addDlg.m_strCrt;
m_pSet->m_info=addDlg.m_strInfo;
m_pSet->m_case=addDlg.m_strCase;
m_pSet->m_date=addDlg.m_strDate;
m_pSet->m_device=addDlg.m_strDevice;
m_pSet->m_clips=addDlg.m_strClips;
m_pSet->m_content=addDlg.m_strContent;
m_pSet->m_other=addDlg.m_strOther;
m_pSet->m_workor=addDlg.m_strWorkor;
m_pSet->Update();
Sort(m_bIsAsc);
ShowTableData();
}
}
}
}
//刪除數(shù)據(jù)函數(shù)；
void CXiahuaView::OnRecordDel()
{
// TODO: Add your command handler code here
if(memberright()==0)
return;
else
{
CListCtrl &ctl=GetListCtrl();
POSITION pos=ctl.GetFirstSelectedItemPosition();
if(pos==NULL)
{
AfxMessageBox(_T("沒有選中記錄"),MB_ICONEXCLAMATION);
return;
}
int nItem=ctl.GetNextSelectedItem(pos);
m_pSet->Move(nItem);
CString str1,str2;
str1.LoadString(IDS_WARN_1);
str2.LoadString(IDS_WARN_2);
str1=str1+str2;
if(AfxMessageBox(str1,MB_YESNO|MB_ICONEXCLAMATION)==IDYES)
{
m_pSet->Delete();
m_pSet->MoveFirst();
ShowTableData();
}
}
}
void CXiahuaView::OnUpdateRecordDel(CCmdUI* pCmdUI)
{
// TODO: Add your command update UI handler code here
CListCtrl &ctl=GetListCtrl();
POSITION pos=ctl.GetFirstSelectedItemPosition();
if(pos==NULL)
pCmdUI->Enable(FALSE);
else
pCmdUI->Enable();
}
//右擊彈出菜單；
void CXiahuaView::OnContextMenu(CWnd*, CPoint point)
{
// CG: This block was added by the Pop-up Menu component { if (point.x == -1 && point.y == -1){ //keystroke invocation CRect rect; GetClientRect(rect); ClientToScreen(rect); point = rect.TopLeft(); point.Offset(5, 5); } CMenu menu; VERIFY(menu.LoadMenu(CG_IDR_POPUP_XIAHUA_VIEW)); CMenu* pPopup = menu.GetSubMenu(0); ASSERT(pPopup != NULL); CWnd* pWndPopupOwner = this; while (pWndPopupOwner->GetStyle() & WS_CHILD) pWndPopupOwner = pWndPopupOwner->GetParent(); pPopup->TrackPopupMenu(TPM_LEFTALIGN | TPM_RIGHTBUTTON, point.x, point.y, pWndPopupOwner); }
}
//查詢數(shù)據(jù)函數(shù)；
void CXiahuaView::OnRecordSearch()
{
// TODO: Add your command handler code here
CRecordSearch search;
CString str;
if(search.DoModal()==IDCANCEL)return;
else
{
ASSERT(m_pSet->CanRestart());
search.m_strCrt.MakeLower();
m_bIsShowAll=FALSE;
CDaoFieldInfo fieldInfo;
if(!search.m_strCrt.IsEmpty())
{
fieldInfo.m_strName="顯象管";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strCrt+"'";
m_pSet->Requery();
}
else if(!search.m_strClips.IsEmpty())
{
fieldInfo.m_strName="機(jī)芯";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strClips+"'";
m_pSet->Requery();
}
else if(!search.m_strCase.IsEmpty())
{
fieldInfo.m_strName="機(jī)殼";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strCase+"'";
m_pSet->Requery();
}
else if(!search.m_strDevice.IsEmpty())
{
fieldInfo.m_strName="器件";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strDevice+"'";
m_pSet->Requery();
}
else if(!search.m_strWorkor.IsEmpty())
{
fieldInfo.m_strName="技術(shù)員";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strWorkor+"'";
m_pSet->Requery();
}
else if(!search.m_strDate.IsEmpty())
{
fieldInfo.m_strName="時(shí)間";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strDate+"'";
m_pSet->Requery();
}
else if(!search.m_strOther.IsEmpty())
{
fieldInfo.m_strName="其他";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strOther+"'";
m_pSet->Requery();
}
else if(!search.m_strInfo.IsEmpty())
{
fieldInfo.m_strName="信息名";
m_pSet->m_strFilter=fieldInfo.m_strName+" = "+"'"+search.m_strInfo+"'";
m_pSet->Requery();
}
else
{
AfxMessageBox(_T("請(qǐng)輸入顯象管型號(hào)"),MB_ICONEXCLAMATION);
OnRecordSearch();
}
ShowTableData();
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -