// StaffInfo.h : CStaffInfo 类的实现 // CStaffInfo 实现 // 代码生成在 2016年9月25日, 17:50 #include "stdafx.h" #include "StaffInfo.h" IMPLEMENT_DYNAMIC(CStaffInfo, CRecordset) CStaffInfo::CStaffInfo(CDatabase* pdb): CRecordset(pdb) { m_AutoID = 0; m_StudioID = _T(""); m_StaffSN = _T(""); m_StaffName = _T(""); m_StaffGender = FALSE; m_StaffAddress = _T(""); m_StaffOffice = _T(""); m_StaffBirthday = _T(""); m_StaffPhone = _T(""); m_StaffStatus = 0; m_StaffNote = _T(""); m_nFields = 11; m_nDefaultType = dynaset; } //#error 安全问题:连接字符串可能包含密码。 // 此连接字符串中可能包含明文密码和/或其他重要 // 信息。请在查看完此连接字符串并找到所有与安全 // 有关的问题后移除 #error。可能需要将此密码存 // 储为其他格式或使用其他的用户身份验证。 CString CStaffInfo::GetDefaultConnect() { return _T("DSN=EasySelection;Description=EasySelection;Trusted_Connection=Yes;APP=Microsoft\x00ae Visual Studio\x00ae 2010;WSID=IT-PC;DATABASE=EasySelection;"); } CString CStaffInfo::GetDefaultSQL() { return _T("[dbo].[StaffInfo]"); } void CStaffInfo::DoFieldExchange(CFieldExchange* pFX) { pFX->SetFieldType(CFieldExchange::outputColumn); // RFX_Text() 和 RFX_Int() 这类宏依赖的是 // 成员变量的类型,而不是数据库字段的类型。 // ODBC 尝试自动将列值转换为所请求的类型 RFX_Long(pFX, _T("[AutoID]"), m_AutoID); RFX_Text(pFX, _T("[StudioID]"), m_StudioID); RFX_Text(pFX, _T("[StaffSN]"), m_StaffSN); RFX_Text(pFX, _T("[StaffName]"), m_StaffName); RFX_Bool(pFX, _T("[StaffGender]"), m_StaffGender); RFX_Text(pFX, _T("[StaffAddress]"), m_StaffAddress); RFX_Text(pFX, _T("[StaffOffice]"), m_StaffOffice); RFX_Text(pFX, _T("[StaffBirthday]"), m_StaffBirthday); RFX_Text(pFX, _T("[StaffPhone]"), m_StaffPhone); RFX_Byte(pFX, _T("[StaffStatus]"), m_StaffStatus); RFX_Text(pFX, _T("[StaffNote]"), m_StaffNote); } ///////////////////////////////////////////////////////////////////////////// // CStaffInfo 诊断 #ifdef _DEBUG void CStaffInfo::AssertValid() const { CRecordset::AssertValid(); } void CStaffInfo::Dump(CDumpContext& dc) const { CRecordset::Dump(dc); } #endif //_DEBUG ////////////////////////////////////////////////////////////////////////// IMPLEMENT_SERIAL(CStaffInfoObj, CObject, 0) CStaffInfoObj::CStaffInfoObj() { m_AutoID = 0; m_StudioID = _T(""); m_StaffSN = _T(""); m_StaffName = _T(""); m_StaffGender = FALSE; m_StaffAddress = _T(""); m_StaffOffice = _T(""); m_StaffBirthday = _T(""); m_StaffPhone = _T(""); m_StaffStatus = 0; m_StaffNote = _T(""); } CStaffInfoObj& CStaffInfoObj::operator=(const CStaffInfoObj& member) { m_AutoID = member.m_AutoID; m_StudioID = member.m_StudioID; m_StaffSN = member.m_StaffSN; m_StaffName = member.m_StaffName; m_StaffGender = member.m_StaffGender; m_StaffAddress = member.m_StaffAddress; m_StaffOffice = member.m_StaffOffice; m_StaffBirthday = member.m_StaffBirthday; m_StaffPhone = member.m_StaffPhone; m_StaffStatus = member.m_StaffStatus; m_StaffNote = member.m_StaffNote; return *this; } void CStaffInfoObj::Serialize(CArchive& ar) { try { CObject::Serialize(ar); if ( ar.IsStoring() ) { ar << m_AutoID; ar << m_StudioID; ar << m_StaffSN; ar << m_StaffName; ar << m_StaffGender; ar << m_StaffAddress; ar << m_StaffOffice; ar << m_StaffBirthday; ar << m_StaffPhone; ar << m_StaffStatus; ar << m_StaffNote; } else { ar >> m_AutoID; ar >> m_StudioID; ar >> m_StaffSN; ar >> m_StaffName; ar >> m_StaffGender; ar >> m_StaffAddress; ar >> m_StaffOffice; ar >> m_StaffBirthday; ar >> m_StaffPhone; ar >> m_StaffStatus; ar >> m_StaffNote; } } catch (CMemoryException* e) { #if _DEBUG e->ReportError(); #endif } }