public RW_COMPONENT getData(int ID) { RW_COMPONENT comp = new RW_COMPONENT(); RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS(); comp.ID = ID; comp.NominalDiameter = txtNominalDiameter.Text != "" ? float.Parse(txtNominalDiameter.Text) : 0; comp.NominalThickness = txtNominalThickness.Text != "" ? float.Parse(txtNominalThickness.Text) : 0; comp.CurrentThickness = txtCurrentThickness.Text != "" ? float.Parse(txtCurrentThickness.Text) : 0; comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? float.Parse(txtMinRequiredThickness.Text) : 0; comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? float.Parse(txtCurrentCorrosionRate.Text) : 0; comp.BranchDiameter = cbBranchDiameter.Text; comp.BranchJointType = cbJointTypeBranch.Text; comp.BrinnelHardness = cbMaxBrillnessHardness.Text; comp.CracksPresent = chkPresenceCracks.Checked ? 1 : 0; comp.ComplexityProtrusion = cbComplexityProtrusion.Text; comp.ChemicalInjection = chkPresenceInjectionMixPoint.Checked ? 1 : 0; comp.HighlyInjectionInsp = chkHighlyEffectiveMixPoint.Checked ? 1 : 0; comp.CorrectiveAction = cbCorrectiveAction.Text; comp.CyclicLoadingWitin15_25m = cbCyclicLoading.Text; comp.DamageFoundInspection = chkDamageFoundDuringInspection.Checked ? 1 : 0; comp.DeltaFATT = txtDeltaFATT.Text != "" ? float.Parse(txtDeltaFATT.Text) : 0; comp.NumberPipeFittings = cbNumberFittingPipe.Text; comp.PipeCondition = cbPipeCondition.Text; comp.PreviousFailures = cbPreviousFailures.Text; comp.ShakingAmount = cbAmountShakingPipe.Text; comp.ShakingDetected = chkVisibleAudible.Checked ? 1 : 0; comp.ShakingTime = cbAccumalatedTimeShakingPipe.Text; comp.TrampElements = chkTrampElements.Checked ? 1 : 0; //comp.ShellHeight cua shell //comp.ReleasePreventionBarrier = cua tank //comp.ConcreteFoundation = cua tank bottom //comp.SeverityOfVibration cua tank return(comp); }
public RW_COMPONENT getDataComponent() { RW_COMPONENT comp = new RW_COMPONENT(); comp.NominalDiameter = sheetComponent[10] == "" ? float.Parse(sheetComponent[10]) : 0; comp.NominalThickness = sheetComponent[11] == "" ? float.Parse(sheetComponent[11]) : 0; comp.CurrentThickness = sheetComponent[12] == "" ? float.Parse(sheetComponent[12]) : 0; comp.MinReqThickness = sheetComponent[13] == "" ? float.Parse(sheetComponent[13]) : 0; comp.CurrentCorrosionRate = sheetComponent[14] == "" ? float.Parse(sheetComponent[14]) : 0; comp.BranchDiameter = sheetComponent[24]; comp.BranchJointType = sheetComponent[25]; comp.BrinnelHardness = sheetComponent[21]; comp.CracksPresent = sheetComponent[17] == "True" ? 1 : 0; comp.ComplexityProtrusion = sheetComponent[22]; return(comp); }
private void ShowDataToControl(int ID) { RW_COMPONENT_BUS busCom = new RW_COMPONENT_BUS(); RW_COMPONENT com = busCom.getData(ID); txtTankDiameter.Text = com.NominalDiameter.ToString(); txtCurrentThickness.Text = com.CurrentThickness.ToString(); txtCurrentCorrosionRate.Text = com.CurrentCorrosionRate.ToString(); txtShellCourseHeight.Text = com.ShellHeight.ToString(); txtNominalThickness.Text = com.NominalThickness.ToString(); chkDamageFoundDuringInspection.Checked = com.DamageFoundInspection == 1 ? true : false; chkConcreteAsphalt.Checked = com.ConcreteFoundation == 1 ? true : false; chkPresenceCracks.Checked = com.CracksPresent == 1 ? true : false; chkPreventionBarrier.Checked = com.ReleasePreventionBarrier == 1 ? true : false; chkTrampElements.Checked = com.TrampElements == 1 ? true : false; txtMinRequiredThickness.Text = com.MinReqThickness.ToString(); for (int i = 0; i < itemsBrinnellHardness.Length; i++) { if (itemsBrinnellHardness[i] == com.BrinnelHardness) { cbMaxBrillnessHardness.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsComplexityProtrusion.Length; i++) { if (itemsComplexityProtrusion[i] == com.ComplexityProtrusion) { cbComplexityProtrusion.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsSeverity.Length; i++) { if (itemsSeverity[i] == com.SeverityOfVibration) { cbSeverityVibration.SelectedIndex = i + 1; break; } } }
public RW_COMPONENT getData(int ID) { RW_COMPONENT comp = new RW_COMPONENT(); comp.ID = ID; comp.NominalDiameter = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0; comp.NominalThickness = txtNominalThickness.Text != "" ? float.Parse(txtNominalThickness.Text) : 0; comp.CurrentThickness = txtCurrentThickness.Text != "" ? float.Parse(txtCurrentThickness.Text) : 0; comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? float.Parse(txtMinRequiredThickness.Text) : 0; comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? float.Parse(txtCurrentCorrosionRate.Text) : 0; comp.BrinnelHardness = cbMaxBrillnessHardness.Text; comp.SeverityOfVibration = cbSeverityVibration.Text; comp.ComplexityProtrusion = cbComplexityProtrusion.Text; comp.DamageFoundInspection = chkDamageFoundDuringInspection.Checked ? 1 : 0; comp.CracksPresent = chkPresenceCracks.Checked ? 1 : 0; comp.TrampElements = chkTrampElements.Checked ? 1 : 0; //kiem tra dieu kien API Component Type -> Disable control cua shell hoac cua bottom //tank Shell Course comp.ShellHeight = txtShellCourseHeight.Text != "" ? float.Parse(txtShellCourseHeight.Text) : 0; //tank bottom comp.ConcreteFoundation = chkConcreteAsphalt.Checked ? 1 : 0; comp.ReleasePreventionBarrier = chkPreventionBarrier.Checked ? 1 : 0; return(comp); }
public RW_COMPONENT getData(int ID) { RW_COMPONENT obj = new RW_COMPONENT(); SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] SELECT [NominalDiameter]" + ",[NominalThickness]" + ",[CurrentThickness]" + ",[MinReqThickness]" + ",[CurrentCorrosionRate]" + ",[BranchDiameter]" + ",[BranchJointType]" + ",[BrinnelHardness]" + ",[ChemicalInjection]" + ",[HighlyInjectionInsp]" + ",[ComplexityProtrusion]" + ",[CorrectiveAction]" + ",[CracksPresent]" + ",[CyclicLoadingWitin15_25m]" + ",[DamageFoundInspection]" + ",[DeltaFATT]" + ",[NumberPipeFittings]" + ",[PipeCondition]" + ",[PreviousFailures]" + ",[ShakingAmount]" + ",[ShakingDetected]" + ",[ShakingTime]" + ",[TrampElements]" + ",[ShellHeight]" + ",[ReleasePreventionBarrier]" + ",[ConcreteFoundation]" + ",[SeverityOfVibration]" + "FROM [rbi].[dbo].[RW_COMPONENT] 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.NominalDiameter = (float)reader.GetDouble(0); obj.NominalThickness = (float)reader.GetDouble(1); obj.CurrentThickness = (float)reader.GetDouble(2); obj.MinReqThickness = (float)reader.GetDouble(3); obj.CurrentCorrosionRate = (float)reader.GetDouble(4); obj.DamageFoundInspection = Convert.ToInt32(reader.GetBoolean(14)); obj.BrinnelHardness = reader.GetString(7); obj.CracksPresent = Convert.ToInt32(reader.GetBoolean(12)); obj.TrampElements = Convert.ToInt32(reader.GetBoolean(22)); obj.ShellHeight = (float)reader.GetDouble(23); obj.ReleasePreventionBarrier = Convert.ToInt32(reader.GetBoolean(24)); obj.ComplexityProtrusion = reader.GetString(10); obj.ConcreteFoundation = Convert.ToInt32(reader.GetBoolean(25)); obj.SeverityOfVibration = reader.GetString(26); } } } } catch (Exception ex) { MessageBox.Show("GET DATA FAIL!" + ex.ToString(), "ERROR!"); } finally { conn.Close(); conn.Dispose(); } return(obj); }
public List <RW_COMPONENT> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <RW_COMPONENT> list = new List <RW_COMPONENT>(); RW_COMPONENT obj = null; String sql = " Use [rbi] Select [ID]" + ",[NominalDiameter]" + ",[NominalThickness]" + ",[CurrentThickness]" + ",[MinReqThickness]" + ",[CurrentCorrosionRate]" + ",[BranchDiameter]" + ",[BranchJointType]" + ",[BrinnelHardness]" + ",[ChemicalInjection]" + ",[HighlyInjectionInsp]" + ",[ComplexityProtrusion]" + ",[CorrectiveAction]" + ",[CracksPresent]" + ",[CyclicLoadingWitin15_25m]" + ",[DamageFoundInspection]" + ",[DeltaFATT]" + ",[NumberPipeFittings]" + ",[PipeCondition]" + ",[PreviousFailures]" + ",[ShakingAmount]" + ",[ShakingDetected]" + ",[ShakingTime]" + ",[TrampElements]" + ",[ShellHeight]" + ",[ReleasePreventionBarrier]" + ",[ConcreteFoundation]" + ",[SeverityOfVibration]" + "From [dbo].[RW_COMPONENT] "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new RW_COMPONENT(); obj.ID = reader.GetInt32(0); if (!reader.IsDBNull(1)) { obj.NominalDiameter = (float)reader.GetDouble(1); } if (!reader.IsDBNull(2)) { obj.NominalThickness = (float)reader.GetDouble(2); } if (!reader.IsDBNull(3)) { obj.CurrentThickness = (float)reader.GetDouble(3); } if (!reader.IsDBNull(4)) { obj.MinReqThickness = (float)reader.GetDouble(4); } if (!reader.IsDBNull(5)) { obj.CurrentCorrosionRate = (float)reader.GetDouble(5); } if (!reader.IsDBNull(6)) { obj.BranchDiameter = reader.GetString(6); } if (!reader.IsDBNull(7)) { obj.BranchJointType = reader.GetString(7); } if (!reader.IsDBNull(8)) { obj.BrinnelHardness = reader.GetString(8); } obj.ChemicalInjection = Convert.ToInt32(reader.GetBoolean(9)); obj.HighlyInjectionInsp = Convert.ToInt32(reader.GetBoolean(10)); if (!reader.IsDBNull(11)) { obj.ComplexityProtrusion = reader.GetString(11); } if (!reader.IsDBNull(12)) { obj.CorrectiveAction = reader.GetString(12); } obj.CracksPresent = Convert.ToInt32(reader.GetBoolean(13)); if (!reader.IsDBNull(14)) { obj.CyclicLoadingWitin15_25m = reader.GetString(14); } obj.DamageFoundInspection = Convert.ToInt32(reader.GetBoolean(15)); if (!reader.IsDBNull(16)) { obj.DeltaFATT = (float)reader.GetDouble(16); } if (!reader.IsDBNull(17)) { obj.NumberPipeFittings = reader.GetString(17); } if (!reader.IsDBNull(18)) { obj.PipeCondition = reader.GetString(18); } if (!reader.IsDBNull(19)) { obj.PreviousFailures = reader.GetString(19); } if (!reader.IsDBNull(20)) { obj.ShakingAmount = reader.GetString(20); } obj.ShakingDetected = Convert.ToInt32(reader.GetBoolean(21)); if (!reader.IsDBNull(20)) { obj.ShakingTime = reader.GetString(22); } obj.TrampElements = Convert.ToInt32(reader.GetBoolean(23)); if (!reader.IsDBNull(24)) { obj.ShellHeight = (float)reader.GetDouble(24); } obj.ReleasePreventionBarrier = Convert.ToInt32(reader.GetBoolean(25)); obj.ConcreteFoundation = Convert.ToInt32(reader.GetBoolean(26)); if (!reader.IsDBNull(27)) { obj.SeverityOfVibration = reader.GetString(27); } list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(list); }
public void delete(RW_COMPONENT obj) { DAL.delete(obj.ID); }
public void edit(RW_COMPONENT obj) { DAL.edit(obj.ID, obj.NominalDiameter, obj.NominalThickness, obj.CurrentThickness, obj.MinReqThickness, obj.CurrentCorrosionRate, obj.BranchDiameter, obj.BranchJointType, obj.BrinnelHardness, obj.ChemicalInjection, obj.HighlyInjectionInsp, obj.ComplexityProtrusion, obj.CorrectiveAction, obj.CracksPresent, obj.CyclicLoadingWitin15_25m, obj.DamageFoundInspection, obj.DeltaFATT, obj.NumberPipeFittings, obj.PipeCondition, obj.PreviousFailures, obj.ShakingAmount, obj.ShakingDetected, obj.ShakingTime, obj.SeverityOfVibration, obj.ReleasePreventionBarrier, obj.ConcreteFoundation, obj.ShellHeight, obj.AllowableStress, obj.WeldJointEfficiency, obj.ComponentVolume, obj.ConfidenceCorrosionRate, obj.MinimumStructuralThicknessGoverns, obj.StructuralThickness, obj.CracksCurrentCondition, obj.FabricatedSteel, obj.EquipmentSatisfied, obj.NominalOperatingConditions, obj.CETGreaterOrEqual, obj.CyclicServiceFatigueVibration, obj.EquipmentCircuitShock, obj.HTHADamageObserved, obj.BrittleFractureThickness); }
public RW_COMPONENT getData(int ID) { RW_COMPONENT obj = new RW_COMPONENT(); SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] SELECT [NominalDiameter]" + ",[NominalThickness]" + ",[CurrentThickness]" + ",[MinReqThickness]" + ",[CurrentCorrosionRate]" + ",[BranchDiameter]" + ",[BranchJointType]" + ",[BrinnelHardness]" + ",[ChemicalInjection]" + ",[HighlyInjectionInsp]" + ",[ComplexityProtrusion]" + ",[CorrectiveAction]" + ",[CracksPresent]" + ",[CyclicLoadingWitin15_25m]" + ",[DamageFoundInspection]" + ",[DeltaFATT]" + ",[NumberPipeFittings]" + ",[PipeCondition]" + ",[PreviousFailures]" + ",[ShakingAmount]" + ",[ShakingDetected]" + ",[ShakingTime]" + ",[SeverityOfVibration]" + ",[ReleasePreventionBarrier]" + ",[ConcreteFoundation]" + ",[ShellHeight]" + ",[AllowableStress]" + ",[WeldJointEfficiency]" + ",[ComponentVolume]" + ",[ConfidenceCorrosionRate]" + ",[MinimumStructuralThicknessGoverns]" + ",[StructuralThickness]" + ",[CracksCurrentCondition]" + ",[FabricatedSteel]" + ",[EquipmentSatisfied]" + ",[NominalOperatingConditions]" + ",[CETGreaterOrEqual]" + ",[CyclicServiceFatigueVibration]" + ",[EquipmentCircuitShock]" + ",[HTHADamageObserved]" + ",[BrittleFractureThickness]" + "FROM [rbi].[dbo].[RW_COMPONENT] 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 = new RW_COMPONENT(); obj.ID = ID; if (!reader.IsDBNull(0)) { obj.NominalDiameter = (float)reader.GetDouble(0); } if (!reader.IsDBNull(1)) { obj.NominalThickness = (float)reader.GetDouble(1); } if (!reader.IsDBNull(2)) { obj.CurrentThickness = (float)reader.GetDouble(2); } if (!reader.IsDBNull(3)) { obj.MinReqThickness = (float)reader.GetDouble(3); } if (!reader.IsDBNull(4)) { obj.CurrentCorrosionRate = (float)reader.GetDouble(4); } if (!reader.IsDBNull(5)) { obj.BranchDiameter = reader.GetString(5); } if (!reader.IsDBNull(6)) { obj.BranchJointType = reader.GetString(6); } if (!reader.IsDBNull(7)) { obj.BrinnelHardness = reader.GetString(7); } obj.ChemicalInjection = Convert.ToInt32(reader.GetBoolean(8)); obj.HighlyInjectionInsp = Convert.ToInt32(reader.GetBoolean(9)); if (!reader.IsDBNull(10)) { obj.ComplexityProtrusion = reader.GetString(10); } if (!reader.IsDBNull(11)) { obj.CorrectiveAction = reader.GetString(11); } obj.CracksPresent = Convert.ToInt32(reader.GetBoolean(12)); if (!reader.IsDBNull(13)) { obj.CyclicLoadingWitin15_25m = reader.GetString(13); } obj.DamageFoundInspection = Convert.ToInt32(reader.GetBoolean(14)); if (!reader.IsDBNull(15)) { obj.DeltaFATT = (float)reader.GetDouble(15); } if (!reader.IsDBNull(16)) { obj.NumberPipeFittings = reader.GetString(16); } if (!reader.IsDBNull(17)) { obj.PipeCondition = reader.GetString(17); } if (!reader.IsDBNull(18)) { obj.PreviousFailures = reader.GetString(18); } if (!reader.IsDBNull(19)) { obj.ShakingAmount = reader.GetString(19); } obj.ShakingDetected = Convert.ToInt32(reader.GetBoolean(20)); if (!reader.IsDBNull(21)) { obj.ShakingTime = reader.GetString(21); } if (!reader.IsDBNull(22)) { obj.SeverityOfVibration = reader.GetString(22); } obj.ReleasePreventionBarrier = Convert.ToInt32(reader.GetBoolean(23)); obj.ConcreteFoundation = Convert.ToInt32(reader.GetBoolean(24)); if (!reader.IsDBNull(25)) { obj.ShellHeight = (float)reader.GetDouble(25); } if (!reader.IsDBNull(26)) { obj.AllowableStress = (float)reader.GetDouble(26); } if (!reader.IsDBNull(27)) { obj.WeldJointEfficiency = (float)reader.GetDouble(27); } if (!reader.IsDBNull(28)) { obj.ComponentVolume = (float)reader.GetDouble(28); } if (!reader.IsDBNull(29)) { obj.ConfidenceCorrosionRate = reader.GetString(29); } obj.MinimumStructuralThicknessGoverns = Convert.ToInt32(reader.GetBoolean(30)); if (!reader.IsDBNull(31)) { obj.StructuralThickness = (float)reader.GetDouble(31); } if (!reader.IsDBNull(32)) { obj.CracksCurrentCondition = reader.GetString(32); } obj.FabricatedSteel = Convert.ToInt32(reader.GetBoolean(33)); obj.EquipmentSatisfied = Convert.ToInt32(reader.GetBoolean(34)); obj.NominalOperatingConditions = Convert.ToInt32(reader.GetBoolean(35)); obj.CETGreaterOrEqual = Convert.ToInt32(reader.GetBoolean(36)); obj.CyclicServiceFatigueVibration = Convert.ToInt32(reader.GetBoolean(37)); obj.EquipmentCircuitShock = Convert.ToInt32(reader.GetBoolean(38)); obj.HTHADamageObserved = Convert.ToInt32(reader.GetBoolean(39)); obj.BrittleFractureThickness = (float)reader.GetDouble(40); } } } } catch (Exception ex) { MessageBox.Show("GET DATA FAIL!" + ex.ToString(), "ERROR!"); } finally { conn.Close(); conn.Dispose(); } return(obj); }
private void ShowDataToControl(int ID, string diameter, string thickness, string corrosionRate, string volumeUnit, string stressUnit) { RW_COMPONENT_BUS busCom = new RW_COMPONENT_BUS(); RW_COMPONENT comp = busCom.getData(ID); BUS_UNITS convUnit = new BUS_UNITS(); if (diameter == "INCH") { txtTankDiameter.Text = (comp.NominalDiameter / convUnit.inch).ToString(); // converst mm sang in } else if (diameter == "MM") { txtTankDiameter.Text = comp.NominalDiameter.ToString(); // giữ nguyên } if (thickness == "MM") { txtNominalThickness.Text = comp.NominalThickness.ToString(); //giữ nguyên txtMinRequiredThickness.Text = comp.MinReqThickness.ToString(); // giữ nguyên txtCurrentThickness.Text = comp.CurrentThickness.ToString(); txtBrittleFractureThickness.Text = comp.BrittleFractureThickness.ToString(); txtStructuralThickness.Text = comp.StructuralThickness.ToString(); } else if (thickness == "INCH") { txtNominalThickness.Text = (comp.NominalThickness / convUnit.inch).ToString(); //converst mm sang in txtMinRequiredThickness.Text = (comp.MinReqThickness / convUnit.inch).ToString(); //convert mm sang in txtCurrentThickness.Text = (comp.CurrentThickness / convUnit.inch).ToString(); txtBrittleFractureThickness.Text = (comp.BrittleFractureThickness / convUnit.inch).ToString(); txtStructuralThickness.Text = (comp.StructuralThickness / convUnit.inch).ToString(); } if (corrosionRate == "MMYR") { txtCurrentCorrosionRate.Text = comp.CurrentCorrosionRate.ToString(); // converst mm sang mm } else { txtCurrentCorrosionRate.Text = (comp.CurrentCorrosionRate / convUnit.mil).ToString(); // converst mm sang mil } if (stressUnit == "KSI") { txtAllowableStress.Text = (comp.AllowableStress / convUnit.ksi).ToString(); } else if (stressUnit == "PSI") { txtAllowableStress.Text = (comp.AllowableStress / convUnit.psi).ToString(); } else if (stressUnit == "MPA") { txtAllowableStress.Text = (comp.AllowableStress).ToString(); } else if (stressUnit == "BAR") { txtAllowableStress.Text = (comp.AllowableStress / convUnit.bar).ToString(); } else if (stressUnit == "NM2") { txtAllowableStress.Text = (comp.AllowableStress / convUnit.NpM2).ToString(); } else { txtAllowableStress.Text = (comp.AllowableStress / convUnit.NpCM2).ToString(); } if (volumeUnit == "M3") { txtComponentVolume.Text = comp.ComponentVolume.ToString(); } else { txtComponentVolume.Text = (comp.ComponentVolume / convUnit.ft3).ToString(); } chkConcreteAsphalt.Checked = comp.ConcreteFoundation == 1 ? true : false; chkPresenceCracks.Checked = comp.CracksPresent == 1 ? true : false; chkPreventionBarrier.Checked = comp.ReleasePreventionBarrier == 1 ? true : false; for (int i = 0; i < itemsBrinnellHardness.Length; i++) { if (itemsBrinnellHardness[i] == comp.BrinnelHardness) { cbMaxBrillnessHardness.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsComplexityProtrusion.Length; i++) { if (itemsComplexityProtrusion[i] == comp.ComplexityProtrusion) { cbComplexityProtrusion.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsSeverity.Length; i++) { if (itemsSeverity[i] == comp.SeverityOfVibration) { cbSeverityVibration.SelectedIndex = i + 1; break; } } }
public RW_COMPONENT getData(int ID, string diameter, string thickness, string corrosionRate, string volumeUnit, string stressUnit) { RW_COMPONENT comp = new RW_COMPONENT(); comp.ID = ID; BUS_UNITS convUnit = new BUS_UNITS(); //Generic Properties if (diameter == "MM") { comp.NominalDiameter = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0; } else if (diameter == "INCH") { comp.NominalDiameter = txtTankDiameter.Text != "" ? (float)(double.Parse(txtTankDiameter.Text) * convUnit.inch) : 0; // in sang mm } if (thickness == "MM") { comp.NominalThickness = txtNominalThickness.Text != "" ? float.Parse(txtNominalThickness.Text) : 0; comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? float.Parse(txtMinRequiredThickness.Text) : 0; comp.BrittleFractureThickness = txtBrittleFractureThickness.Text != "" ? float.Parse(txtBrittleFractureThickness.Text) : 0; comp.StructuralThickness = txtStructuralThickness.Text != "" ? float.Parse(txtStructuralThickness.Text) : 0; } else if (thickness == "INCH") { comp.NominalThickness = txtNominalThickness.Text != "" ? (float)(double.Parse(txtNominalThickness.Text) * convUnit.inch) : 0; // in sang mm comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? (float)(double.Parse(txtMinRequiredThickness.Text) * convUnit.inch) : 0; // in sang mm comp.BrittleFractureThickness = txtBrittleFractureThickness.Text != "" ? (float)(double.Parse(txtBrittleFractureThickness.Text) * convUnit.inch) : 0; comp.StructuralThickness = txtStructuralThickness.Text != "" ? (float)(double.Parse(txtStructuralThickness.Text) * convUnit.inch) : 0; } if (corrosionRate == "MMYR") { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)double.Parse(txtCurrentCorrosionRate.Text) : 0; } else { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)(double.Parse(txtCurrentCorrosionRate.Text) * convUnit.mil) : 0; // mil/yr sang mm/yr } if (volumeUnit == "M3") { comp.ComponentVolume = txtComponentVolume.Text != "" ? float.Parse(txtComponentVolume.Text) : 0; } else { comp.ComponentVolume = txtComponentVolume.Text != "" ? (float)(double.Parse(txtComponentVolume.Text) * convUnit.ft3) : 0; } if (stressUnit == "KSI") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.ksi) : 0; } else if (stressUnit == "PSI") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.psi) : 0; } else if (stressUnit == "MPA") { comp.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) : 0; } else if (stressUnit == "BAR") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.bar) : 0; } else if (stressUnit == "NM2") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.NpM2) : 0; } else { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.NpCM2) : 0; } comp.WeldJointEfficiency = txtWeldJointEfficiency.Text != "" ? float.Parse(txtWeldJointEfficiency.Text) : 0; comp.ConfidenceCorrosionRate = cbConfidenceCorrosionRate.Text; comp.CracksPresent = chkPresenceCracks.Checked ? 1 : 0; comp.MinimumStructuralThicknessGoverns = chkMinimumStructuralThicknessGoverns.Checked ? 1 : 0; //Governing Stress Corrosion Cracking Damage Factor comp.BrinnelHardness = cbMaxBrillnessHardness.Text; //Governing Brittle Fracture Damage Factor comp.FabricatedSteel = chkFabricatedSteel.Checked ? 1 : 0; comp.EquipmentSatisfied = chkEquipmentSatisfied.Checked ? 1 : 0; comp.NominalOperatingConditions = chkNominalOperatingConditions.Checked ? 1 : 0; comp.CETGreaterOrEqual = chkCETGreaterOrEqual.Checked ? 1 : 0; comp.CyclicServiceFatigueVibration = chkCyclicServiceFatigueVibration.Checked ? 1 : 0; comp.EquipmentCircuitShock = chkEquipmentCircuitShock.Checked ? 1 : 0; //Governing Fatigue Damage Factor comp.SeverityOfVibration = cbSeverityVibration.Text; //Governing External Damage Factor comp.ComplexityProtrusion = cbComplexityProtrusion.Text; //Tank Consequence of Falure comp.ConcreteFoundation = chkConcreteAsphalt.Checked ? 1 : 0; comp.ShellHeight = txtShellHeight.Text != "" ? float.Parse(txtShellHeight.Text) : 0; comp.ReleasePreventionBarrier = chkPreventionBarrier.Checked ? 1 : 0; return(comp); }
public RW_COMPONENT getData(int ID, string diameter, string thickness, string corrosionRate) // save vao base { RW_COMPONENT comp = new RW_COMPONENT(); RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS(); BUS_UNITS convUnit = new BUS_UNITS(); comp.ID = ID; // mai if (diameter == "mm") { comp.NominalDiameter = txtNominalDiameter.Text != "" ? float.Parse(txtNominalDiameter.Text) : 0; } else if (diameter == "in") { comp.NominalDiameter = txtNominalDiameter.Text != "" ? (float)(double.Parse(txtNominalDiameter.Text) * convUnit.inch) : 0; // in sang mm } else { comp.NominalDiameter = txtNominalDiameter.Text != "" ? float.Parse(txtNominalDiameter.Text) * 1000 : 0; // m sang mm } if (thickness == "mm") { comp.NominalThickness = txtNominalThickness.Text != "" ? float.Parse(txtNominalThickness.Text) : 0; comp.CurrentThickness = txtCurrentThickness.Text != "" ? float.Parse(txtCurrentThickness.Text) : 0; comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? float.Parse(txtMinRequiredThickness.Text) : 0; } else if (thickness == "in") { comp.NominalThickness = txtNominalThickness.Text != "" ? (float)(double.Parse(txtNominalThickness.Text) * convUnit.inch) : 0; // in sang mm comp.CurrentThickness = txtCurrentThickness.Text != "" ? (float)(double.Parse(txtCurrentThickness.Text) * convUnit.inch) : 0; // in sang mm comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? (float)(double.Parse(txtMinRequiredThickness.Text) * convUnit.inch) : 0; // in sang mm } else { comp.NominalThickness = txtNominalThickness.Text != "" ? (float)(double.Parse(txtNominalThickness.Text) * 1000) : 0; // m sang mm comp.CurrentThickness = txtCurrentThickness.Text != "" ? (float)(double.Parse(txtCurrentThickness.Text) * 1000) : 0; // m sang mm comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? (float)(double.Parse(txtMinRequiredThickness.Text) * 1000) : 0; // m sang mm } if (corrosionRate == "mm/yr") { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)double.Parse(txtCurrentCorrosionRate.Text) : 0; } else { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)(double.Parse(txtCurrentCorrosionRate.Text) * convUnit.mil) : 0; // mil/yr sang mm/yr } // end mai comp.BranchDiameter = cbBranchDiameter.Text; comp.BranchJointType = cbJointTypeBranch.Text; comp.BrinnelHardness = cbMaxBrillnessHardness.Text; comp.CracksPresent = chkPresenceCracks.Checked ? 1 : 0; comp.ComplexityProtrusion = cbComplexityProtrusion.Text; comp.ChemicalInjection = chkPresenceInjectionMixPoint.Checked ? 1 : 0; comp.HighlyInjectionInsp = chkHighlyEffectiveMixPoint.Checked ? 1 : 0; comp.CorrectiveAction = cbCorrectiveAction.Text; comp.CyclicLoadingWitin15_25m = cbCyclicLoading.Text; comp.DamageFoundInspection = chkDamageFoundDuringInspection.Checked ? 1 : 0; comp.DeltaFATT = txtDeltaFATT.Text != "" ? float.Parse(txtDeltaFATT.Text) : 0; comp.NumberPipeFittings = cbNumberFittingPipe.Text; comp.PipeCondition = cbPipeCondition.Text; comp.PreviousFailures = cbPreviousFailures.Text; comp.ShakingAmount = cbAmountShakingPipe.Text; comp.ShakingDetected = chkVisibleAudible.Checked ? 1 : 0; comp.ShakingTime = cbAccumalatedTimeShakingPipe.Text; comp.TrampElements = chkTrampElements.Checked ? 1 : 0; //comp.ShellHeight cua shell //comp.ReleasePreventionBarrier = cua tank //comp.ConcreteFoundation = cua tank bottom //comp.SeverityOfVibration cua tank return(comp); }
public RW_COMPONENT getData(int ID, string diameter, string thickness, string corrosionRate, string volumeUnit, string stressUnit) // save vao base { RW_COMPONENT comp = new RW_COMPONENT(); RW_ASSESSMENT_BUS assBus = new RW_ASSESSMENT_BUS(); BUS_UNITS convUnit = new BUS_UNITS(); comp.ID = ID; // Generic Properties if (diameter == "MM") { comp.NominalDiameter = txtNominalDiameter.Text != "" ? float.Parse(txtNominalDiameter.Text) : 0; } else if (diameter == "INCH") { comp.NominalDiameter = txtNominalDiameter.Text != "" ? (float)(double.Parse(txtNominalDiameter.Text) * convUnit.inch) : 0; // in sang mm } if (thickness == "MM") { comp.CurrentThickness = txtCurrentThickness.Text != "" ? float.Parse(txtCurrentThickness.Text) : 0; comp.NominalThickness = txtNominalThickness.Text != "" ? float.Parse(txtNominalThickness.Text) : 0; comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? float.Parse(txtMinRequiredThickness.Text) : 0; comp.BrittleFractureThickness = txtBrittleFractureThickness.Text != "" ? float.Parse(txtBrittleFractureThickness.Text) : 0; comp.StructuralThickness = txtStructuralThickness.Text != "" ? float.Parse(txtStructuralThickness.Text) : 0; } else if (thickness == "INCH") { comp.CurrentThickness = txtCurrentThickness.Text != "" ? (float)(double.Parse(txtCurrentThickness.Text) * convUnit.inch) : 0; comp.NominalThickness = txtNominalThickness.Text != "" ? (float)(double.Parse(txtNominalThickness.Text) * convUnit.inch) : 0; // in sang mm comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? (float)(double.Parse(txtMinRequiredThickness.Text) * convUnit.inch) : 0; // in sang mm comp.BrittleFractureThickness = txtBrittleFractureThickness.Text != "" ? (float)(double.Parse(txtBrittleFractureThickness.Text) * convUnit.inch) : 0; comp.StructuralThickness = txtStructuralThickness.Text != "" ? (float)(double.Parse(txtStructuralThickness.Text) * convUnit.inch) : 0; } if (corrosionRate == "MMYR") { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)double.Parse(txtCurrentCorrosionRate.Text) : 0; } else { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)(double.Parse(txtCurrentCorrosionRate.Text) * convUnit.mil) : 0; // mil/yr sang mm/yr } if (volumeUnit == "M3") { comp.ComponentVolume = txtComponentVolume.Text != "" ? float.Parse(txtComponentVolume.Text) : 0; } else { comp.ComponentVolume = txtComponentVolume.Text != "" ? (float)(double.Parse(txtComponentVolume.Text) * convUnit.ft3) : 0; } if (stressUnit == "KSI") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.ksi) : 0; } else if (stressUnit == "PSI") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.psi) : 0; } else if (stressUnit == "MPA") { comp.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) : 0; } else if (stressUnit == "BAR") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.bar) :0; } else if (stressUnit == "NM2") { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.NpM2) :0; } else { comp.AllowableStress = txtAllowableStress.Text != "" ? (float)(double.Parse(txtAllowableStress.Text) * convUnit.NpCM2) : 0; } comp.WeldJointEfficiency = txtWeldJointEfficiency.Text != "" ? float.Parse(txtWeldJointEfficiency.Text) : 0; comp.ConfidenceCorrosionRate = cbConfidenceCorrosionRate.Text; comp.CracksPresent = chkPresenceCracks.Checked ? 1 : 0; comp.MinimumStructuralThicknessGoverns = chkMinimumStructuralThicknessGoverns.Checked ? 1 : 0; //Governing Brittle Fracture Damage Factor comp.DeltaFATT = txtDeltaFATT.Text != "" ? float.Parse(txtDeltaFATT.Text) : 0; comp.FabricatedSteel = chkFabricatedSteel.Checked ? 1 : 0; comp.EquipmentSatisfied = chkEquipmentSatisfied.Checked ? 1 : 0; comp.NominalOperatingConditions = chkNominalOperating.Checked ? 1 : 0; comp.CETGreaterOrEqual = chkCETGreaterOrEqual.Checked ? 1 : 0; comp.CyclicServiceFatigueVibration = chkCyclicServiceFatigueVibration.Checked ? 1 : 0; comp.EquipmentCircuitShock = chkEquipmentCircuitShock.Checked ? 1 : 0; //High Temperatur Hydrogen Attack Damage Factor comp.HTHADamageObserved = chkHTHADamageObserved.Checked ? 1 : 0; //Governing Stress Corrosion Cracking Damage Factor comp.BrinnelHardness = cbMaxBrillnessHardness.Text; //Governing External Damage Factor comp.ComplexityProtrusion = cbComplexityProtrusion.Text; //Fatigue Damage Factor comp.BranchDiameter = cbBranchDiameter.Text; comp.BranchJointType = cbJointTypeBranch.Text; comp.CorrectiveAction = cbCorrectiveAction.Text; comp.CyclicLoadingWitin15_25m = cbCyclicLoading.Text; comp.NumberPipeFittings = cbNumberFittingPipe.Text; comp.PipeCondition = cbPipeCondition.Text; comp.PreviousFailures = cbPreviousFailures.Text; comp.ShakingAmount = cbAmountShakingPipe.Text; comp.ShakingDetected = chkVisibleAudible.Checked ? 1 : 0; comp.ShakingTime = cbAccumalatedTimeShakingPipe.Text; return(comp); }
public void edit(RW_COMPONENT obj) { DAL.edit(obj.ID, obj.NominalDiameter, obj.NominalThickness, obj.CurrentThickness, obj.MinReqThickness, obj.CurrentCorrosionRate, obj.BranchDiameter, obj.BranchJointType, obj.BrinnelHardness, obj.ChemicalInjection, obj.HighlyInjectionInsp, obj.ComplexityProtrusion, obj.CorrectiveAction, obj.CracksPresent, obj.CyclicLoadingWitin15_25m, obj.DamageFoundInspection, obj.DeltaFATT, obj.NumberPipeFittings, obj.PipeCondition, obj.PreviousFailures, obj.ShakingAmount, obj.ShakingDetected, obj.ShakingTime, obj.TrampElements, obj.ShellHeight, obj.ReleasePreventionBarrier, obj.ConcreteFoundation, obj.SeverityOfVibration); }
private void ShowDataToControl(int ID, string diameter, string thickness, string corrosionRate) { RW_COMPONENT_BUS busCom = new RW_COMPONENT_BUS(); RW_COMPONENT com = busCom.getData(ID); BUS_UNITS convUnit = new BUS_UNITS(); if (diameter == "in") { txtTankDiameter.Text = (com.NominalDiameter / convUnit.inch).ToString(); // converst mm sang in } else if (diameter == "mm") { txtTankDiameter.Text = com.NominalDiameter.ToString(); // giữ nguyên } else { txtTankDiameter.Text = (com.NominalDiameter / 1000).ToString(); // converst mm sang m } if (thickness == "mm") { txtNominalThickness.Text = com.NominalThickness.ToString(); //giữ nguyên txtCurrentThickness.Text = com.CurrentThickness.ToString(); // giữ nguyên txtMinRequiredThickness.Text = com.MinReqThickness.ToString(); // giữ nguyên } else if (thickness == "in") { txtNominalThickness.Text = (com.NominalThickness / convUnit.inch).ToString(); //converst mm sang in txtCurrentThickness.Text = (com.CurrentThickness / convUnit.inch).ToString(); //converst mm sang in txtMinRequiredThickness.Text = (com.MinReqThickness / convUnit.inch).ToString(); //converst mm sang in } else { txtNominalThickness.Text = (com.NominalThickness / 1000).ToString(); // converst mm sang m txtCurrentThickness.Text = (com.CurrentThickness / 1000).ToString(); // converst mm sang m txtMinRequiredThickness.Text = (com.MinReqThickness / 1000).ToString(); // converst mm sang m } if (corrosionRate == "mm/yr") { txtCurrentCorrosionRate.Text = com.CurrentCorrosionRate.ToString(); // converst mm sang mm } else { txtCurrentCorrosionRate.Text = (com.CurrentCorrosionRate / convUnit.mil).ToString(); // converst mm sang mil } txtShellCourseHeight.Text = com.ShellHeight.ToString(); chkDamageFoundDuringInspection.Checked = com.DamageFoundInspection == 1 ? true : false; chkConcreteAsphalt.Checked = com.ConcreteFoundation == 1 ? true : false; chkPresenceCracks.Checked = com.CracksPresent == 1 ? true : false; chkPreventionBarrier.Checked = com.ReleasePreventionBarrier == 1 ? true : false; chkTrampElements.Checked = com.TrampElements == 1 ? true : false; for (int i = 0; i < itemsBrinnellHardness.Length; i++) { if (itemsBrinnellHardness[i] == com.BrinnelHardness) { cbMaxBrillnessHardness.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsComplexityProtrusion.Length; i++) { if (itemsComplexityProtrusion[i] == com.ComplexityProtrusion) { cbComplexityProtrusion.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsSeverity.Length; i++) { if (itemsSeverity[i] == com.SeverityOfVibration) { cbSeverityVibration.SelectedIndex = i + 1; break; } } }
public RW_COMPONENT getData(int ID, string diameter, string thickness, string corrosionRate) { RW_COMPONENT comp = new RW_COMPONENT(); comp.ID = ID; BUS_UNITS convUnit = new BUS_UNITS(); if (diameter == "mm") { comp.NominalDiameter = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0; } else if (diameter == "in") { comp.NominalDiameter = txtTankDiameter.Text != "" ? (float)(double.Parse(txtTankDiameter.Text) * convUnit.inch) : 0; // in sang mm } else { comp.NominalDiameter = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) * 1000 : 0; // m sang mm } //comp.NominalDiameter = txtTankDiameter.Text != "" ? float.Parse(txtTankDiameter.Text) : 0; if (thickness == "mm") { comp.NominalThickness = txtNominalThickness.Text != "" ? float.Parse(txtNominalThickness.Text) : 0; comp.CurrentThickness = txtCurrentThickness.Text != "" ? float.Parse(txtCurrentThickness.Text) : 0; comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? float.Parse(txtMinRequiredThickness.Text) : 0; } else if (thickness == "in") { comp.NominalThickness = txtNominalThickness.Text != "" ? (float)(double.Parse(txtNominalThickness.Text) * convUnit.inch) : 0; // in sang mm comp.CurrentThickness = txtCurrentThickness.Text != "" ? (float)(double.Parse(txtCurrentThickness.Text) * convUnit.inch) : 0; // in sang mm comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? (float)(double.Parse(txtMinRequiredThickness.Text) * convUnit.inch) : 0; // in sang mm } else { comp.NominalThickness = txtNominalThickness.Text != "" ? (float)(double.Parse(txtNominalThickness.Text) * 1000) : 0; // m sang mm comp.CurrentThickness = txtCurrentThickness.Text != "" ? (float)(double.Parse(txtCurrentThickness.Text) * 1000) : 0; // m sang mm comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? (float)(double.Parse(txtMinRequiredThickness.Text) * 1000) : 0; // m sang mm } //comp.NominalThickness = txtNominalThickness.Text != "" ? float.Parse(txtNominalThickness.Text) : 0; //comp.CurrentThickness = txtCurrentThickness.Text != "" ? float.Parse(txtCurrentThickness.Text) : 0; //comp.MinReqThickness = txtMinRequiredThickness.Text != "" ? float.Parse(txtMinRequiredThickness.Text) : 0; if (corrosionRate == "mm/yr") { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)double.Parse(txtCurrentCorrosionRate.Text) : 0; } else { comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? (float)(double.Parse(txtCurrentCorrosionRate.Text) * convUnit.mil) : 0; // mil/yr sang mm/yr } //comp.CurrentCorrosionRate = txtCurrentCorrosionRate.Text != "" ? float.Parse(txtCurrentCorrosionRate.Text) : 0; comp.BrinnelHardness = cbMaxBrillnessHardness.Text; comp.SeverityOfVibration = cbSeverityVibration.Text; comp.ComplexityProtrusion = cbComplexityProtrusion.Text; comp.DamageFoundInspection = chkDamageFoundDuringInspection.Checked ? 1 : 0; comp.CracksPresent = chkPresenceCracks.Checked ? 1 : 0; comp.TrampElements = chkTrampElements.Checked ? 1 : 0; //kiem tra dieu kien API Component Type -> Disable control cua shell hoac cua bottom //tank Shell Course comp.ShellHeight = txtShellCourseHeight.Text != "" ? float.Parse(txtShellCourseHeight.Text) : 0; //tank bottom comp.ConcreteFoundation = chkConcreteAsphalt.Checked ? 1 : 0; comp.ReleasePreventionBarrier = chkPreventionBarrier.Checked ? 1 : 0; return(comp); }