public RW_MATERIAL getDataMaterial() { RW_MATERIAL ma = new RW_MATERIAL(); ma.MaterialName = sheetMaterial[1]; ma.DesignPressure = sheetMaterial[2] != "" ? float.Parse(sheetMaterial[2]) : 0; ma.DesignTemperature = sheetMaterial[3] != "" ? float.Parse(sheetMaterial[3]) : 0; ma.MinDesignTemperature = sheetMaterial[4] != "" ? float.Parse(sheetMaterial[4]) : 0; ma.BrittleFractureThickness = sheetMaterial[6] != "" ? float.Parse(sheetMaterial[6]) : 0; ma.CorrosionAllowance = sheetMaterial[8] != "" ? float.Parse(sheetMaterial[8]) : 0; //if(tankBottom) -> hide txtSigmaPhase ma.SigmaPhase = sheetMaterial[9] != "" ? float.Parse(sheetMaterial[8]) : 0; ma.SulfurContent = sheetMaterial[15]; ma.HeatTreatment = sheetMaterial[16]; ma.ReferenceTemperature = sheetMaterial[5] != "" ? float.Parse(sheetMaterial[5]) : 0; ma.PTAMaterialCode = sheetMaterial[20]; ma.HTHAMaterialCode = sheetMaterial[18]; ma.IsPTA = sheetMaterial[19] == "True" ? 1 : 0; ma.IsHTHA = sheetMaterial[17] == "True" ? 1 : 0; ma.Austenitic = sheetMaterial[11] == "True" ? 1 : 0; ma.Temper = sheetMaterial[12] == "True" ? 1 : 0; ma.CarbonLowAlloy = sheetMaterial[10] == "True" ? 1 : 0; ma.NickelBased = sheetMaterial[13] == "True" ? 1 : 0; ma.ChromeMoreEqual12 = sheetMaterial[14] == "True" ? 1 : 0; ma.AllowableStress = sheetMaterial[7] != "" ? float.Parse(sheetMaterial[7]) : 0; //ma.CostFactor = mate[20] != "" ? float.Parse(mate[20]) : 0; return(ma); }
public RW_MATERIAL getData(int ID) { RW_MATERIAL ma = new RW_MATERIAL(); ma.ID = ID; ma.MaterialName = txtMaterial.Text; ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) : 0; ma.DesignTemperature = txtMaxDesignTemperature.Text != "" ? float.Parse(txtMaxDesignTemperature.Text) : 0; ma.MinDesignTemperature = txtMinDesignTemperature.Text != "" ? float.Parse(txtMinDesignTemperature.Text) : 0; ma.BrittleFractureThickness = txtBrittleFracture.Text != "" ? float.Parse(txtBrittleFracture.Text) : 0; ma.CorrosionAllowance = txtCorrosionAllowance.Text != "" ? float.Parse(txtCorrosionAllowance.Text) : 0; ma.SigmaPhase = txtSigmaPhase.Text != "" ? float.Parse(txtSigmaPhase.Text) : 0; ma.SulfurContent = cbSulfurContent.Text; ma.HeatTreatment = cbHeatTreatment.Text; ma.ReferenceTemperature = txtReferenceTemperature.Text != "" ? float.Parse(txtReferenceTemperature.Text) : 0; ma.PTAMaterialCode = cbPTAMaterialGrade.Text; ma.HTHAMaterialCode = cbHTHAMaterial.Text; ma.IsPTA = chkIsPTASeverity.Checked ? 1 : 0; ma.IsHTHA = chkIsHTHASeverity.Checked ? 1 : 0; ma.Austenitic = chkAusteniticSteel.Checked ? 1 : 0; ma.Temper = chkSusceptibleTemper.Checked ? 1 : 0; ma.CarbonLowAlloy = chkCarbonLowAlloySteel.Checked ? 1 : 0; ma.NickelBased = chkNickelAlloy.Checked ? 1 : 0; ma.ChromeMoreEqual12 = chkChromium.Checked ? 1 : 0; ma.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) : 0; ma.CostFactor = txtMaterialCostFactor.Text != "" ? float.Parse(txtMaterialCostFactor.Text) : 0; return(ma); }
public void ShowDatatoControl(int id) { RW_MATERIAL_BUS BUS = new RW_MATERIAL_BUS(); RW_MATERIAL obj = BUS.getData(id); txtMaterial.Text = obj.MaterialName; txtDesignPressure.Text = obj.DesignPressure.ToString(); txtMaxDesignTemperature.Text = obj.DesignTemperature.ToString(); txtMinDesignTemperature.Text = obj.MinDesignTemperature.ToString(); txtBrittleFracture.Text = obj.BrittleFractureThickness.ToString(); txtCorrosionAllowance.Text = obj.CorrosionAllowance.ToString(); txtSigmaPhase.Text = obj.SigmaPhase.ToString(); for (int i = 0; i < itemsSulfurContent.Length; i++) { if (obj.SulfurContent == itemsSulfurContent[i]) { cbSulfurContent.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsHeatTreatment.Length; i++) { if (obj.HeatTreatment == itemsHeatTreatment[i]) { cbHeatTreatment.SelectedIndex = i + 1; break; } } txtReferenceTemperature.Text = obj.ReferenceTemperature.ToString(); for (int i = 0; i < itemsPTAMterial.Length; i++) { if (obj.PTAMaterialCode == itemsPTAMterial[i]) { cbPTAMaterialGrade.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsHTHAMaterial.Length; i++) { if (obj.HTHAMaterialCode == itemsHTHAMaterial[i]) { cbHTHAMaterial.SelectedIndex = i + 1; break; } } chkIsPTASeverity.Checked = Convert.ToBoolean(obj.IsPTA); chkIsHTHASeverity.Checked = Convert.ToBoolean(obj.IsHTHA); chkAusteniticSteel.Checked = Convert.ToBoolean(obj.Austenitic); chkSusceptibleTemper.Checked = Convert.ToBoolean(obj.Temper); chkCarbonLowAlloySteel.Checked = Convert.ToBoolean(obj.CarbonLowAlloy); chkNickelAlloy.Checked = Convert.ToBoolean(obj.NickelBased); chkChromium.Checked = Convert.ToBoolean(obj.ChromeMoreEqual12); txtAllowableStress.Text = obj.AllowableStress.ToString(); txtMaterialCostFactor.Text = obj.CostFactor.ToString(); }
public RW_MATERIAL getData(int id) { RW_MATERIAL obj = new RW_MATERIAL(); SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] SELECT [ID]" + ",[MaterialName]" + ",[DesignPressure]" + ",[DesignTemperature]" + ",[MinDesignTemperature]" + ",[BrittleFractureThickness]" + ",[CorrosionAllowance]" + ",[SigmaPhase]" + ",[SulfurContent]" + ",[HeatTreatment]" + ",[SteelProductForm]" + ",[ReferenceTemperature]" + ",[PTAMaterialCode]" + ",[HTHAMaterialCode]" + ",[IsPTA]" + ",[IsHTHA]" + ",[Austenitic]" + ",[Temper]" + ",[CarbonLowAlloy]" + ",[NickelBased]" + ",[ChromeMoreEqual12]" + ",[YieldStrength]" + ",[TensileStrength]" + ",[CostFactor]" + "FROM [dbo].[RW_MATERIAL] 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.MaterialName = reader.GetString(1); } if (!reader.IsDBNull(2)) { obj.DesignPressure = (float)reader.GetDouble(2); } if (!reader.IsDBNull(3)) { obj.DesignTemperature = (float)reader.GetDouble(3); } if (!reader.IsDBNull(4)) { obj.MinDesignTemperature = (float)reader.GetDouble(4); } if (!reader.IsDBNull(5)) { obj.BrittleFractureThickness = (float)reader.GetDouble(5); } if (!reader.IsDBNull(6)) { obj.CorrosionAllowance = (float)reader.GetDouble(6); } if (!reader.IsDBNull(7)) { obj.SigmaPhase = (float)reader.GetDouble(7); } if (!reader.IsDBNull(8)) { obj.SulfurContent = reader.GetString(8); } if (!reader.IsDBNull(9)) { obj.HeatTreatment = reader.GetString(9); } if (!reader.IsDBNull(10)) { obj.SteelProductForm = reader.GetString(10); } if (!reader.IsDBNull(11)) { obj.ReferenceTemperature = (float)reader.GetDouble(11); } if (!reader.IsDBNull(12)) { obj.PTAMaterialCode = reader.GetString(12); } if (!reader.IsDBNull(13)) { obj.HTHAMaterialCode = reader.GetString(13); } obj.IsPTA = Convert.ToInt32(reader.GetBoolean(14)); obj.IsHTHA = Convert.ToInt32(reader.GetBoolean(15)); obj.Austenitic = Convert.ToInt32(reader.GetBoolean(16)); obj.Temper = Convert.ToInt32(reader.GetBoolean(17)); obj.CarbonLowAlloy = Convert.ToInt32(reader.GetBoolean(18)); obj.NickelBased = Convert.ToInt32(reader.GetBoolean(19)); obj.ChromeMoreEqual12 = Convert.ToInt32(reader.GetBoolean(20)); if (!reader.IsDBNull(21)) { obj.YieldStrength = (float)reader.GetDouble(21); } if (!reader.IsDBNull(22)) { obj.TensileStrength = (float)reader.GetDouble(22); } obj.CostFactor = (float)reader.GetDouble(23); } } } } catch (Exception ex) { MessageBox.Show("GET DATA SOURCE FAIL!" + ex.ToString(), "ERROR!"); } finally { conn.Close(); conn.Dispose(); } return(obj); }
public List <RW_MATERIAL> getDataSource() { List <RW_MATERIAL> list = new List <RW_MATERIAL>(); RW_MATERIAL obj = null; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] SELECT [ID]" + ",[MaterialName]" + ",[DesignPressure]" + ",[DesignTemperature]" + ",[MinDesignTemperature]" + ",[BrittleFractureThickness]" + ",[CorrosionAllowance]" + ",[SigmaPhase]" + ",[SulfurContent]" + ",[HeatTreatment]" + ",[SteelProductForm]" + ",[ReferenceTemperature]" + ",[PTAMaterialCode]" + ",[HTHAMaterialCode]" + ",[IsPTA]" + ",[IsHTHA]" + ",[Austenitic]" + ",[Temper]" + ",[CarbonLowAlloy]" + ",[NickelBased]" + ",[ChromeMoreEqual12]" + ",[YieldStrength]" + ",[TensileStrength]" + ",[CostFactor]" + "FROM [dbo].[RW_MATERIAL] "; 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_MATERIAL(); obj.ID = reader.GetInt32(0); if (!reader.IsDBNull(1)) { obj.MaterialName = reader.GetString(1); } if (!reader.IsDBNull(2)) { obj.DesignPressure = reader.GetFloat(2); } if (!reader.IsDBNull(3)) { obj.DesignTemperature = reader.GetFloat(3); } if (!reader.IsDBNull(4)) { obj.MinDesignTemperature = reader.GetFloat(4); } if (!reader.IsDBNull(5)) { obj.BrittleFractureThickness = reader.GetFloat(5); } if (!reader.IsDBNull(6)) { obj.CorrosionAllowance = reader.GetFloat(6); } if (!reader.IsDBNull(7)) { obj.SigmaPhase = reader.GetFloat(7); } if (!reader.IsDBNull(8)) { obj.SulfurContent = reader.GetString(8); } if (!reader.IsDBNull(9)) { obj.HeatTreatment = reader.GetString(9); } if (!reader.IsDBNull(10)) { obj.SteelProductForm = reader.GetString(10); } if (!reader.IsDBNull(11)) { obj.ReferenceTemperature = reader.GetFloat(11); } if (!reader.IsDBNull(12)) { obj.PTAMaterialCode = reader.GetString(12); } if (!reader.IsDBNull(13)) { obj.HTHAMaterialCode = reader.GetString(13); } obj.IsPTA = reader.GetInt32(14); obj.IsHTHA = reader.GetInt32(15); obj.Austenitic = reader.GetInt32(16); obj.Temper = reader.GetInt32(17); obj.CarbonLowAlloy = reader.GetInt32(18); obj.NickelBased = reader.GetInt32(19); obj.ChromeMoreEqual12 = reader.GetInt32(20); if (!reader.IsDBNull(21)) { obj.YieldStrength = reader.GetFloat(21); } if (!reader.IsDBNull(22)) { obj.TensileStrength = reader.GetFloat(22); } obj.CostFactor = reader.GetFloat(23); list.Add(obj); } } } } catch { MessageBox.Show("GET DATA SOURCE FAIL!", "ERROR!"); } finally { conn.Close(); conn.Dispose(); } return(list); }
public void ShowDataToControl(int ID, string temUnit, string pressureUnit, string stressUnit, string thicknessUnit, string corrosionUnit) { RW_MATERIAL_BUS BUS = new RW_MATERIAL_BUS(); RW_MATERIAL obj = BUS.getData(ID); RW_INPUT_CA_TANK_BUS busTank = new RW_INPUT_CA_TANK_BUS(); BUS_UNITS convUnit = new BUS_UNITS(); float tank = busTank.getProductionCost(ID); switch (temUnit) { case "DEG_C": txtMaxDesignTemperature.Text = obj.DesignTemperature.ToString(); txtMinDesignTemperature.Text = obj.MinDesignTemperature.ToString(); txtReferenceTemperature.Text = obj.ReferenceTemperature.ToString(); break; case "DEG_F": txtMaxDesignTemperature.Text = (convUnit.CelToFah(obj.DesignTemperature)).ToString(); txtMinDesignTemperature.Text = (convUnit.CelToFah(obj.MinDesignTemperature)).ToString(); txtReferenceTemperature.Text = (convUnit.CelToFah(obj.ReferenceTemperature)).ToString(); break; case "K": txtMaxDesignTemperature.Text = (convUnit.CelToKenvin(obj.DesignTemperature)).ToString(); txtMinDesignTemperature.Text = (convUnit.CelToKenvin(obj.MinDesignTemperature)).ToString(); txtReferenceTemperature.Text = (convUnit.CelToKenvin(obj.ReferenceTemperature)).ToString(); break; } switch (pressureUnit) { case "psi": txtDesignPressure.Text = obj.DesignPressure.ToString(); break; case "KSI": txtDesignPressure.Text = (obj.DesignPressure / convUnit.ksi).ToString(); break; case "bar": txtDesignPressure.Text = (obj.DesignPressure / convUnit.bar).ToString(); break; case "MPa": txtDesignPressure.Text = (obj.DesignPressure / convUnit.MPa).ToString(); break; case "N/m2": txtDesignPressure.Text = (obj.DesignPressure / convUnit.NpM2).ToString(); break; case "N/cm2": txtDesignPressure.Text = (obj.DesignPressure / convUnit.NpCM2).ToString(); break; } switch (thicknessUnit) { case "mm": txtBrittleFracture.Text = obj.BrittleFractureThickness.ToString(); break; case "in": txtBrittleFracture.Text = (obj.BrittleFractureThickness / convUnit.inch).ToString(); break; case "m": txtBrittleFracture.Text = (obj.BrittleFractureThickness / convUnit.meter).ToString(); break; } switch (corrosionUnit) { case "mm": txtCorrosionAllowance.Text = obj.CorrosionAllowance.ToString(); break; case "mil": txtCorrosionAllowance.Text = (obj.CorrosionAllowance / convUnit.mil).ToString(); break; } switch (stressUnit) { case "psi": txtAllowableStress.Text = obj.AllowableStress.ToString(); break; case "KSI": txtAllowableStress.Text = (obj.AllowableStress / convUnit.ksi).ToString(); break; case "bar": txtAllowableStress.Text = (obj.AllowableStress / convUnit.bar).ToString(); break; case "MPa": txtAllowableStress.Text = (obj.AllowableStress / convUnit.MPa).ToString(); break; case "N/m2": txtAllowableStress.Text = (obj.AllowableStress / convUnit.NpM2).ToString(); break; case "N/cm2": txtAllowableStress.Text = (obj.AllowableStress / convUnit.NpCM2).ToString(); break; } txtMaterial.Text = obj.MaterialName; for (int i = 0; i < itemsSulfurContent.Length; i++) { if (obj.SulfurContent == itemsSulfurContent[i]) { cbSulfurContent.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsHeatTreatment.Length; i++) { if (obj.HeatTreatment == itemsHeatTreatment[i]) { cbHeatTreatment.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsPTAMterial.Length; i++) { if (obj.PTAMaterialCode == itemsPTAMterial[i]) { cbPTAMaterialGrade.SelectedIndex = i + 1; break; } } chkIsPTASeverity.Checked = Convert.ToBoolean(obj.IsPTA); chkAusteniticSteel.Checked = Convert.ToBoolean(obj.Austenitic); chkCarbonLowAlloySteel.Checked = Convert.ToBoolean(obj.CarbonLowAlloy); chkNickelAlloy.Checked = Convert.ToBoolean(obj.NickelBased); chkChromium.Checked = Convert.ToBoolean(obj.ChromeMoreEqual12); txtMaterialCostFactor.Text = obj.CostFactor.ToString(); txtProductionCost.Text = tank.ToString(); }
public RW_MATERIAL getData(int ID, string temUnit, string pressureUnit, string stressUnit, string thicknessUnit, string corrosionUnit) { RW_MATERIAL ma = new RW_MATERIAL(); BUS_UNITS convUnit = new BUS_UNITS(); ma.ID = ID; ma.MaterialName = txtMaterial.Text; switch (temUnit) { case "DEG_C": ma.DesignTemperature = txtMaxDesignTemperature.Text != "" ? float.Parse(txtMaxDesignTemperature.Text) : 0; ma.MinDesignTemperature = txtMinDesignTemperature.Text != "" ? float.Parse(txtMinDesignTemperature.Text) : 0; ma.ReferenceTemperature = txtReferenceTemperature.Text != "" ? float.Parse(txtReferenceTemperature.Text) : 0; break; case "DEG_F": ma.DesignTemperature = txtMaxDesignTemperature.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtMaxDesignTemperature.Text)) : 0; ma.MinDesignTemperature = txtMinDesignTemperature.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtMinDesignTemperature.Text)) : 0; ma.ReferenceTemperature = txtReferenceTemperature.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtReferenceTemperature.Text)) : 0; break; case "K": ma.DesignTemperature = txtMaxDesignTemperature.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtMaxDesignTemperature.Text)) : 0; ma.MinDesignTemperature = txtMinDesignTemperature.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtMinDesignTemperature.Text)) : 0; ma.ReferenceTemperature = txtReferenceTemperature.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtReferenceTemperature.Text)) : 0; break; } switch (pressureUnit) { case "psi": ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) : 0; break; case "KSI": ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.ksi : 0; break; case "bar": ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.bar : 0; break; case "MPa": ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.MPa : 0; break; case "N/m2": ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.NpM2 : 0; break; case "N/cm2": ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.NpCM2 : 0; break; } switch (stressUnit) { case "psi": ma.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) : 0; break; case "KSI": ma.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) * (float)convUnit.ksi : 0; break; case "bar": ma.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) * (float)convUnit.bar : 0; break; case "MPa": ma.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) * (float)convUnit.MPa : 0; break; case "N/m2": ma.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) * (float)convUnit.NpM2 : 0; break; case "N/cm2": ma.AllowableStress = txtAllowableStress.Text != "" ? float.Parse(txtAllowableStress.Text) * (float)convUnit.NpCM2 : 0; break; } switch (corrosionUnit) { case "mm": ma.CorrosionAllowance = txtCorrosionAllowance.Text != "" ? float.Parse(txtCorrosionAllowance.Text) : 0; break; case "mil": ma.CorrosionAllowance = txtCorrosionAllowance.Text != "" ? float.Parse(txtCorrosionAllowance.Text) * (float)convUnit.mil : 0; break; } switch (thicknessUnit) { case "mm": ma.BrittleFractureThickness = txtBrittleFracture.Text != "" ? float.Parse(txtBrittleFracture.Text) : 0; break; case "in": ma.BrittleFractureThickness = txtBrittleFracture.Text != "" ? float.Parse(txtBrittleFracture.Text) * (float)convUnit.inch : 0; break; case "m": ma.BrittleFractureThickness = txtBrittleFracture.Text != "" ? float.Parse(txtBrittleFracture.Text) * (float)convUnit.meter : 0; break; } ma.SulfurContent = cbSulfurContent.Text; ma.HeatTreatment = cbHeatTreatment.Text; ma.PTAMaterialCode = cbPTAMaterialGrade.Text; ma.IsPTA = chkIsPTASeverity.Checked ? 1 : 0; ma.Austenitic = chkAusteniticSteel.Checked ? 1 : 0; ma.CarbonLowAlloy = chkCarbonLowAlloySteel.Checked ? 1 : 0; ma.NickelBased = chkNickelAlloy.Checked ? 1 : 0; ma.ChromeMoreEqual12 = chkChromium.Checked ? 1 : 0; ma.CostFactor = txtMaterialCostFactor.Text != "" ? float.Parse(txtMaterialCostFactor.Text) : 0; return(ma); }
public RW_MATERIAL getData(int ID, string temUnit, string pressureUnit, string corrosionUnit) { RW_MATERIAL ma = new RW_MATERIAL(); BUS_UNITS convUnit = new BUS_UNITS(); ma.ID = ID; ma.MaterialName = txtMaterial.Text; switch (temUnit) { case "DEG_C": ma.DesignTemperature = txtMaxDesignTemperature.Text != "" ? float.Parse(txtMaxDesignTemperature.Text) : 0; ma.MinDesignTemperature = txtMinDesignTemperature.Text != "" ? float.Parse(txtMinDesignTemperature.Text) : 0; ma.ReferenceTemperature = txtReferenceTemperature.Text != "" ? float.Parse(txtReferenceTemperature.Text) : 0; break; case "DEG_F": ma.DesignTemperature = txtMaxDesignTemperature.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtMaxDesignTemperature.Text)) : 0; ma.MinDesignTemperature = txtMinDesignTemperature.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtMinDesignTemperature.Text)) : 0; ma.ReferenceTemperature = txtReferenceTemperature.Text != "" ? (float)convUnit.FahToCel(float.Parse(txtReferenceTemperature.Text)) : 0; break; case "K": ma.DesignTemperature = txtMaxDesignTemperature.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtMaxDesignTemperature.Text)) : 0; ma.MinDesignTemperature = txtMinDesignTemperature.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtMinDesignTemperature.Text)) : 0; ma.ReferenceTemperature = txtReferenceTemperature.Text != "" ? (float)convUnit.KenvinToCel(float.Parse(txtReferenceTemperature.Text)) : 0; break; } switch (pressureUnit) { case "PSI": ma.YieldStrength = txtYieldStrength.Text != "" ? float.Parse(txtYieldStrength.Text) * (float)convUnit.psi : 0; ma.TensileStrength = txtTensileStrength.Text != "" ? float.Parse(txtTensileStrength.Text) * (float)convUnit.psi : 0; ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.psi : 0; break; case "KSI": ma.YieldStrength = txtYieldStrength.Text != "" ? float.Parse(txtYieldStrength.Text) * (float)convUnit.ksi : 0; ma.TensileStrength = txtTensileStrength.Text != "" ? float.Parse(txtTensileStrength.Text) * (float)convUnit.ksi : 0; ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.ksi : 0; break; case "BAR": ma.YieldStrength = txtYieldStrength.Text != "" ? float.Parse(txtYieldStrength.Text) * (float)convUnit.bar : 0; ma.TensileStrength = txtTensileStrength.Text != "" ? float.Parse(txtTensileStrength.Text) * (float)convUnit.bar : 0; ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.bar : 0; break; case "MPA": ma.YieldStrength = txtYieldStrength.Text != "" ? float.Parse(txtYieldStrength.Text) : 0; ma.TensileStrength = txtTensileStrength.Text != "" ? float.Parse(txtTensileStrength.Text) : 0; ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) : 0; break; case "NM2": ma.YieldStrength = txtYieldStrength.Text != "" ? float.Parse(txtYieldStrength.Text) * (float)convUnit.NpM2 : 0; ma.TensileStrength = txtTensileStrength.Text != "" ? float.Parse(txtTensileStrength.Text) * (float)convUnit.NpM2 : 0; ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.NpM2 : 0; break; case "NCM2": ma.YieldStrength = txtYieldStrength.Text != "" ? float.Parse(txtYieldStrength.Text) * (float)convUnit.NpCM2 : 0; ma.TensileStrength = txtTensileStrength.Text != "" ? float.Parse(txtTensileStrength.Text) * (float)convUnit.NpCM2 : 0; ma.DesignPressure = txtDesignPressure.Text != "" ? float.Parse(txtDesignPressure.Text) * (float)convUnit.NpCM2 : 0; break; } switch (corrosionUnit) { case "mm": ma.CorrosionAllowance = txtCorrosionAllowance.Text != "" ? float.Parse(txtCorrosionAllowance.Text) : 0; break; case "mil": ma.CorrosionAllowance = txtCorrosionAllowance.Text != "" ? float.Parse(txtCorrosionAllowance.Text) * (float)convUnit.mil : 0; break; } ma.SulfurContent = cbSulfurContent.Text; ma.PTAMaterialCode = cbPTAMaterialGrade.Text; ma.IsPTA = chkIsPTASeverity.Checked ? 1 : 0; ma.Austenitic = chkAusteniticSteel.Checked ? 1 : 0; ma.CarbonLowAlloy = chkCarbonLowAlloySteel.Checked ? 1 : 0; ma.NickelBased = chkNickelAlloy.Checked ? 1 : 0; ma.ChromeMoreEqual12 = chkChromium.Checked ? 1 : 0; ma.CostFactor = txtMaterialCostFactor.Text != "" ? float.Parse(txtMaterialCostFactor.Text) : 0; return(ma); }
public void delete(RW_MATERIAL obj) { DAL.delete(obj.ID); }
public void edit(RW_MATERIAL obj) { DAL.edit(obj.ID, obj.MaterialName, obj.DesignPressure, obj.DesignTemperature, obj.MinDesignTemperature, obj.BrittleFractureThickness, obj.CorrosionAllowance, obj.SigmaPhase, obj.SulfurContent, obj.HeatTreatment, obj.ReferenceTemperature, obj.PTAMaterialCode, obj.HTHAMaterialCode, obj.IsPTA, obj.IsHTHA, obj.Austenitic, obj.Temper, obj.CarbonLowAlloy, obj.NickelBased, obj.ChromeMoreEqual12, obj.AllowableStress, obj.CostFactor); }
public void ShowDatatoControl(int id, string temperatureUnit, string pressureUnit, string corrosionUnit) { RW_MATERIAL_BUS BUS = new RW_MATERIAL_BUS(); RW_MATERIAL obj = BUS.getData(id); BUS_UNITS convUnit = new BUS_UNITS(); txtMaterial.Text = obj.MaterialName; switch (temperatureUnit) { case "DEG_C": txtMaxDesignTemperature.Text = obj.DesignTemperature.ToString(); txtMinDesignTemperature.Text = obj.MinDesignTemperature.ToString(); txtReferenceTemperature.Text = obj.ReferenceTemperature.ToString(); break; case "DEG_F": txtMaxDesignTemperature.Text = (convUnit.CelToFah(obj.DesignTemperature)).ToString(); txtMinDesignTemperature.Text = (convUnit.CelToFah(obj.MinDesignTemperature)).ToString(); txtReferenceTemperature.Text = (convUnit.CelToFah(obj.ReferenceTemperature)).ToString(); break; case "K": txtMaxDesignTemperature.Text = (convUnit.CelToKenvin(obj.DesignTemperature)).ToString(); txtMinDesignTemperature.Text = (convUnit.CelToKenvin(obj.MinDesignTemperature)).ToString(); txtReferenceTemperature.Text = (convUnit.CelToKenvin(obj.ReferenceTemperature)).ToString(); break; } switch (pressureUnit) { case "PSI": txtDesignPressure.Text = (obj.DesignPressure / convUnit.psi).ToString(); txtYieldStrength.Text = (obj.YieldStrength / convUnit.psi).ToString(); txtTensileStrength.Text = (obj.TensileStrength / convUnit.psi).ToString(); break; case "KSI": txtDesignPressure.Text = (obj.DesignPressure / convUnit.ksi).ToString(); txtYieldStrength.Text = (obj.YieldStrength / convUnit.ksi).ToString(); txtTensileStrength.Text = (obj.TensileStrength / convUnit.ksi).ToString(); break; case "BAR": txtDesignPressure.Text = (obj.DesignPressure / convUnit.bar).ToString(); txtYieldStrength.Text = (obj.YieldStrength / convUnit.bar).ToString(); txtTensileStrength.Text = (obj.TensileStrength / convUnit.bar).ToString(); break; case "MPA": txtDesignPressure.Text = (obj.DesignPressure).ToString(); txtYieldStrength.Text = (obj.YieldStrength).ToString(); txtTensileStrength.Text = (obj.TensileStrength).ToString(); break; case "NM2": txtDesignPressure.Text = (obj.DesignPressure / convUnit.NpM2).ToString(); txtYieldStrength.Text = (obj.YieldStrength / convUnit.NpM2).ToString(); txtTensileStrength.Text = (obj.TensileStrength / convUnit.NpM2).ToString(); break; case "NCM2": txtDesignPressure.Text = (obj.DesignPressure / convUnit.NpCM2).ToString(); txtYieldStrength.Text = (obj.YieldStrength / convUnit.NpCM2).ToString(); txtTensileStrength.Text = (obj.TensileStrength / convUnit.NpCM2).ToString(); break; } switch (corrosionUnit) { case "MM": txtCorrosionAllowance.Text = obj.CorrosionAllowance.ToString(); break; case "MIL": txtCorrosionAllowance.Text = (obj.CorrosionAllowance / convUnit.mil).ToString(); break; } txtSigmaPhase.Text = obj.SigmaPhase.ToString(); for (int i = 0; i < itemsSulfurContent.Length; i++) { if (obj.SulfurContent == itemsSulfurContent[i]) { cbSulfurContent.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsPTAMterial.Length; i++) { if (obj.PTAMaterialCode == itemsPTAMterial[i]) { cbPTAMaterialGrade.SelectedIndex = i + 1; break; } } for (int i = 0; i < itemsHTHAMaterial.Length; i++) { if (obj.HTHAMaterialCode == itemsHTHAMaterial[i]) { cbHTHAMaterial.SelectedIndex = i + 1; break; } } chkIsPTASeverity.Checked = Convert.ToBoolean(obj.IsPTA); chkIsHTHASeverity.Checked = Convert.ToBoolean(obj.IsHTHA); chkAusteniticSteel.Checked = Convert.ToBoolean(obj.Austenitic); chkSusceptibleTemper.Checked = Convert.ToBoolean(obj.Temper); chkCarbonLowAlloySteel.Checked = Convert.ToBoolean(obj.CarbonLowAlloy); chkNickelAlloy.Checked = Convert.ToBoolean(obj.NickelBased); chkChromium.Checked = Convert.ToBoolean(obj.ChromeMoreEqual12); txtTensileStrength.Text = obj.TensileStrength.ToString(); txtYieldStrength.Text = obj.YieldStrength.ToString(); txtMaterialCostFactor.Text = obj.CostFactor.ToString(); }