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