xiangmukf.cpp

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

// XiangMuKF.cpp: implementation of the CXiangMuKF class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "TeacherMIS.h"
#include "XiangMuKF.h"

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

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

CXiangMuKF::CXiangMuKF()
{
	m_ID="";
	m_ItemID="";
	m_TchID="";
	m_NowPlan="";
	m_Term="";
}

CXiangMuKF::~CXiangMuKF()
{

}
//添加项目
void CXiangMuKF::AddRecord()
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	strSQL.Format("select * from tbXiangMuKF");
	pRs->Open(strSQL,CADORecordset::openQuery);
	pRs->AddNew();
	pRs->SetFieldValue("ID",m_ID);
	pRs->SetFieldValue("ItemID",m_ItemID);
	pRs->SetFieldValue("TchID",m_TchID);
	pRs->SetFieldValue("NowPlan",m_NowPlan);
	pRs->SetFieldValue("Term",m_Term);

	pRs->Update();
	pRs->Close();
	delete pRs;
}


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

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