mystudentset.cpp

自编的一个实用的学生成绩处理管理系统。支持.dbf文件

// MyStudentSet.cpp : implementation of the CMyStudentSet class
//

#include "stdafx.h"
#include "MyStudent.h"
#include "MyStudentSet.h"
#include "SetDialog.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMyStudentSet implementation

IMPLEMENT_DYNAMIC(CMyStudentSet, CRecordset)

CMyStudentSet::CMyStudentSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMyStudentSet)
	m_class = _T("");
	m_normal = 0;
	m_endterm = 0;
	m_midterm = 0;
	m_name = _T("");
	m_idnum = 0;
	m_stunum = _T("");
	m_final = 0;
	m_note = _T("");
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
	CSetDialog setdialog;
	m_dsn_name=setdialog.m_dsn_name;//设置数据源名和表名
	m_table_name=setdialog.m_table_name;
}

CString CMyStudentSet::GetDefaultConnect()
{

	return _T("ODBC;DSN="+m_dsn_name);
}

CString CMyStudentSet::GetDefaultSQL()
{
	CString temp=_T("                               ");
	if(m_dsn_name==_T(""))
	{
		m_table_name=m_pDatabase->GetConnect();//获取连接字符串，从中取出也数据源名相同的表名。
		for(int i=9;;i++)
		{
			if(m_table_name.GetAt(i)==';')break;
			temp.SetAt(i-9,m_table_name.GetAt(i));
		}
		m_table_name=temp;
		return _T("["+m_table_name+"]");
	}
		return _T("["+m_dsn_name+"]");

}

void CMyStudentSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMyStudentSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[班级]"), m_class);
	RFX_Long(pFX, _T("[平时]"), m_normal);
	RFX_Long(pFX, _T("[期末]"), m_endterm);
	RFX_Long(pFX, _T("[期中]"), m_midterm);
	RFX_Text(pFX, _T("[姓名]"), m_name);
	RFX_Long(pFX, _T("[序号]"), m_idnum);
	RFX_Text(pFX, _T("[学号]"), m_stunum);
	RFX_Long(pFX, _T("[最终]"), m_final);
	RFX_Text(pFX, _T("[备注]"), m_note);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CMyStudentSet diagnostics

#ifdef _DEBUG
void CMyStudentSet::AssertValid() const
{
	CRecordset::AssertValid();
}

void CMyStudentSet::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG

void CMyStudentSet::OnSetOptions(HSTMT hstmt) 
{
	// TODO: Add your specialized code here and/or call the base class
	
	CRecordset::OnSetOptions(hstmt);
}