public static List<int> listOfGearIds(int materialID, List<int> shaftIds, Database1DataSet1TableAdapters.GearsTableAdapter gta)
{
List<int> gearIds = new List<int>();
Database1DataSet1.GearsDataTable gearTable = new Database1DataSet1.GearsDataTable();
// beacause of the Material
gearTable = gta.GetDataByMaterialID(materialID);
foreach (Database1DataSet1.GearsRow row in gearTable)
{
int id = row.ID;
gearIds.Add(id);
}
// because of the shaft
foreach (int shaft in shaftIds)
{
gearTable = gta.GetDataByShaftID(shaft);
foreach (Database1DataSet1.GearsRow row in gearTable)
{
int id = row.ID;
gearIds.Add(id);
}
}
return gearIds;
}
private void GearBoxGenerator_Load(object sender, EventArgs e)
{
// Get the Materials
Database1DataSet1TableAdapters.MaterialsTableAdapter mta = new Database1DataSet1TableAdapters.MaterialsTableAdapter();
Database1DataSet1.MaterialsDataTable MaterialsFromDB = new Database1DataSet1.MaterialsDataTable();
mta.Fill(MaterialsFromDB);
foreach(Database1DataSet1.MaterialsRow row in MaterialsFromDB.Rows){
Material mat = new Material();
mat.ID = row.ID;
mat.Name = row.MaterialName;
mat.Density = row.Density;
mat.yieldStress = row.YieldStress;
mat.youngsModulus = row.YoungsModulus;
Program.materialList.Add(mat);
}
// Get the Shafts
Database1DataSet1TableAdapters.Shaft1TableAdapter sta = new Database1DataSet1TableAdapters.Shaft1TableAdapter();
Database1DataSet1.Shaft1DataTable ShaftsFromDB = new Database1DataSet1.Shaft1DataTable();
sta.Fill(ShaftsFromDB);
foreach (Database1DataSet1.Shaft1Row row in ShaftsFromDB.Rows) {
Shaft shaft = new Shaft();
shaft.ID = row.ID;
shaft.Name = row.ShaftName;
shaft.Diameter = row.Diameter;
shaft.KeyCutHeigth = row.KeyCutHeight;
shaft.KeyCutLength = row.KeyCutLenght;
shaft.KeyCutWidth = row.KeyCutWidth;
shaft.Material = Util.getMaterialById(row.MaterialID);
Program.shaftList.Add(shaft);
}
Database1DataSet1TableAdapters.GearsTableAdapter gta = new Database1DataSet1TableAdapters.GearsTableAdapter();
Database1DataSet1.GearsDataTable GearsFromDB = new Database1DataSet1.GearsDataTable();
gta.Fill(GearsFromDB);
foreach (Database1DataSet1.GearsRow row in GearsFromDB.Rows)
{
Gear gear = new Gear();
gear.ID = row.ID;
gear.Alpha = row.Alpha;
gear.GearModule = row.GearModule;
gear.Torque = row.Torque;
gear.WantedRadius = row.WantedRadius;
gear.Name = row.GearName;
gear.Z = row.Z;
gear.Phi = row.Phi;
gear.R_base = row.RBase;
gear.R_foot = row.RFoot;
gear.R_pitch = row.RPitch;
gear.R_top = row.RTop;
gear.Material = Util.getMaterialById(row.MaterialID);
gear.Shaft = Util.getShaftById(row.ShaftID);
Program.gearList.Add(gear);
}
Util.refreshGearBoxList();
}
public static List<int> listOfGearIds(int shaftIds, Database1DataSet1TableAdapters.GearsTableAdapter gta)
{
List<int> gearIds = new List<int>();
Database1DataSet1.GearsDataTable gearTable = new Database1DataSet1.GearsDataTable();
gearTable = gta.GetDataByShaftID(shaftIds);
foreach (Database1DataSet1.GearsRow row in gearTable)
{
int id = row.ID;
gearIds.Add(id);
}
return gearIds;
}