teacherinfo.cpp

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

// TeacherInfo.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "TeacherInfo.h"
#include "TeacherSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTeacherInfo dialog


CTeacherInfo::CTeacherInfo(CWnd* pParent /*=NULL*/)
	: CDialog(CTeacherInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTeacherInfo)
	m_name = _T("");
	m_apprise = _T("");
	m_history = _T("");
	//m_starttime = COleDateTime::GetCurrentTime();
	//}}AFX_DATA_INIT
}


void CTeacherInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTeacherInfo)
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT4, m_apprise);
	DDX_CBString(pDX, IDC_COMBO3, m_history);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER1, m_starttime);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CTeacherInfo message handlers

void CTeacherInfo::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CString strSQL;
//	CResourceSet m_recordset(&m_database);
	int i=1;
	int flag=0;
	while(!flag){
		CTeacherSet m_recordset(&m_database);
		strSQL.Format("select * from TEACHER where TEACHER_ID=%d",i);
		m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if(m_recordset.GetRecordCount()==0){
			strSQL.Format("insert into TEACHER values(%d,\'%s\',\'%s\',\'%d-%d-%d\',\'%s\')",i,m_name,m_history,m_starttime.GetYear(),m_starttime.GetMonth(),m_starttime.GetDay(),m_apprise);
			m_database.ExecuteSQL(strSQL);
			m_database.Close();
			CDialog::OnOK();
			flag=1;
		}
		i++;
		//m_recordset.Delete();
	}
	
	CDialog::OnOK();
}

void CTeacherInfo::OnCancel() 
{
	// TODO: Add extra cleanup here
	CDialog::OnCancel();
}

void CTeacherInfo::OnButtonreset() 
{
	// TODO: Add your control notification handler code here
	m_name.Empty();
	m_history.Empty();
	m_apprise.Empty();
	UpdateData(FALSE);
	
}