public IEnumerable<AQIDataPublishLive> getCityStationAir(int cityid)
{
IEnumerable<AQIDataPublishLive> r = new AQIDataPublishLive[0];
MyContext db = new MyContext();
var q = db.Cities.Where(c => c.CityCode == cityid).FirstOrDefault();
if (null != q)
{
string cityname = q.CityName;
r = db.AQIDataPublishLives.Where(a => a.Area.Equals(cityname)).ToArray();
}
db.Dispose();
return r;
}
public IEnumerable <AQIDataPublishLive> getCityStationAir(int cityid)
{
IEnumerable <AQIDataPublishLive> r = new AQIDataPublishLive[0];
MyContext db = new MyContext();
var q = db.Cities.Where(c => c.CityCode == cityid).FirstOrDefault();
if (null != q)
{
string cityname = q.CityName;
r = db.AQIDataPublishLives.Where(a => a.Area.Equals(cityname)).ToArray();
}
db.Dispose();
return(r);
}
private static void showStationLive(AQIDataPublishLive cl)
{
var msg = String.Format("{0,10}|{1,5}|{2,8}|{3,14}|{4,12:g}", cl.Area + "-" + cl.PositionName, cl.AQI, cl.Quality, cl.PrimaryPollutant, cl.TimePoint);
Console.WriteLine(msg);
}
public static void ToAirDayData(AQIDataPublishLive source, AirDayData target)
{
target.Code = source.StationCode;
target.Name = source.PositionName;
target.Time = source.TimePoint;
try
{
if (source.SO2_24h != ConfigHelper.EmptyValueString)
{
target.SO2 = decimal.Parse(source.SO2_24h);
}
if (source.NO2_24h != ConfigHelper.EmptyValueString)
{
target.NO2 = decimal.Parse(source.NO2_24h);
}
if (source.PM10_24h != ConfigHelper.EmptyValueString)
{
target.PM10 = decimal.Parse(source.PM10_24h);
}
if (source.CO_24h != ConfigHelper.EmptyValueString)
{
target.CO = decimal.Parse(source.CO_24h);
}
if (source.O3_8h != ConfigHelper.EmptyValueString)
{
target.O38H = decimal.Parse(source.O3_8h);
}
if (source.PM2_5_24h != ConfigHelper.EmptyValueString)
{
target.PM25 = decimal.Parse(source.PM2_5_24h);
}
}
catch (Exception e)
{
LogHelper.Logger.Error("AQIDataPublishLive To AirDayData", e);
}
}
public static AirDayData ToAirDayData(AQIDataPublishLive src)
{
AirDayData data = new AirDayData();
ToAirDayData(src, data);
return data;
}
