public static void generateExcelFromList(List <xml2excelbody> StockCheckList) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); titleList.Add("SN_NO"); titleList.Add("SSN"); titleList.Add("MAC_ADDR"); titleList.Add("UUID"); titleList.Add("MB_PN"); titleList.Add("MB_VERSION"); foreach (xml2excelbody stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.SN_NO); ct1.Add(stockcheck.SSN); ct1.Add(stockcheck.MAC_ADDR); ct1.Add(stockcheck.UUID); ct1.Add(stockcheck.MB_PN); ct1.Add(stockcheck.MB_VERSION); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("XML_2_Excel相关信息" + DateTime.Now.ToString("yyyyMMddHHmmss").Replace('/', '-') + ".xlsx", titleList, contentList); }
public void generateExcelToCheck(List <OldNewStruct> StockCheckList, string startTime, string endTime) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); titleList.Add("老的8s"); titleList.Add("新的8s"); titleList.Add("输入人"); titleList.Add("输入日期"); foreach (OldNewStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.old8s); ct1.Add(stockcheck.new8s); ct1.Add(stockcheck.inputer); ct1.Add(stockcheck.inputdate); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("新老8s对应信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList); }
public static void setValue(ref Microsoft.Office.Interop.Excel.Worksheet xSheet, int column, int row, Object content) { if (content is ExportExcelContent) { ExportExcelContent temp = (ExportExcelContent)content; xSheet.Cells[column][row] = temp.contentArray[column - 1]; } }
public void generateExcelToCheck(List <CompalMonthlyDataStruct> StockCheckList, string startTime, string endTime) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); titleList.Add("No"); titleList.Add("RMACaseID"); titleList.Add("TrackNo"); titleList.Add("Region"); titleList.Add("TPR"); titleList.Add("Model"); titleList.Add("P N"); titleList.Add("PPID_IN"); titleList.Add("PPID_OUT"); titleList.Add("Return times"); titleList.Add("FAILURE DESCRIPTIONS-Customer"); titleList.Add("ERROR CODE"); titleList.Add("FAILURE DESCRIPTIONS-Compal"); titleList.Add("PART"); titleList.Add("LOCATION"); titleList.Add("CATEGORY"); titleList.Add("RepairMonth"); titleList.Add("ShippingDate"); titleList.Add("ReceivedDate"); int i = 1; foreach (CompalMonthlyDataStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); stockcheck.No = (i++) + ""; ct1.Add(stockcheck.No); ct1.Add(stockcheck.RMACaseID); ct1.Add(stockcheck.TrackNo); ct1.Add(stockcheck.Region); ct1.Add(stockcheck.TPR); ct1.Add(stockcheck.Model); ct1.Add(stockcheck.P_N); ct1.Add(stockcheck.PPID_IN); ct1.Add(stockcheck.PPID_OUT); ct1.Add(stockcheck.Return_times); ct1.Add(stockcheck.FAILURE_DESCRIPTIONS_Customer); ct1.Add(stockcheck.ERROR_CODE); ct1.Add(stockcheck.FAILURE_DESCRIPTIONS_Compal); ct1.Add(stockcheck.PART); ct1.Add(stockcheck.LOCATION); ct1.Add(stockcheck.CATEGORY); ct1.Add(Utils.modifyDataFormat(stockcheck.RepairMonth)); ct1.Add(Utils.modifyDataFormat(stockcheck.ShippingDate)); ct1.Add(stockcheck.ReceivedDate); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("Compal月报表-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList); }
public void generateExcelToCheck(List <TansferSoldStruct> StockCheckList) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); titleList.Add("ID"); titleList.Add("厂商"); titleList.Add("材料类别MB/BGA/FRU/SMT"); titleList.Add("bga类型"); titleList.Add("MPN"); titleList.Add("MB简称"); titleList.Add("简述"); titleList.Add("描述"); titleList.Add("状态"); titleList.Add("数量"); titleList.Add("出库原因"); titleList.Add("收货商名称"); titleList.Add("备注"); titleList.Add("操作人"); titleList.Add("日期"); foreach (TansferSoldStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.Id); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.material_type); ct1.Add(stockcheck.bga_type); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.other_brief); ct1.Add(stockcheck.describe); ct1.Add(stockcheck._state); ct1.Add(stockcheck.number); ct1.Add(stockcheck.out_reason); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.note); ct1.Add(stockcheck.inputer); ct1.Add(stockcheck.input_date); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("报废转卖详细" + DateTime.Now.ToString("yyyy-MM-dd") + ".xlsx", titleList, contentList); }
public void generateExcelToCheck(List <ReceiveOrderStruct> StockCheckList, string startTime, string endTime) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); //厂商 客户别 仓库别 订单编号 客户料号 MB简称 MPN DPK类型 收货数量 还货数量 欠货数量 titleList.Add("厂商"); titleList.Add("客户别"); titleList.Add("仓库别"); titleList.Add("订单编号"); titleList.Add("客户料号"); titleList.Add("MB简称"); titleList.Add("MPN"); titleList.Add("DPK类型"); titleList.Add("收货数量"); titleList.Add("还货数量"); titleList.Add("欠货数量"); titleList.Add("在途天数"); foreach (ReceiveOrderStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.storehouse); ct1.Add(stockcheck.orderno); ct1.Add(stockcheck.custom_material_no); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.dpktype); ct1.Add(stockcheck.receiveNum); ct1.Add(stockcheck.returnNum); ct1.Add(stockcheck.diffNum); ct1.Add(stockcheck.tat); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("RMA信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList); }
public void generateExcelToCheck(List <RenBaoDataStruct> StockCheckList, string startTime, string endTime) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); //厂商 客户别 仓库别 订单编号 客户料号 MB简称 MPN DPK类型 收货数量 还货数量 欠货数量 titleList.Add("Repair Site"); titleList.Add("CUSTOMER_NO"); titleList.Add("RECEVING DATE"); titleList.Add("REGION"); titleList.Add("RMA_NO"); titleList.Add("WIP_SN"); titleList.Add("MODEL_NAME"); titleList.Add("SSN"); titleList.Add("SAP_COMPAL_PN"); titleList.Add("RETURN_TIMES"); titleList.Add("KP_NO"); titleList.Add("MATERIAL_GROUP"); titleList.Add("DPS/TAG/RON_NO"); titleList.Add("CUST_PN"); titleList.Add("SHIPPING_DATE"); titleList.Add("COMPAL_WARRANTY"); titleList.Add("FINAL_STATUS"); titleList.Add("DISPOSITION"); titleList.Add("DUTY"); titleList.Add("CCD_DECISION"); titleList.Add("Dell market model"); titleList.Add("客户故障"); titleList.Add("MB生产日期"); titleList.Add("退货原因"); titleList.Add("维修换件汇总"); foreach (RenBaoDataStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.repair_site); ct1.Add(stockcheck.customer_no); ct1.Add(stockcheck.receive_date != null ? stockcheck.receive_date.Replace("0:00:00", "").Trim():""); ct1.Add(stockcheck.region); ct1.Add(stockcheck.rma_no); ct1.Add(stockcheck.wip_sn); ct1.Add(stockcheck.model_name); ct1.Add(stockcheck.ssn); ct1.Add(stockcheck.sap_compal_pn); ct1.Add(stockcheck.return_times); ct1.Add(stockcheck.kp_no); ct1.Add(stockcheck.material_group); ct1.Add(stockcheck.dps_tag_ron_no); ct1.Add(stockcheck.cust_pn); ct1.Add(stockcheck.shipping_date != null ? stockcheck.shipping_date.Replace("0:00:00", "").Trim():""); ct1.Add(stockcheck.compal_warranty); ct1.Add(stockcheck.final_status); ct1.Add(stockcheck.disposition); ct1.Add(stockcheck.duty); ct1.Add(stockcheck.ccd_decision); ct1.Add(stockcheck.dell_market_model); ct1.Add(stockcheck.customer_fault); ct1.Add(stockcheck.mb_make_date != null ? stockcheck.mb_make_date.Replace("0:00:00", "").Trim():""); ct1.Add(stockcheck.return_reason); ct1.Add(stockcheck.repair_recodes); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("仁宝大数据1-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList); }
public void generateExcelToCheck2(List <RenBaoDataStruct> StockCheckList, string startTime, string endTime) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); //厂商 客户别 仓库别 订单编号 客户料号 MB简称 MPN DPK类型 收货数量 还货数量 欠货数量 titleList.Add("RMA_NO"); titleList.Add("SSN"); titleList.Add("RECV_MB_VERSION"); titleList.Add("REAL_DATE_CODE"); titleList.Add("TEST_TIME"); titleList.Add("REPAIR TIME"); titleList.Add("STATION"); titleList.Add("Error code"); titleList.Add("ERROR DESC"); titleList.Add("Location"); titleList.Add("Action_code"); titleList.Add("Action_desc"); titleList.Add("Reason CODE"); titleList.Add("Reason desc"); titleList.Add("Customer FAILURE_SYMPTOM"); foreach (RenBaoDataStruct stockcheck in StockCheckList) { if (stockcheck.final_status != "Scrap" && stockcheck.repair_recodes != "") { string[] locations = stockcheck.repair_recodes.Split(':'); for (int i = 0; i < locations.Length - 1; i++) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.rma_no); ct1.Add(stockcheck.ssn); ct1.Add(stockcheck.wip_sn); if (stockcheck.mb_make_date != null) { DateTime makedate = Convert.ToDateTime(stockcheck.mb_make_date); ct1.Add("Y" + stockcheck.mb_make_date.Substring(2, 2) + Utils.GetWeekOfYear(makedate)); } else { ct1.Add("Y--no");//当拿不到makedate的时候 } DateTime receiveDate = Convert.ToDateTime(stockcheck.receive_date); ct1.Add(receiveDate.AddDays(1).ToString("yyyy-MM-dd")); ct1.Add(receiveDate.AddDays(1).ToString("yyyy-MM-dd")); ct1.Add("QC1"); //stockcheck.customer_fault string renbaocode = "", renbaodes = "";//aocodeaoDataStruct foreach (badcodescompare temp in badcodeslist) { if (temp.yimaides.Trim() == (stockcheck.customer_fault != null ?stockcheck.customer_fault.Trim():"")) { renbaocode = temp.renbaocode; renbaodes = temp.renbaodes; break; } } ct1.Add(renbaocode); ct1.Add(renbaodes); ct1.Add(locations[i]);//multi ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(""); ct1.Add(renbaodes); ctest1.contentArray = ct1; contentList.Add(ctest1); } } } Utils.createExcel("仁宝大数据2-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList); }
public void generateExcelToCheck(List <RMAAIO_ReceiveOrderStruct> StockCheckList, List <ReturnOrderStructAIO> returnOrderList, string startTime, string endTime) { List <allContent> allcontentList = new List <allContent>(); allContent sumContentAio = new allContent(); sumContentAio.sheetName = "MB 未还在途"; sumContentAio.titleList = new List <string>(); sumContentAio.contentList = new List <object>(); //厂商 客户别 仓库别 订单编号 客户料号 MB简称 MPN DPK类型 收货数量 还货数量 欠货数量 sumContentAio.titleList.Add("厂商"); sumContentAio.titleList.Add("客户别"); sumContentAio.titleList.Add("仓库别"); sumContentAio.titleList.Add("订单编号"); sumContentAio.titleList.Add("客户料号"); sumContentAio.titleList.Add("MB简称"); sumContentAio.titleList.Add("MPN"); sumContentAio.titleList.Add("DPK类型"); sumContentAio.titleList.Add("收货数量"); sumContentAio.titleList.Add("还货数量"); sumContentAio.titleList.Add("欠货数量"); sumContentAio.titleList.Add("在途天数"); sumContentAio.titleList.Add("超期原因"); sumContentAio.titleList.Add("料号"); foreach (RMAAIO_ReceiveOrderStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.storehouse); ct1.Add(stockcheck.orderno); ct1.Add(stockcheck.custom_material_no); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.dpktype); ct1.Add(stockcheck.receiveNum); ct1.Add(stockcheck.returnNum); ct1.Add(stockcheck.diffNum); ct1.Add(stockcheck.tat); ct1.Add(stockcheck.reason); ct1.Add(stockcheck.waitMaterial); ctest1.contentArray = ct1; sumContentAio.contentList.Add(ctest1); } allcontentList.Add(sumContentAio); allContent sumContentAio2 = new allContent(); sumContentAio2.sheetName = "MB TAT"; sumContentAio2.titleList = new List <string>(); sumContentAio2.contentList = new List <object>(); //sumContentAio2.titleList.Add("ID"); sumContentAio2.titleList.Add("厂商"); sumContentAio2.titleList.Add("客户别"); sumContentAio2.titleList.Add("还货文件编号"); sumContentAio2.titleList.Add("客户库别"); sumContentAio2.titleList.Add("做单时间"); sumContentAio2.titleList.Add("收货时间"); sumContentAio2.titleList.Add("还货时间"); sumContentAio2.titleList.Add("订单编号"); sumContentAio2.titleList.Add("客户料号"); sumContentAio2.titleList.Add("MB简称"); sumContentAio2.titleList.Add("DPK状态"); sumContentAio2.titleList.Add("跟踪条码"); sumContentAio2.titleList.Add("客户序号"); sumContentAio2.titleList.Add("厂商序号"); sumContentAio2.titleList.Add("厂商料号"); sumContentAio2.titleList.Add("状态"); //sumContentAio2.titleList.Add("客责类别"); //sumContentAio2.titleList.Add("客责描述"); //sumContentAio2.titleList.Add("联想维修站编号"); //sumContentAio2.titleList.Add("联想维修单编号"); sumContentAio2.titleList.Add("TAT"); foreach (ReturnOrderStructAIO stockcheck in returnOrderList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); // ct1.Add(stockcheck.Id); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.return_file_no); ct1.Add(stockcheck.storehouse); ct1.Add(stockcheck.order_make_date); ct1.Add(Utils.modifyDataFormat(stockcheck.receive_date)); ct1.Add(Utils.modifyDataFormat(stockcheck.return_date)); ct1.Add(stockcheck.orderno); ct1.Add(stockcheck.custommaterialNo); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.dpkpn); ct1.Add(stockcheck.track_serial_no); ct1.Add(stockcheck.custom_serial_no); ct1.Add(stockcheck.vendor_serail_no); ct1.Add(stockcheck.vendormaterialNo); ct1.Add(stockcheck._status); //ct1.Add(stockcheck.custom_res_type); //ct1.Add(stockcheck.response_describe); //ct1.Add(stockcheck.lenovo_maintenance_no); //ct1.Add(stockcheck.lenovo_repair_no); ct1.Add(stockcheck.tat); ctest1.contentArray = ct1; sumContentAio2.contentList.Add(ctest1); } allcontentList.Add(sumContentAio2); Utils.createMulitSheetsUsingNPOI("RMA_AIO信息" + "-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xls", allcontentList); }
public void generateExcelToCheck(List <MBMaterialStruct> StockCheckList, string startTime, string machineType) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); titleList.Add("厂商"); titleList.Add("客户别"); titleList.Add("MB简称"); titleList.Add("厂商料号"); titleList.Add("MPN"); titleList.Add("可替换MPN"); titleList.Add("客户料号"); titleList.Add("可替换客户料号"); titleList.Add("FRU料号"); titleList.Add("可替换FRU料号"); titleList.Add("MB描述");; titleList.Add("厂商PCH_MPN"); titleList.Add("PCH简述"); titleList.Add("PCH描述"); titleList.Add("厂商VGA_MPN"); titleList.Add("VGA简述"); titleList.Add("VGA描述");; titleList.Add("厂商CPU_MPN"); titleList.Add("CPU简述"); titleList.Add("CPU描述"); titleList.Add("DPK类型"); titleList.Add("DPKPN"); titleList.Add("保修期");; titleList.Add("客户机型"); titleList.Add("整机出货量"); titleList.Add("地区"); titleList.Add("状态"); titleList.Add("CPU型号"); titleList.Add("CPU频率"); titleList.Add("ECO"); titleList.Add("EOL"); titleList.Add("添加日期"); titleList.Add("添加人"); foreach (MBMaterialStruct 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.vendormaterialNo); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.replace_mpn); ct1.Add(stockcheck.custommaterialNo); ct1.Add(stockcheck.replace_custom_materialNo); ct1.Add(stockcheck.fruNo); ct1.Add(stockcheck.replace_fruNo); 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.dpkpn); ct1.Add(stockcheck.warranty_period); ct1.Add(stockcheck.custom_machine_type); ct1.Add(stockcheck.whole_machine_num); ct1.Add(stockcheck.area); ct1.Add(stockcheck._status); ct1.Add(stockcheck.cpu_type); ct1.Add(stockcheck.cpu_freq); ct1.Add(stockcheck.eco); ct1.Add(stockcheck.eol); ct1.Add(stockcheck.adddate); ct1.Add(stockcheck.inputuser); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("MB物料对照表" + machineType + ".xlsx", titleList, contentList); }
public void generateExcelToCheck(List <HefeiDataStruct> StockCheckList, string startTime, string endTime) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); titleList.Add("还货跟踪条码"); titleList.Add("REPAIR_CENTER"); titleList.Add("RMA_NO"); titleList.Add("PRODUCT"); titleList.Add("PRODUCT_SN"); titleList.Add("SHIPPING_SN"); titleList.Add("LCFC_PN"); titleList.Add("OS_VERSION"); titleList.Add("LNV_FRU_PN"); titleList.Add("LNV_MODEL_NAME"); titleList.Add("LNV_SERIES"); titleList.Add("PRODUCT_GROUP"); titleList.Add("LCFC_MODEL_NAME"); titleList.Add("PRODUCT_DAY_CODE"); titleList.Add("RETURN_AREA"); titleList.Add("SERVICE_REQUESTER"); titleList.Add("WARRANTY_PERIOD"); titleList.Add("REQUEST_DATE"); titleList.Add("APPROVAL_DATE"); titleList.Add("SHIP_BACK_DATE"); titleList.Add("SVC_RECEIVE_DATE"); titleList.Add("SERVICE_TYPE"); titleList.Add("INCOMING_INSPECTION"); titleList.Add("LINE_INPUT_DATE"); titleList.Add("REPAIR_START_DATE"); titleList.Add("FINAL_TEST_DATE"); titleList.Add("WH_TAKEIN_DATE"); titleList.Add("PACKING_DATE"); titleList.Add("DELIVERY_DATE"); titleList.Add("CLOSE_DATE"); titleList.Add("NORMAL_SYMPTOM"); for (int i = 1; i <= 5; i++) { titleList.Add("REPAIR" + i + "_LOCATION"); titleList.Add("REPAIR" + i + "_ACTION"); titleList.Add("REPAIR" + i + "_PARTS"); titleList.Add("REPAIR" + i + "_USED_MATERIAL_CODE"); titleList.Add("REPAIR" + i + "_USED_MATERIAL_QTY"); titleList.Add("REPAIR" + i + "_RESULT"); titleList.Add("REPAIR" + i + "_RESPONSIBILITY"); } titleList.Add("REPAIR_RESULT"); titleList.Add("REPAIR_RESPONSIBILITY"); titleList.Add("Q_A_Result"); titleList.Add("DELIVERY"); titleList.Add("RMA_STATUS"); titleList.Add("TAT"); titleList.Add("TAT_TARGET"); titleList.Add("TAT_HIT"); titleList.Add("RRR_90"); foreach (HefeiDataStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.tracker_no_receive); ct1.Add(stockcheck.REPAIR_CENTER); ct1.Add(stockcheck.RMA_NO); ct1.Add(stockcheck.PRODUCT); ct1.Add(stockcheck.PRODUCT_SN); ct1.Add(stockcheck.SHIPPING_SN); ct1.Add(stockcheck.LCFC_PN); ct1.Add(stockcheck.OS_VERSION); ct1.Add(stockcheck.LNV_FRU_PN); ct1.Add(stockcheck.LNV_MODEL_NAME); ct1.Add(stockcheck.LNV_SERIES); ct1.Add(stockcheck.PRODUCT_GROUP); ct1.Add(stockcheck.LCFC_MODEL_NAME); ct1.Add(stockcheck.PRODUCT_DAY_CODE != null ? stockcheck.PRODUCT_DAY_CODE.Substring(0, stockcheck.PRODUCT_DAY_CODE.IndexOf(" ")).Trim():""); ct1.Add(stockcheck.RETURN_AREA); ct1.Add(stockcheck.SERVICE_REQUESTER); ct1.Add(stockcheck.WARRANTY_PERIOD); ct1.Add(stockcheck.REQUEST_DATE); ct1.Add(stockcheck.APPROVAL_DATE); ct1.Add(stockcheck.SHIP_BACK_DATE != null ? stockcheck.SHIP_BACK_DATE.Substring(0, stockcheck.SHIP_BACK_DATE.IndexOf(" ")).Trim() : ""); ct1.Add(stockcheck.SVC_RECEIVE_DATE != null ? stockcheck.SVC_RECEIVE_DATE.Substring(0, stockcheck.SVC_RECEIVE_DATE.IndexOf(" ")).Trim() : ""); ct1.Add(stockcheck.SERVICE_TYPE); ct1.Add(stockcheck.INCOMING_INSPECTION); ct1.Add(stockcheck.LINE_INPUT_DATE != null ? stockcheck.LINE_INPUT_DATE.Substring(0, stockcheck.LINE_INPUT_DATE.IndexOf(" ")).Trim() : ""); ct1.Add(stockcheck.REPAIR_START_DATE != null ? stockcheck.REPAIR_START_DATE.Substring(0, stockcheck.REPAIR_START_DATE.IndexOf(" ")).Trim() : ""); ct1.Add((stockcheck.FINAL_TEST_DATE != null && stockcheck.FINAL_TEST_DATE != "") ? stockcheck.FINAL_TEST_DATE.Substring(0, stockcheck.FINAL_TEST_DATE.IndexOf(" ")).Trim() : ""); ct1.Add((stockcheck.WH_TAKEIN_DATE != null && stockcheck.WH_TAKEIN_DATE != "") ? stockcheck.WH_TAKEIN_DATE.Substring(0, stockcheck.WH_TAKEIN_DATE.IndexOf(" ")).Trim() : ""); ct1.Add((stockcheck.PACKING_DATE != null && stockcheck.PACKING_DATE != "") ? stockcheck.PACKING_DATE.Substring(0, stockcheck.PACKING_DATE.IndexOf(" ")).Trim() : ""); ct1.Add((stockcheck.DELIVERY_DATE != null && stockcheck.DELIVERY_DATE != "") ? stockcheck.DELIVERY_DATE.Substring(0, stockcheck.DELIVERY_DATE.IndexOf(" ")).Trim() : ""); ct1.Add((stockcheck.CLOSE_DATE != null && stockcheck.CLOSE_DATE != "") ? stockcheck.CLOSE_DATE.Substring(0, stockcheck.CLOSE_DATE.IndexOf(" ")).Trim() : ""); ct1.Add(stockcheck.NORMAL_SYMPTOM); for (int i = 0; i < 5; i++)//至少包括5个数据,前面已经补齐 { ct1.Add(stockcheck.repairDetailList[i].REPAIR1_LOCATION); ct1.Add(stockcheck.repairDetailList[i].REPAIR1_ACTION); ct1.Add(stockcheck.repairDetailList[i].REPAIR1_PARTS); ct1.Add(stockcheck.repairDetailList[i].REPAIR1_USED_MATERIAL_CODE); ct1.Add(stockcheck.repairDetailList[i].REPAIR1_USED_MATERIAL_QTY); ct1.Add(stockcheck.repairDetailList[i].REPAIR1_RESULT); ct1.Add(stockcheck.repairDetailList[i].REPAIR1_RESPONSIBILITY); } ct1.Add(stockcheck.REPAIR_RESULT); ct1.Add(stockcheck.REPAIR_RESPONSIBILITY); ct1.Add(stockcheck.Q_A_Result); ct1.Add(stockcheck.DELIVERY); ct1.Add(stockcheck.RMA_STATUS); ct1.Add(stockcheck.TAT); ct1.Add(stockcheck.TAT_TARGET); ct1.Add(stockcheck.TAT_HIT); ct1.Add(stockcheck.RRR_90); ctest1.contentArray = ct1; contentList.Add(ctest1); } Utils.createExcel("合肥报表-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList); }
private void jiaochaquery_Click(object sender, EventArgs e) { if (mb_briefTextBox.Text.Trim() == "" && this.material_mpnTextBox.Text.Trim() == "" && this.material_describeTextBox.Text.Trim() != "") { MessageBox.Show("输入的内容为空,不能导出"); return; } List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); string querycolumnmb_brief = "", quereyContentmb_brief = ""; if (this.mb_briefTextBox.Text.Trim() != "") { querycolumnmb_brief = "mb_brief"; quereyContentmb_brief = this.mb_briefTextBox.Text.Trim(); } string querycolumnmaterial_mpn = "", quereyContentmaterial_mpn = ""; if (this.material_mpnTextBox.Text.Trim() != "") { querycolumnmaterial_mpn = "material_mpn"; quereyContentmaterial_mpn = this.material_mpnTextBox.Text.Trim(); } string querycolumnmaterial_describe = "", quereyContentmaterial_describe = ""; if (this.material_describeTextBox.Text.Trim() != "") { querycolumnmaterial_describe = "material_describe"; quereyContentmaterial_describe = this.material_describeTextBox.Text.Trim(); } string sqlCmd = "select * from LCFC_MBBOM_table "; if (querycolumnmb_brief != "") { if (sqlCmd.Contains("where")) { sqlCmd += " and " + querycolumnmb_brief + " like '%" + quereyContentmb_brief + "%'"; } else { sqlCmd += " where " + querycolumnmb_brief + " like '%" + quereyContentmb_brief + "%'"; } } if (querycolumnmaterial_mpn != "") { if (sqlCmd.Contains("where")) { sqlCmd += " and " + querycolumnmaterial_mpn + " like '%" + quereyContentmaterial_mpn + "%'"; } else { sqlCmd += " where " + querycolumnmaterial_mpn + " like '%" + quereyContentmaterial_mpn + "%'"; } } if (querycolumnmaterial_describe != "") { if (sqlCmd.Contains("where")) { sqlCmd += " and " + querycolumnmaterial_describe + " like '%" + quereyContentmaterial_describe + "%'"; } else { sqlCmd += " where " + querycolumnmaterial_describe + " like '%" + quereyContentmaterial_describe + "%'"; } } titleList.Add("ID"); titleList.Add("日期"); titleList.Add("厂商"); titleList.Add("客户别"); titleList.Add("MB简称"); titleList.Add("MPN"); titleList.Add("材料MPN"); titleList.Add("料盒位置"); titleList.Add("物料描述"); titleList.Add("用料数量"); titleList.Add("L1"); titleList.Add("L2"); titleList.Add("L3"); titleList.Add("L4"); titleList.Add("L5"); titleList.Add("L6"); titleList.Add("L7"); titleList.Add("L8"); try { List <Lcfc_mbbom> mbbomlist = new List <Lcfc_mbbom>(); SqlConnection conn = new SqlConnection(Constlist.ConStr); conn.Open(); if (conn.State == ConnectionState.Open) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = sqlCmd; SqlDataReader querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { Lcfc_mbbom lcfc = new Lcfc_mbbom(); lcfc.id = querySdr[0].ToString(); lcfc.date = querySdr[1].ToString(); lcfc.vendor = querySdr[2].ToString(); lcfc.producet = querySdr[3].ToString(); lcfc.mbbrief = querySdr[4].ToString(); lcfc.mpn = querySdr[5].ToString(); lcfc.materialmpn = querySdr[6].ToString(); lcfc.place = querySdr[7].ToString();; lcfc.describe = querySdr[8].ToString();; lcfc.num = querySdr[9].ToString(); lcfc.l1 = querySdr[10].ToString(); lcfc.l2 = querySdr[11].ToString(); lcfc.l3 = querySdr[12].ToString(); lcfc.l4 = querySdr[13].ToString(); lcfc.l5 = querySdr[14].ToString(); lcfc.l6 = querySdr[15].ToString(); lcfc.l7 = querySdr[16].ToString(); lcfc.l8 = querySdr[17].ToString(); mbbomlist.Add(lcfc); } querySdr.Close(); foreach (Lcfc_mbbom bom in mbbomlist) { cmd.CommandText = "select Id from LCFC_MBBOM_table where vendor='" + bom.vendor + "' and material_mpn='" + bom.materialmpn + "'"; querySdr = cmd.ExecuteReader(); if (querySdr.HasRows == false) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(bom.id); ct1.Add(bom.date); ct1.Add(bom.vendor); ct1.Add(bom.producet); ct1.Add(bom.mbbrief); ct1.Add(bom.mpn); ct1.Add(bom.materialmpn); ct1.Add(bom.place); ct1.Add(bom.describe); ct1.Add(bom.num); ct1.Add(bom.l1); ct1.Add(bom.l2); ct1.Add(bom.l3); ct1.Add(bom.l4); ct1.Add(bom.l5); ct1.Add(bom.l6); ct1.Add(bom.l7); ct1.Add(bom.l8); ctest1.contentArray = ct1; contentList.Add(ctest1); } querySdr.Close(); } } else { MessageBox.Show("SaledService is not opened"); } conn.Close(); Utils.createExcel("在LCFC_MBBOM交叉查询不存在的料号" + DateTime.Now.ToString("yyyy-MM-dd").Replace('/', '-') + ".xlsx", titleList, contentList); this.Cursor = Cursors.Default; } catch (Exception ex) { this.Cursor = Cursors.Default; MessageBox.Show(ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { List <string> titleList = new List <string>(); List <Object> contentList = new List <object>(); string querycolumnmb_brief = "", quereyContentmb_brief = ""; if (this.mb_briefTextBox.Text.Trim() != "") { querycolumnmb_brief = "mb_brief"; quereyContentmb_brief = this.mb_briefTextBox.Text.Trim(); } string querycolumnmaterial_mpn = "", quereyContentmaterial_mpn = ""; if (this.material_mpnTextBox.Text.Trim() != "") { querycolumnmaterial_mpn = "material_mpn"; quereyContentmaterial_mpn = this.material_mpnTextBox.Text.Trim(); } string querycolumnmaterial_describe = "", quereyContentmaterial_describe = ""; if (this.material_describeTextBox.Text.Trim() != "") { querycolumnmaterial_describe = "material_describe"; quereyContentmaterial_describe = this.material_describeTextBox.Text.Trim(); } string sqlCmd = "select * from LCFC_MBBOM_table "; if (querycolumnmb_brief != "") { if (sqlCmd.Contains("where")) { sqlCmd += " and " + querycolumnmb_brief + " like '%" + quereyContentmb_brief + "%'"; } else { sqlCmd += " where " + querycolumnmb_brief + " like '%" + quereyContentmb_brief + "%'"; } } if (querycolumnmaterial_mpn != "") { if (sqlCmd.Contains("where")) { sqlCmd += " and " + querycolumnmaterial_mpn + " like '%" + quereyContentmaterial_mpn + "%'"; } else { sqlCmd += " where " + querycolumnmaterial_mpn + " like '%" + quereyContentmaterial_mpn + "%'"; } } if (querycolumnmaterial_describe != "") { if (sqlCmd.Contains("where")) { sqlCmd += " and " + querycolumnmaterial_describe + " like '%" + quereyContentmaterial_describe + "%'"; } else { sqlCmd += " where " + querycolumnmaterial_describe + " like '%" + quereyContentmaterial_describe + "%'"; } } titleList.Add("ID"); titleList.Add("日期"); titleList.Add("厂商"); titleList.Add("客户别"); titleList.Add("MB简称"); titleList.Add("MPN"); titleList.Add("材料MPN"); titleList.Add("料盒位置"); titleList.Add("物料描述"); titleList.Add("用料数量"); titleList.Add("L1"); titleList.Add("L2"); titleList.Add("L3"); titleList.Add("L4"); titleList.Add("L5"); titleList.Add("L6"); titleList.Add("L7"); titleList.Add("L8"); try { SqlConnection conn = new SqlConnection(Constlist.ConStr); conn.Open(); if (conn.State == ConnectionState.Open) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = sqlCmd; SqlDataReader querySdr = cmd.ExecuteReader(); while (querySdr.Read()) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(querySdr[0].ToString()); ct1.Add(querySdr[1].ToString()); ct1.Add(querySdr[2].ToString()); ct1.Add(querySdr[3].ToString()); ct1.Add(querySdr[4].ToString()); ct1.Add(querySdr[5].ToString()); ct1.Add(querySdr[6].ToString()); ct1.Add(querySdr[7].ToString()); ct1.Add(querySdr[8].ToString()); ct1.Add(querySdr[9].ToString()); ct1.Add(querySdr[10].ToString()); ct1.Add(querySdr[11].ToString()); ct1.Add(querySdr[12].ToString()); ct1.Add(querySdr[13].ToString()); ct1.Add(querySdr[14].ToString()); ct1.Add(querySdr[15].ToString()); ct1.Add(querySdr[16].ToString()); ct1.Add(querySdr[17].ToString()); ctest1.contentArray = ct1; contentList.Add(ctest1); } querySdr.Close(); } else { MessageBox.Show("SaledService is not opened"); } conn.Close(); Utils.createExcel("LCFC_MBBOM" + DateTime.Now.ToString("yyyy-MM-dd").Replace('/', '-') + ".xlsx", titleList, contentList); this.Cursor = Cursors.Default; } catch (Exception ex) { this.Cursor = Cursors.Default; MessageBox.Show(ex.ToString()); } }
public void generateExcelToCheck(List <FruQianHuoStruct> StockCheckList, List <FruReturnStruct> returnOrderListfru, List <RMAAIO_ReceiveOrderStruct> receiveOrderListTarget, List <ReturnOrderStructLBG> returnOrderList, string startTime, string endTime) { List <allContent> allcontentList = new List <allContent>(); allContent sumContentAio = new allContent(); sumContentAio.sheetName = "FRU未还在途"; sumContentAio.titleList = new List <string>(); sumContentAio.contentList = new List <object>(); //厂商 客户别 仓库别 订单编号 客户料号 MB简称 MPN DPK类型 收货数量 还货数量 欠货数量 //sumContentAio.titleList.Add("厂商"); //sumContentAio.titleList.Add("客户别"); //sumContentAio.titleList.Add("仓库别"); sumContentAio.titleList.Add("订单编号"); sumContentAio.titleList.Add("客户料号"); sumContentAio.titleList.Add("描述"); sumContentAio.titleList.Add("MB简称"); sumContentAio.titleList.Add("收货数量"); sumContentAio.titleList.Add("还货数量"); sumContentAio.titleList.Add("欠货数量"); sumContentAio.titleList.Add("在途天数"); foreach (FruQianHuoStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); //ct1.Add(stockcheck.vendor); //ct1.Add(stockcheck.product); //ct1.Add(stockcheck.storehouse); ct1.Add(stockcheck.orderno); ct1.Add(stockcheck.custom_material_no); ct1.Add(stockcheck.mpn);//此处mpn用做描述字段存储 ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.receiveNum); ct1.Add(stockcheck.returnNum); ct1.Add(stockcheck.diffNum); ct1.Add(stockcheck.tat); ctest1.contentArray = ct1; sumContentAio.contentList.Add(ctest1); } allcontentList.Add(sumContentAio); allContent sumContentAio2 = new allContent(); sumContentAio2.sheetName = "FRU TAT"; sumContentAio2.titleList = new List <string>(); sumContentAio2.contentList = new List <object>(); sumContentAio2.titleList.Add("订单编号"); //sumContentAio2.titleList.Add("厂商"); //sumContentAio2.titleList.Add("客户别"); sumContentAio2.titleList.Add("客户料号"); sumContentAio2.titleList.Add("机型"); sumContentAio2.titleList.Add("名称"); //sumContentAio2.titleList.Add("客户物料描述"); sumContentAio2.titleList.Add("配件序号"); //sumContentAio2.titleList.Add("客户序号"); //sumContentAio2.titleList.Add("客户故障"); //sumContentAio2.titleList.Add("生产日期"); //sumContentAio2.titleList.Add("保内/保外"); //sumContentAio2.titleList.Add("保外备注"); //sumContentAio2.titleList.Add("厂商料号"); //sumContentAio2.titleList.Add("MPN1"); //sumContentAio2.titleList.Add("还货人"); sumContentAio2.titleList.Add("收货日期"); sumContentAio2.titleList.Add("还货日期"); sumContentAio2.titleList.Add("TAT"); sumContentAio2.titleList.Add("状态"); foreach (FruReturnStruct stockcheck in returnOrderListfru) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.orderno); //ct1.Add(stockcheck.vendor); //ct1.Add(stockcheck.product); ct1.Add(stockcheck.customermaterialno); ct1.Add(stockcheck.machine_type); ct1.Add(stockcheck.name); //ct1.Add(stockcheck.customermaterialdes); ct1.Add(stockcheck.peijian_no); //ct1.Add(stockcheck.customer_serial_no); //ct1.Add(stockcheck.custom_fault); //ct1.Add(stockcheck.make_date); //ct1.Add(stockcheck.gurantee); //ct1.Add(stockcheck.gurantee_note); //ct1.Add(stockcheck.vendor_material_no); //ct1.Add(stockcheck.mpn1); //ct1.Add(stockcheck.receiver); ct1.Add(Utils.modifyDataFormat(stockcheck.make_date));//用来装载收货日期 ct1.Add(Utils.modifyDataFormat(stockcheck.receive_date)); ct1.Add(stockcheck.tat); ct1.Add(stockcheck._status); ctest1.contentArray = ct1; sumContentAio2.contentList.Add(ctest1); } allcontentList.Add(sumContentAio2); allContent sumContentAio3 = new allContent(); sumContentAio3.sheetName = "MB 未还在途"; sumContentAio3.titleList = new List <string>(); sumContentAio3.contentList = new List <object>(); //厂商 客户别 仓库别 订单编号 客户料号 MB简称 MPN DPK类型 收货数量 还货数量 欠货数量 sumContentAio3.titleList.Add("厂商"); sumContentAio3.titleList.Add("客户别"); sumContentAio3.titleList.Add("仓库别"); sumContentAio3.titleList.Add("订单编号"); sumContentAio3.titleList.Add("客户料号"); sumContentAio3.titleList.Add("MB简称"); sumContentAio3.titleList.Add("MPN"); sumContentAio3.titleList.Add("DPK类型"); sumContentAio3.titleList.Add("收货数量"); sumContentAio3.titleList.Add("还货数量"); sumContentAio3.titleList.Add("欠货数量"); sumContentAio3.titleList.Add("在途天数"); sumContentAio3.titleList.Add("超期原因"); sumContentAio3.titleList.Add("料号"); foreach (RMAAIO_ReceiveOrderStruct stockcheck in receiveOrderListTarget) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.storehouse); ct1.Add(stockcheck.orderno); ct1.Add(stockcheck.custom_material_no); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.mpn); ct1.Add(stockcheck.dpktype); ct1.Add(stockcheck.receiveNum); ct1.Add(stockcheck.returnNum); ct1.Add(stockcheck.diffNum); ct1.Add(stockcheck.tat); ct1.Add(stockcheck.reason); ct1.Add(stockcheck.waitMaterial); ctest1.contentArray = ct1; sumContentAio3.contentList.Add(ctest1); } allcontentList.Add(sumContentAio3); allContent sumContentAio4 = new allContent(); sumContentAio4.sheetName = "MB TAT"; sumContentAio4.titleList = new List <string>(); sumContentAio4.contentList = new List <object>(); sumContentAio4.titleList.Add("厂商"); sumContentAio4.titleList.Add("客户别"); sumContentAio4.titleList.Add("还货文件编号"); sumContentAio4.titleList.Add("客户库别"); sumContentAio4.titleList.Add("做单时间"); sumContentAio4.titleList.Add("收货时间"); sumContentAio4.titleList.Add("还货时间"); sumContentAio4.titleList.Add("订单编号"); sumContentAio4.titleList.Add("客户料号"); sumContentAio4.titleList.Add("MB简称"); sumContentAio4.titleList.Add("DPK状态"); sumContentAio4.titleList.Add("跟踪条码"); sumContentAio4.titleList.Add("客户序号"); sumContentAio4.titleList.Add("厂商序号"); sumContentAio4.titleList.Add("厂商料号"); sumContentAio4.titleList.Add("TAT"); sumContentAio4.titleList.Add("超期原因"); sumContentAio4.titleList.Add("料号"); sumContentAio4.titleList.Add("状态"); foreach (ReturnOrderStructLBG stockcheck in returnOrderList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.product); ct1.Add(stockcheck.return_file_no); ct1.Add(stockcheck.storehouse); ct1.Add(stockcheck.order_make_date); ct1.Add(Utils.modifyDataFormat(stockcheck.receive_date)); ct1.Add(Utils.modifyDataFormat(stockcheck.return_date)); ct1.Add(stockcheck.orderno); ct1.Add(stockcheck.custommaterialNo); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.dpkpn); ct1.Add(stockcheck.track_serial_no); ct1.Add(stockcheck.custom_serial_no); ct1.Add(stockcheck.vendor_serail_no); ct1.Add(stockcheck.vendormaterialNo); ct1.Add(stockcheck.tat); ct1.Add(stockcheck.reason); ct1.Add(stockcheck.waitMaterial); ct1.Add(stockcheck._status); ctest1.contentArray = ct1; sumContentAio4.contentList.Add(ctest1); } allcontentList.Add(sumContentAio4); Utils.createMulitSheetsUsingNPOI("RMA_LBG信息" + "-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xls", allcontentList); }
public void generateExcelToCheck(List <lifeCycleStruct> StockCheckList, string startTime, string endTime, List <lifeCycleSumStruct> bagWaitSumList) { List <allContent> allcontentList = new List <allContent>(); allContent firstsheet = new allContent(); firstsheet.sheetName = "主板生命周期" + 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("客户料号"); firstsheet.titleList.Add("MB简称"); firstsheet.titleList.Add("MPN"); foreach (lifeCycleStruct stockcheck in StockCheckList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.trackno); ct1.Add(stockcheck.station); ct1.Add(stockcheck.tester); ct1.Add(stockcheck.inputdate); ct1.Add(stockcheck.result); ct1.Add(stockcheck.product); ct1.Add(stockcheck.vendor); ct1.Add(stockcheck.custommaterialNo); ct1.Add(stockcheck.mb_brief); ct1.Add(stockcheck.mpn); 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("站别"); secondsheet.titleList.Add("数量"); foreach (lifeCycleSumStruct stockcheck in bagWaitSumList) { ExportExcelContent ctest1 = new ExportExcelContent(); List <string> ct1 = new List <string>(); ct1.Add(stockcheck.station); ct1.Add(stockcheck.returnNum + ""); ctest1.contentArray = ct1; secondsheet.contentList.Add(ctest1); } allcontentList.Add(secondsheet); Utils.createMulitSheetsUsingNPOI("主板生命周期信息" + "-" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xls", allcontentList); }