runpara.cpp

变压器监控程序

// RunPara.cpp: implementation of the CRunPara class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CRunPara::CRunPara()
{

}

CRunPara::~CRunPara()
{

}
void CRunPara::sql_insert()
{
		//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO run_para (运行参数编号,输入功率,输入电压,输出功率,输出电压,频率) VALUES('"
		+ RunParaId + "','" + InPower + "','" + InV + "','" + OutPower + "','" + OutV + "','" + Freq + "')";
	
	//执行INSERT语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}
void CRunPara::sql_delete(CString cRunParaId)
{
		//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM run_para WHERE 运行参数编号='" + RunParaId +"'";
	//执行DELETE语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}