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