courseinfo.cpp

vc+sql server数据库开发实例一书的源文件特意分享一下

// CourseInfo.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "CourseInfo.h"
#include "CourseSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCourseInfo dialog


CCourseInfo::CCourseInfo(CWnd* pParent /*=NULL*/)
	: CDialog(CCourseInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCourseInfo)
	m_class = _T("");
	m_cname = _T("");
	m_ename = _T("");
	m_discription = _T("");
	m_duration = 0;
	m_equivalent = 0;
	m_before = 0;
	m_bookname = _T("");
	m_mark = 0;
	m_dept = 0;
	//}}AFX_DATA_INIT
}


void CCourseInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCourseInfo)
	DDX_Text(pDX, IDC_EDIT1, m_class);
	DDX_Text(pDX, IDC_EDIT2, m_cname);
	DDX_Text(pDX, IDC_EDIT3, m_ename);
	DDX_Text(pDX, IDC_EDIT4, m_discription);
	DDX_Text(pDX, IDC_EDIT5, m_duration);
	DDX_Text(pDX, IDC_EDIT6, m_equivalent);
	DDX_Text(pDX, IDC_EDIT7, m_before);
	DDX_Text(pDX, IDC_EDIT8, m_bookname);
	DDX_Text(pDX, IDC_EDIT9, m_mark);
	DDX_Text(pDX, IDC_EDIT10, m_dept);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CCourseInfo message handlers

void CCourseInfo::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CString strSQL;
//	CResourceSet m_recordset(&m_database);
	int i=1;
	int flag=0;
	while(!flag){
		CCourseSet m_recordset(&m_database);
		strSQL.Format("select * from COURSE where COURSE_ID=%d",i);
		m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
		if(m_recordset.GetRecordCount()==0){
			strSQL.Format("insert into COURSE values(%d,\'%s\',\'%s\',\'%s\',\'%s\',%d,\'%s\',%d,%d,%d,%d)",i,m_class,m_cname,m_ename,m_discription,m_duration,m_bookname,m_equivalent,m_before,m_mark,m_dept);
			m_database.ExecuteSQL(strSQL);
			m_database.Close();
			CDialog::OnOK();
			flag=1;
		}
		i++;
		//m_recordset.Delete();
	}	
	CDialog::OnOK();
}

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

void CCourseInfo::OnButtonreset() 
{
	// TODO: Add your control notification handler code here
	m_before=0;
	m_bookname.Empty();
	m_class.Empty();
	m_cname.Empty();
	m_ename.Empty();
	m_dept=0;
	m_discription.Empty();
	m_duration=0;
	m_equivalent=0;
	m_mark=0;
	UpdateData(FALSE);
}