private void Op1Combobox_SelectedIndexChanged(object sender, EventArgs e) { MEPanel.Rows.Clear(); TEPanel.Rows.Clear(); FixInsPanel.Rows.Clear(); Op2Text.Text = ((Com_PartOperation)Op1Combobox.SelectedItem).sysOperation2.operation2Name; //從資料庫中取得有關ME的表單資料 status = GetDataFromDatabase.SetMEPanelData(((Com_PartOperation)Op1Combobox.SelectedItem), CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text, ref MEPanel); if (!status) { MessageBox.Show("SetMEExcelData資料取得失敗,請聯繫開發工程師"); this.Close(); } //從資料庫中取得有關TE的表單資料 status = GetDataFromDatabase.SetTEPanelData(((Com_PartOperation)Op1Combobox.SelectedItem), CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text, ref TEPanel); if (!status) { MessageBox.Show("SetTEExcelData資料取得失敗,請聯繫開發工程師"); this.Close(); } //從資料庫中取得有關FixIns的表單資料 status = GetDataFromDatabase.SetFixInsPanelData(((Com_PartOperation)Op1Combobox.SelectedItem), CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, Op1Combobox.Text, ref FixInsPanel); if (!status) { MessageBox.Show("SetFixInsPanelData資料取得失敗,請聯繫開發工程師"); this.Close(); } }
private void CusVerCombobox_SelectedIndexChanged(object sender, EventArgs e) { //MessageBox.Show(((Com_PEMain)CusVerCombobox.SelectedItem).peSrNo.ToString()); OpVerCombobox.Enabled = true; Op1Combobox.Enabled = false; OpVerCombobox.Items.Clear(); Op1Combobox.Items.Clear(); Op2Text.Text = ""; OpVerCombobox.Text = ""; Op1Combobox.Text = ""; PEPanel.Rows.Clear(); MEPanel.Rows.Clear(); TEPanel.Rows.Clear(); CPPanel.Rows.Clear(); FixInsPanel.Rows.Clear(); status = GetDataFromDatabase.SetOpVerData(((Sys_Customer)CusComboBox.SelectedItem), PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox); if (!status) { MessageBox.Show("製程資料取得失敗,請聯繫開發工程師"); this.Close(); } if (OpVerCombobox.Items.Count == 1) { OpVerCombobox.Text = OpVerCombobox.Items[0].ToString(); } }
private void CusComboBox_SelectedIndexChanged(object sender, EventArgs e) { PartNoCombobox.Enabled = true; CusVerCombobox.Enabled = false; OpVerCombobox.Enabled = false; Op1Combobox.Enabled = false; PartNoCombobox.Items.Clear(); CusVerCombobox.Items.Clear(); OpVerCombobox.Items.Clear(); Op1Combobox.Items.Clear(); PartNoCombobox.Text = ""; CusVerCombobox.Text = ""; OpVerCombobox.Text = ""; Op1Combobox.Text = ""; Op2Text.Text = ""; PEPanel.Rows.Clear(); MEPanel.Rows.Clear(); TEPanel.Rows.Clear(); CPPanel.Rows.Clear(); FixInsPanel.Rows.Clear(); status = GetDataFromDatabase.SetPartNoData(((Sys_Customer)CusComboBox.SelectedItem), PartNoCombobox); if (!status) { MessageBox.Show("料號資料取得失敗,請聯繫開發工程師"); this.Close(); } }
private void GetCustomerFromDatabase() { status = GetDataFromDatabase.SetCustomerData(CusComboBox); if (!status) { MessageBox.Show("客戶資料取得失敗,請聯繫開發工程師"); this.Close(); } }
private void OpVerCombobox_SelectedIndexChanged(object sender, EventArgs e) { Op1Combobox.Enabled = true; Op1Combobox.Items.Clear(); Op1Combobox.Text = ""; Op2Text.Text = ""; PEPanel.Rows.Clear(); MEPanel.Rows.Clear(); TEPanel.Rows.Clear(); CPPanel.Rows.Clear(); FixInsPanel.Rows.Clear(); //comPEMain = session.QueryOver<Com_PEMain>() // .Where(x => x.partName == PartNoCombobox.Text) // .Where(x => x.customerVer == CusVerCombobox.Text) // .Where(x => x.opVer == OpVerCombobox.Text) // .SingleOrDefault<Com_PEMain>(); CaxSQL.GetCom_PEMain(CusComboBox.Text, PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, out comPEMain); status = GetDataFromDatabase.SetPEPanelData(comPEMain, ref PEPanel); if (!status) { MessageBox.Show("PFD資料取得失敗,請聯繫開發工程師"); this.Close(); } //status = GetDataFromDatabase.SetPEPanelData(((Sys_Customer)CusComboBox.SelectedItem), PartNoCombobox.Text, CusVerCombobox.Text, OpVerCombobox.Text, ref PEPanel); //if (!status) //{ // MessageBox.Show("PFD資料取得失敗,請聯繫開發工程師"); // this.Close(); //} status = GetDataFromDatabase.SetOp1Data(comPEMain, Op1Combobox); if (!status) { MessageBox.Show("製程資料取得失敗,請聯繫開發工程師"); this.Close(); } }
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(); }