Esempio n. 1
0
        private void btn_firms_in_country_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Страна", "Введите маску страны");

            if (dialog.ShowDialog() == true)
            {
                string sql = $"SELECT * FROM firms_country_like('{dialog.ResponseText}')";
                FillGridFromDataSet(FillDataSetFromDB(sql));
            }
        }
        private void btn_orders_V_fuels_like_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Топливо", "Введите название топлива");

            if (dialog.ShowDialog() == true)
            {
                string sql = $"SELECT * FROM \"orders_sum_where_V_fuel_like\"('{dialog.ResponseText}')";
                FillGridFromDataSet(FillDataSetFromDB(sql));
            }
        }
Esempio n. 3
0
        private void btn_orders_by_firm_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Фирма", "Введите фирму");

            if (dialog.ShowDialog() == true)
            {
                string sql = $"SELECT * FROM zakazi_by_firm('{dialog.ResponseText}')";
                FillGridFromDataSet(FillDataSetFromDB(sql));
            }
        }
        private void btn_not_in_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Месяцы", "Введите за сколько последних месяцев");

            if (dialog.ShowDialog() == true)
            {
                try
                {
                    string sql = $"SELECT * FROM \"no_buyers_last_months\"({dialog.ResponseText})";
                    FillGridFromDataSet(FillDataSetFromDB(sql));
                }
                catch (Exception ee)
                {
                    MessageBox.Show("Вы ввели не число", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }
        private void btn_avg_orders_bigger_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Объём", "Введите N");

            if (dialog.ShowDialog() == true)
            {
                try
                {
                    string sql = $"SELECT * FROM \"avg_orders_bigger\"({dialog.ResponseText})";
                    FillGridFromDataSet(FillDataSetFromDB(sql));
                }
                catch (Exception ee)
                {
                    MessageBox.Show("Вы ввели не число", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }
Esempio n. 6
0
        private void btn_not_in_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Месяцы", "Введите интервал в месяцах");

            if (dialog.ShowDialog() == true)
            {
                try
                {
                    string sql = $"SELECT * FROM no_hospitals_by_last_months({dialog.ResponseText})";
                    FillGridFromDataSet(FillDataSetFromDB(sql));
                }
                catch (Exception ee)
                {
                    MessageBox.Show("Вы ввели не число", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }
Esempio n. 7
0
        private void btn_sum_zakazi_by_firm_where_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("количество", "Введите количество товаров для данных");

            if (dialog.ShowDialog() == true)
            {
                try
                {
                    string sql = $"SELECT * FROM sum_zakazi_by_firm_where({dialog.ResponseText})";
                    FillGridFromDataSet(FillDataSetFromDB(sql));
                }
                catch (Exception ee)
                {
                    MessageBox.Show("Вы ввели не число", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }
Esempio n. 8
0
        private void btn_orders_by_last_years_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Месяцы", "Введите за сколько последних лет вернуть заказы");

            if (dialog.ShowDialog() == true)
            {
                try
                {
                    string sql = $"SELECT * FROM zakazi_by_last_years({dialog.ResponseText})";
                    FillGridFromDataSet(FillDataSetFromDB(sql));
                }
                catch (Exception ee)
                {
                    MessageBox.Show("Вы ввели не число", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }
Esempio n. 9
0
        private void btn_orders_by_hospital_Click(object sender, RoutedEventArgs e)
        {
            var dialog = new MyDialog("Больница", "Введите Номер больницы");

            if (dialog.ShowDialog() == true)
            {
                try
                {
                    string sql = $"SELECT * FROM zakazi_by_hospital({dialog.ResponseText})";
                    FillGridFromDataSet(FillDataSetFromDB(sql));
                }
                catch (Exception ee)
                {
                    MessageBox.Show("Вы ввели не число", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                }
            }
        }