private void OK_Click(object sender, EventArgs e) { try { Dictionary <Node, List <Node> > DicSelNodes = new Dictionary <Node, List <Node> >(); status = Fun_Common.GetSelNodes(OISTree, out DicSelNodes); if (!status) { MessageBox.Show("取得對話框資料失敗,請聯繫開發工程師"); this.Close(); } IList <Com_PFMEA> listComPFMEA = session.QueryOver <Com_PFMEA>().List(); status = Fun_Common.DeleteDataBase(listComPFMEA, DicSelNodes); if (!status) { MessageBox.Show("刪除資料庫發生錯誤,請聯繫開發工程師"); this.Close(); } string ExcelFolder = string.Format(@"{0}\{1}_{2}_{3}" , Environment.GetFolderPath(Environment.SpecialFolder.Desktop) , PartNoCombo.Text , CusRevCombo.Text , OpRevCombo.Text); //建立桌面資料夾存放產生的Excel if (!Directory.Exists(ExcelFolder)) { Directory.CreateDirectory(ExcelFolder); } status = Fun_Common.CreatePFMEA(PartNoCombo.Text, CusRevCombo.Text, OpRevCombo.Text, DicSelNodes); if (!status) { MessageBox.Show("輸出P-FMEA發生錯誤,請聯繫開發工程師"); this.Close(); } MessageBox.Show("輸出成功"); this.Close(); /* * status = GetAllNodes(out dicAllNode); * if (!status) * { * MessageBox.Show("取得對話框資料失敗,請聯繫開發工程師"); * this.Close(); * } * * IList<Com_PFMEA> listComPFMEA = session.QueryOver<Com_PFMEA>().List(); * * foreach (KeyValuePair<Node,List<DimenData>> kvp in dicAllNode) * { * foreach (DimenData i in kvp.Value) * { * //刪除舊資料 * foreach (Com_PFMEA j in listComPFMEA) * { * if (j.comDimension.dimensionSrNo == ((Com_Dimension)i.node.Tag).dimensionSrNo) * session.Delete(j); * * session.BeginTransaction().Commit(); * } * Com_PFMEA cCom_PFMEA = new Com_PFMEA(); * cCom_PFMEA.comDimension = (Com_Dimension)i.node.Tag; * cCom_PFMEA.pFMData = i.node.Cells[2].Text; * cCom_PFMEA.pEoFData = i.node.Cells[3].Text; * cCom_PFMEA.sevData = i.node.Cells[4].Text; * cCom_PFMEA.classData = i.node.Cells[5].Text; * cCom_PFMEA.pCoFData = i.node.Cells[6].Text; * cCom_PFMEA.occurrenceData = i.node.Cells[7].Text; * cCom_PFMEA.preventionData = i.node.Cells[8].Text; * cCom_PFMEA.detectionData = i.node.Cells[9].Text; * cCom_PFMEA.detData = i.node.Cells[10].Text; * cCom_PFMEA.rpnData = i.node.Cells[11].Text; * using (ITransaction trans = session.BeginTransaction()) * { * session.Save(cCom_PFMEA); * trans.Commit(); * } * } * } * this.Close(); */ } catch (System.Exception ex) { MessageBox.Show(ex.ToString()); //MessageBox.Show("取得對話框資料失敗,請聯繫開發工程師"); this.Close(); } }
private void AddBtn_Click(object sender, EventArgs e) { Fun_Common.ManualAdd(panel, Manual.Text); }