guandao.cpp

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

// Guandao.cpp: implementation of the CGuandao class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CGuandao::~CGuandao()
{

}

void CGuandao::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();
}

void CGuandao::sql_insert()
{
//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strxinghao;
	strxinghao=xinghao;
	CString strwaijing;
	strwaijing=waijing;
	CString strchandi;
	strchandi=chandi;
	CString strdanjia;
	strdanjia=danjia;
	CString strchengben;
	strchengben=chengben;

		_bstr_t vSQL;
	vSQL = "INSERT INTO 管道及保温材料(型号,[外径（mm）],产地,[单价（万元）],[成本价（万元）]) VALUES('" + strxinghao + "','" + strwaijing + "','" + strchandi + "','" + strdanjia + "','" + strchengben + "')";
//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CGuandao::sql_update(CString cId)
{
//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
CString strxinghao;
	strxinghao.Format("%s",xinghao);
CString strwaijing;
	strwaijing.Format("%s",waijing);
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+"',[外径（mm）]='"+strwaijing+"'WHERE 型号='"+cId+"'";
//执行INSERT语句
m_AdoConn.ExecuteSQL(vSQL);	
m_AdoConn.ExitConnect();
}