private static void padding_EightCore(Maticsoft.BLL.Report.ImportEventArgs e, Excel.Application xlApp) { Maticsoft.BLL.Pack_Exfo _M_PackExfo = new Pack_Exfo(); SerialNumber _M_SerialNumber = new SerialNumber(); ArrayList _SN_Data = _M_SerialNumber.Get_SN_List(" BatchNo = '" + e.BatchNo.BatchNo + "' AND State = 'Yet_Pack'"); int temcount = 0; int _exRow = 5; foreach (string _SN in _SN_Data) { xlApp.Cells[_exRow, 1] = _SN; // 1 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-1" + "' AND (Wave = '1550nm')"), _exRow, 3); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-2" + "' AND (Wave = '1550nm')"), _exRow, 5); // 2 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-3" + "' AND (Wave = '1550nm')"), _exRow, 7); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-4" + "' AND (Wave = '1550nm')"), _exRow, 9); // 3 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-5" + "' AND (Wave = '1550nm')"), _exRow, 11); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-6" + "' AND (Wave = '1550nm')"), _exRow, 13); // 4 PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-7" + "' AND (Wave = '1550nm')"), _exRow, 15); PaddingEightCore(xlApp, _M_PackExfo.GetList("SN = '" + _SN + "-8" + "' AND (Wave = '1550nm')"), _exRow, 17); temcount++; _exRow++; e.StatUpProgressBar(0, _SN_Data.Count, temcount); } }
/// <summary> /// 配组-8芯 /// </summary> /// <param name="e"></param> public void peizu(Maticsoft.BLL.Report.ImportEventArgs e) { try { //从模板拷贝数据 string _OrignFile, _NewFile; _OrignFile = "D:\\模板\\ReportTemplates\\" + e.Template; _NewFile = e.SavePath + "_3D.xls"; File.Delete(_NewFile); File.Copy(_OrignFile, _NewFile); //将数据填充到模板 Excel.Application xlApp = new Excel.Application(); if (xlApp == null) { MessageBox.Show("Can’t open Excel!"); return; } xlApp.Workbooks._Open(_NewFile); Excel._Worksheet oSheet = (Excel._Worksheet)xlApp.Sheets.get_Item(1); padding_putu(e, xlApp); //填充完成后的操作 xlApp.DisplayAlerts = false; //设置禁止弹出保存和覆盖的询问提示框 xlApp.AlertBeforeOverwriting = false; xlApp.SaveWorkspace(); //保存工作簿 xlApp.Quit(); //确保Excel进程关闭 xlApp = null; GC.Collect(); //如果不使用这条语句会导致excel进程无法正常退出,使用后正常退出 My_MessageBox.My_MessageBox_Message("导出完成!"); } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 装箱报告导出 /// </summary> /// <param name="e"></param> public void Encasement(Maticsoft.BLL.Report.ImportEventArgs e) { try { //从模板拷贝数据 string _OrignFile, _NewFile; _OrignFile = "D:\\模板\\ReportTemplates\\" + e.Template; _NewFile = e.SavePath + e.Template; File.Delete(_NewFile); File.Copy(_OrignFile, _NewFile); //将数据填充到模板 Excel.Application xlApp = new Excel.Application(); if (xlApp == null) { MessageBox.Show("Can’t open Excel!"); return; } xlApp.Workbooks._Open(_NewFile); Excel._Worksheet oSheet = (Excel._Worksheet)xlApp.Sheets.get_Item(1); //开始填充数据 DataSet temdata = e.ImportData; int rowIndex = 1; int colIndex = 0; //填充数据 foreach (DataRow row in temdata.Tables[0].Rows) { rowIndex++; colIndex = 0; foreach (DataColumn col in temdata.Tables[0].Columns) { colIndex++; xlApp.Cells[rowIndex, colIndex] = row[col.ColumnName]; } e.StatUpProgressBar(0, temdata.Tables[0].Rows.Count, rowIndex - 1); } //填充完成后的操作 xlApp.DisplayAlerts = false; //设置禁止弹出保存和覆盖的询问提示框 xlApp.AlertBeforeOverwriting = false; xlApp.SaveWorkspace(); //保存工作簿 xlApp.Quit(); //确保Excel进程关闭 xlApp = null; GC.Collect(); //如果不使用这条语句会导致excel进程无法正常退出,使用后正常退出 My_MessageBox.My_MessageBox_Message("导出完成!"); } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 4芯数据导出 /// </summary> private static void padding_fourCore(Maticsoft.BLL.Report.ImportEventArgs e, Excel.Application xlApp) { //开始填充数据 ArrayList _SN_Data = e.SN_DataList; int rowIndex = 7; int maxcount = e.SN_DataList.Count; foreach (DataSet temds in _SN_Data) { rowIndex++; //colIndex = 1; //填充数据 foreach (DataRow row in temds.Tables[0].Rows) { string PigtailNum = row["Name"].ToString(); switch (PigtailNum) { case "1": { xlApp.Cells[rowIndex, 2] = row["SN"]; xlApp.Cells[rowIndex, 3] = row["IL_A"]; xlApp.Cells[rowIndex, 4] = row["Refl_A"]; break; } case "2": { xlApp.Cells[rowIndex, 5] = row["IL_A"]; xlApp.Cells[rowIndex, 6] = row["Refl_A"]; break; } case "3": { xlApp.Cells[rowIndex, 7] = row["IL_A"]; xlApp.Cells[rowIndex, 8] = row["Refl_A"]; break; } case "4": { xlApp.Cells[rowIndex, 9] = row["IL_A"]; xlApp.Cells[rowIndex, 10] = row["Refl_A"]; break; } } e.StatUpProgressBar(0, maxcount, rowIndex - 7); } } }
/// <summary> /// 普通填充 /// </summary> private static void padding_putu(Maticsoft.BLL.Report.ImportEventArgs e, Excel.Application xlApp) { //开始填充数据 DataSet temdata = e.ImportData; int rowIndex = 7; int colIndex = 0; //填充数据 foreach (DataRow row in temdata.Tables[0].Rows) { rowIndex++; colIndex = 0; foreach (DataColumn col in temdata.Tables[0].Columns) { colIndex++; xlApp.Cells[rowIndex, colIndex] = row[col.ColumnName]; } e.StatUpProgressBar(0, temdata.Tables[0].Rows.Count, rowIndex - 1); } }