kongzhi.cpp

价格生成系统 热水器生产厂家价格管理、设备类型管理系统

// 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();
}