/// <summary> /// 在数据库中查询源强 /// </summary> /// <param name="speed">速度</param> /// <param name="type">车辆类型</param> /// <returns>铁路源强</returns> public double getSpurce(double speed, String type) { double source = 0; String sql = "select v" + speed + " from TRAINSOURCE where TRAINTYPE ='" + type + "'"; NoiseAnalysis.DataBase.Access access = new NoiseAnalysis.DataBase.Access(); OleDbConnection connection = access.getConn(); OleDbCommand command = new OleDbCommand(sql, connection); OleDbDataReader reader = command.ExecuteReader(); //执行command并得到相应的DataReader while (reader.Read()) { source = Convert.ToDouble(reader["v" + speed]); } reader.Close(); access.Close(); return(source); }
/*! * 功能 空气效应衰减 * 参数 temperature 温度 * humidity 湿度 * frequency 频率 * 返回值 空气效应衰减值 * 版本号 1.0 * 作者 樊晓剑 * 创建时间 2016年7月14日 * 修改时间 */ private float getAirAttenuation(float temperature, float humidity, float frequency) { float source = 0; String sql = "select f" + frequency + " from 1/3ATM where T ='" + temperature + "',and HM=" + humidity + "'"; NoiseAnalysis.DataBase.Access access = new NoiseAnalysis.DataBase.Access(); OleDbConnection connection = access.getConn(); OleDbCommand command = new OleDbCommand(sql, connection); OleDbDataReader reader = command.ExecuteReader(); //执行command并得到相应的DataReader while (reader.Read()) { source = (float)(reader["v" + frequency]); } reader.Close(); access.Close(); return(source); }