void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target) { switch (connectionId) { case 1: #line 6 "..\..\..\CaseStudy.xaml" ((ReliefAnalysis.CaseStudy)(target)).Loaded += new System.Windows.RoutedEventHandler(this.Window_Loaded_1); #line default #line hidden #line 6 "..\..\..\CaseStudy.xaml" ((ReliefAnalysis.CaseStudy)(target)).Closing += new System.ComponentModel.CancelEventHandler(this.MetroWindow_Closing_1); #line default #line hidden return; case 2: this.mainTab = ((System.Windows.Controls.TabControl)(target)); return; case 3: this.ti0 = ((System.Windows.Controls.TabItem)(target)); return; case 4: this.txtDescription = ((System.Windows.Controls.TextBox)(target)); return; case 5: this.gridStreamIn = ((System.Windows.Controls.DataGrid)(target)); return; case 6: this.gridStreamOut = ((System.Windows.Controls.DataGrid)(target)); return; case 7: this.gridHeatIn = ((System.Windows.Controls.DataGrid)(target)); return; case 8: this.gridHeatOut = ((System.Windows.Controls.DataGrid)(target)); return; case 9: this.txtRunResult = ((System.Windows.Controls.TextBox)(target)); return; case 10: this.progressBar = ((System.Windows.Controls.ProgressBar)(target)); return; case 11: this.btnCheckData = ((System.Windows.Controls.Button)(target)); #line 80 "..\..\..\CaseStudy.xaml" this.btnCheckData.Click += new System.Windows.RoutedEventHandler(this.btnCheckData_Click); #line default #line hidden return; case 12: this.btnRunCalculation = ((System.Windows.Controls.Button)(target)); #line 81 "..\..\..\CaseStudy.xaml" this.btnRunCalculation.Click += new System.Windows.RoutedEventHandler(this.btnRunCalculation_Click); #line default #line hidden return; case 13: this.btnExport = ((System.Windows.Controls.Button)(target)); #line 82 "..\..\..\CaseStudy.xaml" this.btnExport.Click += new System.Windows.RoutedEventHandler(this.btnExport_Click); #line default #line hidden return; case 14: this.btnLoadData = ((System.Windows.Controls.Button)(target)); #line 83 "..\..\..\CaseStudy.xaml" this.btnLoadData.Click += new System.Windows.RoutedEventHandler(this.btnLoadData_Click); #line default #line hidden return; case 15: this.ti1 = ((System.Windows.Controls.TabItem)(target)); return; case 16: this.uc1 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 17: this.ti2 = ((System.Windows.Controls.TabItem)(target)); return; case 18: this.uc2 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 19: this.ti3 = ((System.Windows.Controls.TabItem)(target)); return; case 20: this.uc3 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 21: this.ti14 = ((System.Windows.Controls.TabItem)(target)); return; case 22: this.uc14 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 23: this.ti15 = ((System.Windows.Controls.TabItem)(target)); return; case 24: this.uc15 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 25: this.ti16 = ((System.Windows.Controls.TabItem)(target)); return; case 26: this.uc16 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 27: this.ti17 = ((System.Windows.Controls.TabItem)(target)); return; case 28: this.uc17 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 29: this.ti18 = ((System.Windows.Controls.TabItem)(target)); return; case 30: this.uc18 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 31: this.ti4 = ((System.Windows.Controls.TabItem)(target)); return; case 32: this.uc4 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 33: this.ti5 = ((System.Windows.Controls.TabItem)(target)); return; case 34: this.uc5 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 35: this.ti6 = ((System.Windows.Controls.TabItem)(target)); return; case 36: this.uc6 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 37: this.ti7 = ((System.Windows.Controls.TabItem)(target)); return; case 38: this.uc7 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 39: this.ti8 = ((System.Windows.Controls.TabItem)(target)); return; case 40: this.uc8 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 41: this.ti9 = ((System.Windows.Controls.TabItem)(target)); return; case 42: this.uc9 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 43: this.ti10 = ((System.Windows.Controls.TabItem)(target)); return; case 44: this.uc10 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 45: this.ti11 = ((System.Windows.Controls.TabItem)(target)); return; case 46: this.uc11 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 47: this.ti12 = ((System.Windows.Controls.TabItem)(target)); return; case 48: this.uc12 = ((ReliefAnalysis.UC_CaseStudy)(target)); return; case 49: this.ti13 = ((System.Windows.Controls.TabItem)(target)); return; case 50: this.uc13 = ((ReliefAnalysis.UC_Fire)(target)); return; } this._contentLoaded = true; }
private void btnExport_Click(object sender, RoutedEventArgs e) { int idx = dbFile.LastIndexOf(@"\"); Microsoft.Win32.SaveFileDialog dlgSaveDiagram = new Microsoft.Win32.SaveFileDialog(); dlgSaveDiagram.Filter = "Excel xlsx |*.xlsx;"; dlgSaveDiagram.Title = "Export Report"; if (dlgSaveDiagram.ShowDialog() == true) { string filePath = dlgSaveDiagram.FileName; string vsd = AppDomain.CurrentDomain.BaseDirectory.ToString() + "SimTech-PRV_DataSheet_Model.xlsx"; System.IO.File.Copy(vsd, filePath); Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook xlWorkBook = xlApp.Workbooks.Open(filePath, Type.Missing, false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Sheets.get_Item(1); xlWorkSheet.Cells[5][15] = "test"; int count = 0; int row1 = 14; int note1 = 42; int row2 = 74; int note2 = 102; int row3 = 134; int note3 = 162; for (int i = 1; i < mainTab.Items.Count; i++) { TabItem ti = (TabItem)mainTab.Items[i]; if (ti.Visibility == Visibility.Visible) { string num = ti.Name.Remove(0, 2); UC_CaseStudy uc = (UC_CaseStudy)ti.FindName("uc" + num); int col = count % 5; if (count <= 4) { xlWorkSheet.Cells[5 + col * 2][row1] = ti.Header.ToString(); xlWorkSheet.Cells[5 + col * 2][row1 + 1] = 16; if (ti.Header.ToString().Contains("Fire")) { xlWorkSheet.Cells[5 + col * 2][row1 + 1] = 21; } xlWorkSheet.Cells[5 + col * 2][row1 + 2] = uc.txtReliefPress.Text; xlWorkSheet.Cells[5 + col * 2][row1 + 3] = uc.txtReliefTemp.Text; xlWorkSheet.Cells[5 + col * 2][row1 + 4] = uc.txtReliefRate.Text; xlWorkSheet.Cells[5 + col * 2][row1 + 5] = uc.txtReliefMW.Text; xlWorkSheet.Cells[5 + col * 2][row1 + 6] = Compressibility; xlWorkSheet.Cells[5 + col * 2][row1 + 7] = CpCv; xlWorkSheet.Cells[3][note1 + count] = uc.txtDescription.Text; xlWorkSheet.Cells[3][note2 + count] = uc.txtDescription.Text; xlWorkSheet.Cells[3][note3 + count] = uc.txtDescription.Text; } else if (count >= 5 && count <= 9) { xlWorkSheet.Cells[5 + col * 2][row2] = ti.Header.ToString(); xlWorkSheet.Cells[5 + col * 2][row2 + 1] = 16; if (ti.Header.ToString().Contains("Fire")) { xlWorkSheet.Cells[5 + col * 2][row2 + 1] = 21; } xlWorkSheet.Cells[5 + col * 2][row2 + 2] = uc.txtReliefPress.Text; xlWorkSheet.Cells[5 + col * 2][row2 + 3] = uc.txtReliefTemp.Text; xlWorkSheet.Cells[5 + col * 2][row2 + 4] = uc.txtReliefRate.Text; xlWorkSheet.Cells[5 + col * 2][row2 + 5] = uc.txtReliefMW.Text; xlWorkSheet.Cells[5 + col * 2][row2 + 6] = Compressibility; xlWorkSheet.Cells[5 + col * 2][row2 + 7] = CpCv; xlWorkSheet.Cells[3][note1 + count] = uc.txtDescription.Text; xlWorkSheet.Cells[3][note2 + count] = uc.txtDescription.Text; xlWorkSheet.Cells[3][note3 + count] = uc.txtDescription.Text; } else { xlWorkSheet.Cells[5 + col * 2][row3] = ti.Header.ToString(); xlWorkSheet.Cells[5 + col * 2][row3 + 1] = 16; if (ti.Header.ToString().Contains("Fire")) { xlWorkSheet.Cells[5 + col * 2][row3 + 1] = 21; } xlWorkSheet.Cells[5 + col * 2][row3 + 2] = uc.txtReliefPress.Text; xlWorkSheet.Cells[5 + col * 2][row3 + 3] = uc.txtReliefTemp.Text; xlWorkSheet.Cells[5 + col * 2][row3 + 4] = uc.txtReliefRate.Text; xlWorkSheet.Cells[5 + col * 2][row3 + 5] = uc.txtReliefMW.Text; xlWorkSheet.Cells[5 + col * 2][row3 + 6] = Compressibility; xlWorkSheet.Cells[5 + col * 2][row3 + 7] = CpCv; xlWorkSheet.Cells[3][note1 + count] = uc.txtDescription.Text; xlWorkSheet.Cells[3][note2 + count] = uc.txtDescription.Text; xlWorkSheet.Cells[3][note3 + count] = uc.txtDescription.Text; } count++; } } if (count <= 5) { Microsoft.Office.Interop.Excel.Range r = xlWorkSheet.Range[xlWorkSheet.Cells[2][122], xlWorkSheet.Cells[3][181]]; r.UnMerge(); r = xlWorkSheet.Range[xlWorkSheet.Cells[2][122], xlWorkSheet.Cells[14][181]]; r.Clear(); Microsoft.Office.Interop.Excel.Shape pic = xlWorkSheet.Shapes.Item(3) as Microsoft.Office.Interop.Excel.Shape; pic.Delete(); r = xlWorkSheet.Range[xlWorkSheet.Cells[2][62], xlWorkSheet.Cells[3][121]]; r.UnMerge(); r = xlWorkSheet.Range[xlWorkSheet.Cells[2][62], xlWorkSheet.Cells[14][121]]; r.Clear(); pic = xlWorkSheet.Shapes.Item(2) as Microsoft.Office.Interop.Excel.Shape; pic.Delete(); } else if (count <= 10) { Microsoft.Office.Interop.Excel.Range r = xlWorkSheet.Range[xlWorkSheet.Cells[2][122], xlWorkSheet.Cells[3][181]]; r.UnMerge(); r = xlWorkSheet.Range[xlWorkSheet.Cells[2][122], xlWorkSheet.Cells[14][181]]; r.Clear(); Microsoft.Office.Interop.Excel.Shape pic = xlWorkSheet.Shapes.Item(3) as Microsoft.Office.Interop.Excel.Shape; pic.Delete(); } xlWorkBook.Save(); xlWorkBook.Close(true, Type.Missing, Type.Missing); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); } }
private void bindUCData() { for (int i = 1; i < mainTab.Items.Count; i++) { TabItem ti = (TabItem)mainTab.Items[i]; if (ti.Visibility == Visibility.Visible) { string caseid = ti.Name.ToString().Substring(2); if (caseid != "13") { UC_CaseStudy uc = (UC_CaseStudy)ti.FindName("uc" + caseid.ToString()); DataTable feed = dtfrmcase_feed_single.Copy(); foreach (DataRow dr in feed.Rows) { dr["case_id"] = caseid; dr["flowstop"] = false; dr["flowcalcfactor"] = 1; } uc.gridStreamIn.ItemsSource = feed.DefaultView; DataTable product = dtfrmcase_product_single.Copy(); foreach (DataRow dr in product.Rows) { dr["case_id"] = caseid; dr["flowstop"] = false; dr["flowcalcfactor"] = 1; } uc.gridStreamOut.ItemsSource = product.DefaultView; DataTable reboiler = dtfrmcase_reboiler.Clone(); foreach (DataRow dr in dtfrmbasecase_reboiler.Rows) { DataRow r = reboiler.NewRow(); r["case_id"] = caseid; r["visiofile"] = vsdFile; r["heatername"] = dr["heatername"].ToString(); r["heaterduty"] = dr["heaterduty"].ToString(); r["dutylost"] = false; r["dutycalcfactor"] = 1; reboiler.Rows.Add(r); } uc.gridHeatIn.ItemsSource = reboiler.DefaultView; DataTable condenser = dtfrmcase_condenser.Clone(); foreach (DataRow dr in dtfrmbasecase_condenser.Rows) { DataRow r = condenser.NewRow(); r["case_id"] = caseid; r["visiofile"] = vsdFile; r["heatername"] = dr["heatername"].ToString(); r["heaterduty"] = dr["heaterduty"].ToString(); r["dutylost"] = false; r["dutycalcfactor"] = 1; condenser.Rows.Add(r); } uc.gridHeatOut.ItemsSource = condenser.DefaultView; uc.latestH = decimal.Round(decimal.Parse(txtRunResult.Text), 4); DataRow[] drs = dtStreamOut.Select("ProdType='3' or ProdType='4'"); uc.defaultOverHeadH = decimal.Round(decimal.Parse(drs[0]["enthalpy"].ToString()) * 4180000, 4); uc.txtReliefPress.Text = ReliefPress; uc.txtReliefTemp.Text = ReliefTemp; uc.txtReliefMW.Text = ReliefMW; } } if (ti13.Visibility == Visibility.Visible) { uc4.txtReliefPress.Text = ReliefPress; uc4.txtReliefTemp.Text = ReliefTemp; uc4.txtReliefMW.Text = ReliefMW; } } saveDataToDB(); checkDictionary(); for (int i = 1; i < mainTab.Items.Count; i++) { TabItem ti = (TabItem)mainTab.Items[i]; if (ti.Visibility == Visibility.Visible) { string caseid = ti.Name.ToString().Substring(2); if (caseid != "13") { UC_CaseStudy uc = (UC_CaseStudy)ti.FindName("uc" + caseid.ToString()); uc.gridStreamIn.ItemsSource = dbF.getDataByTable("frmcase_feed", "visiofile='" + vsdFile + "' and case_id=" + caseid).DefaultView; uc.gridStreamOut.ItemsSource = dbF.getDataByTable("frmcase_product", "visiofile='" + vsdFile + "' and case_id=" + caseid).DefaultView; uc.gridHeatIn.ItemsSource = dbF.getDataByTable("frmcase_reboiler", "visiofile='" + vsdFile + "' and case_id=" + caseid).DefaultView; uc.gridHeatOut.ItemsSource = dbF.getDataByTable("frmcase_condenser", "visiofile='" + vsdFile + "' and case_id=" + caseid).DefaultView; } } } }
private void InitTabBaseCase() { clearData(); DataSet dsStreamIn = new DataSet(); DataSet dsStreamOut = new DataSet(); DataSet dsHeat = new DataSet(); DBRelief dbReader = new DBRelief(dbFile); string[] arrColumns = { "id", "visiofile", "case_id" }; dtfrmbasecase_feed = dbReader.getDataByVsdFile("frmfeed", vsdFile); dtfrmbasecase_product = dbReader.getDataByVsdFile("frmproduct", vsdFile); dtfrmbasecase_reboiler = dbReader.getDataByVsdFile("frmreboiler", vsdFile); dtfrmbasecase_condenser = dbReader.getDataByVsdFile("frmcondenser", vsdFile); dtfrmbasecase = dbReader.getDataByVsdFile("frmbasecase", vsdFile); dtFlashResult = dbReader.getDataByVsdFile("flashresult", vsdFile); DataTable dtfrmtower = dbReader.getDataByVsdFile("frmtower", vsdFile); if (dtfrmtower.Rows.Count > 0) { string path = System.IO.Path.GetDirectoryName(dbFile); przFile = path + @"\" + dtfrmtower.Rows[0]["przfile"].ToString(); } DataTable dtfrmpsv = dbReader.getDataByVsdFile("frmpsv", vsdFile); if (dtfrmpsv.Rows.Count > 0) { DataRow dr = dtfrmpsv.Rows[0]; Prelief = double.Parse(dr["pressure"].ToString()) * double.Parse(dr["reliefmultiple"].ToString()); } if (dtfrmbasecase.Rows.Count > 0) { DataRow dr = dtfrmbasecase.Rows[0]; txtDescription.Text = dr["Description"].ToString(); txtRunResult.Text = dr["latentheat"].ToString(); strTray1Pressure = dr["Tray1Pressure"].ToString(); vapor = dr["vapor"].ToString(); liquid = dr["liquid"].ToString(); tempdir = dr["dir"].ToString(); tempTemperature = dr["Temperature"].ToString(); } gridStreamIn.ItemsSource = dtfrmbasecase_feed.DefaultView; gridStreamOut.ItemsSource = dtfrmbasecase_product.DefaultView; gridHeatIn.ItemsSource = dtfrmbasecase_reboiler.DefaultView; gridHeatOut.ItemsSource = dtfrmbasecase_condenser.DefaultView; DataTable dtcases = getCases(); checkDictionarySource(dtcases); checkDictionaryCondenser(dtcases); checkDictionaryReboiler(dtcases); dtfrmcase = dbReader.getDataByVsdFile("frmcase", vsdFile); dtfrmcase_feed = dbReader.getDataByVsdFile("frmcase_feed", vsdFile); dtfrmcase_product = dbReader.getDataByVsdFile("frmcase_product", vsdFile); dtfrmcase_reboiler = dbReader.getDataByVsdFile("frmcase_reboiler", vsdFile); dtfrmcase_condenser = dbReader.getDataByVsdFile("frmcase_condenser", vsdFile); foreach (DataRow drcase in dtfrmcase.Rows) { int caseid = int.Parse(drcase["case_id"].ToString()); int i = dicCaseIndex[caseid]; TabItem ti = (TabItem)mainTab.Items[i]; string ucName = "uc" + ti.Name.Substring(2); object uc = ti.FindName(ucName); if (uc is UC_CaseStudy) { UC_CaseStudy uccase = (UC_CaseStudy)uc; DataView dv = new DataView(dtfrmcase_feed); dv.RowFilter = "case_id=" + caseid.ToString() + " and visiofile='" + vsdFile + "'"; uccase.gridStreamIn.ItemsSource = dv; dv = new DataView(dtfrmcase_product); dv.RowFilter = "case_id=" + caseid.ToString() + " and visiofile='" + vsdFile + "'"; uccase.gridStreamOut.ItemsSource = dv; dv = new DataView(dtfrmcase_reboiler); dv.RowFilter = "case_id=" + caseid.ToString() + " and visiofile='" + vsdFile + "'"; uccase.gridHeatIn.ItemsSource = dv; dv = new DataView(dtfrmcase_condenser); dv.RowFilter = "case_id=" + caseid.ToString() + " and visiofile='" + vsdFile + "'"; uccase.gridHeatOut.ItemsSource = dv; DataRow[] drs = dtfrmcase.Select("case_id=" + caseid.ToString() + " and visiofile='" + vsdFile + "'"); uccase.txtDescription.Text = drs[0]["Description"].ToString(); uccase.txtReliefMW.Text = drs[0]["ReliefMW"].ToString(); uccase.txtReliefPress.Text = drs[0]["ReliefPress"].ToString(); uccase.txtReliefRate.Text = drs[0]["reliefrate"].ToString(); uccase.txtReliefTemp.Text = drs[0]["ReliefTemp"].ToString(); ti.Visibility = Visibility.Visible; uccase.latestH = decimal.Round(decimal.Parse(txtRunResult.Text), 4); } } //chkGeneralElectricalPowerFailure(); }