xianxingdlg.cpp

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

range.SetItem(COleVariant((long)18),COleVariant((long)1),COleVariant("T机"));
range.SetItem(COleVariant((long)18),COleVariant((long)2),COleVariant("机器工作时间"));
range.SetItem(COleVariant((long)18),COleVariant((long)4),COleVariant("h"));
range.SetItem(COleVariant((long)18),COleVariant((long)5),COleVariant(t_ji));
//range.SetItem(COleVariant((long)16),COleVariant((long)9),COleVariant(m_zong));
range.SetItem(COleVariant((long)20),COleVariant((long)1),COleVariant("M额"));
range.SetItem(COleVariant((long)20),COleVariant((long)2),COleVariant("机器额定出水量"));
range.SetItem(COleVariant((long)20),COleVariant((long)4),COleVariant("L/h"));
range.SetItem(COleVariant((long)20),COleVariant((long)5),COleVariant(m_e));
//range.SetItem(COleVariant((long)18),COleVariant((long)9),COleVariant(m_zong));
//range.SetItem(COleVariant((long)20),COleVariant((long)1),COleVariant("M总"));
range.SetItem(COleVariant((long)22),COleVariant((long)2),COleVariant("日额定出水量"));
range.SetItem(COleVariant((long)22),COleVariant((long)4),COleVariant("L/天"));
range.SetItem(COleVariant((long)22),COleVariant((long)5),COleVariant("M额×T机×台数"));
range.SetItem(COleVariant((long)22),COleVariant((long)9),COleVariant(m_shuiliang));
range.SetItem(COleVariant((long)24),COleVariant((long)1),COleVariant("M峰"));
range.SetItem(COleVariant((long)24),COleVariant((long)2),COleVariant("峰值最大用水总量"));
range.SetItem(COleVariant((long)24),COleVariant((long)4),COleVariant("kg"));
range.SetItem(COleVariant((long)24),COleVariant((long)5),COleVariant(m_feng));
//range.SetItem(COleVariant((long)22),COleVariant((long)9),COleVariant(m_zong));
range.SetItem(COleVariant((long)26),COleVariant((long)1),COleVariant("T峰"));
range.SetItem(COleVariant((long)26),COleVariant((long)2),COleVariant("峰值时间"));
range.SetItem(COleVariant((long)26),COleVariant((long)4),COleVariant("min"));
range.SetItem(COleVariant((long)26),COleVariant((long)5),COleVariant(t_feng));
//range.SetItem(COleVariant((long)24),COleVariant((long)9),COleVariant(m_zong));
range.SetItem(COleVariant((long)28),COleVariant((long)1),COleVariant("S峰"));
range.SetItem(COleVariant((long)28),COleVariant((long)2),COleVariant("峰值用水速度"));
range.SetItem(COleVariant((long)28),COleVariant((long)4),COleVariant("kg/min"));
range.SetItem(COleVariant((long)28),COleVariant((long)5),COleVariant("S峰＝M峰／T峰"));
range.SetItem(COleVariant((long)28),COleVariant((long)9),COleVariant(s_feng));
range.SetItem(COleVariant((long)30),COleVariant((long)1),COleVariant("M补"));
range.SetItem(COleVariant((long)30),COleVariant((long)2),COleVariant("峰值补水量"));
range.SetItem(COleVariant((long)30),COleVariant((long)4),COleVariant("kg"));
//range.SetItem(COleVariant((long)28),COleVariant((long)5),COleVariant("M总=N(个)×P(L/人)"));
range.SetItem(COleVariant((long)30),COleVariant((long)9),COleVariant(m_bu));
range.SetItem(COleVariant((long)32),COleVariant((long)1),COleVariant("S补"));
range.SetItem(COleVariant((long)32),COleVariant((long)2),COleVariant("峰值补水速度"));
range.SetItem(COleVariant((long)32),COleVariant((long)4),COleVariant("kg/min"));
//range.SetItem(COleVariant((long)30),COleVariant((long)5),COleVariant("M总=N(个)×P(L/人)"));
range.SetItem(COleVariant((long)32),COleVariant((long)9),COleVariant(s_bu));
range.SetItem(COleVariant((long)34),COleVariant((long)1),COleVariant("L1"));
range.SetItem(COleVariant((long)34),COleVariant((long)2),COleVariant("上1水位"));
//range.SetItem(COleVariant((long)32),COleVariant((long)4),COleVariant("min"));
m_str[5].Format("%f",m_a1);
range.SetItem(COleVariant((long)34),COleVariant((long)5),COleVariant(m_str[5]));
range.SetItem(COleVariant((long)36),COleVariant((long)1),COleVariant("L2"));
range.SetItem(COleVariant((long)36),COleVariant((long)2),COleVariant("上2水位"));
//range.SetItem(COleVariant((long)34),COleVariant((long)4),COleVariant("min"));
m_str[5].Format("%f",m_a2);
range.SetItem(COleVariant((long)36),COleVariant((long)5),COleVariant(m_str[5]));
range.SetItem(COleVariant((long)38),COleVariant((long)1),COleVariant("L3"));
range.SetItem(COleVariant((long)38),COleVariant((long)2),COleVariant("上3水位"));
//range.SetItem(COleVariant((long)36),COleVariant((long)4),COleVariant("min"));
m_str[5].Format("%f",m_a3);
range.SetItem(COleVariant((long)38),COleVariant((long)5),COleVariant(m_str[5]));
range.SetItem(COleVariant((long)40),COleVariant((long)1),COleVariant("L4"));
range.SetItem(COleVariant((long)40),COleVariant((long)2),COleVariant("上4水位"));
//range.SetItem(COleVariant((long)38),COleVariant((long)4),COleVariant("min"));
m_str[5].Format("%f",m_a4);
range.SetItem(COleVariant((long)40),COleVariant((long)5),COleVariant(m_str[5]));
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(); 
}
}	

CString tring1;
void CXianxingDlg::OnSelchangeCombo4() 
{
	flag1=false;
	UpdateData(true);
	CButton *m_check=(CButton*)GetDlgItem(IDC_CHECK);
	if(m_check->GetCheck())
{//flag1=true;
//if(tai1==0)
//m_shebei1.SelCurSel(-1);
int s2=m_shebei1.GetCurSel();
m_shebei1.GetLBText(s2,tring1);
combo[4]=tring1;
danjia[4]=Jizu[s2].danjia;
chengben[4]=Jizu[s2].chengben;
shuliang[4]=tai1;
chandi[4]=Jizu[s2].chandi;	
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;
int d2=m_shebei.GetCurSel();
m_e=Jizu[s2].chanshuilv+Jizu[d2].chanshuilv;
m_shuiliang=tai1*atof(t_ji)*Jizu[s2].chanshuilv+tai*atof(t_ji)*Jizu[d2].chanshuilv;
p_dian=6+3*(tai+tai1-1);
w_dian=p_dian*860/40;
gonglv1=p_dian;
a[6]=atof(m_feng);
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::OnTimer(UINT nIDEvent) 
{
	UpdateData(true);
	CButton *m_check=(CButton*)GetDlgItem(IDC_CHECK);
	if(m_check->GetCheck())
	{if(tai1==0)
	{m_shebei1.SetCurSel(-1);
	shuliang[4]=0;
combo[4]="";
danjia[4]=0;
chengben[4]=0;
chandi[4]="";
int h3=m_shebei.GetCurSel();
m_shebei.GetLBText(h3,str);
for(int h4=0;h4<m_shebei.GetCount();h4++)
{if(strcmp(str,Jizu[h4].xinghao)==0)
{m_e=Jizu[h4].chanshuilv;
m_shuiliang=m_e*tai*atof(t_ji);
}
}

	}
	}
	UpdateData(false);
	CDialog::OnTimer(nIDEvent);
}

void CXianxingDlg::OnChangeEdit6() 
{flag1=false;
	UpdateData(TRUE);
/*int h4=m_shebei.GetCurSel();
if(h4==-1)
{m_e=0;
m_shuiliang=0;}
else
{
m_shebei.GetLBText(h4,str);
for(int h6=0;h6<m_shebei.GetCount();h6++)
{if(strcmp(str,Jizu[h6].xinghao)==0)
{m_e=Jizu[h6].chanshuilv;
m_shuiliang=tai*Jizu[h6].chanshuilv*atof(t_ji);
}
}
}

int h5=m_shebei1.GetCurSel();
if(h5!=-1)

{
m_shebei1.GetLBText(h5,str);
for(int h7=0;h7<m_shebei1.GetCount();h7++)
{if(strcmp(str,Jizu[h7].xinghao)==0)
{m_e+=Jizu[h7].chanshuilv;
m_shuiliang+=tai1*Jizu[h7].chanshuilv*atof(t_ji);
}
}
}*/
if(atof(t_ji)>0)
Queding();
UpdateData(FALSE);	
}

void CXianxingDlg::OnChangeEdit23() 
{flag1=false;
UpdateData(TRUE);
if(atoi(num)>0)	
Queding();
UpdateData(FALSE);	
	
}

void CXianxingDlg::OnChangeEdit25() 
{flag1=false;
UpdateData(TRUE);
if(atof(m_wencha)>0)	
Queding();
UpdateData(FALSE);
}

void CXianxingDlg::OnChangeEdit26() 
{flag1=false;
UpdateData(TRUE);
if(atof(m_xiaolv)>0)	
Queding();
UpdateData(FALSE);
	
}

void CXianxingDlg::OnChangeEdit27() 
{flag1=false;
UpdateData(TRUE);
if(atoi(m_num)>0)	
Queding();
UpdateData(FALSE);
	
}

void CXianxingDlg::OnChangeEdit10() 
{flag1=false;
	UpdateData(TRUE);
if(atof(t_feng)>0)
Queding();
UpdateData(FALSE);
	
}

void CXianxingDlg::OnChangeEdit9() 
{flag1=false;
	UpdateData(TRUE);
if(atof(m_feng)>0)
queding1();
UpdateData(FALSE);
	
}

void CXianxingDlg::XianxingExcel()
{
UpdateData(true);
//AfxOleInit();
 CString m_str[200];
m_str[20].Empty();

 m_str[20].Format("d:\\Yornik2\\系统图\\%d-%d.dwg",tai+tai1,shuliang[2]);
m_str[22]="d:\\Yornik2\\文件\\hjp.dwg";
if(!CopyFile(m_str[20],m_str[22],0))
MessageBox("没有此文件!");
else