filter1.cpp

变压器监控程序

// Filter1.cpp: implementation of the CFilter1 class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CFilter1::CFilter1()
{

}

CFilter1::~CFilter1()
{

}
void CFilter1::sql_delete(CString cFilterId)
{
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM filter WHERE 故障滤波器编号='" + cFilterId+"'";
	//执行DELETE语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();

}

void CFilter1::sql_insert()
{
		//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO filter (故障滤波器编号,故障相,故障电流幅值,故障电压幅值,故障开始时间,故障结束时间) VALUES('"
		+ FilterId + "','" + ErrorPhase + "','" + ErrorI + "','" + ErrorV + "','" + ErrorStart + "','" + ErrorEnd + "')";
	
	//执行INSERT语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}