datastat.cpp

使用ODBC访问SQL数据库

// DataStat.cpp : implementation file
//

#include "stdafx.h"
#include "testODBC4.h"
#include "DataStat.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDataStat dialog


CDataStat::CDataStat(CWnd* pParent /*=NULL*/)
	: CDialog(CDataStat::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDataStat)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CDataStat::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDataStat)
	DDX_Control(pDX, IDC_LIST1, m_list1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDataStat, CDialog)
	//{{AFX_MSG_MAP(CDataStat)
	ON_BN_CLICKED(IDC_BUTTON_Again, OnBUTTONAgain)
	ON_BN_CLICKED(IDC_BUTTON_Average, OnBUTTONAverage)
	ON_BN_CLICKED(IDC_BUTTON_Second, OnBUTTONSecond)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDataStat message handlers

void CDataStat::OnBUTTONAgain() 
{

}

void CDataStat::OnBUTTONAverage() 
{
	float average=0;
	CString ItemStr = "";
	int i=0;
	m_Pset->MoveFirst();
	while(!m_Pset->IsEOF())
	{
		average = (m_Pset->m_math + m_Pset->m_politics +m_Pset->m_physics + m_Pset->m_english)/4;
		ItemStr.Format("%4.2f",average);
		m_list1.SetItemText(i,2,ItemStr);
		m_Pset->MoveNext();
		i++;
	}
}

void CDataStat::OnBUTTONSecond() 
{

}

BOOL CDataStat::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	////////////////////////////////////////////////////////////////////////////
	// list control
	m_list1.DeleteAllItems();
	m_list1.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE,
                0,LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
	m_list1.InsertColumn(0,"学号",LVCFMT_LEFT,80);
	m_list1.InsertColumn(1,"姓名",LVCFMT_LEFT,80);
	m_list1.InsertColumn(2,"平均成绩",LVCFMT_LEFT,90);
	m_list1.InsertColumn(3,"重修成绩",LVCFMT_LEFT,90);
	m_list1.InsertColumn(4,"补考成绩",LVCFMT_LEFT,90);
	m_list1.InsertColumn(5,"备注",LVCFMT_LEFT,80);

	CString ItemStr = "";
	int i=0;
	m_Pset->MoveFirst();
	while(!m_Pset->IsEOF())
	{
		ItemStr.Format("%d",m_Pset->m_id);
		m_list1.InsertItem(i,"A",0);
		m_list1.SetItemText(i,0,ItemStr);
		ItemStr = m_Pset->m_name;
		m_list1.SetItemText(i,1,ItemStr);
	
		m_Pset->MoveNext();
		i++;
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}