ex_adoview.cpp

一系列的c++例子 一步一步由浅入深 有 聊天室

// Ex_ADOView.cpp : implementation of the CEx_ADOView class
//

#include "stdafx.h"
#include "Ex_ADO.h"
#include "EditDlg.h"
#include "Ex_ADODoc.h"
#include "Ex_ADOView.h"
#include "ADOConn.h"
#include "Employees.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CEx_ADOView

IMPLEMENT_DYNCREATE(CEx_ADOView, CListView)

BEGIN_MESSAGE_MAP(CEx_ADOView, CListView)
	//{{AFX_MSG_MAP(CEx_ADOView)
	ON_COMMAND(ID_OP_ADD, OnOpAdd)
	ON_COMMAND(ID_OP_CHA, OnOpCha)
	ON_COMMAND(ID_OP_DEL, OnOpDel)
	//}}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()

/////////////////////////////////////////////////////////////////////////////
// CEx_ADOView construction/destruction

CEx_ADOView::CEx_ADOView()
{
	// TODO: add construction code here

}

CEx_ADOView::~CEx_ADOView()
{
}

BOOL CEx_ADOView::PreCreateWindow(CREATESTRUCT& cs)
{
	cs.style |= LVS_REPORT;		// 报表风格
	return CListView::PreCreateWindow(cs);

}

/////////////////////////////////////////////////////////////////////////////
// CEx_ADOView drawing

void CEx_ADOView::OnDraw(CDC* pDC)
{
	CEx_ADODoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
	// TODO: add draw code for native data here
}

void CEx_ADOView::OnInitialUpdate()
{
	CListView::OnInitialUpdate();
	CListCtrl& m_ListCtrl = GetListCtrl();
	CString strHeader[]={"员工号","员工姓名","性别", " 职务","工资"};
	int nLong[] = {100, 80, 100, 100,100};
	for (int nCol=0; nCol<sizeof(strHeader)/sizeof(CString); nCol++)
		m_ListCtrl.InsertColumn(nCol,strHeader[nCol],LVCFMT_CENTER,nLong[nCol]);
	ResetListItem();
}




/////////////////////////////////////////////////////////////////////////////
// CEx_ADOView printing

BOOL CEx_ADOView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}

void CEx_ADOView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add extra initialization before printing
}

void CEx_ADOView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add cleanup after printing
}

/////////////////////////////////////////////////////////////////////////////
// CEx_ADOView diagnostics

#ifdef _DEBUG
void CEx_ADOView::AssertValid() const
{
	CListView::AssertValid();
}

void CEx_ADOView::Dump(CDumpContext& dc) const
{
	CListView::Dump(dc);
}

CEx_ADODoc* CEx_ADOView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CEx_ADODoc)));
	return (CEx_ADODoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CEx_ADOView message handlers
void CEx_ADOView::ResetListItem()
{
		CListCtrl& m_ListCtrl=GetListCtrl();
        m_ListCtrl.DeleteAllItems();
		int nItem=0;
    	_bstr_t vSQL;
	    vSQL = "SELECT * FROM Employees ORDER BY Emp_id DESC";
		ADOConn m_AdoConn;
    	m_AdoConn.OnInitADOConn();
		_RecordsetPtr m_pRecordset;
	    m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
       
	   	while(!m_pRecordset->adoEOF)
	{
		_variant_t value;
		value=m_pRecordset->GetCollect("Emp_id");
		m_ListCtrl.InsertItem(nItem,(char*)_bstr_t(value));
		value=m_pRecordset->GetCollect("Emp_name");
        m_ListCtrl.SetItemText(nItem,1,(char*)_bstr_t(value));
		value=m_pRecordset->GetCollect("Sex");
		m_ListCtrl.SetItemText(nItem,2,(char*)_bstr_t(value));
        value=m_pRecordset->GetCollect("Title");
        m_ListCtrl.SetItemText(nItem,3,(char*)_bstr_t(value));
        value=m_pRecordset->GetCollect("Wage");
        m_ListCtrl.SetItemText(nItem,4,(char*)_bstr_t(value));
    		m_pRecordset->MoveNext();
	}
			m_AdoConn.ExitConnect();
}

void CEx_ADOView::OnOpAdd() 
{

	CEditDlg dlg;
	dlg.cEmpId = "";
	dlg.strSex = "男";
	if (dlg.DoModal() == IDOK)
	ResetListItem();
}

void CEx_ADOView::OnOpCha() 
{
CListCtrl& m_ListCtrl=GetListCtrl();
POSITION pos;
pos=m_ListCtrl.GetFirstSelectedItemPosition();
if(pos==NULL)	
{
MessageBox("你还没有选中列表项！"); 
}
int nItem=m_ListCtrl.GetNextSelectedItem(pos);
CString strItem;
strItem=m_ListCtrl.GetItemText(nItem,0);
CEditDlg dlg;
dlg.cEmpId=strItem;
CEmployees emp;
emp.GetData(strItem);
dlg.m_EmpName=emp.Emp_name;
dlg.strSex =emp.Sex;
dlg.m_Title=emp.Title;
dlg.m_Wage=emp.Wage;
if(dlg.DoModal()==IDOK)
ResetListItem();
}

void CEx_ADOView::OnOpDel() 
{

	CListCtrl& m_ListCtrl=GetListCtrl();
    POSITION pos;
    pos=m_ListCtrl.GetFirstSelectedItemPosition();

    if(pos==NULL)	
	{
     MessageBox("你还没有选中列表项！"); return;}
     int nItem=m_ListCtrl.GetNextSelectedItem(pos);
     CString strItem;
     strItem=m_ListCtrl.GetItemText(nItem,0);
      CString str;
       str.Format("你确定要删除%s列表项吗?",strItem);
       if(MessageBox(str,"删除确认",MB_ICONQUESTION|MB_OKCANCEL)!=IDOK)  return;
	   	CEmployees emp;
		emp.sql_delete(strItem);
       ResetListItem();

}