baojiadlg.cpp

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

while(!m_nRecordset->adoEOF)
{
m_combo3.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
Shuixiang[i].xinghao=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号");
Shuixiang[i].chandi=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("产地");
Shuixiang[i].danjia=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("单价(万元)"));
Shuixiang[i].chengben=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("成本价(万元)"));
Shuixiang[i].rongliang=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("容量(L)"));
m_nRecordset->MoveNext();
i++;}
	vSQL="SELECT * FROM 水箱支架";
m_nRecordset=m_com.GetRecordSet(vSQL);
i=0;

while(!m_nRecordset->adoEOF)
{
m_combo4.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
Zhijia[i].xinghao=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号");
Zhijia[i].chandi=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("产地");
Zhijia[i].danjia=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("单价"));
Zhijia[i].chengben=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("成本"));
Zhijia[i].houdu=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("厚度"));
m_nRecordset->MoveNext();
i++;}
	vSQL="SELECT * FROM 管道及保温材料";
m_nRecordset=m_com.GetRecordSet(vSQL);
i=0;

while(!m_nRecordset->adoEOF)
{
m_combo5.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
m_combo11.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
Guandao[i].xinghao=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号");
Guandao[i].chandi=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("产地");
Guandao[i].danjia=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("单价(万元)"));
Guandao[i].chengben=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("成本价(万元)"));
Guandao[i].waijing=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("外径(mm)"));
m_nRecordset->MoveNext();
i++;}
	vSQL="SELECT * FROM 自动控制器";
m_nRecordset=m_com.GetRecordSet(vSQL);
i=0;

while(!m_nRecordset->adoEOF)
{
m_combo6.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
Kongzhi[i].xinghao=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号");
Kongzhi[i].chandi=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("产地");
Kongzhi[i].danjia=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("单价(万元)"));
Kongzhi[i].chengben=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("成本价(万元)"));

m_nRecordset->MoveNext();
i++;}
	vSQL="SELECT * FROM 自动增压水泵";
m_nRecordset=m_com.GetRecordSet(vSQL);
i=0;

while(!m_nRecordset->adoEOF)
{
m_combo7.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
Shuibeng[i].xinghao=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号");
Shuibeng[i].chandi=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("产地");
Shuibeng[i].danjia=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("单价(万元)"));
Shuibeng[i].chengben=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("成本价(万元)"));

m_nRecordset->MoveNext();
i++;}
	vSQL="SELECT * FROM 电源电缆";
m_nRecordset=m_com.GetRecordSet(vSQL);
i=0;

while(!m_nRecordset->adoEOF)
{
m_combo8.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
m_combo10.AddString((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号"));
Dianlan[i].xinghao=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("型号");
Dianlan[i].chandi=(LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("产地");
Dianlan[i].danjia=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("单价(万元)"));
Dianlan[i].chengben=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("成本价(万元)"));
Dianlan[i].zhijing=atof((LPCTSTR)(_bstr_t)m_nRecordset->GetCollect("直径(mm)"));
m_nRecordset->MoveNext();
i++;}
m_xishu="1";
m_xishu1="1";
m_xishu2="1";
m_xishu3="1";
m_xishu4="1";
m_xishu5="1";
m_xishu6="1";
m_xishu7="1";
m_xishu8="1";
m_xishu9="1";
m_xishu10="1";
m_num5=1;
m_num6=1;
m_num7=1;
m_num10=0;
SetTimer(1,100,NULL);
UpdateData(false);
m_tooltip3.Create(this);
m_tooltip3.AddTool(GetDlgItem(IDC_BUTTON1), _T("<b><ct=0x0000FF><al_c>文件存放在D:\\Yornik2\\输出文件目录下</b>"));
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
//CXianxingDlg xianxing1;
CString str2,str3;
void CBaojiaDlg::OnTimer(UINT nIDEvent) 
{UpdateData(true);
if(flag1==false)
{m_num5=shuliang[0]+shuliang[4];
m_num6=shuliang[0]+shuliang[4];
if(combo[0]=="")
{m_combo1.SetCurSel(-1);
m_num=0;
m_danjia="";
m_chengben="";
m_chengbenjia=0;
m_xiaoji=0;
m_chandi="";
m_combo2.SetCurSel(-1);
m_chandi1="";
m_num1=0;
m_danjia1="";
danjia[1]=0;
m_chengben1="";
m_chengbenjia1=0;
m_xiaoji1=0;
}
else
{
for(int i=0;i<m_combo1.GetCount();i++)
{m_combo1.GetLBText(i,m_str);
if(strcmp(m_str,combo[0])==0)
{m_combo1.SetCurSel(i);
m_num=shuliang[0];
m_danjia.Format("%1.2f",danjia[0]*atof(m_xishu));
m_chengben.Format("%1.2f",chengben[0]);
m_chengbenjia=atof(m_chengben)*m_num;
m_xiaoji=atof(m_danjia)*m_num;
m_chandi=chandi[0];
m_combo2.SetCurSel(i);
m_num1=m_num;
m_chandi1=Jizu[i].chandi;
m_danjia1.Format("%1.3f",Jizu[i].danjia1*atof(m_xishu1));
danjia[1]=Jizu[i].danjia1;
m_chengben1.Format("%1.2f",Jizu[i].chengben1);
m_xiaoji1=atof(m_danjia1)*m_num1;
m_chengbenjia1=atof(m_chengben1)*m_num1;
}
}
}
if(shuliang[4]<=0)
{
	m_combo9.SetCurSel(-1);
m_num8=0;
m_danjia8="";
m_chengben8="";
m_chengbenjia8=0;
m_xiaoji8=0;
m_chandi8="";
m_combo12.SetCurSel(-1);
m_chandi11="";
m_num11=0;
m_danjia11="";
danjia[2]=0;
m_chengben11="";
m_chengbenjia11=0;
m_xiaoji11=0;
}
else
{for(int h=0;h<m_combo9.GetCount();h++)

{m_combo9.GetLBText(h,m_str);
if(strcmp(m_str,combo[4])==0)
{m_combo9.SetCurSel(h);
m_num8=shuliang[4];
m_danjia8.Format("%1.2f",danjia[4]*atof(m_xishu8));
m_chengben8.Format("%1.2f",chengben[4]);
m_chengbenjia8=atof(m_chengben8)*m_num8;
m_xiaoji8=atof(m_danjia8)*m_num8;
m_chandi8=chandi[4];
m_combo12.SetCurSel(h);
m_num11=m_num8;
m_chandi11=Jizu[h].chandi;
m_danjia11.Format("%1.3f",Jizu[h].danjia1*atof(m_xishu11));
danjia[2]=Jizu[h].danjia1;
m_chengben11.Format("%1.2f",Jizu[h].chengben1);
m_xiaoji11=atof(m_danjia11)*m_num11;
m_chengbenjia11=atof(m_chengben11)*m_num11;

}
}
}

/*
for(int k=0;k<20;k++)
{if(Dianre[k].gonglv==gonglv1)
{for(int j=0;j<m_combo2.GetCount();j++)
{m_combo2.GetLBText(j,str2);
if(strcmp(str2,Dianre[k].xinghao)==0)
{m_combo2.SetCurSel(j);
m_chandi1=Dianre[k].chandi;
m_danjia1=Dianre[k].danjia*atof(m_xishu1);
m_chengben1=Dianre[k].chengben;
m_xiaoji1=m_num*m_danjia1;
m_chengbenjia1=m_num1*m_chengben1;
}
}
}
}*/
float shui[20];
float all[20];

float min;
for(int l=0;l<m_combo3.GetCount();l++)
{shui[l]=a[6]/(Shuixiang[l].rongliang*1000);
if((float)(int)shui[l]==shui[l])
all[l]=Shuixiang[l].danjia*shui[l];
else
{all[l]=Shuixiang[l].danjia*((int)shui[l]+1);
shui[l]=(int)shui[l]+1;
}
}
//min=all[0];
int min6=0;
for(int l3=0;l3<m_combo3.GetCount();l3++)
{if(all[l3]>0)
{min=all[l3];
break;}
}
for(int j=0;j<m_combo3.GetCount();j++)
{if(all[j]<=min&&all[j]>0)
{min=all[j];
min6=(int)shui[j];
}
}
for(int n=0;n<m_combo3.GetCount();n++)
{if(all[n]<=min+0.0001)
{if((int)shui[n]<=min6&&shui[n]>0)
{min6=(int)shui[n];
m_combo3.SetCurSel(n);
m_chandi2=Shuixiang[n].chandi;
m_danjia2.Format("%1.3f",Shuixiang[n].danjia*atof(m_xishu2));
danjia[3]=Shuixiang[n].danjia;
m_chengben2.Format("%1.2f",Shuixiang[n].chengben);
m_num2=(int)((all[n]+0.0001)/Shuixiang[n].danjia);
shuliang[2]=m_num2;
m_xiaoji2=m_num2*atof(m_danjia2);
m_chengbenjia2=m_num2*atof(m_chengben2);
}
}
}
int index1=m_combo3.GetCurSel();
if(index1>=0)
{m_combo3.GetLBText(index1,str2);
for(int h=0;h<m_combo3.GetCount();h++)
{if(strcmp(Shuixiang[h].xinghao,str2)==0)
{if(Shuixiang[h].rongliang<=4)
{for(int d=0;d<m_combo4.GetCount();d++)
{if(Zhijia[d].houdu==200)
{for(int b=0;b<m_combo4.GetCount();b++)
{m_combo4.GetLBText(b,str3);
	if(strcmp(Zhijia[d].xinghao,str3)==0)
	{m_combo4.SetCurSel(d);
	m_chandi3=Zhijia[d].chandi;
	m_num3=m_num2;
	m_chengben3.Format("%1.2f",Zhijia[d].chengben);
	m_danjia3.Format("%1.3f",Zhijia[d].danjia*atof(m_xishu3));
	danjia[5]=Zhijia[d].danjia;
	m_xiaoji3=m_num3*atof(m_danjia3);
	m_chengbenjia3=m_num3*atof(m_chengben3);
	}
}
}
}
}
else if(Shuixiang[h].rongliang>=5&&Shuixiang[h].rongliang<=6)
{for(int d=0;d<m_combo4.GetCount();d++)
{if(Zhijia[d].houdu==220)
{for(int b=0;b<m_combo4.GetCount();b++)
{m_combo4.GetLBText(b,str3);
	if(strcmp(Zhijia[d].xinghao,str3)==0)
	{m_combo4.SetCurSel(d);
	m_chandi3=Zhijia[d].chandi;
	m_num3=m_num2;
	m_chengben3.Format("%1.2f",Zhijia[d].chengben);
	m_danjia3.Format("%1.3f",Zhijia[d].danjia*atof(m_xishu3));
	danjia[5]=Zhijia[d].danjia;
	m_xiaoji3=m_num3*atof(m_danjia3);
	m_chengbenjia3=m_num3*atof(m_chengben3);
	}
}
}
}
}
else if(Shuixiang[h].rongliang>=7&&Shuixiang[h].rongliang<=10)
{for(int d=0;d<m_combo4.GetCount();d++)
{if(Zhijia[d].houdu==240)
{for(int b=0;b<m_combo4.GetCount();b++)
{m_combo4.GetLBText(b,str3);
	if(strcmp(Zhijia[d].xinghao,str3)==0)
	{m_combo4.SetCurSel(d);
	m_chandi3=Zhijia[d].chandi;
	m_num3=m_num2;
	m_chengben3.Format("%1.2f",Zhijia[d].chengben);
	m_danjia3.Format("%1.3f",Zhijia[d].danjia*atof(m_xishu3));
	danjia[5]=Zhijia[d].danjia;
	m_xiaoji3=m_num3*atof(m_danjia3);
	m_chengbenjia3=m_num3*atof(m_chengben3);
	}
}
}
}
}
}
}
}
int index5=m_combo1.GetCurSel();
CString str6;
bool hjp=false;
if(index5==-1)
{m_combo5.SetCurSel(-1);
m_chandi4="";
m_danjia4="";
m_chengben4="";
m_xiaoji4=0;
m_chengbenjia4=0;
m_num10=1;
m_num4=0;
}
else
{
m_combo1.GetLBText(index5,str6);
for(int ii=0;ii<m_combo1.GetCount();ii++)
{if(strcmp(str6,Jizu[ii].xinghao)==0)
{for(int c=0;c<m_combo5.GetCount();c++)
{if(Guandao[c].waijing==Jizu[ii].chicun)
{hjp=true;
m_combo5.SetCurSel(c);
m_chandi4=Guandao[c].chandi;
m_num4=1;
m_num10=0;
m_danjia4.Format("%1.3f",(Guandao[c].danjia+(shuliang[0]+shuliang[4]-1)*0.04)*atof(m_xishu4));
danjia[6]=Guandao[c].danjia+(shuliang[0]+shuliang[4]-1)*0.04;
m_chengben4.Format("%1.2f",Guandao[c].chengben+(shuliang[0]+shuliang[4]-1)*0.04);
m_xiaoji4=atof(m_danjia4)*m_num4;
m_chengbenjia4=atof(m_chengben4)*m_num4;
}
}
}
if(hjp==false)
{m_combo5.SetCurSel(-1);