private void button2_Click(object sender, EventArgs e)
{
Generation_Class generation_class = new Generation_Class(connectionstring);
SqlDataReader read_spec = generation_class.ReadTable("Specialty");
SqlDataReader read_spiski = generation_class.ReadTable("Priority");
List<List> list_spisok = new List<List>();
while (read_spiski.Read())
{
list_spisok.Add(new List { ID_student = Convert.ToInt32(read_spiski.GetValue(1)), ID_specialty = Convert.ToInt32(read_spiski.GetValue(2)), Prio = Convert.ToInt32(read_spiski.GetValue(3)), Sum = Convert.ToInt32(read_spiski.GetValue(4)) });
}
List<ListSpec> listSpec = new List<ListSpec>();
while (read_spec.Read())
{
listSpec.Add(new ListSpec { ID = Convert.ToInt32(read_spec.GetValue(0)), Specialty = (read_spec.GetValue(1)).ToString(), Amount = Convert.ToInt32(read_spec.GetValue(2)) });
}
int i = 0;
List<ListFirstSpec> listFirstSpec = new List<ListFirstSpec>();
foreach(var k in listSpec)
{
DataGridView dgv = new DataGridView();
DataGridView dgv1 = new DataGridView();
dgv.Name = "DGV" + i.ToString();
dgv.Width = 500;
dgv.Height = 500;
dgv.Left = 0;
dgv.Top = 0;
dgv.Columns.Add("123", "Номер_студента");
dgv.Columns.Add("123", "Приоритет");
dgv.Columns.Add("123", "Сумма баллов");
tabControl1.TabPages[i].Controls.Add(dgv);
foreach (var j in list_spisok)
{
if (j.ID_specialty == k.ID)
{
//dgv.Rows.Add(j.ID_student, j.Prio, j.Sum);
}
}
i++;
}
}
private void btn_gen_Click(object sender, EventArgs e)
{
SQLiteDataReader read_stud = generation_class.writerTable("Abiturient");
SQLiteDataReader read_spec = generation_class.writerTable("Specialty");
//int count = generation_class.Count("Specialty");
int[] mas = new int[5];
int i = 0;
while (read_spec.Read())
{
mas[i] = Convert.ToInt32(read_spec.GetValue(0).ToString());
i++;
}
Random rn = new Random();
int max = 0;
int min = 0;
min = mas[0];
max = mas[0];
for (int j = 0; j < mas.Length - 1; j++)
{
for (int k = j + 1; k < mas.Length; k++)
{
if (mas[k] < min)
min = mas[k];
if (mas[k] > max)
max = mas[k];
}
}
while (read_stud.Read())
{
int[] masspec = new int[3];
for (int j = 0; j < 3; j++)
{
masspec[j] = rn.Next(min, max);
if (j > 0)
{
int temp = masspec[j];
for (int jj = j - 1; jj >= 0; jj--)
{
if (temp == masspec[jj])
{
j--;
}
}
}
}
int[] masprior = new int[3];
for (int j = 0; j < 2; j++)
{
masprior[j] = rn.Next(1, 3);
if (j > 0)
{
int temp = masprior[j];
for (int jj = j - 1; jj >= 0; jj--)
{
if (temp == masprior[jj])
{
j--;
}
}
}
}
masprior[2] = 6 - masprior[0] - masprior[1];
// for (int k = 0; k < masspec.Length; k++)
// {
/* SqlDataReader readsubj = generation_class.IdSubj(masspec[k]);
while (readsubj.Read())
{
SqlDataReader readScore = generation_class.Score(Convert.ToInt32(readsubj.GetValue(0)), Convert.ToInt32(read_stud.GetValue(0)));
while (readScore.Read())
{
sum += Convert.ToInt32(readScore.GetValue(0));
}
}*/
// sum = generation_class.Sum(masspec[k],Convert.ToInt32(read_stud.GetValue(0)));
// }
List<List> list_prio = new List<List>();
for (int k = 0; k < masspec.Length; k++)
{
list_prio.Add(new List { ID_student = Convert.ToInt32(read_stud.GetValue(0)), ID_specialty = masspec[k], Prio = masprior[k], Sum = rn.Next(150, 260) });
}
foreach (var k in list_prio)
{
generation_class.AbitSpec("AbitSpec", "id_abit", "id_spec", "prior", "scores", k.ID_student, k.ID_specialty, k.Prio, k.Sum);
}
}
generation_class.writerTableAbitSpec("AbitSpec", DGC_priority);
}