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); }