dgctview.cpp

来自「难得的activeX控件基础及应用程序」· C++ 代码 · 共 242 行

// DGCTView.cpp : implementation of the CDGCTView class
//

#include "stdafx.h"
#include "DGCT.h"

#include "DGCTDoc.h"
#include "DGCTView.h"


#include "column.h"
#include "columns.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDGCTView

IMPLEMENT_DYNCREATE(CDGCTView, CView)

BEGIN_MESSAGE_MAP(CDGCTView, CView)
	//{{AFX_MSG_MAP(CDGCTView)
	ON_WM_CREATE()
	ON_WM_SIZE()
	ON_COMMAND(ID_TABLE_INSERT_COLUMN, OnTableInsertColumn)
	ON_COMMAND(ID_TABLE_APPEND_ROW, OnTableAppendRow)
	ON_WM_DESTROY()
	ON_COMMAND(ID_TABLE_ADJUST_WIDTH, OnTableAdjustWidth)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDGCTView construction/destruction

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

}

CDGCTView::~CDGCTView()
{
}

BOOL CDGCTView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CView::PreCreateWindow(cs);
}

/////////////////////////////////////////////////////////////////////////////
// CDGCTView drawing

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

/////////////////////////////////////////////////////////////////////////////
// CDGCTView printing

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

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

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

/////////////////////////////////////////////////////////////////////////////
// CDGCTView diagnostics

#ifdef _DEBUG
void CDGCTView::AssertValid() const
{
	CView::AssertValid();
}

void CDGCTView::Dump(CDumpContext& dc) const
{
	CView::Dump(dc);
}

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

/////////////////////////////////////////////////////////////////////////////
// CDGCTView message handlers

int CDGCTView::OnCreate(LPCREATESTRUCT lpCreateStruct) 
{
	if (CView::OnCreate(lpCreateStruct) == -1)
		return -1;
	
	// TODO: Add your specialized creation code here
	m_DataGrid.Create(NULL, WS_VISIBLE|WS_CHILD, CRect(0,0,0,0), \
		this, IDC_DATAGRID);

	return 0;
}

void CDGCTView::OnInitialUpdate() 
{
	CView::OnInitialUpdate();
	
	// TODO: Add your specialized code here and/or call the base class
	::CoInitialize(NULL);	// 初始化组件库
	m_pCN.CreateInstance(__uuidof(Connection));	
	m_pRS.CreateInstance(__uuidof(Recordset));

	// 打开数据库和表
	CString strCN;
	strCN.Format(_T("Provider=Microsoft.Jet.OLEDB.4.0;")
		_T("Data Source=note.mdb"));
	m_pCN->Open(bstr_t(strCN),"","",0);
	m_pRS->CursorLocation=adUseClient;
	m_pRS->Open("select * from info", m_pCN.GetInterfacePtr(),
		 adOpenDynamic, adLockOptimistic, adCmdText);

	// 为DataGrid控件设置数据源属性
	m_DataGrid.SetRefDataSource((LPUNKNOWN)m_pRS);
}

void CDGCTView::OnSize(UINT nType, int cx, int cy) 
{
	CView::OnSize(nType, cx, cy);
	
	// TODO: Add your message handler code here
	CRect clientRect;
	GetClientRect(&clientRect);
	m_DataGrid.MoveWindow(&clientRect);
}

void CDGCTView::OnTableInsertColumn() 
{
	// TODO: Add your command handler code here
	CColumns cols=m_DataGrid.GetColumns();
	int c=cols.GetCount();
	cols.Add(c);
}

void CDGCTView::OnTableAppendRow() 
{
	// TODO: Add your command handler code here
	m_DataGrid.SetAllowAddNew(TRUE);
	m_pRS->MoveLast();
	long pos=m_pRS->GetAbsolutePosition();
	m_DataGrid.SetRow(short(pos));
	m_DataGrid.SetCol(0);
	m_DataGrid.SetFocus();
}

void CDGCTView::OnDestroy() 
{
	CView::OnDestroy();
	
	// TODO: Add your message handler code here
	if(m_pRS)
	{
		m_pRS->Close();
		m_pRS.Release();
	}
	if(m_pCN)
	{
		m_pCN->Close();
		m_pCN.Release();
	}
	::CoUninitialize();
}

BEGIN_EVENTSINK_MAP(CDGCTView, CView)
    //{{AFX_EVENTSINK_MAP(CTestGridDlg)
	ON_EVENT(CDGCTView, IDC_DATAGRID, 216 /* HeadClick */, OnHeadClickDatagrid, VTS_I2)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

static int flag=0;  // flag=0升序,否则降序
void CDGCTView::OnHeadClickDatagrid(short ColIndex)
{
	CString strSQL;
	flag=!flag;

	// 获得ADO所连接数据库的字段名
	FieldsPtr  pFields=m_pRS->GetFields();
	FieldPtr   pField=pFields->GetItem(ColIndex);
	strSQL.Format(_T("select * from info order by %s %s;"),
		(char*)_bstr_t(pField->GetName()), (flag)?_T("desc"):_T("asc"));

	// 按照新的顺序获得数据
	m_pRS->Close();
	m_pRS->Open((char*)LPCTSTR(strSQL), m_pCN.GetInterfacePtr(),
		 adOpenDynamic, adLockOptimistic, adCmdText);
	
	m_DataGrid.SetRefDataSource((LPUNKNOWN)m_pRS);
}

void CDGCTView::OnTableAdjustWidth() 
{
	// TODO: Add your command handler code here
	CRect rc;
	m_DataGrid.GetClientRect(&rc);
	CColumns cols =m_DataGrid.GetColumns();
	
	int colnum=cols.GetCount();	 //取得DataGrid控件的列数
	float fwidth =(float)rc.Width()/colnum;	//求每列宽度
	VARIANT vt;		// VARIANT是控件的特有类型
	vt.vt =VT_INT;
	
	for(int i=0;i<colnum;i++)
	{
		//设置每列宽度
		vt.intVal =i;
		CColumn col =cols.GetItem(vt);
		col.SetWidth(fwidth);	//指定宽度
	}

}