public EN1993_1_1(string combo1, string combo2,bool item3,bool item4, bool item5, bool item6)
{
string sql1;
string sql2;
sql1 = "Select mat_num, mat_name, mat_prod_code_num, mat_prod_code_name1, mat_prod_code_name2, steel_grade_num, fy1, fu1, fy2, fu2, gamaM0, gamaM1, gamaM2, betaw, eta_shear, E, G, nu_pois, alpha_temp from Steel where mat_name like '" + combo1 + "'";
#region Database DATA-STEEL variables reader
dat_conn = DatabaseConnection.getInstance();
dat_reader = dat_conn.getDBReader(sql1);
try
{
while (dat_reader.Read())
{
// STEEL DATABASE DATA
#region Data list
try
{
mat_num = Convert.ToInt16(dat_reader.GetValue(0).ToString());
}
catch (FormatException) { }
try
{
mat_name = dat_reader.GetValue(1).ToString();
}
catch (FormatException) { }
try
{
mat_prod_code_num = Convert.ToInt16(dat_reader.GetValue(2).ToString());
}
catch (FormatException) { }
try
{
mat_prod_code_name1 = dat_reader.GetValue(3).ToString();
}
catch (FormatException) { }
try
{
mat_prod_code_name2 = dat_reader.GetValue(4).ToString();
}
catch (FormatException) { }
try
{
steel_grade_num = Convert.ToInt32(dat_reader.GetValue(5).ToString());
}
catch (FormatException) { }
try
{
fy1 = Convert.ToDouble(dat_reader.GetValue(6).ToString());
}
catch (FormatException) { }
try
{
fu1 = Convert.ToDouble(dat_reader.GetValue(7).ToString());
}
catch (FormatException) { }
try
{
fy2 = Convert.ToDouble(dat_reader.GetValue(8).ToString());
}
catch (FormatException) { }
try
{
fu2 = Convert.ToDouble(dat_reader.GetValue(9).ToString());
}
catch (FormatException) { }
try
{
gamaM0 = Convert.ToDouble(dat_reader.GetValue(10).ToString());
}
catch (FormatException) { }
try
{
gamaM1 = Convert.ToDouble(dat_reader.GetValue(11).ToString());
}
catch (FormatException) { }
try
{
gamaM2 = Convert.ToDouble(dat_reader.GetValue(12).ToString());
}
catch (FormatException) { }
try
{
betaw = Convert.ToDouble(dat_reader.GetValue(13).ToString());
}
catch (FormatException) { }
try
{
eta_shear = Convert.ToDouble(dat_reader.GetValue(14).ToString());
}
catch (FormatException) { }
try
{
_E = Convert.ToDouble(dat_reader.GetValue(15).ToString());
}
catch (FormatException) { }
try
{
_G = Convert.ToDouble(dat_reader.GetValue(16).ToString());
}
catch (FormatException) { }
try
{
nu_pois = Convert.ToDouble(dat_reader.GetValue(17).ToString());
}
catch (FormatException) { }
try
{
alpha_temp = Convert.ToDouble(dat_reader.GetValue(18).ToString());
}
catch (FormatException) { }
#endregion
}
}
catch (FormatException) { }
#endregion
sql2 = "Select csprof_namenum, csprof_name, csprofshape, csprof_production, csprodcode1_name1, csprodcode1_name2, csprodcode2_name1, csprodcode2_name2, csproducer1, csproducer2, csprof_weight,h, b, bh, bd, tw, tf, r, r1, r2, r3, hi, d, d1, e, e_apostrof, ez, ey, w, w1, v, v1, v2, eel, epl, D_tube, t_tube, A, A_su, Af, Aw, Ay_v, Az_v, Av, Iy, Wy_el, Wy1, Wy2, Wy_pl, iy_r, Sy, Iz, Wz_el, Wz1, Wz2, Wz_pl, iz_r, Sz, IT, Wt, Iw, ss, ys, ym, Id, Ieta, Weta, ieta_r, Ixi, Wxi2, Wxi13,ixi_r, Iyz, omega_w, izf, iz1, ipc, ay, aeta, ip, ia, Ww1, Ww2, Sw3, iw1, k, a1, tg_fi, cy1, ty1, cz1, tz1, cy2, ty2, cz2, tz2 from sections where csprof_name like '" + combo2 + "'";
#region Database DATA-SECTIONS variables reader
dat_conn = DatabaseConnection.getInstance();
dat_reader = dat_conn.getDBReader(sql2);
try
{
while (dat_reader.Read())
{
// CROSS-SECTION DATABASE DATA
#region Data list
// 0 - 9
try
{
csprof_namenum = Convert.ToInt16(dat_reader.GetValue(0).ToString());
}
catch (FormatException) { }
try
{
csprof_name = dat_reader.GetValue(1).ToString();
}
catch (FormatException) { }
try
{
csprofshape = Convert.ToInt16(dat_reader.GetValue(2).ToString());
}
catch (FormatException) { }
try
{
csprof_production = Convert.ToInt16(dat_reader.GetValue(3).ToString());
}
catch (FormatException) { }
try
{
csprodcode1_name1 = dat_reader.GetValue(4).ToString();
}
catch (FormatException) { }
try
{
csprodcode1_name2 = dat_reader.GetValue(5).ToString();
}
catch (FormatException) { }
try
{
csprodcode2_name1 = dat_reader.GetValue(6).ToString();
}
catch (FormatException) { }
try
{
csprodcode2_name2 = dat_reader.GetValue(7).ToString();
}
catch (FormatException) { }
try
{
csproducer1 = dat_reader.GetValue(8).ToString();
}
catch (FormatException) { }
try
{
csproducer2 = dat_reader.GetValue(9).ToString();
}
catch (FormatException) { }
// 10-19
csprof_weight = Convert.ToDouble(dat_reader.GetValue(10).ToString());
try
{
h = Convert.ToDouble(dat_reader.GetValue(11).ToString());
}
catch (FormatException) { }
try
{
b = Convert.ToDouble(dat_reader.GetValue(12).ToString());
}
catch (FormatException) { }
try
{
bh = Convert.ToDouble(dat_reader.GetValue(13).ToString());
}
catch (FormatException) { }
try
{
bd = Convert.ToDouble(dat_reader.GetValue(14).ToString());
}
catch (FormatException) { }
try
{
tw = Convert.ToDouble(dat_reader.GetValue(15).ToString());
}
catch (FormatException) { }
try
{
tf = Convert.ToDouble(dat_reader.GetValue(16).ToString());
}
catch (FormatException) { }
try
{
r = Convert.ToDouble(dat_reader.GetValue(17).ToString());
}
catch (FormatException) { }
try
{
r1 = Convert.ToDouble(dat_reader.GetValue(18).ToString());
}
catch (FormatException) { }
try
{
r2 = Convert.ToDouble(dat_reader.GetValue(19).ToString());
}
catch (FormatException) { }
// 20-29
try
{
r3 = Convert.ToDouble(dat_reader.GetValue(20).ToString());
}
catch (FormatException) { }
try
{
hi = Convert.ToDouble(dat_reader.GetValue(21).ToString());
}
catch (FormatException) { }
try
{
d = Convert.ToDouble(dat_reader.GetValue(22).ToString());
}
catch (FormatException) { }
try
{
d1 = Convert.ToDouble(dat_reader.GetValue(23).ToString());
}
catch (FormatException) { }
try
{
e = Convert.ToDouble(dat_reader.GetValue(24).ToString());
}
catch (FormatException) { }
try
{
e_apostrof = Convert.ToDouble(dat_reader.GetValue(25).ToString());
}
catch (FormatException) { }
try
{
ez = Convert.ToDouble(dat_reader.GetValue(26).ToString());
}
catch (FormatException) { }
try
{
ey = Convert.ToDouble(dat_reader.GetValue(27).ToString());
}
catch (FormatException) { }
try
{
w = Convert.ToDouble(dat_reader.GetValue(28).ToString());
}
catch (FormatException) { }
try
{
w1 = Convert.ToDouble(dat_reader.GetValue(29).ToString());
}
catch (FormatException) { }
// 30-39
try
{
v = Convert.ToDouble(dat_reader.GetValue(30).ToString());
}
catch (FormatException) { }
try
{
v1 = Convert.ToDouble(dat_reader.GetValue(31).ToString());
}
catch (FormatException) { }
try
{
v2 = Convert.ToDouble(dat_reader.GetValue(32).ToString());
}
catch (FormatException) { }
try
{
eel = Convert.ToDouble(dat_reader.GetValue(33).ToString());
}
catch (FormatException) { }
try
{
epl = Convert.ToDouble(dat_reader.GetValue(34).ToString());
}
catch (FormatException) { }
try
{
_D_tube = Convert.ToDouble(dat_reader.GetValue(35).ToString());
}
catch (FormatException) { }
try
{
t_tube = Convert.ToDouble(dat_reader.GetValue(36).ToString());
}
catch (FormatException) { }
try
{
_A = Convert.ToDouble(dat_reader.GetValue(37).ToString());
}
catch (FormatException) { }
try
{
_A_su = Convert.ToDouble(dat_reader.GetValue(38).ToString());
}
catch (FormatException) { }
try
{
_Af = Convert.ToDouble(dat_reader.GetValue(39).ToString());
}
catch (FormatException) { }
// 40-49
try
{
_Aw = Convert.ToDouble(dat_reader.GetValue(40).ToString());
}
catch (FormatException) { }
try
{
_Ay_v = Convert.ToDouble(dat_reader.GetValue(41).ToString());
}
catch (FormatException) { }
try
{
_Az_v = Convert.ToDouble(dat_reader.GetValue(42).ToString());
}
catch (FormatException) { }
try
{
_Av = Convert.ToDouble(dat_reader.GetValue(43).ToString());
}
catch (FormatException) { }
try
{
_Iy = Convert.ToDouble(dat_reader.GetValue(44).ToString());
}
catch (FormatException) { }
try
{
_Wy_el = Convert.ToDouble(dat_reader.GetValue(45).ToString());
}
catch (FormatException) { }
try
{
_Wy1 = Convert.ToDouble(dat_reader.GetValue(46).ToString());
}
catch (FormatException) { }
try
{
_Wy2 = Convert.ToDouble(dat_reader.GetValue(47).ToString());
}
catch (FormatException) { }
try
{
_Wy_pl = Convert.ToDouble(dat_reader.GetValue(48).ToString());
}
catch (FormatException) { }
try
{
iy_r = Convert.ToDouble(dat_reader.GetValue(49).ToString());
}
catch (FormatException) { }
// 50-59
try
{
_Sy = Convert.ToDouble(dat_reader.GetValue(50).ToString());
}
catch (FormatException) { }
try
{
_Iz = Convert.ToDouble(dat_reader.GetValue(51).ToString());
}
catch (FormatException) { }
try
{
_Wz_el = Convert.ToDouble(dat_reader.GetValue(52).ToString());
}
catch (FormatException) { }
try
{
_Wz1 = Convert.ToDouble(dat_reader.GetValue(53).ToString());
}
catch (FormatException) { }
try
{
_Wz2 = Convert.ToDouble(dat_reader.GetValue(54).ToString());
}
catch (FormatException) { }
try
{
_Wz_pl = Convert.ToDouble(dat_reader.GetValue(55).ToString());
}
catch (FormatException) { }
try
{
iz_r = Convert.ToDouble(dat_reader.GetValue(56).ToString());
}
catch (FormatException) { }
try
{
_Sz = Convert.ToDouble(dat_reader.GetValue(57).ToString());
}
catch (FormatException) { }
try
{
_IT = Convert.ToDouble(dat_reader.GetValue(58).ToString());
}
catch (FormatException) { }
try
{
_Wt = Convert.ToDouble(dat_reader.GetValue(59).ToString());
}
catch (FormatException) { }
// 60-69
try
{
_Iw = Convert.ToDouble(dat_reader.GetValue(60).ToString());
}
catch (FormatException) { }
try
{
ss = Convert.ToDouble(dat_reader.GetValue(61).ToString());
}
catch (FormatException) { }
try
{
ys = Convert.ToDouble(dat_reader.GetValue(62).ToString());
}
catch (FormatException) { }
try
{
ym = Convert.ToDouble(dat_reader.GetValue(63).ToString());
}
catch (FormatException) { }
try
{
_Id = Convert.ToDouble(dat_reader.GetValue(64).ToString());
}
catch (FormatException) { }
try
{
_Ieta = Convert.ToDouble(dat_reader.GetValue(65).ToString());
}
catch (FormatException) { }
try
{
_Weta = Convert.ToDouble(dat_reader.GetValue(66).ToString());
}
catch (FormatException) { }
try
{
ieta_r = Convert.ToDouble(dat_reader.GetValue(67).ToString());
}
catch (FormatException) { }
try
{
_Ixi = Convert.ToDouble(dat_reader.GetValue(68).ToString());
}
catch (FormatException) { }
try
{
_Wxi2 = Convert.ToDouble(dat_reader.GetValue(69).ToString());
}
catch (FormatException) { }
// 70-79
try
{
_Wxi13 = Convert.ToDouble(dat_reader.GetValue(70).ToString());
}
catch (FormatException) { }
try
{
ixi_r = Convert.ToDouble(dat_reader.GetValue(71).ToString());
}
catch (FormatException) { }
try
{
_Iyz = Convert.ToDouble(dat_reader.GetValue(72).ToString());
}
catch (FormatException) { }
try
{
omega_w = Convert.ToDouble(dat_reader.GetValue(73).ToString());
}
catch (FormatException) { }
try
{
izf = Convert.ToDouble(dat_reader.GetValue(74).ToString());
}
catch (FormatException) { }
try
{
iz1 = Convert.ToDouble(dat_reader.GetValue(75).ToString());
}
catch (FormatException) { }
try
{
ipc = Convert.ToDouble(dat_reader.GetValue(76).ToString());
}
catch (FormatException) { }
try
{
ay = Convert.ToDouble(dat_reader.GetValue(77).ToString());
}
catch (FormatException) { }
try
{
aeta = Convert.ToDouble(dat_reader.GetValue(78).ToString());
}
catch (FormatException) { }
try
{
ip = Convert.ToDouble(dat_reader.GetValue(79).ToString());
}
catch (FormatException) { }
// 80-89
try
{
ia = Convert.ToDouble(dat_reader.GetValue(80).ToString());
}
catch (FormatException) { }
try
{
_Ww1 = Convert.ToDouble(dat_reader.GetValue(81).ToString());
}
catch (FormatException) { }
try
{
_Ww2 = Convert.ToDouble(dat_reader.GetValue(82).ToString());
}
catch (FormatException) { }
try
{
_Sw3 = Convert.ToDouble(dat_reader.GetValue(83).ToString());
}
catch (FormatException) { }
try
{
iw1 = Convert.ToDouble(dat_reader.GetValue(84).ToString());
}
catch (FormatException) { }
try
{
k = Convert.ToDouble(dat_reader.GetValue(85).ToString());
}
catch (FormatException) { }
try
{
a1 = Convert.ToDouble(dat_reader.GetValue(86).ToString());
}
catch (FormatException) { }
try
{
tg_fi = Convert.ToDouble(dat_reader.GetValue(87).ToString());
}
catch (FormatException) { }
try
{
cy1 = Convert.ToDouble(dat_reader.GetValue(88).ToString());
}
catch (FormatException) { }
try
{
ty1 = Convert.ToDouble(dat_reader.GetValue(89).ToString());
}
catch (FormatException) { }
// 90-99
try
{
cz1 = Convert.ToDouble(dat_reader.GetValue(90).ToString());
}
catch (FormatException) { }
try
{
tz1 = Convert.ToDouble(dat_reader.GetValue(91).ToString());
}
catch (FormatException) { }
try
{
cy2 = Convert.ToDouble(dat_reader.GetValue(92).ToString());
}
catch (FormatException) { }
try
{
ty2 = Convert.ToDouble(dat_reader.GetValue(93).ToString());
}
catch (FormatException) { }
try
{
cz2 = Convert.ToDouble(dat_reader.GetValue(94).ToString());
}
catch (FormatException) { }
try
{
tz2 = Convert.ToDouble(dat_reader.GetValue(95).ToString());
}
catch (FormatException) { }
#endregion
}
}
catch (FormatException) { }
#endregion
// Data from Form: EN1993-1-1MessageBoxes.cs
this.item3_check = item3;
this.item4_check = item4;
this.item5_check = item5;
this.item6_check = item6;
}
