protect.cpp

变压器监控程序

// Protect.cpp: implementation of the CProtect class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CProtect::CProtect()
{

}

CProtect::~CProtect()
{

}
void CProtect::sql_delete (CString cProtectId)
{
		//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM protect WHERE 变压器保护编号='" + cProtectId+"'";
	//执行DELETE语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}
void CProtect::sql_insert()
{
	
	//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO protect (变压器保护编号,差动保护,瓦斯保护,零序电流保护,零序电压保护,温度保护,过负荷保护) VALUES('"
		+ ProtectId + "','" + DiffTime + "','" + Gas + "','" + ZeroI + "','" + ZeroV + "','" + Trem + "','" + FlowLoad + "')";
	
	//执行INSERT语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}