public RW_STREAM getDataStream()
{
RW_STREAM stream = new RW_STREAM();
stream.AmineSolution = sheetStream[13];
stream.AqueousOperation = sheetStream[14] == "True" ? 1 : 0;
stream.AqueousShutdown = sheetStream[15] == "True" ? 1 : 0;
stream.ToxicConstituent = sheetStream[11] == "True" ? 1 : 0;
stream.Caustic = sheetStream[20] == "True" ? 1 : 0;
stream.Chloride = sheetStream[6] != "" ? float.Parse(sheetStream[6]) : 0;
stream.CO3Concentration = sheetStream[7] != "" ? float.Parse(sheetStream[7]) : 0;
stream.Cyanide = sheetStream[18] == "True" ? 1 : 0;
stream.ExposedToGasAmine = sheetStream[10] == "True" ? 1 : 0;
stream.ExposedToSulphur = sheetStream[21] == "True" ? 1 : 0;
stream.ExposureToAmine = sheetStream[12];
stream.H2S = sheetStream[16] == "True" ? 1 : 0;
stream.H2SInWater = sheetStream[8] != "" ? float.Parse(sheetStream[8]) : 0;
stream.Hydrogen = sheetStream[19] == "True" ? 1 : 0;
stream.MaterialExposedToClInt = sheetStream[22] == "True" ? 1 : 0;
stream.NaOHConcentration = sheetStream[4] != "" ? float.Parse(sheetStream[4]) : 0;
stream.ReleaseFluidPercentToxic = sheetStream[5] != "" ? float.Parse(sheetStream[5]) : 0;
stream.WaterpH = sheetStream[9] != "" ? float.Parse(sheetStream[9]) : 0;
stream.Hydrofluoric = sheetStream[17] == "True" ? 1 : 0;
return(stream);
}
private void getData(int ID)
{
RW_STREAM_BUS SteamBus = new RW_STREAM_BUS();
RW_EXTCOR_TEMPERATURE_BUS tempBus = new RW_EXTCOR_TEMPERATURE_BUS();
RW_STREAM objSteam = SteamBus.getData(ID);
RW_EXTCOR_TEMPERATURE extTemp = tempBus.getData(ID);
txtFlowRate.Text = objSteam.FlowRate.ToString();
txtMaxOperatingPressure.Text = objSteam.MaxOperatingPressure.ToString();
txtMinOperatingPressure.Text = objSteam.MinOperatingPressure.ToString();
txtMaximumOperatingTemp.Text = objSteam.MaxOperatingTemperature.ToString();
txtMinimumOperatingTemp.Text = objSteam.MinOperatingTemperature.ToString();
txtCriticalExposure.Text = objSteam.CriticalExposureTemperature.ToString();
txtOperatingHydrogen.Text = objSteam.H2SPartialPressure.ToString();
txtOp12.Text = extTemp.Minus12ToMinus8.ToString();
txtOp8.Text = extTemp.Minus8ToPlus6.ToString();
txtOp6.Text = extTemp.Plus6ToPlus32.ToString();
txtOp32.Text = extTemp.Plus32ToPlus71.ToString();
txtOp71.Text = extTemp.Plus71ToPlus107.ToString();
txtOp107.Text = extTemp.Plus107ToPlus121.ToString();
txtOp121.Text = extTemp.Plus121ToPlus135.ToString();
txtOp135.Text = extTemp.Plus135ToPlus162.ToString();
txtOp162.Text = extTemp.Plus162ToPlus176.ToString();
txtOp176.Text = extTemp.MoreThanPlus176.ToString();
}
public RW_STREAM getData2()
{
UCOperatingCondition ucOperating = new UCOperatingCondition();
RW_STREAM temp = new RW_STREAM();
temp = ucOperating.getData();
return(temp);
}
private void ShowDataToControl(int ID)
{
RW_STREAM_BUS SteamBus = new RW_STREAM_BUS();
RW_STREAM obj = SteamBus.getData(ID);
for (int i = 0; i < itemsAmineSolutionComposition.Length; i++)
{
if (obj.AmineSolution == itemsAmineSolutionComposition[i])
{
cbAmineSolutionComposition.SelectedIndex = i + 1;
break;
}
}
chkAqueousPhaseDuringOperation.Checked = Convert.ToBoolean(obj.AqueousOperation);
chkAqueousPhaseShutdown.Checked = Convert.ToBoolean(obj.AqueousShutdown);
chkEnvironmentContainsCaustic.Checked = Convert.ToBoolean(obj.Caustic);
txtChlorideIon.Text = obj.Chloride.ToString();
txtCO3ConcentrationWater.Text = obj.CO3Concentration.ToString();
chkPresenceCyanides.Checked = Convert.ToBoolean(obj.Cyanide);
chkExposedAcidGas.Checked = Convert.ToBoolean(obj.ExposedToGasAmine);
chkExposedSulphurBearing.Checked = Convert.ToBoolean(obj.ExposedToSulphur);
for (int i = 0; i < itemsExposureAmine.Length; i++)
{
if (obj.ExposureToAmine == itemsExposureAmine[i])
{
cbExposureAmine.SelectedIndex = i + 1;
break;
}
}
chkEnviromentContainsH2S.Checked = Convert.ToBoolean(obj.H2S);
txtH2SContent.Text = obj.H2SInWater.ToString();
chkPresenceHydrofluoricAcid.Checked = Convert.ToBoolean(obj.Hydrofluoric);
chkChlorine.Checked = Convert.ToBoolean(obj.MaterialExposedToClInt);
txtNaOHConcentration.Text = obj.NaOHConcentration.ToString();
txtReleaseFluidPercent.Text = obj.ReleaseFluidPercentToxic.ToString();
txtpHWater.Text = obj.WaterpH.ToString();
//tank
//for (int i = 0; i < itemsTankFluid.Length; i++)
//{
// if (obj.TankFluidName == itemsTankFluid[i])
// {
// cbFluidTank.SelectedIndex = i + 1;
// break;
// }
//}
txbModelFluid.Text = obj.TankFluidName;
txtFluidHeight.Text = obj.FluidHeight.ToString();
txtPercentageLeavingDike.Text = obj.FluidLeaveDikePercent.ToString();
txtPercentageLeavingRemainsOnSite.Text = obj.FluidLeaveDikeRemainOnSitePercent.ToString();
txtPercentageFluidGoingOffsite.Text = obj.FluidGoOffSitePercent.ToString();
}
public RW_STREAM getDataforStream(int ID)
{
RW_STREAM str = new RW_STREAM();
str.ID = ID;
str.FlowRate = txtFlowRate.Text != "" ? float.Parse(txtFlowRate.Text) : 0;
str.MaxOperatingPressure = txtMaxOperatingPressure.Text != "" ? float.Parse(txtMaxOperatingPressure.Text) : 0;
str.MinOperatingPressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) : 0;
str.MaxOperatingTemperature = txtMaximumOperatingTemp.Text != "" ? float.Parse(txtMaximumOperatingTemp.Text) : 0;
str.MinOperatingTemperature = txtMinimumOperatingTemp.Text != "" ? float.Parse(txtMinimumOperatingTemp.Text) : 0;
str.CriticalExposureTemperature = txtCriticalExposure.Text != "" ? float.Parse(txtCriticalExposure.Text) : 0;
str.H2SPartialPressure = txtOperatingHydrogen.Text != "" ? float.Parse(txtOperatingHydrogen.Text) : 0;
return(str);
}
public RW_STREAM getData(int ID)
{
RW_STREAM stream = new RW_STREAM();
RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS();
stream.ID = ID;
stream.AmineSolution = cbAmineSolutionComposition.Text;
stream.AqueousOperation = chkAqueousPhaseDuringOperation.Checked ? 1 : 0;
stream.AqueousShutdown = chkAqueousPhaseShutdown.Checked ? 1 : 0;
stream.ToxicConstituent = chkToxicConstituents.Checked ? 1 : 0;
stream.Caustic = chkEnvironmentContainsCaustic.Checked ? 1 : 0;
stream.Chloride = txtChlorideIon.Text != "" ? float.Parse(txtChlorideIon.Text) : 0;
stream.CO3Concentration = txtCO3ConcentrationWater.Text != "" ? float.Parse(txtCO3ConcentrationWater.Text) : 0;
stream.Cyanide = chkPresenceCyanides.Checked ? 1 : 0;
stream.ExposedToGasAmine = chkExposedAcidGas.Checked ? 1 : 0;
stream.ExposedToSulphur = chkExposedSulphurBearing.Checked ? 1 : 0;
stream.ExposureToAmine = cbExposureAmine.Text;
//stream.FlammableFluidID
//stream.FlowRate
stream.H2S = chkEnviromentContainsH2S.Checked ? 1 : 0;
stream.H2SInWater = txtH2SContentInWater.Text != "" ? float.Parse(txtH2SContentInWater.Text) : 0;
stream.Hydrogen = chkProcessContainsHydrogen.Checked ? 1 : 0;
//stream.H2SPartialPressure
stream.Hydrofluoric = chkPresenceHydrofluoricAcid.Checked ? 1 : 0;
stream.MaterialExposedToClInt = chkChlorine.Checked ? 1 : 0;
//stream.MaxOperatingPressure
//stream.MaxOperatingTemperature
//stream.MinOperatingPressure
//stream.MinOperatingTemperature
//stream.CriticalExposureTemperature
//stream.ModelFluidID
stream.NaOHConcentration = txtNaOHConcentration.Text != "" ? float.Parse(txtNaOHConcentration.Text) : 0;
//stream.NonFlameToxicFluidID
stream.ReleaseFluidPercentToxic = txtReleaseFluidPercent.Text != "" ? float.Parse(txtReleaseFluidPercent.Text) : 0;
//stream.StoragePhase
//stream.ToxicFluidID
stream.WaterpH = txtpHWater.Text != "" ? float.Parse(txtpHWater.Text) : 0;
//stream.TankFluidName
//stream.FluidHeight
//stream.FluidLeaveDikePercent
//stream.FluidLeaveDikeRemainOnSitePercent
//stream.FluidGoOffSitePercent
return(stream);
}
public void ShowDatatoControl(int ID)
{
RW_STREAM_BUS SteamBus = new RW_STREAM_BUS();
RW_STREAM obj = SteamBus.getData(ID);
for (int i = 0; i < itemsAmineSolutionComposition.Length; i++)
{
if (obj.AmineSolution == itemsAmineSolutionComposition[i])
{
cbAmineSolutionComposition.SelectedIndex = i + 1;
break;
}
}
chkAqueousPhaseDuringOperation.Checked = Convert.ToBoolean(obj.AqueousOperation);
chkAqueousPhaseShutdown.Checked = Convert.ToBoolean(obj.AqueousShutdown);
chkEnvironmentContainsCaustic.Checked = Convert.ToBoolean(obj.Caustic);
txtChlorideIon.Text = obj.Chloride.ToString();
txtCO3ConcentrationWater.Text = obj.CO3Concentration.ToString();
chkPresenceCyanides.Checked = Convert.ToBoolean(obj.Cyanide);
chkExposedAcidGas.Checked = Convert.ToBoolean(obj.ExposedToGasAmine);
chkExposedSulphurBearing.Checked = Convert.ToBoolean(obj.ExposedToSulphur);
for (int i = 0; i < itemsExposureAmine.Length; i++)
{
if (obj.ExposureToAmine == itemsExposureAmine[i])
{
cbExposureAmine.SelectedIndex = i + 1;
break;
}
}
chkEnviromentContainsH2S.Checked = Convert.ToBoolean(obj.H2S);
txtH2SContentInWater.Text = obj.H2SInWater.ToString();
chkProcessContainsHydrogen.Checked = Convert.ToBoolean(obj.Hydrogen);
chkPresenceHydrofluoricAcid.Checked = Convert.ToBoolean(obj.Hydrofluoric);
chkChlorine.Checked = Convert.ToBoolean(obj.MaterialExposedToClInt);
txtNaOHConcentration.Text = obj.NaOHConcentration.ToString();
txtpHWater.Text = obj.WaterpH.ToString();
txbModelFluid.Text = obj.TankFluidName;
txbToxicFluid.Text = obj.ToxicFluidName;
}
public RW_STREAM getDataOperating()
{
RW_STREAM str = new RW_STREAM();
str.FlowRate = sheetOperatingCondition[8] != "" ? float.Parse(sheetOperatingCondition[8]) : 0;
str.MaxOperatingPressure = sheetOperatingCondition[5] != "" ? float.Parse(sheetOperatingCondition[5]) : 0;
str.MinOperatingPressure = sheetOperatingCondition[6] != "" ? float.Parse(sheetOperatingCondition[6]) : 0;
str.MaxOperatingTemperature = sheetOperatingCondition[2] != "" ? float.Parse(sheetOperatingCondition[2]) : 0;
str.MinOperatingTemperature = sheetOperatingCondition[3] != "" ? float.Parse(sheetOperatingCondition[3]) : 0;
str.CriticalExposureTemperature = sheetOperatingCondition[4] != "" ? float.Parse(sheetOperatingCondition[4]) : 0;
str.H2SPartialPressure = sheetOperatingCondition[7] != "" ? float.Parse(sheetOperatingCondition[7]) : 0;
str.CUI_PERCENT_1 = sheetOperatingCondition[9] != "" ? float.Parse(sheetOperatingCondition[9]) : 0;
str.CUI_PERCENT_2 = sheetOperatingCondition[10] != "" ? float.Parse(sheetOperatingCondition[10]) : 0;
str.CUI_PERCENT_3 = sheetOperatingCondition[11] != "" ? float.Parse(sheetOperatingCondition[11]) : 0;
str.CUI_PERCENT_4 = sheetOperatingCondition[12] != "" ? float.Parse(sheetOperatingCondition[12]) : 0;
str.CUI_PERCENT_5 = sheetOperatingCondition[13] != "" ? float.Parse(sheetOperatingCondition[13]) : 0;
str.CUI_PERCENT_6 = sheetOperatingCondition[14] != "" ? float.Parse(sheetOperatingCondition[14]) : 0;
str.CUI_PERCENT_7 = sheetOperatingCondition[15] != "" ? float.Parse(sheetOperatingCondition[15]) : 0;
str.CUI_PERCENT_8 = sheetOperatingCondition[16] != "" ? float.Parse(sheetOperatingCondition[16]) : 0;
str.CUI_PERCENT_9 = sheetOperatingCondition[17] != "" ? float.Parse(sheetOperatingCondition[17]) : 0;
str.CUI_PERCENT_10 = sheetOperatingCondition[18] != "" ? float.Parse(sheetOperatingCondition[18]) : 0;
return(str);
}
private void ShowDataToForm(int ID, string temperatureUnit, string pressureUnit, string flowRateUnit)
{
RW_STREAM_BUS SteamBus = new RW_STREAM_BUS();
RW_EXTCOR_TEMPERATURE_BUS tempBus = new RW_EXTCOR_TEMPERATURE_BUS();
RW_STREAM objSteam = SteamBus.getData(ID);
RW_EXTCOR_TEMPERATURE extTemp = tempBus.getData(ID);
BUS_UNITS convUnit = new BUS_UNITS();
switch (temperatureUnit)
{
case "DEG_C":
txtMaximumOperatingTemp.Text = objSteam.MaxOperatingTemperature.ToString();
txtMinimumOperatingTemp.Text = objSteam.MinOperatingTemperature.ToString();
txtCriticalExposure.Text = objSteam.CriticalExposureTemperature.ToString();
break;
case "DEG_F":
txtMaximumOperatingTemp.Text = convUnit.CelToFah(objSteam.MaxOperatingTemperature).ToString();
txtMinimumOperatingTemp.Text = convUnit.CelToFah(objSteam.MinOperatingTemperature).ToString();
txtCriticalExposure.Text = convUnit.CelToFah(objSteam.CriticalExposureTemperature).ToString();
Console.WriteLine("Hha");
break;
case "K":
txtMaximumOperatingTemp.Text = convUnit.CelToKenvin(objSteam.MaxOperatingTemperature).ToString();
txtMinimumOperatingTemp.Text = convUnit.CelToKenvin(objSteam.MinOperatingTemperature).ToString();
txtCriticalExposure.Text = convUnit.CelToKenvin(objSteam.CriticalExposureTemperature).ToString();
break;
}
switch (pressureUnit)
{
case "psi":
txtMaxOperatingPressure.Text = objSteam.MaxOperatingPressure.ToString();
txtMinOperatingPressure.Text = objSteam.MinOperatingPressure.ToString();
txtOperatingHydrogen.Text = objSteam.H2SPartialPressure.ToString();
break;
case "KSI":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.ksi).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.ksi).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.ksi).ToString();
break;
case "bar":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.bar).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.bar).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.bar).ToString();
break;
case "MPa":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.MPa).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.MPa).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.MPa).ToString();
break;
case "N/m2":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.NpM2).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.NpM2).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.NpM2).ToString();
break;
case "N/cm2":
txtMaxOperatingPressure.Text = (objSteam.MaxOperatingPressure / convUnit.NpCM2).ToString();
txtMinOperatingPressure.Text = (objSteam.MinOperatingPressure / convUnit.NpCM2).ToString();
txtOperatingHydrogen.Text = (objSteam.H2SPartialPressure / convUnit.NpCM2).ToString();
break;
}
switch (flowRateUnit)
{
case "ft3/hr":
txtFlowRate.Text = (objSteam.FlowRate / convUnit.ft3).ToString();
break;
case "m3/hr":
txtFlowRate.Text = objSteam.FlowRate.ToString();
break;
}
txtOp12.Text = extTemp.Minus12ToMinus8.ToString();
txtOp8.Text = extTemp.Minus8ToPlus6.ToString();
txtOp6.Text = extTemp.Plus6ToPlus32.ToString();
txtOp32.Text = extTemp.Plus32ToPlus71.ToString();
txtOp71.Text = extTemp.Plus71ToPlus107.ToString();
txtOp107.Text = extTemp.Plus107ToPlus121.ToString();
txtOp121.Text = extTemp.Plus121ToPlus135.ToString();
txtOp135.Text = extTemp.Plus135ToPlus162.ToString();
txtOp162.Text = extTemp.Plus162ToPlus176.ToString();
txtOp176.Text = extTemp.MoreThanPlus176.ToString();
}
public RW_STREAM getDataforStream(int ID, string temperatureUnit, string pressureUnit, string flowRateUnit)
{
RW_STREAM str = new RW_STREAM();
BUS_UNITS convUnit = new BUS_UNITS();
str.ID = ID;
if (flowRateUnit == "m3/hr")
{
str.FlowRate = txtFlowRate.Text != "" ? float.Parse(txtFlowRate.Text) : 0;
}
else
{
str.FlowRate = txtFlowRate.Text != "" ? float.Parse(txtFlowRate.Text) * (float)convUnit.ft3 : 0;
}
switch (temperatureUnit)
{
case "DEG_C":
str.MaxOperatingTemperature = txtMaximumOperatingTemp.Text != "" ? float.Parse(txtMaximumOperatingTemp.Text) : 0;
str.MinOperatingTemperature = txtMinimumOperatingTemp.Text != "" ? float.Parse(txtMinimumOperatingTemp.Text) : 0;
str.CriticalExposureTemperature = txtCriticalExposure.Text != "" ? float.Parse(txtCriticalExposure.Text) : 0;
break;
case "DEG_F":
str.MaxOperatingTemperature = txtMaximumOperatingTemp.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtMaximumOperatingTemp.Text)) : 0;
str.MinOperatingTemperature = txtMinimumOperatingTemp.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtMinimumOperatingTemp.Text)) : 0;
str.CriticalExposureTemperature = txtCriticalExposure.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtCriticalExposure.Text)) : 0;
break;
case "K":
str.MaxOperatingTemperature = txtMaximumOperatingTemp.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtMaximumOperatingTemp.Text)) : 0;
str.MinOperatingTemperature = txtMinimumOperatingTemp.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtMinimumOperatingTemp.Text)) : 0;
str.CriticalExposureTemperature = txtCriticalExposure.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtCriticalExposure.Text)) : 0;
break;
}
switch (pressureUnit)
{
case "psi":
str.MaxOperatingPressure = txtMaxOperatingPressure.Text != "" ? float.Parse(txtMaxOperatingPressure.Text) : 0;
str.MinOperatingPressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) : 0;
str.H2SPartialPressure = txtOperatingHydrogen.Text != "" ? float.Parse(txtOperatingHydrogen.Text) : 0;
break;
case "KSI":
str.MaxOperatingPressure = txtMaxOperatingPressure.Text != "" ? float.Parse(txtMaxOperatingPressure.Text) * (float)convUnit.ksi : 0;
str.MinOperatingPressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.ksi : 0;
str.H2SPartialPressure = txtOperatingHydrogen.Text != "" ? float.Parse(txtOperatingHydrogen.Text) * (float)convUnit.ksi : 0;
break;
case "bar":
str.MaxOperatingPressure = txtMaxOperatingPressure.Text != "" ? float.Parse(txtMaxOperatingPressure.Text) * (float)convUnit.bar : 0;
str.MinOperatingPressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.bar : 0;
str.H2SPartialPressure = txtOperatingHydrogen.Text != "" ? float.Parse(txtOperatingHydrogen.Text) * (float)convUnit.bar : 0;
break;
case "MPa":
str.MaxOperatingPressure = txtMaxOperatingPressure.Text != "" ? float.Parse(txtMaxOperatingPressure.Text) * (float)convUnit.MPa : 0;
str.MinOperatingPressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.MPa : 0;
str.H2SPartialPressure = txtOperatingHydrogen.Text != "" ? float.Parse(txtOperatingHydrogen.Text) * (float)convUnit.MPa : 0;
break;
case "NpM2":
str.MaxOperatingPressure = txtMaxOperatingPressure.Text != "" ? float.Parse(txtMaxOperatingPressure.Text) * (float)convUnit.NpM2 : 0;
str.MinOperatingPressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.NpM2 : 0;
str.H2SPartialPressure = txtOperatingHydrogen.Text != "" ? float.Parse(txtOperatingHydrogen.Text) * (float)convUnit.NpM2 : 0;
break;
case "NpCM2":
str.MaxOperatingPressure = txtMaxOperatingPressure.Text != "" ? float.Parse(txtMaxOperatingPressure.Text) * (float)convUnit.NpCM2 : 0;
str.MinOperatingPressure = txtMinOperatingPressure.Text != "" ? float.Parse(txtMinOperatingPressure.Text) * (float)convUnit.NpCM2 : 0;
str.H2SPartialPressure = txtOperatingHydrogen.Text != "" ? float.Parse(txtOperatingHydrogen.Text) * (float)convUnit.NpCM2 : 0;
break;
}
return(str);
}
public RW_STREAM getData(int ID)
{
RW_STREAM obj = new RW_STREAM();
SqlConnection conn = MSSQLDBUtils.GetDBConnection();
conn.Open();
String sql = "USE [rbi]" +
"" +
"SELECT [ID]" +
",[AmineSolution]" +
",[AqueousOperation]" +
",[AqueousShutdown]" +
",[ToxicConstituent]" +
",[Caustic]" +
",[Chloride]" +
",[CO3Concentration]" +
",[Cyanide]" +
",[ExposedToGasAmine]" +
",[ExposedToSulphur]" +
",[ExposureToAmine]" +
",[FlammableFluidID]" +
",[FlowRate]" +
",[H2S]" +
",[H2SInWater]" +
",[Hydrogen]" +
",[H2SPartialPressure]" +
",[Hydrofluoric]" +
",[MaterialExposedToClInt]" +
",[MaxOperatingPressure]" +
",[MaxOperatingTemperature]" +
",[MinOperatingPressure]" +
",[MinOperatingTemperature]" +
",[CriticalExposureTemperature]" +
",[ModelFluidID]" +
",[NaOHConcentration]" +
",[NonFlameToxicFluidID]" +
",[ReleaseFluidPercentToxic]" +
",[StoragePhase]" +
",[ToxicFluidID]" +
",[WaterpH]" +
",[TankFluidName]" +
",[FluidHeight]" +
",[FluidLeaveDikePercent]" +
",[FluidLeaveDikeRemainOnSitePercent]" +
",[FluidGoOffSitePercent]" +
" FROM [rbi].[dbo].[RW_STREAM] WHERE [ID]='" + ID + "'" +
" ";
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader.HasRows)
{
obj.ID = reader.GetInt32(0);
if (!reader.IsDBNull(1))
{
obj.AmineSolution = reader.GetString(1);
}
obj.AqueousOperation = Convert.ToInt32(reader.GetBoolean(2));
obj.AqueousShutdown = Convert.ToInt32(reader.GetBoolean(3));
obj.ToxicConstituent = Convert.ToInt32(reader.GetBoolean(4));
obj.Caustic = Convert.ToInt32(reader.GetBoolean(5));
if (!reader.IsDBNull(6))
{
obj.Chloride = (float)reader.GetDouble(6);
}
if (!reader.IsDBNull(7))
{
obj.CO3Concentration = (float)reader.GetDouble(7);
}
obj.Cyanide = Convert.ToInt32(reader.GetBoolean(8));
obj.ExposedToGasAmine = Convert.ToInt32(reader.GetBoolean(9));
obj.ExposedToSulphur = Convert.ToInt32(reader.GetBoolean(10));
if (!reader.IsDBNull(11))
{
obj.ExposureToAmine = reader.GetString(11);
}
if (!reader.IsDBNull(12))
{
obj.FlammableFluidID = reader.GetInt32(12);
}
if (!reader.IsDBNull(13))
{
obj.FlowRate = (float)reader.GetDouble(13);
}
obj.H2S = Convert.ToInt32(reader.GetBoolean(14));
if (!reader.IsDBNull(15))
{
obj.H2SInWater = (float)reader.GetDouble(15);
}
obj.Hydrogen = Convert.ToInt32(reader.GetBoolean(16));
if (!reader.IsDBNull(17))
{
obj.H2SPartialPressure = (float)reader.GetDouble(17);
}
obj.Hydrofluoric = Convert.ToInt32(reader.GetBoolean(18));
obj.MaterialExposedToClInt = Convert.ToInt32(reader.GetBoolean(19));
if (!reader.IsDBNull(20))
{
obj.MaxOperatingPressure = (float)reader.GetDouble(20);
}
if (!reader.IsDBNull(21))
{
obj.MaxOperatingTemperature = (float)reader.GetDouble(21);
}
if (!reader.IsDBNull(22))
{
obj.MinOperatingPressure = (float)reader.GetDouble(22);
}
if (!reader.IsDBNull(23))
{
obj.MinOperatingTemperature = (float)reader.GetDouble(23);
}
if (!reader.IsDBNull(24))
{
obj.CriticalExposureTemperature = (float)reader.GetDouble(24);
}
if (!reader.IsDBNull(25))
{
obj.ModelFluidID = reader.GetInt32(25);
}
if (!reader.IsDBNull(26))
{
obj.NaOHConcentration = (float)reader.GetDouble(26);
}
if (!reader.IsDBNull(27))
{
obj.NonFlameToxicFluidID = reader.GetInt32(27);
}
if (!reader.IsDBNull(28))
{
obj.ReleaseFluidPercentToxic = (float)reader.GetDouble(28);
}
if (!reader.IsDBNull(29))
{
obj.StoragePhase = reader.GetString(29);
}
if (!reader.IsDBNull(30))
{
obj.ToxicFluidID = reader.GetInt32(30);
}
if (!reader.IsDBNull(31))
{
obj.WaterpH = (float)reader.GetDouble(31);
}
if (!reader.IsDBNull(32))
{
obj.TankFluidName = reader.GetString(32);
}
if (!reader.IsDBNull(33))
{
obj.FluidHeight = (float)reader.GetDouble(33);
}
if (!reader.IsDBNull(34))
{
obj.FluidLeaveDikePercent = (float)reader.GetDouble(34);
}
if (!reader.IsDBNull(35))
{
obj.FluidLeaveDikeRemainOnSitePercent = (float)reader.GetDouble(35);
}
if (!reader.IsDBNull(36))
{
obj.FluidGoOffSitePercent = (float)reader.GetDouble(36);
}
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "GET DATA FAIL!");
}
finally
{
conn.Close();
conn.Dispose();
}
return(obj);
}
public void delete(RW_STREAM obj)
{
DAL.delete(obj.ID);
}
public void edit(RW_STREAM obj)
{
DAL.edit(obj.ID, obj.AmineSolution, obj.AqueousOperation, obj.AqueousShutdown, obj.ToxicConstituent, obj.Caustic, obj.Chloride, obj.CO3Concentration, obj.Cyanide, obj.ExposedToGasAmine, obj.ExposedToSulphur, obj.ExposureToAmine, obj.FlammableFluidID, obj.FlowRate, obj.H2S, obj.H2SInWater, obj.Hydrogen, obj.H2SPartialPressure, obj.Hydrofluoric, obj.MaterialExposedToClInt, obj.MaxOperatingPressure, obj.MaxOperatingTemperature, obj.MinOperatingPressure, obj.MinOperatingTemperature, obj.CriticalExposureTemperature, obj.ModelFluidID, obj.NaOHConcentration, obj.NonFlameToxicFluidID, obj.ReleaseFluidPercentToxic, obj.StoragePhase, obj.ToxicFluidID, obj.WaterpH, obj.TankFluidName, obj.FluidHeight, obj.FluidLeaveDikeRemainOnSitePercent, obj.FluidLeaveDikePercent, obj.FluidGoOffSitePercent);
}
