public RW_EQUIPMENT getData1() { RW_EQUIPMENT eq = new RW_EQUIPMENT(); eq.CommissionDate = dateComissionDate.DateTime; return(eq); }
public RW_EQUIPMENT getData(int ID) { RW_EQUIPMENT eq = new RW_EQUIPMENT(); RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS(); eq.ID = ID; eq.AdminUpsetManagement = chkAministrativeControl.Checked ? 1 : 0; eq.ContainsDeadlegs = chkContainsDeadlegs.Checked ? 1 : 0; eq.CyclicOperation = chkCylicOperation.Checked ? 1 : 0; eq.HighlyDeadlegInsp = chkHighlyEffectiveInspection.Checked ? 1 : 0; eq.DowntimeProtectionUsed = chkDowntimeProtection.Checked ? 1 : 0; eq.ExternalEnvironment = cbExternalEnvironment.Text; eq.HeatTraced = chkHeatTraced.Checked ? 1 : 0; eq.InterfaceSoilWater = chkInterfaceSoilWater.Checked ? 1 : 0; eq.LinerOnlineMonitoring = chkLinerOnlineMonitoring.Checked ? 1 : 0; eq.MaterialExposedToClExt = chkMaterialExposedFluid.Checked ? 1 : 0; eq.MinReqTemperaturePressurisation = txtMinRequiredTemperature.Text != "" ? float.Parse(txtMinRequiredTemperature.Text) : 0; eq.OnlineMonitoring = cbOnlineMonitoring.Text; eq.PresenceSulphidesO2 = chkPresenceSulphideOperation.Checked ? 1 : 0; eq.PresenceSulphidesO2Shutdown = chkPresenceSulphideShutdown.Checked ? 1 : 0; eq.PressurisationControlled = chkPressurisationControlled.Checked ? 1 : 0; eq.PWHT = chkPWHT.Checked ? 1 : 0; eq.SteamOutWaterFlush = chkSteamedOutPriorWaterFlushing.Checked ? 1 : 0; eq.ManagementFactor = (float)numSystemManagementFactor.Value; eq.ThermalHistory = cbThermalHistory.Text; eq.YearLowestExpTemp = chkEquipmentOperatingManyYear.Checked ? 1 : 0; eq.Volume = txtEquipmentVolume.Text != "" ? float.Parse(txtEquipmentVolume.Text) : 0; //eq.CommissionDate = return(eq); }
public RW_EQUIPMENT getDataEquipment() { RW_EQUIPMENT eq = new RW_EQUIPMENT(); eq.AdminUpsetManagement = sheetEquipment[12] == "True" ? 1 : 0; eq.ContainsDeadlegs = sheetEquipment[13] == "True" ? 1 : 0; eq.CyclicOperation = sheetEquipment[15] == "True" ? 1 : 0; eq.HighlyDeadlegInsp = sheetEquipment[14] == "True" ? 1 : 0; eq.DowntimeProtectionUsed = sheetEquipment[16] == "True" ? 1 : 0; eq.ExternalEnvironment = sheetEquipment[28]; eq.HeatTraced = sheetEquipment[18] == "True" ? 1 : 0; eq.InterfaceSoilWater = sheetEquipment[20] == "True" ? 1 : 0; eq.LinerOnlineMonitoring = sheetEquipment[25] == "True" ? 1 : 0; eq.MaterialExposedToClExt = sheetEquipment[24] == "True" ? 1 : 0; eq.MinReqTemperaturePressurisation = sheetEquipment[22] != "" ? float.Parse(sheetEquipment[22]) : 0; eq.OnlineMonitoring = sheetEquipment[30]; eq.PresenceSulphidesO2 = sheetEquipment[26] == "True" ? 1 : 0; eq.PresenceSulphidesO2Shutdown = sheetEquipment[27] == "True" ? 1 : 0; eq.PressurisationControlled = sheetEquipment[21] == "True" ? 1 : 0; eq.PWHT = sheetEquipment[19] == "True" ? 1 : 0; eq.SteamOutWaterFlush = sheetEquipment[17] == "True" ? 1 : 0; eq.ManagementFactor = sheetEquipment[32] != "" ? float.Parse(sheetEquipment[32]) : 0; eq.ThermalHistory = sheetEquipment[29]; eq.YearLowestExpTemp = sheetEquipment[23] == "True" ? 1 : 0; eq.Volume = sheetEquipment[31] != "" ? float.Parse(sheetEquipment[31]) : 0; eq.CommissionDate = Convert.ToDateTime(sheetEquipment[8]); Debug.WriteLine("commission date " + eq.CommissionDate); return(eq); }
public RW_EQUIPMENT getData(int ID) { RW_EQUIPMENT eq = new RW_EQUIPMENT(); eq.ID = ID; eq.AdminUpsetManagement = chkAministrativeControl.Checked ? 1 : 0; eq.CyclicOperation = chkCylicOperation.Checked ? 1 : 0; eq.DowntimeProtectionUsed = chkDowntimeProtection.Checked ? 1 : 0; eq.ExternalEnvironment = cbAdjustmentSettlement.Text; eq.HeatTraced = chkHeatTraced.Checked ? 1 : 0; eq.InterfaceSoilWater = chkInterfaceSoilWater.Checked ? 1 : 0; eq.LinerOnlineMonitoring = chkLinerOnlineMonitoring.Checked ? 1 : 0; eq.MaterialExposedToClExt = chkMaterialExposedFluid.Checked ? 1 : 0; eq.MinReqTemperaturePressurisation = txtMinRequiredTemperature.Text != "" ? float.Parse(txtMinRequiredTemperature.Text) : 0; eq.OnlineMonitoring = cbOnlineMonitoring.Text; eq.PresenceSulphidesO2 = chkPresenceSulphideOperation.Checked ? 1 : 0; eq.PresenceSulphidesO2Shutdown = chkPresenceSulphideShutdown.Checked ? 1 : 0; eq.PressurisationControlled = chkPressurisationControlled.Checked ? 1 : 0; eq.PWHT = chkPWHT.Checked ? 1 : 0; eq.SteamOutWaterFlush = chkSteamedOutPriorWaterFlushing.Checked ? 1 : 0; eq.ManagementFactor = (float)numSystemManagementFactor.Value; eq.ThermalHistory = cbThermalHistory.Text; eq.YearLowestExpTemp = chkEquipmentOperatingManyYear.Checked ? 1 : 0; eq.Volume = txtEquipmentVolume.Text != "" ? float.Parse(txtEquipmentVolume.Text) : 0; eq.TypeOfSoil = cbTypeSoild.Text; eq.EnvironmentSensitivity = cbEnvironmentalSensitivity.Text; eq.AdjustmentSettle = cbAdjustmentSettlement.Text; eq.ComponentIsWelded = chkComponentWelded.Checked ? 1 : 0; eq.TankIsMaintained = chkTankMaintainedAccordance.Checked ? 1 : 0; //tank shell //tank bottom eq.DistanceToGroundWater = txtDistanceGroundWater.Text != "" ? float.Parse(txtDistanceGroundWater.Text) : 0; return(eq); }
public RW_EQUIPMENT getData(int ID, string temUnit, string volUnit) { RW_EQUIPMENT eq = new RW_EQUIPMENT(); RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS(); BUS_UNITS convUnit = new BUS_UNITS(); eq.ID = ID; eq.AdminUpsetManagement = chkAministrativeControl.Checked ? 1 : 0; eq.ContainsDeadlegs = chkContainsDeadlegs.Checked ? 1 : 0; eq.CyclicOperation = chkCylicOperation.Checked ? 1 : 0; eq.HighlyDeadlegInsp = chkHighlyEffectiveInspection.Checked ? 1 : 0; eq.DowntimeProtectionUsed = chkDowntimeProtection.Checked ? 1 : 0; eq.ExternalEnvironment = cbExternalEnvironment.Text; eq.HeatTraced = chkHeatTraced.Checked ? 1 : 0; eq.InterfaceSoilWater = chkInterfaceSoilWater.Checked ? 1 : 0; eq.LinerOnlineMonitoring = chkLinerOnlineMonitoring.Checked ? 1 : 0; eq.MaterialExposedToClExt = chkMaterialExposedFluid.Checked ? 1 : 0; double minReqTem = 0; if (temUnit == "DEG_C") { minReqTem = txtMinRequiredTemperature.Text != "" ? double.Parse(txtMinRequiredTemperature.Text) : 0; } else if (temUnit == "DEG_F") { minReqTem = txtMinRequiredTemperature.Text != "" ? convUnit.FahToCel(double.Parse(txtMinRequiredTemperature.Text)) : 0; // mai } else { minReqTem = txtMinRequiredTemperature.Text != "" ? convUnit.KenvinToCel(double.Parse(txtMinRequiredTemperature.Text)) : 0; // mai } eq.MinReqTemperaturePressurisation = (float)minReqTem; eq.OnlineMonitoring = cbOnlineMonitoring.Text; eq.PresenceSulphidesO2 = chkPresenceSulphideOperation.Checked ? 1 : 0; eq.PresenceSulphidesO2Shutdown = chkPresenceSulphideShutdown.Checked ? 1 : 0; eq.PressurisationControlled = chkPressurisationControlled.Checked ? 1 : 0; eq.PWHT = chkPWHT.Checked ? 1 : 0; eq.SteamOutWaterFlush = chkSteamedOutPriorWaterFlushing.Checked ? 1 : 0; int equipmentID = assBus.getEquipmentID(ID); float FMS = busFacility.getFMS(busEquipmentMaster.getFacilityID(equipmentID)); eq.ManagementFactor = FMS; eq.ThermalHistory = cbThermalHistory.Text; eq.YearLowestExpTemp = chkEquipmentOperatingManyYear.Checked ? 1 : 0; double equipVolume = 0; if (volUnit == "m3") { equipVolume = txtEquipmentVolume.Text != "" ? float.Parse(txtEquipmentVolume.Text) : 0; } else { equipVolume = txtMinRequiredTemperature.Text != "" ? (float.Parse(txtEquipmentVolume.Text) * convUnit.ft3) : 0; // mai } eq.Volume = (float)equipVolume; //eq.CommissionDate = return(eq); }
public RW_EQUIPMENT getdata(int ID) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); RW_EQUIPMENT obj = new RW_EQUIPMENT(); String sql = "Use[rbi] Select[ID]" + ",[CommissionDate]" + ",[AdminUpsetManagement]" + ",[ContainsDeadlegs]" + ",[CyclicOperation]" + ",[HighlyDeadlegInsp]" + ",[DowntimeProtectionUsed]" + ",[ExternalEnvironment]" + ",[HeatTraced]" + ",[InterfaceSoilWater]" + ",[LinerOnlineMonitoring]" + ",[MaterialExposedToClExt]" + ",[MinReqTemperaturePressurisation]" + ",[OnlineMonitoring]" + ",[PresenceSulphidesO2]" + ",[PresenceSulphidesO2Shutdown]" + ",[PressurisationControlled]" + ",[PWHT]" + ",[SteamOutWaterFlush]" + ",[ManagementFactor]" + ",[ThermalHistory]" + ",[YearLowestExpTemp]" + ",[Volume]" + ",[TypeOfSoil]" + ",[EnvironmentSensitivity]" + ",[DistanceToGroundWater]" + ",[AdjustmentSettle]" + ",[ComponentIsWelded]" + ",[TankIsMaintained]" + "From [dbo].[RW_EQUIPMENT] 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); obj.CommissionDate = reader.GetDateTime(1); obj.AdminUpsetManagement = Convert.ToInt32(reader.GetBoolean(2)); obj.ContainsDeadlegs = Convert.ToInt32(reader.GetBoolean(3)); obj.CyclicOperation = Convert.ToInt32(reader.GetBoolean(4)); obj.HighlyDeadlegInsp = Convert.ToInt32(reader.GetBoolean(5)); obj.DowntimeProtectionUsed = Convert.ToInt32(reader.GetBoolean(6)); if (!reader.IsDBNull(7)) { obj.ExternalEnvironment = reader.GetString(7); } obj.HeatTraced = Convert.ToInt32(reader.GetBoolean(8)); obj.InterfaceSoilWater = Convert.ToInt32(reader.GetBoolean(9)); obj.LinerOnlineMonitoring = Convert.ToInt32(reader.GetBoolean(10)); obj.MaterialExposedToClExt = Convert.ToInt32(reader.GetBoolean(11)); if (!reader.IsDBNull(12)) { obj.MinReqTemperaturePressurisation = (float)reader.GetDouble(12); } if (!reader.IsDBNull(13)) { obj.OnlineMonitoring = reader.GetString(13); } obj.PresenceSulphidesO2 = Convert.ToInt32(reader.GetBoolean(14)); obj.PresenceSulphidesO2Shutdown = Convert.ToInt32(reader.GetBoolean(15)); obj.PressurisationControlled = Convert.ToInt32(reader.GetBoolean(16)); obj.PWHT = Convert.ToInt32(reader.GetBoolean(17)); obj.SteamOutWaterFlush = Convert.ToInt32(reader.GetBoolean(18)); if (!reader.IsDBNull(19)) { obj.ManagementFactor = (float)reader.GetDouble(19); } if (!reader.IsDBNull(20)) { obj.ThermalHistory = reader.GetString(20); } obj.YearLowestExpTemp = Convert.ToInt32(reader.GetBoolean(21)); if (!reader.IsDBNull(22)) { obj.Volume = (float)reader.GetDouble(22); } if (!reader.IsDBNull(23)) { obj.TypeOfSoil = reader.GetString(23); } if (!reader.IsDBNull(24)) { obj.EnvironmentSensitivity = reader.GetString(24); } if (!reader.IsDBNull(25)) { obj.DistanceToGroundWater = (float)reader.GetDouble(25); } if (!reader.IsDBNull(26)) { obj.AdjustmentSettle = reader.GetString(26); } obj.ComponentIsWelded = Convert.ToInt32(reader.GetBoolean(27)); obj.TankIsMaintained = Convert.ToInt32(reader.GetBoolean(28)); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL"); } finally { conn.Close(); } return(obj); }
public void delete(RW_EQUIPMENT obj) { DAL.delete(obj.ID); }
public void edit(RW_EQUIPMENT obj) { DAL.edit(obj.ID, obj.AdminUpsetManagement, obj.ContainsDeadlegs, obj.CyclicOperation, obj.HighlyDeadlegInsp, obj.DowntimeProtectionUsed, obj.ExternalEnvironment, obj.HeatTraced, obj.InterfaceSoilWater, obj.LinerOnlineMonitoring, obj.MaterialExposedToClExt, obj.MinReqTemperaturePressurisation, obj.OnlineMonitoring, obj.PresenceSulphidesO2, obj.PresenceSulphidesO2Shutdown, obj.PressurisationControlled, obj.PWHT, obj.SteamOutWaterFlush, obj.ManagementFactor, obj.ThermalHistory, obj.YearLowestExpTemp, obj.Volume, obj.TypeOfSoil, obj.EnvironmentSensitivity, obj.DistanceToGroundWater, obj.AdjustmentSettle, obj.ComponentIsWelded, obj.TankIsMaintained); }
public void ShowDataToControl(int ID, string temUnit, string volumeUnit) { RW_EQUIPMENT_BUS bus = new RW_EQUIPMENT_BUS(); RW_EQUIPMENT eq = bus.getData(ID); chkAministrativeControl.Checked = Convert.ToBoolean(eq.AdminUpsetManagement); chkCylicOperation.Checked = Convert.ToBoolean(eq.CyclicOperation); chkDowntimeProtection.Checked = Convert.ToBoolean(eq.DowntimeProtectionUsed); for (int i = 0; i < itemsAdjustmentSettlement.Length; i++) { if (eq.ExternalEnvironment == itemsAdjustmentSettlement[i]) { cbAdjustmentSettlement.SelectedIndex = i + 1; break; } } chkHeatTraced.Checked = Convert.ToBoolean(eq.HeatTraced); chkInterfaceSoilWater.Checked = Convert.ToBoolean(eq.InterfaceSoilWater); chkLinerOnlineMonitoring.Checked = Convert.ToBoolean(eq.LinerOnlineMonitoring); chkMaterialExposedFluid.Checked = Convert.ToBoolean(eq.MaterialExposedToClExt); if (temUnit == "DEG_C") { txtMinRequiredTemperature.Text = eq.MinReqTemperaturePressurisation.ToString(); } else if (temUnit == "DEG_F") { txtMinRequiredTemperature.Text = (convUnit.CelToFah(eq.MinReqTemperaturePressurisation)).ToString(); // mai } else { txtMinRequiredTemperature.Text = (convUnit.CelToKenvin(eq.MinReqTemperaturePressurisation)).ToString(); // mai } for (int i = 0; i < itemsOnlineMonitoring.Length; i++) { if (eq.OnlineMonitoring == itemsOnlineMonitoring[i]) { cbOnlineMonitoring.SelectedIndex = i + 1; break; } } chkPresenceSulphideOperation.Checked = Convert.ToBoolean(eq.PresenceSulphidesO2); chkPresenceSulphideShutdown.Checked = Convert.ToBoolean(eq.PresenceSulphidesO2Shutdown); chkPressurisationControlled.Checked = Convert.ToBoolean(eq.PressurisationControlled); chkPWHT.Checked = Convert.ToBoolean(eq.PWHT); chkSteamedOutPriorWaterFlushing.Checked = Convert.ToBoolean(eq.SteamOutWaterFlush); numSystemManagementFactor.Value = (decimal)eq.ManagementFactor; for (int i = 0; i < itemsThermalHistory.Length; i++) { if (eq.ThermalHistory == itemsThermalHistory[i]) { cbThermalHistory.SelectedIndex = i + 1; break; } } chkEquipmentOperatingManyYear.Checked = Convert.ToBoolean(eq.YearLowestExpTemp); if (volumeUnit == "m3") { txtEquipmentVolume.Text = eq.Volume.ToString(); //mai } else if (volumeUnit == "ft3") { txtEquipmentVolume.Text = (eq.Volume / convUnit.ft3).ToString(); // mai } for (int i = 0; i < itemsExternalEnvironment.Length; i++) { if (eq.ExternalEnvironment == itemsExternalEnvironment[i]) { cbExternalEnviroment.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsTypeSoil.Length; i++) { if (eq.TypeOfSoil == itemsTypeSoil[i]) { cbTypeSoild.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsEnvironmental.Length; i++) { if (eq.EnvironmentSensitivity == itemsEnvironmental[i]) { cbEnvironmentalSensitivity.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsAdjustmentSettlement.Length; i++) { if (eq.AdjustmentSettle == itemsAdjustmentSettlement[i]) { cbAdjustmentSettlement.SelectedIndex = i + 1; break; } } chkComponentWelded.Checked = Convert.ToBoolean(eq.ComponentIsWelded); chkTankMaintainedAccordance.Checked = Convert.ToBoolean(eq.TankIsMaintained); txtDistanceGroundWater.Text = eq.DistanceToGroundWater.ToString(); }