// Kongzhi.cpp: implementation of the CKongzhi class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Yornik1.h"
#include "Kongzhi.h"
#include "ADOConn.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

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

CKongzhi::CKongzhi()
{
 xinghao="";
 chandi="";
 danjia="";
 chengben="";
}

CKongzhi::~CKongzhi()
{

}

void CKongzhi::sql_update(CString cId)
{
//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
CString strxinghao;
	strxinghao.Format("%s",xinghao);
CString strchandi;
	strchandi.Format("%s",chandi);
CString strchengben;
	strchengben.Format("%s",chengben);
CString strdanjia;
	strdanjia.Format("%s",danjia);

_bstr_t vSQL;
	vSQL = "UPDATE 自動控制器 SET [單價（萬元）]='"+strdanjia+"',[成本價（萬元）]='"+strchengben+"',產地='"+strchandi+"'WHERE 型號='"+cId+"'";
//執行INSERT語句
m_AdoConn.ExecuteSQL(vSQL);	
m_AdoConn.ExitConnect();
}

void CKongzhi::sql_insert()
{
//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strxinghao;
	strxinghao=xinghao;
	CString strchandi;
	strchandi=chandi;
	CString strdanjia;
	strdanjia=danjia;
	CString strchengben;
	strchengben=chengben;

		_bstr_t vSQL;
	vSQL = "INSERT INTO 自動控制器(型號,產地,[單價（萬元）],[成本價（萬元）]) VALUES('" + strxinghao + "','" + strchandi + "','" + strdanjia + "','" + strchengben + "')";
//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	

	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CKongzhi::sql_delete(CString cId)
{
//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置DELETE語句
	_bstr_t vSQL;
	vSQL = "DELETE FROM 自動控制器 WHERE 型號='"+cId+"'";
	//執行DELETE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}