public void AddRowToSredn(AgroDataSredn[] DataSredn, bool sloj0_5, int Kod_Glavn, string name_razrez, string myConnectionString)
{
string query_ifExist = "SELECT Kod_Sred FROM t_Glavnaya WHERE kod=" + Kod_Glavn;
int exist = ExecQueryWithResult(myConnectionString, query_ifExist);
if (exist != -1)
{
string query_delete_sred = "DELETE FROM t_data_sredn WHERE Kod_sredn=" + exist;
ExecQuery(myConnectionString, query_delete_sred);
}
int kod_razrez = SelectKodFormRazrez(name_razrez, myConnectionString);
if (sloj0_5)
{
string query = "INSERT INTO t_data_sredn( ras_vlazn_p_0, ras_vlazn_p_1, ras_vlazn_p_2, ras_vlazn_p_3, ras_vlazn_p_4, ras_vlazn_p_5, ras_vlazn_p_6, ras_vlazn_p_7, ras_vlazn_p_8, "
+ "ras_vlazn_p_9, ras_vlazn_p_10, zap_vlagi_0, zap_vlagi_1, zap_vlagi_2, zap_vlagi_3, zap_vlagi_4, zap_vlagi_5, zap_vlagi_6, zap_vlagi_7, "
+ "zap_vlagi_8, zap_vlagi_9, zap_vlagi_10, zap_vl_narast_itog_0, zap_vl_narast_itog_1, zap_vl_narast_itog_2, zap_vl_narast_itog_3, "
+ "zap_vl_narast_itog_4, zap_vl_narast_itog_5, zap_vl_narast_itog_6, zap_vl_narast_itog_7, zap_vl_narast_itog_8, zap_vl_narast_itog_9, "
+ "zap_vl_narast_itog_10, Kod_Razrez) VALUES(";
for (int i = 0; i < 11; i++)
{
query = query + ConvertFloatToString(DataSredn[i].stroka3) + ",";
}
for (int i = 0; i < 11; i++)
{
query = query + ConvertFloatToString(DataSredn[i].stroka4) + ",";
}
for (int i = 0; i < 11; i++)
{
query = query + ConvertFloatToString(DataSredn[i].stroka5) + ",";
}
query = query + kod_razrez.ToString() + ")";
ExecQuery(myConnectionString, query);
}
else
{
string query = "INSERT INTO t_data_sredn( ras_vlazn_p_1, ras_vlazn_p_2, ras_vlazn_p_3, ras_vlazn_p_4, ras_vlazn_p_5, ras_vlazn_p_6, ras_vlazn_p_7, ras_vlazn_p_8, "
+ "ras_vlazn_p_9, ras_vlazn_p_10, zap_vlagi_1, zap_vlagi_2, zap_vlagi_3, zap_vlagi_4, zap_vlagi_5, zap_vlagi_6, zap_vlagi_7, "
+ "zap_vlagi_8, zap_vlagi_9, zap_vlagi_10, zap_vl_narast_itog_1, zap_vl_narast_itog_2, zap_vl_narast_itog_3, "
+ "zap_vl_narast_itog_4, zap_vl_narast_itog_5, zap_vl_narast_itog_6, zap_vl_narast_itog_7, zap_vl_narast_itog_8, zap_vl_narast_itog_9, "
+ "zap_vl_narast_itog_10, Kod_Razrez) VALUES(";
for (int i = 1; i < 11; i++)
{
query = query + ConvertFloatToString(DataSredn[i].stroka3) + ",";
}
for (int i = 1; i < 11; i++)
{
query = query + ConvertFloatToString(DataSredn[i].stroka4) + ",";
}
for (int i = 1; i < 11; i++)
{
query = query + ConvertFloatToString(DataSredn[i].stroka5) + ",";
}
query = query + kod_razrez.ToString() + ")";
ExecQuery(myConnectionString, query);
}
string query_return_id = "SELECT IDENT_CURRENT('t_data_sredn') AS Expr1";
int id = ExecQueryWithResult(myConnectionString, query_return_id);
string query_Update_Glavn = "UPDATE t_Glavnaya SET Kod_Sred=" + id + " WHERE Kod=" + Kod_Glavn;
ExecQuery(myConnectionString, query_Update_Glavn);
}
public AgroDataSredn[] SelectDataFromDataSredn(int kod_Sredn,bool sloj0_5, out int kod_razrez ,string myConnectionString)
{
kod_razrez = -1;
if (kod_Sredn == 0) return null;
string query_select = "SELECT ras_vlazn_p_0 ,ras_vlazn_p_1,ras_vlazn_p_2,ras_vlazn_p_3,ras_vlazn_p_4,ras_vlazn_p_5,ras_vlazn_p_6,ras_vlazn_p_7,ras_vlazn_p_8,ras_vlazn_p_9"
+ ",ras_vlazn_p_10,zap_vlagi_0,zap_vlagi_1,zap_vlagi_2,zap_vlagi_3,zap_vlagi_4,zap_vlagi_5 ,zap_vlagi_6 ,zap_vlagi_7 ,zap_vlagi_8 ,zap_vlagi_9 ,zap_vlagi_10"
+ ",zap_vl_narast_itog_0 ,zap_vl_narast_itog_1 ,zap_vl_narast_itog_2 ,zap_vl_narast_itog_3 ,zap_vl_narast_itog_4 ,zap_vl_narast_itog_5 ,zap_vl_narast_itog_6"
+ ",zap_vl_narast_itog_7 ,zap_vl_narast_itog_8 ,zap_vl_narast_itog_9 ,zap_vl_narast_itog_10, Kod_Razrez FROM t_data_sredn WHERE kod_sredn=" + kod_Sredn;
SqlConnection myConnection = new SqlConnection(myConnectionString);
SqlCommand myCommand = new SqlCommand(query_select);
myCommand.Connection = myConnection;
myConnection.Open();
SqlDataReader reader = myCommand.ExecuteReader();
if (reader.Read())
{
AgroDataSredn[] AgroSred = new AgroDataSredn[11];
if (sloj0_5)
{
for (int i = 0; i < reader.FieldCount-1; i++)
{
if (i < 11)
{
AgroSred[i].stroka3 = ConvertStringToFloat(reader[i].ToString(), 1);
}
else if (i >= 11 && i < 22)
{
AgroSred[i - 11].stroka4 = ConvertStringToFloat(reader[i].ToString(), 1);
}
else if (i >= 22 && i < 33)
{
AgroSred[i - 22].stroka5 = ConvertStringToFloat(reader[i].ToString(), 1);
}
}
}
else
{
for (int i = 1; i < reader.FieldCount; i++)
{
if (i < 11)
{
AgroSred[i].stroka3 = ConvertStringToFloat(reader[i].ToString(), 1);
}
else if (i >= 12 && i < 22)
{
AgroSred[i - 11].stroka4 = ConvertStringToFloat(reader[i].ToString(), 1);
}
else if (i >= 23 && i < 33)
{
AgroSred[i - 22].stroka5 = ConvertStringToFloat(reader[i].ToString(), 1);
}
}
}
kod_razrez = Convert.ToInt32(reader["Kod_Razrez"]);
myCommand.Connection.Close();
return AgroSred;
}
else
return null;
}
