private void Button_Click(object sender, RoutedEventArgs e)
        {
            string comboSelectedValue = charSet.SelectedItem.ToString().Replace("System.Windows.Controls.ComboBoxItem: ", "");
            string charSetS           = getCharSet(comboSelectedValue);
            string createStr          = "CREATE DATABASE `";

            createStr += this.DBName.Text + "` ";
            if (comboSelectedValue != "binary")
            {
                createStr += "DEFAULT CHARACTER SET " + charSetS + " COLLATE " + comboSelectedValue;
            }
            else
            {
                createStr += "DEFAULT CHARACTER SET binary";
            }

            MySqlLib.MySqlData.MySqlExecute.MyResult result =
                MySqlLib.MySqlData.MySqlExecute.SqlNoneQuery(createStr, connectString);
            if (result.HasError == false)
            {
                MainWindow wnd = (MainWindow)App.Current.MainWindow;
                wnd.SelectDataBases();
                this.Close();
            }
            else
            {
                MessageBox.Show(result.ErrorText);
            }
        }
Example #2
0
        private async void showAcceptCreateTableDialog()
        {
            var mySettings = new MetroDialogSettings()
            {
                AffirmativeButtonText = "Да",
                NegativeButtonText    = "Нет",
                MaximumBodyHeight     = 100,
                ColorScheme           = MetroDialogOptions.ColorScheme
            };

            MessageDialogResult result = await this.ShowMessageAsync("SQL-запрос сформирован. Хотите выполнить его?", "" + string.Join(Environment.NewLine, SQLQuery),
                                                                     MessageDialogStyle.AffirmativeAndNegative, mySettings);

            if (result == MessageDialogResult.Affirmative)
            {
                MainWindow wnd = (MainWindow)App.Current.MainWindow;
                MySqlLib.MySqlData.MySqlExecute.MyResult queryResult =
                    MySqlLib.MySqlData.MySqlExecute.SqlNoneQuery(SQLQuery, connectStr);
                if (queryResult.HasError == false)
                {
                    MessageBox.Show("Запрос выполнился без ошибок");
                    wnd.updateCurrentTable();
                    wnd.Activate();
                    this.Close();
                }
                else
                {
                    MessageBox.Show(queryResult.ErrorText, "Возникла ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
                    wnd.Activate();
                    this.Close();
                }
            }
        }
        private void SqlNoneQuery(string query)
        {
            MySqlLib.MySqlData.MySqlExecute.MyResult result =
                MySqlLib.MySqlData.MySqlExecute.SqlNoneQuery(query, connectStr);

            if (result.HasError == false)
            {
                SensorsGridUpdate();
            }
            else
            {
                MessageBox.Show(result.ErrorText);
            }
        }
        private void acceptChanges(object sender, EventArgs e)
        {
            string SQLQuery = "UPDATE `" + dataBase + "`.`" +
                              table + "`" + " SET ";
            int index = 7;

            for (int i = 0; i < columns.Length; i++)
            {
                TextBox tb = (TextBox)MainGrid.Children[index];
                if (tb.Text != null && tb.Text != "")
                {
                    SQLQuery += "`" + table + "`" + "." + "`" + columns[i] + "` = '"
                                + tb.Text + "', ";
                }
                index += 4;
            }
            SQLQuery += "replaceme";
            if (!SQLQuery.Contains("'"))
            {
                this.Close();
            }
            else
            {
                SQLQuery  = SQLQuery.Replace(", replaceme", " WHERE ");
                SQLQuery += "`" + table + "`.`" + columns[0] + "` = '" +
                            rows[0] + "' ";
                for (int i = 1; i < columns.Length; i++)
                {
                    if (types[i] == "date" || types[i] == "datetime")
                    {
                        continue;
                    }
                    SQLQuery += "AND `" + table + "`.`" + columns[i] + "` = '" +
                                rows[i] + "' ";
                }
                SQLQuery += "LIMIT 1";
            }
            MySqlLib.MySqlData.MySqlExecute.MyResult result =
                MySqlLib.MySqlData.MySqlExecute.SqlNoneQuery(SQLQuery, connectString);
            if (result.HasError == false)
            {
                this.Close();
            }
            else
            {
                MessageBox.Show(result.ErrorText);
            }
        }
Example #5
0
        void pokazaniya_och(object sender, EventArgs e)
        {
            string conn_str = "Database=" + notify.Properties.Settings.Default.database_name + ";Data Source=" + notify.Properties.Settings.Default.database_ip + ";User Id=" + notify.Properties.Settings.Default.user + ";Password="******"SELECT stoki_tek FROM resources.`stoki_tek` ORDER BY stoki_tek_date DESC LIMIT 0,1", conn_str);
            result2 = MySqlLib.MySqlData.MySqlExecute.SqlScalar("SELECT stoki_tek_date FROM resources.`stoki_tek` ORDER BY stoki_tek_date DESC LIMIT 0,1", conn_str);

            label2.Text = result.ResultText;
            label3.Text = result2.ResultText;
            toolStripStatusLabel2.Text = Convert.ToString(DateTime.Now);
            statusStrip1.Update();
        }
Example #6
0
        private void Form1_Load(object sender, EventArgs e)
        {
            bool status_och = PingHost ("10.1.4.160");
            bool status_db = PingHost("10.1.1.50");

            if (status_och == true)
                {
                    label6.Text = "Доступен";
                    label6.ForeColor = System.Drawing.Color.ForestGreen;

                }
            else
                {
                    label6.Text = "Недоступен";
                    label6.ForeColor = System.Drawing.Color.OrangeRed;
                }

            if (status_db == true)
            {
                label5.Text = "Доступен";
                label5.ForeColor = System.Drawing.Color.ForestGreen;

            }
            else
            {
                label5.Text = "Недоступен";
                label5.ForeColor = System.Drawing.Color.OrangeRed;
            }

            string conn_str = "Database=" + notify.Properties.Settings.Default.database_name + ";Data Source=" + notify.Properties.Settings.Default.database_ip + ";User Id=" + notify.Properties.Settings.Default.user + ";Password="******"SELECT stoki_tek FROM resources.`stoki_tek` ORDER BY stoki_tek_date DESC LIMIT 0,1", conn_str);
            result2 = MySqlLib.MySqlData.MySqlExecute.SqlScalar("SELECT stoki_tek_date FROM resources.`stoki_tek` ORDER BY stoki_tek_date DESC LIMIT 0,1", conn_str);

            label2.Text = result.ResultText;
            label3.Text = result2.ResultText;

            this.Left = Screen.PrimaryScreen.Bounds.Width - this.Width;
            this.Top = Screen.PrimaryScreen.Bounds.Height - this.Height;

            Timer timer = new Timer();
            timer.Interval = 60000;
            timer.Tick += new EventHandler(pokazaniya_och);

            toolStripStatusLabel2.Text = Convert.ToString(DateTime.Now);
            statusStrip1.Update();

            timer.Start();
        }
        private void AcceptChanges(object sender, EventArgs e)
        {
            string SQLQuery;

            if (isWindowForSearch == false)
            {
                SQLQuery = "INSERT INTO `" + dataBase + "`.`" +
                           table + "`" + " (";
                for (int i = 0; i < columns.Length; i++)
                {
                    SQLQuery += "`" + columns[i] + "`, ";
                }
                SQLQuery += "replaceme";
                SQLQuery  = SQLQuery.Replace(", replaceme", ") ");
                SQLQuery += "VALUES(";
                int index = 5;
                for (int i = 0; i < columns.Length; i++)
                {
                    TextBox tb = (TextBox)MainGrid.Children[index];
                    SQLQuery += "'" + tb.Text + "', ";
                    index    += 3;
                }
                SQLQuery += "replaceme";
                SQLQuery  = SQLQuery.Replace(", replaceme", ")");
                MySqlLib.MySqlData.MySqlExecute.MyResult result =
                    MySqlLib.MySqlData.MySqlExecute.SqlNoneQuery(SQLQuery, connectString);
                if (result.HasError == false)
                {
                    this.Close();
                }
                else
                {
                    MessageBox.Show(result.ErrorText);
                }
            }
            else
            {
                SQLQuery = "SELECT * FROM `" + table + "`" + " WHERE ";
                int index = 5;
                for (int i = 0; i < columns.Length; i++)
                {
                    TextBox tb = (TextBox)MainGrid.Children[index];
                    if (tb.Text != null && tb.Text != "")
                    {
                        SQLQuery += "`" + columns[i] + "` = " + "'" + tb.Text + "' AND ";
                        index    += 3;
                    }
                }
                SQLQuery += "replaceme";
                SQLQuery  = SQLQuery.Replace("AND replaceme", " LIMIT 0, 30");

                MySqlLib.MySqlData.MySqlExecuteData.MyResultData result = new MySqlLib.MySqlData.MySqlExecuteData.MyResultData();
                result = MySqlLib.MySqlData.MySqlExecuteData.SqlReturnDataset(SQLQuery, connectStringWithDb);
                if (result.HasError == false)
                {
                    openedGrid.ItemsSource = result.ResultData.DefaultView;
                    this.Close();
                }
                else
                {
                    MessageBox.Show(result.ErrorText);
                }
            }
        }