private void OpRevCombo_SelectedIndexChanged(object sender, EventArgs e) { CaxLoading.RunDlg(); OISTree.Nodes.Clear(); comPEMain = session.QueryOver <Com_PEMain>() .Where(x => x.partName == PartNoCombo.Text) .Where(x => x.customerVer == CusRevCombo.Text) .Where(x => x.opVer == OpRevCombo.Text) .SingleOrDefault <Com_PEMain>(); listComPartOperation = session.QueryOver <Com_PartOperation>().Where(x => x.comPEMain == comPEMain).List(); foreach (Com_PartOperation i in listComPartOperation) { status = cGetOISData.InitializeOISTree(i, OISTree); if (!status) { MessageBox.Show("製程資料取得失敗,請聯繫開發工程師"); CaxLoading.CloseDlg(); this.Close(); return; } } CaxLoading.CloseDlg(); }
private void OK_Click(object sender, EventArgs e) { CaxLoading.RunDlg(); string ExcelFolder = string.Format(@"{0}\{1}_{2}_{3}", Environment.GetFolderPath(Environment.SpecialFolder.Desktop), PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text); #region ME表單 if (SuperTabControl.SelectedTab.Text == "ME") { //ME_檢查是否有選取表單格式 status = CheckFun.CheckAll("ME", MEPanel); if (!status) { CaxLoading.CloseDlg(); return; } //ME_建立桌面資料夾存放產生的Excel if (!Directory.Exists(ExcelFolder)) { Directory.CreateDirectory(ExcelFolder); } foreach (GridRow i in MEPanel.Rows) { if (i.GetCell(1).Value.ToString() == "PDF" && ((bool)i.GetCell(0).Value) == true) { CopyNC.CopyOISPDFToDesktop(CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text, i.GetCell(2).Value.ToString()); } } //ME_由選取的Op1與Excel表單,查出資料庫的Com_Dimension status = GetDataFromDatabase.GetDimensionData(Op1Combobox, out DicDimensionData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("由Panel資料查DicDimensionData時發生錯誤,請聯繫開發工程師"); this.Close(); } //ME_開始輸出ME的Excel status = GetExcelForm.InsertDataToMEExcel(DicDimensionData, CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("輸出ME的Excel時發生錯誤,請聯繫開發工程師"); this.Close(); } } #endregion #region TE表單 else if (SuperTabControl.SelectedTab.Text == "TE") { //TE_檢查是否有選取表單格式 status = CheckFun.CheckAll("TE", TEPanel); if (!status) { return; } //TE_建立桌面資料夾存放產生的Excel if (!Directory.Exists(ExcelFolder)) { Directory.CreateDirectory(ExcelFolder); } foreach (GridRow i in TEPanel.Rows) { if (i.GetCell(1).Value.ToString() == "ShopDoc" && ((bool)i.GetCell(0).Value) == true) { #region ShopDoc //TE_由選取的Op1與Excel表單,查出資料庫的Com_ShopDoc status = GetDataFromDatabase.GetShopDocData(Op1Combobox, out DicShopDocData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("由Panel資料查DicShopDocData時發生錯誤,請聯繫開發工程師"); this.Close(); } //TE_開始輸出TE的ShopDoc status = GetExcelForm.InsertDataToShopDocExcel(DicShopDocData, CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("輸出TE的ShopDoc時發生錯誤,請聯繫開發工程師"); this.Close(); } #endregion } else if (i.GetCell(1).Value.ToString() == "ToolList" && ((bool)i.GetCell(0).Value) == true) { #region ToolList //TE_由選取的Op1與Excel表單,查出資料庫的Com_ToolList status = GetDataFromDatabase.GetToolListData(Op1Combobox, out DicToolListData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("由Panel資料查DicToolListData時發生錯誤,請聯繫開發工程師"); this.Close(); } //TE_開始輸出TE的ToolList status = GetExcelForm.InsertDataToTLExcel(DicToolListData, CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("輸出TE的ToolList時發生錯誤,請聯繫開發工程師"); this.Close(); } #endregion } else if (i.GetCell(1).Value.ToString() == "NC程式" && ((bool)i.GetCell(0).Value) == true) { #region NC程式 status = CopyNC.CopyNCToDesktop(CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text, i.GetCell(2).Value.ToString()); if (!status) { MessageBox.Show("下載NC資料夾時發生錯誤,請聯繫開發工程師"); this.Close(); } #endregion } } } #endregion #region PE表單 else if (SuperTabControl.SelectedTab.Text == "PE") { //PE_檢查是否有選取表單格式 status = CheckFun.CheckAll("PE", PEPanel); if (!status) { return; } //PE_建立桌面資料夾存放產生的Excel if (!Directory.Exists(ExcelFolder)) { Directory.CreateDirectory(ExcelFolder); } foreach (GridRow i in PEPanel.Rows) { if (i.GetCell(1).Value.ToString() == "PFD" && ((bool)i.GetCell(0).Value) == true) { //PE_由選取的Row查出PFD資料 status = GetDataFromDatabase.GetPFDData(comPEMain, out DicPFDData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("由Panel資料查PFD Data時發生錯誤,請聯繫開發工程師"); this.Close(); } //PE_開始輸出PFD的Excel status = GetExcelForm.InsertDataToPFDExcel(PartNoCombobox.Text, DicPFDData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("輸出PFD的Excel時發生錯誤,請聯繫開發工程師"); this.Close(); } } else if (i.GetCell(1).Value.ToString() == "Control Plan" && ((bool)i.GetCell(0).Value) == true) { //PE_由選取的Row查出Control Plan資料 status = GetDataFromDatabase.GetControlPlanData(comPEMain, out DicCPData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("由Panel資料查Control Plan Data時發生錯誤,請聯繫開發工程師"); this.Close(); } //PE_開始輸出Control Plan的Excel status = GetExcelForm.InsertDataToCPExcel(DicCPData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("輸出Control Plan的Excel時發生錯誤,請聯繫開發工程師"); this.Close(); } } } } #endregion #region 模.檢.治 else if (SuperTabControl.SelectedTab.Text == "模.檢.治") { //模.檢.治_檢查是否有選取表單格式 status = CheckFun.CheckAll("模.檢.治", FixInsPanel); if (!status) { return; } //建立桌面資料夾存放產生的Excel if (!Directory.Exists(ExcelFolder)) { Directory.CreateDirectory(ExcelFolder); } foreach (GridRow i in OutputForm.FixInsPanel.Rows) { if (i.GetCell(1).Value.ToString().Contains(".pdf") && (bool)i.GetCell(0).Value) { CopyNC.CopyFixOISPDFToDesktop(this.CusComboBox.Text, this.PartNoCombobox.Text, this.CusVerCombobox.Text, this.OpVerCombobox.Text, this.Op1Combobox.Text, i.GetCell(1).Value.ToString()); } } foreach (GridRow i in FixInsPanel.Rows) { if (((bool)i.GetCell(0).Value) != true || i.GetCell(1).Value.ToString().Contains(".pdf") /*|| i.GetCell(1).Value.ToString() == "PDF"*/) { continue; } status = GetDataFromDatabase.GetFixInsData(Op1Combobox, i.GetCell(1).Value.ToString(), out DicFixDimensionData); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("由Panel資料查DicFixDimensionData時發生錯誤"); this.Close(); } status = GetExcelForm.InsertDataToFixInsExcel(DicFixDimensionData, CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text); if (!status) { CaxLoading.CloseDlg(); MessageBox.Show("輸出模.檢.治的Excel時發生錯誤,請聯繫開發工程師"); this.Close(); } } } #endregion CaxLoading.CloseDlg(); MessageBox.Show("表單輸出完成!"); //this.Close(); }