public void SetDataToTextBoxSredn() { Connect_to_sql conn = new Connect_to_sql(); string connect_string = conn.Con_str(); int kod_razrez; if (ras_param.kod_sred != -1) { Connect_to_sql.AgroDataSredn[] AgroSredn = conn.SelectDataFromDataSredn(ras_param.kod_sred, ras_param.sloj0_5, out kod_razrez, connect_string); if (AgroSredn != null) { TextBox[] str3 = GetTextBoxStroka3(); TextBox[] str4 = GetTextBoxStroka4(); TextBox[] str5 = GetTextBoxStroka5(); if (ras_param.sloj0_5) { for (int i = 0; i < 11; i++) { str3[i].Text = conn.ConvertFloatToString(AgroSredn[i].stroka3); str4[i].Text = conn.ConvertFloatToString(AgroSredn[i].stroka4); str5[i].Text = conn.ConvertFloatToString(AgroSredn[i].stroka5); } } else { for (int i = 1; i < 11; i++) { str3[i].Text = conn.ConvertFloatToString(AgroSredn[i].stroka3); str4[i].Text = conn.ConvertFloatToString(AgroSredn[i].stroka4); str5[i].Text = conn.ConvertFloatToString(AgroSredn[i].stroka5); } } SqlConnection myConnection = new SqlConnection(connect_string); string myInsertQuery = "SELECT * FROM t_razrez WHERE kod_razrez=" + kod_razrez; SqlCommand myCommand = new SqlCommand(myInsertQuery); myCommand.Connection = myConnection; myConnection.Open(); SqlDataReader reader = myCommand.ExecuteReader(); TextBox[] TextBoxNum = GetTextBoxOb_massa_pochvi(); TextBox[] TextBoxVes = GetTextBoxVl_ustoj_zav(); int ii = 0; while (reader.Read()) { int ind = listBox1.Items.IndexOf(reader[1].ToString()); listBox1.SelectedIndex = ind; textBox133.Text = reader[1].ToString(); for (int i = 2; i < 13; i++) { TextBoxNum[ii].Text = reader[i].ToString(); ii++; } ii = 0; for (int i = 13; i < 24; i++) { TextBoxVes[ii].Text = reader[i].ToString(); ii++; } } myCommand.Connection.Close(); TextBox[] stroka5 = GetTextBoxStroka5(); float[] val = new float[10]; for (int i = 0; i < 10; i++) { val[i] = conn.ConvertStringToFloat(stroka5[i + 1].Text, 1); } Connect_to_sql.ResultStepUvl[] res_step = conn.GetResultStepUvl(val, textBox133.Text, connect_string); /*for (int i = 0; i < 10; i++) { if (res_step[i].color != 0) stroka5[i + 1].BackColor = Color.FromArgb(res_step[i].color); }*/ if (res_step[0].color != 0) { textBox137.BackColor = Color.FromArgb(res_step[0].color); } if (res_step[1].color != 0) { textBox138.BackColor = Color.FromArgb(res_step[1].color); } if (res_step[4].color != 0) { textBox139.BackColor = Color.FromArgb(res_step[4].color); } if (res_step[9].color != 0) { textBox140.BackColor = Color.FromArgb(res_step[9].color); } } } }
private void button2_Click_1(object sender, EventArgs e) { Connect_to_sql conn = new Connect_to_sql(); string connect_string = conn.Con_str(); float[] SrednVl = conn.GetSrednPovtorn(ras_param.Glav_ID, ras_param.sloj0_5, ras_param.marshrut, connect_string); TextBox[] stroka1 = GetTextBoxOb_massa_pochvi(); TextBox[] stroka2 = GetTextBoxVl_ustoj_zav(); TextBox[] stroka3 = GetTextBoxStroka3(); TextBox[] stroka4 = GetTextBoxStroka4(); TextBox[] stroka5 = GetTextBoxStroka5(); Connect_to_sql.AgroDataSredn[] DataSred = new Connect_to_sql.AgroDataSredn[11]; for (int i = 0; i < 11; i++) { stroka3[i].Text = conn.ConvertFloatToString(SrednVl[i]); } if (!ras_param.sloj0_5) { for (int i = 1; i < 11; i++) { float str3 = conn.ConvertStringToFloat(stroka3[i].Text,1); float str2 = conn.ConvertStringToFloat(stroka2[i].Text,2); float str1 = conn.ConvertStringToFloat(stroka1[i].Text,2); float srt_rez = (str3 - str2) * str1; stroka4[i].Text = conn.ConvertFloatToString(conn.RoundTo(srt_rez, 1)); } stroka5[1].Text = stroka4[1].Text; for (int i = 2; i < 11; i++) { stroka5[i].Text = conn.ConvertFloatToString(conn.RoundTo((conn.ConvertStringToFloat(stroka5[i - 1].Text, 1) + conn.ConvertStringToFloat(stroka4[i].Text, 1)), 1)); } for (int i = 1; i < 11; i++) { DataSred[i].stroka3 = conn.ConvertStringToFloat(stroka3[i].Text,1); DataSred[i].stroka4 = conn.ConvertStringToFloat(stroka4[i].Text,1); DataSred[i].stroka5 = conn.ConvertStringToFloat(stroka5[i].Text,1); } conn.AddRowToSredn(DataSred, ras_param.sloj0_5, ras_param.Glav_ID, textBox133.Text, connect_string); } else { for (int i = 0; i < 11; i++) { float str3 = conn.ConvertStringToFloat(stroka3[i].Text,1); float str2 = conn.ConvertStringToFloat(stroka2[i].Text,2); float str1 = conn.ConvertStringToFloat(stroka1[i].Text,2); float srt_rez = (str3 - str2) * str1; stroka4[i].Text = conn.ConvertFloatToString(conn.RoundTo(srt_rez, 1)); } stroka4[0].Text = conn.ConvertFloatToString(conn.RoundTo((conn.ConvertStringToFloat(stroka4[0].Text, 1) / 2), 1)); stroka4[1].Text = conn.ConvertFloatToString(conn.RoundTo((conn.ConvertStringToFloat(stroka4[1].Text, 1) / 2), 1)); stroka5[0].Text = stroka4[0].Text; for (int i = 1; i < 11; i++) { stroka5[i].Text = conn.ConvertFloatToString(conn.RoundTo((conn.ConvertStringToFloat(stroka5[i - 1].Text, 1) + conn.ConvertStringToFloat(stroka4[i].Text, 1)), 1)); } for (int i = 0; i < 11; i++) { DataSred[i].stroka3 = conn.ConvertStringToFloat(stroka3[i].Text, 1); DataSred[i].stroka4 = conn.ConvertStringToFloat(stroka4[i].Text, 1); DataSred[i].stroka5 = conn.ConvertStringToFloat(stroka5[i].Text, 1); } conn.AddRowToSredn(DataSred, ras_param.sloj0_5, ras_param.Glav_ID, textBox133.Text, connect_string); } float[] val = new float[10]; for (int i = 0; i < 10; i++) { val[i] = conn.ConvertStringToFloat(stroka5[i + 1].Text, 1); } Connect_to_sql.ResultStepUvl[] res_step = conn.GetResultStepUvl(val, textBox133.Text, connect_string); /* for (int i = 0; i < 10; i++) { if(res_step[i].color!=0) stroka5[i + 1].BackColor = Color.FromArgb(res_step[i].color); }*/ if (res_step[0].color != 0) { textBox137.BackColor = Color.FromArgb(res_step[0].color); } if (res_step[1].color != 0) { textBox138.BackColor = Color.FromArgb(res_step[1].color); } if (res_step[4].color != 0) { textBox139.BackColor = Color.FromArgb(res_step[4].color); } if (res_step[9].color != 0) { textBox140.BackColor = Color.FromArgb(res_step[9].color); } }
private void button1_Click(object sender, EventArgs e) { try { if (textBox1.Text != "") { Connect_to_sql conn = new Connect_to_sql(); string connect_string = conn.Con_str(); Connect_to_sql.AgroStakan[] agr_st = new Connect_to_sql.AgroStakan[11]; TextBox[] TextBoxNum = GetTextBoxNumber(); TextBox[] TextBoxVes = GetTextBoxVes(); string ves = ""; for (int i = 0; i < 11; i++) { agr_st[i].nomer_stakan = Convert.ToInt32(TextBoxNum[i].Text); ves = TextBoxVes[i].Text; ves = ves.Replace('.', ','); agr_st[i].ves_stakan = conn.ConvertStringToFloat(ves, 1); } conn.AddRowToStakan(textBox1.Text, agr_st, connect_string); listBox1.Items.Add(textBox1.Text); MessageBox.Show("Запись успешно добавлена", "Оповещение", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Не задано название группы стаканчиков!", "Предупреждение!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Ошибка!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }