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); } }
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); } }
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(); }
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); } } }