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