//查询所有河流站点信息
public void GetAllRiverStation()
{
var collection = mySession.CreateCriteria <Hydrologicalstation>()
.Add(Restrictions.Eq("Type", "河道站"))
.List <Hydrologicalstation>();
foreach (Hydrologicalstation station in collection)
{
RiverHydrologyRecord rhr = new RiverHydrologyRecord();
rhr.StationId = station.Uid;
rhr.StationName = station.Name;
rhr.StationLocation = station.Administrativeregion;
rhr.RiverName = station.River;
riverList.Add(rhr);
}
}
//获取数据到List中
public void FecthData()
{
var datas = mySession.Query <Hydrologicaldata>();
var stations = mySession.Query <Hydrologicalstation>();
var query = from d in datas
join s in stations
on d.Stationid equals s.Uid
select new
{
RecordId = d.Recordid,
StationId = d.Stationid,
StationName = s.Name,
StationLocation = s.Address,
RiverName = s.River,
Level = d.L,
Flow = d.Q,
Time = d.Time,
WarningLevel = d.Wl1,
SafetyLevel = d.Wl2,
Longitude = s.Longitude,
Latitude = s.Latitude
};
if (isSetDuration == true)
{
query = query.Where(d => d.Time <this.to && d.Time> this.from);
}
if (isSetStation == true)
{
if (stationList.Count > 0)
{
query = query.Where(s => stationList.Contains(s.StationId));
}
}
foreach (var data in query)
{
RiverHydrologyRecord record = new RiverHydrologyRecord();
record.RecordId = data.RecordId;
record.StationId = data.StationId;
record.StationName = data.StationName;
record.StationLocation = data.StationLocation;
record.RiverName = data.RiverName;
try
{
record.Level = double.Parse(data.Level);
}
catch (ArgumentNullException)
{
record.Level = 0.0;
}
try
{
record.Flow = double.Parse(data.Flow);
}
catch (ArgumentNullException)
{
record.Flow = 0.0;
}
record.Time = (DateTime)data.Time;
try
{
record.WarningLevel = double.Parse(data.WarningLevel);
}
catch (ArgumentNullException)
{
record.WarningLevel = 0.0;
}
try
{
record.SafetyLevel = double.Parse(data.SafetyLevel);
}
catch (ArgumentNullException)
{
record.SafetyLevel = 0.0;
}
try
{
record.Longitude = double.Parse(data.Longitude);
}
catch (ArgumentNullException)
{
record.Longitude = 0.0;
}
try
{
record.Latitude = double.Parse(data.Latitude);
}
catch (ArgumentNullException)
{
record.Latitude = 0.0;
}
riverList.Add(record);
}
}