public static List <RiverWarningRecord> GetRiverWarningInfo()
{
List <RiverWarningRecord> infoList = new List <RiverWarningRecord>();
List <RiverWarningRecord> rtnList = new List <RiverWarningRecord>();
HydrologicReader dbReader = new HydrologicReader();
HydrologicEntity entity = dbReader.RetrieveEntity(DateTime.Now.AddDays(-1), DateTime.Now, "河道站"); //获取最近1天河道站最新水情
foreach (var item in entity.Items)
{
if ((item.L - item.Wl1) > -0.5) //超过监测门限-0.5
{
RiverWarningRecord record = new RiverWarningRecord();
if (item.Basin != null)
{
int index = item.Basin.IndexOf("流域");
record.Basin = (index < 0) ? item.Basin : item.Basin.Remove(index);
}
else
{
record.Basin = item.Basin;
}
if (item.L > item.Wl1)
{
record.IsBeyond = true;
}
else
{
record.IsBeyond = false;
}
record.Level = item.L;
record.Name = item.Name;
record.OverWarningLevel = item.L - item.Wl1;
record.Province = GetProvinceByAdm(item.Administrativeregion); //从行政地址获得省名
record.River = item.River;
record.Stationid = item.Stationid;
record.Time = item.Time;
record.WarningLevel = item.Wl1;
int tr = dbReader.ComparedWithRecent(item, DateTime.Now.AddDays(-2), DateTime.Now); //最近2天内的最新趋势
if (tr > 0)
{
record.ComparedBefore = Trend.Rise;
}
else if (tr == 0)
{
record.ComparedBefore = Trend.Hold;
}
else
{
record.ComparedBefore = Trend.Fall;
}
if (!(double.IsNaN(record.WarningLevel) || record.WarningLevel <= 0))
{
infoList.Add(record);
}
}
}
var groupedList = from info in infoList
group info by info.Basin into g
select g;
/*infoList = new List<RiverWarningRecord>();
* foreach(var g in groupedList)
* {
* foreach(var x in g)
* {
* infoList.Add(x);
* }
* }*/
foreach (var group in groupedList)
{
foreach (var item in group)
{
rtnList.Add(item);
}
}
return(rtnList);
}
public static List <ReservoirWarningRecord> GetKeyReservoirWarningInfo()
{
List <ReservoirWarningRecord> infoList = new List <ReservoirWarningRecord>();
HydrologicReader dbReader = new HydrologicReader();
HydrologicEntity entity = dbReader.RetrieveEntity(DateTime.Now.AddDays(-1), DateTime.Now, "水库站"); //获取最近1天水库站最新水情
foreach (var item in entity.Items)
{
if ((item.L - item.Wl1) > -20 && item.Issign == true) //超过监测门限-20且为重点站
{
ReservoirWarningRecord record = new ReservoirWarningRecord();
if (item.Basin != null)
{
int index = item.Basin.IndexOf("流域");
record.Basin = (index < 0) ? item.Basin : item.Basin.Remove(index);
}
else
{
record.Basin = item.Basin;
}
if (item.L > item.Wl1)
{
record.IsBeyond = true;
}
else
{
record.IsBeyond = false;
}
record.Level = item.L;
record.Name = item.Name;
record.OverWarningLevel = item.L - item.Wl1;
record.Province = GetProvinceByAdm(item.Administrativeregion); //从行政地址获得省名
record.River = item.River;
record.Stationid = item.Stationid;
record.Time = item.Time;
record.WarningLevel = item.Wl1;
int tr = dbReader.ComparedWithRecent(item, DateTime.Now.AddDays(-2), DateTime.Now); //最近2天内的最新趋势
if (tr > 0)
{
record.ComparedBefore = Trend.Rise;
}
else if (tr == 0)
{
record.ComparedBefore = Trend.Hold;
}
else
{
record.ComparedBefore = Trend.Fall;
}
if (!(double.IsNaN(record.WarningLevel) || record.WarningLevel <= 0))
{
infoList.Add(record);
}
}
}
return(infoList);
}
