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