bijiaodlg.cpp

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

     VariantTimeToSystemTime(vResult.date, &st);
 }
 else if(vResult.vt==VT_EMPTY)   //单元格空的
 {
  str="";
 }  
 
 //*****
 //读取第一个单元格的对齐方式，数据类型:VT_I4
 //读取水平对齐方式
 for(int k1=4;k1<20;k1++)
	 for(int k2=1;k2<15;k2+=3)
	 {
 range.AttachDispatch(sheet.GetCells());
 iCell.AttachDispatch((range.GetItem (COleVariant(long(k1)), COleVariant(long(k2)))).pdispVal);
 vResult.lVal=0;
iCell.SetHorizontalAlignment(COleVariant((long)-4108));
 vResult=iCell.GetHorizontalAlignment();
 if(vResult.lVal!=0)
 {
  switch (vResult.lVal)
  {
  case 1:      //默认
   break;
  case -4108:  //居中
   break;
  case -4131 : //*左
   break;
  case -4152 : //*右
   break;
  }
  
 }
  
 //垂直对齐方式
 iCell.AttachDispatch((range.GetItem (COleVariant(long(k1)), COleVariant(long(k2)))).pdispVal);
 vResult.lVal=0;

iCell.SetVerticalAlignment(COleVariant((long)-4108));
 vResult=iCell.GetVerticalAlignment();
 if(vResult.lVal!=0)
 {
  switch (vResult.lVal)
  {
  case -4160 :  //*上
   break;
  case -4108 :  //居中
   break;
  case -4107 :  //*下
   break;
  }
 
 }
	 range.AttachDispatch(range.GetItem (COleVariant((long)k1),COleVariant((long)k2)).pdispVal );
range.Merge(COleVariant((short)1));
range.SetWrapText(COleVariant((short)1));
	 }
for(int i=1;i<=26;i++)
{range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)i),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)1),COleVariant((long)3)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)i),COleVariant((long)4)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)1),COleVariant((long)3)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)i),COleVariant((long)7)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)1),COleVariant((long)3)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
  range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)i),COleVariant((long)10)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)1),COleVariant((long)3)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格

}
range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)27),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)9)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 //设置第一个单元格的值"HI,EXCEL!"
 //range.SetItem(COleVariant((long)1),COleVariant((long)1),COleVariant("机号")); 
range.SetItem(COleVariant((long)2),COleVariant((long)4),COleVariant("热水系统比较"));
range.SetItem(COleVariant((long)3),COleVariant((long)1),COleVariant("日产水量："));
range.SetItem(COleVariant((long)3),COleVariant((long)4),COleVariant(m_richanshuiliang));
range.SetItem(COleVariant((long)3),COleVariant((long)7),COleVariant("kg"));
range.SetItem(COleVariant((long)5),COleVariant((long)7),COleVariant("约能热泵"));
range.SetItem(COleVariant((long)6),COleVariant((long)1),COleVariant("设备名称"));
index=m_combo2.GetCurSel();
m_combo2.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)6),COleVariant((long)4),COleVariant(m_str1[0]));
index=m_combo1.GetCurSel();
m_combo1.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)6),COleVariant((long)7),COleVariant(m_str1[0]));
/*range.SetItem(COleVariant((long)6),COleVariant((long)1),COleVariant("设备名称"));
index=m_combo2.GetCurSel();
m_combo2.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)6),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)6),COleVariant((long)7),COleVariant(m_str1[0]));*/
range.SetItem(COleVariant((long)7),COleVariant((long)1),COleVariant("能源种类"));
index=m_combo3.GetCurSel();
m_combo3.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)7),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)7),COleVariant((long)7),COleVariant("空气源+电"));
range.SetItem(COleVariant((long)8),COleVariant((long)1),COleVariant("占地面积"));
index=m_combo6.GetCurSel();
m_combo6.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)8),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)8),COleVariant((long)7),COleVariant("10㎡"));
range.SetItem(COleVariant((long)9),COleVariant((long)1),COleVariant("使用寿命"));
index=m_combo7.GetCurSel();
m_combo7.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)9),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)9),COleVariant((long)7),COleVariant("15年"));
range.SetItem(COleVariant((long)10),COleVariant((long)1),COleVariant("燃值"));
index=m_combo9.GetCurSel();
m_combo9.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)10),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)10),COleVariant((long)7),COleVariant("860kcal/kwh"));
range.SetItem(COleVariant((long)11),COleVariant((long)1),COleVariant("热效率"));
index=m_combo10.GetCurSel();
m_combo10.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)11),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)11),COleVariant((long)7),COleVariant("550%"));
range.SetItem(COleVariant((long)12),COleVariant((long)1),COleVariant("能源单价"));

range.SetItem(COleVariant((long)12),COleVariant((long)4),COleVariant(Bijiao[u1].nengyuandanjia));
range.SetItem(COleVariant((long)12),COleVariant((long)7),COleVariant(m_nengyuandanjia1));
//range.SetItem(COleVariant((long)13),COleVariant((long)1),COleVariant("热效率"));

//range.SetItem(COleVariant((long)13),COleVariant((long)4),COleVariant(m_str1[0]));
//range.SetItem(COleVariant((long)13),COleVariant((long)7),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)14),COleVariant((long)1),COleVariant("日耗能费（元）"));

range.SetItem(COleVariant((long)14),COleVariant((long)4),COleVariant(m_rihao));
range.SetItem(COleVariant((long)14),COleVariant((long)7),COleVariant(m_rihao1));
range.SetItem(COleVariant((long)15),COleVariant((long)1),COleVariant("节省"));

range.SetItem(COleVariant((long)15),COleVariant((long)4),COleVariant(m_sheng));
range.SetItem(COleVariant((long)15),COleVariant((long)7),COleVariant(m_sheng1));
range.SetItem(COleVariant((long)16),COleVariant((long)1),COleVariant("1年能耗费合计 （元）"));

range.SetItem(COleVariant((long)16),COleVariant((long)4),COleVariant(m_1nianhao));
range.SetItem(COleVariant((long)16),COleVariant((long)7),COleVariant(m_1nianhao1));
range.SetItem(COleVariant((long)17),COleVariant((long)1),COleVariant("5年能耗费合计 （元）"));

range.SetItem(COleVariant((long)17),COleVariant((long)4),COleVariant(m_5nianhao));
range.SetItem(COleVariant((long)17),COleVariant((long)7),COleVariant(m_5nianhao1));
range.SetItem(COleVariant((long)18),COleVariant((long)1),COleVariant("8年能耗费合计 （元）"));

range.SetItem(COleVariant((long)18),COleVariant((long)4),COleVariant(m_8nianhao));
range.SetItem(COleVariant((long)18),COleVariant((long)7),COleVariant(m_8nianhao1));
range.SetItem(COleVariant((long)19),COleVariant((long)1),COleVariant("维护成本"));
index=m_combo13.GetCurSel();
m_combo13.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)19),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)19),COleVariant((long)7),COleVariant("小"));
range.SetItem(COleVariant((long)20),COleVariant((long)1),COleVariant("运行人力成本"));
index=m_combo15.GetCurSel();
m_combo15.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)20),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)20),COleVariant((long)7),COleVariant("  无"));
range.SetItem(COleVariant((long)21),COleVariant((long)1),COleVariant("污染情况"));
index=m_combo17.GetCurSel();
m_combo17.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)21),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)21),COleVariant((long)7),COleVariant(" 无"));
range.SetItem(COleVariant((long)22),COleVariant((long)1),COleVariant("外部因数影响"));
index=m_combo19.GetCurSel();
m_combo19.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)22),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)22),COleVariant((long)7),COleVariant("电价"));
range.SetItem(COleVariant((long)23),COleVariant((long)1),COleVariant("安全性"));
index=m_combo21.GetCurSel();
m_combo21.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)23),COleVariant((long)4),COleVariant(m_str1[0]));
range.SetItem(COleVariant((long)23),COleVariant((long)7),COleVariant("安全"));
range.SetItem(COleVariant((long)27),COleVariant((long)1),COleVariant((CString("项目：")+combo[5])));
 //设置第一个单元格字体颜色:红色
 Font font;
 range.AttachDispatch(sheet.GetCells());
 range.AttachDispatch((range.GetItem (COleVariant(long(1)), COleVariant(long(1)))).pdispVal);
 font.SetColor(COleVariant((long)0xFF0000));  
 
 
 //*****
 //合并单元格的处理
 //包括判断第一个单元格是否为合并单元格，以及将第一个单元格进行合并
 /*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)2),COleVariant((long)3)));
 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(); 
}	
}

BOOL CBijiaoDlg::PreTranslateMessage(MSG* pMsg) 
{
m_tooltip3.RelayEvent(pMsg);	
	return CDialog::PreTranslateMessage(pMsg);
}

void CBijiaoDlg::OnChangeEdit13() 
{UpdateData(true);
flag1=true;
int index=m_combo2.GetCurSel();
switch(index)
{
case 0:
	Bijiao[0].nengyuandanjia=m_nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=a[0]/0.95/860*atof(m_nengyuandanjia);
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	UpdateData(false);
	break;
case 1:Bijiao[1].nengyuandanjia=m_nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=a[1]*40/0.8/6500*atof(m_nengyuandanjia);
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	UpdateData(false);
	break;
case 2:
	Bijiao[2].nengyuandanjia=m_nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=a[1]*40/0.85/10200*atof(m_nengyuandanjia);
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	UpdateData(false);
	break;
case 3:
	Bijiao[3].nengyuandanjia=m_nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=a[0]/0.95/860/3*atof(m_nengyuandanjia);
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	UpdateData(false);
	break;
case 4:Bijiao[4].nengyuandanjia=m_nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=a[1]*40/0.8/3800*atof(m_nengyuandanjia);
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	UpdateData(false);
	break;
default:
	break;
}
	
}

void CBijiaoDlg::OnChangeEdit15() 
{
UpdateData(true);
m_rihao1=(int)(a[2]*atof(m_nengyuandanjia1));
if(m_combo2.GetCurSel()>=0)
{m_sheng1.Format("%0.1f%%",(m_rihao-m_rihao1)/m_rihao*100);
m_1nianhao1=m_rihao1*365;
m_5nianhao1=m_1nianhao1*5;
m_8nianhao1=m_1nianhao1*8;
m_nengxiaobi.Format("%0.1f%%",atof(nengxiaobi)*100);
UpdateData(false);	
}	
}