public void generateExcelToCheck(List <MBBgaMaterialStruct> StockCheckList, List <bgaReport> bgas, string startTime, string endTime) { List <allContent> allcontentList = new List <allContent>(); allContent firstsheet = new allContent(); firstsheet.sheetName = "MBBga材料一览表"; firstsheet.titleList = new List <string>(); firstsheet.contentList = new List <object>(); firstsheet.titleList.Add("厂商"); firstsheet.titleList.Add("客户别"); firstsheet.titleList.Add("MB简称"); firstsheet.titleList.Add("MPN"); firstsheet.titleList.Add("MB描述");; firstsheet.titleList.Add("厂商PCH_MPN"); firstsheet.titleList.Add("PCH简述"); firstsheet.titleList.Add("PCH描述"); firstsheet.titleList.Add("厂商VGA_MPN"); firstsheet.titleList.Add("VGA简述"); firstsheet.titleList.Add("VGA描述"); firstsheet.titleList.Add("厂商CPU_MPN"); firstsheet.titleList.Add("CPU简述"); firstsheet.titleList.Add("CPU描述"); firstsheet.titleList.Add("DPK类型"); firstsheet.titleList.Add("保修期"); firstsheet.titleList.Add("客户机型"); firstsheet.titleList.Add("整机出货量"); firstsheet.titleList.Add("客户退修量"); firstsheet.titleList.Add("MB购买数量"); firstsheet.titleList.Add("MB报废数量"); firstsheet.titleList.Add("MB报废率"); firstsheet.titleList.Add("材料类别"); foreach (MBBgaMaterialStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.mb_descripe); ct1.Add(stockcheck.vendor_pch_mpn); ct1.Add(stockcheck.pcb_brief_describe); ct1.Add(stockcheck.pcb_describe); ct1.Add(stockcheck.vendor_vga_mpn); ct1.Add(stockcheck.vga_brief_describe); ct1.Add(stockcheck.vga_describe); ct1.Add(stockcheck.vendor_cpu_mpn); ct1.Add(stockcheck.cpu_brief); ct1.Add(stockcheck.cpu_describe); ct1.Add(stockcheck.dpk_type); ct1.Add(stockcheck.warranty_period); ct1.Add(stockcheck.custom_machine_type); ct1.Add(stockcheck.whole_out_num); ct1.Add(stockcheck.repaire_num); ct1.Add(stockcheck.mb_buy_in_num); ct1.Add(stockcheck.mb_fault_num); ct1.Add(stockcheck.mb_fault_rate); ct1.Add(stockcheck.eol); ctest1.contentArray = ct1; firstsheet.contentList.Add(ctest1); } allcontentList.Add(firstsheet); allContent secondsheet = new allContent(); secondsheet.sheetName = "BGAMB一览表"; secondsheet.titleList = new List <string>(); secondsheet.contentList = new List <object>(); secondsheet.titleList.Add("BGA_厂商MPN"); secondsheet.titleList.Add("BGA简述"); secondsheet.titleList.Add("BGA描述"); secondsheet.titleList.Add("BGA类别"); secondsheet.titleList.Add("厂商"); secondsheet.titleList.Add("客户别"); secondsheet.titleList.Add("MB简称"); secondsheet.titleList.Add("mpn"); secondsheet.titleList.Add("对应整机出货量"); secondsheet.titleList.Add("客户退修量"); secondsheet.titleList.Add("近1个月MB退修量"); secondsheet.titleList.Add("近2个月MB退修量"); secondsheet.titleList.Add("BGA更换数量"); secondsheet.titleList.Add("BGA不良率"); secondsheet.titleList.Add("材料类别"); foreach (bgaReport stockcheck in bgas) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.bgapn); ct1.Add(stockcheck.bga_brief); ct1.Add(stockcheck.bga_desc); ct1.Add(stockcheck.bga_type); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.whole_out_num); ct1.Add(stockcheck.repaire_num); ct1.Add(stockcheck.repair_num_1_month); ct1.Add(stockcheck.repair_num_2_month); ct1.Add(stockcheck.bga_change_number); ct1.Add(stockcheck.bga_rate); ct1.Add(stockcheck.material_type); ctest1.contentArray = ct1; secondsheet.contentList.Add(ctest1); } allcontentList.Add(secondsheet); Utils.createMulitSheetsUsingNPOI("MBBga材料一览表" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xls", allcontentList); }
public void generateExcelToCheck( debitnotsSheet3 debitnots, List <allSumStruct> allSumStructListAIO, List <allSumStruct> allSumStructListNB, List <fruListSheet4> fruList, List <nb_aio_mblistSheet5_6> repairRecordListAIO, List <nb_aio_mblistSheet5_6> repairRecordListNB, string startTime, string endTime) { List <allContent> allcontentList = new List <allContent>(); //汇总AIO allContent sumContentAio = new allContent(); sumContentAio.sheetName = startTime + "到" + endTime + "汇总AIO"; sumContentAio.titleList = new List <string>(); sumContentAio.contentList = new List <object>(); sumContentAio.titleList.Add("Model"); sumContentAio.titleList.Add("数量"); if (allSumStructListAIO.Count == 0) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ctest1.contentArray = ct1; ct1.Add(""); ct1.Add(""); sumContentAio.contentList.Add(ctest1); } else { foreach (allSumStruct temp in allSumStructListAIO) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ctest1.contentArray = ct1; ct1.Add(temp.mb_brief); ct1.Add(temp.returnNum + ""); sumContentAio.contentList.Add(ctest1); } } allcontentList.Add(sumContentAio); //汇总NB allContent sumContentNB = new allContent(); sumContentNB.sheetName = startTime + "到" + endTime + "汇总NB"; sumContentNB.titleList = new List <string>(); sumContentNB.contentList = new List <object>(); sumContentNB.titleList.Add("Model"); sumContentNB.titleList.Add("数量"); if (allSumStructListNB.Count == 0) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ctest1.contentArray = ct1; ct1.Add(""); ct1.Add(""); sumContentNB.contentList.Add(ctest1); } else { foreach (allSumStruct temp in allSumStructListNB) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ctest1.contentArray = ct1; ct1.Add(temp.mb_brief); ct1.Add(temp.returnNum + ""); sumContentNB.contentList.Add(ctest1); } } allcontentList.Add(sumContentNB); //FRU记录 allContent fruContent = new allContent(); fruContent.sheetName = startTime + "到" + endTime + "FRU记录"; fruContent.titleList = new List <string>(); fruContent.contentList = new List <object>(); fruContent.titleList.Add("收料日期"); fruContent.titleList.Add("rma号码"); fruContent.titleList.Add("联想料号"); fruContent.titleList.Add("机型"); fruContent.titleList.Add("名称"); fruContent.titleList.Add("配件序号"); fruContent.titleList.Add("周期"); fruContent.titleList.Add("保内外"); fruContent.titleList.Add("料号71"); fruContent.titleList.Add("原材料号"); fruContent.titleList.Add("客户故障"); // fruContent.titleList.Add("是否收费"); fruContent.titleList.Add("charge "); if (fruList.Count == 0) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ctest1.contentArray = ct1; ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); //ct1.Add(""); ct1.Add(""); fruContent.contentList.Add(ctest1); } else { foreach (fruListSheet4 temp in fruList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ctest1.contentArray = ct1; ct1.Add(Utils.modifyDataFormat(temp.receive_date)); ct1.Add(temp.orderno); ct1.Add(temp.customermaterialno); ct1.Add(temp.machine_type); ct1.Add(temp.name); ct1.Add(temp.peijian_no); ct1.Add(Utils.modifyDataFormat(temp.make_date)); ct1.Add(temp.gurantee); ct1.Add(temp.vendor_material_no); ct1.Add(temp.mpn1); ct1.Add(temp.custom_fault); //ct1.Add(temp.eol); ct1.Add(temp.charge); fruContent.contentList.Add(ctest1); } } allcontentList.Add(fruContent); //维修记录AIO allContent repairRecordContentAIO = new allContent(); repairRecordContentAIO.sheetName = startTime + "到" + endTime + "维修记录AIO"; repairRecordContentAIO.titleList = new List <string>(); repairRecordContentAIO.contentList = new List <object>(); repairRecordContentAIO.titleList.Add("订单编号"); repairRecordContentAIO.titleList.Add("来源"); repairRecordContentAIO.titleList.Add("跟踪条码"); repairRecordContentAIO.titleList.Add("收货日期"); repairRecordContentAIO.titleList.Add("MB简称"); repairRecordContentAIO.titleList.Add("MB描述"); repairRecordContentAIO.titleList.Add("MPN"); repairRecordContentAIO.titleList.Add("厂商序号"); repairRecordContentAIO.titleList.Add("MB生产日期"); repairRecordContentAIO.titleList.Add("客户故障"); for (int i = 1; i <= 3; i++) { repairRecordContentAIO.titleList.Add("现象" + i); } for (int i = 1; i <= 1; i++) { repairRecordContentAIO.titleList.Add("mbfa" + i); } repairRecordContentAIO.titleList.Add("短路电压"); repairRecordContentAIO.titleList.Add("北桥"); repairRecordContentAIO.titleList.Add("南北桥料号"); repairRecordContentAIO.titleList.Add("南桥"); repairRecordContentAIO.titleList.Add("vga芯片料号"); repairRecordContentAIO.titleList.Add("显存"); repairRecordContentAIO.titleList.Add("CPU料号"); repairRecordContentAIO.titleList.Add("CPU底座"); for (int i = 1; i <= 3; i++) { repairRecordContentAIO.titleList.Add("其他" + i + "位置"); //repairRecordContentAIO.titleList.Add("其他" + i + "位置料号"); } repairRecordContentAIO.titleList.Add("断线氧化内短位置"); repairRecordContentAIO.titleList.Add("维修人"); repairRecordContentAIO.titleList.Add("测试人"); repairRecordContentAIO.titleList.Add("修复日期 "); repairRecordContentAIO.titleList.Add("工程变更 "); repairRecordContentAIO.titleList.Add("charge"); if (repairRecordListAIO.Count == 0) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); for (int i = 0; i < 3; i++) { ct1.Add(""); } for (int i = 0; i < 1; i++) { ct1.Add(""); } ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); for (int i = 0; i < 3; i++) { ct1.Add(""); } ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ctest1.contentArray = ct1; repairRecordContentAIO.contentList.Add(ctest1); } else { foreach (nb_aio_mblistSheet5_6 repaircheck in repairRecordListAIO) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(repaircheck.order_no); ct1.Add(repaircheck.source); ct1.Add(repaircheck.track_serial_no); ct1.Add(Utils.modifyDataFormat(repaircheck.receivedate)); ct1.Add(repaircheck.mb_brief); ct1.Add(repaircheck.mb_describe); ct1.Add(repaircheck.mpn); ct1.Add(repaircheck.vendor_serail_no); ct1.Add(Utils.modifyDataFormat(repaircheck.mb_make_date)); ct1.Add(repaircheck.custom_fault); for (int i = 0; i < 3; i++) { if (i < repaircheck.fault_describeList.Count) { ct1.Add(repaircheck.fault_describeList[i]); } else { ct1.Add(""); } } for (int i = 0; i < 1; i++) { if (i < repaircheck.mbfaList.Count) { ct1.Add(repaircheck.mbfaList[i]); } else { ct1.Add(""); } } ct1.Add(repaircheck.shortcut); ct1.Add(""); ct1.Add(repaircheck.pch); ct1.Add(""); ct1.Add(repaircheck.vga); ct1.Add(""); ct1.Add(repaircheck.cpu); ct1.Add(""); for (int i = 0; i < 3; i++) { if (i < repaircheck.smtRecords.Count) { ct1.Add(repaircheck.smtRecords[i].smtplace); // ct1.Add(repaircheck.smtRecords[i].smtMpn); } else { ct1.Add(""); // ct1.Add(""); } } ct1.Add(""); ct1.Add(repaircheck.repairer); ct1.Add(repaircheck.tester); ct1.Add(Utils.modifyDataFormat(repaircheck.repair_date)); ct1.Add(""); ct1.Add(repaircheck.charge); ctest1.contentArray = ct1; repairRecordContentAIO.contentList.Add(ctest1); } } allcontentList.Add(repairRecordContentAIO); //维修记录NB allContent repairRecordContentNB = new allContent(); repairRecordContentNB.sheetName = startTime + "到" + endTime + "维修记录NB"; repairRecordContentNB.titleList = new List <string>(); repairRecordContentNB.contentList = new List <object>(); repairRecordContentNB.titleList.Add("订单编号"); repairRecordContentNB.titleList.Add("来源"); repairRecordContentNB.titleList.Add("跟踪条码"); repairRecordContentNB.titleList.Add("收货日期"); repairRecordContentNB.titleList.Add("MB简称"); repairRecordContentNB.titleList.Add("MB描述"); repairRecordContentNB.titleList.Add("MPN"); repairRecordContentNB.titleList.Add("厂商序号"); repairRecordContentNB.titleList.Add("MB生产日期"); repairRecordContentNB.titleList.Add("客户故障"); for (int i = 1; i <= 3; i++) { repairRecordContentNB.titleList.Add("现象" + i); } for (int i = 1; i <= 1; i++) { repairRecordContentNB.titleList.Add("mbfa" + i); } repairRecordContentNB.titleList.Add("短路电压"); repairRecordContentNB.titleList.Add("北桥"); repairRecordContentNB.titleList.Add("南北桥料号"); repairRecordContentNB.titleList.Add("南桥"); repairRecordContentNB.titleList.Add("vga芯片料号"); repairRecordContentNB.titleList.Add("显存"); repairRecordContentNB.titleList.Add("CPU料号"); repairRecordContentNB.titleList.Add("CPU底座"); for (int i = 1; i <= 3; i++) { repairRecordContentNB.titleList.Add("其他" + i + "位置"); //repairRecordContentNB.titleList.Add("其他" + i + "位置料号"); } repairRecordContentNB.titleList.Add("断线氧化内短位置"); repairRecordContentNB.titleList.Add("维修人"); repairRecordContentNB.titleList.Add("测试人"); repairRecordContentNB.titleList.Add("修复日期 "); repairRecordContentNB.titleList.Add("工程变更 "); repairRecordContentNB.titleList.Add("charge"); if (repairRecordListNB.Count == 0) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); for (int i = 0; i < 3; i++) { ct1.Add(""); } for (int i = 0; i < 1; i++) { ct1.Add(""); } ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); for (int i = 0; i < 3; i++) { ct1.Add(""); } ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ctest1.contentArray = ct1; repairRecordContentNB.contentList.Add(ctest1); } else { foreach (nb_aio_mblistSheet5_6 repaircheck in repairRecordListNB) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(repaircheck.order_no); ct1.Add(repaircheck.source); ct1.Add(repaircheck.track_serial_no); ct1.Add(Utils.modifyDataFormat(repaircheck.receivedate)); ct1.Add(repaircheck.mb_brief); ct1.Add(repaircheck.mb_describe); ct1.Add(repaircheck.mpn); ct1.Add(repaircheck.vendor_serail_no); ct1.Add(Utils.modifyDataFormat(repaircheck.mb_make_date)); ct1.Add(repaircheck.custom_fault); for (int i = 0; i < 3; i++) { if (i < repaircheck.fault_describeList.Count) { ct1.Add(repaircheck.fault_describeList[i]); } else { ct1.Add(""); } } for (int i = 0; i < 1; i++) { if (i < repaircheck.mbfaList.Count) { ct1.Add(repaircheck.mbfaList[i]); } else { ct1.Add(""); } } ct1.Add(repaircheck.shortcut); ct1.Add(""); ct1.Add(repaircheck.pch); ct1.Add(""); ct1.Add(repaircheck.vga); ct1.Add(""); ct1.Add(repaircheck.cpu); ct1.Add(""); for (int i = 0; i < 3; i++) { if (i < repaircheck.smtRecords.Count) { ct1.Add(repaircheck.smtRecords[i].smtplace); // ct1.Add(repaircheck.smtRecords[i].smtMpn); } else { ct1.Add(""); // ct1.Add(""); } } ct1.Add(""); ct1.Add(repaircheck.repairer); ct1.Add(repaircheck.tester); ct1.Add(Utils.modifyDataFormat(repaircheck.repair_date)); ct1.Add(""); ct1.Add(repaircheck.charge); ctest1.contentArray = ct1; repairRecordContentNB.contentList.Add(ctest1); } } allcontentList.Add(repairRecordContentNB); exportxmlbutton.Enabled = true; Utils.createExcelListUsingNPOI("D:\\" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + "新维修数据.xls", debitnots, allcontentList); }
public void generateExcelToCheck(List <BgaUsedStruct> StockCheckList, string startTime, string endTime, List <bagUsedSumStruct> bagWaitSumList) { List <allContent> allcontentList = new List <allContent>(); allContent firstsheet = new allContent(); firstsheet.sheetName = "BGA待料信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-'); firstsheet.titleList = new List <string>(); firstsheet.contentList = new List <object>(); firstsheet.titleList.Add("跟踪条码"); firstsheet.titleList.Add("客户料号"); firstsheet.titleList.Add("厂商"); firstsheet.titleList.Add("客户别"); firstsheet.titleList.Add("来源"); firstsheet.titleList.Add("订单编号"); firstsheet.titleList.Add("收货日期"); firstsheet.titleList.Add("MB描述"); firstsheet.titleList.Add("MB简称"); firstsheet.titleList.Add("客户序号"); firstsheet.titleList.Add("厂商序号"); firstsheet.titleList.Add("MPN"); firstsheet.titleList.Add("MB生产日期"); firstsheet.titleList.Add("客户故障"); firstsheet.titleList.Add("ECO"); firstsheet.titleList.Add("bga类型"); firstsheet.titleList.Add("BGAPN"); firstsheet.titleList.Add("BGA描述"); firstsheet.titleList.Add("BGA简述"); firstsheet.titleList.Add("老sn"); firstsheet.titleList.Add("新sn"); firstsheet.titleList.Add("更换原因"); firstsheet.titleList.Add("短路电压"); firstsheet.titleList.Add("维修人"); firstsheet.titleList.Add("更换人"); firstsheet.titleList.Add("更换日期"); firstsheet.titleList.Add("CPU采购类别"); firstsheet.titleList.Add("CPU是否更换"); foreach (BgaUsedStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.track_serial_no); ct1.Add(stockcheck.customMaterialNo); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.source); ct1.Add(stockcheck.orderno); ct1.Add(Utils.modifyDataFormat(stockcheck.receivedate)); ct1.Add(stockcheck.mb_describe); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.custom_serial_no); ct1.Add(stockcheck.vendor_serail_no); ct1.Add(stockcheck.mpn); ct1.Add(Utils.modifyDataFormat(stockcheck.mb_make_date)); ct1.Add(stockcheck.customFault); ct1.Add(stockcheck.ECO); ct1.Add(stockcheck.bgatype); ct1.Add(stockcheck.BGAPN); ct1.Add(stockcheck.BGA_describe); ct1.Add(stockcheck.bga_brief); ct1.Add(stockcheck.oldSn); ct1.Add(stockcheck.newSn); ct1.Add(stockcheck.change_reason); ct1.Add(stockcheck.shortcut); ct1.Add(stockcheck.repairer); ct1.Add(stockcheck.bga_repairer); ct1.Add(Utils.modifyDataFormat(stockcheck.change_date)); ct1.Add(stockcheck.cpu_buy_type); ct1.Add(stockcheck.cpu_change); ctest1.contentArray = ct1; firstsheet.contentList.Add(ctest1); } allcontentList.Add(firstsheet); allContent secondsheet = new allContent(); secondsheet.sheetName = "统计信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-'); secondsheet.titleList = new List <string>(); secondsheet.contentList = new List <object>(); secondsheet.titleList.Add("ECO"); secondsheet.titleList.Add("BGA类型"); secondsheet.titleList.Add("BGA简述"); secondsheet.titleList.Add("待货数量"); foreach (bagUsedSumStruct stockcheck in bagWaitSumList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.eco); ct1.Add(stockcheck.bga_type); ct1.Add(stockcheck.bga_brief); ct1.Add(stockcheck.returnNum + ""); ctest1.contentArray = ct1; secondsheet.contentList.Add(ctest1); } allcontentList.Add(secondsheet); Utils.createMulitSheetsUsingNPOI("BGA维修信息" + bgaRepair_resultcomboBox.Text.Trim() + "-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xls", allcontentList); }
public void generateExcelToCheck(List <StoreHouseStatisticsStruct> StockCheckList, Dictionary <string, bgaTypeStatistics> bgabriefdict, string startTime, string endTime) { List <allContent> allcontentList = new List <allContent>(); allContent firstsheet = new allContent(); firstsheet.sheetName = this.houseComboBox.Text + "平衡表信息导出" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-'); firstsheet.titleList = new List <string>(); firstsheet.contentList = new List <object>(); firstsheet.titleList.Add("ID"); firstsheet.titleList.Add("库房"); firstsheet.titleList.Add("储位"); firstsheet.titleList.Add("存储料号"); firstsheet.titleList.Add("类型"); firstsheet.titleList.Add("厂商"); firstsheet.titleList.Add("剩余数量"); firstsheet.titleList.Add("购买数量"); firstsheet.titleList.Add("出库数量"); firstsheet.titleList.Add("报废转卖"); firstsheet.titleList.Add("描述"); firstsheet.titleList.Add("BGA简称"); foreach (StoreHouseStatisticsStruct stockcheck in StockCheckList) { if (stockcheck.type != null && !stockcheck.type.Contains("SMT")) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.Id); ct1.Add(stockcheck.house); ct1.Add(stockcheck.place); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.type); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.leftnumber); ct1.Add(stockcheck.buynumber); ct1.Add(stockcheck.outnumber); ct1.Add(stockcheck.othernumber); ct1.Add(stockcheck.describe); ct1.Add(stockcheck.bga_brief); ctest1.contentArray = ct1; firstsheet.contentList.Add(ctest1); } } allcontentList.Add(firstsheet); allContent secondsheet = new allContent(); secondsheet.sheetName = "BGA简称" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-'); secondsheet.titleList = new List <string>(); secondsheet.contentList = new List <object>(); secondsheet.titleList.Add("BGA类型"); secondsheet.titleList.Add("剩余数量"); secondsheet.titleList.Add("购买数量"); secondsheet.titleList.Add("出货数量"); secondsheet.titleList.Add("报废转卖"); secondsheet.titleList.Add("描述"); secondsheet.titleList.Add("相关mpn"); foreach (string key in bgabriefdict.Keys) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); bgaTypeStatistics stockcheck = bgabriefdict[key]; ct1.Add(stockcheck.bga_brief); ct1.Add(stockcheck.leftnumber); ct1.Add(stockcheck.buynumber); ct1.Add(stockcheck.outnumber); ct1.Add(stockcheck.othernumber); ct1.Add(stockcheck.describe); ct1.Add(stockcheck.releatedMpn); ctest1.contentArray = ct1; secondsheet.contentList.Add(ctest1); } allcontentList.Add(secondsheet); Utils.createMulitSheetsUsingNPOI(string.Format("{0}平衡表信息导出{1}-{2}", this.houseComboBox.Text, startTime.Replace('/', '-'), endTime.Replace('/', '-')) + ".xls", allcontentList); }