jizu.cpp

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

// Jizu.cpp: implementation of the CJizu class.
//
//////////////////////////////////////////////////////////////////////

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

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

CJizu::CJizu()
{
 xinghao="";
 danjia="";
 chengben="";
 chandi="";
 chanshulv="";
 zhireliang="";
 gonglv="";
 chicun="";
 zhijing="";
 dianre="";
 danjia1="";
 chengben1="";
}

CJizu::~CJizu()
{

}

void CJizu::sql_insert()
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strxinghao;
	strxinghao=xinghao;
		CString strchandi;
	strchandi=chandi;
		CString strchanshulv;
	strchanshulv=chanshulv;
		CString strchengben;
	strchengben=chengben;
		CString strchicun;
	strchicun=chicun;
		CString strdanjia;
	strdanjia=danjia;
	CString strdanjia1;
	strdanjia1=danjia1;
	CString strchengben1;
	strchengben1=chengben1;
		CString strgonglv;
	strgonglv=gonglv;
		CString strzhijing;
	strzhijing=zhijing;
		CString strzhireliang;
	strzhireliang=zhireliang;
	CString strdianre;
	strdianre=dianre;

	_bstr_t vSQL;
	vSQL = "INSERT INTO 空气源热水约能主机(型号,[单价（万元）],[成本价（万元）],产地,[产水率（L/H）],[制热量（KW）],[输入功率（KW）],[接管尺寸（DN）],[电缆直径（mm）],[电加热功率(KW)],[电热单价(万元)],[电热成本(万元)]) VALUES('" + strxinghao + "','" + strdanjia + "','" + strchengben + "','" + strchandi + "','" + strchanshulv + "','" + strzhireliang + "','" + strgonglv + "','" + strchicun + "','" + strzhijing + "','" + strdianre + "','" + strdanjia1 + "','" + strchengben1 + "')";
//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	

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

void CJizu::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 CJizu::sql_update(CString cId)
{
//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
CString strxinghao;
	strxinghao.Format("%s",xinghao);
CString strchandi;
	strchandi.Format("%s",chandi);
CString strchanshulv;
	strchanshulv.Format("%s",chanshulv);
CString strchengben;
	strchengben.Format("%s",chengben);
CString strchicun;
	strchicun.Format("%s",chicun);
CString strdanjia;
	strdanjia.Format("%s",danjia);
CString strdanjia1;
	strdanjia.Format("%s",danjia1);
CString strchengben1;
	strchengben1.Format("%s",chengben1);
CString strgonglv;
	strgonglv.Format("%s",gonglv);
CString strzhijing;
	strzhijing.Format("%s",zhijing);
CString strzhireliang;
	strzhireliang.Format("%s",zhireliang);
CString strdianre;
	strdianre.Format("%s",dianre);
	_bstr_t vSQL;
	vSQL = "UPDATE 空气源热水约能主机 SET [单价（万元）]='"+strdanjia+"',[成本价（万元）]='"+strchengben+"',产地='"+strchandi+"',[产水率（L/H）]='"+strchanshulv+"',[制热量（KW）]='"+strzhireliang+"',[输入功率（KW）]='"+strgonglv+"',[接管尺寸（DN）]='"+strchicun+"',[电缆直径（mm）]='"+strzhijing+"',[电加热功率(KW)]='"+strdianre+"',[电热单价(万元)]='"+strdanjia1+"',[电热成本(万元)]='"+strchengben1+"'WHERE 型号='"+cId+"'";
//执行INSERT语句
m_AdoConn.ExecuteSQL(vSQL);	
m_AdoConn.ExitConnect();
}