private void chkGeneralElectricalPowerFailure()
{
if (chkIsMaintained.IsChecked == true)
{
DataTable dtCase4 = dbR.getDataByVsdFile("frmcase_feed", vsdFile, "case_id=4 and streamname='" + dr["streamname"].ToString() + "'");
if (dtCase4.Rows.Count > 0)
{
DataRow r = dtCase4.Rows[0];
r["flowstop"] = false;
dbR.saveDataByRow(r, 1);
}
}
else
{
DataTable dtCase4 = dbR.getDataByVsdFile("frmcase_feed", vsdFile, "case_id=4 and streamname='" + dr["streamname"].ToString() + "'");
if (dtCase4.Rows.Count > 0)
{
DataRow r = dtCase4.Rows[0];
if (isMotor())
{
r["flowstop"] = true;
}
else
{
r["flowstop"] = false;
}
dbR.saveDataByRow(r, 1);
}
}
}
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 bool isMotor(string streamname)
{
DBRelief dbReader = new DBRelief(dbFile);;
DataTable dt = dbReader.getDataByVsdFile("frmSource", vsdFile, "streamname='" + streamname + "' and sourcetype like '%%Motor%%'");
if (dt.Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
private void chkGeneralElectricalPowerFailure()
{
DataTable dtCase4 = dbR.getDataByVsdFile("frmcase_condenser", vsdFile, "case_id=4 and heatername='" + dr["heatername"].ToString() + "'");
if (dtCase4.Rows.Count > 0)
{
DataRow r = dtCase4.Rows[0];
decimal airfactor = decimal.Parse(txtAirFactor.Text.Trim()) * 0.2m;
decimal wetairfactor = decimal.Parse(txtWetAirFactor.Text.Trim()) * 0.3m;
decimal waterfactor = decimal.Parse(txtWaterFactor.Text.Trim());
r["dutycalcfactor"] = airfactor + wetairfactor + waterfactor;
dbR.saveDataByRow(r, 1);
}
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
DBRelief dbR = new DBRelief(dbFile);
dt = dbR.getDataByVsdFile("frmfire", vsdFile, "id=" + id + "");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
op = 1;
dr = dt.Rows[0];
this.txtEquipmentNO.Text = dr["equipment_no"].ToString();
txtService.Text = dr["equipment_service"].ToString();
txtLocation.Text = dr["equipment_location"].ToString();
cbxStream.Text = dr["stream"].ToString();
cbxVesselType.Text = dr["vessel_type"].ToString();
txtNumberOfIdentcalVessels.Text = dr["number_of_identical_vessels"].ToString();
txtIVDiameter.Text = dr["diameter_identical_vessels"].ToString();
txtIVFactor.Text = dr["vessel_factor"].ToString();
txtIVLength.Text = dr["vessel_length"].ToString();
txtNumberOfWettedHeads.Text = dr["number_of_wetted_heads"].ToString();
txtNormalLiquidLevel.Text = dr["normal_liquid_level"].ToString();
txtFireExposedLiquidLevel.Text = dr["fire_exposed_liquid_level"].ToString();
txtElevationtoBottom.Text = dr["elevation_to_bottom"].ToString();
txtWettedDiameter.Text = dr["diameter_wetted_heads"].ToString();
txtTT.Text = dr["tt"].ToString();
txtHeatInput.Text = dr["heat_input"].ToString();
txtC1.Text = dr["c1"].ToString();
txtC2.Text = dr["c2"].ToString();
txtC3.Text = dr["c3"].ToString();
txtC4.Text = dr["c4"].ToString();
txtC5.Text = dr["c5"].ToString();
txtInlet.Text = dr["piping_inlet"].ToString();
txtInletLength.Text = dr["inlet_length"].ToString();
this.txtOutLet.Text = dr["piping_outlet"].ToString();
this.txtOutLength.Text = dr["outlet_length"].ToString();
this.txtPipingDiameter.Text = dr["piping_diameter"].ToString();
txtWettedArea.Text = dr["Wetted_Area"].ToString();
}
else
{
dr = dt.NewRow();
}
}
}
private void window_Loaded(object sender, RoutedEventArgs e)
{
int[] partiStop = { 14, 15, 16, 17, 18 };
DBRelief dbr = new DBRelief(dbFile);
IEnumerable <CheckBox> collection = gridDuty.FindChildren <CheckBox>();
DataTable dt = dbr.getDataByVsdFile("frmoptionduty", vsdFile);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
int idx = int.Parse(dr["case_id"].ToString());
if (!partiStop.Contains(idx))
{
CheckBox chk = collection.ElementAt(idx - 1);
chk.IsChecked = true;
}
}
}
private void MetroWindow_Loaded_1(object sender, RoutedEventArgs e)
{
DBRelief dbR = new DBRelief(dbFile);
string Name = txtName.Text;
dt = dbR.getDataByVsdFile("frmreboiler", vsdFile, "heatername='" + Name + "'");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
op = 1;
dr = dt.Rows[0];
txtName.Text = Name;
txtDescription.Text = dr["description"].ToString();
txtDuty.Text = dr["heaterduty"].ToString();
txtSteam.Text = dr["Steam"].ToString();
txtSteamFactor.Text = dr["SteamFactor"].ToString();
txtHotOil.Text = dr["HotOil"].ToString();
txtHotOilFactor.Text = dr["HotOilFactor"].ToString();
txtHotStream.Text = dr["HotStream"].ToString();
txtHotStreamFactor.Text = dr["HotStreamfactor"].ToString();
txtFurnace.Text = dr["Furnace"].ToString();
txtFurnaceFactor.Text = dr["FurnaceFactor"].ToString();
chkIsContinued.IsChecked = bool.Parse(dr["iscontinued"].ToString());
setColor(dr, "heatername_color", txtName);
setColor(dr, "heaterduty_color", txtDuty);
setColor(dr, "Steam_color", txtSteam);
setColor(dr, "SteamFactor_color", txtSteamFactor);
setColor(dr, "HotOil_color", txtHotOil);
setColor(dr, "HotOilFactor_color", txtHotOilFactor);
setColor(dr, "HotStream_color", txtHotStream);
setColor(dr, "HotStreamfactor_color", txtHotStreamFactor);
setColor(dr, "Furnace_color", txtFurnace);
setColor(dr, "FurnaceFactor_color", txtFurnaceFactor);
setColor(dr, "iscontinued_color", chkIsContinued);
loadstatus = 1;
}
else
{
dr = dt.NewRow();
}
}
}
private void MetroWindow_Loaded_1(object sender, RoutedEventArgs e)
{
try
{
txtName.BorderBrush = Brushes.Red;
txtName.BorderThickness = new Thickness(2, 2, 2, 2);
txtMaxPressure.BorderBrush = Brushes.Red;
txtMaxPressure.BorderThickness = new Thickness(2, 2, 2, 2);
dbR = new DBRelief(dbFile);
string sourceName = txtName.Text;
dtsource = dbR.getDataByVsdFile("frmsource", vsdFile, "sourcename='" + sourceName + "'");
if (dtsource != null)
{
if (dtsource.Rows.Count > 0)
{
op = 1;
dr = dtsource.Rows[0];
txtName.Text = sourceName;
txtDescription.Text = dr["description"].ToString();
cbxType.Text = dr["sourcetype"].ToString();
txtMaxPressure.Text = dr["maxpossiblepressure"].ToString();
chkIsMaintained.IsChecked = bool.Parse(dr["ismaintained"].ToString());
setColor(dr, "sourcename_color", txtName);
setColor(dr, "sourcetype_color", cbxType);
setColor(dr, "maxpossiblepressure_color", txtMaxPressure);
setColor(dr, "ismaintained_color", chkIsMaintained);
loadstatus = 1;
}
else
{
dr = dtsource.NewRow();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Action");
}
}
private void MetroWindow_Loaded_1(object sender, RoutedEventArgs e)
{
dbR = new DBRelief(dbFile);
string condenserName = txtName.Text;
dtCondenser = dbR.getDataByVsdFile("frmcondenser", vsdFile, "heatername='" + condenserName + "'");
if (dtCondenser != null)
{
if (dtCondenser.Rows.Count > 0)
{
op = 1;
dr = dtCondenser.Rows[0];
txtName.Text = condenserName;
txtDescription.Text = dr["description"].ToString();
txtDuty.Text = dr["heaterduty"].ToString();
txtWater.Text = dr["water"].ToString();
txtWaterFactor.Text = dr["waterfactor"].ToString();
txtAir.Text = dr["air"].ToString();
txtAirFactor.Text = dr["airfactor"].ToString();
txtWetAir.Text = dr["wetair"].ToString();
txtWetAirFactor.Text = dr["wetairfactor"].ToString();
txtPumpAbound.Text = dr["pumpabound"].ToString();
txtPumpAboundFactor.Text = dr["pumpaboundfactor"].ToString();
setColor(dr, "heatername_color", txtName);
setColor(dr, "heaterduty_color", txtDuty);
setColor(dr, "water_color", txtWater);
setColor(dr, "waterFactor_color", txtWaterFactor);
setColor(dr, "air_color", txtAir);
setColor(dr, "airFactor_color", txtAirFactor);
setColor(dr, "wetair_color", txtWetAir);
setColor(dr, "wetairfactor_color", txtWetAirFactor);
setColor(dr, "pumpabound_color", txtPumpAbound);
setColor(dr, "pumpaboundFactor_color", txtPumpAboundFactor);
loadstatus = 1;
}
}
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
DBRelief dbR = new DBRelief(dbFile);
dtpsv = dbR.getDataByVsdFile("frmpsv", vsdFile);
if (dtpsv != null)
{
if (dtpsv.Rows.Count > 0)
{
DataRow dr = dtpsv.Rows[0];
vsdFile = dr["visiofile"].ToString();
txtName.Text = dr["psvname"].ToString();
txtDescription.Text = dr["description"].ToString();
cbxValueType.SelectedItem = dr["valvetype"].ToString();
txtValveNumber.Text = dr["valvenumber"].ToString();
txtPress.Text = dr["pressure"].ToString();
txtPrelief.Text = dr["reliefmultiple"].ToString();
cbxLocation.SelectedItem = dr["location"].ToString();
txtLocationDescription.Text = dr["locationdescription"].ToString();
}
}
}
private void MetroWindow_Loaded_1(object sender, RoutedEventArgs e)
{
DBRelief dbR = new DBRelief(dbFile);
string Name = txtName.Text;
dt = dbR.getDataByVsdFile("frmaccumulator", vsdFile, "accumulatorname='" + Name + "'");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
op = 1;
dr = dt.Rows[0];
txtName.Text = Name;
string orientation = voH.Content.ToString();
string orientation_db = dr["orientation"].ToString();
if (string.Compare(orientation_db, orientation) == 0)
{
voH.IsChecked = true;
}
else
{
voV.IsChecked = true;
}
this.txtDiameter.Text = dr["diameter"].ToString();
this.txtLength.Text = dr["length"].ToString();
this.txtNumberofHeads.Text = dr["numberofheads"].ToString();
this.txtHeadRatio.Text = dr["headratio"].ToString();
}
else
{
dr = dt.NewRow();
}
}
}
public void getTowerInfo()
{
try
{
DBRelief dbR = new DBRelief(dbFile);
dtTower = dbR.getDataByVsdFile("frmtower", vsdFile);
if (dtTower.Rows.Count != 0)
{
op = 1;
DataRow dr = dtTower.Rows[0];
txtName.Text = dr["towername"].ToString();
this.txtStageNumber.Text = dr["StageNumber"].ToString();
this.txtDescription.Text = dr["Description"].ToString();
string towercolor = dr["towername_color"].ToString();
if (towercolor == "blue")
{
txtName.BorderBrush = Brushes.Blue;
txtName.BorderThickness = new Thickness(2, 2, 2, 2);
}
else
{
txtName.BorderBrush = Brushes.Green;
txtName.BorderThickness = new Thickness(2, 2, 2, 2);
}
if (dr["StageNumber_color"].ToString() == "blue")
{
txtStageNumber.BorderBrush = Brushes.Blue;
txtStageNumber.BorderThickness = new Thickness(2, 2, 2, 2);
}
else
{
txtStageNumber.BorderBrush = Brushes.Green;
txtStageNumber.BorderThickness = new Thickness(2, 2, 2, 2);
}
}
DataTable dt = new DataTable();
dt = dbR.getDataByVsdFile("frmfeed", vsdFile);
if (dt.Rows.Count != 0)
{
dtFeed = dt;
}
dt = dbR.getDataByVsdFile("frmproduct", vsdFile);
if (dt.Rows.Count != 0)
{
dtProd = dt;
}
dt = dbR.getDataByVsdFile("frmcondenser", vsdFile, "ishx=false");
if (dt.Rows.Count != 0)
{
this.dtCondenser = dt;
}
dt = dbR.getDataByVsdFile("frmcondenser", vsdFile, "ishx=true");
if (dt.Rows.Count != 0)
{
this.dtHxCondenser = dt;
}
dt = dbR.getDataByVsdFile("frmreboiler", vsdFile, "ishx=false");
if (dt.Rows.Count != 0)
{
this.dtReboiler = dt;
}
dt = dbR.getDataByVsdFile("frmreboiler", vsdFile, "ishx=true");
if (dt.Rows.Count != 0)
{
this.dtHxReboiler = dt;
}
bindCombox();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
try
{
FocusManager.SetFocusedElement(grid1, txtName);
DBRelief dbR = new DBRelief(dbFile);
string Name = txtName.Text;
dt = dbR.getDataByVsdFile("frmfeed", vsdFile, "streamname='" + Name + "'");
if (dt != null)
{
if (dt.Rows.Count > 0)
{
op = 1;
dr = dt.Rows[0];
txtName.Text = Name;
txtDescription.Text = dr["description"].ToString();
txtTemp.Text = dr["Temperature"].ToString();
txtPres.Text = dr["Pressure"].ToString();
txtVabFrac.Text = dr["VaporFraction"].ToString();
txtWf.Text = dr["WeightFlow"].ToString();
txtH.Text = dr["Enthalpy"].ToString();
txtSph.Text = dr["SpEnthalpy"].ToString();
setColor(dr, "streamname_color", txtName);
setColor(dr, "Temperature_color", txtTemp);
setColor(dr, "Pressure_color", txtPres);
setColor(dr, "VaporFraction_color", txtVabFrac);
setColor(dr, "WeightFlow_color", txtWf);
setColor(dr, "Enthalpy_color", txtH);
setColor(dr, "SpEnthalpy_color", txtSph);
loadstatus = 1;
}
else
{
op = 1;
dt = dbR.getDataByVsdFile("frmproduct", vsdFile, "streamname='" + Name + "'");
dr = dt.Rows[0];
txtName.Text = Name;
txtDescription.Text = dr["description"].ToString();
txtTemp.Text = dr["Temperature"].ToString();
txtPres.Text = dr["Pressure"].ToString();
txtVabFrac.Text = dr["VaporFraction"].ToString();
txtWf.Text = dr["WeightFlow"].ToString();
txtH.Text = dr["Enthalpy"].ToString();
txtSph.Text = dr["SpEnthalpy"].ToString();
setColor(dr, "streamname_color", txtName);
setColor(dr, "Temperature_color", txtTemp);
setColor(dr, "Pressure_color", txtPres);
setColor(dr, "VaporFraction_color", txtVabFrac);
setColor(dr, "WeightFlow_color", txtWf);
setColor(dr, "Enthalpy_color", txtH);
setColor(dr, "SpEnthalpy_color", txtSph);
loadstatus = 1;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Action");
}
}
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();
}
