public AgroStepUlv[] SelectRowFrom_Step_Ulv(int razrez, string myConnectionString) { AgroStepUlv[] step_uvl = new AgroStepUlv[7]; for (int i = 0; i < 7; i++) { step_uvl[i].ball = new float[4]; step_uvl[i].val_do = new float[4]; step_uvl[i].val_ot = new float[4]; } string query_sel = "SELECT * FROM t_Step_uvlachnen WHERE razrez=" + razrez.ToString(); SqlConnection myConnection = new SqlConnection(myConnectionString); SqlCommand myCommand = new SqlCommand(query_sel); myCommand.Connection = myConnection; myConnection.Open(); SqlDataReader reader = myCommand.ExecuteReader(); int ii=0; while (reader.Read()) { int jj = 0; step_uvl[ii].znachenie = Convert.ToInt32(reader["znachenie_uvl"]); for (int i = 3; i < 15; i = i + 3) { step_uvl[ii].val_ot[jj] = ConvertStringToFloat(reader[i].ToString(),1); step_uvl[ii].val_do[jj] = ConvertStringToFloat(reader[i+1].ToString(), 1); step_uvl[ii].ball[jj] = ConvertStringToFloat(reader[i+2].ToString(), 1); jj++; } ii++; } myCommand.Connection.Close(); return step_uvl; }
public void AddRowTo_Step_Ulv(AgroStepUlv[] Step_uvl, int razrez, string myConnectionString) { string query_del_from_uvl = "DELETE FROM t_Step_uvlachnen WHERE razrez=" + razrez.ToString(); ExecQuery(myConnectionString, query_del_from_uvl); for (int i = 0; i < 7; i++) { string query_add = "INSERT INTO t_Step_uvlachnen(razrez, znachenie_uvl, sloj10_val_ot, sloj10_val_do, sloj10_ball, " + "sloj20_val_ot, sloj20_val_do, sloj20_ball, " + "sloj50_val_ot, sloj50_val_do, sloj50_ball, " + "sloj100_val_ot, sloj100_val_do, sloj100_ball) VALUES("; query_add += razrez.ToString() + ","; query_add += Step_uvl[i].znachenie; for (int j = 0; j < 4; j++) { query_add += "," + ConvertFloatToString(Step_uvl[i].val_ot[j]) + "," + ConvertFloatToString(Step_uvl[i].val_do[j]) + "," + ConvertFloatToString(Step_uvl[i].ball[j]); } query_add += ")"; ExecQuery(myConnectionString, query_add); } }