scoreinfo.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// ScoreInfo.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "ScoreInfo.h"
#include "ScoreSet.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CScoreInfo dialog


CScoreInfo::CScoreInfo(CWnd* pParent /*=NULL*/)
	: CDialog(CScoreInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(CScoreInfo)
	m_personid = 0;
	m_courseid = 0;
	m_site = _T("");
	m_teacherid = 0;
	m_score2 = 0;
	m_score1 = 0;
	m_teachernote = _T("");
	//m_date = COleDateTime::GetCurrentTime();
	//}}AFX_DATA_INIT
}


void CScoreInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CScoreInfo)
	DDX_Text(pDX, IDC_EDIT2, m_courseid);
	DDX_Text(pDX, IDC_EDIT4, m_site);
	DDX_Text(pDX, IDC_EDIT9, m_teacherid);
	DDX_Text(pDX, IDC_EDIT7, m_score2);
	DDX_Text(pDX, IDC_EDIT6, m_score1);
	DDX_Text(pDX, IDC_EDIT8, m_teachernote);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER2, m_date);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CScoreInfo, CDialog)
	//{{AFX_MSG_MAP(CScoreInfo)
	ON_BN_CLICKED(IDC_BUTTONRESET, OnButtonreset)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CScoreInfo message handlers

void CScoreInfo::OnCancel() 
{
	// TODO: Add extra cleanup here
	m_database.Close();
	CDialog::OnCancel();
}

void CScoreInfo::OnButtonreset() 
{
	// TODO: Add your control notification handler code here
	m_courseid=0;
	m_personid=0;
	m_score1=0;
	m_score2=0;
	m_site.Empty();
	m_teacherid=0;
	UpdateData(FALSE);
}

void CScoreInfo::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	int m_check;
	int choice=CDialog::GetCheckedRadioButton(IDC_RADIO1,IDC_RADIO1);
	if(choice==IDC_RADIO1) m_check=1;
	else m_check=0;
	CString strSQL;
//	CResourceSet m_recordset(&m_database);
	CScoreSet m_recordset(&m_database);
	strSQL.Format("insert into SCORE values(%d,%d,\'%d-%d-%d\',\'%s\',%d,%d,%d,\'%s\',%d)",person_id,m_courseid,m_date.GetYear(),m_date.GetMonth(),m_date.GetDay(),m_site,m_teacherid,m_score1,m_score2,m_teachernote,m_check);
	m_database.ExecuteSQL(strSQL);
	m_database.Close();
	CDialog::OnOK();
}