chroma.cpp

变压器监控程序

// Chroma.cpp: implementation of the CChroma class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CChroma::CChroma()
{

}

CChroma::~CChroma()
{

}
void CChroma::sql_insert()
{
	//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO chromatogram (油色谱编号,H2,CH4,C2H6,C2H4,C2H2,C1C2,CO,CO2) VALUES('"
		+ Chromatogram + "','" + H2 + "','" + CH4 + "','" + C2H6 + "','" + C2H4 + "','" + C2H2 + "','" + C1C2+ "','" + CO + "','" + CO2 + "')";
	
	//执行INSERT语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}
void CChroma::sql_delete(CString cChromatogram)
{
		//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM chromatogram WHERE 油色谱编号='" + cChromatogram+"'";
	//执行DELETE语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();

}