public static List <RiverWarningRecord> LakeGetByWarningList() { List <WarningData> listWarning = new List <WarningData>(); listWarning.Add(new WarningData { Uid = "61512000", Time = DateTime.Now, L = 0, WL1 = 0 }); //61512000 城陵矶(七里山) 洞庭湖湖口 listWarning.Add(new WarningData { Uid = "62601600", Time = DateTime.Now, L = 0, WL1 = 0 }); //62601600 湖口 湖口水道 listWarning.Add(new WarningData { Uid = "63201999", Time = DateTime.Now, L = 0, WL1 = 0 }); //63201999 太湖水位 太湖 List <RiverWarningRecord> listRecord = new List <RiverWarningRecord>(); HydrologicReader dbReader = new HydrologicReader(); foreach (WarningData warning in listWarning) { RiverWarningRecord record = new RiverWarningRecord(); bool isBeyond = false; double OverWarningLevel = 0; HydrologicEntityItem item = new HydrologicEntityItem(); int t = dbReader.GetLastWarningData(DateTime.Now.AddDays(-2), DateTime.Now, warning.Uid, out item, out isBeyond, out OverWarningLevel); if (item.Basin != null || !item.Basin.Contains("其他")) { int index = item.Basin.IndexOf("流域"); record.Basin = (index < 0) ? item.Basin : item.Basin.Remove(index); } else { record.Basin = item.Basin; } record.IsBeyond = isBeyond; record.Level = item.L; record.Name = item.Name; record.OverWarningLevel = OverWarningLevel; record.Province = GetProvinceByAdm(item.Administrativeregion); //从行政地址获得省名 record.River = item.River; record.Time = item.Time; record.WarningLevel = item.Wl1; if (t > 0) { record.ComparedBefore = Trend.Rise; } else if (t == 0) { record.ComparedBefore = Trend.Hold; } else { record.ComparedBefore = Trend.Fall; } listRecord.Add(record); } return(listRecord); }
public static List <ReservoirWarningRecord> ResGetByWarningList(List <WarningData> listWarning) { List <ReservoirWarningRecord> listRecord = new List <ReservoirWarningRecord>(); List <ReservoirWarningRecord> listRtnRecord = new List <ReservoirWarningRecord>(); HydrologicReader dbReader = new HydrologicReader(); foreach (WarningData warning in listWarning) { ReservoirWarningRecord record = new ReservoirWarningRecord(); bool isBeyond = false; double OverWarningLevel = 0; HydrologicEntityItem item = new HydrologicEntityItem(); int t = dbReader.GetLastWarningData(DateTime.Now.AddDays(-2), DateTime.Now, warning.Uid, out item, out isBeyond, out OverWarningLevel); if (item.Basin != null || !item.Basin.Contains("其他")) { int index = item.Basin.IndexOf("流域"); record.Basin = (index < 0) ? item.Basin : item.Basin.Remove(index); } else { record.Basin = item.Basin; } record.IsBeyond = isBeyond; record.Level = item.L; record.Name = item.Name; record.OverWarningLevel = OverWarningLevel; record.Province = GetProvinceByAdm(item.Administrativeregion); //从行政地址获得省名 record.River = item.River; record.Time = item.Time; record.WarningLevel = item.Wl1; if (t > 0) { record.ComparedBefore = Trend.Rise; } else if (t == 0) { record.ComparedBefore = Trend.Hold; } else { record.ComparedBefore = Trend.Fall; } if (!(double.IsNaN(record.WarningLevel) || record.WarningLevel <= 0)) { listRecord.Add(record); } } var groupedList = from info in listRecord group info by info.Basin into g select g; foreach (var group in groupedList) { List <ReservoirWarningRecord> toSortList = new List <ReservoirWarningRecord>(); foreach (var item in group) { toSortList.Add(item); } toSortList.Sort(delegate(ReservoirWarningRecord a, ReservoirWarningRecord b) { return(b.OverWarningLevel.CompareTo(a.OverWarningLevel)); }); listRtnRecord.AddRange(toSortList); } return(listRtnRecord); }