keyan.cpp

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

// KeYan.cpp: implementation of the CKeYan class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "TeacherMIS.h"
#include "KeYan.h"

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

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

CKeYan::CKeYan()
{
	m_KeYanID="";
	m_TchID="";
	m_Name="";
	m_Dept="";
	m_Grade="";
	m_GainTime="";
	m_Brief="";
}

CKeYan::~CKeYan()
{

}
//添加科研信息
void CKeYan::AddRecord()
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	strSQL.Format("select * from tbKeYan");
	pRs->Open(strSQL,CADORecordset::openQuery);
	pRs->AddNew();
	pRs->SetFieldValue("KeYanID",m_KeYanID);
    pRs->SetFieldValue("TchID",m_TchID);
	pRs->SetFieldValue("Name",m_Name);
	pRs->SetFieldValue("Dept",m_Dept);
	pRs->SetFieldValue("Grade",m_Grade);
	pRs->SetFieldValue("GainTime",m_GainTime);
	pRs->SetFieldValue("Brief",m_Brief);

	pRs->Update();
	
}


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

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