datafinddlg.cpp

使用ODBC访问SQL数据库

// DataFindDlg.cpp : implementation file
//

#include "stdafx.h"
#include "testODBC4.h"
#include "DataFindDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDataFindDlg dialog


CDataFindDlg::CDataFindDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDataFindDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDataFindDlg)
	m_id = 0;
	//}}AFX_DATA_INIT
}


void CDataFindDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDataFindDlg)
	DDX_Control(pDX, IDC_LIST1, m_list1);
	DDX_Text(pDX, IDC_EDIT_ID, m_id);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDataFindDlg, CDialog)
	//{{AFX_MSG_MAP(CDataFindDlg)
	ON_BN_CLICKED(IDC_BUTTON_Design, OnBUTTONDesign)
	ON_BN_CLICKED(IDC_BUTTON_Last, OnBUTTONLast)
	ON_BN_CLICKED(IDC_BUTTON_Practice, OnBUTTONPractice)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDataFindDlg message handlers

BOOL CDataFindDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	// 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,80);
	m_list1.InsertColumn(3,"数学",LVCFMT_LEFT,60);
	m_list1.InsertColumn(4,"物理",LVCFMT_LEFT,60);
	m_list1.InsertColumn(5,"英语",LVCFMT_LEFT,60);
	m_list1.InsertColumn(6,"政治",LVCFMT_LEFT,60);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDataFindDlg::OnBUTTONDesign() 
{
	UpdateData(TRUE);
	BOOL findflag=0;
	m_Pset->MoveFirst();
	CString ItemStr;
	while(!m_Pset->IsEOF())
	{
		if(m_Pset->m_id == m_id)
		{
			
			ItemStr = "课设成绩";
			m_list1.InsertItem(0,"A",0);
			m_list1.SetItemText(0,0,ItemStr);

			ItemStr.Format("%d",m_Pset->m_id);	
			m_list1.SetItemText(0,1,ItemStr);
			ItemStr = m_Pset->m_name;
			m_list1.SetItemText(0,2,ItemStr);
		
			ItemStr.Format("%4.2f",m_Pset->m_math);
			m_list1.SetItemText(0,3,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_physics);
			m_list1.SetItemText(0,4,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_english);
			m_list1.SetItemText(0,5,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_politics);
			m_list1.SetItemText(0,6,ItemStr);		
			findflag=1;
			break;
		}
		else
			m_Pset->MoveNext();
	}
	if(!findflag)
		MessageBox("输入学号不存在！");
}

void CDataFindDlg::OnBUTTONLast() 
{
	UpdateData(TRUE);
	BOOL findflag=0;
	m_Pset->MoveFirst();
	CString ItemStr;
	while(!m_Pset->IsEOF())
	{
		if(m_Pset->m_id == m_id)
		{
			
			ItemStr = "期末成绩";
			m_list1.InsertItem(0,"A",0);
			m_list1.SetItemText(0,0,ItemStr);

			ItemStr.Format("%d",m_Pset->m_id);	
			m_list1.SetItemText(0,1,ItemStr);
			ItemStr = m_Pset->m_name;
			m_list1.SetItemText(0,2,ItemStr);
		
			ItemStr.Format("%4.2f",m_Pset->m_math-4);
			m_list1.SetItemText(0,3,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_physics*0.92);
			m_list1.SetItemText(0,4,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_english/2);
			m_list1.SetItemText(0,5,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_politics/6+80);
			m_list1.SetItemText(0,6,ItemStr);		
			findflag=1;
			break;
		}
		else
			m_Pset->MoveNext();
	}
	if(!findflag)
		MessageBox("输入学号不存在！");	
}

void CDataFindDlg::OnBUTTONPractice() 
{
	UpdateData(TRUE);
	BOOL findflag=0;
	m_Pset->MoveFirst();
	CString ItemStr;
	while(!m_Pset->IsEOF())
	{
		if(m_Pset->m_id == m_id)
		{
			
			ItemStr = "实习成绩";
			m_list1.InsertItem(0,"A",0);
			m_list1.SetItemText(0,0,ItemStr);

			ItemStr.Format("%d",m_Pset->m_id);	
			m_list1.SetItemText(0,1,ItemStr);
			ItemStr = m_Pset->m_name;
			m_list1.SetItemText(0,2,ItemStr);
		
			ItemStr.Format("%4.2f",m_Pset->m_math*0.8);
			m_list1.SetItemText(0,3,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_physics*0.9);
			m_list1.SetItemText(0,4,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_english*0.67);
			m_list1.SetItemText(0,5,ItemStr);
			ItemStr.Format("%4.2f",m_Pset->m_politics*1.1);
			m_list1.SetItemText(0,6,ItemStr);		
			findflag=1;
			break;
		}
		else
			m_Pset->MoveNext();
	}
	if(!findflag)
		MessageBox("输入学号不存在！");	
}