patroltask1.cpp

变压器监控程序

// PatrolTask1.cpp: implementation of the CPatrolTask1 class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CPatrolTask1::CPatrolTask1()
{

}
void CPatrolTask1::sql_insert()
{
		//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置INSERT语句
	_bstr_t vSQL;
	vSQL = "INSERT INTO patrol (巡检人编号,巡检任务编号,信息钮编号,巡检棒编号,巡检时间,是否到位) VALUES('"
		+ PatrolManId + "','" + PatrolTaskId + "','" + ButtonId + "','" + BarId + "','" + PatrolTime + "','" + ComeOrNot + "')";	
	//执行INSERT语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
	
}

void CPatrolTask1::sql_delete(CString cButtonId)
{
	//连接数据库
	CTransConn m_TransConn;
	m_TransConn.OnInitTransConn();
	// 设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM patrol WHERE 信息钮编号='" + cButtonId+"'";
	//执行DELETE语句
	m_TransConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_TransConn.ExitConnect();
}

CPatrolTask1::~CPatrolTask1()
{

}