//Constructor
public EN1999_1_1Form()
{
InitializeComponent();
dat_conn = DatabaseConnection.getInstance();
this.loadCombo1(); //loading data to combobox1
dtform = new DataTableForm(1); //for inicializing of object default value is 1
}
private void TableDataToolStripMenuItem_Click(object sender, EventArgs e)
{
dtform = new DataTableForm(typ_prierezu);
if (dtform.ShowDialog() == DialogResult.Cancel)
{
naplnZoznamy();
updateDataGridView();
}
}
private void naplnZoznamy()
{
string combo1 = comboBox1.Text; //actual text in combobox1
string combo2 = comboBox2.Text; //actual text in combobox2
string unit = "nedef";
CheckedListInfo chLInfo;
this.deleteLists();
#region choosing typ_prierezu from database
// checking type of cross-section from database for further processing
string sql = "Select csprofshape from sections where csprof_name like '" + combo2 + "'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
try
{
typ_prierezu = Convert.ToByte(dat_reader.GetValue(0).ToString());
}
catch (InvalidOperationException) { /*MessageBox.Show("Set up cross-section in ComboBox Cross-section, please!");*/
//This type of exception appears mainly because text in combo2 is empty
}
catch (FormatException) { }
#endregion
dtform = new DataTableForm(typ_prierezu);
try
{
#region filling lists with actual variables,their names in table and units
chLInfo = dtform.ZozChLInfos[0, 0]; //for checkListbox 4. (STEEL)
for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++)
{
//if the variable is checked in checkedlistbox4 then add this variable to list of variables
if (chLInfo.ZoznamZasktPrem[i])
{
zoznamNazvyPremeSTEEL.Add(chLInfo.ZoznamPremennych[i]); //variables for database
zoznamMenuNazvySTEEL.Add(chLInfo.ZoznamZobrazPremennych[i]); //variables names for table
zoznamMenuJednotkySTEEL.Add(chLInfo.ZoznamJednotiek[i]); //units of these variables
}
}
chLInfo = dtform.ZozChLInfos[typ_prierezu, 0]; //pre checkListbox 1.
for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++)
{
if (chLInfo.ZoznamZasktPrem[i])
{
zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]); //premenne do databazy
zoznamMenuNazvy.Add(chLInfo.ZoznamZobrazPremennych[i]); //premenne zobrazene v tabulke
zoznamMenuJednotky.Add(chLInfo.ZoznamJednotiek[i]);
//MessageBox.Show(chLInfo.ZoznamPremennych[i] + "\n" + chLInfo.ZoznamZobrazPremennych[i] + "\n"
// + chLInfo.ZoznamJednotiek[i]);
}
}
chLInfo = dtform.ZozChLInfos[typ_prierezu, 1]; //pre checkListbox 2.
for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++)
{
if (chLInfo.ZoznamZasktPrem[i])
{
zoznamMenuNazvy.Add(chLInfo.ZoznamPremennych[i]); //premenne zadavane pouzivatelom
zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]);
//MessageBox.Show(chLInfo.ZoznamPremennych[i]);
}
}
#endregion
#region loading values for variables from database
//getting values of actual choosen variables of STEEL
for (int i = 0; i < zoznamNazvyPremeSTEEL.Count; i++)
{
if (combo1 != "" && comboBox1.SelectedIndex != 0 && combo2 != "")
{
sql = "Select " + zoznamNazvyPremeSTEEL[i] + " from Steel where mat_name like '"+combo1+"'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
try
{
zoznamMenuHodnotySTEEL.Add(dat_reader.GetValue(0).ToString());
}
catch (InvalidOperationException) { }
}
}
//getting values of actual choosen variables of cross sections
//if variable is from user input - getting character from database that determines
//that it is user input,adding unit for this variable ,other visual style for this
//variable in datagrid is defined in method updateDataGridView()
for (int i = 0; i < zoznamNazvyPremennych.Count; i++)
{
if (combo2 != "" && combo1 != "")
{
sql = "Select ";
switch (zoznamNazvyPremennych[i])
{
#region Table - user-data cells basic loading - database "user" column
// Internal forces in section
case "N": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break;
case "Vy": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break;
case "Vz": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break;
case "Mx": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "My": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
// End bending moments
case "My.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "My.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
// Midspan bending moments
case "My.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
// Annex A - Table A.2 input data
case "My.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break;
case "Mz.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break;
case "Deflection.y.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break;
case "Deflection.z.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break;
// Lateral buckling Mcr variables
case "C1y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "C2y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "C3y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "kz_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "kw_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
// Beam properties - lenght
case "L_teor": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_y_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_z_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_y_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_z_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_T": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
// Cross-section data
case "Anet": sql += "user"; unit = "mm2"; zoznamMenuJednotky.Add(unit); break;
// Variables - Torsion NAD CZE
case "MEd.T": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break;
case "VEd.T": sql += "user"; unit = "[kN]"; zoznamMenuJednotky.Add(unit); break;
case "e.T": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break;
#endregion
default: sql += zoznamNazvyPremennych[i]; break;
}
sql += " from SECTIONS where csprof_name like '" + combo2 + "'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
try
{
zoznamMenuHodnoty.Add(dat_reader.GetValue(0).ToString());//zapise sa hodnota do zoznamu
}
catch (InvalidOperationException) { }
}
}
#endregion
}
catch (NullReferenceException) { MessageBox.Show("There is nothing to display! Please choose some variables in Options -> Data table list."); }
}
