oilbox.cpp

变压器监控程序

// OilBox.cpp: implementation of the COilBox class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

COilBox::COilBox()
{
    CString OilBoxId;
	CString PatrolTime;
	CString LeakOr;
	CString MaxV;
	CString AverageTrem;
	CString Water;
	CString Ph;
}

COilBox::~COilBox()
{

}
void COilBox::sql_insert()
{
	//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO oil_box (油箱编号,油箱是否漏油,最大流油速度,油的平均温度,含水量,酸度) VALUES('"
		+ OilBoxId + "','" + LeakOr + "','" + MaxV + "','" + AverageTrem + "','" + Water + "','" + Ph + "')";
	
	//执行INSERT语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}

void COilBox::sql_delete(CString cOilBoxId)
{
		//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM oil_box WHERE 油箱编号='" + cOilBoxId+"'";
	//执行DELETE语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();

}