private void getChekedItems() { DBRelief dbr = new DBRelief(dbFile); DataTable dt = dbr.getStructure("frmoptionduty"); IEnumerable <CheckBox> collection = gridDuty.FindChildren <CheckBox>(); foreach (CheckBox chk in collection) { if (chk.IsChecked == true) { string strIdx = chk.Name.Substring(3); items.Add(int.Parse(strIdx)); DataRow dr = dt.NewRow(); dr["case_id"] = strIdx; dr["visiofile"] = vsdFile; dt.Rows.Add(dr); if (strIdx == "3") { for (int i = 14; i <= 18; i++) { dr = dt.NewRow(); dr["case_id"] = i; dr["visiofile"] = vsdFile; dt.Rows.Add(dr); items.Add(i); } } } } dbr.saveDataByTable(dt, vsdFile); }
private void saveData() { DBRelief dbWrite = new DBRelief(dbFile); if (gridStreamIn.ItemsSource != null) { DataView dvFeed = (DataView)gridStreamIn.ItemsSource; dtfrmcase_feed.Merge(dvFeed.Table); DataView dvProduct = (DataView)gridStreamOut.ItemsSource; dtfrmcase_product.Merge(dvProduct.Table); DataView dvReboiler = (DataView)gridHeatIn.ItemsSource; dtfrmcase_reboiler.Merge(dvReboiler.Table); DataView dvCondenser = (DataView)gridHeatOut.ItemsSource; dtfrmcase_condenser.Merge(dvCondenser.Table); DataRow dr = dtfrmcase.NewRow(); dr["case_id"] = case_id; dr["visiofile"] = vsdFile; dr["relieftemp"] = txtReliefTemp.Text; dr["reliefpress"] = txtReliefPress.Text; dr["reliefrate"] = txtReliefRate.Text; dr["reliefmw"] = txtReliefMW.Text; dtfrmcase.Rows.Add(dr); } dbWrite.saveDataByTable(dtfrmcase, vsdFile); dbWrite.saveDataByTable(dtfrmcase_feed, vsdFile); dbWrite.saveDataByTable(dtfrmcase_product, vsdFile); dbWrite.saveDataByTable(dtfrmcase_reboiler, vsdFile); dbWrite.saveDataByTable(dtfrmcase_condenser, vsdFile); }
private void bindDataGrid() { DBRelief dbR = new DBRelief(dbFile); DataTable dt = dbR.getDataByVsdFile("frmfire", vsdFile); if (dt != null) { if (dt.Rows.Count != 0) { fireDataGrid.ItemsSource = dt.DefaultView; } else { DataTable dtCondenser = dbR.getDataByVsdFile("frmcondenser", vsdFile); foreach (DataRow drCondenser in dtCondenser.Rows) { DataRow dr = dt.NewRow(); dr["equipment_no"] = drCondenser["heatername"].ToString(); dr["visiofile"] = vsdFile; dt.Rows.Add(dr); } DataTable dtReboiler = dbR.getDataByVsdFile("frmreboiler", vsdFile); foreach (DataRow drReboiler in dtReboiler.Rows) { DataRow dr = dt.NewRow(); dr["equipment_no"] = drReboiler["heatername"].ToString(); dr["visiofile"] = vsdFile; dt.Rows.Add(dr); } DataTable dtAccumulator = dbR.getDataByVsdFile("frmAccumulator", vsdFile); foreach (DataRow drAccumulator in dtAccumulator.Rows) { DataRow dr = dt.NewRow(); dr["equipment_no"] = drAccumulator["accumulatorname"].ToString(); dr["visiofile"] = vsdFile; dt.Rows.Add(dr); } dbR.saveDataByTable(dt, vsdFile); dt = dbR.getDataByVsdFile("frmfire", vsdFile); fireDataGrid.ItemsSource = dt.DefaultView; } } }
private void btnOK_Click(object sender, RoutedEventArgs e) { DBRelief dbR = new DBRelief(dbFile); DataRow dr = dtTower.NewRow(); if (op == 0) { Application.Current.Properties.Add("FeedData", dtFeed); Application.Current.Properties.Add("Condenser", dtCondenser); Application.Current.Properties.Add("HxCondenser", dtHxCondenser); Application.Current.Properties.Add("Reboiler", dtReboiler); Application.Current.Properties.Add("HxReboiler", dtHxReboiler); Application.Current.Properties.Add("ProdData", dtProd); dtTower.Rows.Add(dr); dr["towername"] = txtName.Text; dr["stagenumber"] = this.txtStageNumber.Text; dr["description"] = this.txtDescription.Text; dr["visiofile"] = vsdFile; if (!string.IsNullOrEmpty(przFile)) { dr["przfile"] = przFile; } DataTable dtCondenserTemp = dtCondenser.Clone(); dtCondenserTemp.Merge(dtCondenser); dtCondenserTemp.Merge(dtHxCondenser); DataTable dtReboilerTemp = dtReboiler.Clone(); dtReboilerTemp.Merge(dtReboiler); dtReboilerTemp.Merge(dtHxReboiler); dbR.saveDataByTable(dtFeed, vsdFile); dbR.saveDataByTable(dtProd, vsdFile); dbR.saveDataByTable(dtSource, vsdFile); dbR.saveDataByTable(dtSink, vsdFile); dbR.saveDataByTable(dtCondenserTemp, vsdFile); dbR.saveDataByTable(dtReboilerTemp, vsdFile); dbR.saveDataByTable(dtTower, vsdFile); } else { dr = dtTower.Rows[0]; dr["towername"] = txtName.Text; dr["stagenumber"] = this.txtStageNumber.Text; dr["description"] = this.txtDescription.Text; dr["visiofile"] = vsdFile; if (!string.IsNullOrEmpty(przFile)) { dr["przfile"] = przFile; } if (txtName.BorderBrush == Brushes.Green) { dr["towername_color"] = "green"; } else { dr["towername_color"] = "blue"; } if (txtStageNumber.BorderBrush == Brushes.Green) { dr["stagenumber_color"] = "green"; } else { dr["stagenumber_color"] = "blue"; } dbR.saveDataByRow(dr, 1); } this.DialogResult = true; }
private void btnOK_Click(object sender, RoutedEventArgs e) { if (txtName.Text.ToString().Trim() == string.Empty) { CustomMessageBox msg = new CustomMessageBox(); msg.WindowStartupLocation = WindowStartupLocation.CenterScreen; msg.tipcontent.Text = "PSV Name could not be empty"; msg.Show(); return; } string pressure = txtPress.Text.ToString().Trim(); if (pressure == string.Empty) { CustomMessageBox msg = new CustomMessageBox(); msg.WindowStartupLocation = WindowStartupLocation.CenterScreen; msg.tipcontent.Text = "Pressure Name could not be empty"; msg.Show(); return; } else if (isNumber(pressure) == false) { CustomMessageBox msg = new CustomMessageBox(); msg.WindowStartupLocation = WindowStartupLocation.CenterScreen; msg.tipcontent.Text = "Pressure could not be empty"; msg.Show(); return; } string relief = txtPrelief.Text.ToString().Trim(); if (relief == string.Empty) { CustomMessageBox msg = new CustomMessageBox(); msg.WindowStartupLocation = WindowStartupLocation.CenterScreen; msg.tipcontent.Text = "Prelief's Value could not be empty"; msg.Show(); return; } else if (isNumber(pressure) == false) { CustomMessageBox msg = new CustomMessageBox(); msg.WindowStartupLocation = WindowStartupLocation.CenterScreen; msg.tipcontent.Text = "Prelief's Value must be a number"; msg.Show(); return; } DBRelief dbR = new DBRelief(dbFile); dtpsv = dtpsv.Clone(); DataRow dr = dtpsv.NewRow(); if (dtpsv.Rows.Count == 0) { dtpsv.Rows.Add(dr); } else { dr = dtpsv.Rows[0]; } dr["visiofile"] = vsdFile; dr["psvname"] = txtName.Text; dr["description"] = txtDescription.Text; dr["valvetype"] = cbxValueType.SelectedItem.ToString(); dr["valvenumber"] = txtValveNumber.Text; dr["pressure"] = txtPress.Text; dr["reliefmultiple"] = txtPrelief.Text; dr["location"] = cbxLocation.SelectedItem.ToString(); dr["locationdescription"] = txtLocationDescription.Text; dbR.saveDataByTable(dtpsv, vsdFile); this.DialogResult = true; }
private void saveDataToDB() { DBRelief dbr = new DBRelief(dbFile); dtfrmbasecase = dtfrmbasecase.Clone(); DataRow dr = dtfrmbasecase.NewRow(); dr["description"] = this.txtDescription.Text; dr["latentheat"] = this.txtRunResult.Text; dr["visiofile"] = vsdFile; dr["Tray1Pressure"] = strTray1Pressure; dr["vapor"] = vapor; dr["liquid"] = liquid; dr["dir"] = tempdir; dr["Temperature"] = tempTemperature; dtfrmbasecase.Rows.Add(dr); DataView dvFeed = (DataView)gridStreamIn.ItemsSource; DataView dvProduct = (DataView)gridStreamOut.ItemsSource; DataView dvReboiler = (DataView)gridHeatIn.ItemsSource; DataView dvCondenser = (DataView)gridHeatOut.ItemsSource; DataTable dtFeed = dvFeed.Table.Copy(); DataTable dtProduct = dvProduct.Table; dbr.saveDataByTable(dtfrmbasecase, vsdFile); dbr.saveDataByTable(dtFeed, vsdFile); dbr.saveDataByTable(dtProduct, vsdFile); dbr.saveDataByTable(dvReboiler.Table, vsdFile); dbr.saveDataByTable(dvCondenser.Table, vsdFile); dbr.saveDataByTable(dtFlashResult, vsdFile); dtfrmcase_feed = dtfrmcase_feed.Clone(); dtfrmcase_product = dtfrmcase_product.Clone(); dtfrmcase_reboiler = dtfrmcase_reboiler.Clone(); dtfrmcase_condenser = dtfrmcase_condenser.Clone(); dtfrmcase = dtfrmcase.Clone(); foreach (KeyValuePair <int, UC_CaseStudy> uc in dicCase) { if (uc.Value.gridStreamIn.ItemsSource != null) { dvFeed = (DataView)uc.Value.gridStreamIn.ItemsSource; dtfrmcase_feed.Merge(dvFeed.ToTable()); dvProduct = (DataView)uc.Value.gridStreamOut.ItemsSource; dtfrmcase_product.Merge(dvProduct.ToTable()); dvReboiler = (DataView)uc.Value.gridHeatIn.ItemsSource; dtfrmcase_reboiler.Merge(dvReboiler.ToTable()); dvCondenser = (DataView)uc.Value.gridHeatOut.ItemsSource; dtfrmcase_condenser.Merge(dvCondenser.ToTable()); dr = dtfrmcase.NewRow(); dr["case_id"] = uc.Key; dr["visiofile"] = vsdFile; dr["relieftemp"] = uc.Value.txtReliefTemp.Text; dr["reliefpress"] = uc.Value.txtReliefPress.Text; dr["reliefrate"] = uc.Value.txtReliefRate.Text; dr["reliefmw"] = uc.Value.txtReliefMW.Text; dtfrmcase.Rows.Add(dr); } } dbr.saveDataByTable(dtfrmcase, vsdFile); dbr.saveDataByTable(dtfrmcase_feed, vsdFile); dbr.saveDataByTable(dtfrmcase_product, vsdFile); dbr.saveDataByTable(dtfrmcase_reboiler, vsdFile); dbr.saveDataByTable(dtfrmcase_condenser, vsdFile); }