private void button1_Click(object sender, EventArgs e) { try { Connect_to_sql conn = new Connect_to_sql(); string connect_string = conn.Con_str(); TextBox[] stolbec1 = GetTextBoxVesVlazhPochvi(); TextBox[] stolbec2 = GetTextBoxVesSuhojPochvi(); TextBox[] stolbec3 = GetTextBoxVesStakan(); TextBox[] stolbec4 = GetTextBoxPole4(); TextBox[] stolbec5 = GetTextBoxPole5(); TextBox[] stolbec6 = GetTextBoxPole6(); TextBox[] stolbec7 = GetTextBoxPole7(); for (int i = 0; i < 11; i++) { stolbec1[i].Text = stolbec1[i].Text.Replace('.', ','); stolbec2[i].Text = stolbec2[i].Text.Replace('.', ','); stolbec3[i].Text = stolbec3[i].Text.Replace('.', ','); } if (!ras_param.sloj0_5) { for (int i = 1; i < 11; i++) { stolbec4[i].Text = Convert.ToString(conn.RoundTo((Convert.ToDouble(stolbec1[i].Text) - Convert.ToDouble(stolbec2[i].Text)), 1)); } for (int i = 1; i < 11; i++) { stolbec5[i].Text = Convert.ToString(conn.RoundTo((Convert.ToDouble(stolbec2[i].Text) - Convert.ToDouble(stolbec3[i].Text)), 1)); } for (int i = 1; i < 11; i++) { stolbec6[i].Text = Convert.ToString(conn.RoundTo(((Convert.ToDouble(stolbec4[i].Text) / Convert.ToDouble(stolbec5[i].Text)) * 100), 1)); } for (int i = 1; i < 11; i++) { stolbec7[i].Text = Convert.ToString(conn.RoundTo((Convert.ToDouble(stolbec1[i].Text) - Convert.ToDouble(stolbec3[i].Text)), 1)); } } else { for (int i = 0; i < 11; i++) { stolbec4[i].Text = Convert.ToString(conn.RoundTo((Convert.ToDouble(stolbec1[i].Text) - Convert.ToDouble(stolbec2[i].Text)), 1)); } for (int i = 0; i < 11; i++) { stolbec5[i].Text = Convert.ToString(conn.RoundTo((Convert.ToDouble(stolbec2[i].Text) - Convert.ToDouble(stolbec3[i].Text)), 1)); } for (int i = 0; i < 11; i++) { stolbec6[i].Text = Convert.ToString(conn.RoundTo(((Convert.ToDouble(stolbec4[i].Text) / Convert.ToDouble(stolbec5[i].Text)) * 100), 1)); } for (int i = 0; i < 11; i++) { stolbec7[i].Text = Convert.ToString(conn.RoundTo((Convert.ToDouble(stolbec1[i].Text) - Convert.ToDouble(stolbec3[i].Text)), 1)); } } Connect_to_sql.AgroDataPovt[] DataPovt = new Connect_to_sql.AgroDataPovt[11]; for (int i = 0; i < 11; i++) { DataPovt[i].ves_vlazhnoj = ConvertStringToFloat(stolbec1[i].Text); DataPovt[i].ves_suhoj = ConvertStringToFloat(stolbec2[i].Text); DataPovt[i].ves_stakan = ConvertStringToFloat(stolbec3[i].Text); DataPovt[i].vlazhn_suhaya = ConvertStringToFloat(stolbec4[i].Text); DataPovt[i].suhaya_stakan = ConvertStringToFloat(stolbec5[i].Text); DataPovt[i].procent_isparivsh_vlagi = ConvertStringToFloat(stolbec6[i].Text); DataPovt[i].vlazhnaya_stakan = ConvertStringToFloat(stolbec7[i].Text); } string query_progress = "SELECT progress FROM t_Glavnaya WHERE kod=" + ras_param.Glav_ID; if (!ras_param.marshrut) { if (((int)comboBox1.SelectedItem == comboBox1.Items.Count) && ((int)comboBox1.SelectedItem <= 4)) { int progress = conn.ExecQueryWithResult(connect_string, query_progress); if (progress == 4) { string query_delRowFrom = "DELETE FROM t_data_povt WHERE kod_Glavn=" + ras_param.Glav_ID + " AND Povtornost=" + (int)comboBox1.SelectedItem; conn.ExecQuery(connect_string, query_delRowFrom); } conn.InsertRowToDataPovt(ras_param.Glav_ID, (int)comboBox1.SelectedItem, DataPovt, ras_param.sloj0_5, textBox134.Text, connect_string); string query_edit_progress = "UPDATE t_Glavnaya SET progress=" + comboBox1.Items.Count + " WHERE kod=" + ras_param.Glav_ID; conn.ExecQuery(connect_string, query_edit_progress); if (comboBox1.Items.Count < 4) { comboBox1.Items.Add((int)comboBox1.SelectedItem + 1); } } else { string query_delRowFrom = "DELETE FROM t_data_povt WHERE kod_Glavn=" + ras_param.Glav_ID + " AND Povtornost=" + (int)comboBox1.SelectedItem; conn.ExecQuery(connect_string, query_delRowFrom); conn.InsertRowToDataPovt(ras_param.Glav_ID, (int)comboBox1.SelectedItem, DataPovt, ras_param.sloj0_5, textBox134.Text, connect_string); } } else { if (((int)comboBox1.SelectedItem == comboBox1.Items.Count) && ((int)comboBox1.SelectedItem <= 2)) { int progress = conn.ExecQueryWithResult(connect_string, query_progress); if (progress == 2) { string query_delRowFrom = "DELETE FROM t_data_povt WHERE kod_Glavn=" + ras_param.Glav_ID + " AND Povtornost=" + (int)comboBox1.SelectedItem; conn.ExecQuery(connect_string, query_delRowFrom); } conn.InsertRowToDataPovt(ras_param.Glav_ID, (int)comboBox1.SelectedItem, DataPovt, ras_param.sloj0_5, textBox134.Text, connect_string); // int progress = conn.ExecQueryWithResult(connect_string, query_progress); string query_edit_progress = "UPDATE t_Glavnaya SET progress=" + comboBox1.Items.Count + " WHERE kod=" + ras_param.Glav_ID; conn.ExecQuery(connect_string, query_edit_progress); if (comboBox1.Items.Count < 2) { comboBox1.Items.Add((int)comboBox1.SelectedItem + 1); } } else { string query_delRowFrom = "DELETE FROM t_data_povt WHERE kod_Glavn=" + ras_param.Glav_ID + " AND Povtornost=" + (int)comboBox1.SelectedItem; conn.ExecQuery(connect_string, query_delRowFrom); conn.InsertRowToDataPovt(ras_param.Glav_ID, (int)comboBox1.SelectedItem, DataPovt, ras_param.sloj0_5, textBox134.Text, connect_string); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }