teacherbase.cpp

陕西理工学院计算机系教师信息管理系统的设计与实现

// TeacherBase.cpp: implementation of the CTeacherBase class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "TeacherMIS.h"
#include "TeacherBase.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CTeacherBase::CTeacherBase()
{
	m_TchID="";
    m_Name="";
	m_Sex="";
	m_Birth="";
	m_Folk="";
	m_Political="";
	m_Native="";
	m_Specialty="";
	m_Degree="";
	m_School="";
	m_Officephone="";
	m_Mobilephone="";
	m_Address="";
	m_Mail="";
	m_Email="";
	m_Profession="";
	m_Marriage="";
	m_TchType="";
}

CTeacherBase::~CTeacherBase()
{

}
//添加课程
/*laoxianggaide
void CTeacherBase::AddRecord()
{
//	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
//	strSQL.Format("select * from tbTeacherBase");
	strSQL.Format("insert into tbTeacherBase(TchID,Birth) values(%s,2007)",m_TchID);
	AfxMessageBox(strSQL);
	try
	{
		((CTeacherMISApp*)AfxGetApp())->pDB->BeginTransaction();
		((CTeacherMISApp*)AfxGetApp())->pDB->Execute(strSQL);
		((CTeacherMISApp*)AfxGetApp())->pDB->CommitTransaction();
// 		pRs->Open(strSQL,CADORecordset::openQuery);
// 		pRs->AddNew();
// 		pRs->SetFieldValue("TchID",atoi(m_TchID));
// 		pRs->SetFieldValue("Name",m_Name);
// 		pRs->SetFieldValue("Birth",m_Birth);
// 		pRs->SetFieldValue("Address",m_Address);
// 		pRs->SetFieldValue("Degree",m_Degree);
// 		pRs->SetFieldValue("Email",m_Email);
// 		pRs->SetFieldValue("Folk",m_Folk);	
// 		pRs->SetFieldValue("Mail",m_Mail);
// 		pRs->SetFieldValue("Marriage",m_Marriage);
// 		pRs->SetFieldValue("Mobilephone",m_Mobilephone);
// 		pRs->SetFieldValue("Native",m_Native);
// 		pRs->SetFieldValue("Officephone",m_Officephone);
// 		pRs->SetFieldValue("Political",m_Political);
// 		pRs->SetFieldValue("Profession",m_Profession);
// 		pRs->SetFieldValue("School",m_School);
// 		pRs->SetFieldValue("Sex",m_Sex);
// 		pRs->SetFieldValue("Specialty",m_Specialty);
// 		pRs->SetFieldValue("TchType",m_TchType);
// 		pRs->Update();
	}
	catch(_com_error &e)
	{
		((CTeacherMISApp*)AfxGetApp())->pDB->RollbackTransaction();
		AfxMessageBox(e.Description());
	}
	
}*/
//添加课程
void CTeacherBase::AddRecord()
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	strSQL.Format("select * from tbTeacherBase");
	pRs->Open(strSQL,CADORecordset::openQuery);
	pRs->AddNew();
	pRs->SetFieldValue("TchID",atoi(m_TchID));
	pRs->SetFieldValue("Name",m_Name);
	pRs->SetFieldValue("Birth",m_Birth);
	pRs->SetFieldValue("Address",m_Address);
	pRs->SetFieldValue("Degree",m_Degree);
	pRs->SetFieldValue("Email",m_Email);
	pRs->SetFieldValue("Folk",m_Folk);	
	pRs->SetFieldValue("Mail",m_Mail);
	pRs->SetFieldValue("Marriage",m_Marriage);
	pRs->SetFieldValue("Mobilephone",m_Mobilephone);
	pRs->SetFieldValue("Native",m_Native);
	pRs->SetFieldValue("Officephone",m_Officephone);
	pRs->SetFieldValue("Political",m_Political);
	pRs->SetFieldValue("Profession",m_Profession);
	pRs->SetFieldValue("School",m_School);
	pRs->SetFieldValue("Sex",m_Sex);
	pRs->SetFieldValue("Specialty",m_Specialty);
	pRs->SetFieldValue("TchType",m_TchType);
	pRs->Update();
	
}


int CTeacherBase::HaveName(CString cTchName)
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	int m;
	strSQL.Format("select * from tbTeacherBase where Name='%s'",cTchName);
	pRs->Open(strSQL,CADORecordset::openQuery);
	if(pRs->GetRecordCount()>=1)
		m=1;
	else m=-1;

	pRs->Close();
	delete pRs;
	return m;
}

int CTeacherBase::HaveID(CString cTchID)
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	int m;
	strSQL.Format("select * from tbTeacherBase where TchID='%s'",cTchID);
	pRs->Open(strSQL,CADORecordset::openQuery);
	if(pRs->GetRecordCount()>=1)
		m=1;
	else m=-1;

	pRs->Close();
	delete pRs;
	return m;
}