jizudlg.cpp

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

// JizuDlg.cpp : implementation file
//

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

/////////////////////////////////////////////////////////////////////////////
// CJizuDlg dialog


CJizuDlg::CJizuDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CJizuDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CJizuDlg)
	m_chandi = _T("");
	m_chengben = 0.0f;
	m_danjia = 0.0f;
	m_gonglv = 0.0f;
	m_xinghao = _T("");
	m_zhireliang = 0.0f;
	m_xinghao1 = _T("");
	m_chanshuiliang = 0;
	m_chicun = 0;
	m_zhijing = 0;
	m_dianregonglv = 0.0f;
	//}}AFX_DATA_INIT
}


void CJizuDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJizuDlg)
	DDX_Text(pDX, IDC_CHANDI, m_chandi);
	DDX_Text(pDX, IDC_CHENBEN, m_chengben);
	DDX_Text(pDX, IDC_DANJIA, m_danjia);
	DDX_Text(pDX, IDC_GONGLV, m_gonglv);
	DDX_Text(pDX, IDC_XINGHAO, m_xinghao);
	DDX_Text(pDX, IDC_ZHIRELIANG, m_zhireliang);
	DDX_Text(pDX, IDC_XINGHAO1, m_xinghao1);
	DDX_Text(pDX, IDC_CHANSHUILV, m_chanshuiliang);
	DDX_Text(pDX, IDC_CHICUN, m_chicun);
	DDX_Text(pDX, IDC_ZHIJING, m_zhijing);
	DDX_Text(pDX, IDC_ZHIRELIANG2, m_dianregonglv);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CJizuDlg, CDialog)
	//{{AFX_MSG_MAP(CJizuDlg)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CJizuDlg message handlers

void CJizuDlg::OnOK() 
{
bool flag=false;
UpdateData(TRUE);
ADOConn m_conn;
_bstr_t vSQL1;
_RecordsetPtr m_pRecordset;
m_conn.OnInitADOConn();
vSQL1="SELECT * FROM 空气源热水约能主机";
m_pRecordset=m_conn.GetRecordSet(vSQL1);
CJizu jizu;
jizu.xinghao=m_xinghao;
jizu.chandi=m_chandi;
jizu.chanshulv.Format("%ld",m_chanshuiliang);
jizu.chengben.Format("%f",m_chengben);
jizu.chicun.Format("%d",m_chicun);
jizu.danjia.Format("%f",m_danjia);
jizu.gonglv.Format("%f",m_gonglv);
jizu.zhijing.Format("%d",m_zhijing);
jizu.zhireliang.Format("%f",m_zhireliang);
jizu.dianre.Format("%f",m_dianregonglv);
if(m_xinghao=="")
MessageBox("请输入型号");
else
{
while(!m_pRecordset->adoEOF)
{if(m_xinghao==(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("型号"))
{jizu.sql_update(jizu.xinghao);
flag=true;
flag1=1;
}
m_pRecordset->MoveNext();}
if(flag==false)
jizu.sql_insert();	
flag1=1;	

	CDialog::OnOK();
}
}

void CJizuDlg::OnDelete() 
{
UpdateData(TRUE);
bool flag=false;
CJizu jizu1;
ADOConn m_conn;
_bstr_t vSQL1;
_RecordsetPtr m_pRecordset;
m_conn.OnInitADOConn();
vSQL1="SELECT * FROM 空气源热水约能主机";
m_pRecordset=m_conn.GetRecordSet(vSQL1);
while(!m_pRecordset->adoEOF)
{if(m_xinghao1==(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("型号"))
flag=true;
m_pRecordset->MoveNext();
}
jizu1.sql_delete(m_xinghao1);
if(flag==false)
MessageBox("该型号不存在!");
//flag1=1;
if(m_xinghao1=="")
MessageBox("请输入删除的型号!");
else
{
jizu1.sql_delete(m_xinghao1);
CDialog::OnOK();
}			
}