예제 #1
0
        public void M()
        {
            LV.Items.Clear();
            string          sql        = "SELECT * FROM STOPBUS"; // Строка запроса
            MySqlConnection connection = new MySqlConnection(connStr);
            MySqlCommand    sqlCom     = new MySqlCommand(sql, connection);

            connection.Open();
            sqlCom.ExecuteNonQuery();
            MySqlDataAdapter dataAdapter = new MySqlDataAdapter(sqlCom);
            DataTable        dt          = new DataTable();

            dataAdapter.Fill(dt);

            var myData = dt.Select();

            for (int i = 0; i < myData.Length; i++)
            {
                //for (int j = 0; j < myData[i].ItemArray.Length; j++)
                String  idBus       = myData[i].ItemArray[0].ToString();
                String  nameBusstat = myData[i].ItemArray[1].ToString();
                Busstop Station     = new Busstop(int.Parse(idBus), nameBusstat);
                LV.Items.Add(Station);
            }
        }
예제 #2
0
        private void SetCb()
        {
            cb2.Items.Clear();
            string          sql        = "SELECT * FROM STOPBUS ORDER BY NAME_STOP"; // Строка запроса
            MySqlConnection connection = new MySqlConnection(connStr);
            MySqlCommand    sqlCom     = new MySqlCommand(sql, connection);

            connection.Open();
            sqlCom.ExecuteNonQuery();
            MySqlDataAdapter dataAdapter = new MySqlDataAdapter(sqlCom);
            DataTable        dt          = new DataTable();

            dataAdapter.Fill(dt);

            var myData = dt.Select();

            for (int i = 0; i < myData.Length; i++)
            {
                //for (int j = 0; j < myData[i].ItemArray.Length; j++)
                String  idBus       = myData[i].ItemArray[0].ToString();
                String  nameBusstat = myData[i].ItemArray[1].ToString();
                Busstop Station     = new Busstop(int.Parse(idBus), nameBusstat);
                cb2.Items.Add(Station);
            }
            foreach (Busstop cmi in cb2.Items)
            {
                if (cmi.Name == update_station.Name)
                {
                    cb2.SelectedItem = cmi;
                }
            }
        }
예제 #3
0
        private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
        {
            listView.Items.Clear();
            TextBox         temp       = sender as TextBox;
            string          sql        = "SELECT * FROM STOPBUS WHERE NAME_STOP LIKE '%" + temp.Text + "%' ORDER BY NAME_STOP"; // Строка запроса
            MySqlConnection connection = new MySqlConnection(connStr);
            MySqlCommand    sqlCom     = new MySqlCommand(sql, connection);

            connection.Open();
            sqlCom.ExecuteNonQuery();
            MySqlDataAdapter dataAdapter = new MySqlDataAdapter(sqlCom);
            DataTable        dt          = new DataTable();

            dataAdapter.Fill(dt);

            var myData = dt.Select();

            for (int i = 0; i < myData.Length; i++)
            {
                //for (int j = 0; j < myData[i].ItemArray.Length; j++)
                String  idBus       = myData[i].ItemArray[0].ToString();
                String  nameBusstat = myData[i].ItemArray[1].ToString();
                Busstop Station     = new Busstop(int.Parse(idBus), nameBusstat);
                listView.Items.Add(Station);
            }
        }
예제 #4
0
 private void LV_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     if (LV.SelectedItem != null)
     {
         Busstop temp = LV.SelectedItem as Busstop;
         TextBoxNameStation.Text = temp.Name;
     }
 }
예제 #5
0
        private void step2_Click(object sender, RoutedEventArgs e)
        {
            if (listView.SelectedItem != null)
            {
                panel0.Visibility = Visibility.Visible;
                TBusStop          = listView.SelectedItem as Busstop;


                panel1.Visibility = Visibility.Hidden;

                label.Content = TBusStop.Name + " будний";
                maskTb.Text   = "";
            }
        }
예제 #6
0
 private void Button_Click_2(object sender, RoutedEventArgs e)
 {
     if (LV.SelectedItem != null)
     {
         Busstop         temp = LV.SelectedItem as Busstop;
         MySqlConnection conn = new MySqlConnection(connStr);
         conn.Open();
         string          text       = TextBoxNameStation.Text;
         string          sql        = "UPDATE `STOPBUS` SET `NAME_STOP`='" + text + "' WHERE `ID_STOP_BUS`='" + temp.ID + "';"; // Строка запроса
         MySqlConnection connection = new MySqlConnection(connStr);
         MySqlCommand    sqlCom     = new MySqlCommand(sql, connection);
         connection.Open();
         sqlCom.ExecuteNonQuery();
         M();
     }
 }
예제 #7
0
        private void Button_Click_3(object sender, RoutedEventArgs e)
        {
            if (LV.SelectedItem != null)
            {
                Busstop         temp = LV.SelectedItem as Busstop;
                MySqlConnection conn = new MySqlConnection(connStr);
                conn.Open();

                string          sql        = "DELETE FROM `STOPBUS` WHERE `ID_STOP_BUS`='" + temp.ID + "';"; // Строка запроса
                MySqlConnection connection = new MySqlConnection(connStr);
                MySqlCommand    sqlCom     = new MySqlCommand(sql, connection);
                connection.Open();
                sqlCom.ExecuteNonQuery();
                M();
            }
        }
예제 #8
0
        private void step4_Click(object sender, RoutedEventArgs e)
        {
            day.Clear();
            wday.Clear();
            foreach (TextBox tx in chRd.Children)
            {
                day.Add(tx.Text);
            }

            foreach (TextBox tx in chRw.Children)
            {
                wday.Add(tx.Text);
            }



            string sql = "UPDATE `TIMETRANSPORT` SET ";
            string qp1 = "";
            int    k   = 5;

            foreach (string st in day)
            {
                qp1 += "`T" + k + "`='" + st + "',";
                if (k < 23)
                {
                    k++;
                }
                else
                {
                    k = 0;
                }
            }

            qp1  = qp1.Remove(qp1.Length - 1);
            qp1 += " WHERE `ID_TIME`='" + one + "';";
            sql += qp1;



            MySqlConnection connection = new MySqlConnection(connStr);
            MySqlCommand    sqlCom     = new MySqlCommand(sql, connection);

            connection.Open();
            sqlCom.ExecuteNonQuery();

            sql = "UPDATE `TIMETRANSPORT` SET ";
            string qp2 = "";

            k = 5;
            foreach (string st in wday)
            {
                qp2 += "`T" + k + "`='" + st + "',";
                if (k < 23)
                {
                    k++;
                }
                else
                {
                    k = 0;
                }
            }

            qp2    = qp2.Remove(qp2.Length - 1);
            qp2   += " WHERE `ID_TIME`='" + second + "';";
            sql   += qp2;
            sqlCom = new MySqlCommand(sql, connection);

            sqlCom.ExecuteNonQuery();
            Busstop temp = cb2.SelectedItem as Busstop;

            sql    = "UPDATE `MAINROUTE` SET `ID_STOP_BUS`='" + temp.ID + "' WHERE ID='" + update_station.ID + "';";
            sqlCom = new MySqlCommand(sql, connection);

            sqlCom.ExecuteNonQuery();
            panel3.Visibility = Visibility.Hidden;
            M();
        }