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 <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 <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); }