baojiadlg.cpp

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

 unionRange.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)3)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)10)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)1),COleVariant((long)13)).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)14)).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)3),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)3),COleVariant((long)2)).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)3),COleVariant((long)3)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)10)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)3),COleVariant((long)13)).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)3),COleVariant((long)14)).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)5),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)5),COleVariant((long)2)).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)5),COleVariant((long)3)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)10)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)5),COleVariant((long)13)).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)5),COleVariant((long)14)).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)7),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)12)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 


for(int k=9;k<32;k+=2)
{range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)2)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)3)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)3)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)6)).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)k),COleVariant((long)7)).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)k),COleVariant((long)8)).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)k),COleVariant((long)9)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)2)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)11)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)2)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)13)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)1)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
}
for(k=33;k<50;k+=2)
{range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)2)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)3)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)8)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)11)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)2)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)k),COleVariant((long)13)).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)51),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)12)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格

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

 range.AttachDispatch(sheet.GetCells()); 
 unionRange.AttachDispatch(range.GetItem (COleVariant((long)55),COleVariant((long)1)).pdispVal );
 unionRange.AttachDispatch(unionRange.GetResize(COleVariant((long)2),COleVariant((long)12)));
 unionRange.Merge(COleVariant((long)0));   //合并单元格
 */
range.SetItem(COleVariant((long)3),COleVariant((long)3),COleVariant("约能热水工程设备清单及报价"));
string[9]=CString("项目名称：")+combo[5];
range.SetItem(COleVariant((long)7),COleVariant((long)1),COleVariant(string[9]));
range.SetItem(COleVariant((long)9),COleVariant((long)1),COleVariant("设备名称"));
range.SetItem(COleVariant((long)9),COleVariant((long)3),COleVariant("规格型号"));
range.SetItem(COleVariant((long)9),COleVariant((long)6),COleVariant("产地"));
range.SetItem(COleVariant((long)9),COleVariant((long)7),COleVariant("数量"));
range.SetItem(COleVariant((long)9),COleVariant((long)8),COleVariant("单位"));
range.SetItem(COleVariant((long)9),COleVariant((long)9),COleVariant("单价(元）"));
range.SetItem(COleVariant((long)9),COleVariant((long)11),COleVariant("小计(元)"));
//range.SetItem(COleVariant((long)5),COleVariant((long)13),COleVariant("系数"));

//range.SetItem(COleVariant((long)11),COleVariant((long)1),COleVariant("空气源热水约能主机"));
dex=m_combo1.GetCurSel();
dex11=m_combo9.GetCurSel();
if(dex>=0&&dex11>=0)
{
m_combo1.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)11),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)11),COleVariant((long)6),COleVariant(m_chandi));
range.SetItem(COleVariant((long)11),COleVariant((long)7),COleVariant((float)m_num));
range.SetItem(COleVariant((long)11),COleVariant((long)8),COleVariant("台"));
range.SetItem(COleVariant((long)11),COleVariant((long)9),COleVariant(atof(m_danjia)*10000));
range.SetItem(COleVariant((long)11),COleVariant((long)11),COleVariant(m_xiaoji*10000));
//range.SetItem(COleVariant((long)7),COleVariant((long)13),COleVariant(m_xishu));
m_combo9.GetLBText(dex11,string[0]);
range.SetItem(COleVariant((long)13),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)13),COleVariant((long)6),COleVariant(m_chandi8));
range.SetItem(COleVariant((long)13),COleVariant((long)7),COleVariant((float)m_num8));
range.SetItem(COleVariant((long)13),COleVariant((long)8),COleVariant("台"));
range.SetItem(COleVariant((long)13),COleVariant((long)9),COleVariant(atof(m_danjia8)*10000));
range.SetItem(COleVariant((long)13),COleVariant((long)11),COleVariant(m_xiaoji8*10000));
}

else if(dex11=-1&&dex>=0)
{
m_combo1.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)11),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)11),COleVariant((long)6),COleVariant(m_chandi));
range.SetItem(COleVariant((long)11),COleVariant((long)7),COleVariant((float)m_num));
range.SetItem(COleVariant((long)11),COleVariant((long)8),COleVariant("台"));
range.SetItem(COleVariant((long)11),COleVariant((long)9),COleVariant(atof(m_danjia)*10000));
range.SetItem(COleVariant((long)11),COleVariant((long)11),COleVariant(m_xiaoji*10000));
//range.SetItem(COleVariant((long)9),COleVariant((long)13),COleVariant(m_xishu8));
range.SetItem(COleVariant((long)13),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)11),COleVariant(""));
}

else if(dex11>=0&&dex==-1)
{
m_combo9.GetLBText(dex11,string[0]);
range.SetItem(COleVariant((long)11),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)11),COleVariant((long)6),COleVariant(m_chandi8));
range.SetItem(COleVariant((long)11),COleVariant((long)7),COleVariant((float)m_num8));
range.SetItem(COleVariant((long)11),COleVariant((long)8),COleVariant("台"));
range.SetItem(COleVariant((long)11),COleVariant((long)9),COleVariant(atof(m_danjia8)*10000));
range.SetItem(COleVariant((long)11),COleVariant((long)11),COleVariant(m_xiaoji8*10000));
range.SetItem(COleVariant((long)13),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)11),COleVariant(""));
}

else if(dex11==-1&&dex==-1)
{

range.SetItem(COleVariant((long)11),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)11),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)11),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)11),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)11),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)11),COleVariant((long)11),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)13),COleVariant((long)11),COleVariant(""));
}
//range.SetItem(COleVariant((long)15),COleVariant((long)1),COleVariant("不锈钢电加热器"));

dex=m_combo2.GetCurSel();
dex11=m_combo12.GetCurSel();
if(dex>=0&&dex11>=0)
{
m_combo2.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)15),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)15),COleVariant((long)6),COleVariant(m_chandi1));
range.SetItem(COleVariant((long)15),COleVariant((long)7),COleVariant((float)m_num1));
range.SetItem(COleVariant((long)15),COleVariant((long)8),COleVariant("个"));
range.SetItem(COleVariant((long)15),COleVariant((long)9),COleVariant(atof(m_danjia1)*10000));
range.SetItem(COleVariant((long)15),COleVariant((long)11),COleVariant(m_xiaoji1*10000));
m_combo12.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)17),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)17),COleVariant((long)6),COleVariant(m_chandi11));
range.SetItem(COleVariant((long)17),COleVariant((long)7),COleVariant((float)m_num11));
range.SetItem(COleVariant((long)17),COleVariant((long)8),COleVariant("个"));
range.SetItem(COleVariant((long)17),COleVariant((long)9),COleVariant(atof(m_danjia11)*10000));
range.SetItem(COleVariant((long)17),COleVariant((long)11),COleVariant(m_xiaoji11*10000));
//range.SetItem(COleVariant((long)11),COleVariant((long)13),COleVariant(m_xishu1));
}

else if(dex11==-1&&dex>=0)
{
m_combo2.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)15),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)15),COleVariant((long)6),COleVariant(m_chandi1));
range.SetItem(COleVariant((long)15),COleVariant((long)7),COleVariant((float)m_num1));
range.SetItem(COleVariant((long)15),COleVariant((long)8),COleVariant("个"));
range.SetItem(COleVariant((long)15),COleVariant((long)9),COleVariant(atof(m_danjia1)*10000));
range.SetItem(COleVariant((long)15),COleVariant((long)11),COleVariant(m_xiaoji1*10000));

range.SetItem(COleVariant((long)17),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)11),COleVariant(""));
//range.SetItem(COleVariant((long)11),COleVariant((long)13),COleVariant(m_xishu1));
}
else if(dex11>=0&&dex==-1)
{m_combo12.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)15),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)15),COleVariant((long)6),COleVariant(m_chandi11));
range.SetItem(COleVariant((long)15),COleVariant((long)7),COleVariant((float)m_num11));
range.SetItem(COleVariant((long)15),COleVariant((long)8),COleVariant("个"));
range.SetItem(COleVariant((long)15),COleVariant((long)9),COleVariant(atof(m_danjia11)*10000));
range.SetItem(COleVariant((long)15),COleVariant((long)11),COleVariant(m_xiaoji11*10000));
range.SetItem(COleVariant((long)17),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)11),COleVariant(""));
}
else if(dex11==-1&&dex==-1)
{range.SetItem(COleVariant((long)15),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)15),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)15),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)15),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)15),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)15),COleVariant((long)11),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)17),COleVariant((long)11),COleVariant(""));
}
//range.SetItem(COleVariant((long)19),COleVariant((long)1),COleVariant("不锈钢保温水箱"));


dex=m_combo3.GetCurSel();
if(dex>=0)
{
m_combo3.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)19),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)19),COleVariant((long)6),COleVariant(m_chandi2));
range.SetItem(COleVariant((long)19),COleVariant((long)7),COleVariant((float)m_num2));
range.SetItem(COleVariant((long)19),COleVariant((long)8),COleVariant("个"));
range.SetItem(COleVariant((long)19),COleVariant((long)9),COleVariant(atof(m_danjia2)*10000));
CString xiaoji2;
xiaoji2.Format("%1.0f",m_xiaoji2*10000);
range.SetItem(COleVariant((long)19),COleVariant((long)11),COleVariant(xiaoji2));
//range.SetItem(COleVariant((long)13),COleVariant((long)13),COleVariant(m_xishu2));
}
else 
{range.SetItem(COleVariant((long)19),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)19),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)19),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)19),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)19),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)19),COleVariant((long)11),COleVariant(""));
}
//range.SetItem(COleVariant((long)21),COleVariant((long)1),COleVariant("水箱支架"));
dex=m_combo4.GetCurSel();
if(dex>=0)
{
m_combo4.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)21),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)21),COleVariant((long)6),COleVariant(m_chandi3));
range.SetItem(COleVariant((long)21),COleVariant((long)7),COleVariant((float)m_num3));
range.SetItem(COleVariant((long)21),COleVariant((long)8),COleVariant("个"));
range.SetItem(COleVariant((long)21),COleVariant((long)9),COleVariant(atof(m_danjia3)*10000));
range.SetItem(COleVariant((long)21),COleVariant((long)11),COleVariant(m_xiaoji3*10000));
//range.SetItem(COleVariant((long)15),COleVariant((long)13),COleVariant(m_xishu3));
}
else 
{range.SetItem(COleVariant((long)21),COleVariant((long)3),COleVariant(""));
range.SetItem(COleVariant((long)21),COleVariant((long)6),COleVariant(""));
range.SetItem(COleVariant((long)21),COleVariant((long)7),COleVariant(""));
range.SetItem(COleVariant((long)21),COleVariant((long)8),COleVariant(""));
range.SetItem(COleVariant((long)21),COleVariant((long)9),COleVariant(""));
range.SetItem(COleVariant((long)21),COleVariant((long)11),COleVariant(""));
}
//range.SetItem(COleVariant((long)23),COleVariant((long)1),COleVariant("管道及保温材料"));
dex=m_combo5.GetCurSel();
dex11=m_combo11.GetCurSel();
if(dex>=0)
{
m_combo5.GetLBText(dex,string[0]);
range.SetItem(COleVariant((long)23),COleVariant((long)3),COleVariant(string[0]));
range.SetItem(COleVariant((long)23),COleVariant((long)6),COleVariant(m_chandi4));
range.SetItem(COleVariant((long)23),COleVariant((long)7),COleVariant((float)m_num4));
range.SetItem(COleVariant((long)23),COleVariant((long)8),COleVariant("棕"));
range.SetItem(COleVariant((long)23),COleVariant((long)9),COleVariant(atof(m_danjia4)*10000));
range.SetItem(COleVariant((long)23),COleVariant((long)11),COleVariant(m_xiaoji4*10000));
//range.SetItem(COleVariant((long)17),COleVariant((long)13),COleVariant(m_xishu4));
}

else if(dex11>=0&&dex==-1)
{m_co