baojiadlg.cpp

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

// BaojiaDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Yornik1.h"
#include "BaojiaDlg.h"
#include "XianxingDlg.h"
#include "FengmianDlg.h"
#include "BijiaoDlg.h"
#include "comdef.h"
#include "Excel9.h"
#include "PrintFrame.h"
#include "PrintView.h"
#include "NumToHan.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CBaojiaDlg dialog
//#include "XianxingDlg.h"
extern CString combo[8];
extern CString chandi[8];
extern int shuliang[8];
extern float danjia[16];
extern float chengben[8];
extern float xiaoji[8];
extern float chengbenjia[8];
extern float gonglv1;
extern float a[8];
extern bool flag1;
extern jizu Jizu[20];
CBaojiaDlg::CBaojiaDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBaojiaDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBaojiaDlg)
	m_chandi = _T("");
	m_num = 0;
	m_xiaoji = 0.0f;
	m_chengbenjia = 0.0f;
	m_chandi1 = _T("");
	m_chandi2 = _T("");
	m_chandi3 = _T("");
	m_chandi4 = _T("");
	m_chandi5 = _T("");
	m_chandi6 = _T("");
	m_chandi7 = _T("");
	m_num1 = 0;
	m_num2 = 0;
	m_num3 = 0;
	m_num4 = 0;
	m_num5 = 0;
	m_num6 = 0;
	m_num7 = 0;
	m_xiaoji1 = 0.0f;
	m_xiaoji2 = 0.0f;
	m_xiaoji3 = 0.0f;
	m_xiaoji4 = 0.0f;
	m_xiaoji5 = 0.0f;
	m_xiaoji6 = 0.0f;
	m_xiaoji7 = 0.0f;
	m_chengbenjia1 = 0.0f;
	m_chengbenjia2 = 0.0f;
	m_chengbenjia3 = 0.0f;
	m_chengbenjia4 = 0.0f;
	m_chengbenjia5 = 0.0f;
	m_chengbenjia6 = 0.0f;
	m_chengbenjia7 = 0.0f;
	m_xishu = _T("");
	m_xishu1 = _T("");
	m_xishu2 = _T("");
	m_xishu3 = _T("");
	m_xishu4 = _T("");
	m_xishu5 = _T("");
	m_xishu6 = _T("");
	m_xishu7 = _T("");
	m_shuishou = 0.0f;
	m_inall = 0.0f;
	m_all1 = 0.0f;
	m_chandi8 = _T("");
	m_num8 = 0;
	m_xiaoji8 = 0.0f;
	m_chengbenjia8 = 0.0f;
	m_xishu8 = _T("");
	m_chandi9 = _T("");
	m_xiaoji9 = 0.0f;
	m_chengbenjia9 = 0.0f;
	m_xishu9 = _T("");
	m_chandi10 = _T("");
	m_num10 = 0;
	m_xiaoji10 = 0.0f;
	m_chengbenjia10 = 0.0f;
	m_xishu10 = _T("");
	m_zongjia = 0.0f;
	m_chandi11 = _T("");
	m_num11 = 0;
	m_xiaoji11 = 0.0f;
	m_chengbenjia11 = 0.0f;
	m_xishu11 = _T("");
	m_diaozhuang = _T("");
	m_tiaoshi = _T("");
	m_diaozhuang1 = _T("");
	m_danjia = _T("");
	m_danjia1 = _T("");
	m_danjia2 = _T("");
	m_danjia3 = _T("");
	m_danjia4 = _T("");
	m_danjia5 = _T("");
	m_danjia6 = _T("");
	m_danjia7 = _T("");
	m_danjia8 = _T("");
	m_danjia9 = _T("");
	m_danjia10 = _T("");
	m_danjia11 = _T("");
	m_chengben = _T("");
	m_chengben1 = _T("");
	m_chengben2 = _T("");
	m_chengben3 = _T("");
	m_chengben4 = _T("");
	m_chengben5 = _T("");
	m_chengben6 = _T("");
	m_chengben7 = _T("");
	m_chengben8 = _T("");
	m_chengben9 = _T("");
	m_chengben10 = _T("");
	m_chengben11 = _T("");
	//}}AFX_DATA_INIT
}


void CBaojiaDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBaojiaDlg)
	DDX_Control(pDX, IDC_COMBO16, m_combo12);
	DDX_Control(pDX, IDC_COMBO14, m_combo11);
	DDX_Control(pDX, IDC_COMBO12, m_combo10);
	DDX_Control(pDX, IDC_COMBO9, m_combo9);
	DDX_Control(pDX, IDC_COMBO8, m_combo8);
	DDX_Control(pDX, IDC_COMBO7, m_combo7);
	DDX_Control(pDX, IDC_COMBO6, m_combo6);
	DDX_Control(pDX, IDC_COMBO5, m_combo5);
	DDX_Control(pDX, IDC_COMBO4, m_combo4);
	DDX_Control(pDX, IDC_COMBO3, m_combo3);
	DDX_Control(pDX, IDC_COMBO2, m_combo2);
	DDX_Control(pDX, IDC_COMBO1, m_combo1);
	DDX_Text(pDX, IDC_EDIT1, m_chandi);
	DDX_Text(pDX, IDC_EDIT9, m_num);
	DDX_Text(pDX, IDC_EDIT33, m_xiaoji);
	DDX_Text(pDX, IDC_EDIT41, m_chengbenjia);
	DDX_Text(pDX, IDC_EDIT2, m_chandi1);
	DDX_Text(pDX, IDC_EDIT3, m_chandi2);
	DDX_Text(pDX, IDC_EDIT4, m_chandi3);
	DDX_Text(pDX, IDC_EDIT5, m_chandi4);
	DDX_Text(pDX, IDC_EDIT6, m_chandi5);
	DDX_Text(pDX, IDC_EDIT7, m_chandi6);
	DDX_Text(pDX, IDC_EDIT8, m_chandi7);
	DDX_Text(pDX, IDC_EDIT10, m_num1);
	DDX_Text(pDX, IDC_EDIT11, m_num2);
	DDX_Text(pDX, IDC_EDIT12, m_num3);
	DDX_Text(pDX, IDC_EDIT13, m_num4);
	DDX_Text(pDX, IDC_EDIT14, m_num5);
	DDX_Text(pDX, IDC_EDIT15, m_num6);
	DDX_Text(pDX, IDC_EDIT16, m_num7);
	DDX_Text(pDX, IDC_EDIT34, m_xiaoji1);
	DDX_Text(pDX, IDC_EDIT35, m_xiaoji2);
	DDX_Text(pDX, IDC_EDIT36, m_xiaoji3);
	DDX_Text(pDX, IDC_EDIT37, m_xiaoji4);
	DDX_Text(pDX, IDC_EDIT38, m_xiaoji5);
	DDX_Text(pDX, IDC_EDIT39, m_xiaoji6);
	DDX_Text(pDX, IDC_EDIT40, m_xiaoji7);
	DDX_Text(pDX, IDC_EDIT42, m_chengbenjia1);
	DDX_Text(pDX, IDC_EDIT43, m_chengbenjia2);
	DDX_Text(pDX, IDC_EDIT44, m_chengbenjia3);
	DDX_Text(pDX, IDC_EDIT45, m_chengbenjia4);
	DDX_Text(pDX, IDC_EDIT46, m_chengbenjia5);
	DDX_Text(pDX, IDC_EDIT47, m_chengbenjia6);
	DDX_Text(pDX, IDC_EDIT48, m_chengbenjia7);
	DDX_Text(pDX, IDC_EDIT49, m_xishu);
	DDX_Text(pDX, IDC_EDIT50, m_xishu1);
	DDX_Text(pDX, IDC_EDIT51, m_xishu2);
	DDX_Text(pDX, IDC_EDIT52, m_xishu3);
	DDX_Text(pDX, IDC_EDIT53, m_xishu4);
	DDX_Text(pDX, IDC_EDIT54, m_xishu5);
	DDX_Text(pDX, IDC_EDIT55, m_xishu6);
	DDX_Text(pDX, IDC_EDIT56, m_xishu7);
	DDX_Text(pDX, IDC_EDIT60, m_shuishou);
	DDX_Text(pDX, IDC_EDIT61, m_inall);
	DDX_Text(pDX, IDC_EDIT62, m_all1);
	DDX_Text(pDX, IDC_EDIT63, m_chandi8);
	DDX_Text(pDX, IDC_EDIT64, m_num8);
	DDX_Text(pDX, IDC_EDIT67, m_xiaoji8);
	DDX_Text(pDX, IDC_EDIT68, m_chengbenjia8);
	DDX_Text(pDX, IDC_EDIT69, m_xishu8);
	DDX_Text(pDX, IDC_EDIT70, m_chandi9);
	DDX_Text(pDX, IDC_EDIT74, m_xiaoji9);
	DDX_Text(pDX, IDC_EDIT75, m_chengbenjia9);
	DDX_Text(pDX, IDC_EDIT76, m_xishu9);
	DDX_Text(pDX, IDC_EDIT77, m_chandi10);
	DDX_Text(pDX, IDC_EDIT78, m_num10);
	DDX_Text(pDX, IDC_EDIT81, m_xiaoji10);
	DDX_Text(pDX, IDC_EDIT82, m_chengbenjia10);
	DDX_Text(pDX, IDC_EDIT83, m_xishu10);
	DDX_Text(pDX, IDC_EDIT71, m_zongjia);
	DDX_Text(pDX, IDC_EDIT84, m_chandi11);
	DDX_Text(pDX, IDC_EDIT85, m_num11);
	DDX_Text(pDX, IDC_EDIT88, m_xiaoji11);
	DDX_Text(pDX, IDC_EDIT89, m_chengbenjia11);
	DDX_Text(pDX, IDC_EDIT90, m_xishu11);
	DDX_Text(pDX, IDC_EDIT57, m_diaozhuang);
	DDX_Text(pDX, IDC_EDIT58, m_tiaoshi);
	DDX_Text(pDX, IDC_EDIT91, m_diaozhuang1);
	DDX_Text(pDX, IDC_EDIT17, m_danjia);
	DDX_Text(pDX, IDC_EDIT18, m_danjia1);
	DDX_Text(pDX, IDC_EDIT19, m_danjia2);
	DDX_Text(pDX, IDC_EDIT20, m_danjia3);
	DDX_Text(pDX, IDC_EDIT21, m_danjia4);
	DDX_Text(pDX, IDC_EDIT22, m_danjia5);
	DDX_Text(pDX, IDC_EDIT23, m_danjia6);
	DDX_Text(pDX, IDC_EDIT24, m_danjia7);
	DDX_Text(pDX, IDC_EDIT65, m_danjia8);
	DDX_Text(pDX, IDC_EDIT72, m_danjia9);
	DDX_Text(pDX, IDC_EDIT79, m_danjia10);
	DDX_Text(pDX, IDC_EDIT86, m_danjia11);
	DDX_Text(pDX, IDC_EDIT25, m_chengben);
	DDX_Text(pDX, IDC_EDIT26, m_chengben1);
	DDX_Text(pDX, IDC_EDIT27, m_chengben2);
	DDX_Text(pDX, IDC_EDIT28, m_chengben3);
	DDX_Text(pDX, IDC_EDIT29, m_chengben4);
	DDX_Text(pDX, IDC_EDIT30, m_chengben5);
	DDX_Text(pDX, IDC_EDIT31, m_chengben6);
	DDX_Text(pDX, IDC_EDIT32, m_chengben7);
	DDX_Text(pDX, IDC_EDIT66, m_chengben8);
	DDX_Text(pDX, IDC_EDIT73, m_chengben9);
	DDX_Text(pDX, IDC_EDIT80, m_chengben10);
	DDX_Text(pDX, IDC_EDIT87, m_chengben11);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBaojiaDlg, CDialog)
	//{{AFX_MSG_MAP(CBaojiaDlg)
	ON_WM_TIMER()
	ON_CBN_SELCHANGE(IDC_COMBO2, OnSelchangeCombo2)
	ON_CBN_SELCHANGE(IDC_COMBO3, OnSelchangeCombo3)
	ON_CBN_SELCHANGE(IDC_COMBO4, OnSelchangeCombo4)
	ON_CBN_SELCHANGE(IDC_COMBO5, OnSelchangeCombo5)
	ON_CBN_SELCHANGE(IDC_COMBO6, OnSelchangeCombo6)
	ON_CBN_SELCHANGE(IDC_COMBO7, OnSelchangeCombo7)
	ON_CBN_SELCHANGE(IDC_COMBO8, OnSelchangeCombo8)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_CBN_SELCHANGE(IDC_COMBO16, OnSelchangeCombo16)
	ON_EN_CHANGE(IDC_EDIT49, OnChangeEdit49)
	ON_EN_CHANGE(IDC_EDIT69, OnChangeEdit69)
	ON_EN_CHANGE(IDC_EDIT90, OnChangeEdit90)
	ON_EN_CHANGE(IDC_EDIT50, OnChangeEdit50)
	ON_EN_CHANGE(IDC_EDIT51, OnChangeEdit51)
	ON_EN_CHANGE(IDC_EDIT52, OnChangeEdit52)
	ON_EN_CHANGE(IDC_EDIT53, OnChangeEdit53)
	ON_EN_CHANGE(IDC_EDIT54, OnChangeEdit54)
	ON_EN_CHANGE(IDC_EDIT55, OnChangeEdit55)
	ON_EN_CHANGE(IDC_EDIT56, OnChangeEdit56)
	ON_EN_CHANGE(IDC_EDIT76, OnChangeEdit76)
	ON_EN_CHANGE(IDC_EDIT83, OnChangeEdit83)
	ON_EN_CHANGE(IDC_EDIT10, OnChangeEdit10)
	ON_EN_CHANGE(IDC_EDIT11, OnChangeEdit11)
	ON_EN_CHANGE(IDC_EDIT12, OnChangeEdit12)
	ON_EN_CHANGE(IDC_EDIT13, OnChangeEdit13)
	ON_EN_CHANGE(IDC_EDIT14, OnChangeEdit14)
	ON_EN_CHANGE(IDC_EDIT15, OnChangeEdit15)
	ON_EN_CHANGE(IDC_EDIT78, OnChangeEdit78)
	ON_EN_CHANGE(IDC_EDIT85, OnChangeEdit85)
	ON_EN_CHANGE(IDC_EDIT57, OnChangeEdit57)
	ON_EN_CHANGE(IDC_EDIT58, OnChangeEdit58)
	ON_EN_CHANGE(IDC_EDIT91, OnChangeEdit91)
	ON_EN_CHANGE(IDC_EDIT17, OnChangeEdit17)
	ON_EN_CHANGE(IDC_EDIT18, OnChangeEdit18)
	ON_EN_CHANGE(IDC_EDIT19, OnChangeEdit19)
	ON_EN_CHANGE(IDC_EDIT20, OnChangeEdit20)
	ON_EN_CHANGE(IDC_EDIT21, OnChangeEdit21)
	ON_EN_CHANGE(IDC_EDIT22, OnChangeEdit22)
	ON_EN_CHANGE(IDC_EDIT23, OnChangeEdit23)
	ON_EN_CHANGE(IDC_EDIT24, OnChangeEdit24)
	ON_EN_CHANGE(IDC_EDIT65, OnChangeEdit65)
	ON_EN_CHANGE(IDC_EDIT72, OnChangeEdit72)
	ON_EN_CHANGE(IDC_EDIT79, OnChangeEdit79)
	ON_EN_CHANGE(IDC_EDIT86, OnChangeEdit86)
	ON_CBN_SELCHANGE(IDC_COMBO14, OnSelchangeCombo14)
	ON_EN_CHANGE(IDC_EDIT25, OnChangeEdit25)
	ON_EN_CHANGE(IDC_EDIT26, OnChangeEdit26)
	ON_EN_CHANGE(IDC_EDIT27, OnChangeEdit27)
	ON_EN_CHANGE(IDC_EDIT28, OnChangeEdit28)
	ON_EN_CHANGE(IDC_EDIT29, OnChangeEdit29)
	ON_EN_CHANGE(IDC_EDIT30, OnChangeEdit30)
	ON_EN_CHANGE(IDC_EDIT31, OnChangeEdit31)
	ON_EN_CHANGE(IDC_EDIT32, OnChangeEdit32)
	ON_EN_CHANGE(IDC_EDIT66, OnChangeEdit66)
	ON_EN_CHANGE(IDC_EDIT73, OnChangeEdit73)
	ON_EN_CHANGE(IDC_EDIT80, OnChangeEdit80)
	ON_EN_CHANGE(IDC_EDIT87, OnChangeEdit87)
	ON_COMMAND(ID_FILE_PRINT, OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, OnFilePrintPreview)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBaojiaDlg message handlers
int i;
BOOL CBaojiaDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_num4=1;
	m_xishu11="1";
	m_diaozhuang="0.15";
	m_diaozhuang1="0.1";
	m_tiaoshi="0.18";
	vSQL="SELECT * FROM 空气源热水约能主机";
m_nRecordset=m_com.GetRecordSet(vSQL);
while(!m_nRecordset->adoEOF)
{
m_combo1.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
m_combo9.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
m_nRecordset->MoveNext();}


for(i=0;i<m_combo1.GetCount();i++)
{CString str,str1;
str.Format("功率%dKW",(int)Jizu[i].dianre);
m_combo2.AddString(str);
m_combo12.AddString(str);
}

/*	vSQL="SELECT * FROM 不锈钢电加热器";
m_nRecordset=m_com.GetRecordSet(vSQL);
i=0;
while(!m_nRecordset->adoEOF)
{
m_combo2.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
Dianre[i].xinghao=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号");
Dianre[i].chandi=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("产地");
Dianre[i].danjia=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("单价(万元)"));
Dianre[i].chengben=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("成本价(万元)"));
Dianre[i].gonglv=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("功率(KW)"));
m_nRecordset->MoveNext();
i++;}*/

	vSQL="SELECT * FROM 不锈钢保温水箱";
m_nRecordset=m_com.GetRecordSet(vSQL);
i=0;