Esempio n. 1
0
        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++;
            }
        }
Esempio n. 2
0
        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);
        }