ssfset.cpp

一个由MFC做的学生信息管理系统

// SSFSet.cpp : implementation of the CSSFSet class
//

#include "stdafx.h"
#include "SSF.h"
#include "SSFSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSSFSet implementation

IMPLEMENT_DYNAMIC(CSSFSet, CRecordset)

CSSFSet::CSSFSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CSSFSet)
	m_code = _T("");
	m_name = _T("");
	m_department = _T("");
	m_major = _T("");
	m_teacher = _T("");
	m_brief = _T("");
	m_code2 = _T("");
	m_name2 = _T("");
	m_class_past = _T("");
	m_class_now = _T("");
	m_date = _T("");
	m_reason = _T("");
	m_code3 = _T("");
	m_name3 = _T("");
	m_brief2 = _T("");
	m_code4 = _T("");
	m_name4 = _T("");
	m_ID = _T("");
	m_time = _T("");
	m_code5 = _T("");
	m_name5 = _T("");
	m_ID2 = _T("");
	m_code6 = _T("");
	m_name6 = _T("");
	m_class = _T("");
	m_date2 = _T("");
	m_content = _T("");
	m_brief3 = _T("");
	m_code7 = _T("");
	m_name7 = _T("");
	m_class2 = _T("");
	m_date3 = _T("");
	m_reason2 = _T("");
	m_code8 = _T("");
	m_name8 = _T("");
	m_department2 = _T("");
	m_brief4 = _T("");
	m_code9 = _T("");
	m_name9 = _T("");
	m_department3 = _T("");
	m_major2 = _T("");
	m_class3 = _T("");
	m_date4 = _T("");
	m_brief5 = _T("");
	m_ID3 = _T("");
	m_name10 = _T("");
	m_type = _T("");
	m_level = _T("");
	m_person = _T("");
	m_brief6 = _T("");
	m_date5 = _T("");
	m_ID4 = _T("");
	m_class4 = _T("");
	m_time2 = _T("");
	m_code10 = _T("");
	m_name11 = _T("");
	m_subject = _T("");
	m_type2 = _T("");
	m_score = _T("");
	m_makeup_score = _T("");
	m_absent = _T("");
	m_code11 = _T("");
	m_name12 = _T("");
	m_sex = _T("");
	m_folk = _T("");
	m_birth = _T("");
	m_political = _T("");
	m_IDcard = _T("");
	m_department4 = _T("");
	m_major3 = _T("");
	m_class5 = _T("");
	m_phone = _T("");
	m_enroll_date = _T("");
	m_graduate_date = _T("");
	m_address = _T("");
	m_code12 = _T("");
	m_name13 = _T("");
	m_class6 = _T("");
	m_date6 = _T("");
	m_time3 = _T("");
	m_reason3 = _T("");
	m_code13 = _T("");
	m_name14 = _T("");
	m_class7 = _T("");
	m_date7 = _T("");
	m_reason4 = _T("");
	m_user = _T("");
	m_passwd = _T("");
	m_type3 = _T("");
	m_nFields = 89;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CSSFSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=SSF");
}

CString CSSFSet::GetDefaultSQL()
{
	return _T("[class],[degrade],[department],[examsubject],[examtime],[examtype],[honor],[leave],[major],[outgrade],[scholarship],[score],[student],[suspand],[transfer],[user]");
}

void CSSFSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CSSFSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[class].[code]"), m_code);
	RFX_Text(pFX, _T("[class].[name]"), m_name);
	RFX_Text(pFX, _T("[class].[department]"), m_department);
	RFX_Text(pFX, _T("[class].[major]"), m_major);
	RFX_Text(pFX, _T("[teacher]"), m_teacher);
	RFX_Text(pFX, _T("[class].[brief]"), m_brief);
	RFX_Text(pFX, _T("[degrade].[code]"), m_code2);
	RFX_Text(pFX, _T("[degrade].[name]"), m_name2);
	RFX_Text(pFX, _T("[class_past]"), m_class_past);
	RFX_Text(pFX, _T("[class_now]"), m_class_now);
	RFX_Text(pFX, _T("[degrade].[date]"), m_date);
	RFX_Text(pFX, _T("[degrade].[reason]"), m_reason);
	RFX_Text(pFX, _T("[department].[code]"), m_code3);
	RFX_Text(pFX, _T("[department].[name]"), m_name3);
	RFX_Text(pFX, _T("[department].[brief]"), m_brief2);
	RFX_Text(pFX, _T("[examsubject].[code]"), m_code4);
	RFX_Text(pFX, _T("[examsubject].[name]"), m_name4);
	RFX_Text(pFX, _T("[examtime].[ID]"), m_ID);
	RFX_Text(pFX, _T("[examtime].[time]"), m_time);
	RFX_Text(pFX, _T("[examtype].[code]"), m_code5);
	RFX_Text(pFX, _T("[examtype].[name]"), m_name5);
	RFX_Text(pFX, _T("[honor].[ID]"), m_ID2);
	RFX_Text(pFX, _T("[honor].[code]"), m_code6);
	RFX_Text(pFX, _T("[honor].[name]"), m_name6);
	RFX_Text(pFX, _T("[honor].[class]"), m_class);
	RFX_Text(pFX, _T("[honor].[date]"), m_date2);
	RFX_Text(pFX, _T("[content]"), m_content);
	RFX_Text(pFX, _T("[honor].[brief]"), m_brief3);
	RFX_Text(pFX, _T("[leave].[code]"), m_code7);
	RFX_Text(pFX, _T("[leave].[name]"), m_name7);
	RFX_Text(pFX, _T("[leave].[class]"), m_class2);
	RFX_Text(pFX, _T("[leave].[date]"), m_date3);
	RFX_Text(pFX, _T("[leave].[reason]"), m_reason2);
	RFX_Text(pFX, _T("[major].[code]"), m_code8);
	RFX_Text(pFX, _T("[major].[name]"), m_name8);
	RFX_Text(pFX, _T("[major].[department]"), m_department2);
	RFX_Text(pFX, _T("[major].[brief]"), m_brief4);
	RFX_Text(pFX, _T("[outgrade].[code]"), m_code9);
	RFX_Text(pFX, _T("[outgrade].[name]"), m_name9);
	RFX_Text(pFX, _T("[outgrade].[department]"), m_department3);
	RFX_Text(pFX, _T("[outgrade].[major]"), m_major2);
	RFX_Text(pFX, _T("[outgrade].[class]"), m_class3);
	RFX_Text(pFX, _T("[outgrade].[date]"), m_date4);
	RFX_Text(pFX, _T("[outgrade].[brief]"), m_brief5);
	RFX_Text(pFX, _T("[scholarship].[ID]"), m_ID3);
	RFX_Text(pFX, _T("[scholarship].[name]"), m_name10);
	RFX_Text(pFX, _T("[scholarship].[type]"), m_type);
	RFX_Text(pFX, _T("[level]"), m_level);
	RFX_Text(pFX, _T("[person]"), m_person);
	RFX_Text(pFX, _T("[scholarship].[brief]"), m_brief6);
	RFX_Text(pFX, _T("[scholarship].[date]"), m_date5);
	RFX_Text(pFX, _T("[score].[ID]"), m_ID4);
	RFX_Text(pFX, _T("[score].[class]"), m_class4);
	RFX_Text(pFX, _T("[score].[time]"), m_time2);
	RFX_Text(pFX, _T("[score].[code]"), m_code10);
	RFX_Text(pFX, _T("[score].[name]"), m_name11);
	RFX_Text(pFX, _T("[subject]"), m_subject);
	RFX_Text(pFX, _T("[score].[type]"), m_type2);
	RFX_Text(pFX, _T("[score]"), m_score);
	RFX_Text(pFX, _T("[makeup_score]"), m_makeup_score);
	RFX_Text(pFX, _T("[absent]"), m_absent);
	RFX_Text(pFX, _T("[student].[code]"), m_code11);
	RFX_Text(pFX, _T("[student].[name]"), m_name12);
	RFX_Text(pFX, _T("[sex]"), m_sex);
	RFX_Text(pFX, _T("[folk]"), m_folk);
	RFX_Text(pFX, _T("[birth]"), m_birth);
	RFX_Text(pFX, _T("[political]"), m_political);
	RFX_Text(pFX, _T("[IDcard]"), m_IDcard);
	RFX_Text(pFX, _T("[student].[department]"), m_department4);
	RFX_Text(pFX, _T("[student].[major]"), m_major3);
	RFX_Text(pFX, _T("[student].[class]"), m_class5);
	RFX_Text(pFX, _T("[phone]"), m_phone);
	RFX_Text(pFX, _T("[enroll_date]"), m_enroll_date);
	RFX_Text(pFX, _T("[graduate_date]"), m_graduate_date);
	RFX_Text(pFX, _T("[address]"), m_address);
	RFX_Text(pFX, _T("[suspand].[code]"), m_code12);
	RFX_Text(pFX, _T("[suspand].[name]"), m_name13);
	RFX_Text(pFX, _T("[suspand].[class]"), m_class6);
	RFX_Text(pFX, _T("[suspand].[date]"), m_date6);
	RFX_Text(pFX, _T("[suspand].[time]"), m_time3);
	RFX_Text(pFX, _T("[suspand].[reason]"), m_reason3);
	RFX_Text(pFX, _T("[transfer].[code]"), m_code13);
	RFX_Text(pFX, _T("[transfer].[name]"), m_name14);
	RFX_Text(pFX, _T("[transfer].[class]"), m_class7);
	RFX_Text(pFX, _T("[transfer].[date]"), m_date7);
	RFX_Text(pFX, _T("[transfer].[reason]"), m_reason4);
	RFX_Text(pFX, _T("[user]"), m_user);
	RFX_Text(pFX, _T("[passwd]"), m_passwd);
	RFX_Text(pFX, _T("[user].[type]"), m_type3);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CSSFSet diagnostics

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

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