baojiadlg.cpp

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

	for(int r=0;r<m_combo6.GetCount();r++)
	{if(strcmp(str8,Kongzhi[r].xinghao)==0)
	{m_chandi5=Kongzhi[r].chandi;
m_chengben5.Format("%1.2f",Kongzhi[r].chengben);
m_danjia5.Format("%1.3f",Kongzhi[r].danjia*atof(m_xishu5));
danjia[7]=Kongzhi[r].danjia;
m_xiaoji5=atof(m_danjia5)*m_num5;
m_chengbenjia5=atof(m_chengben5)*m_num5;
	}
	}
}
m_shuishou=(m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi))*0.06;
m_inall=m_shuishou+m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi);
m_all1=m_chengbenjia+m_chengbenjia1+m_chengbenjia2+m_chengbenjia3+m_chengbenjia4+m_chengbenjia5+m_chengbenjia6+m_chengbenjia7+m_chengbenjia8+m_chengbenjia9+m_chengbenjia10+m_chengbenjia11+atof(m_diaozhuang1);
m_zongjia=m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi);
UpdateData(false);
}

void CBaojiaDlg::OnSelchangeCombo7() 
{
	UpdateData(true);
flag1=true;
if(m_num6==0)
{
m_combo7.SetCurSel(-1);
m_chandi6="";
m_chengben6="";
m_danjia6="";
m_xiaoji6=0;
m_chengbenjia6=0;
danjia[8]=0;
}
else
{
	int index9=m_combo7.GetCurSel();
	CString str9;
	m_combo7.GetLBText(index9,str9);
	for(int r=0;r<m_combo7.GetCount();r++)
	{if(strcmp(str9,Shuibeng[r].xinghao)==0)
	{m_chandi6=Shuibeng[r].chandi;
m_chengben6.Format("%1.2f",Shuibeng[r].chengben);
m_danjia6.Format("%1.3f",Shuibeng[r].danjia*atof(m_xishu6));
danjia[8]=Shuibeng[r].danjia;
m_xiaoji6=atof(m_danjia6)*m_num6;
m_chengbenjia6=atof(m_chengben6)*m_num6;
	}
	}
}
m_shuishou=(m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi))*0.06;
m_inall=m_shuishou+m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi);
m_all1=m_chengbenjia+m_chengbenjia1+m_chengbenjia2+m_chengbenjia3+m_chengbenjia4+m_chengbenjia5+m_chengbenjia6+m_chengbenjia7+m_chengbenjia8+m_chengbenjia9+m_chengbenjia10+m_chengbenjia11+atof(m_diaozhuang1);
m_zongjia=m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi);
UpdateData(false);
}

void CBaojiaDlg::OnSelchangeCombo8() 
{
		UpdateData(true);
flag1=true;
if(m_num7==0)
{
m_combo8.SetCurSel(-1);
m_chandi7="";
m_chengben7="";
m_danjia7="";
m_xiaoji7=0;
m_chengbenjia7=0;
}
else
{
	int index13=m_combo8.GetCurSel();
	CString str14;
	m_combo8.GetLBText(index13,str14);
	for(int r=0;r<m_combo8.GetCount();r++)
	{if(strcmp(str14,Dianlan[r].xinghao)==0)
	{m_chandi7=Dianlan[r].chandi;
m_chengben7.Format("%1.2f",Dianlan[r].chengben);
m_danjia7.Format("%1.3f",Dianlan[r].danjia*atof(m_xishu7));
m_xiaoji7=atof(m_danjia7)*m_num7;
m_chengbenjia7=atof(m_chengben7)*m_num7;

	}
	}
}
m_shuishou=(m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi))*0.06;
m_inall=m_shuishou+m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi);
m_all1=m_chengbenjia+m_chengbenjia1+m_chengbenjia2+m_chengbenjia3+m_chengbenjia4+m_chengbenjia5+m_chengbenjia6+m_chengbenjia7+m_chengbenjia8+m_chengbenjia9+m_chengbenjia10+m_chengbenjia11+atof(m_diaozhuang1);
m_zongjia=m_xiaoji+m_xiaoji1+m_xiaoji2+m_xiaoji3+m_xiaoji4+m_xiaoji5+m_xiaoji6+m_xiaoji7+m_xiaoji8+m_xiaoji9+m_xiaoji10+m_xiaoji11+atof(m_diaozhuang)+atof(m_tiaoshi);
UpdateData(false);

	
}

void CBaojiaDlg::OnButton1() 
{
UpdateData(true);
//AfxOleInit();	//COM初始化
//*****
 //变量定义
 _Application app;    
 Workbooks books;
 _Workbook book;
 Worksheets sheets;
 _Worksheet sheet;
 Range range;
 Range iCell;
 Range unionRange;
 CString string[100];
 int dex,dex11;
 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
 books.AttachDispatch(app.GetWorkbooks());
 lpDisp = books.Open("d:\\Yornik2\\输出文件\\报价4.xls",      
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional, covOptional, covOptional, covOptional,
   covOptional, covOptional );   

//lpDisp = books.Add(covOptional);
     
 //*****
 //得到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
 //读取水平对齐方式

range.AttachDispatch(sheet.GetCells());
 iCell.AttachDispatch((range.GetItem (COleVariant(long(3)), COleVariant(long(3)))).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(3)), COleVariant(long(3)))).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)3),COleVariant((long)3)).pdispVal );
range.Merge(COleVariant((short)1));
range.SetWrapText(COleVariant((short)1));


range.AttachDispatch(sheet.GetCells());
 iCell.AttachDispatch((range.GetItem (COleVariant(long(7)), COleVariant(long(1)))).pdispVal);
 vResult.lVal=0;
iCell.SetHorizontalAlignment(COleVariant((long)-4131));
 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(7)), COleVariant(long(1)))).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)3),COleVariant((long)3)).pdispVal );
range.Merge(COleVariant((short)1));
range.SetWrapText(COleVariant((short)1));

 for(int g1=9;g1<=43;g1+=2)
	 for(int g2=1;g2<=15;g2++)
	 {
 range.AttachDispatch(sheet.GetCells());
 iCell.AttachDispatch((range.GetItem (COleVariant(long(g1)), COleVariant(long(g2)))).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(g1)), COleVariant(long(g2)))).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)g1),COleVariant((long)g2)).pdispVal );
range.Merge(COleVariant((short)1));
range.SetWrapText(COleVariant((short)1));
	 }

  

range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)1)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)2)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)1)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells());