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 Window_Loaded_1(object sender, RoutedEventArgs e)
{
dbF = new DBRelief(dbFile);
initDicCaseIndex();
initDicCase();
InitTabBaseCase();
for (int i = 1; i < mainTab.Items.Count; i++)
{
TabItem ti = (TabItem)mainTab.Items[i];
ti.Visibility = Visibility.Collapsed;
}
foreach (int i in dispCase)
{
TabItem ti = (TabItem)FindName("ti" + i.ToString());
ti.Visibility = Visibility.Visible;
if (i == 13)
{
uc13.dbFile = dbFile;
uc13.vsdFile = vsdFile;
}
}
}
private void checkData()
{
tempdir = System.IO.Path.GetDirectoryName(dbFile) + @"\temp\" + Guid.NewGuid().ToString();
if (!Directory.Exists(tempdir))
{
Directory.CreateDirectory(tempdir);
}
backgroundWorker.ReportProgress(5);
PRZWriter w = new PRZWriter();
DataTable dt = w.copyStream(przFile, eqName);
backgroundWorker.ReportProgress(15);
FlashCompute flashc = new FlashCompute();
strTray1Pressure = dt.Rows[0]["pressure"].ToString();
if (strTray1Pressure == "")
{
strTray1Pressure = "0";
}
strTray1Pressure = UnitConverter.unitConv(strTray1Pressure, "KPA", "MPAG", "{0:0.0000}");
backgroundWorker.ReportProgress(25);
string strTray1Temperature = dt.Rows[0]["Temperature"].ToString();
if (strTray1Temperature == "")
{
strTray1Temperature = "0";
}
strTray1Temperature = UnitConverter.unitConv(strTray1Temperature, "K", "C", "{0:0.0000}");
tray1_s = dt.Rows[0]["streamname"].ToString().ToUpper();
string gd = Guid.NewGuid().ToString();
vapor = "S_" + gd.Substring(0, 5).ToUpper();
liquid = "S_" + gd.Substring(gd.Length - 5, 5).ToUpper();
backgroundWorker.ReportProgress(30);
string content = InpReader.getUsableContent(przFile, dt.Rows[0]["streamname"].ToString(), tempdir);
backgroundWorker.ReportProgress(40);
tray1_f = flashc.compute(content, 1, Prelief.ToString(), 3, "", dt.Rows[0], vapor, liquid, tempdir);
backgroundWorker.ReportProgress(60);
PRZReader reader = new PRZReader(tray1_f);
DataSet ds = reader.getDataFromFile();
while (ds.Tables[0].Rows[0]["temperature"].ToString() == "")
{
ds = reader.getDataFromFile();
}
backgroundWorker.ReportProgress(80);
DBRelief dbreader = new DBRelief();
feedH = dbreader.computeH(ds.Tables[0], tray1_s.ToUpper());
vaporH = dbreader.computeH(ds.Tables[0], vapor);
liqidH = dbreader.computeH(ds.Tables[0], liquid);
tempTemperature = vaporH[3];
backgroundWorker.ReportProgress(100);
}
public DataSet getDataFromFile()
{
try
{
DBRelief dbRelief = new DBRelief();
List <string> streamList = new List <string>();
DataSet dsStructure = dbRelief.getDataStructure();
DataTable dtEqlist = dsStructure.Tables["eqlist"].Clone();
DataTable dtStream = dsStructure.Tables["stream"].Clone();
DataTable dtEqType = dsStructure.Tables["eqtype"];
cp2File = (CP2File)cp2Srv.OpenDatabase(przFile);
objCompCalc = (CP2Object)cp2File.ActivateObject("CompCalc", "CompCalc");
foreach (DataRow dr in dtEqType.Rows)
{
string otype = dr["eqtypename"].ToString();
object objectnames = cp2File.GetObjectNames(otype);
if (objectnames.ToString() != "")
{
if (objectnames is Array)
{
string[] oNames = (string[])objectnames;
foreach (string name in oNames)
{
getEqDataFromFile(otype, name, ref streamList, ref dtEqlist, ref dtStream);
}
}
else
{
string name = (string)objectnames;
getEqDataFromFile(otype, name, ref streamList, ref dtEqlist, ref dtStream);
}
}
}
Marshal.FinalReleaseComObject(cp2Srv);
GC.ReRegisterForFinalize(cp2Srv);
DataSet ds = new DataSet();
ds.Tables.Add(dtStream);
ds.Tables.Add(dtEqlist);
return(ds);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
//CloseReader();
}
}
public void InitDataTable()
{
DBRelief dbr = new DBRelief(dbFile);
dtFeed = dbr.getStructure("frmfeed");
dtProd = dbr.getStructure("frmproduct");
dtCondenser = dbr.getStructure("frmcondenser");
dtReboiler = dbr.getStructure("frmreboiler");
dtHxReboiler = dtReboiler.Clone();
dtHxCondenser = dtCondenser.Clone();
dtSource = dbr.getStructure("frmsource");
dtSink = dbr.getStructure("frmsink");
}
//判断是否是电力启动
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 btnOK_Click(object sender, RoutedEventArgs e)
{
decimal water = decimal.Parse(txtSteam.Text.Trim());
decimal air = decimal.Parse(txtHotOil.Text.Trim());
decimal wetair = decimal.Parse(txtHotStream.Text.Trim());
decimal pumpabound = decimal.Parse(txtFurnace.Text.Trim());
decimal duty = decimal.Parse(txtDuty.Text.Trim());
if (duty != (water + air + wetair + pumpabound))
{
//txtSteamFactor.Focus();
txtSteamFactor.BorderBrush = Brushes.Red;
txtSteamFactor.BorderThickness = new Thickness(2, 2, 2, 2);
return;
}
dr["heatername"] = txtName.Text.Trim();
dr["description"] = txtDescription.Text.Trim();
dr["heaterduty"] = txtDuty.Text.Trim();
dr["Steam"] = txtSteam.Text.Trim();
dr["SteamFactor"] = txtSteamFactor.Text.Trim();
dr["HotOil"] = txtHotOil.Text.Trim();
dr["HotOilFactor"] = txtHotOilFactor.Text.Trim();
dr["HotStream"] = txtHotStream.Text.Trim();
dr["HotStreamfactor"] = txtHotStreamFactor.Text.Trim();
dr["Furnace"] = txtFurnace.Text.Trim();
dr["FurnaceFactor"] = txtFurnaceFactor.Text.Trim();
dr["iscontinued"] = chkIsContinued.IsChecked;
dr["visiofile"] = vsdFile;
getColor(ref dr, "heatername_color", txtName);
getColor(ref dr, "heaterduty_color", txtDuty);
getColor(ref dr, "Steam_color", txtSteam);
getColor(ref dr, "SteamFactor_color", txtSteamFactor);
getColor(ref dr, "HotOil_color", txtHotOil);
getColor(ref dr, "HotOilFactor_color", txtHotOilFactor);
getColor(ref dr, "HotStream_color", txtHotStream);
getColor(ref dr, "HotStreamfactor_color", txtHotStreamFactor);
getColor(ref dr, "Furnace_color", txtFurnace);
getColor(ref dr, "FurnaceFactor_color", txtFurnaceFactor);
getColor(ref dr, "iscontinued_color", chkIsContinued);
DBRelief dbR = new DBRelief(dbFile);
dbR.saveDataByRow(dr, op);
this.DialogResult = true;
}
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 btnCancel_Click(object sender, RoutedEventArgs e)
{
PRZReader przReader = new PRZReader(newPrzFile);
DataSet ds = przReader.getDataFromFile();
DBRelief dbreader = new DBRelief();
string[] feedH = dbreader.computeH(ds.Tables[0], txtName.Text.Trim().ToUpper());
string[] vaporH = dbreader.computeH(ds.Tables[0], v);
string[] liqidH = dbreader.computeH(ds.Tables[0], l);
lblFeedH.Content = "FEED= " + feedH[0] + " KJ/hr";
lblVaporH.Content = "VAPOR= " + vaporH[0] + " KJ/hr";
lblLiqidH.Content = "LIQID= " + liqidH[0] + " KJ/hr";
lblTest.Content = (double.Parse(vaporH[1]) - double.Parse(liqidH[1])).ToString() + " KJ/Kg";
}
private void importDataToDB()
{
try
{
DBRelief dbRelief = new DBRelief(dbFile);
DataSet dsStructure = dbRelief.getDataStructure();
DataTable dtEqType = dsStructure.Tables["eqtype"];
PRZReader przReader = new PRZReader(curprzFile);
DataSet ds = new DataSet();
ds = przReader.getDataFromFile();
dbRelief.importDataByDataTable(ds);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnOK_Click(object sender, RoutedEventArgs e)
{
dr["sinkname"] = txtName.Text;
dr["visiofile"] = vsdFile;
dr["description"] = txtDescription.Text;
dr["sinktype"] = cbxType.Text;
dr["maxpossiblepressure"] = txtMaxPressure.Text;
dr["ismaintained"] = chkIsMaintained.IsChecked;
getColor(ref dr, "sinkname_color", txtName);
getColor(ref dr, "sinktype_color", cbxType);
getColor(ref dr, "maxpossiblepressure_color", txtMaxPressure);
getColor(ref dr, "ismaintained_color", chkIsMaintained);
DBRelief dbR = new DBRelief(dbFile);
dbR.saveDataByRow(dr, op);
this.DialogResult = true;
}
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 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)
{
try
{
dr["equipment_no"] = this.txtEquipmentNO.Text.Trim();
dr["equipment_service"] = txtService.Text.Trim();
dr["equipment_location"] = txtLocation.Text.Trim();
dr["stream"] = cbxStream.Text.Trim();
dr["vessel_type"] = cbxVesselType.Text.Trim();
dr["number_of_identical_vessels"] = txtNumberOfIdentcalVessels.Text.Trim();
dr["diameter_identical_vessels"] = txtIVDiameter.Text.Trim();
dr["vessel_factor"] = txtIVFactor.Text.Trim();
dr["vessel_length"] = txtIVLength.Text.Trim();
dr["number_of_wetted_heads"] = txtNumberOfWettedHeads.Text.Trim();
dr["normal_liquid_level"] = txtNormalLiquidLevel.Text.Trim();
dr["fire_exposed_liquid_level"] = txtFireExposedLiquidLevel.Text.Trim();
dr["elevation_to_bottom"] = txtElevationtoBottom.Text.Trim();
dr["diameter_wetted_heads"] = txtWettedDiameter.Text.Trim();
dr["tt"] = txtTT.Text.Trim();
dr["heat_input"] = txtHeatInput.Text.Trim();
dr["c1"] = txtC1.Text.Trim();
dr["c2"] = txtC2.Text.Trim();
dr["c3"] = txtC3.Text.Trim();
dr["c4"] = txtC4.Text.Trim();
dr["c5"] = txtC5.Text.Trim();
dr["piping_inlet"] = txtInlet.Text.Trim();
dr["inlet_length"] = txtInletLength.Text.Trim();
dr["piping_outlet"] = this.txtOutLet.Text.Trim();
dr["outlet_length"] = this.txtOutLength.Text.Trim();
dr["piping_diameter"] = this.txtPipingDiameter.Text.Trim();
dr["wetted_area"] = this.txtWettedArea.Text.Trim();
dr["visiofile"] = vsdFile;
DBRelief dbR = new DBRelief(dbFile);
dbR.saveDataByRow(dr, op);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Action");
}
this.DialogResult = true;
}
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 btnOK_Click(object sender, RoutedEventArgs e)
{
try
{
string name = this.txtName.Text;
string temp = this.txtTemp.Text;
string press = this.txtPres.Text;
string wf = this.txtWf.Text;
string enthalpy = this.txtH.Text;
string spenthalpy = this.txtSph.Text;
string vf = this.txtVabFrac.Text;
dr["streamname"] = name;
dr["Temperature"] = temp;
dr["Pressure"] = press;
dr["Enthalpy"] = enthalpy;
dr["SpEnthalpy"] = spenthalpy;
dr["VaporFraction"] = vf;
dr["WeightFlow"] = wf;
dr["Description"] = txtDescription.Text;
dr["visiofile"] = vsdFile;
getColor(ref dr, "streamname_color", txtName);
getColor(ref dr, "Temperature_color", txtTemp);
getColor(ref dr, "Pressure_color", txtPres);
getColor(ref dr, "VaporFraction_color", txtVabFrac);
getColor(ref dr, "WeightFlow_color", txtWf);
getColor(ref dr, "Enthalpy_color", txtH);
getColor(ref dr, "SpEnthalpy_color", txtSph);
DBRelief dbr = new DBRelief(dbFile); //带参数，谨记
dbr.saveDataByRow(dr, op);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Action");
}
this.DialogResult = true;
}
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 backgroundWorker_DoWork(object sender, DoWorkEventArgs e)
{
try
{
dbRelief = new DBRelief(dbFile);
DataSet dsStructure = dbRelief.getDataStructure();
DataTable dtEqType = dsStructure.Tables["eqtype"];
dtEqList = dsStructure.Tables["eqlist"];
dtStream = dsStructure.Tables["stream"];
picker = new PRZPicker(curprzFile);
int total = picker.getAllEqAndStreamCount(dtEqType, ref eqList, ref streamList);
int eqCount = eqList.Count;
for (int i = 1; i <= eqList.Count; i++)
{
EqInfo eq = (EqInfo)eqList[i - 1];
picker.getEqInfo(eq.eqType, eq.eqName, ref dtEqList);
int percents = (i * 100) / total;
backgroundWorker.ReportProgress(percents, i);
}
for (int i = 1; i <= streamList.Count; i++)
{
picker.getSteamInfo(streamList[i - 1].ToString(), ref dtStream);
int percents = ((eqCount + i) * 100) / total;
backgroundWorker.ReportProgress(percents);
}
backgroundWorker.ReportProgress(100);
}
catch (Exception ex)
{
string lines = ex.ToString();
using (StreamWriter writer = new StreamWriter("log.txt", true))
{
writer.WriteLine(ex.ToString());
}
}
}
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 btnOK_Click(object sender, RoutedEventArgs e)
{
dr["accumulatorname"] = txtName.Text.Trim();
if (voH.IsChecked == true)
{
dr["orientation"] = voH.Content.ToString();
}
else
{
dr["orientation"] = voV.Content.ToString();
}
dr["diameter"] = this.txtDiameter.Text.Trim();
dr["length"] = this.txtLength.Text.Trim();
dr["numberofheads"] = this.txtNumberofHeads.Text.Trim();
dr["headratio"] = this.txtHeadRatio.Text.Trim();
dr["visiofile"] = vsdFile;
DBRelief dbR = new DBRelief(dbFile);
dbR.saveDataByRow(dr, op);
AccumulationName = txtName.Text.Trim();
this.DialogResult = true;
}
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();
}
}
}
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);
}
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;
}
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 CloseReader()
//{
//Marshal.FinalReleaseComObject(objCompCalc);
//GC.ReRegisterForFinalize(objCompCalc);
//Marshal.FinalReleaseComObject(cp2File);
//GC.ReRegisterForFinalize(cp2File);
// }
//复制塔的首层物流
public DataTable copyTray1Stream2(string columnName)
{
DBRelief dbR = new DBRelief();
DataTable dt = dbR.getStructure("stream");
string streamName = "TEMP" + Guid.NewGuid().ToString().Substring(0, 5).ToUpper();
CP2Object tempStream = (CP2Object)cp2File.CreateObject("Stream", streamName);
bool b = cp2File.CopyTrayToStream(columnName, 1, (p2Phase)2, 0, (p2TrayFlow)1, streamName);
string bb = b.ToString();
DataRow dr = dt.NewRow();
bool bCalulate = cp2File.CalculateStreamProps(streamName);
CP2Object compCalc = (CP2Object)cp2File.ActivateObject("CompCalc", "CompCalc");
object ComponentId = compCalc.GetAttribute("ComponentId");
if (ComponentId != null && ComponentId is Array)
{
dr["ComponentId"] = UnitConverter.convertData(ComponentId);
}
else
{
dr["ComponentId"] = ComponentId;
}
object CompIn = cp2File.GetObjectNames("CompIn");
if (CompIn != null && ComponentId is Array)
{
dr["CompIn"] = UnitConverter.convertData(CompIn);
}
else
{
dr["CompIn"] = CompIn;
}
dr["streamname"] = streamName;
dr["sourcefile"] = przFile;
dr["tray"] = 1;
dr["prodtype"] = 3;
CP2Object curStream = (CP2Object)cp2File.ActivateObject("Stream", streamName);
foreach (string s in arrStreamAttributes)
{
object v = curStream.GetAttribute(s);
if (v != null && v is Array)
{
dr[s] = UnitConverter.convertData(v);
}
else
{
dr[s] = v;
}
}
if (bCalulate)
{
CP2Object bulkDrop = (CP2Object)cp2File.ActivateObject("SrBulkProp", streamName);
foreach (string s in arrBulkPropAttributes)
{
object v = bulkDrop.GetAttribute(s);
if (v != null && v is Array)
{
dr[s] = UnitConverter.convertData(v);
}
else
{
dr[s] = v;
}
}
}
cp2File.DeleteObject("Stream", streamName);
dt.Rows.Add(dr);
//CloseReader();
//Marshal.FinalReleaseComObject(cp2Srv1);
//GC.ReRegisterForFinalize(cp2Srv1);
//Marshal.FinalReleaseComObject(tempStream);
//GC.ReRegisterForFinalize(tempStream);
// Marshal.FinalReleaseComObject(curStream);
// GC.ReRegisterForFinalize(curStream);
return(dt);
}
private void bindTowerInfo()
{
if (dsTower.Tables.Count > 0 && dsTower.Tables[0].Rows.Count > 0)
{
DataRow dr = dsTower.Tables[0].Rows[0];
txtName.Text = dr["eqname"].ToString();
//txtDescription.Text = dr["description"].ToString();
txtStageNumber.Text = dr["numberoftrays"].ToString();
DBRelief dbReader = new DBRelief(dbFile);
Dictionary <string, string> dicFeeds = new Dictionary <string, string>();
Dictionary <string, string> dicProducts = new Dictionary <string, string>();
dbReader.getMaincolumnRealFeedProduct(dr["eqname"].ToString(), ref dicFeeds, ref dicProducts);
DBRelief dbR = new DBRelief(dbFile);
foreach (KeyValuePair <string, string> feed in dicFeeds)
{
DataRow r = dtFeed.NewRow();
r["streamname"] = feed.Key;
r["tray"] = feed.Value;
r["visiofile"] = vsdFile;
dbR.getAndConvertStreamInfo(feed.Key, ref r);
dtFeed.Rows.Add(r);
DataRow rsource = dtSource.NewRow();
rsource["streamname"] = feed.Key;
rsource["sourcename"] = feed.Key + "_Source";
rsource["visiofile"] = vsdFile;
rsource["ismaintained"] = false;
rsource["sourcetype"] = "Pump（Motor）";
rsource["maxpossiblepressure"] = r["pressure"].ToString();
rsource["maxpossiblepressure_color"] = "green";
dtSource.Rows.Add(rsource);
}
foreach (KeyValuePair <string, string> prodcut in dicProducts)
{
DataRow r = dtProd.NewRow();
r["streamname"] = prodcut.Key;
r["tray"] = prodcut.Value;
r["visiofile"] = vsdFile;
dbR.getAndConvertStreamInfo(prodcut.Key, ref r);
dtProd.Rows.Add(r);
DataRow rsink = dtSink.NewRow();
rsink["streamname"] = prodcut.Key;
rsink["sinkname"] = prodcut.Key + "_Sink";
rsink["visiofile"] = vsdFile;
rsink["ismaintained"] = false;
rsink["sinktype"] = "Pump（Motor）";
rsink["maxpossiblepressure"] = r["pressure"].ToString();
rsink["maxpossiblepressure_color"] = "green";
dtSink.Rows.Add(rsink);
}
string heaterNames = dr["HeaterNames"].ToString();
string heaterDuties = dr["HeaterDuties"].ToString();
string heaterTrayLoc = dr["HeaterTrayLoc"].ToString();
string[] arrHeaterNames = heaterNames.Split(',');
string[] arrHeaterDuties = heaterDuties.Split(',');
string[] arrHeaterTrayLoc = heaterTrayLoc.Split(',');
for (int i = 0; i < arrHeaterNames.Length; i++)
{
decimal duty = decimal.Parse(arrHeaterDuties[i]) / 1000;
duty = decimal.Round(duty, 4);
if (arrHeaterNames[i] == "CONDENSER")
{
DataRow r = dtCondenser.NewRow();
r["heatername"] = arrHeaterNames[i];
r["heaterduty"] = duty;
r["visiofile"] = vsdFile;
r["water"] = duty;
r["waterfactor"] = 1;
r["ishx"] = false;
r["air"] = 0;
r["airfactor"] = 0;
r["wetair"] = 0;
r["wetairfactor"] = 0;
r["pumpabound"] = 0;
r["pumpaboundfactor"] = 0;
r["heatername_color"] = "green";
r["heaterduty_color"] = "green";
r["water_color"] = "green";
r["waterfactor_color"] = "green";
dtCondenser.Rows.Add(r);
}
else if (arrHeaterNames[i] == "REBOILER")
{
DataRow r = dtReboiler.NewRow();
r["heatername"] = arrHeaterNames[i];
r["heaterduty"] = duty;
r["visiofile"] = vsdFile;
r["steam"] = duty;
r["steamfactor"] = 1;
r["hotstream"] = 0;
r["hotstreamfactor"] = 0;
r["hotoil"] = 0;
r["hotoilfactor"] = 0;
r["furnace"] = 0;
r["furnacefactor"] = 0;
r["ishx"] = false;
r["iscontinued"] = false;
dtReboiler.Rows.Add(r);
}
else if (double.Parse(arrHeaterDuties[i]) <= 0 && arrHeaterNames[i] != "CONDENSER")
{
if (arrHeaterTrayLoc[i] == "1")
{
DataRow r = dtCondenser.NewRow();
r["heatername"] = arrHeaterNames[i];
r["heaterduty"] = duty;
r["visiofile"] = vsdFile;
r["water"] = duty;
r["waterfactor"] = 1;
r["ishx"] = false;
r["air"] = 0;
r["airfactor"] = 0;
r["wetair"] = 0;
r["wetairfactor"] = 0;
r["pumpabound"] = 0;
r["pumpaboundfactor"] = 0;
dtCondenser.Rows.Add(r);
}
else
{
DataRow r = dtHxCondenser.NewRow();
r["heatername"] = arrHeaterNames[i];
r["heaterduty"] = duty;
r["visiofile"] = vsdFile;
r["water"] = duty;
r["waterfactor"] = 1;
r["ishx"] = true;
r["air"] = 0;
r["airfactor"] = 0;
r["wetair"] = 0;
r["wetairfactor"] = 0;
r["pumpabound"] = 0;
r["pumpaboundfactor"] = 0;
dtHxCondenser.Rows.Add(r);
}
}
else if (double.Parse(arrHeaterDuties[i]) > 0 && arrHeaterNames[i] != "REBOILER")
{
if (arrHeaterTrayLoc[i] == dr["numberoftrays"].ToString())
{
DataRow r = dtReboiler.NewRow();
r["heatername"] = arrHeaterNames[i];
r["heaterduty"] = duty;
r["visiofile"] = vsdFile;
r["steam"] = duty;
r["steamfactor"] = 1;
r["ishx"] = false;
r["iscontinued"] = false;
r["hotstream"] = 0;
r["hotstreamfactor"] = 0;
r["hotoil"] = 0;
r["hotoilfactor"] = 0;
r["furnace"] = 0;
r["furnacefactor"] = 0;
dtReboiler.Rows.Add(r);
}
else
{
DataRow r = dtHxReboiler.NewRow();
r["heatername"] = arrHeaterNames[i];
r["heaterduty"] = duty;
r["visiofile"] = vsdFile;
r["steam"] = duty;
r["steamfactor"] = 1;
r["ishx"] = true;
r["iscontinued"] = false;
r["hotstream"] = 0;
r["hotstreamfactor"] = 0;
r["hotoil"] = 0;
r["hotoilfactor"] = 0;
r["furnace"] = 0;
r["furnacefactor"] = 0;
dtHxReboiler.Rows.Add(r);
}
}
}
}
dtFeed_init = dtFeed.Copy();
dtProd_init = dtProd.Copy();
dtCondenser_init = dtCondenser.Copy();
dtHxCondenser_init = dtHxCondenser.Copy();
dtReboiler_init = dtReboiler.Copy();
dtHxReboiler_init = dtHxReboiler.Copy();
}
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 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");
}
}
