xiangmu.cpp

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

// XiangMu.cpp: implementation of the CXiangMu class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "TeacherMIS.h"
#include "XiangMu.h"

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

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

CXiangMu::CXiangMu()
{
	m_ItemID="";
	m_ItemName="";
//	m_ItemMember="";
	m_ParticularPlan="";
	m_BeginTime="";
	m_EndTime="";
	m_ItemPay="";
}

CXiangMu::~CXiangMu()
{

}
//添加项目
void CXiangMu::AddRecord()
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	strSQL.Format("select * from tbXiangMu");
	pRs->Open(strSQL,CADORecordset::openQuery);
	pRs->AddNew();
	pRs->SetFieldValue("ItemID",m_ItemID);
	pRs->SetFieldValue("ItemName",m_ItemName);
//	pRs->SetFieldValue("ItemMember",m_ItemMember);
	pRs->SetFieldValue("ParticularPlan",m_ParticularPlan);
	pRs->SetFieldValue("BeginTime",m_BeginTime);
	pRs->SetFieldValue("EndTime",m_EndTime);
	pRs->SetFieldValue("ItemPay",m_ItemPay);

	pRs->Update();

}


int CXiangMu::HaveName(CString cItemName)
{
	CADORecordset* pRs=new CADORecordset(((CTeacherMISApp*)AfxGetApp())->pDB);
	CString strSQL;
	int m;
	strSQL.Format("select * from tbXiangMu where ItemName like '%s'",cItemName);
	pRs->Open(strSQL,CADORecordset::openQuery);
	if(pRs->GetRecordCount()>=1)
		m=1;
	else m=-1;
	pRs->Close();
	delete pRs;
	return m;
}

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

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