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