public AgroDataPovt[] SelectFromDataPovt(int kod_glav, int povtornost, out int kod_stak,string myConnectionString) { string query_select = "SELECT * FROM t_data_povt WHERE kod_Glavn=" + kod_glav + " AND Povtornost=" + povtornost; AgroDataPovt[] agrodata = new AgroDataPovt[11]; SqlConnection myConnection = new SqlConnection(myConnectionString); string myInsertQuery = query_select; SqlCommand myCommand = new SqlCommand(myInsertQuery); myCommand.Connection = myConnection; myConnection.Open(); SqlDataReader reader = myCommand.ExecuteReader(); kod_stak = -1; while (reader.Read()) { for (int i = 3; i < 14; i++) { agrodata[i - 3].ves_suhoj = ConvertStringToFloat(reader[i].ToString(),1); } for (int i = 14; i < 25; i++) { agrodata[i - 14].ves_vlazhnoj = ConvertStringToFloat(reader[i].ToString(), 1); } for (int i = 25; i < 36; i++) { agrodata[i - 25].ves_stakan = ConvertStringToFloat(reader[i].ToString(), 1); } for (int i = 36; i < 47; i++) { agrodata[i - 36].vlazhn_suhaya = ConvertStringToFloat(reader[i].ToString(), 1); } for (int i = 47; i < 58; i++) { agrodata[i - 47].suhaya_stakan = ConvertStringToFloat(reader[i].ToString(), 1); } for (int i = 58; i < 69; i++) { agrodata[i - 58].procent_isparivsh_vlagi = ConvertStringToFloat(reader[i].ToString(), 1); } for (int i = 69; i < 80; i++) { agrodata[i - 69].vlazhnaya_stakan = ConvertStringToFloat(reader[i].ToString(), 1); } if (reader[80] != DBNull.Value) { kod_stak = Convert.ToInt32(reader[80]); } } return agrodata; }
public void InsertRowToDataPovt(int kod_glavn_tabl, int povtornost, AgroDataPovt[] DataPovtorn /*Структура с данными повторности*/, bool marshrutnaya /*если true то марштуртая*/, string name_stak ,string myConnectionString) { int kod_st = SelectKodFormStakanGrup(name_stak, myConnectionString); if (!marshrutnaya) { string query = "INSERT INTO t_data_povt (kod_Glavn, Povtornost, v_suhoj_1, v_suhoj_2, v_suhoj_3, v_suhoj_4, v_suhoj_5, v_suhoj_6, v_suhoj_7, v_suhoj_8, v_suhoj_9, v_suhoj_10," + " v_vlazh_1, v_vlazh_2, v_vlazh_3, v_vlazh_4, v_vlazh_5, v_vlazh_6, v_vlazh_7, v_vlazh_8, v_vlazh_9, v_vlazh_10," + " v_stakan_1, v_stakan_2, v_stakan_3, v_stakan_4, v_stakan_5, v_stakan_6, v_stakan_7, v_stakan_8, v_stakan_9, v_stakan_10," + " vlazh_suh_1, vlazh_suh_2, vlazh_suh_3, vlazh_suh_4, vlazh_suh_5, vlazh_suh_6, vlazh_suh_7, vlazh_suh_8, vlazh_suh_9, vlazh_suh_10," + " suh_stak_1, suh_stak_2, suh_stak_3, suh_stak_4, suh_stak_5, suh_stak_6, suh_stak_7, suh_stak_8, suh_stak_9, suh_stak_10," + " Poc_isp_vl_1, Poc_isp_vl_2, Poc_isp_vl_3, Poc_isp_vl_4, Poc_isp_vl_5, Poc_isp_vl_6, Poc_isp_vl_7, Poc_isp_vl_8, Poc_isp_vl_9," + " Poc_isp_vl_10, vlazh_stak_1, vlazh_stak_2, vlazh_stak_3, vlazh_stak_4, vlazh_stak_5, vlazh_stak_6, vlazh_stak_7, vlazh_stak_8," + " vlazh_stak_9, vlazh_stak_10, kod_stak_grup) VALUES ("; query = query + kod_glavn_tabl + ","; query = query + povtornost + ","; for (int i = 1; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].ves_suhoj) + ","; } for (int i = 1; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].ves_vlazhnoj) + ","; } for (int i = 1; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].ves_stakan) + ","; } for (int i = 1; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].vlazhn_suhaya) + ","; } for (int i = 1; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].suhaya_stakan) + ","; } for (int i = 1; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].procent_isparivsh_vlagi) + ","; } for (int i = 1; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].vlazhnaya_stakan) + ","; } query += kod_st.ToString() + ")"; ExecQuery(myConnectionString, query); } else { string query = "INSERT INTO t_data_povt (kod_Glavn, Povtornost, v_suhoj_0, v_suhoj_1, v_suhoj_2, v_suhoj_3, v_suhoj_4, v_suhoj_5, v_suhoj_6, v_suhoj_7, v_suhoj_8, v_suhoj_9, v_suhoj_10, " + "v_vlazh_0, v_vlazh_1, v_vlazh_2, v_vlazh_3, v_vlazh_4, v_vlazh_5, v_vlazh_6, v_vlazh_7, v_vlazh_8, v_vlazh_9, v_vlazh_10, v_stakan_0, " + "v_stakan_1, v_stakan_2, v_stakan_3, v_stakan_4, v_stakan_5, v_stakan_6, v_stakan_7, v_stakan_8, v_stakan_9, v_stakan_10, vlazh_suh_0, " + "vlazh_suh_1, vlazh_suh_2, vlazh_suh_3, vlazh_suh_4, vlazh_suh_5, vlazh_suh_6, vlazh_suh_7, vlazh_suh_8, vlazh_suh_9, vlazh_suh_10, " + "suh_stak_0, suh_stak_1, suh_stak_2, suh_stak_3, suh_stak_4, suh_stak_5, suh_stak_6, suh_stak_7, suh_stak_8, suh_stak_9, suh_stak_10," + "Poc_isp_vl_0, Poc_isp_vl_1, Poc_isp_vl_2, Poc_isp_vl_3, Poc_isp_vl_4, Poc_isp_vl_5, Poc_isp_vl_6, Poc_isp_vl_7, Poc_isp_vl_8, Poc_isp_vl_9, " + "Poc_isp_vl_10, vlazh_stak_0, vlazh_stak_1, vlazh_stak_2, vlazh_stak_3, vlazh_stak_4, vlazh_stak_5, vlazh_stak_6, vlazh_stak_7, vlazh_stak_8, " + "vlazh_stak_9, vlazh_stak_10, kod_stak_grup) VALUES ("; query = query + kod_glavn_tabl + ","; query = query + povtornost + ","; for (int i = 0; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].ves_suhoj) + ","; } for (int i = 0; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].ves_vlazhnoj) + ","; } for (int i = 0; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].ves_stakan) + ","; } for (int i = 0; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].vlazhn_suhaya) + ","; } for (int i = 0; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].suhaya_stakan) + ","; } for (int i = 0; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].procent_isparivsh_vlagi) + ","; } for (int i = 0; i < 11; i++) { query = query + ConvertFloatToString(DataPovtorn[i].vlazhnaya_stakan) + ","; } query += kod_st.ToString() + ")"; ExecQuery(myConnectionString, query); } }