public List <ThicknessTable> GetThickness()
{
List <ThicknessTable> thicknesses = new List <ThicknessTable>();
try
{
connection.Open();
var command = new OleDbCommand();
command.Connection = connection;
command.CommandText = "select * from Thickness";
var reader = command.ExecuteReader();
while (reader.Read())
{
ThicknessTable thickness = new ThicknessTable();
thickness.thickness = reader.GetString(1);
thickness.type = reader.GetString(2);
thicknesses.Add(thickness);
}
thicknesses.Sort();
reader.Close();
connection.Close();
return(thicknesses);
}
catch (Exception e) { }
finally { }
return(thicknesses);
}
public int CompareTo(Object obj)
{
if (obj == null)
{
return(1);
}
ThicknessTable other = obj as ThicknessTable;
if (this.type != other.type)
{
return(this.type.CompareTo(other.type));
}
else
{
float mythick = float.Parse(this.thickness);
float otherthick = float.Parse(other.thickness);
return(mythick.CompareTo(otherthick));
}
}
