xianxingdlg.cpp

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

range.SetItem(COleVariant((long)42),COleVariant((long)1),COleVariant("V"));
range.SetItem(COleVariant((long)42),COleVariant((long)2),COleVariant("罐容量"));
range.SetItem(COleVariant((long)42),COleVariant((long)4),COleVariant("L"));
m_str[5].Format("%f",v);
range.SetItem(COleVariant((long)42),COleVariant((long)5),COleVariant(m_str[5]));
range.SetItem(COleVariant((long)44),COleVariant((long)1),COleVariant("t低"));
range.SetItem(COleVariant((long)44),COleVariant((long)2),COleVariant("低温水"));
range.SetItem(COleVariant((long)44),COleVariant((long)4),COleVariant("c"));
range.SetItem(COleVariant((long)44),COleVariant((long)5),COleVariant(t_di));
range.SetItem(COleVariant((long)46),COleVariant((long)1),COleVariant("t高"));
range.SetItem(COleVariant((long)46),COleVariant((long)2),COleVariant("高温水"));
range.SetItem(COleVariant((long)46),COleVariant((long)4),COleVariant("c"));
range.SetItem(COleVariant((long)46),COleVariant((long)5),COleVariant(t_gao));
range.SetItem(COleVariant((long)48),COleVariant((long)1),COleVariant("P电"));
range.SetItem(COleVariant((long)48),COleVariant((long)2),COleVariant("辅助电功率"));
range.SetItem(COleVariant((long)48),COleVariant((long)4),COleVariant("kw"));
range.SetItem(COleVariant((long)48),COleVariant((long)5),COleVariant(p_dian));
range.SetItem(COleVariant((long)50),COleVariant((long)1),COleVariant("W电"));
range.SetItem(COleVariant((long)50),COleVariant((long)2),COleVariant("辅助电加热水量"));
range.SetItem(COleVariant((long)50),COleVariant((long)4),COleVariant("kg/h"));
range.SetItem(COleVariant((long)50),COleVariant((long)5),COleVariant(w_dian));
//range.SetItem(COleVariant((long)52),COleVariant((long)2),COleVariant("注：以每天用水计算"));
range.SetItem(COleVariant((long)58),COleVariant((long)1),COleVariant((CString("项目名称：")+combo[5])));


//range.SetItem(COleVariant((long)3),COleVariant((long)6),COleVariant("个"));
 //设置第一个单元格的值"HI,EXCEL!"
/* range.SetItem(COleVariant((long)1),COleVariant((long)1),COleVariant("机号")); 
 range.SetItem(COleVariant((long)1),COleVariant((long)2),COleVariant("规格型号"));
 range.SetItem(COleVariant((long)1),COleVariant((long)3),COleVariant("水位"));
 range.SetItem(COleVariant((long)1),COleVariant((long)4),COleVariant("水温"));
 range.SetItem(COleVariant((long)1),COleVariant((long)5),COleVariant("机温"));
 range.SetItem(COleVariant((long)1),COleVariant((long)6),COleVariant("压力"));
 range.SetItem(COleVariant((long)1),COleVariant((long)7),COleVariant("出水温度"));
 range.SetItem(COleVariant((long)1),COleVariant((long)8),COleVariant("翅片温度"));
 range.SetItem(COleVariant((long)1),COleVariant((long)9),COleVariant("输入"));
 range.SetItem(COleVariant((long)1),COleVariant((long)10),COleVariant("输出"));
 range.SetItem(COleVariant((long)1),COleVariant((long)11),COleVariant("星期"));
*/
 //设置第一个单元格字体颜色:红色
 Font font;
 range.AttachDispatch(sheet.GetCells());
 range.AttachDispatch((range.GetItem (COleVariant(long(1)), COleVariant(long(1)))).pdispVal);
 font.SetColor(COleVariant((long)0xF00000));  
 

 //*****
 //合并单元格的处理
 //包括判断第一个单元格是否为合并单元格，以及将第一个单元格进行合并
 /*Range unionRange;
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)1)).pdispVal );
  
 vResult=unionRange.GetMergeCells();    
 if(vResult.boolVal==-1)             //是合并的单元格    
 {
  //合并单元格的行数 
  range.AttachDispatch (unionRange.GetRows ());
  long iUnionRowNum=range.GetCount (); 
   
  //合并单元格的列数
  range.AttachDispatch (unionRange.GetColumns ());
  long iUnionColumnNum=range.GetCount ();   
  
  //合并区域的起始行，列
  long iUnionStartRow=unionRange.GetRow();       //起始行，从1开始
  long iUnionStartCol=unionRange.GetColumn();    //起始列，从1开始
  
 }
 else if(vResult.boolVal==0)   
 {//不是合并的单元格}
 
 //将第一个单元格合并成2行，3列
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)3),COleVariant((long)5)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 }
 */
 //*****
 //将文件保存为2.xls 

/* book.SaveAs(COleVariant("d:\\hjp.xls"),covOptional,covOptional, \
  covOptional,covOptional,covOptional,0,\
  covOptional,covOptional,covOptional,covOptional);  
*/
  book.Save();
 //*****
 //关闭所有的book，退出Excel 
book.Close(covOptional,COleVariant("OutFilename"),covOptional);
books.Close();      
app.Quit();
//释放对象 
range.ReleaseDispatch(); 
iCell.ReleaseDispatch();
sheet.ReleaseDispatch(); 
sheets.ReleaseDispatch(); 
book.ReleaseDispatch(); 
books.ReleaseDispatch(); 
app.ReleaseDispatch(); 
}
}

void CXianxingDlg::Queding()
{
UpdateData(true);
//CBaojiaDlg baojia1;

if((atoi(num)>0)&&(atoi(m_num)>0)&&(atof(m_feng)>0)&&(atof(t_feng)>0))
{CString str,str5;
flag1=false;
float b[10];
float c[10];
int l=0;
m_zong=atoi(num)*atoi(m_num);
a[1]=m_zong;	
m_jisuan=m_zong;
w_zong=m_jisuan*atof(m_wencha);
a[0]=w_zong;
w_ji=w_zong*1;
m_feng.Format("%1.0f",m_zong);
w_1=w_ji/860.0/atof(m_xiaolv);
a[2]=w_1;
float max=Jizu[0].chanshuilv;
for(int c2=0;c2<m_shebei.GetCount();c2++)
{if(max<Jizu[c2].chanshuilv)
max=Jizu[c2].chanshuilv;
}
if(m_jisuan<=(atof(t_ji)*max*1.2))
{float k4[20];
for(int d2=0;d2<m_shebei.GetCount();d2++)
{k4[d2]=abs(m_jisuan-Jizu[d2].chanshuilv*atof(t_ji));
/*if(Jizu[d2].chanshuilv==min4)
{m_shebei.SetCurSel(d2);
combo[0]=Jizu[d2].xinghao;
chandi[0]=Jizu[d2].chandi;
danjia[0]=Jizu[d2].danjia;
chengben[0]=Jizu[d2].chengben;
shuliang[0]=1;
tai=1;
m_e=Jizu[d2].chanshuilv;
m_shuiliang=m_e*atof(t_ji)*tai;
}*/
}

float min5=k4[0];
int find=0;
for(int d3=0;d3<m_shebei.GetCount();d3++)
{if(min5>k4[d3])
{min5=k4[d3];
find=d3;
}
}

m_shebei.SetCurSel(find);
combo[0]=Jizu[find].xinghao;
chandi[0]=Jizu[find].chandi;
danjia[0]=Jizu[find].danjia;
chengben[0]=Jizu[find].chengben;
shuliang[0]=1;
tai=1;
m_e=Jizu[find].chanshuilv;
m_shuiliang=m_e*atof(t_ji)*tai;


m_shebei1.SetCurSel(-1);
combo[4]="";
chandi[4]="";
danjia[4]=0;
chengben[4]=0;
shuliang[4]=0;
tai1=0;
p_dian=6+(tai+tai1-1)*3;

UpdateData(false);
}
else
{
for(int j=0;j<m_shebei.GetCount();j++)
{m_shebei.GetLBText(j,str);
for(int k=0;k<20;k++)
{if(Jizu[k].xinghao==str)
{b[l]=m_jisuan/(Jizu[k].chanshuilv*atof(t_ji));
c[l]=Jizu[k].danjia*((int)b[l]);
l++;
break;
}
}
}
float min;
for(int j2=0;j2<l;j2++)
{if(c[j2]>0)
{min=c[j2];
break;
}
}
if(l>1)
{
for(int m=j2;m<l-1;m++)
{if(c[m+1]<min&&c[m+1]>0)
min=c[m+1];}
}
//else min=c[0];

float a1,a2,e,f[8];
for(int m=0;m<l;m++)
{if(c[m]==min)
{tai=(int)b[m];
shuliang[0]=tai;

a1=m_jisuan/(b[m]*atof(t_ji));
e=m_jisuan-a1*atof(t_ji)*tai;
break;
}
}

if(e>0&&e>(100*atof(t_ji)))
{
for(int p=0;p<m_shebei1.GetCount();p++)
{f[p]=abs(e-Jizu[p].chanshuilv*atof(t_ji));
}
float min1=f[0];
a2=Jizu[0].chanshuilv;
if(m_shebei1.GetCount()>1)
{
for(int o=0;o<m_shebei1.GetCount();o++)
{if(f[o]<min1)
{min1=f[o];
a2=Jizu[o].chanshuilv;
}
}
}
else
a2=Jizu[0].chanshuilv;
}
else
{a2=0;
}
if(a2==0)
{
m_shebei1.SetCurSel(-1);
tai1=0;
m_e1=0;
combo[4]="";
danjia[4]=0;
chengben[4]=0;
chandi[4]="";
shuliang[4]=tai1;
}
else 
{
for(int s=0;s<m_shebei1.GetCount();s++)
{
if(Jizu[s].chanshuilv==a2)
{for(int g=0;g<m_shebei.GetCount();g++)
{m_shebei1.GetLBText(g,str5);
if(strcmp(Jizu[s].xinghao,str5)==0)
{m_shebei1.SetCurSel(g);
tai1=1;
m_e1=Jizu[s].chanshuilv;
combo[4]=Jizu[s].xinghao;
danjia[4]=Jizu[s].danjia;
chengben[4]=Jizu[s].chengben;
chandi[4]=Jizu[s].chandi;
shuliang[4]=tai1;
break;
}
}
}
}
}
for(int k=0;k<20;k++)
{if(Jizu[k].chanshuilv==a1)
{for(m=0;m<m_shebei.GetCount();m++)
{m_shebei.GetLBText(m,str);
if(strcmp(Jizu[k].xinghao,str)==0)
{m_shebei.SetCurSel(m);
m_e=Jizu[k].chanshuilv+m_e1;
combo[0]=Jizu[k].xinghao;
danjia[0]=Jizu[k].danjia;
chengben[0]=Jizu[k].chengben;
chandi[0]=Jizu[k].chandi;
break;}
}
}
}

//m_shuiliang=m_e*atof(t_ji)*tai;
m_shuiliang=m_e1*atof(t_ji)*tai1+(m_e-m_e1)*atof(t_ji)*tai;
}
s_feng=atof(m_feng)/atof(t_feng);
a[6]=atof(m_feng);
float a=0;
a=55*m_a1-47.5+7.5*m_a4;
v=atof(m_feng)/(a/24.5+1-m_a4);
m_bu=(55*m_a1-47.5+7.5+m_a4)*v/24.5;
s_bu=m_bu/atof(t_feng);
p_dian=6+3*(tai+tai1-1);
w_dian=p_dian*860/40;
gonglv1=p_dian;
nengxiaobi=m_xiaolv;
}
CString str100,str101;
int a111,a112;
a111=m_shebei.GetCurSel();
a112=m_shebei1.GetCurSel();
m_shebei.GetLBText(a111,str100);
m_shebei1.GetLBText(a112,str101);
if(strcmp(str100,str101)==0)
{tai=tai+tai1;
tai1=0;
m_shebei1.SetCurSel(-1);
combo[4]="";
danjia[4]=0;
chengben[4]=0;
chandi[4]="";
shuliang[4]=tai1;
shuliang[0]=tai;
m_e=m_e/2;
m_shuiliang=m_e*tai*atof(t_ji);

}
UpdateData(false);	
}

void CXianxingDlg::queding1()
{
UpdateData(true);
//CBaojiaDlg baojia1;

if((atoi(num)>0)&&(atoi(m_num)>0)&&(atof(m_feng)>0)&&(atof(t_feng)>0))
{CString str,str5;
flag1=false;
float b[10];
float c[10];
int l=0;
m_zong=atoi(num)*atoi(m_num);
a[1]=m_zong;	
m_jisuan=m_zong;
w_zong=m_jisuan*atof(m_wencha);
a[0]=w_zong;
w_ji=w_zong*1;
w_1=w_ji/860.0/atof(m_xiaolv);
a[2]=w_1;
float max=Jizu[0].chanshuilv;
for(int c2=0;c2<m_shebei.GetCount();c2++)
{if(max<Jizu[c2].chanshu