zhijia.cpp

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

// Zhijia.cpp: implementation of the CZhijia class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CZhijia::~CZhijia()
{

}

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

		_bstr_t vSQL;
	vSQL = "INSERT INTO 水箱支架(型号,厚度,产地,单价,成本) VALUES('" + strxinghao + "','" + strhoudu + "','" + strchandi + "','" + strdanjia + "','" + strchengben + "')";
//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

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

void CZhijia::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 CZhijia::sql_update(CString cId)
{
//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
CString strxinghao;
	strxinghao.Format("%s",xinghao);
CString strhoudu;
	strhoudu.Format("%s",houdu);
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+"',厚度='"+strhoudu+"'WHERE 型号='"+cId+"'";
//执行INSERT语句
m_AdoConn.ExecuteSQL(vSQL);	
m_AdoConn.ExitConnect();
}