⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 bijiaodlg.cpp

📁 价格生成系统 热水器生产厂家价格管理、设备类型管理系统
💻 CPP
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
}
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("%1.0f%%",atof(nengxiaobi)*100);
UpdateData(false);	
}
	CDialog::OnTimer(nIDEvent);
}

void CBijiaoDlg::OnButton2() 
{
UpdateData(true);
for(int u1=0;u1<m_combo2.GetCount();u1++)
{m_combo2.SetCurSel(u1);
m_combo3.SetCurSel(u1);	
m_combo6.SetCurSel(u1);	
m_combo7.SetCurSel(u1);	
m_combo9.SetCurSel(u1);	
m_combo10.SetCurSel(1);	
//m_combo11.SetCurSel(u1);	
m_combo13.SetCurSel(u1);	
m_combo15.SetCurSel(u1);	
m_combo17.SetCurSel(u1);	
m_combo19.SetCurSel(u1);	
m_combo21.SetCurSel(u1);	

switch(u1)
{
case 0:m_nengyuandanjia=Bijiao[0].nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=(int)(a[0]/0.95/860*atof(m_nengyuandanjia));
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	m_sheng1.Format("%0.1f%%",(m_rihao-m_rihao1)/m_rihao*100);
	UpdateData(false);
	break;
case 1:m_nengyuandanjia=Bijiao[1].nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=(int)(a[1]*40/0.8/6500*atof(m_nengyuandanjia));
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	m_sheng1.Format("%0.1f%%",(m_rihao-m_rihao1)/m_rihao*100);
	UpdateData(false);
	break;
case 2:m_nengyuandanjia=Bijiao[2].nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=(int)(a[1]*35/0.80/10200*atof(m_nengyuandanjia));
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	m_sheng1.Format("%0.1f%%",(m_rihao-m_rihao1)/m_rihao*100);
	UpdateData(false);
	break;
case 3:m_nengyuandanjia=Bijiao[3].nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=(int)(a[0]/0.95/860/3*atof(m_nengyuandanjia));
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	m_sheng1.Format("%0.1f%%",(m_rihao-m_rihao1)/m_rihao*100);
	UpdateData(false);
	break;
case 4:m_nengyuandanjia=Bijiao[4].nengyuandanjia;
	m_richanshuiliang=a[1];
	m_rihao=(int)(a[1]*40/0.8/3800*atof(m_nengyuandanjia));
	m_1nianhao=m_rihao*365;
	m_5nianhao=m_1nianhao*5;
	m_8nianhao=m_1nianhao*8;
	m_sheng1.Format("%0.1f%%",(m_rihao-m_rihao1)/m_rihao*100);
	UpdateData(false);
	break;
default:
	break;
}
//*****
 //变量定义
 _Application app;    
 Workbooks books;
 _Workbook book;
 Worksheets sheets;
 _Worksheet sheet;
 Range range;
 Range iCell;
 Range unionRange;
 CString m_str1[100];
 int index;
 LPDISPATCH lpDisp;    
 COleVariant vResult;
 COleVariant
        covTrue((short)TRUE),
        covFalse((short)FALSE),
        covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);    
 
 

 
 
 //*****
 //创建Excel 2000服务器(启动Excel)
 if(!app.CreateDispatch("Excel.Application"))
{
  AfxMessageBox("无法启动Excel服务器!");
    return;
 }
 
app.SetVisible(TRUE);          //使Excel可见
 app.SetUserControl(TRUE);      //允许其它用户控制Excel
 

 //*****   
 //打开c:\1.xls
 switch(u1)
 {
 case 0:books.AttachDispatch(app.GetWorkbooks());
 lpDisp = books.Open("d:\\Yornik2\\输出文件\\电热水器5.xls",      
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional );   
 break;

 case 1:books.AttachDispatch(app.GetWorkbooks());
 lpDisp = books.Open("d:\\Yornik2\\输出文件\\煤    气7.xls",      
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional );   
 break;

 case 2:books.AttachDispatch(app.GetWorkbooks());
 lpDisp = books.Open("d:\\Yornik2\\输出文件\\燃油锅炉6.xls",      
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional );   
 break;

 case 3:books.AttachDispatch(app.GetWorkbooks());
 lpDisp = books.Open("d:\\Yornik2\\输出文件\\太阳能8.xls",      
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional );   
 break;

 case 4:books.AttachDispatch(app.GetWorkbooks());
 lpDisp = books.Open("d:\\Yornik2\\输出文件\\管道媒气9.xls",      
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional );   
 break;


 default:
	 break;


 }   
 //*****
 //得到Workbook
 book.AttachDispatch(lpDisp);
 
 
 //*****
 //得到Worksheets 
 sheets.AttachDispatch(book.GetWorksheets()); 
 
 
 //*****
 //得到当前活跃sheet
 //如果有单元格正处于编辑状态中，此操作不能返回，会一直等待
 lpDisp=book.GetActiveSheet();
 sheet.AttachDispatch(lpDisp); 
  


 //读取已经使用区域的信息，包括已经使用的行数、列数、起始行、起始列

 Range usedRange;
 usedRange.AttachDispatch(sheet.GetUsedRange());
 range.AttachDispatch(usedRange.GetRows());
 long iRowNum=range.GetCount();                   //已经使用的行数
 
 range.AttachDispatch(usedRange.GetColumns());
 long iColNum=range.GetCount();                   //已经使用的列数
  
 long iStartRow=usedRange.GetRow();               //已使用区域的起始行，从1开始
 long iStartCol=usedRange.GetColumn();            //已使用区域的起始列，从1开始

 //读取第一个单元格的值
range.AttachDispatch(sheet.GetCells()); 
 range.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)1)).pdispVal );
vResult =range.GetValue();
 CString str;
 if(vResult.vt == VT_BSTR)       //字符串
 {
  str=vResult.bstrVal;
 }
 else if (vResult.vt==VT_R8)     //8字节的数字 
 {
  str.Format("%f",vResult.dblVal);
 }
 else if(vResult.vt==VT_DATE)    //时间格式
 {
  SYSTEMTIME st;
     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)5),COleVariant((long)1),COleVariant("设备名称"));
index=m_combo2.GetCurSel();
m_combo2.GetLBText(index,m_str1[0]);
range.SetItem(COleVariant((long)5),COleVariant((long)4),COleVariant(m_str1[0]));
index=m_combo1.GetCurSel();
m_combo1.GetLBText(index,m_str1[0]);
m_str1[1].Format("约能热泵(%s)",m_str1[0]);
range.SetItem(COleVariant((long)5),COleVariant((long)7),COleVariant(m_str1[1]));
/*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();
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -