private void btn_OBOM_Execute_Click(object sender, EventArgs e) { bool DirPass = false; tbx_OBOM_Result.Text = ""; try { DirectoryInfo Dir = new DirectoryInfo(tbx_OBOMDir.Text); FileInfo[] trySourceFiles = Dir.GetFiles(); DirPass = true; } catch { tbx_OBOM_Result.Text += "Wrong Directory"; } if (DirPass) { try { DirectoryInfo Dir = new DirectoryInfo(tbx_OBOMDir.Text); FileInfo[] SourceFiles = Dir.GetFiles("*.xls"); int Sequence = 1; foreach (var t in SourceFiles) { Broadcast Test = new Broadcast(tbx_Setting_VIN.Text, tbx_Setting_Project.Text); Test.GetAttributesFromOBOM(t.FullName, Sequence); if (cbx_OBOM_ImportEBOM.Checked == true && this.tbx_Setting_EBOM.Text != "") { Test.OBOM_GetPartsFromEBOM(t.FullName, this.tbx_Setting_EBOM.Text, this.tbx_Setting_EBOMExtra.Text, this.tbx_Setting_SWTP.Text, this.tbx_Setting_SWCP_SheetName.Text, Convert.ToInt32(this.nud_Setting_SWCP_BoughtinCol.Value) - 1, Convert.ToInt32(this.nud_Setting_SWCPTopCol.Value) - 1); } Test.WriteBroadcastToFile(tbx_OBOMDir.Text); Sequence++; AddResult(t.Name + " Created", this.tbx_OBOM_Result); } AddResult("Finished", this.tbx_OBOM_Result); MessageBox.Show("Broadcast Generated"); } catch { MessageBox.Show("Generate Process Error, Please Check Settings"); } } }
private void btn_V6000_Execute_Click(object sender, EventArgs e) { List<Broadcast> V6000_Broadcast = new List<Broadcast>(); this.tbx_V6000_Result.Text=""; DataTable BOM = new DataTable(); List<string> SWCP = new List<string>(); try { if (cbx_V6000_ImportEBOM.Checked) { BOM.Columns.Add("PN"); for (int i = 0; i < Convert.ToInt32(nud_V6000_VehicleNumber.Value); i++) BOM.Columns.Add(); object missing = Missing.Value; Microsoft.Office.Interop.Excel.Application xlApp = null; Microsoft.Office.Interop.Excel.Workbook BOM_xlBook = null; Microsoft.Office.Interop.Excel.Worksheet BOM_xlSheet = null; Microsoft.Office.Interop.Excel.Workbook SWCP_xlBook = null; Microsoft.Office.Interop.Excel.Worksheet SWCP_xlSheet = null; xlApp = new Microsoft.Office.Interop.Excel.Application(); xlApp.DisplayAlerts = false; AddResult("Reading SWCP", tbx_V6000_Result); SWCP_xlBook = xlApp.Workbooks.Add(tbx_Setting_SWTP.Text); SWCP_xlSheet = SWCP_xlBook.Sheets[tbx_Setting_SWCP_SheetName.Text]; int Rows = 2; string SWCPAssy = SWCP_xlSheet.Cells[Convert.ToInt32(nud_Setting_SWCPTopCol.Value)][Rows].Value; while (SWCPAssy != null && SWCPAssy != "") { SWCP.Add(SWCPAssy); Rows++; SWCPAssy = SWCP_xlSheet.Cells[Convert.ToInt32(nud_Setting_SWCPTopCol.Value)][Rows].Value; if (Rows % 10 == 0) AddResult((Rows / 10).ToString("00"), tbx_V6000_Result); } SWCP_xlBook.Close(); AddResult("Reading BOM", tbx_V6000_Result); BOM_xlBook = xlApp.Workbooks.Add(tbx_V6000_BOM.Text); BOM_xlSheet = BOM_xlBook.Sheets[tbx_V6000_BOMSheetName.Text]; Rows = 0; string BOMAssy = BOM_xlSheet.Cells[(Convert.ToInt32(nud_V6000_BOMAssyCol.Value))][Convert.ToInt32(nud_V6000_BOMStartRow.Value) + Rows].Value; while (BOMAssy != null && BOMAssy != "") { DataRow Target = BOM.NewRow(); Target[0] = BOMAssy; for (int i = 0; i < Convert.ToInt32(nud_V6000_VehicleNumber.Value); i++) { object isFit = BOM_xlSheet.Cells[Convert.ToInt32(nud_V6000_BOMVehicleStartCol.Value) + i][ Convert.ToInt32(nud_V6000_BOMStartRow.Value) + Rows].Value; if (isFit == null) Target[i + 1] = ""; else Target[i + 1] = isFit.ToString(); } BOM.Rows.Add(Target); Rows++; BOMAssy = BOM_xlSheet.Cells[Convert.ToInt32(nud_V6000_BOMAssyCol.Value)][Convert.ToInt32(nud_V6000_BOMStartRow.Value) + Rows].Value; if (Rows % 100 == 0) AddResult((Rows / 100).ToString("0000"), tbx_V6000_Result); } BOM_xlBook.Close(); xlApp.Quit(); } for (int i = 0; i < Convert.ToInt32(nud_V6000_VehicleNumber.Value); i++) { Broadcast Target = new Broadcast(tbx_Setting_VIN.Text, tbx_Setting_Project.Text); Target.GetAttributesFromV6000(tbx_V6000_Feature.Text, i, tbx_V6000_SWCPSheetName.Text, Convert.ToInt32(nud_V6000_VINRow.Value), Convert.ToInt32(nud_V6000_OrderRow.Value), Convert.ToInt32(nud_V6000_ModelRow.Value), Convert.ToInt32(nud_V6000_FeatureCol.Value), Convert.ToInt32(nud_V6000_FamilyCol.Value), Convert.ToInt32(nud_V6000_FeatureVehicleStartCol.Value), Convert.ToInt32(nud_V6000_FeatureStartRow.Value) ); if (cbx_V6000_ImportEBOM.Checked) { /* Target.V6000_GetPartsInfo_Old(i, tbx_V6000_BOM.Text, tbx_V6000_BOMSheetName.Text, tbx_Setting_SWTP.Text, tbx_Setting_SWCP_SheetName.Text, tbx_Setting_EBOM.Text, Convert.ToInt32(nudColumnAssy.Value), Convert.ToInt32(nud_V6000_BOMAssyCol.Value), Convert.ToInt32(nud_V6000_BOMStartRow.Value), Convert.ToInt32(nud_V6000_BOMVehicleStartCol.Value) ); * */ Target.V600_GetPartsInfo(i, SWCP, BOM, tbx_Setting_EBOM.Text, tbx_Setting_EBOMExtra.Text); } Target.WriteBroadcastToFile(tbx_V6000_OutputFolder.Text); AddResult(Target.GetVIN() + " Created", tbx_V6000_Result); } AddResult("Finished", tbx_V6000_Result); MessageBox.Show("Broadcast Generated"); } catch(Exception f) { MessageBox.Show(f.ToString() + "\r\n" + "Process Failed. Please Check Settings"); } }