patrolman.cpp

变压器监控程序

// PatrolMan.cpp: implementation of the CPatrolMan class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "trans.h"
#include "PatrolMan.h"
#include "TransConn.h"

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

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

CPatrolMan::CPatrolMan()
{

}

CPatrolMan::~CPatrolMan()
{

}
//========================================
//
CString CPatrolMan::GetPatrolManId()
{
	return PatrolManId;
}
void CPatrolMan::SetPatrolManId(CString vManId)
{
	PatrolManId=vManId;
}

//========================================
CString CPatrolMan::GetPatrolManName()
{
	return PatrolManName;
}
void CPatrolMan::SetPatrolManName(CString vPatrolManName)
{
	PatrolManName=vPatrolManName;
}
//========================================
CString CPatrolMan::GetPatrolTime()
{
	return PatrolTime;
}
void CPatrolMan::SetPatrolTime(CString vPatrolTime)
{
	PatrolTime=vPatrolTime;
}
//========================================
CString CPatrolMan::GetPatrolManSex()
{
	return PatrolManSex;
}
void CPatrolMan::SetPatrolManSex(CString vPatrolManSex)
{
	PatrolManSex=vPatrolManSex;
}


//========================================
CString CPatrolMan::GetPatrolManPhone()
{
	return PatrolManPhone;
}
void CPatrolMan::SetPatrolManPhone(CString vPatrolManPhone)
{
	PatrolManPhone=vPatrolManPhone;
}
//========================================
CString CPatrolMan::GetPatrolManAddress()
{
	return PatrolManAddress;
}
void CPatrolMan::SetPatrolManAddress(CString vPatrolManAddress)
{
	PatrolManAddress=vPatrolManAddress;
}
//=========================================

void CPatrolMan::sql_delete(CString cPatrolManId)
{
	//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM patrol_man WHERE 巡检人编号='" + cPatrolManId+"'";
	//执行DELETE语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}

void CPatrolMan::sql_insert()
{
	//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO patrol_man (巡检人编号,姓名,性别,电话,住址) VALUES('"
		+ PatrolManId + "','" + PatrolManName + "','" + PatrolManSex + "','" + PatrolManPhone + "','" + PatrolManAddress + "')";
	
	//执行INSERT语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}